Question: Prepare a pro forma cash flow forecast by completing the following table. Wordings and format of the table cannot be changed in any way. Round
Prepare a pro forma cash flow forecast by completing the following table.
Wordings and format of the table cannot be changed in any way.
Round all numbers in the table to the last two decimal points.
No explanation and supporting calculation of your numeric answers are required.
| Fuyao Glass | ||||
| Pro Forma Cash Flow Forecast | ||||
|
| 2015 | 2016 | 2017 | 2018 |
|
| (millions of ) | |||
| Cash flows from operating activities |
|
|
|
|
| Cash generated from operations |
|
|
|
|
| Income tax paid |
|
|
|
|
| Net cash generated from operating activities |
|
|
|
|
|
|
|
|
|
|
| Cash flow from investing activities |
|
|
|
|
| Capital expenditures -United States |
|
| 0.00 | 0.00 |
| Capital expenditures -Russia |
|
| 0.00 | 0.00 |
| Capital expenditures -Others including China |
|
|
|
|
| Working capital investment |
|
|
|
|
| Net cash used from or (used in) investing activities |
|
|
|
|
|
|
|
|
|
|
| Net cash available or (shortage) before financing |
|
|
|
|
|
|
|
|
|
|
| Cash flow from financing activities |
|
|
|
|
| Borrowings and (Repayments) | (4,335.50) | 1,121.57 | (949.42) | (1,242.42) |
| Dividends paid to the company's shareholders |
|
|
|
|
| Other Interest received | 227.00 | 5.00 | 61.00 | 13.00 |
| Capital injections - issuance of new shares |
| 0.00 | 0.00 | 0.00 |
| Net cash generated from or (used in) financing activities |
|
|
|
|
|
|
|
|
|
|
| Net (decrease) or increase in cash and cash equivalents |
|
|
|
|
| Cash and cash equivalents at beginning of the period |
|
|
|
|
| Cash and cash equivalents at end of the period |
|
|
|
|
|
|
|
|
|
|
Supplementary Notes:
- Cash generated from operations and Revenue increase at a constant rate of 10 per cent per year from 2014 to 2018.
- Income tax paid is 12 per cent of cash generated from operations from 2015 to 2018.
- Planned capital expenditures for Others including China remains the same amount from 2016 to 2018.
- 0.50 per share annual dividend until 2018.
- Working capital investment increases at an annual rate of 163 per cent of the change in cash generated from operations from 2016 to 2018.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
