2018 calculations with formulas and work

growth constant at 30%

E20 XV fx A B C D D E 1 2015 2016 2017 2018 2019 N 30% 3.67% 60 75 1,206 1,377 36 285 2,979 90 1,440 1,683 60 321 3,594 66 1,875 2,091 102 360 4,494 1,050 168 3 Growth Rate 4 Tax Rate 5 Interest Rate 6 Dividend 7 Mortgage Principal 8 9 Cash 10 Accounts receivable 11 Inventory 12 Prepalds 13 Net fixed assets 14 Total 15 16 Accounts payable 17 Misc. accruals 18 Bank loan (Long Term) 19 Mortgage 20 Equity 21 Total 22 23 24 25 Sales 26 Cost of goods sold 27 Gross profit 28 Operating expenses 29 Selling expense 30 Salaries 31 General expenses 32 Depreciation 33 Total 34 EBIT 35 Interest 36 Earnings before tax 37 Tax 38 Net Income 39 645 120 750 150 1,314 2,979 132 1,737 102 1,020 138 1,497 4,494 831 144 1,401 3,594 7,260 5,874 1,386 9,075 7,440 1,635 11,370 9.438 1,932 567 315 140 45 1,067 320 83 237 93 144 696 411 173 36 1,316 320 843 492 201 48 1,584 348 105 243 87 156 89 231 84 147 an