Draft a spreadsheet showing financial history and projected performance for the company you plan to use in this course's final project.

Sheet: Financials

This is a sample

Note: Calculations were not included. Don't forget to make the cells functional to show the calculations.

History

Projected

Revenue

Gross Profit

Operating Expenses

Calculated Profit

Calculated Profit Margin

Assumptions: (Example)

* After a slight increase in revenues in 2017, due tolcul the new store opening, to 2% above average; revenue will stay consistent for the next two years at 6% increase.

* The cost of revenue will stay at approximately 62% of revenue through 2019.

*

Information for 2015 and 2016 has a year end of 01/31 and was obtained from MSN money

Citation:

Please include citations.