Math Problem Statement
Q. PQR Ltd. is considering the purchase of new machine. Two alternative machines have been suggested, cash costing 4,00,000 and requiring 30,000 as additional working capital at the end of the 1st year. EAT are expected to be as follows: Year Machine A ( Rs.) Machine B (Rs.) 1 40000 120000 2 120000 160000 3 160000 200000 4 240000 120000 5 160000 80000 Total 720000 680000
The company has a target return on capital of 10%, you are required to select the most profitable machine on the N. P. V. method.
Solution
To solve this problem using the Net Present Value (NPV) method, we need to discount the expected net cash inflows for both machines at the company's required rate of return (10%) and then compare the two NPVs. The machine with the higher NPV will be considered more profitable.
Steps to calculate NPV:
-
Determine the initial investment:
- For both machines, the initial investment is Rs. 4,00,000.
- Machine A requires Rs. 30,000 as additional working capital at the end of the 1st year.
-
Determine the annual cash inflows:
- The EAT (Earnings After Tax) for each machine is given for 5 years.
-
Discount the cash inflows:
- Using the discount rate of 10%, the formula to calculate the Present Value (PV) of each cash flow is: where is the discount rate (10% or 0.10) and is the year.
-
Calculate the NPV:
Now, let's calculate the NPV for both Machine A and Machine B using the provided data.
Discount Factors for 10% rate:
We will use the following discount factors for 10%:
- Year 1: 0.9091
- Year 2: 0.8264
- Year 3: 0.7513
- Year 4: 0.6830
- Year 5: 0.6209
NPV for Machine A:
-
Cash inflows:
- Year 1: Rs. 40,000
- Year 2: Rs. 1,20,000
- Year 3: Rs. 1,60,000
- Year 4: Rs. 2,40,000
- Year 5: Rs. 1,60,000
-
Additional working capital in year 1: Rs. 30,000
-
Discounted cash inflows:
- Year 1:
- Year 2:
- Year 3:
- Year 4:
- Year 5:
Total discounted cash inflows =
-
Initial investment and working capital = Rs. 4,00,000 + Rs. 30,000 = Rs. 4,30,000
-
NPV for Machine A:
NPV for Machine B:
-
Cash inflows:
- Year 1: Rs. 1,20,000
- Year 2: Rs. 1,60,000
- Year 3: Rs. 2,00,000
- Year 4: Rs. 1,20,000
- Year 5: Rs. 80,000
-
Discounted cash inflows:
- Year 1:
- Year 2:
- Year 3:
- Year 4:
- Year 5:
Total discounted cash inflows =
-
Initial investment = Rs. 4,00,000
-
NPV for Machine B:
Conclusion:
- NPV for Machine A = Rs. 88,004
- NPV for Machine B = Rs. 1,23,208
Since Machine B has a higher NPV, it is the more profitable investment.
Would you like more details on any part of this? Here are some related questions:
- How does the working capital adjustment impact NPV calculations?
- What happens if the discount rate is changed to something other than 10%?
- Can you explain other methods like IRR or payback period for the same scenario?
- What if the company wants to evaluate the risk of the cash flows?
- How would depreciation affect this analysis?
Tip: When calculating NPV, remember that future cash flows are worth less than present cash flows, hence the need for discounting.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Net Present Value (NPV)
Discounting
Cash Flow Analysis
Formulas
NPV = Present Value of cash inflows - Initial Investment
Present Value (PV) = Cash Flow / (1 + r)^t
Theorems
Time Value of Money
Suitable Grade Level
Undergraduate Business/Finance
Related Recommendation
Compare Machines A and B Using NPV with a 10% Discount Rate
NPV Analysis for Machine Investment Decision: Machine A vs. Machine B
Machine Investment Analysis using NPV and Replacement Chain Approach
Net Present Value (NPV) Analysis for Capital Budgeting Decisions: Machine A vs. Machine B
Net Present Value (NPV) Calculation for Machines A and B with 11% Opportunity Cost