Chapter 11
Problems 1-30
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.”
Chapter 11
Question 1
Input area:
Output area:
Chapter 11
Question 2
Input area:
Output area:
Chapter 11
Question 3
Input area:
Output area:
Chapter 11
Question 5
Input area:
Projected VC change (1.00)$
Output area:
a. Depreciation per year 115,500$
Accounting breakeven 62,700
b. Base OCF 235,425$
Base NPV 132,427.67$
New quantity 80,000
For a sales change of (500)
the NPV would change (21,875.69)$
If variable costs change by (1.00)$
then OCF would change by 48,750.00$
b. New quantity for calculation 80,000
Chapter 11
Question 6
Input area:
Output area:
Annual depreciation $115,500
Chapter 11
Question 7
Input area:
Output area:
Chapter 11
Question 8
Input area:
Output area:
Chapter 11
Question 9
Input area:
Price per unit 62.00$
Output area:
Chapter 11
Question 10
Input area:
Output area:
Price 38.15$
Chapter 11
Question 11
Input area:
Output area:
Chapter 11
Question 12
Input area:
Initial output level 73,000
Output area:
Chapter 11
Question 13
Input area:
Output area:
Chapter 11
Questions 14,15
Input area:
Output area: