Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

IIncome statement for this year: part c income statement: Pro forma income statement-Scenario analysis Allen Products, Inc., wants to do a scenario analysis for the

image text in transcribedIIncome statement for this year:image text in transcribed

part c income statement:image text in transcribed

image text in transcribed

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 $906,000; the most likely amount of sales is $1,128,000; and the optimistic prediction is $1,275,000. Allen's income statement for the most recent year is shown here : a. Use the percent-of-sales method, the income statement for December 31, 2015, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year. b. Explain how this method could result in overstatement of profits for the pessimistic case and 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 2015 costs: $244,515 of the cost of goods sold is fixed; the rest is variable. $168,644 of the operating expenses is fixed; the rest is variable. All the interest expense is fixed. (Please see: .) d. Compare your findings in part c. to your findings in part a. Do your observations confirm your explanation in part b? .) Allen Products, Inc. Income Statement for the Year Ended December 31, 2015 Sales revenue $937,100 Less: cost of good sold 417,947 Gross profits $519,153 Less: operating expenses 229,590 Operating profits $289,563 Less: interest expense 32,799 Net profit before taxes $256,764 Less: taxes (rate 30%) 77,029 Net profits after taxes $179,735 Allen Products, Inc. Income Statement for the Year Ended December 31, 2015 Sales revenue $937,100 Less: cost of good sold Fixed 244,515 Variable 173,432 Gross profits $519,153 Less: operating expenses Fixed 168,644 Variable 60,946 Operating profits $289,563 Less: interest expense 32,799 Net profit before taxes $256,764 Less: taxes (rate 30%) 77,029 Net profits after taxes $179,735 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 $906,000; the most likely amount of sales is $1,128,000; and the optimistic prediction is $1,275,000. Allen's income statement for the most recent year is shown here 3. a. Use the percent-of-sales method, the income statement for December 31, 2015, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming b. Explain how this method could result in overstatement of profits for the pessimistic case and 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 2015 costs: $244,515 of the cost of goods sold is fixed; the rest is variable. $168,644 of the opera expenses is fixed; the rest is variable. All the interest expense is fixed. (Please see: E .) d. Compare your findings in part c. to your findings in part a. Do your observations confirm your explanation in part b? a. Use the percent-of-sales method, the income statement for December 31, 2015, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming y Complete the pro forma income statement for the year ending December 31, 2016 that is shown below (pessimistic scenario): (Round the percentage of sales to one decimal place and the pro forma income state accounts to the nearest dollar.) Pro Forma Income Statement Allen Products, Inc. for the Year Ended December 31, 2016 Pessimistic Sales Less: Cost of goods sold Gross profits Less: Operating expense $ L Enter any number in the edit fields and then click Check Answer. 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 $906,000; the most likely amount of sales is $1,128,000; and the optimistic prediction is $1,275,000. Allen's income statement for the most recent year is shown here : a. Use the percent-of-sales method, the income statement for December 31, 2015, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year. b. Explain how this method could result in overstatement of profits for the pessimistic case and 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 2015 costs: $244,515 of the cost of goods sold is fixed; the rest is variable. $168,644 of the operating expenses is fixed; the rest is variable. All the interest expense is fixed. (Please see: .) d. Compare your findings in part c. to your findings in part a. Do your observations confirm your explanation in part b? .) Allen Products, Inc. Income Statement for the Year Ended December 31, 2015 Sales revenue $937,100 Less: cost of good sold 417,947 Gross profits $519,153 Less: operating expenses 229,590 Operating profits $289,563 Less: interest expense 32,799 Net profit before taxes $256,764 Less: taxes (rate 30%) 77,029 Net profits after taxes $179,735 Allen Products, Inc. Income Statement for the Year Ended December 31, 2015 Sales revenue $937,100 Less: cost of good sold Fixed 244,515 Variable 173,432 Gross profits $519,153 Less: operating expenses Fixed 168,644 Variable 60,946 Operating profits $289,563 Less: interest expense 32,799 Net profit before taxes $256,764 Less: taxes (rate 30%) 77,029 Net profits after taxes $179,735 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 $906,000; the most likely amount of sales is $1,128,000; and the optimistic prediction is $1,275,000. Allen's income statement for the most recent year is shown here 3. a. Use the percent-of-sales method, the income statement for December 31, 2015, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming b. Explain how this method could result in overstatement of profits for the pessimistic case and 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 2015 costs: $244,515 of the cost of goods sold is fixed; the rest is variable. $168,644 of the opera expenses is fixed; the rest is variable. All the interest expense is fixed. (Please see: E .) d. Compare your findings in part c. to your findings in part a. Do your observations confirm your explanation in part b? a. Use the percent-of-sales method, the income statement for December 31, 2015, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming y Complete the pro forma income statement for the year ending December 31, 2016 that is shown below (pessimistic scenario): (Round the percentage of sales to one decimal place and the pro forma income state accounts to the nearest dollar.) Pro Forma Income Statement Allen Products, Inc. for the Year Ended December 31, 2016 Pessimistic Sales Less: Cost of goods sold Gross profits Less: Operating expense $ L Enter any number in the edit fields and then click Check

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Finance questions