Question 1 · NPV Calculation (Table completion)
3 marksCASE STUDY BOOKLET EXTRACT — Marlow Outdoor Ltd
Marlow Outdoor Ltd is a Northern Ireland-based manufacturer of outdoor clothing and equipment, founded in 1998 and employing 340 staff across its Belfast head office and Portadown distribution centre. Turnover has grown from £42 million to £51 million over the past two years. The board is choosing between two strategic investment options:
Option A: build a new manufacturing factory in Antrim (initial investment £4,000,000).
Option B: license production to a manufacturing partner in Vietnam (initial investment £1,800,000).
Table 1: Net Present Value calculation for Option A (discount rate 8%)
Year Net cash flow (£) Discount factor Discounted cash flow (£)
1 1,200,000 0.926 1,111,200
2 1,500,000 0.857 1,285,500
3 1,500,000 0.794 [BLANK — to be calculated]
4 1,300,000 0.735 955,500
Using the data in Table 1, calculate the discounted cash flow for Year 3, and hence calculate the Net Present Value (NPV) of Option A. (Show your workings clearly in the table, to the nearest £.)
Marlow Outdoor Ltd is a Northern Ireland-based manufacturer of outdoor clothing and equipment, founded in 1998 and employing 340 staff across its Belfast head office and Portadown distribution centre. Turnover has grown from £42 million to £51 million over the past two years. The board is choosing between two strategic investment options:
Option A: build a new manufacturing factory in Antrim (initial investment £4,000,000).
Option B: license production to a manufacturing partner in Vietnam (initial investment £1,800,000).
Table 1: Net Present Value calculation for Option A (discount rate 8%)
Year Net cash flow (£) Discount factor Discounted cash flow (£)
1 1,200,000 0.926 1,111,200
2 1,500,000 0.857 1,285,500
3 1,500,000 0.794 [BLANK — to be calculated]
4 1,300,000 0.735 955,500
Using the data in Table 1, calculate the discounted cash flow for Year 3, and hence calculate the Net Present Value (NPV) of Option A. (Show your workings clearly in the table, to the nearest £.)
Show answer & marking schemeHide answer & marking scheme
Worked solution
Year 3 discounted cash flow = net cash flow × discount factor = £1,500,000 × 0.794 = £1,191,000. Total discounted cash flow over the 4 years = £1,111,200 + £1,285,500 + £1,191,000 + £955,500 = £4,543,200. NPV = total discounted cash flow − initial investment = £4,543,200 − £4,000,000 = £543,200. Second-route check: summing the four discounted cash flows column-wise (1,111,200 + 1,285,500 = 2,396,700; + 1,191,000 = 3,587,700; + 955,500 = 4,543,200) gives the identical running total, confirming the sum; subtracting the £4,000,000 initial investment from this total gives £543,200, independently verified by adding £543,200 back to £4,000,000 to recover £4,543,200. Final answer: Year 3 discounted cash flow = £1,191,000; NPV of Option A = £543,200 (positive).
Marking scheme
[3] total: [1] correct Year 3 discounted cash flow (£1,191,000), with method (£1,500,000 × 0.794) shown; [1] correct total discounted cash flow (£4,543,200); [1] correct final NPV (£543,200), clearly identified as positive. Own figure rule applies if Year 3 is miscalculated but the NPV is then correctly derived from the candidate's own (wrong) Year 3 figure.