Chapter_04_HWK

# Chapter_04_HWK - \$ FV of bond account \$ Total account FV \$...

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

Chapter 4 Problems 10, 23, 26, 34, 39 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 "Tools|Add-Ins" and select "Analysis ToolPak and "Solver Add-In."

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

View Full Document
k"
Chapter 4 Question 10 Input area: Present value \$1,900 Years Rate a. 5 12% b. 3 10% c. 10 5% d. 8 7% Output area: a. Future value \$3,462.03 b. Future value \$2,564.73 c. Future value \$3,132.57 d. Future value \$3,326.28

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

View Full Document
Chapter 4 Question 23 Input area: Monthly stock investment Monthly bond investment Stock return Bond return Years to save Retirement return Retirement years Output area: FV of stock account

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

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: \$- FV of bond account \$- Total account FV \$- Monthly withdrawal #VALUE! Chapter 4 Question 26 Input area: First cash flow Years until first payment Growth rate Discount rate Output area: Value one period before first payment #DIV/0! Value today #DIV/0! Chapter 4 Question 34 Input area: Current salary Salary percent saved Return Salary increase Deposit length Output area: Next year's salary \$- Next year's deposit \$- Present value deposits #DIV/0! Future value of deposits #DIV/0! Chapter 4 Question 39 Input area: PV of cash flows Year Cash flow 1 2 3 4 Discount rate Output area: Year PV 1 \$- 2 \$- 3 \$- 4 \$- Total \$- PV of missing CF \$- Value of missing CF \$-...
View Full Document

{[ snackBarMessage ]}

### Page1 / 7

Chapter_04_HWK - \$ FV of bond account \$ Total account FV \$...

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

View Full Document
Ask a homework question - tutors are online