A water distribution company wants to purchase a new pump. The purchase price of

Question

A water distribution company wants to purchase a new pump. The purchase price of the pump is $278,993. The company will put 12.5% down on the pump at the time of purchase and finance the payment of the remaining balance with a 5 year loan having an APR of 6%. Electrical costs will start at $24,599 and increase each year by $567. The average O&M costs are estimated to be $3800 per year. The pump will have a $28,000 salvage value at the end of the 10 year life of the pump. Prepare an annual cash flow table for the annual cost of ownership of the pump for its 10 year life. This cash flow analysis assumes that the loan for the pump is paid off at the end of 5 years and those payments terminate at that point. All other cash flows continue. Only the loan payments terminate.

please show all work

Explanation / Answer

Purchase Price $278,993 down payment 12.50% Down payment 34,874.13 Loan for the pump 244,118.87 Total loan amount paid at the end of 5 years 326,686.11 Loan payment each year for 5 years 65,337.22 Electrial costs per year Increase each year Operation & maintenance costs per year Start $24,599 $567 $3,800 1 $25,166 $567 $3,800 2 $25,733 $567 $3,800 3 $26,300 $567 $3,800 4 $26,867 $567 $3,800 5 $27,434 $567 $3,800 6 $28,001 $567 $3,800 7 $28,568 $567 $3,800 8 $29,135 $567 $3,800 9 $29,702 $567 $3,800 10 $30,269 $567 $3,800 Salvage value $28,000 Loan for the pump Annual cash flows table Cash flows 1 93,736.32 2 94303.32 3 94,870.32 4 95,437.32 5 96,004.32 6 $31,801 7 $32,368 8 $32,935 9 $33,502 10 $34,069

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.