Complete the forecasted income statement and forecasted balance sheet by using the data and information from the assumptions listed. Show all formulas and work/supporting calculations.

Assumptions:

Proforma income statement and balance sheet to fill out:

ASSUMPTIONS NOTE: You will use a combination of the Proforma and the Percent-of-Sales methods to create your forecasted financials. Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both - clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Balance Sheet ( 30 points) ASSUMPTIONS NOTE: You will use a combination of the Proforma and the Percent-of-Sales methods to create your forecasted financials. Fill in the yellow highlighted cells with your forecasted figures. SHOW ALL YOUR SUPPORTING CALCULATIONS! You may do this either within the cell by using formulas, out to the right, or both - clearly labeling your work. All your work must be shown on this sheet, not on a separate tab. Forecasted Balance Sheet ( 30 points)