A) Pay-Back Period Calculation
The pay-back period is the time it takes for the initial investment to be recovered through cash inflows generated by the project.
Initial Investment: $320,000 Annual Cash Inflow (Contribution Margin): $200,000 * 0.40 = $80,000
Pay-Back Period = Initial Investment / Annual Cash Inflow = $320,000 / $80,000 = 4 years
Description: The pay-back period indicates that it will take 4 years to recover the initial investment of $320,000. This measure is useful for assessing the liquidity of the investment and the risk associated with the time it takes to recover the initial outlay.
B) Net Present Value (NPV) Calculation
Initial Investment: $320,000 Annual Cash Inflow (Contribution Margin): $80,000 Salvage Value: $20,000 Required Rate of Return: 18%
NPV Calculation: 1. Discount the annual cash inflows: Year 1-6: $80,000 / (1 + 0.18)^n Sum of discounted cash inflows = $80,000 * [1 - (1 / 1.18^6)] / 0.18 ≈ $293,017.84
-
Discount the salvage value: Year 6: $20,000 / (1 + 0.18)^6 ≈ $7,988.85
-
Calculate NPV: NPV = -$320,000 + $293,017.84 + $7,988.85 ≈ -$18,993.31
Decision: Reject the proposal because the NPV is negative.
C) Internal Rate of Return (IRR) Calculation
Initial Investment: $320,000 Annual Cash Inflow (Contribution Margin): $80,000 Salvage Value: Ignored
IRR Calculation: 1. Set up the equation: $320,000 = $80,000 * [1 - (1 / (1 + IRR)^6)] / IRR
- Solve for IRR: Using a financial calculator or trial and error, the IRR is approximately 15.24%.
Decision: If the required rate of return is 18%, reject the proposal because the IRR (15.24%) is less than the required rate.
D) Net Present Value (NPV) Calculation with Tax
Initial Investment: $320,000 Annual Cash Inflow (Contribution Margin): $80,000 Salvage Value: $20,000 Tax Rate: 30% Depreciation: Straight-line to zero over 6 years = $320,000 / 6 = $53,333.33 per year Tax Shield from Depreciation: $53,333.33 * 0.30 = $16,000 per year
After-Tax Cash Inflow: $80,000 - ($80,000 * 0.30) + $16,000 = $72,000 per year
NPV Calculation: 1. Discount the annual after-tax cash inflows: Year 1-6: $72,000 / (1 + 0.18)^n Sum of discounted cash inflows ≈ $263,716.06
-
Discount the salvage value (after tax): Year 6: $20,000 * (1 - 0.30) = $14,000 Discounted salvage value ≈ $5,592.19
-
Calculate NPV: NPV = -$320,000 + $263,716.06 + $5,592.19 ≈ -$50,691.75
Decision: Reject the proposal because the NPV is negative.