Use the information from your Cash flow statement to perform a Discounted Cash Flow valuation of your organisation Attempt to value the shares of your company at the beginning of the 3-year period. .Assume the company has a cost of capital of 5 %. ( show these calculations in Excel

Based on your DCF valuation answer the following question.

How does your valuation compare to the market price existing at the beginning of the 3-year period. Explain if and why your answer is the same / different

Description 2017 amount Income Statement revenue 2319 cost of goods sold 1666 interest expense 79 tax expense 80 income from cont operations 653 net income 494 Blance sheet cash 80 accounts receivable 260 inventory 91 current assets 431 net fixed assets 8019 other assets 215 total assets 8665 current liabilitues 579 non current liabilities 3004 total liablities 3583 total stockholders e ui 5082 cash flow from operations 656 dividends 477 interest 79 115 82.6 3.9 4 32.4 24.5 0.9 1.1 92.5 2.5 100 6.7 34.7 41.4 58.6 2016 percentage amount 2375 1725 78 71 650 501 118 194 94 406 7818 314 8538 513 2975 3488 5050 625 501 78 117.9 85.6 3.9 3.5 32.3 24.9 1.4 2.3 1.1 4.8 91.6 3.7 100 34.8 40.9 59.1 2015 percentage amount 2904 2286 78 2 618 538 69 191 74 334 7144 183 7661 478 2435 2913 4748 614 385 78 144.1 113.4 3.9 0.1 30.7 26.7 0.9 2.5 4.4 93.3 2.4 100 6.2 31.8 38 62 2014 percentage amount 2509 1924 73 87 585 425 276 183 523 6983 7590 466 2490 2959 4634 612 261 73 Growth ratios sales growth income growth asset growth profitability ratios profit margin return on assets return on equity dividend payout ratio activity ratios receivable turnover inventory turnover fixed asset turnover liquidity ratio current ratio solvency ratios debt to equity debt to total assets 2017 2.4 3.4 1.5 28.2 7.6 9.8 96.6 10.2 25.1 0.3 0.74 0.16 0.35 2016 18.2 24.5 11.4 27.4 10.6 100 12.3 28.3 0.3 0.79 0.15 0.35 2015 15.7 18.8 0.9 21.3 8.1 22.7 71.6 15.5 42.1 0.4 0.7 0.16 0.32