{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Exercises 1,2

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

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

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

{[ snackBarMessage ]}