Excel Solutions - Chapter 05

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

Info iconThis preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 5 Problems 1-20 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
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
Background image of page 5

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

View Full DocumentRight Arrow Icon
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
Background image of page 6
Image of page 7
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 Right Arrow Icon
Ask a homework question - tutors are online