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

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

View Full Document Right Arrow Icon
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."
Background image of page 1

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

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

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

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

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 Right Arrow Icon
Ask a homework question - tutors are online