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%

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

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...

Fill out the summary of T-Accounts for 1. Revenue and Expenses (Temporary Income Statement Accounts) ...

Fill out the summary of T-Accounts for 1. Revenue and Expenses (Temporary Income Statement Accounts) -Includes: Sales and Service Revenue, Costs of Goods sold, Wages Expense, Insurance Expense, Rent Expense, Depreciation Expense. 2. Assets (Permanent Balance Sheet Accounts) -Includes: Cash, Inventory, accounts receivable, prepaid insurance, equipment, accumulated depreciation, prepaid rent. 3. Liabilities and Equities (Permanent Balance Sheet Accounts) -Includes: Accounts payable, unearned revenue, wages payable, common stock, retained earnings 4. What are the total Assets? 5. What...

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 ...