Chapter 4 Excel

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.”
Chapter 4
Question 10

Input area:
Present value $1,900
Years Rate
a. 7 12%
b. 5 10%
c. 12 5%
d. 10 7%

Chapter 4
Question 23

Input area:

Monthly stock investment $800
Monthly bond investment $350
Stock return 11%
Bond return 6%
Years to save 30
Retirement return 8%
Retirement years 25

Chapter 4
Question 26

Input area:

First cash flow $175,000
Years until first payment 2
Growth rate 3.5%
Discount rate 19.0%

Chapter 4
Question 34

Input area:

Current salary $65,000
Salary percent saved 5%
Return 10%
Salary increase 4%
Deposit length 40

Chapter 4
Question 39

Input area:

PV of cash flows $7,300
Year Cash flow
1 $1,500
2
3 $2,700
4 $2,900

Discount rate 8%