Allen Products​ LP, wants to do a scenario analysis for the coming year. The pessimistic prediction...

50.1K

Verified Solution

Question

Finance

Allen Products​ LP, wants to do a scenario analysis for thecoming year. The pessimistic prediction for sales is $ 900,000​;the most likely amount of sales is $ 1,118,000​; and the optimisticprediction is $ 1,288,000. ​Allen's income statement for the mostrecent year is shown here

Allen Products, Inc. Income Statement for
the Year Ended December 31, 2019  
Sales revenue   $937,400
Less: cost of good sold   436,828
Gross profits   $500,572
Less: operating expenses   245,599
Operating profits   $254,973
Less: interest expense   30,934
Net profit before taxes   $224,039
Less: taxes (rate 25%)   56,010
Net profits after taxes   $168,029

a. Use the ​percent-of-sales method, the income statement forDecember​ 31,2019​, and the sales revenue estimates to develop​pessimistic, most​ likely, and optimistic pro forma incomestatements for the coming year.

b. Explain how this method could result in overstatement ofprofits for the pessimistic case and understatement of profits forthe most likely and optimistic cases.

c. Restate the pro forma income statements prepared in part a.to incorporate the following assumptions about the costs:

$252,497 of the cost of goods sold is​ fixed; the rest isvariable. $193,516 of the operating expenses is​ fixed; the rest isvariable. 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​?

Use the ​percent-of-sales method, the income statement forDecember​ 31, 2019, and the sales revenue estimates to develop​pessimistic, most​ likely, and optimistic pro forma incomestatements for the coming year.

Complete the pro forma income statement for the year endingDecember​ 31, 2020 that is shown below​ (pessimistic scenario): ​(Round the percentage of sales to one decimal place and the proforma income statement accounts to the nearest​ dollar.)

Answer & Explanation Solved by verified expert
4.5 Ratings (931 Votes)
Part a Dec 31 2019 Pessimistic Most Likely Optimistic of sales Sales Revenue 937400 100 A Sales Revenue 900000 1118000 1288000 Less Cost of goods sold 436828 47 B 47A Less Cost of goods sold 419400 520988 600207 Gross Profits 500572 53 C AB Gross Profits 480600 597012 687793 Less Operating Expenses 245599 26 D26A Less Operating Expenses 235800 292916 337456 Operating profits 254973 27 ECD Operating profits 244800 304096 350336 Less Interest Expense 30934 3 F3A Less Interest Expense 29700 36894 42504 Net Profit before taxes 224039 24 GEF Net Profit    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students