Question

I am unsure of what is unclear. The instructions are: 1. Set up a worksheet for...

I am unsure of what is unclear. The instructions are:

1. Set up a worksheet for the solvency ratios--current ratio and the quick ratio.

2. Compute these ratios for Doctors Smith and Brown. To do so, you will need one additional piece of information that is not present on the doctors’ statements: their maximum annual debt service is $22,200.

Practice Exercise 11–II: Solvency Ratios

Refer to Doctors Smith and Brown’s financial statements presented in the preceding Chapter 10.

Required

1. Set up a worksheet for the solvency ratios .  current ratio and the quick ratio.

2. Compute these ratios for Doctors Smith and Brown. To do so, you will need one additional piece of information that is not present on the doctors’ statements: their maximum annual debt service is $22,200.

The requested information is below:

Exhibit 10-1 Westside Clinic Balance Sheet

Assets

December 31, 20x2

December 31, 20x1

Current Assets

    Cash and cash equivalents

$190,000

$145,000

    Accounts receivable (net)

250,000

300,000

    Inventories

25,000

20,000

    Prepaid Insurance

   5,000

   3,000

    Total Current Assets

$470,000

$468,000

Property, Plant, and Equipment

    Land

$100,000

$100,000

    Buildings (net)

0

0

    Equipment (net)

260,000

300,000

    Net Property, Plant, and Equipment

360,000

400,000

Other Assets

    Investments

$133,000

$32,000

    Total Other Assets

133,000

  32,000

Total Assets

$963,000

$900,000

Liabilities and Fund Balance

Current Liabilities

    Current maturities of long-term debt

$52,000

$48,000

    Accounts payable and accrued expenses

293,000

302,000

    Total Current Liabilities

$345,000

$350,000

Long-Term Debt

$252,000

$300,000

Less Current Maturities of Long-Term Debt

?52,000

?48,000

Net Long-Term Debt

200,000

252,000

Total Liabilities

$545,000

$602,000

Fund Balances

    Unrestricted fund balance

$418,000

$298,000

    Restricted fund balance

      0

      0

    Total Fund Balances

418,000

298,000

Total Liabilities

$963,000

$900,000

Exhibit 10-2 sets out the result of operations for two years, with the most current period in the left column. If the balance sheet is a snapshot, then the statement of revenue and expenses is a diary because it is a record of transactions over the period of a year. Operating revenues and operating expenses are set out first, with the result being income from operations of $115,000 ($2,000,000 less $1,885,000). Then other transactions are reported; in this case, interest income of $5,000 under the heading “Nonoperating Gains (Losses).” The total of $120,000 ($115,000 plus $5,000) is reported as an increase in fund balance. This figure carries forward to the next major report, known as the statement of changes in fund balance.

STATEMENT OF CHANGES IN FUND BALANCE/NET WORTH

Remember that our formula for a basic statement of revenue and expense looked like this:

Operating Revenue — Operating Expenses = Operating Income

Exhibit 10-2 Westside Clinic Statement of Revenue and Expenses

For the Year Ending

Revenue

December 31, 20x2

December 31, 20x1

Net patient service revenue

$2,000,000

$1,850,000

    Total operating revenue

$2,000,000

$1,850,000

Operating Expenses

    Medical/surgical services

$600,000

$575,000

    Therapy services

860,000

806,000

    Other professional services

80,000

75,000

    Support services

220,000

220,000

    General services

65,000

60,000

    Depreciation

40,000

40,000

    Interest

  20,000

  24,000

    Total operating expenses

1,885,000

1,800,000

Income from Operations

$115,000

$50,000

Nonoperating Gains (Losses)

    Interest Income

  $5,000

  $2,000

    Net nonoperating gains

    5,000

    2,000

Revenue and Gains in Excess of

    Expenses and Losses

$120,000

$52,000

Increase in Unrestricted Fund Balance

$120,000

$52,000

The excess of revenue over expenses flows back into equity or fund balance through the mechanism of the statement of fund balance/net worth. Exhibit 10-3 shows a balance at the first of the year; then it adds the excess of revenue over expenses (in the amount of $115,000) plus some interest income (in the amount of $5,000) to arrive at the balance at the end of the year.

If you refer back to the balance sheet, you will see the $418,000 balance at the end of the year appearing on it. So we can think of the balance sheet, the statement of revenue and expenses, and the statement of changes in fund balance/net worth as locked together, with the statement of changes in fund balance being the mechanism that links the other two statements.

But there is one more major report—the statement of cash flows—and we will examine it next.

STATEMENT OF CASH FLOWS

To perceive why a statement of cash flows is necessary, we must first revisit the concept of accrual basis accounting. If cash is not paid or received when revenues and expenses are entered on the books—the usual situation in accrual accounting—what happens? The other side of the entry for revenues is accounts receivable, and the other side of the entry for expenses is accounts payable. These accounts rest on the balance sheet and have not yet been turned into cash. Another characteristic of accrual accounting is the recognition of depreciation. A capital asset—a piece of equipment, for example—is purchased for $20,000. It has a usable life of five years. So depreciation expense is recognized in each of the five years until the $20,000 is used up, or depreciated. (Land is an exception to this rule: it is never depreciated.) Depreciation is recognized within each year as an expense, but it does not represent a cash expense. This is a concept that now enters into the statement of cash flows.

Exhibit 10-4 presents the current period cash flow. In effect, this statement takes the accrual basis statements and converts them to a cash flow for the period through a series of reconciling adjustments that account for the noncash amounts.

Understanding the cash/noncash concept makes sense of this statement. The starting point is the income from operations, the subtotal from the statement of revenue and expense. Depreciation and interest are added back, and changes in asset and liability ac-counts, both positive and negative, are recognized. These adjustments account for operating activities. Next, capital and related financing activities are addressed; then investing activities are adjusted. The result is a net increase in cash and cash equivalents of $45,000 in our example. This figure is added to the cash balance at the beginning of the year ($145,000) to arrive at the cash balance at the end of the year ($190,000). Now refer back to the balance sheet, and you will find the cash balance is indeed $190,000. So the fourth major report—the statement of cash flows—interlocks with the other three major reports.

Exhibit 10-3 Westside Clinic Statement of Changes in Fund Balance

For the Year Ending

Statement of Changes in Fund Balance

December 31, 20x2

December 31, 20x1

Balance First of Year

$298,000

$246,000

Revenue in Excess of Expenses

115,000

50,000

Interest Income

   5,000

   2,000

Balance End of Year

$418,000

$298,000

Exhibit 10-4 Westside Clinic Statement of Cash Flows

Statement of Cash Flows

For the Year Ending

December 31, 20x2

December 31, 20x1

Operating Activities

Income from operations

$115,000

$50,000

Adjustments to reconcile income from

   operations to net cash flows from

   operating activities

     Depreciation and amortization

40,000

40,000

     Interest expense

20,000

24,000

     Changes in asset and liability accounts

       Patient accounts receivable

50,000

–250,000

       Inventories

–5,000

–5,000

       Prepaid expenses and other assets

–2,000

–1,000

       Accounts payable and accrued expenses

  –9,000

  185,000

Net cash flow from operating activities

$209,000

$43,000

Cash Flows from Noncapital Financing Activities

0

0

Cash Flows from Capital and Related Financing Activities Acquisition of equipment

$    0

$(300,000)

Proceeds from loan for equipment

0

300,000

Interest paid on long-term obligations

–20,000

0

Repayment of long-term obligations

–48,000

       0

Net cash flows from capital and related financing activities

–68,000

0

Cash Flows from Investing Activities

Interest income received

$5,000

$2,000

Investments purchased (net)

  – 101,000

         0

Net cash flows from investing activities

  –96,000

  2,000

Net Increase (Decrease) in Cash and Cash Equivalents

  $45,000

  $45,000

Cash and Cash Equivalents, Beginning of Year

145,000

100,000

Cash and Cash Equivalents, End of Year

  $190,000

  $145,000

Homework Answers

Answer #1
SOLVENCY RATIOS:
Current Ratio Current asset/Current Liabilities
Quick Ratio Quick Asset(Current asset -Inventory)/Current Liabilities
Deby to Equity Ratio Total Liabilities/Total Equity
Interest Coverage Ratio Earning before interest and taxes/Debt Service payment
A Current assets $470,000
B Quick Assets $440,000 (470000-25000-50000)
C Current liabilities $345,000
D Total Liabilities $545,000
E Total Equity $418,000
F Earning Before Interest and Taxes(EBIT) $135,000 (115000+20000)
G Debt service payments $22,200
A/C Current Ratio 1.362319
B/C Quick Ratio 1.275362
D/E Deby to Equity Ratio 1.303828
F/G Interest Coverage Ratio 6.081081
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Issued $26,000 of common stock for cash. Provided $95,600 of services on account. Provided $52,000 of...
Issued $26,000 of common stock for cash. Provided $95,600 of services on account. Provided $52,000 of services and received cash. Collected $85,000 cash from accounts receivable. Paid $54,000 of salaries expense for the year. Adjusted the accounting records to reflect uncollectible accounts expense for the year. Leach estimates that 4 percent of the ending accounts receivable balance will be uncollectible. Closed the revenue account. Closed the expense account. Year 2: Wrote off an uncollectible account for $750. Provided $104,000 of...
New Vision Company completed its income statement and balance sheet and provided the following information: Service...
New Vision Company completed its income statement and balance sheet and provided the following information: Service Revenue $ 66,000 Expenses: Salaries and Wages $ 42,000 Depreciation 7,300 Utilities 6,000 Office 1,700 57,000 Net Income $ 9,000 Decrease in Accounts Receivable $ 12,000 Paid cash for equipment 5,000 Increase in Salaries and Wages Payable 9,000 Decrease in Accounts Payable 4,250 Present the operating activities section of the statement of cash flows for New Vision Company using the indirect method. (Amounts to...
Exercise 12-4 Indirect: Cash flows from operating activities LO P2 The following income statement and information...
Exercise 12-4 Indirect: Cash flows from operating activities LO P2 The following income statement and information about changes in noncash current assets and current liabilities are reported. SONAD COMPANY Income Statement For Year Ended December 31, 2017 Sales $ 1,828,000 Cost of goods sold 991,000 Gross profit 837,000 Operating expenses Salaries expense $ 245,535 Depreciation expense 44,200 Rent expense 49,600 Amortization expenses–Patents 4,200 Utilities expense 18,125 361,660 475,340 Gain on sale of equipment 6,200 Net income $ 481,540 Changes in...
The following information applies to the questions displayed below.] Lansing Company’s current-year income statement and selected...
The following information applies to the questions displayed below.] Lansing Company’s current-year income statement and selected balance sheet data at December 31 of the current and prior years follow. LANSING COMPANY Income Statement For Current Year Ended December 31 Sales revenue $ 118,200 Expenses Cost of goods sold 49,000 Depreciation expense 15,500 Salaries expense 25,000 Rent expense 9,700 Insurance expense 4,500 Interest expense 4,300 Utilities expense 3,500 Net income $ 6,700    LANSING COMPANY Selected Balance Sheet Accounts At December...
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities)...
Lansing Company’s 2017 income statement and selected balance sheet data (for current assets and current liabilities) at December 31, 2016 and 2017, follow. LANSING COMPANY Income Statement For Year Ended December 31, 2017 Sales revenue $142,200 Expenses Cost of goods sold 57,000 Depreciation expense 19,500 Salaries expense 33,000 Rent expense 10,500 Insurance expense 5,300 Interest expense 5,100 Utilities expense 4,300 Net income $7,500    LANSING COMPANY Selected Balance Sheet Accounts At December 31 2017 2016 Accounts receivable $7,100 $8,800 Inventory...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the current year was $244,900. Depreciation recorded on equipment and a building amounted to $73,200 for the year. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $64,900 $68,790 Accounts receivable (net) 82,290 84,890 Inventories 162,250 146,250 Prepaid expenses 9,020 9,700 Accounts payable (merchandise creditors) 72,490 76,770...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the current year was $135,500. Depreciation recorded on store equipment for the year amounted to $22,400. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $54,060 $49,190 Accounts receivable (net) 38,760 36,350 Merchandise inventory 52,920 55,340 Prepaid expenses 5,950 4,670 Accounts payable (merchandise creditors) 50,650 46,530 Wages...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the...
Cash Flows from Operating Activities—Indirect Method The net income reported on the income statement for the current year was $120,600. Depreciation recorded on store equipment for the year amounted to $19,900. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $49,330 $44,890 Accounts receivable (net) 35,370 33,170 Inventories 48,290 50,500 Prepaid expenses 5,430 4,260 Accounts payable (merchandise creditors) 46,220 42,470 Wages payable...
The following income statement and additional year-end information is provided. SONAD COMPANY Income Statement For Year...
The following income statement and additional year-end information is provided. SONAD COMPANY Income Statement For Year Ended December 31 Sales $ 2,465,000 Cost of goods sold 1,207,850 Gross profit 1,257,150 Operating expenses Salaries expense $ 337,705 Depreciation expense 59,160 Rent expense 66,555 Amortization expenses—Patents 7,395 Utilities expense 27,115 497,930 759,220 Gain on sale of equipment 9,860 Net income $ 769,080 Accounts receivable $ 22,550 increase Accounts payable $ 12,275 decrease Inventory 29,750 increase Salaries payable 2,200 decrease Prepare the operating...
Cemptex Corporation prepares its statement of cash flows using the indirect method to report operating activities....
Cemptex Corporation prepares its statement of cash flows using the indirect method to report operating activities. Net income for the 2018 fiscal year was $659,000. Depreciation and amortization expense of $94,000 was included with operating expenses in the income statement. The following information describes the changes in current assets and liabilities other than cash: Decrease in accounts receivable $ 29,000 Increase in inventories 9,900 Increase prepaid expenses 9,200 Increase in salaries payable 10,700 Decrease in income taxes payable 18,000 Required:...