Reference no: EM131110860
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, 2012
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, 2012, 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 2012 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 of 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?
|
What is the difference between future value and present val
: What is the difference between future value and present value? Which approach is generally preferred by financial managers? Why?
|
|
Press release indicating that sales will not be as high
: The SEC is trying to get companies to notify the investment community more quickly when a “material change” will affect their forthcoming financial results. In what sense might a financial manager be seen as “more ethical” if he or she follows this d..
|
|
Discuss the financing changes suggested by the statement
: Prepare a pro forma balance sheet dated December 31, 2014. Discuss the financing changes suggested by the statement prepared in parta.
|
|
Prepare a pro forma balance sheet for december
: Leonard Industries wishes to prepare a pro forma balance sheet for December 31, 2013. The firm expects 2013 sales to total $3,000,000. The following information has been gathered.
|
|
Explain how the percent of sales method could result
: Use the percent-of-sales method, the income statement for December 31, 2012, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year. Explain how the percent-of-sales method ..
|
|
Compare and contrast the statements developed
: Use the percent-of-sales method to prepare a pro forma income statement for the year ended December 31, 2013. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2013. Compare and contrast the stat..
|
|
Discuss how knowledge of the timing and amounts involved
: Prepare a scenario analysis of Trotter's cash budget using -$20,000 as the beginning cash balance for October and a minimum required cash balance of $18,000. Use the analysis prepared in part a to predict Trotter's financing needs and investment oppo..
|
|
Check statements that will be affected immediately
: The following represent financial transactions that Johnsfield & Co. will be undertaking in the next planning period. For each transaction, check the statement or statements that will be affected immediately.
|
|
What is the cumulative cash surplus or deficit by the end
: Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2013. Are there individual months that incur a deficit? What is the cumulative cash surplus or deficit by the end of December2013?
|