FCF 9th edition Chapter 05

FCF 9th edition Chapter 05 - Chapter 5 Problems 1-20 Input...

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 NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK."
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 8% Deposit $5,000 # of years 10 Output area: Compound interest $10,794.62 Simple interest $9,000.00 Difference $1,794.62
Background image of page 2
Chapter 5 Question 2 Input area: Output area: Present value Years Interest rate Future value $2,250 11 10% $6,419.51 8,752 7 8% $14,999.39 76,355 14 17% $687,764.17 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 $10,295.65 6 7% $15,451 $21,914.85 7 13% 51,557 $43,516.90 23 14% 886,073 $116,631.32 18 9% 550,164
Background image of page 4
Chapter 5 Question 4 Input area: Output area: Present value Years Interest rate Future value $240 2 11.24% $297 360 10 11.61% 1,080 39,000 15 10.95% 185,382 38,261 30 9.17% 531,618
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 $560 9.63 9% $1,284 810 17.61 10% 4,341 18,400 19.02 17% 364,518 21,500 14.94 15% 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.

Page1 / 21

FCF 9th edition Chapter 05 - Chapter 5 Problems 1-20 Input...

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