Ch2_3-Gradients_Compounding handout

Ch2_3-Gradients_Compounding handout - A B C D E...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 9 AB C D E F G H I J 10 year bridge repair plan Linear Gradient Input (x1000) rate, i 0.05 gradient, G 20 Period A G Total PV PV Formula FV FV Formula 1 500 0 500 $476.19 = PV($B$5,A9,,D9) $775.66 = FV($B$5,$A$18 A9,,D9) 2 500 20 520 $471.66 = $768.28 = 3 500 40 540 $466.47 = $759.83 = 4 500 60 560 $460.71 = $750.45 = 5 500 80 580 $454.45 = $740.24 = 6 500 100 600 $447.73 = $729.30 = 7 500 120 620 $440.62 = $717.73 = 8 500 140 640 $433.18 = $705.60 = 9 500 160 660 $425.44 = $693.00 = 10 500 180 680 $417.46 = $680.00 = 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 sum= $4,493.91 = SUM(E9:E18) $7,320.10 = SUM(H9:H18) Equivalent Annual Costs = $581.98 = PMT($B$5,10,E20) 800 700 600 500 400 300 200 100 0 Withdrawls Withdrawls
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 AB C D E F G H I J 10 year bridge repair plan Geometric Gradient (4%) Input (x1000) rate, i 0.05 gradient, g 0.04 First Cost, A 1 500 Period Begin G End PV PV Formula FV FV Formula 1 500.00 $0.00 $500.00 $476.19 = =PV($B$5,A10,,D10) $775.66 = =FV($B$5,$A$19 A10,,D10) 2 500.00 $20.00 $520.00 $471.66 = $768.28 = 3 520.00 $20.80 $540.80 $467.16 = $760.96 = 4 540.80 $21.63 $562.43 $462.71 = $753.71 = 5 562.43
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 04/03/2012 for the course ENGIN 106 taught by Professor Fizali during the Spring '12 term at Laney College.

Page1 / 4

Ch2_3-Gradients_Compounding handout - A B C D E...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online