Financial ManagementTU Board 2023
Financial manager has responsibility to perform various financial decisions of any business company. Suppose you are BBA graduates from Tribhuvan University with finance specialization. Kathmandu…
Financial manager has responsibility to perform various financial decisions of any business company. Suppose you are BBA graduates from Tribhuvan University with finance specialization. Kathmandu Manufacturing Company (KMC) has just appointed you as financial manager and your responsibilities are to make financial planning and forecasting, capital investment, financing, working capital and dividend decisions, dealing with financial markets, managing financial risk, controlling of financial resources etc. At present, the Chief Financial Officer (CFO) of KMC asks you to analyze two proposed projects: Project A and Project B with their expected cash flows for the sound capital investment decisions. Initial cost of each project is Rs 1,000,000. The cost of capital of each project is 10 percent. The expected net cash flows of each project are as follows: YearCash Flow of Project A (Rs)Cash Flow of Project B (Rs)0(1,000,000)(1,000,000)1700,000950,0002700,000750,0003700,000300,000 Based on the above information, you are asked to answer the following questions: a. Calculate payback period of each project. b. Calculate net present value (NPV) of each project. Which project/projects should be accepted based on NPV if projects are independent? c. Calculate internal rate of return (IRR) of each project. Which project should be accepted based on IRR if projects are mutually exclusive? d. What are the merits and demerits of payback period, net present value, and internal rate of return?
Answer
a. Payback Period Calculation
The payback period is the time required to recover the initial investment from the project’s cash flows.
Project A
- Year 0: -Rs 1,000,000
- Year 1: Rs 700,000 (Cumulative: -1,000,000 + 700,000 = -Rs 300,000)
- Year 2: Rs 700,000 (Cumulative: -300,000 + 700,000 = Rs 400,000)
Since the investment is recovered between Year 1 and Year 2, we calculate the exact payback period:
Project B
- Year 0: -Rs 1,000,000
- Year 1: Rs 950,000 (Cumulative: -1,000,000 + 950,000 = -Rs 50,000)
- Year 2: Rs 750,000 (Cumulative: -50,000 + 750,000 = Rs 700,000)
The investment is recovered between Year 1 and Year 2:
b. Net Present Value (NPV) Calculation
NPV is calculated using the formula: where .
Project A
Project B
Decision Rule (Independent Projects): Since both projects have positive NPV, both should be accepted.
c. Internal Rate of Return (IRR) Calculation
IRR is the discount rate that makes NPV = 0. We solve for in:
Project A
Using the IRR formula (or financial calculator):
Project B
Decision Rule (Mutually Exclusive Projects): Since Project A has a higher IRR (30.23%), it should be selected.
d. Merits and Demerits of Payback Period, NPV, and IRR
| Criteria | Payback Period | Net Present Value (NPV) | Internal Rate of Return (IRR) |
|---|---|---|---|
| Merits | - Simple and easy to understand. | - Considers time value of money. | - Considers time value of money. |
| - Useful for liquidity assessment. | - Directly indicates project profitability. | - Provides a percentage return rate. | |
| - Ignores cash flows after payback. | - Works well for independent projects. | - Useful for comparing projects. | |
| Demerits | - Ignores time value of money. | - Requires cost of capital estimation. | - May have multiple IRRs. |
| - Does not consider profitability. | - Cannot rank mutually exclusive projects. | - Assumes reinvestment at IRR. | |
| - Biased against long-term projects. | - Sensitive to discount rate changes. | - May not exist for unconventional cash flows. |
Python Code for NPV and IRR Calculation
import numpy_financial as npf
# Cash Flows for Project A
CF_A = [-1000000, 700000, 700000, 700000]
NPV_A = npf.npv(0.10, CF_A[1:]) - abs(CF_A[0])
IRR_A = npf.irr(CF_A)
# Cash Flows for Project B
CF_B = [-1000000, 950000, 750000, 300000]
NPV_B = npf.npv(0.10, CF_B[1:]) - abs(CF_B[0])
IRR_B = npf.irr(CF_B)
print(f"NPV of Project A: Rs {NPV_A:.2f}")
print(f"IRR of Project A: {IRR_A:.2%}")
print(f"NPV of Project B: Rs {NPV_B:.2f}")
print(f"IRR of Project B: {IRR_B:.2%}")
How it works:
- Uses
numpy_financialto compute NPV and IRR for given cash flows. - Inputs are structured as a list of cash flows (including Year 0).
- Outputs NPV and IRR for both projects.
Discussion
Loading…