I need to calculate a NPV and II was wondering if you could help me establish th
ID: 1172090 • Letter: I
Question
I need to calculate a NPV and II was wondering if you could help me establish the relevant cash flow for this question:
Worldwide Medical Devices (WMD) manufactures medical diagnostic equipment at several locations across Europe. WMD has traditionally manufactured high-quality large medical equipment for use in hospitals. Recently, the firm has developed a new technology that makes testing vitamin D deficiency at GP surgeries affordable, avoiding the need to send patients’ blood to testing laboratories. WMD has spent £50m designing and developing this new generation of equipment for the European domestic market. The costs to complete the final stages of regulatory approval are estimated to be £30m. WMD plan to establish a new division, Fast Medical Diagnostics (FMD), to manufacture and market this new generation of testing devices. This will be WMD’s first venture into the smaller equipment market. WMD will continue to manufacture their larger hospital equipment separately.
This new generation of testing devices is expected to have a production life of six years. The Group Finance Director is busy arranging a new debt facility for WMD and has asked you to prepare an investment appraisal report to present to the next board meeting which will make a recommendation to the directors whether to proceed with establishing FMD.
The new FMD factory would be built on a vacant site already owned by WMD adjacent to their existing Lyon factory. The vacant site was recently valued at £6m. Investment to build the factory and the required plant and equipment would be £300m. WMD charges depreciation on a straight-line basis over the useful life of assets. The plant and equipment is not expected to have any scrap value at the end of the project. The project will also require additional working capital of £60m for the life of the project. It is expected that 60% of the working capital investment will be recovered at the end of the project.
Currently, net investment in plant and equipment is eligible for capital allowances on a straight-line basis over four years. The applicable corporation tax rate is 30% and paid one year in arrears. Capital allowances are received by WMD in the same year that they are claimed.
FMD expects to sell a total of 100,000 of the devices each year at a fixed price of £3,200 per device over the planned production life of six years. Incremental operating costs for FMD are estimated to be £220m per annum. All cash flows are in today’s money and inflation is expected to be 2.5% per annum over the next six years.
WMD’s shares continue to be listed on the London Stock Exchange where they currently trade at £3.50 with an equity beta of 1.6. The expected equity risk premium is 8% and risk-free rate is 2%. WMD currently has a market gearing ratio (debt / [debt+equity]) of 30%. WMD has sufficient resources available to fund the FMD project from current facilities. The current average before-tax cost of borrowing for the company is 5%.
Explanation / Answer
Calculation of Cost of Capital (WACC)
Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Sales (A) 320,000,000 328,000,000 336,200,000 344,605,000 353,220,125 362,050,628 (3200*100000) (320000000*102.5%) (328000000*102.5%) (336200000*102.5%) (344605000*102.5%) (353220125*102.5%) Operating Costs (B) 220,000,000 225,500,000 231,137,500 236,915,938 242,838,836 248,909,807 (220000000*102.5%) (225500000*102.5%) (23137500*102.5%) (236915938*102.5%) (242838836*102.5%) Gross Profit (C=A-B) 100,000,000 102,500,000 105,062,500 107,689,063 110,381,289 113,140,821 Less: Depreciation (D) 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 (300m/6) Income before Taxes (E= C-D) 50,000,000 52,500,000 55,062,500 57,689,063 60,381,289 63,140,821 Less: Taxes (one year in arrears) (F) 15,000,000 15,750,000 16,518,750 17,306,719 18,114,387 18,942,246 Income after Taxes (G=E-F) 50,000,000 37,500,000 39,312,500 41,170,313 43,074,570 45,026,435 - 18,942,246 Add: Depreciation (D) 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 50,000,000 - Cashflows (H=G+D) 100,000,000 87,500,000 89,312,500 91,170,313 93,074,570 95,026,435 - 18,942,246 Working Capital (I) - 60,000,000 36,000,000 (60000000*60%) Purchase of Equipment (J) - 300,000,000 Net Cashflows(K=H+I+J) - 360,000,000 100,000,000 87,500,000 89,312,500 91,170,313 93,074,570 131,026,435 - 18,942,246 Discounting Factor @11.41% (L) 1 0.90 0.81 0.72 0.65 0.58 0.52 0.47 (1/1.1141) (0.90/1.1141) (0.81/1.1141) (0.72/1.1141) (0.65/1.1141) (0.58/1.1141) (0.52/1.1141) Discounted Cashflows (M=K*L) - 360,000,000 89,758,550 70,495,226 64,586,199 59,177,518 54,226,325 68,519,452 - 8,891,239 NPV (Sum of M) 37,872,029Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.