2/Ellingham plc opens a Spanish subsidiary, which starts operating on 2 January 2014. On 2 January 2014 it has to buy a machine costing €30m, partly financed by a €20m bank loan repayable in instalments of €2m every 15 July and 15 January over 5 years. Financial expenses, payable on a half-yearly basis, are as follows: June Dec June Dec June Dec June Dec June Dec 1 0.9 0.8 0.7 0.6 0.5 0.4 0.3 0.2 0.1 Profits are tax free. Sales will be €12 m per month. A month’s inventory of finished products will have to be built up. Customers pay at 90 days. The company is keen to have a month’s worth of advance purchases and, accordingly, plans to buy two months’ worth of supplies in January 2011. Requirements in a normal month amount to €4m. The supplier grants the company a 90-day payment period. Other costs are: ◦ personnel costs of €4m per month; ◦ shipping, packaging and other costs amounting to €2m per month and paid at 30 days. These costs are incurred from 1 January 2014. Draw up a monthly and an annual cash flow plan. How much cash will the subsidiary need at the end of each month over the first year? And if operations are identical, how much will it need each month over 2015? What is the change in the cash position over 2015 (no additional investments are planned)?

Answer rating: 100% (QA)

Ellingham Cash flow statement Cash Forecast Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 2011 Cash Inflows 20 0 0 0 12 12 12 12 12 ... View the full answer