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
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
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)
- Don Williams received a memo requesting that he complete a trend analysis of the following numbers using 2021 as the base year. Sales Gross profit Net income 2024 $ 390,000 210,000 41,100 Could you help Don with the request? 2024 Sales Gross profit Net income % % % 2023 $ 462,000 285,000 53,100 2023 % % % 2022 2022 $ 486,000 410,000 23,100 % % % 2021 2021 $ 600,000 500,000 30,000 100 % 100 % 100 %arrow_forwardPrepare calculations for each financial indicator (budget and actual) that is indicated as being missing from Exhibit 2, together with other relevant financial performance measures.arrow_forwardMVV has the following data on its 2020 financial statement Total sales 2,000,000 Profit 360,000 Beginning total sales Ending total sales 1,500,000 2,100,000 What is the Return on Investment (ROI) of the MVV?arrow_forward
- Using ROI and RI to evaluate investment centers This problem continues the Piedmont Computer Company situation from Chapter 23. Piedmont Computer Company reported 2020 sales of $3,500,000 and Operating income of $183,600. Average total assets during 2020 were $600,000. Piedmont Computer Company’s target rate of return is 16%. Calculate Piedmont Computer Company’s profit margin ratio, asset turnover ratio, ROI, and RI for 2020. Comment on the results.arrow_forwardUSING JOHNSON AND JOHNSON AS THE COMPANY..... Create the sales growth forecast based on the past 5-10 years, which should use multiple methods, such as arithmetic, geometric, regression methods. Excel forms should be used so that it's clear for everyone to see the work." Johnson & Johnson Annual Revenue(Millions of US $) 2023 $85,159 2022 $79,990 2021 $78,740 2020 $82,584 2019 $82,059 2018 $81,581 2017 $76,450 2016 $71,890 2015 $70,074 2014 $74,331 2013 $71,312 2012 $67,224arrow_forwardSuppose a firm has had the following historic sales figures. What would be the forecast for next year's sales using the average approach? You must use the built-in Excel function to answer this question. Input area: Year Sales 2016 2017 2018 es es e $ 1,500,000 $ 1,750,000 $ 1,400,000 2019 $ 2,000,000 2020 $ 1,600,000 Output area: Next year's salesarrow_forward
- Please explain without excelarrow_forwardUsing ROI and RI to evaluate investment centers Consider the following condensed financial statements of Secure Life, Inc. The company's target rate of return is 12%. SECURE LIFE, INC. Comparative Balance Sheet As of December 31, 2021, and 2020 2021 2020 Assets Cash $ 82,000 $ 50,000 Accounts Receivable 54,000 20,500 Supplies 1,000 500 Property, Plant, and Equipment, net 275,000 180,000 Patents, net 138,000 99,000 Total Assets $ 550,000 $ 350,000 Liabilities and Stockholders' Equity Accounts Payable $ 40,000 $ 32,000 Short-term Notes Payable 135,000 45,000 Long-term Notes Payable 170,000 125,000 Common Stock, no Par 150,000 130,000 Retained Earnings 55,000 18,000 Total Liabilities and Stockholders' Equity $ 550,000 $ 350,000arrow_forwardBegin with the partial model in the file Ch02 P21 Build a Model.xlsx on the textbooks Web site. a. Using the financial statements shown here for Lan Chen Technologies, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for 2020. The federal-plus-state tax rate is 25%. b. Assume there were 15 million shares outstanding at the end of 2019, the year-end closing stock price was 65 per share, and the after-tax cost of capital was 10%. Calculate EVA and MVA for 2020. Lan Chen Technologies: Income Statements for Year Ending December 31 (Millions of Dollars) Lan Chen Technologies: December 31 Balance Sheets (Thousands of Dollars)arrow_forward
- AFN equation Broussard Skateboard's sales are expected to increase by 25% from $7.4 million in 2019 to $9.25 million in 2020. Its assets totaled $2 million at the end of 2019. Broussard is already at full capacity, so its assets must grow at the same rate as projected sales. At the end of 2019, current liabilities were $1.4 million, consisting of $450,000 of accounts payable, $500,000 of notes payable, and $450,000 of accruals. The after-tax profit margin is forecasted to be 6%, and the forecasted payout ratio is 60%. Use the AFN equation to forecast Broussard's additional funds needed for the coming year. Enter your answer in dollars. For example, an answer of $1.2 million should be entered as $1,200,000. Do not round intermediate calculations. Round your answer to the nearest dollar. $arrow_forwardYou are asked to complete a financial projection for a hardware company using straight line method complete the form and compute the yearly projected sales and revenue using the following assumptions Here are some assumptions to consider: -income the company is projecting cells to increase 8% each year -interest income remain at 1200 every yeararrow_forwardProblem 3 bod di due ull PRINCESS Processing Company has two products. The actual sales data for the past two years are as follows: oghud nommon zabivorq sogbed T nomexingmo 2019 2020 1 25,000 P40.00 27,000 42.00 2130,000 33,000 singhaud A bew serval pinnal PRINCESS expects that the percentage of increase in sales volume in 2020 against the 2019 performance will remain in 2021. However, the business predicts that the selling price in 2020 will be the same the following year. und si sillo soment o svolge ar to noraqiteq adTe here haver Product ABasis Product CD Units Unit price Units Unit Price nosoboqarltose cortad Required: Prepare the sales budget in 2021. 115 no P60.00 63.00 1990 tdi 15ybod A luore no bound bound Joghud bolaarrow_forward