Question

In: Finance

Common sizing for the MHS Statement of Revenue and Expenses appears on the worksheet below. Metropolis...

Common sizing for the MHS Statement of Revenue and Expenses appears on the worksheet below. Metropolis Health System
Statement of Revenue and Expenses
For the Years Ended March 31, 20X3 and 20X2

Find the Xs

    Year 2   Percent   Year 1   Percent

Revenue

Net patient service revenue   34,000,000   96.87%   33,600,000   97.11%

Other revenue   1,100,000   3.13%   1,000,000   2.89%

Total Operating Revenue   35,100,000   100.00%     XXX 100.00%

Expenses

Nursing services XXXX 14.32%   5,450,000   15.75%

Other professional services   13,100,000   37.32% XXXX 37.43%

    Year 2   Percent   Year 1   Percent

General services   3,200,000   9.12% XXXX 9.31%

Support services XXXXX 23.65%   8,340,000   24.10%

Depreciation   1,900,000   5.41%   1,800,000   5.20%

Amortization   50,000   0.14% XXXX   0.14%

Interest XXXX   0.93%   350,000   1.01%

Provision for doubtful
accounts   1,500,000   4.27% XXXX 4.62%

Total Expenses   33,400,000   95.16%   33,760,000   97.57%

Income from Operations XXXX   4.84%   840,000   2.43%

Nonoperating Gains (Losses)

Unrestricted gifts and
memorials   20,000   0.06% XXXX   0.20%

Interest income XXXX   0.23%   40,000   0.12%

Nonoperating Gains Net XXXX   0.28%   110,000   0.32%

Revenues and Gains in Excess of
Expenses and Losses   1,800,000 5.13% XXXX 2.75%

Solutions

Expert Solution

1. Total Operating Revenue for Year 1 = 33,600,000 + 1,000,000 = 34,600,000

2. Nursing services for Year 2 = Total Operating Revenue for Year 2 * 14.32 % = 35,100,000*14.32% = 5,026,320

3. Other professional services for Year 1 =  Total Operating Revenue for Year 1* 37.43% = 34,600,000* 37.43% = 12,950,780

4. General services  for Year 1 =  Total Operating Revenue for Year 1 * 9.31% = 34,600,000*9.31% = 3,221,260

5. Support services for Year 2 =  Total Operating Revenue for Year 2 * 23.65% = 35,100,000* 23.65% = 8,301,150

6. Amortization for Year 1 =  Total Operating Revenue for Year 1 * 0.14%= 48,440

7. Interest for Year 2 = Total Operating Revenue for Year 2 * 0.93% = 35,100,000*0.93% = 326,430

8. Provision for doubtful for accounts for Year 1 = Total Operating Revenue for Year 1* 4.62% = 1,598,520

9.Income from Operations   for Year 2 = Total Operating Revenue for Year 2 * 4.84% = 35,100,000 * 4.84% = 1,698,840

10. Unrestricted gifts and memorials for Year 1 = Total Operating Revenue for Year 1* 0.20%= 34,600,000* 0.20% = 69,200

11. Interest income for Year 2 = Total Operating Revenue for Year 2 * 0.23% = 35,100,000 * 0.23%= 80,730

12. Nonoperating Gains Net for Year 2 = Total Operating Revenue for Year 2 *  0.28%= 35,100,000 * 0.28%= 98,280

13. Expenses and Losses for Year 1 = Total Operating Revenue for Year 1* 2.75% = 34,600,000 * 2.75% = 951,500

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Trend analysis for the MHS Statement of Revenue and Expenses appears on the worksheet below. Metropolis...
Trend analysis for the MHS Statement of Revenue and Expenses appears on the worksheet below. Metropolis Health System Statement of Revenue and Expenses For the Years Ended March 31, 20X4 and 20X3 find the X’s Year 2   Year 1   Difference   Percent Revenue Net patient service revenue $34,000,000   $33,600,000   $400,000   1.19% Other revenue XXXX         1,000,000      100,000   10.00% Total Operating Revenue $35,100,000 XXXXX $500,000   1.45% Expenses Nursing services XXXXX     $5,450,000   ($425,000)   –7.80% Other professional services 13,100,000     XXXX   150,000   1.16% General services XXXX     3,220,000   (20,000)      –0.62% Support services   8,300,000     XXXX (40,000)   –0.48% Depreciation XXXXX      1,800,000   100,000   5.56% Amortization   50,000     XXXX 0   0.00% Interest   325,000      350,000   (25,000)   –7.14%...
Metropolis Health System Statement of Revenue and Expenses For the Years Ended March 31, 20X3 and...
Metropolis Health System Statement of Revenue and Expenses For the Years Ended March 31, 20X3 and 20X2 Revenue Net patient service revenue $34,000,00 $33,600,000 Other revenue 1,100,000 1,000,000 Total Operating Revenue 35,100,000 34,600,000 Expenses Nursing services 5,025,000 5,450,000 Other professional services 13,100,000 12,950,000 General services 3,200,000 3,220,000 Support services 8,300,000 8,340,000 Depreciation 1,900,00 1,800,00 Amortization 50,000 50,000 Interest 325,000 350,000 Provision for doubtful accounts 1,500,000 1,600,000 total Expenses 33,400,000 33,760,000 Income from Operations 1,700,000 840,000 Nonoperating Gains (Losses) Unrestricted gifts...
The July contribution format income statement of Doxtater Corporation appears below: Sales $ 564,400 Variable expenses...
The July contribution format income statement of Doxtater Corporation appears below: Sales $ 564,400 Variable expenses 312,800 Contribution margin 251,600 Fixed expenses 193,800 Net operating income $ 57,800 If the company's sales increase by 19%, its net operating income should increase by about:
Q4 You have performed the common sizing and horizontal analysis to the financial statement of X...
Q4 You have performed the common sizing and horizontal analysis to the financial statement of X co. You have selectively considered the current (Year 0) parameters as mentioned in the table below. Based on the value's, you have calculated the Year 1 ratios and growth rates Particulars Year 0 Year 1 Growth rate in Sales revunes (y-o-y) N/A 4% Gross Profit Margin 33% 34% SG& A expenses/ Saled revenue 25% 25% Depreciation Net PPEt-1 10% 10% Net working Capital Turnover...
The primary area of income statement creativity is the opportunistic classification of revenue, gains, expenses, and...
The primary area of income statement creativity is the opportunistic classification of revenue, gains, expenses, and losses. Although materiality is defined subjectively, one rule of thumb suggests that the misstatement or omission of an item that falls under a 5% of revenue threshold is not material in the absence of particularly egregious circumstances. Equally important is the appropriate classification of amounts within the statement of comprehensive income and the statement of financial position. The financial statement users have placed greater...
In 175 words or more give some common examples of accrued revenue and accrued expenses that...
In 175 words or more give some common examples of accrued revenue and accrued expenses that may occur in a business. Discuss why they arise, how they are recorded, and why it is necessary to record them.
An income statement for the first year of operations for Patti Company appears below: Sales $...
An income statement for the first year of operations for Patti Company appears below: Sales $ 390,000 Dividend revenue 39,000 Interest revenue 24,050 Cost of goods sold (208,000 ) Salary expense (26,000 ) Depreciation expense (70,200 ) Income tax expense (109,200 ) Net income $ 39,650 Additional information: Accounts payable, end of year, $13,000. Salaries payable, end of year, $8,450. Inventories, end of year, $26,000. Accounts receivable, end of year, $32,500. Required: Use the direct approach to calculate the cash...
On December 31, 2019, the Income Statement section of the worksheet is shown below. The balance...
On December 31, 2019, the Income Statement section of the worksheet is shown below. The balance of Ally Logan’s drawing account is $32,000. INCOME STATEMENT COLUMNS ACCOUNT NAME DEBIT CREDIT Income Summary $ 63,000 $ 69,000 Sales 250,000 Sales Returns and Allowances 6,100 Interest Income 760 Purchases 87,000 Freight In 3,900 Purchases Returns and Allowances 2,900 Purchases Discounts 3,500 Sales Salaries Expense 53,000 Office Salaries Expense 20,100 Office Supplies Expense 860 Utilities Expense 5,100 Payroll Taxes Expense 2,700 Uncollectible Accounts...
Presented below is the income statement of Cowan, Inc.:          Sales revenue                      &nbsp
Presented below is the income statement of Cowan, Inc.:          Sales revenue                                                                        $380,000          Cost of goods sold                                                                 225,000          Gross profit                                                                             $155,000          Operating expenses                                                                   95,000          Income before income taxes                                                      60,000          Income taxes                                                                              24,000          Net income                                                                             $ 36,000 In addition, the following information related to net changes in working capital is presented:                                                                                                               Debit                  Credit          Cash                                                                                         $12,000          Accounts receivable                                                                   25,000          Inventories                                                                                                              $19,400          Salaries payable (operating expenses)                                        8,000         ...
Presented below is the income statement of Cowan, Inc.:          Sales revenue                      &nbsp
Presented below is the income statement of Cowan, Inc.:          Sales revenue                                                                         $380,000          Cost of goods sold                                                                    225,000          Gross profit                                                                             $155,000          Operating expenses                                                                    95,000          Income before income taxes                                                      60,000          Income taxes                                                                              24,000          Net income                                                                             $ 36,000 In addition, the following information related to net changes in working capital is presented:                                                                                                               Debit                     Credit          Cash                                                                                          $12,000          Accounts receivable                                                                   25,000          Inventories                                                                                                              $19,400          Salaries payable (operating expenses)                                        8,000          Accounts payable                                                                                                     14,000         ...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT