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...

What is the proper equation for current I in the circuit below 

A. Vs / 2R B. 2Vs / R C. 2R Vs D. R Vs E. Vs / R

Trades & Technology

Identify the ASME term that is the system of words used to name things in a discipline, description, the list of names, features or terms, and part and assembly designation data presented in a separate list.

What will be an ideal response?

Trades & Technology

After 1905, which group in Russia continued to attack government officials, even after Czar Nicholas II offered concessions and imposed martial law?

a. communists b. liberals c. peasants d. Cossacks

Trades & Technology

In the circuit shown in Figure P3.5, the source and node voltages are


Determine the voltage across each of the five resistors.

Find:
The voltage across each of the five resistors

Trades & Technology