Copy of FCF 9th edition Chapter 05

Copy of FCF 9th edition Chapter 05 - Chapter 5 Problems...

Info iconThis preview shows pages 1–6. 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 Document Right 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 Document Right 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
Question 4 Input area:
Background image of page 5

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

View Full Document Right Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

Page1 / 21

Copy of FCF 9th edition Chapter 05 - Chapter 5 Problems...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online