Pro forma Spreadsheet
Part 1
Build a pro forma Excel sheet estimating revenue and all operating cost items of the business for each of the first 3 years (12 quarters) of operation. Review the pro forma examples provided in the topic Resources. Pro forma estimates should be based on researched information and rational assumptions.
Part 2
Write a 750-1,000-word summary of your pro forma spreadsheet. Include the following items:
Describe how you developed the pro forma projected expenses and operating costs.
Explain your revenue estimates, variable costs, fixed costs, margin, and how your arrived at your figures.
Build a pro forma Excel sheet estimating revenue and all operating cost items of the business for each of the first 3 years (12 quarters) of operation.