Chapter 18
Problems 5, 6
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
Calculating Payback
Payback Period:
Payback Year 1:
Payback Year 2:
Payback Year 3:
Payback Year 4:
Pay back into Year 3
3.29 Years
$
$
$
$
0.2941176471
Payback Year 1:
Payback Year 2:
Payback Year 3:
Payback Year 4:
Payback Year 5:
Payback Year 6:
Paybac
Chapter 10
Problems 6, 7, 18, 20, 21
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
Chapter 13
Problems 11, 20, 23, 24
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
Chapter 16
Problems 6, 12
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.
T
Chapter 26
Problems 2, 4, 5, 10
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 Ex
Chapter 11
Problems 5, 17
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.
T
Chapter 15
Problems 1, 7
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
one year from now
Dividend
Sell stock for
PV
2
14
total value
$1.67
$11.67
$13.33
required return = 20%
If stock sells for $13.33, I make 20% return.
If stock sells for > $13.33, then I would make less than 20% if I purchased
If stock sells for < $13.33,
CF A
Cumulative CF
0
-60000
1
23000
-37000
2
28000
-9000
3
21000
12000
4
8000
Rule: Accept project if cost recovered in 3 years.
CF A
CF B
Accept
Reject
within 3 years
Not within 3 years
CF B
Cumulative CF
-70000
15000
-55000
18000
-37000
26000
-11000
230
Ch. 5 Problems
6
Future Value
Present Value
Time (Nper)
Solve for Rate
$
$
300,000
65,000
18
8.87% <= use RATE function
9
Future Value
Present Value
Rate
Solve for Nper
190000
40000
4.80%
33.23 <= use Nper function
It will take over 33 years to save up fo
Ch 7 Problems
3
It doesn't matter that this says Euros; we can calculate it the same as if it were dollars.
Since they are asking us to solve for the current price, we are looking for the present value.
The par value of 1,000 is also the future value sinc