In: Finance
?(Equivalent annual annuity?) Rib? & Wings-R-Us is considering the purchase of a new smoker oven for cooking? barbecue, ribs, and wings. It is looking at two different ovens. The first is a relatively standard smoker and would cost $ 52,000 last for 9 ?years, and produce annual cash flows of $ 18,000 per year. The alternative is the? deluxe, award-winning? Smoke-alator, which costs $ 78,000 and, because of its patented humidity? control, produces the? "moistest, tastiest barbecue in the? world." The? Smoke-alator would last for 13 years and produce cash flows of $ 24,000 per year. Assuming a required rate of return of 11 percent on both? projects, compute their equivalent annual annuities (EAAs?).
Discount rate | 11.0000% | ||
Cash flows | Year | Discounted CF= cash flows/(1+rate)^year | Cumulative cash flow |
(52,000.00) | 0 | (52,000.00) | (52,000.00) |
18,000.000 | 1 | 16,216.22 | (35,783.78) |
18,000.000 | 2 | 14,609.20 | (21,174.58) |
18,000.000 | 3 | 13,161.44 | (8,013.14) |
18,000.000 | 4 | 11,857.16 | 3,844.02 |
18,000.000 | 5 | 10,682.12 | 14,526.15 |
18,000.000 | 6 | 9,623.54 | 24,149.68 |
18,000.000 | 7 | 8,669.85 | 32,819.53 |
18,000.000 | 8 | 7,810.68 | 40,630.21 |
18,000.000 | 9 | 7,036.65 | 47,666.86 |
PV = 47,666.86, FV = 0, N = 9, rate = 11%
Use PMT function in Excel
EAA = 8,608.71
Discount rate | 11.0000% | ||
Cash flows | Year | Discounted CF= cash flows/(1+rate)^year | Cumulative cash flow |
(78,000.00) | 0 | (78,000.00) | (78,000.00) |
24,000.000 | 1 | 21,621.62 | (56,378.38) |
24,000.000 | 2 | 19,478.94 | (36,899.44) |
24,000.000 | 3 | 17,548.59 | (19,350.85) |
24,000.000 | 4 | 15,809.54 | (3,541.30) |
24,000.000 | 5 | 14,242.83 | 10,701.53 |
24,000.000 | 6 | 12,831.38 | 23,532.91 |
24,000.000 | 7 | 11,559.80 | 35,092.71 |
24,000.000 | 8 | 10,414.24 | 45,506.95 |
24,000.000 | 9 | 9,382.19 | 54,889.14 |
24,000.000 | 10 | 8,452.43 | 63,341.57 |
24,000.000 | 11 | 7,614.80 | 70,956.37 |
24,000.000 | 12 | 6,860.18 | 77,816.55 |
24,000.000 | 13 | 6,180.34 | 83,996.89 |
PV = 83,996.89, FV = 0, N = 13 , rate =11%
use PMT funciton in Excel
EAA = 12,444.22
so the second one is better