Determine the equivalent annual worth for years 1 through 10 of a uniform series of payments of $20,000 that begins in year 3 and ends in year 10. Use an interest rate of 10% per year. Also, write the single-cell spreadsheet function to find A.

What will be an ideal response?


Find F in year 10 and then convert to A in years 1-10

F = 20,000(F/A,10%,8)
= 20,000(11.4359)
= $228,718

A = 228,718(A/F,10%,10)
= 228,718(0.06275)
= $14,352

Spreadsheet function: = PMT(10%,10,,FV(10%,8,20000))

Trades & Technology

You might also like to view...

Name three famous people who are former FFA members

What will be an ideal response?

Trades & Technology

Denitrification completes the nitrogen cycle by converting nitrate ions to nitrogen gas, which filters

out of the soil.

Indicate whether the statement is true or false.

Trades & Technology

Metric nut strength is indicated by ________

A) Lines B) Dimples C) Both A and B D) Neither A nor B

Trades & Technology

A rain-sense wiper system uses a rain sensor that is usually mounted ________

A) Inside of the windshield at the top B) On the roof C) Outside of the windshield at the top D) Behind the grille

Trades & Technology