Excel Solutions - Chapter 05

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

This preview shows pages 1–7. 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
This is the end of the preview. Sign up to access the rest of the document.

## This note was uploaded on 05/26/2010 for the course BUSINESS A 139 taught by Professor Cheng during the Spring '09 term at 東京大学.

### Page1 / 21

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

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

View Full Document
Ask a homework question - tutors are online