Learning Goal 5
P4-17 Pro forma income statement: Scenario analysis Allen Products Inc. wants to do a scenario analysis for the coming year. The pessimistic prediction for sales is $900,000; the most likely amount of sales is $1,125,000; and the optimistic prediction is $1,280,000. Allen’s income statement for the most recent year follows.
Allen Products Inc. Income Statement for the Year Ended December 31, 2019
Sales revenue | $937,500 |
Less: Cost of goods sold | 421,875 |
Gross profits | $515,625 |
Less: Operating expenses | 234,375 |
Operating profits | $281,250 |
Less: Interest expense | 30,000 |
Net profits before taxes | $251,250 |
Less: Taxes (rate = 25%) | 62, 813 |
Net profits after taxes | $188,437 |
- a. Use the percent-of-sales method, the income statement for December 31, 2019, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year.
- b. Explain how the percent-of-sales method could result in an overstatement of profits for the pessimistic case and an understatement of profits for the most likely and optimistic cases.
- c. Restate the pro forma income statements prepared in part a to incorporate the following assumptions about the 2019 costs:
$250,000 of the cost of goods sold is fixed; the rest is variable.
$180,000 of the operating expenses is fixed; the rest is variable.
All the interest expense is fixed.
- d. Compare your findings in part c to your findings in part a. Do your observations confirm your explanation in part b?
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Principles of Managerial Finance Plus MyLab Finance with Pearson eText -- Access Card Package (15th Edition)
Additional Business Textbook Solutions
Foundations of Finance (9th Edition) (Pearson Series in Finance)
Principles of Managerial Finance (14th Edition) (Pearson Series in Finance)
Corporate Finance (4th Edition) (Pearson Series in Finance) - Standalone book
Corporate Finance
Foundations Of Finance
Horngren's Accounting (12th Edition)
- (Learning Objective 7: Calculate return on assets) Hometown Supply Companyreported the following information in its comparative financial statements for the fiscal yearended January 31, 2018:January 31,2018January 31,2017Net sales....................................Net earnings..............................Average total assets...................$84,000$ 4,200$70,000$82,600$ 4,050$69,450Requirements1. Compute the net profit margin ratio for the years ended January 31, 2018, and 2017. Did itimprove or worsen in 2018?2. Compute asset turnover for the years ended January 31, 2018, and 2017. Did it improve orworsen in 2018?3. Compute return on assets for the years ended January 31, 2018, and 2017. Did it improveor worsen in 2018? Which component—net profit margin ratio or asset turnover—wasmostly responsible for the change in the company’s return on assets?arrow_forward1. Using the data in the student spreadsheet file Ethan Allen Financials.xlsx forecast the 2019 income statement and balance sheet for Ethan Allen. Use the percent of sales method and the following assumptions: (1) sales in FY 2019 will be $797.3359; (2) the tax rate will be 35%; (3) each item that changes with sales will be the five-year average percentage of sales; (4) net fixed assets will increase to $300; and (5) the common dividend will be $0.75 per share. Use your judgment on all other items. a. What is the discretionary financing needed in 2019? Is this a surplus or deficit? b. Assume that the DFN will be absorbed by long-term debt and that the interest rate is 4% of LTD. Set up an iterative worksheet to eliminate it.arrow_forwardCJB's fiscal 2020 net income was $155.9 and cash flows from operating activities was $132.0 million What impact does this have on the evaluation of the 2020 earnings quality for CJB? Question 30 options: a) Weakens, due to sustainability issues b) Weakens due to substance issues c) Strengthens due to substance issues d) Strengthens, due to sustainability issuesarrow_forward