Question
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
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 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Fundamentals Of Financial Accounting
Authors: Fred Phillips, Robert Libby, Patricia Libby
1st Edition
0072992573, 9780072992571
