Question

Complete the following Income Statement for 12/31/2019 with these assumptions which are in no particular order:...

Complete the following Income Statement for 12/31/2019 with these assumptions which are in no particular order:

HINT: Determine revenue as a starting point. If you cannot figure that out put in a number and finish based on rest of the assumptions as this will allow you to receive some points.

1. The company has an Operating Profit Margin of 30%

2. The company has an Account Receivable turnover of 10

3. The Contribution Rate for this company is 40%

4. They have an Interest Coverage ratio of 4

5. All sales for the company were on credit

6. They have a 30% tax rate

7. The account receivable balance as of 12/31/2019 was $7,000,000

Sales                                               

-Fixed Costs

- Variable Costs

EBIT

- Interest

Profit before Tax

- Tax

Net Income

Homework Answers

Answer #1
Steps Particulars Amont Workings Formulas
A Sales 70000000 7000000*10
B=A-C Variable cost 67200000 Sales - contribution
C Contribution 2800000 7000000*40% Salesx Contribution ratio
D=C-E Fixed Cost 700000
E EBIT 2100000 7000000*30% Operating margin = EBIT/Sales
F Interest 525000 2100000/4 EBIT/Interst coverage ratio
G=E-F PBT 1575000
H Tax 472500 1575000*30%
I=G-H PAT 1102500
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
Complete the following Income Statement for 12/31/2019 with these assumptions which are in no particular order:...
Complete the following Income Statement for 12/31/2019 with these assumptions which are in no particular order: The company has an Operating Profit Margin of 30% The company has an Account Receivable turnover of 12 The Contribution Rate for this company is 40% They have an Interest Coverage ratio of 5 All sales for the company were on credit They have a 30% tax rate The account receivable balance as of 12/31/2019 was $7,000,000
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...
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...
Below are the 2019 income statement and balance sheet of Happy water, Inc. Assuming the company's...
Below are the 2019 income statement and balance sheet of Happy water, Inc. Assuming the company's fixed assets are operating at 100% capacity and the company expect 20% growth in sales in 2020. If the tax rate and payout ratio in 2020 are the same as those in 2019, what is the external financing needs in 2020? Income Statement 2019 Sales 150 Costs 100 EBIT 50 Interest exp. 10 EBT 40 Tax 8 NI 32 Dividends 16 RE 16 Balance...
Below are the 2019 income statement and balance sheet of Happy water, Inc. Assuming the company's...
Below are the 2019 income statement and balance sheet of Happy water, Inc. Assuming the company's fixed assets are operating at 100% capacity and the company expect 20% growth in sales in 2020. If the tax rate and payout ratio in 2020 are the same as those in 2019, what is the external financing needs in 2020? Income Statement 2019 Sales 150 Costs 100 EBIT 50 Interest exp. 10 EBT 40 Tax 8 NI 32 Dividends 16 RE 16 Balance...
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...
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...
The financial statements for Wiley Ltd are presented below Statement of profit or loss and other...
The financial statements for Wiley Ltd are presented below Statement of profit or loss and other comprehensive income for Wiley Ltd for the year ending 30 June 2019 $ $ Sales (credit) 250 000 Cost of sales – Inventory—01 July 2018 (25 000) – Purchases (152 500) – Inventory—30 June 2019     27 500 (150 000) Gross profit 100 000 Selling and administrative expenses (20 000) Depreciation (40 000) Profit before tax 40 000 Income tax expense (20 per cent)...
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...
1) Berkshire LLC reported the following income statement and balance sheet amounts on December 31, 2011....
1) Berkshire LLC reported the following income statement and balance sheet amounts on December 31, 2011. 2011 2010 Net sales revenue (all credit) $950,000 Cost of goods sold 630,000 Gross profit 320,000 Selling and general expenses 230,000 Interest expense    20,000 Net income $70,000 Current assets $60,000 $55,000 Long-term assets    465,000    445,000 Total assets - 12/31 $525,000 $500,000 Current liabilities $25,000 $20,000 Long-term liabilities 105,000 205,000 Common stockholders’ equity - 12/31    395,000    275,000 Total liabilities and...