You have posted 6 sub parts and I am answering for the first 4 sub parts. If you want answers for the other parts post the question with unanswered parts.
1. Calculation of Payback period for each project:
For Product A, Initial investment is $ 190,000
Formula for Payback period =
Payback period =
= 2.714 years
For Product B, initial investment is $ 400,000
Payback period =
= 2.86 years
Working note:
Calculation of Initial Cash inflow,
Particulars | Product A | Product B |
---|---|---|
Sales | 270,000 | 370,000 |
Less: | ||
Variable cost | (128,000) | (178,000) |
Depreciation | (38,000) | (80,000) |
Fixed Operating cost | (72000) | (52000) |
Net Income | 32,000 | 60,000 |
Add: | ||
Depreciation | 38000 | 80000 |
Net Cash Inflow | 70000 | 140000 |
2. Calculation of Net Present value for each Product
For product A,
Initial investment = $ 190,000
Annual cash inflow = $ 70,000
Discounting rate @17% for 5 years = 3.199 or 3.20
Present value of Cash inflow = 70,000* 3.20
= $ 224,000
Net present value = Pv of Cash inflows - Pv of Cash outflows
= 224,000 - 190,000
= $ 34,000
For Product B,
Initial Investment = $ 400,000
Annual cash inflow = $ 140,000
Discounting rate at 17% for 5 years = 3.20
Present value of cash inflows = 140,000 * 3.20
= $ 448,000
Net Present value = 448,000 - 400,000
= $ 48,000
3. Calculation of internal rate of return for each product
Internal rate of return is defined at 2 present value factors where Npv is zero.
We have given discounting factor at 17% (lower discount rate) and I assume 2nd factor as 19%(higher discount rate) .
For product A
Cash inflow = $ 70,000
Discounting factor at 19% for 5 years = 3.05
Present value of cash inflows = Cash inflow * 3.05
= 70,000 * 3.05
= $ 213,500
Present value of Cash outflow = 190,000
NPV for Product A @19% = 213,500 - 190,000
= $ 23,500
NPV for Product A @ 17% = 34,000
Formula for calculating Internal rate of return
=+
where, = lower discount rate @ 17%
= higher discount rate @ 19%
= NPV at
= NPV at
Hence, IRR = 17% +
= 17 +
= 17 + 3.24(2)
= 17 + 6.48
= 23.48%
At 23.48% Npv will be zero.
For Product B,
Cash inflow = $ 140,000
Discounting factor at 19% for 5 years = 3.05
Present value of cash inflows = 140,000 * 3.05
= $ 427,000
Present value of cash outflow = $ 400,000
NPV @19% = 427,000- 400,000
= $ 27,000
NPV @ 17% = $ 48000
IRR for Product B,
= 17% +
= 17 +
= 17 - 2.29(2)
= 17 - 4.58
= 12.42
4. Calculation of Probability Index for two products
Probability Index =
For Product A,
Present value of Cash inflows = 224,000
Cash outflow = 190,000
Probability index =
= 1.18
For Product B,
Present value of cash inflows = $ 448,000
Cash outflow = 400,000
Probability index =
= 1.12
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 19% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B $190,000 $400,000 Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 25 % each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment Cost of equipment (zero salvage value) 370,000 530,000 Annual revenues and costs:...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 19% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 190,000 $ 400,000 Annual revenues and costs:...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five-year period. His annual pay raises are determined by his division’s return on investment (ROI), which has exceeded 20% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment: Cost of equipment (zero salvage value) $ 250,000 $ 460,000 Annual revenues and costs:...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 19% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B $190,000 $400,000 Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 21% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B $270,000 $480,000 Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs: Sales...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 25% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B Initial investment:Cost of equipment (zero salvage value)$ 340,000 $ 525,000Annual revenues and costs:Sales revenues $ 380,000$ 480,000Variable expenses$ 172,00$ 225,000Depreciation expense $...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 23% each of the E last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B $ 390,000 $ 585,000 Initial investment: Cost of equipment (zero salvage value) Annual revenues...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 23% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product Product B $ 290,000 $ 490,000 Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs:...
Lou Barlow, a divisional manager for Sage Company, has an opportunity to manufacture and sell one of two new products for a five- year period. His annual pay raises are determined by his division's return on investment (ROI), which has exceeded 18% each of the last three years. He has computed the cost and revenue estimates for each product as follows: Product A Product B $ 170,000 $380,000 Initial investment: Cost of equipment (zero salvage value) Annual revenues and costs:...