With the given financial statements displayed in Excel:

• What is the five-year financial forecast for the company (2011-2016)?

* I DO NOT need an explanation of methods, accounting info, etc.

* I NEED calculations in an Excel format to ensure mine is coming from the correct data. Thank you!

Link to the case study (copy and paste): https://www.imanet.org/-/media/219c07318fa3422eb0d7112a194642cb.ashx

3 4 Sales 5 COGS 6 7 8 9 Depreciation Allocation 10 11 12 13 14 Operating Expenses 15 Owners/Mgt Compensation 16 CEO Bonus Compensation 17 Saleries & Wages 18 Professional Fees 19 Rent Allocation 20 Commissions 21 Bad Debts 22 Advertising & Promotion 23 Trade Shows 24 Research 25 Depreciation Allocation 26 Amortization - Purchase Debt 27 Interest 28 Other Expenses 29 30 31 32 Materials DL Rent Allocation Other Total COGS Gross Profit Total Operating Expenses Operating Profit 2005 2,050,742 693,945 207,823 18,374 19,110 95,798 1,035,050 1,015,692 133,000 20,327 139,523 45,131 20,793 71,815 14,000 94,304 29,021 14,224 3,901 12,600 42,310 210,169 851,118 164,574 2006 1,789,429 596, 194 185,736 26,921 12,434 62,723 884,008 905,421 151,000 4,270 29,395 99,177 24,447 154,430 0 74,302 25,184 24,582 2,814 12,600 19,517 264,125 885,843 19,578 2007 2,248,511 771,007 251,120 25,719 11,131 77,157 1,136,134 1,112,377 138,238 23,900 22,331 47,422 23,912 122,089 32,551 104,310 25,162 4,008 1,995 12,600 107,534 367,186 1,033,238 79,139 2008 2,600,000 910,000 296,000 26,000 17,770 100,230 1,350,000 1,250,000 150,000 32,500 24,500 10,000 24,000 143,770 26,140 120,000 26,000 15,000 3,230 12,600 117,630 219,630 925,000 325,000 2009 3,000,000 1,030,000 335,000 26,000 17,950 123,050 1,532,000 1,468,000 180,000 37,500 27,000 10,000 24,000 165,000 30,000 138,000 28,000 15,000 4,050 12,600 134,955 286,895 1,093,000 375,000 2010 3,500,000 1,195,000 390,000 26,000 19,800 146,200 1,777,000 1,723,000 220,000 45,000 29,700 10,000 24,000 191,345 34,790 160,000 30,000 15,000 4,200 12,600 156,548 339,817 1,273,000 450,000 2011 2012 2013 2014