A B
capital investment 50000 65000
annual expenses 9000 8000
annual revenues 22000 24000
salvage value 13000 20000
useful life 8 year 8 year
A_ Calculate the payback period of each alternative and decide the best alternative without taking into account the time value of the money
B- Use conventional benefit cost ratio analysis to define which alternative should be selected.
C-Use modified benefit cost ratio to define which alternative should be selected (MARR %10)
(A)
Payback period (PBP) is the time by when project's cumulative net benefit equals zero.
Annual net benefit (NB) = Annual revenue - Annual expense
Project - A | Project - B | |||||||||
Year | Revenue ($) | Expense ($) | NB ($) | Cumulative NB ($) | Year | Revenue ($) | Expense ($) | NB ($) | Cumulative NB ($) | |
0 | 50,000 | -50,000 | -50,000 | 0 | 65,000 | -65,000 | -65,000 | |||
1 | 22,000 | 9,000 | 13,000 | -37,000 | 1 | 24,000 | 8,000 | 16,000 | -49,000 | |
2 | 22,000 | 9,000 | 13,000 | -24,000 | 2 | 24,000 | 8,000 | 16,000 | -33,000 | |
3 | 22,000 | 9,000 | 13,000 | -11,000 | 3 | 24,000 | 8,000 | 16,000 | -17,000 | |
4 | 22,000 | 9,000 | 13,000 | 2,000 | 4 | 24,000 | 8,000 | 16,000 | -1,000 | |
5 | 24,000 | 8,000 | 16,000 | 15,000 |
PBP of project A lies between years 3 & 4.
PBP, Project A = 3 + (Absolute value of cumulative NB, year 3 / NB, year 4)
= 3 + (11,000 / 13,000) = 3 + 0.85 = 3.85 years
PBP of project B lies between years 4 & 5.
PBP, Project B = 4 + (Absolute value of cumulative NB, year 4 / NB, year 5)
= 4 + (1,000 / 16,000) = 4 + 0.0625 = 4.0625 years
Since Project A has lower PBP, Project A should be selected.
(B)
Conventional benefit-cost ratio = PW of Revenue / (Initial cost + PW of Annual cost - PW of Salvage value)
Project A: [22,000 x P/A(10%, 8)] / [50,000 + 9,000 x P/A(10%, 8) - 13,000 x P/F(10%, 8)]
= (22,000 x 5.3349**) / [50,000+ (9,000 x 5.3349**) - (13,000 x 0.4665**)]
= 117,368 / (50,000 + 48,014 - 6,065)
= 117,368 / 91,949
= 1.28
Project B: [24,000 x P/A(10%, 8)] / [65,000 + 8,000 x P/A(10%, 8) - 20,000 x P/F(10%, 8)]
= (24,000 x 5.3349**) / [65,000+ (8,000 x 5.3349**) - (20,000 x 0.4665**)]
= 128,038 / (65,000 + 42,679 - 9,330)
= 128,038 / 98,349
= 1.30
Since Project B has higher Conventional BCR, Project B should be selected.
(C)
Modified Benefit-cost ratio = (PW of Revenue - PW of Annual cost) / (Initial cost - PW of Salvage value)
Project A: [(22,000 - 9,000) x P/A(10%, 8)] / [50,000 - 13,000 x P/F(10%, 8)]
= (13,000 x 5.3349**) / [50,000 - (13,000 x 0.4665**)]
= 69,354 / (50,000 - 6,065)
= 69,354 / 43,935
= 1.58
Project B: [(24,000 - 8,000) x P/A(10%, 8)] / [65,000 - 20,000 x P/F(10%, 8)]
= (16,000 x 5.3349**) / [65,000 - (20,000 x 0.4665**)]
= 85,358 / (65,000 - 9,330)
= 85,358 / 55,670
= 1.53
Since Project A has higher modified BCR, Project A should be selected.
**From P/A and P/F Factor tables
A B capital investment 50000 65000 annual expenses 9000 8000 annual revenues 22000 24000 salvage value...
4. A manufacturer wants to buy a new machine. He has two alternative technologies. The cash flows of the alternatives are given below Initial Investment Cost Annual Expenses Annual Revenues Salvage Value Useful Life ProjectA 50000 TL 22000 TL 9000 TL Project B 65000 TL 24000 TL 8000 TL 20000 TL 13000 T ears Calculate the payback period of each alternative and decide the best alternative without taking into account the time value of the money. (15 points) A. B....
The following four mutually exclusive alternatives have no salvage value after 10 years. Consider a MARR of 16%. a. Determine the Benefit cost ratio for each option, and the incremental analysis to determine which option should be selected b. Determine the payback period for each option and determine which option should be selected A B С D 8000 6500 6000 9500 Option Initial cost Yearly Benefit $1,195.5 $1,717.2 5 $1,446.3 5 $1,821.2 8 1
Need cash flow diagram 04) Three mutually exclusive alternative are being considered Initial Cost Benefit at the end of the first Year Uniform Annual Benefits at end of subsequent years Useful Life in years $500 $200 $100 $400 $200 $125 $300 $200 $100 At the end of its useful life, an alternative is not replaced. If MARR is 10%, which alternatives should be selected? a) Based on the payback period? b) Based on benefit-cost ratio analysis c) Benefit/Costs Analysis using...
Consider an alternative with the following cash flows. Capital Investment Revenues Annual Expenses Market Value Useful Life MARR = € $45,000 $5000 at the end of the first year increasing by $2000 per year for the next 9 years $2000 $4500 10 years 10% Using ERR, is this a good alternative or a bad alternative? How do you know?
9- Two alternatives with identical benefits are being considered: 49 A B Initial cost $500 $800 Uniform annual cost 200 150 Useful life, in years 8 8 (a) Compute the payback period if Alt. B is purchased rather than Alt. A (b) Use a MARR of 10% and benefit-cost ratio analysis to identify the alternative that should be selected
2) [Problem 9-50) Consider four mutually exclusive alternatives: A B C D Cost $65 $55 $25 $80 Uniform annual benefit 16.3 15.1 2 5. 2 1.3 AL Each alternative has a 6-yeatuseful life and no salvage value. The MARR is 9%. Which alternative should be selected, based on, ? a) The payback period b) Future worth analysis c) Benefit-cost ratio analysis
8-14 A The following four mutually exclusive alternatives have no salvage value after 10 years. A B C D First cost $7500 $5000 $5000 $8500 Uniform annual benefit 1600 1200 1000 1700 Computed rate of return 16.8% 20.2% 15.1% 15.1% (a) Construct a choice table for interest rates from 0% to 100%. (b) Using 8% for the MARR, which alternative should be selected? 9-59 Two equipment investments are estimated as follows: Year 0 - $15,000 5,000 5,000 5,000 5,000 5,000...
please show excel formulas so I can understand the problem THANKS 9-50 Consider four mutually exclusive alternatives: (Α) A B C D Cost $75.0 $50.0 $15.0 $90.0 Uniform annual 18.8 13.9 4.5 23.8 benefit Each alternative has a 5-year useful life and no sal- vage value. The MARR is 10%. Which alternative should be selected, based on (a) The payback period (b) Future worth analysis (c) Benefit-cost ratio analysis
8-14 A The following four mutually exclusive alternatives have no salvage value after 10 years. First cost Uniform annual benefit Computed rate of return $7500 $5000 $5000 $8500 1600 1200 1000 1700 16.8% 20.2% 15.1% 15.1% (a) Construct a choice table for interest rates from 0% to 100%. (b) Using 8% for the MARR, which alternative should be selected?
13. Using benefit-cost ratio analysis, b 5 year useful life, and a 15% MARR, determine which of the following mutually exclusive alternatives should be selected. D 310 380 470 Cost Annual Benefit Salvage/Value Ule OS 8 90