-Please refer to the spreadsheet above.Selected assumptions are given for preparing pro forma financial statements for 2015.Which of the following formulas would correctly give the forecast for sales in cell C8?
A) =B8*B2
B) =B8 + B8*B2
C) =(1 + B8)*B2
D) =(1/B2)*B8
E) None of the above.

Question

-Please refer to the spreadsheet above.Selected assumptions are given for preparing pro forma financial statements for 2015.Which of the following formulas would correctly give the forecast for sales in cell C8?
A) =B8*B2 
B) =B8 + B8*B2 
C) =(1 + B8)*B2 
D) =(1/B2)*B8 
E) None of the above.

Quizplus · Accepted Answer

The correct formula to forecast sales in cell C8 is =B8 + B8*B2, which represents the current sales plus the growth rate applied to the current sales.

-Please Refer to the Spreadsheet Above