Question

22) Given the actual Income Statement for UMPI Inc. for 2019, the company anticipates sales growth...

22) Given the actual Income Statement for UMPI Inc. for 2019, the company anticipates sales growth of 3% in 2020 and 5% growth in sales for 2021. Prepare a pro forma income statement for 2020 & 2021. Note that depreciation & interest expense did not increase for 2020 & 2021. Also, the tax expense is calculated based on 30% of taxable income calculated on the pro forma income statement.

UMPI, Incorporated Income Statement

For the Period Ended December 31, 2019

Sales Revenue $280,000

COGS 140,000

SG&A 65,000

Depreciation 15,000

EBIT 60,000

Interest expense 10,000

Taxable Income 50,000

Tax rate 30%

Tax expense 15,000

Net Income $35,000

Homework Answers

Answer #1

Income statement for 2020 & 2021 is as follows:

UMPI, Incorporated Income Statement

For the Period Ended December 31, 2020 and 2021

2020($) 2021($)
Sale 288,400 294,000
($280,000*1.03) ($280,000*1.05)
Cost of goods sold 144,200 147,000
( $140,000*1.03) ($140,000*1.05)
SG&A 66,950 68,250
( $65,000*1.03) ($65,000*1.05)
Depreciation 15,000 15,000
EBIT 62,250 63,750
Interest expense 10,000 10,000
Taxable Income 52,250 53,750
Tax expense (30%) 15,675 16,125
Net Income $36.575 $37,625  
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
Your pro forma income statement shows sales of $975,000​, cost of goods sold as $503,000​, depreciation...
Your pro forma income statement shows sales of $975,000​, cost of goods sold as $503,000​, depreciation expense of $102,000​, and taxes of $148,000 due to a tax rate of 40 % What are your pro forma​ earnings? What is your pro forma free cash​ flow? Complete the pro forma income statement​ below:  ​(Round to the nearest​ dollar.) Sales $ Cost of Goods Sold $ Gross Profit $ Depreciation $ EBIT $ Taxes (40%) $ Earnings $
Your pro forma income statement shows sales of $956,000​, cost of goods sold as $496,000​, depreciation...
Your pro forma income statement shows sales of $956,000​, cost of goods sold as $496,000​, depreciation expense of $102,000​, and taxes of $143,200 due to a tax rate of 40%. What are your pro forma​ earnings? What is your pro forma free cash​ flow? Complete the pro forma income statement​ below:  ​(Round to the nearest​ dollar.) Sales $ Cost of Goods Sold $ Gross Profit $ Depreciation $ EBIT $ Taxes (40%) $ Earnings $ The pro forma free cash...
4.  Problem 16.04 (Pro Forma Income Statement) eBook Austin Grocers recently reported the following 2019 income statement...
4.  Problem 16.04 (Pro Forma Income Statement) eBook Austin Grocers recently reported the following 2019 income statement (in millions of dollars): Sales $700 Operating costs including depreciation 500 EBIT $200 Interest 40 EBT $160 Taxes (25%) 40 Net income $120 Dividends $40 Addition to retained earnings $80 For the coming year, the company is forecasting a 30% increase in sales, and it expects that its year-end operating costs, including depreciation, will equal 70% of sales. Austin's tax rate, interest expense, and...
Complete the 2019 income statement of the ABC Inc. using the information provided. Income Statement (in...
Complete the 2019 income statement of the ABC Inc. using the information provided. Income Statement (in thousands)   Year 2019 Revenues 2,450 COGS 1,950 Depreciation 75 EBIT   Interest 45 Taxable Income   Taxes (25%)   Net Income   Dividends (Payout Ratio= 35%)   Additions to Retained Earnings  
Garlington Technologies Inc.'s 2019 financial statements are shown below: Income Statement for December 31, 2019 Sales...
Garlington Technologies Inc.'s 2019 financial statements are shown below: Income Statement for December 31, 2019 Sales $4,000,000 Operating costs 3,200,000 EBIT $  800,000 Interest 120,000 Pre-tax earnings $  680,000 Taxes (25%) 170,000 Net income 510,000 Dividends $  190,000 Balance Sheet as of December 31, 2019 Cash $   160,000 Accounts payable $   360,000 Receivables 360,000 Line of credit 0 Inventories 720,000 Accruals 200,000 Total CA $1,240,000 Total CL $   560,000 Fixed assets 4,000,000 Long-term bonds 1,000,000 Total Assets $5,240,000 Common stock 1,100,000 RE 2,580,000 Total L&E $5,240,000...
For Year 2019 a firm had sales of $900,000, cost of goods sold of $685,000, depreciation...
For Year 2019 a firm had sales of $900,000, cost of goods sold of $685,000, depreciation expense of $35,000, interest expense of $15,000, and dividends paid of $18,800. At the beginning of the year, net fixed assets were $580,000, current assets were $300,000, and current liabilities were $140,000. At the end of the year, net fixed assets were $640,000, current assets were $400,000, and current liabilities were $200,000. The tax rate was 21%. Income Statement                                     6(a) What was the...
Summer Co. is preparing the reconciliation between accounting income and taxable income for 2019.   Actual warranty...
Summer Co. is preparing the reconciliation between accounting income and taxable income for 2019.   Actual warranty repairs made in 2019 and allowed to be deducted for tax purposes amounted to $40,000. Warranty expense recorded in 2019 was $30,000. For years before 2019, warranty expense recorded was $60,000 and total repairs made under warranty amounted to $10,000. CCA allowed for tax purposes in 2019 was $65,000; depreciation expense recorded in 2019 was $85,000. For years before 2019, depreciation expense exceeded CCA...
Financing Deficit Garlington Technologies Inc.'s 2019 financial statements are shown below: Income Statement for December 31,...
Financing Deficit Garlington Technologies Inc.'s 2019 financial statements are shown below: Income Statement for December 31, 2019 Sales $4,000,000 Operating costs 3,200,000 EBIT $  800,000 Interest 120,000 Pre-tax earnings $  680,000 Taxes (25%) 170,000 Net income 510,000 Dividends $  190,000 Balance Sheet as of December 31, 2019 Cash $   160,000 Accounts payable $   360,000 Receivables 360,000 Line of credit 0 Inventories 720,000 Accruals 200,000 Total CA $1,240,000 Total CL $   560,000 Fixed assets 4,000,000 Long-term bonds 1,000,000 Total Assets $5,240,000 Common stock 1,100,000 RE 2,580,000 Total...
EX. 1 ABC Company reports pretax financial income of $140,000 for 2019. The following items cause...
EX. 1 ABC Company reports pretax financial income of $140,000 for 2019. The following items cause taxable income to be different than pretax financial income. Depreciation on the tax return is greater than depreciation on the income statement by $30,000 (which will reverse in 4 years). Rent collected on the tax return is greater than rent earned on the income statement by $15,000 (which will reverse in 2019). Fines related to tax returns filed after the due date for filing,...
Your pro forma income statement shows sales of $ 976 comma 000?, cost of goods sold...
Your pro forma income statement shows sales of $ 976 comma 000?, cost of goods sold as $ 486 comma 000?, depreciation expense of $ 95 comma 000?, and taxes of $ 158 comma 000 due to a tax rate of 40 %. What are your pro forma? earnings? What is your pro forma free cash? flow?