In: Finance
A firm is considering replacing the existing industrial air conditioning unit. They will pick one of two units. The first, the AC360, costs $26,468.00 to install, $5,014.00 to operate per year for 7 years at which time it will be sold for $7,062.00. The second, RayCool 8, costs $41,121.00 to install, $2,143.00 to operate per year for 5 years at which time it will be sold for $9,074.00. The firm’s cost of capital is 5.40%. What is the equivalent annual cost of the AC360?
Answer Format: Currency: Round to: 2 decimal places.
AC360 | ||||||||
Discount rate | 5.400% | |||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
Cash flow stream | -26468.000 | -5014.000 | -5014.000 | -5014.000 | -5014.000 | -5014.000 | -5014.000 | 2048.000 |
Discounting factor | 1.000 | 1.054 | 1.111 | 1.171 | 1.234 | 1.301 | 1.371 | 1.445 |
Discounted cash flows project | -26468.000 | -4757.116 | -4513.393 | -4282.156 | -4062.767 | -3854.617 | -3657.132 | 1417.247 |
NPV = Sum of discounted cash flows | ||||||||
NPV AC360 = | -50177.93 | |||||||
Where | ||||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||||
Discounted Cashflow= | Cash flow stream/discounting factor | |||||||
Equvalent annuity(EAA)= | -8797.87 | |||||||
Required rate = | 5.400% | |||||||
Year | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
Cash flow stream | 0.00 | -8797.87 | -8797.87 | -8797.87 | -8797.87 | -8797.87 | -8797.87 | -8797.87 |
Discounting factor | 1.000 | 1.054 | 1.111 | 1.171 | 1.234 | 1.301 | 1.371 | 1.445 |
Discounted cash flows project | 0.000 | -8347.123 | -7919.471 | -7513.730 | -7128.776 | -6763.545 | -6417.025 | -6088.259 |
Sum of discounted future cashflows = | -50177.93 | |||||||
Discounting factor = | (1 + discount rate)^(Corresponding period in years) | |||||||
Discounted Cashflow= | Cash flow stream/discounting factor |