{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Excel Solutions - Chapter 05

# Excel Solutions - Chapter 05 - Chapter 5 Problems 1-20...

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

Chapter 5 Problems 1-20 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green

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

View Full Document
Chapter 5 Question 1 Input area: Interest rate 7% Deposit \$5,000 # of years 10 Output area: Compound interest \$9,835.76 Simple interest \$8,500.00 Difference = \$1,335.76
Chapter 5 Question 2 Input area: Output area: Present value Years Interest rate Future value \$2,250 19 10% \$13,760.80 9,310 13 8% \$25,319.70 76,355 4 22% \$169,151.87 183,796 8 7% \$315,795.75

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

View Full Document
Chapter 5 Question 3 Output area: Input area: Present value Years Interest rate Future value \$11,529.77 6 5% \$15,451 \$20,154.91 9 11% 51,557 \$29,169.95 23 16% 886,073 \$24,024.09 18 19% 550,164
Chapter 5 Question 4 Input area: Output area: Present value Years Interest rate Future value \$265 2 7.63% \$307 360 9 10.66% 896 39,000 15 9.97% 162,181 46,523 30 8.12% 483,500

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

View Full Document
Chapter 5 Question 5 Input area: Output area: Present value Years Interest rate Future value \$625 9.36 8% \$1,284 810 24.81 7% 4,341 18,400 16.19 21% 402,662 21,500 8.20 29% 173,439
Chapter 5 Question 6 Input area: Output area: Present value Years Interest rate Future value \$43,000 18 10.27% \$250,000

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

View Full Document
Chapter 5 Question 7 Input area: Output area: Present value Years Interest rate Future value \$1.00 10.24 7% \$2.00 1.00 20.49 7% 4.00
Chapter 5 Question 8 Input area: Output area: Present value Years Interest rate Future value \$21,608 5 5.94% \$28,835

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 21

Excel Solutions - Chapter 05 - Chapter 5 Problems 1-20...

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

View Full Document
Ask a homework question - tutors are online