{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Ch2_3-Gradients_Compounding handout

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

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 A B 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 = 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

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

View Full Document
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 A B 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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern