FCF 9th edition Chapter 05

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

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

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

View Full Document
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
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

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

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 \$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
This is the end of the preview. Sign up to access the rest of the document.

## 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
Ask a homework question - tutors are online