Solve Problem using Excel.


PW = NPV (0.08, -7000, -7000, -5000, -5000, -5000, 2000, 2000, 5000, 5000, -
7000)
= ?$19,142.52
or
PW = PV(0.08, 5,7000)+(PV(0.08, 2, 0, -PV(0.08, 5,-2000))+PV(0.08, 7, 0,-PV(0.08, 2,-5000))+PV(0.08, 10, 0, 7000)) = ?$19,142.52
AW = PMT(0.08, 10, -(PV(0.08, 5,7000)+(PV(0.08, 2, 0, -PV(0.08, 5,-2000))+PV(0.08, 7, 0,-PV(0.08, 2,-5000))+PV(0.08, 10, 0, 7000)))) = ?$2,852.80
FW = FV(0.08, 10, 0,-( PV(0.08, 5,7000)+(PV(0.08, 2, 0, -PV(0.08, 5,-2000))+PV(0.08, 7, 0,-PV(0.08, 2,-5000))+PV(0.08, 10, 0, 7000)))) = ?$41,327.28

Trades & Technology

You might also like to view...

What diameter is designated by 1/4-20 UNC - RH?

a. 1?4 inch b. 1 cm c. 4 mm d. 20 mm

Trades & Technology

How many tie-downs are required for a 20-foot load?

Trades & Technology

Technician A says that a MacPherson strut typically does not include the spring as part of the strut assembly. Technician B says that a modified strut typically does not include the spring as part of the strut assembly. Which technician is correct?

A) Technician A only B) Technician B only C) Both technicians D) Neither technician

Trades & Technology

____ homes combine techniques of both traditional framing and mass production to reduce costs, improve quality, shorten the construction cycle, and minimize weather damage to structural components.

A. Modular B. Panelized C. Manufactured D. Assembled

Trades & Technology