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)

(cash flow statement)

Item	06/13	06/14	06/15
Receipts from Customers	248,214,000.00	262,476,000.00	270,150,000.00
Payments to Suppliers and Employees	-120,992,000.00	-137,988,000.00	-135,470,000.00
Dividends Received	0.00	0.00	0.00
Interest Received	890,000.00	280,000.00	740,000.00
Interest Paid	-17,792,000.00	-15,055,000.00	-15,980,000.00
Tax Paid	-26,926,000.00	-27,355,000.00	-28,886,000.00
Other Operating Cashflows	0.00	0.00	0.00
Net Operating Cashflows	83,394,000.00	82,358,000.00	90,554,000.00
Payment for Purchase of PPE	-68,730,000.00	-61,635,000.00	-54,873,000.00
Proceeds From Sale of PPE	53,886,000.00	140,000.00	512,000.00
Investments Purchased	0.00	0.00	-3,829,000.00
Proceeds From Sale of Investments	0.00	-19,776,000.00	167,000.00
Payments for Purchase of Subsidiaries	-27,252,000.00	0.00	0.00
Proceeds from Sale of Subsidiaries	0.00	0.00	-929,000.00
Loans Granted	-5,753,000.00	-1,400,000.00	-6,180,000.00
Loans Repaid	16,599,000.00	0.00	0.00
Other Investing Cashflows	9,371,000.00	-1,981,000.00	10,423,000.00
Net Investing Cashflows	-21,879,000.00	-84,652,000.00	-54,709,000.00
Proceeds from Issues	0.00	16,000.00	0.00
Proceeds from Borrowings	30,000,000.00	64,155,000.00	95,180,000.00
Repayment of Borrowings	-466,000.00	-34,000,000.00	-45,000,000.00
Dividends Paid	-63,035,000.00	-63,035,000.00	-69,419,000.00
Other Financing Cashflows	-40,000.00	-500,000.00	-248,000.00
Net Financing Cashflows	-33,541,000.00	-33,364,000.00	-19,487,000.00
Net Increase in Cash	27,974,000.00	-35,658,000.00	16,358,000.00
Cash at Beginning of Period	9,244,000.00	37,218,000.00	1,560,000.00
Exchange Rate Adj	0.00	0.00	0.00
Other Cash Adjustments	0.00	0.00	0.00
Cash at End of Period	37,218,000.00	1,560,000.00	17,918,000.00