Unit: Advanced Financial Management
Sign in to download the full Topic PDF and enable offline revision mode.
Login to Access| Project | Initial outlay Sh.“million” | Annual revenue Sh.“million” | Annual fixed costs Sh.“million” | Project life (Years) |
| A | 100 | 200 | 50 | 3 |
| B | 300 | 300 | 100 | 5 |
| C | 150 | 180 | 60 | 4 |
| D | 120 | 170 | 80 | 10 |
| E | 180 | 80 | 20 | 15 |
| Scenario | Probability | Before tax savings | Salvage value | Net operating working capital (NOWC) |
| Sh.“million” | Sh.“million” | Sh.“million” | ||
| Worst case | 0.30 | 36 | 32 | 6.4 |
| Base case | 0.40 | 45 | 40 | 8.0 |
| Best case | 0.30 | 54 | 48 | 9.6 |
Required: The project’s expected net present values (ENPV). | ||||
| Age of vehicles (years) | 0 | 1 | 2 | 3 | 4 |
| Sh.“000” | Sh.“000” | Sh.“000” | Sh.“000” | Sh.“000” | |
| Replacement cost | 7,000 | - | - | - | - |
| Annual operating and maintenance cost | 500 | 750 | 1,000 | 2,000 | |
| Residual value at the end of the year | 4,750 | 3,500 | 3,000 | 2,250 |
| 1. | The project will commence on 1 January 2025 with the initial capital of 5 million South Africa Rands (ZAR) which will be used in acquiring agricultural machinery with an estimated useful life of 5 years with a zero salvage value. The straight line method of depreciation will be applied. |
| 2. | To enable the firm pay land rates and other working capital requirements, an additional 2.5 million ZAR will be required and it is expected that this amount will be recouped in full at the end of the project’s useful life. |
| 3. | Annual sales revenue from the project are estimated as follows: | ||
| Year | Revenue (ZAR) | Fixed costs (ZAR) | |
| 2025 | 2,600,000 | 600,000 | |
| 2026 | 3,500,000 | 780,000 | |
| 2027 | 5,000,000 | 905,000 | |
| 2028 | 4,200,000 | 880,000 | |
| 2029 | 2,800,000 | 450,000 | |
| 4. | Variable operating costs are expected to be 20% of the sales and are assumed to accrue evenly. |
| 5. | The exchange rates between the Kenya Shilling and the South Africa Rand are as follows: |
| ZAR/KES | ||
| 1 January 2025 | 8.00 | |
| 31 December 2025 | 8.50 | |
| 31 December 2026 | 9.00 | |
| 31 December 2027 | 9.50 | |
| 31 December 2028 | 10.00 | |
| 31 December 2029 | 10.30 | |
| 6. | All the cash flows are expected to occur at the year end. | |
| 7. | The cost of capital for both South Africa and Kenya is assumed to be 12% per annum. | |
| 8. | Assume that the corporation tax rate in South Africa is 30% and no further taxation will be levied in Kenya. | |
| Required: | ||
| (i) | The net present value (NPV) of the project in Kenya Shillings (KSh.). | |
| (ii) | Based on your results in (c) (i) above, advise the management of Mavuno Bora Ltd. on appropriate course of action. | |
| Year | Project A | Project B | ||
| Cash flows Sh.“000” | Certainty equivalents Sh.“000” | Cash flows Sh.“000” | Certainty equivalents Sh.“000” | |
| 0 | (45,000) | 1.00 | (60,000) | 1.00 |
| 1 | 22,500 | 0.85 | 37,500 | 0.80 |
| 2 | 22,500 | 0.80 | 30,000 | 0.70 |
| 3 | 15,000 | 0.75 | 22,500 | 0.60 |
| 4 | 15,000 | 0.60 | 15,000 | 0.50 |
| (i) | Estimate the value of the option to delay the start of the project for two years using the Black Scholes Option Pricing Model (BSOPM) and comment on your findings. Assume that the government will make its announcement about the potential transport link at the end of the two years. |
| (ii) | On the basis of valuation of the option to delay, estimate the overall value of the project, giving a concise rationale for the valuation method used. |
| (iii) | Explain TWO other types of real options that may be present relating to the Mua Greens Estate housing development. Hint: Value of call option: \(P_s (Nd_1)\) – \(P_e (Nd_2). e^{–rfT}\) Where: \(\displaystyle d_1 = \frac{ln (P_s/P_e) + (rf + 0.5σ^2)T}{σ \sqrt{T}}\) \(d_2 = d_1 – σ \sqrt{T}\) \(P_s\)\(=\)Underlying price \(P_e\) \(=\)Strike price σ \(=\)Volatility rf \(=\) Continuity compounded risk-free interest rate T = Time to expiration |
| Debentures | 25% |
| Preference share capita | 15% |
| Ordinary share capital | 60% |
| 100% |
| 1. | Mapato Ltd.’s expected profit after tax for the year ended 30 June 2023 was Sh.34,285,714. Mapato Ltd. has an established dividend pay-out ratio of 30%. The tax rate for the company is 30% and investors expect earnings and dividends to grow at a constant rate of 9% per annum in the future. |
| 2. | The company paid a dividend of Sh.3.6 per share in the year ended 30 June 2023. The company’s shares currently sells at Sh.60 per share. |
| 3. | The company can obtain new capital as follows: | |
| Ordinary shares: | New ordinary share capital can be issued at a floatation cost of 10%. | |
| Preference share capital: | New preference share capital can be issued to the public at Sh.100 per share. The floatation cost is Sh.5 per share and a dividend of Sh.11 per share. | |
| Debentures: | Debentures can be issued at an interest rate of 12% per annum. | |
| 4. | Assume that the cost of capital is constant beyond the retained earnings breakpoint. |
| 5. | Mapato Ltd. has the following investment opportunities: |
| 5. | Project | Cost (Sh.) | Internal rate of return (IRR) |
| A | 10,000,000 | 17.4% | |
| B | 20,000,000 | 16.0% | |
| C | 10,000,000 | 14.2% | |
| D | 20,000,000 | 13.7% | |
| E | 10,000,000 | 12.0% |
| Year | 1 | 2 | 3 | 4 |
| Sales (units per year) | 300,000 | 410,000 | 525,000 | 220,000 |
| Selling price per unit (Sh.) | 125 | 130 | 140 | 120 |
| Variable cost per unit (Sh.) | 71 | 71 | 71 | 71 |
| Annual fixed cost (Sh.“000”) | 3,000 | 3,100 | 3,200 | 3,000 |
| Project | Initial outlay Sh. “000” | Net present value Sh. “000” |
| 1 | 1,000 | 390 |
| 2 | 750 | 325 |
| 3 | 1,125 | 590 |
| 4 | 1,850 | 840 |
| 5 | 1,300 | 635 |
| 6 | 1,500 | - |
| 1. | Project 6 is expected to generate the following annual cash flows: |
| 1. | Year | 1 Sh. “000” | 2 Sh. “000” | 3 Sh. “000” | 4 Sh. “000” |
| Sales | 725 | 765 | 885 | 612 | |
| Cost | 145 | 168 | 202 | 94 |
| Project 6 cash flows are exclusive of inflation at the rate of 4% per year for sales income and 5% per year for costs. | |
| 2. | The cost of capital is 10%. |
| 3. | Due to management reluctance to raise additional finance, the capital for investment is currently restricted to Sh.5,000,000. |
| 4. | Project 1, 3, 5 and 6 are all independent but project 2 and 4 are mutually exclusive. |
| 5. | All of the above projects are divisible and none can be delayed or repeated. |
Required: | |
| (i) | The net present value (NPV) for project 6. |
| (ii) | The optimum investment combination given the capital constraint. |
| (iii) | The resulting net present value (NPV) in (c) (ii) above. |
| Year | Worst case Sh.“000” | Most probable case Sh.“000” | Best case Sh.“000” |
| 0 | (100,000) | (100,000) | (100,000) |
| 1 | 20,000 | 30,000 | 40,000 |
| 2 | 20,000 | 30,000 | 40,000 |
| 3 | 20,000 | 30,000 | 40,000 |
| 4 | 20,000 | 30,000 | 40,000 |
| 5 | 20,000 | 30,000 | 40,000 |
| \(5^*\) | 5,000 | 20,000 | 30,000 |
| Probability | 0.20 | 0.60 | 0.20 |
| Project | ||
| Year | X | Y |
| Cash flow Sh.“000” | Cash flow Sh.“000” | |
| 0 | (40,000) | (80,000) |
| 1 | (80,000) | (40,000) |
| 2 | (120,000) | - |
| 3 | 400,000 | 240,000 |
| Year | Amount Sh.“000” |
| 0 | 100,000 |
| 1 | 80,000 |
| 2 | 60,000 |

| 1. | The plant has a useful life of five years and is to be depreciated on a straight line basis. |
| 2. | The salvage value is nil. |
| 3. | Due to market uncertainties, the sale price, variable cost and sales volume of the super pad have been estimated stochastically as follows: |
| Selling price | Variable Cost | Sales Volume | ||||
| Value Sh. | Probability | Value Sh. | Probability | Value units | Probability | |
| 30 | 0.20 | 10 | 0.20 | 4 million | 0.20 | |
| 40 | 0.60 | 20 | 0.50 | 6 million | 0.50 | |
| 50 | 0.20 | 30 | 0.30 | 8 million | 0.30 | |
| 4. | The company’s cost of capital is 12% and the corporate tax rate is 30%. | |||||
| Required: | |
| (a) | The expected net present value (NPV) of the new product using expected values for each variable. |
| (b) | The expected NPV by performing ten runs using the following random numbers for each variable. Selling.price:...76..64..02..53..16..16..55..54..23..36 Variable.cost:..20..82..74..08..01..69..36..35..52..99 Sales.volume:.55..50..29..58..51..14..86..24..39..47 Required: Determine the expected NPV as simulated. |
| (c) | The probability that this product will be a success. |
| (d) | Discuss the advantage (merits) and disadvantages (limitations) of simulation analysis. |
| Project | Initial investment Sh. (millions) | Net present value Sh. (millions) |
| P | 300 | 120 |
| Q | 300 | 90 |
| R | 600 | 150 |
| S | 300 | 30 |
| T | 150 | 12 |
| Unit selling price | Unit variable cost | Annual sales volume | |||
| Value | Probability | Value | Probability | Volume | Probability |
| 25 | 0.30 | 10 | 0.20 | 4.5 million | 0.30 |
| 35 | 0.50 | 15 | 0.40 | 6 million | 0.40 |
| 45 | 0.20 | 30 | 0.40 | 7.5 million | 0.30 |
| (i) | The expected net present value (NPV) of the project. |
| (ii) | Simulate the net present value (NPV) using the following random numbers: (752560 658055 957530 869950 544025) and hence determine the expected Net Present Value of the project. |
| (iii) | Determine the probability that the product will be a success. |
| Sh."million" | |
| Debenture capital | 25 |
| Reserves | 15 |
| Ordinary share capital | 45 |
| Preference share capital | 15 |
| 100 |
| 1. | The firm's historical earnings per share (EPS) and dividend per share (DPS) over the last five years are given as follows: |
| Year to 31 December | EPS Sh. | DPS Sh. | |
| 2016 | 6.5 | 3.00 | |
| 2017 | 6.8 | 3.10 | |
| 2018 | 7.0 | 3.30 | |
| 2019 | 7.5 | 3.50 | |
| 2020 | 8.0 | 3.60 |
| 2. | The company's ordinary shares currently sell at Sh.50 per share at the Securities Exchange. New ordinary shares will be sold at this price. |
| 3. | The company's expected net income for the year ending 31 December 2020 is Sh.40,000,000. Dinosoft Limited adopts a constant payout ratio of 40% as its dividend policy. |
| 4. | The company can raise additional capital as follows to finance acceptable investment projects: | |
| Equity capital: | Utilise all available retained earnings for the year ended 31 December 2020. Any extra external equity will be raised through issue of new ordinary shares at a floatation cost of 10% of the issue price. | |
| Preference share capital: | New preference shares will be issued at 11% coupon rate. The par value of each share is Sh.100. New preference shares will be issued at par subject to a floatation cost of Sh.5 per share | |
| Debentures: | New debentures can be sold at a coupon rate of 13%. The debentures will be issued at par. | |
| 5. | Corporation tax rate is 30%. | |
| Required: | |
| (i) | Calculate the breakpoint in the marginal cost of capital schedule. |
| (ii) | The weighted marginal cost of capital (WMCC) in each of the intervals between the breakpoints. |
| (iii) | Dinosoft Limited has the following potential investment opportunities. | ||
| Project | Initial cash outlay Sh. | Internal rate of return (%) | |
| V | 10,000,000 | 16 | |
| W | 20,000,000 | 14 | |
| X | 10,000,000 | 11 | |
| Y | 20,000,000 | 10 | |
| Z | 10,000,000 | 8 | |
| (iii) | Required: Using the investment opportunities schedule, advise on which project(s) to accept and hence determine the firm's optimal capital budget. |

| Year | 1 | 2 | 3 | 4 | 5 |
| Cash Flow (Sh. "000") | 850 | 900 | 950 | 1,000 | 950 |
| Alternative | Sell | License | Manufacture |
| Initial investment, I, (Sh.) | 400,000 | 400,000 | 900,000 |
| Year | Cash inflows (Sh.) | ||
| 1 2 3 4 5 6 | 400,000 500,000 - - - - | 300,000 200,000 160,000 120,000 80,000 - | 400,000 500,000 400,000 400,000 400,000 400,000 |
| Economic state | Poor | Normal | Good |
| Probability | 0.30 | 0.60 | 0.10 |
| Annual sales volume (units) | 17,500,000 | 20,000,000 | 22,500,000 |
| Probability | Useful life of computers (years) |
| 0.20 0.50 0.30 | 5 10 15 |
| Unit selling price | Unit variable cost | Annual sales volume | |||
| Value Sh. | Probability | Value Sh. | Probability | Value (Sh."million") | Probability |
| 35 30 50 | 0.30 0.40 0.30 | 15 10 25 | 0.20 0.50 0.30 | 4 7 9 | 0.10 0.60 0.30 |
| (i) | The expected net present value (NPV) of the new product. |
| (ii) | Simulate the net present values (NPV) using the following random numbers: (802560 638351 057530 150353 603785 553525 245239 369948 160252 857015) and compute the expected net present value of the project. |
| Probability estimates | |||
| Cash outlay | Annual cash inflows | ||
| Probability | Amount Sh."000" | Probability | Amount Sh."000" |
| 0.45 | 250,000 | 0.20 | 45,000 |
| 0.25 | 280,000 | ||
| 0.40 | 50,000 | ||
| 0.25 | 300,000 | ||
| 0.10 | 305,000 | 0.40 | 60,000 |
| Year 1 Sh."000" | Year 2 Sh."000" | Year 3 Sh."000" | Year 4 Sh."000" | |
| Maintenance costs | 7,500 | 11,000 | 12,500 | 15,000 |
| Resale value (end of year) | 15,000 | 10,000 | 7,500 | 2,500 |
| Source of capitai | % |
| Long-term debt Equity capital | 45 55 |
| Total | 100 |
| Loan amount (Sh.) | Interest rate on incremental debt |
| 0-500,000 | 9% |
| 500,000 - 900,000 | 11% |
| 900,000 and above | 13% |
| Project | Cash outlay Sh. | Annual net cash flow Sh. | Project life (years) Sh. | Internal rate of return % |
| A B C D E | 675,000 900,000 375,000 562,500 750,000 | 155,401 268,484 161,524 185,194 127,351 | 8 5 3 4 10 | ? 15 ? 12 11 |
| Annual after tax cash flow (Sh."000") | Probability | Drug life in years | Probability |
| 1,000 1,500 2,000 2,500 3,000 3,500 4,000 | 0.02 0.03 0.15 0.15 0.30 0.20 0.15 | 3 4 5 6 7 8 9 10 | 0.05 0.10 0.30 0.25 0.15 0.10 0.03 0.02 |
| (i) | Using the following random numbers, perform 10 simulation runs of the net present value (NPV) of this project. 5397 6699 3081 1909 3167 8170 3875 4883 9033 5852 |
| (ii) | Determine the expected net present value (NPV) of the project. |
| Project | Required initial investment Sh. "million" | Internal rate of return (%) |
| A B C D | 8 7 9 6 | 26 16 20 22 |
| 1 | The company had Sh.9 million available from retained earnings as at I January 2016. Any extra equity finance would have to be sourced through an issue of new ordinary shares. |
| 2 | The market price per ordinary share on 1 January 2016 was Sh.25.60 ex-dividend. Information on earnings per share (EPS) and dividend per share (DPS) over the last 6 years is as follows: |
| Year ended 31 December | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | |
| EPS (Sh.) DPS (Sh.) | 4.5 2.5 | 4.8 2.8 | 4.9 2.9 | 5.2 30 | 5.5 3.2 | 6.0 3.5 |
| 3 | Issue of new ordinary shares would attract a floatation cost of Sh.4.60 per share. |
| 4 | 9% irredeemable debentures (par value of Sh.1,000 each) could be sold with net proceeds of 95% due to a discount on issue of 2% and a floatation cost of Sh.30 per debenture. The maximum amount available from the issue of the 9% irredeemable debenture would be Sh.4 million after which debt could only be obtained at 12% interest with net proceeds of 90% of par value. |
| 5 | 10% preference shares can be issued at a par value of Sh.80. |
| 6 | The company's capital structure, which is considered optimal, is as Sh. Equity capital 45% Preference share capital 30% Debenture capital 25% 100% |
| 7 | The corporate tax rate applicable is 30%. |
| 8 | The company has to exhaust internally generated funds before raising extra funds from external sources. |