Excel Exercises 1,2

Excel Exercises 1,2 - $17,270.37 $19,004.67 4.5% $8,018.73...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Excel Exercises 1,2 1) B8 C8 "=PMT(($B9/12),(C$8*12),$B$8)"  $20,000.00  2 2.5 3 3.5 4 4.5 5 B9 4.0% ($868.50) ($701.67) ($590.48) ($511.09) ($451.58) ($405.32) ($368.33) 4.5% ($872.96) ($706.12) ($594.94) ($515.56) ($456.07) ($409.83) ($372.86) 5.0% ($877.43) ($710.59) ($599.42) ($520.06) ($460.59) ($414.37) ($377.42) 5.5% ($881.91) ($715.07) ($603.92) ($524.58) ($465.13) ($418.94) ($382.02) 6.0% ($886.41) ($719.58) ($608.44) ($529.12) ($469.70) ($423.54) ($386.66) 6.5% ($890.93) ($724.10) ($612.98) ($533.69) ($474.30) ($428.17) ($391.32) 7.0% ($895.45) ($728.64) ($617.54) ($538.28) ($478.92) ($432.83) ($396.02) 2) B19 C19 "=PV(($B20/12),(C$19*12),$B$19)"  $(350.00) 2 2.5 3 3.5 4 4.5 5 B20 4.0% $8,059.89  $9,976.27  $11,854.77  $13,696.13  $15,501.09 
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $17,270.37 $19,004.67 4.5% $8,018.73 $9,913.36 $11,765.92 $13,577.34 $15,348.53 $17,080.39 $18,773.78 5.0% $7,977.86 $9,851.01 $11,678.00 $13,459.97 $15,198.03 $16,893.28 $18,546.75 5.5% $7,937.29 $9,789.19 $11,590.98 $13,344.00 $15,049.57 $16,708.99 $18,323.49 6.0% $7,897.00 $9,727.92 $11,504.86 $13,229.40 $14,903.11 $16,527.47 $18,103.95 6.5% $7,857.00 $9,667.18 $11,419.62 $13,116.17 $14,758.62 $16,348.69 $17,888.04 7.0% $7,817.28 $9,606.96 $11,335.26 $13,004.29 $14,616.07 $16,172.58 $17,675.70...
View Full Document

This note was uploaded on 11/16/2009 for the course FIN 125 taught by Professor Buell during the Fall '08 term at Lehigh University .

Ask a homework question - tutors are online