Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

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,

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)?


Step by Step Solution

There are 3 Steps involved in it

Step: 1

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 ... blur-text-image
Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting with IFRS Fold Out Primer

Authors: John Wild

5th edition

978-0077408770, 77408772, 978-0077413804

More Books

Students explore these related Finance questions