Unlock document.
This document is partially blurred.
Unlock all pages and 1 million more documents.
Get Access
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
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 4
Output area:
Chapter 11
Question 5
Input area:
Projected VC change (1.00)$
Output area:
a. Depreciation per year 115,500$
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:
