1. Allen Auto Group owns corner property that can serve as a parking lot for cus
ID: 383786 • Letter: 1
Question
1. Allen Auto Group owns corner property that can serve as a parking lot for customers. The parking lot can be made of concrete or asphalt. Concrete will cost $375K initially, have an estimated monthly maintenance cost of $200 starting at the end of the first month of the eighth year, and will last for 20 years. Asphalt is cheaper to install at $250K, costs $700 per month starting at the end of the second year, and will last 10 years and. Using MARR=12% per year compounded quarterly and a 20 year planning horizon, should the parking lot be of concrete or asphalt? a. Use present worth analysis to solve the problem assuming that the projects may be repeated. Solve the problem using the factors. Make sure to explicitly recommend one of the options. (ANS: $- 381,930.16 vs. $-371.961.09 – select asphalt) b. Compute the 10 year annual equivalent for the asphalt option using the factors. (ANS: $-51,526.73) c. Compute the 20 year annual equivalent for the asphalt option using the factors assuming that the project can be repeated with the same costs and compare it to the results in part b. (ANS: $-51,526.73) d. Solve the problem using the Rate of Return Analysis. (ANS: i* = 0.91%, select asphalt)1. Allen Auto Group owns corner property that can serve as a parking lot for customers. The parking lot can be made of concrete or asphalt. Concrete will cost $375K initially, have an estimated monthly maintenance cost of $200 starting at the end of the first month of the eighth year, and will last for 20 years. Asphalt is cheaper to install at $250K, costs $700 per month starting at the end of the second year, and will last 10 years and. Using MARR=12% per year compounded quarterly and a 20 year planning horizon, should the parking lot be of concrete or asphalt? a. Use present worth analysis to solve the problem assuming that the projects may be repeated. Solve the problem using the factors. Make sure to explicitly recommend one of the options. (ANS: $- 381,930.16 vs. $-371.961.09 – select asphalt) b. Compute the 10 year annual equivalent for the asphalt option using the factors. (ANS: $-51,526.73) c. Compute the 20 year annual equivalent for the asphalt option using the factors assuming that the project can be repeated with the same costs and compare it to the results in part b. (ANS: $-51,526.73) d. Solve the problem using the Rate of Return Analysis. (ANS: i* = 0.91%, select asphalt)
1. Allen Auto Group owns corner property that can serve as a parking lot for customers. The parking lot can be made of concrete or asphalt. Concrete will cost $375K initially, have an estimated monthly maintenance cost of $200 starting at the end of the first month of the eighth year, and will last for 20 years. Asphalt is cheaper to install at $250K, costs $700 per month starting at the end of the second year, and will last 10 years and. Using MARR=12% per year compounded quarterly and a 20 year planning horizon, should the parking lot be of concrete or asphalt? a. Use present worth analysis to solve the problem assuming that the projects may be repeated. Solve the problem using the factors. Make sure to explicitly recommend one of the options. (ANS: $- 381,930.16 vs. $-371.961.09 – select asphalt) b. Compute the 10 year annual equivalent for the asphalt option using the factors. (ANS: $-51,526.73) c. Compute the 20 year annual equivalent for the asphalt option using the factors assuming that the project can be repeated with the same costs and compare it to the results in part b. (ANS: $-51,526.73) d. Solve the problem using the Rate of Return Analysis. (ANS: i* = 0.91%, select asphalt) 1. Allen Auto Group owns corner property that can serve as a parking lot for customers. The parking lot can be made of concrete or asphalt. Concrete will cost $375K initially, have an estimated monthly maintenance cost of $200 starting at the end of the first month of the eighth year, and will last for 20 years. Asphalt is cheaper to install at $250K, costs $700 per month starting at the end of the second year, and will last 10 years and. Using MARR=12% per year compounded quarterly and a 20 year planning horizon, should the parking lot be of concrete or asphalt? a. Use present worth analysis to solve the problem assuming that the projects may be repeated. Solve the problem using the factors. Make sure to explicitly recommend one of the options. (ANS: $- 381,930.16 vs. $-371.961.09 – select asphalt) b. Compute the 10 year annual equivalent for the asphalt option using the factors. (ANS: $-51,526.73) c. Compute the 20 year annual equivalent for the asphalt option using the factors assuming that the project can be repeated with the same costs and compare it to the results in part b. (ANS: $-51,526.73) d. Solve the problem using the Rate of Return Analysis. (ANS: i* = 0.91%, select asphalt)
Explanation / Answer
a) MARR is compounded quarterly, so we use quarter as unit of time for calculations
Planning horizon, n = 20*4 = 80 quarters
Interest rate = 12%/4 = 3% per quarter
Quarterly maintenance cost = 200*3 = $ 600.
Quarterly maintenance cost for the first 7 years is 0 . it starts from the first quarter of 8th year. Therefore, subtract the compound interest factor for 7 years (28 qtrs) = (P/A,3%,28) from that of 20 years (80 qrtrs) = (P/A,3%,80)
Present Value the lifecycle cost of Concrete = -375000 + (-600)*((P/A,3%,80) - (P/A,3%,28))
where compound interest factors, (P/A,3%,80) = 30.201, (P/A,3%,28) = 18.764
PV of concrete = -375000 + (-600)*(30.201-18.764) = $ -381,862.20
Life of Asphalt is 10 years, versus 20 years of concrete. Therefore, we consider 2 cycles of Asphlat.
PV of Asphalt = -250000 + (-700*3)*((P/A,3%,40) - (P/A,3%,4)) + (-250000*(P/F,3%,40) + (-700*3)*((P/A,3%,80) - (P/A,3%,44))
= -250000 + (-2100)*(23.115 - 3.717) + (-250000*0.3066 + (-2100)*(30.201 - 24.519)
= -379318
Present worth of the cost of Asphalt option is less. Therefore, Asphalt is recommended.
b) 10 yr PV of Asphalt = -250000 + (-2100)*(23.115 - 3.717) = 290,735.8
10 yr Annual equivalent for Asphalt option = -290735.8 * (A/P,12%,10) = -290735.8*0.177 = -51,460.24
c) 20 year annual equivalent for asphalt option = -379318*(A/P,12%,20) = -379318*0.1339 = -50,790.68
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.