pro forma statements

Decide upon an initiative you want to implement that would increase sales over the next five years, (for example, market another product, corporate expansion, and so on).
Using the ATTACHED sample financial statements for xyz company as the base year (last year's performance results), create, in an EXCEL file, pro forma statements of  five year projections of the Balance Sheet and, the Income Statement, that are clear, concise, and easy to read. Be sure to double check the calculations in your pro forma statements. Make assumptions that support each line item increase or decrease for your forecasted statements.
Discuss and interpret the financials in relation to the initiative. Make recommendations on potential discretionary financing needs.
In your EXCEL file, Write a 150-200 word analysis of the company's short term and long term financing needs and determine strategies for the company to manage working capital. You can use bullets.  If you prefer, you can copy /paste your analysis from a word document---but submit all work in a single Excel file, on a single sheet in the Excel file.