Chapter 11 Mini Case: Cash Flow Estimation
Chapter 11 Mini Case: Cash Flow Estimation
Chapter 11 Mini Case: Cash Flow Estimation
Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducte
Johnson, a recently graduated MBA. The production line would be set up in unused space in Shrieves' main plant. The machinery
would be approximately $200,000, another $10,000 in shipping charges would be required, and it would cost an additional $30,000
equipment. The machinery has an economic life of 4 years, and Shrieves has obtained a special tax ruling that places the equipmen
MACRS 3-year class. The machinery is expected to have a salvage value of $25,000 after 4 years of use.
The new line would generate incremental sales of 1,250 units per year for 4 years at an incremental cost of $100 per unit in the first
depreciation. Each unit can be sold for $200 in the first year. The sales price and cost are expected to increase by 3% per year due
Further, to handle the new line, the firm’s net working capital would have to increase by an amount equal to 12% of sales revenues
rate is 40%, and its overall weighted average cost of capital is 10%.
(1.) Should you subtract interest expense or dividends when calculating project cash flow?
(2.) Suppose the firm had spent $100,000 last year to rehabilitate the production line site. Should this be
included in the analysis? Explain.
(3.) Now assume that the plant space could be leased out to another firm at $25,000 per year. Should this be
included in the analysis? If so, how?
(4.) Finally, assume that the new product line is expected to decrease sales of the firm’s other lines by
$50,000 per year. Should this be considered in the analysis? If so, how?
c. Calculate the annual sales revenues and costs (other than depreciation). Why is it important to include
inflation when estimating cash flows?
e. Estimate the required net working capital for each year, and the cash flow due to investments in net working
capital.
g. Calculate the net cash flows for each year. Based on these cash flows, what are the project’s NPV, IRR,
MIRR, and payback? Do these indicators suggest the project should be undertaken?
NPV $29,958,104
IRR 194.5% PV of Inflows TV of Inflows
$42,758,104 $62,602,140
Years
Find MIRR 0 1 2
Net Cash Flows ($12,800,000) $24,400,000 $25,972,000
PV= ($12,800,000)
To find MIRR, we could now find the discount rate that equates the PV and TV. But it is easier to use the MIRR function.
MIRR = 102.8%
Payback = 0.5
h. What does the term ”risk” mean in the context of capital budgeting; to what extent can risk be quantified; and
when risk is quantified, is the quantification based primarily on statistical analysis of historical data or on
subjective, judgmental estimates?
Risk in capital budgeting really means the probability that the actual outcome will be worse than the expected outcome. For examp
a high probability that the expected NPV as calculated above will actually turn out to be negative, then the project would be classifi
risky. The reason for a worse-than-expected outcome is, typically, because sales were lower than expected, costs were higher than e
the project turned out to have a higher than expected initial cost. In other words, if the assumed inputs turn out to be worse than ex
the output will likewise be worse than expected. We use Excel to examine the project's sensitivity to changes in the input variables.
i. (1.) What are the three types of risk that are relevant in capital budgeting?
(2.) How is each of these risk types measured, and how do they relate to one another?
(3.) How is each type of risk used in the capital budgeting process?
(2.) Perform a sensitivity analysis on the unit sales, salvage value, and cost of capital for the project. Assume
that each of these variables can vary from its base-case, or expected, value by plus and minus 10%, 20%, and
30%. Include a sensitivity diagram, and discuss the results.
Here we use an Excel "Data Table" to find the NPVs for changes in unit sales, salvage value, and WACC holding other things const
one variable at a time. This produces the sensitivity analys as shown below.
We summarize the data tables and show the sensitivity analysis graph below:
Sensitivity Analysis
NPV ($)
120,000,000
Units Sold
100,000,000
80,000,000
Salvage Value
60,000,000
40,000,000
20,000,000 WACC
0
-40% -30% -20% -10% 0% 10% 20% 30% 40%
-20,000,000
Range $0 $13,034,193 $0
(3.) What is the primary weakness of sensitivity analysis? What is its primary usefulness?
k. Assume that Sidney Johnson is confident of her estimates of all the variables that affect the project’s cash flows
except unit sales and sales price: If product acceptance is poor, unit sales would be only 900 units a year and the
unit price would only be $160; a strong consumer response would produce sales of 1,600 units and a unit price of
$240. Sidney believes that there is a 25% chance of poor acceptance, a 25% chance of excellent acceptance, and
a 50% chance of average acceptance (the base case).
Scenario analysis extends risk analysis in two ways: (1) It allows us to change more than one variable at a time, hence to see the com
changes in several variables on NPV, and (2) it allows us to bring in the probabilities of changes in the key variables.
(3.) Use the worst-, most likely, and best-case NPVs and probabilities of occurrence to find the project’s expected
NPV, standard deviation, and coefficient of variation.
(3.) Use the worst-, most likely, and best-case NPVs and probabilities of occurrence to find the project’s expected
NPV, standard deviation, and coefficient of variation.
We could find the NPV by entering the value of unit sales and price for each scenario and then recording the NPV (this is what we d
below). Alternatively, we could use Tools, Scenarios to define the inputs for each scenario, which we did and show in the Scenario S
below. In fact, you could even use Tools, Scenarios, and then click the Summary button on the dialog box, and it will automatically
similar to the one below. This is a powerful feature of Excel, and we encourage you to explore it.
Scenario Analysis
Squared Deviation
Scenario Probability Unit Sales Unit Price NPV times Probability
l. Are there problems with scenario analysis? Define simulation analysis, and discuss its principal advantages and
disadvantages.
Monte Carlo simulation is similar to scenario analysis in that different values of key input variables are used. Unlike scenario analy
Carlo simulation draws the input values from specified probability distributions and then computes the NPV. It repeats this proces
even thousands, of times. It then averages the NPVs from each repetition.
(2.) Shrieves typically adds or subtracts 3 percentage points to the overall cost of capital to adjust for risk.
Should the new line be accepted?
The CV of this project is 1.15, which is larger than the CV range of the firm's average project. Consequently, this project is riskier
average project, so management should add 3% to the WACC to risk adjust.
Cost of capital for average projects: 50%
Adjustment for risky projects:
Risk adjusted cost of capital:
flow?
’s other lines by
$29,958,104
e the annual
mportant to include
Year 4
20,000
$2,315.25
$0.00
$46,305,000
0
921,600
$45,383,400
18,153,360
$27,230,040
921,600
$28,151,640
Year 4
$46,305,000
5,556,600
roject’s NPV, IRR,
?
Year 3 Year 4
$27,074,400 $28,151,640
(264,600) 5,556,600
1,752,960
$26,809,800 $35,461,200
Years
3 4
$26,809,800 $35,461,200
40,214,700
58,437,000
82,350,000
TV = $216,462,900
Years
3 4
$26,809,800 $35,461,200
$64,381,800 $99,843,000
an risk be quantified; and
f historical data or on
SALVAGE
Variable NPV
Cost $29,958,104
$29,721,067
29,721,067
29,721,067
29,721,067
29,721,067
Value
0% 40%
lue
ness?
Squared Deviation
times Probability
Quick calculation:
Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducte
Johnson, a recently graduated MBA. The production line would be set up in unused space in Shrieves' main plant. The machinery
would be approximately $200,000, another $10,000 in shipping charges would be required, and it would cost an additional $30,000
equipment. The machinery has an economic life of 4 years, and Shrieves has obtained a special tax ruling that places the equipmen
MACRS 3-year class. The machinery is expected to have a salvage value of $25,000 after 4 years of use.
The new line would generate incremental sales of 1,250 units per year for 4 years at an incremental cost of $100 per unit in the first
depreciation. Each unit can be sold for $200 in the first year. The sales price and cost are expected to increase by 3% per year due
Further, to handle the new line, the firm’s net working capital would have to increase by an amount equal to 12% of sales revenues
rate is 40%, and its overall weighted average cost of capital is 10%.
(1.) Should you subtract interest expense or dividends when calculating project cash flow?
(2.) Suppose the firm had spent $100,000 last year to rehabilitate the production line site. Should this be
included in the analysis? Explain.
(3.) Now assume that the plant space could be leased out to another firm at $25,000 per year. Should this be
included in the analysis? If so, how?
(4.) Finally, assume that the new product line is expected to decrease sales of the firm’s other lines by
$50,000 per year. Should this be considered in the analysis? If so, how?
c. Calculate the annual sales revenues and costs (other than depreciation). Why is it important to include
inflation when estimating cash flows?
e. Estimate the required net working capital for each year, and the cash flow due to investments in net working
capital.
g. Calculate the net cash flows for each year. Based on these cash flows, what are the project’s NPV, IRR,
MIRR, and payback? Do these indicators suggest the project should be undertaken?
NPV $27,232,889
IRR 150.6% PV of Inflows TV of Inflows
$44,032,889 $64,468,553
Years
Find MIRR 0 1 2
Net Cash Flows ($16,800,000) $24,720,000 $26,484,000
PV= ($16,800,000)
To find MIRR, we could now find the discount rate that equates the PV and TV. But it is easier to use the MIRR function.
MIRR = 90.9%
Payback = 0.7
h. What does the term ”risk” mean in the context of capital budgeting; to what extent can risk be quantified; and
when risk is quantified, is the quantification based primarily on statistical analysis of historical data or on
subjective, judgmental estimates?
Risk in capital budgeting really means the probability that the actual outcome will be worse than the expected outcome. For examp
a high probability that the expected NPV as calculated above will actually turn out to be negative, then the project would be classifi
risky. The reason for a worse-than-expected outcome is, typically, because sales were lower than expected, costs were higher than e
the project turned out to have a higher than expected initial cost. In other words, if the assumed inputs turn out to be worse than ex
the output will likewise be worse than expected. We use Excel to examine the project's sensitivity to changes in the input variables.
i. (1.) What are the three types of risk that are relevant in capital budgeting?
(2.) How is each of these risk types measured, and how do they relate to one another?
(3.) How is each type of risk used in the capital budgeting process?
(2.) Perform a sensitivity analysis on the unit sales, salvage value, and cost of capital for the project. Assume
that each of these variables can vary from its base-case, or expected, value by plus and minus 10%, 20%, and
30%. Include a sensitivity diagram, and discuss the results.
Here we use an Excel "Data Table" to find the NPVs for changes in unit sales, salvage value, and WACC holding other things const
one variable at a time. This produces the sensitivity analys as shown below.
We summarize the data tables and show the sensitivity analysis graph below:
Sensitivity Analysis
NPV ($)
120,000,000
Units Sold
100,000,000
80,000,000
Salvage Value
60,000,000
40,000,000
20,000,000 WACC
0
-40% -30% -20% -10% 0% 10% 20% 30% 40%
-20,000,000
Range $0 $18,484,622 $0
(3.) What is the primary weakness of sensitivity analysis? What is its primary usefulness?
k. Assume that Sidney Johnson is confident of her estimates of all the variables that affect the project’s cash flows
except unit sales and sales price: If product acceptance is poor, unit sales would be only 900 units a year and the
unit price would only be $160; a strong consumer response would produce sales of 1,600 units and a unit price of
$240. Sidney believes that there is a 25% chance of poor acceptance, a 25% chance of excellent acceptance, and
a 50% chance of average acceptance (the base case).
Scenario analysis extends risk analysis in two ways: (1) It allows us to change more than one variable at a time, hence to see the com
changes in several variables on NPV, and (2) it allows us to bring in the probabilities of changes in the key variables.
(3.) Use the worst-, most likely, and best-case NPVs and probabilities of occurrence to find the project’s expected
NPV, standard deviation, and coefficient of variation.
(3.) Use the worst-, most likely, and best-case NPVs and probabilities of occurrence to find the project’s expected
NPV, standard deviation, and coefficient of variation.
We could find the NPV by entering the value of unit sales and price for each scenario and then recording the NPV (this is what we d
below). Alternatively, we could use Tools, Scenarios to define the inputs for each scenario, which we did and show in the Scenario S
below. In fact, you could even use Tools, Scenarios, and then click the Summary button on the dialog box, and it will automatically
similar to the one below. This is a powerful feature of Excel, and we encourage you to explore it.
Scenario Analysis
Squared Deviation
Scenario Probability Unit Sales Unit Price NPV times Probability
l. Are there problems with scenario analysis? Define simulation analysis, and discuss its principal advantages and
disadvantages.
Monte Carlo simulation is similar to scenario analysis in that different values of key input variables are used. Unlike scenario analy
Carlo simulation draws the input values from specified probability distributions and then computes the NPV. It repeats this proces
even thousands, of times. It then averages the NPVs from each repetition.
(2.) Shrieves typically adds or subtracts 3 percentage points to the overall cost of capital to adjust for risk.
Should the new line be accepted?
The CV of this project is 1.15, which is larger than the CV range of the firm's average project. Consequently, this project is riskier
average project, so management should add 3% to the WACC to risk adjust.
Cost of capital for average projects: 50%
Adjustment for risky projects:
Risk adjusted cost of capital:
flow?
’s other lines by
$27,232,889
e the annual
mportant to include
Year 4
20,000
$2,315.25
$0.00
$46,305,000
0
1,382,400
$44,922,600
17,969,040
$26,953,560
1,382,400
$28,335,960
Year 4
$46,305,000
5,556,600
roject’s NPV, IRR,
?
Year 3 Year 4
$27,381,600 $28,335,960
(264,600) 5,556,600
5,329,440
$27,117,000 $39,222,000
Years
3 4
$27,117,000 $39,222,000
40,675,500
59,589,000
83,430,000
TV = $222,916,500
Years
3 4
$27,117,000 $39,222,000
$61,521,000 $100,743,000
an risk be quantified; and
f historical data or on
SALVAGE
Variable NPV
Cost $27,232,889
$26,344,000
26,344,000
26,344,000
26,344,000
26,344,000
Value
0% 40%
lue
ness?
Squared Deviation
times Probability
Quick calculation:
Shrieves Casting Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducte
Johnson, a recently graduated MBA. The production line would be set up in unused space in Shrieves' main plant. The machinery
would be approximately $200,000, another $10,000 in shipping charges would be required, and it would cost an additional $30,000
equipment. The machinery has an economic life of 4 years, and Shrieves has obtained a special tax ruling that places the equipmen
MACRS 3-year class. The machinery is expected to have a salvage value of $25,000 after 4 years of use.
The new line would generate incremental sales of 1,250 units per year for 4 years at an incremental cost of $100 per unit in the first
depreciation. Each unit can be sold for $200 in the first year. The sales price and cost are expected to increase by 3% per year due
Further, to handle the new line, the firm’s net working capital would have to increase by an amount equal to 12% of sales revenues
rate is 40%, and its overall weighted average cost of capital is 10%.
(1.) Should you subtract interest expense or dividends when calculating project cash flow?
(2.) Suppose the firm had spent $100,000 last year to rehabilitate the production line site. Should this be
included in the analysis? Explain.
(3.) Now assume that the plant space could be leased out to another firm at $25,000 per year. Should this be
included in the analysis? If so, how?
(4.) Finally, assume that the new product line is expected to decrease sales of the firm’s other lines by
$50,000 per year. Should this be considered in the analysis? If so, how?
c. Calculate the annual sales revenues and costs (other than depreciation). Why is it important to include
inflation when estimating cash flows?
e. Estimate the required net working capital for each year, and the cash flow due to investments in net working
capital.
g. Calculate the net cash flows for each year. Based on these cash flows, what are the project’s NPV, IRR,
MIRR, and payback? Do these indicators suggest the project should be undertaken?
NPV $37,357,757
IRR 499.6% PV of Inflows TV of Inflows
$42,165,257 $61,734,153
Years
Find MIRR 0 1 2
Net Cash Flows ($4,807,500) $23,760,600 $24,948,960
PV= ($4,807,500)
To find MIRR, we could now find the discount rate that equates the PV and TV. But it is easier to use the MIRR function.
MIRR = 158.1%
Payback = 0.2
h. What does the term ”risk” mean in the context of capital budgeting; to what extent can risk be quantified; and
when risk is quantified, is the quantification based primarily on statistical analysis of historical data or on
subjective, judgmental estimates?
Risk in capital budgeting really means the probability that the actual outcome will be worse than the expected outcome. For examp
a high probability that the expected NPV as calculated above will actually turn out to be negative, then the project would be classifi
risky. The reason for a worse-than-expected outcome is, typically, because sales were lower than expected, costs were higher than e
the project turned out to have a higher than expected initial cost. In other words, if the assumed inputs turn out to be worse than ex
the output will likewise be worse than expected. We use Excel to examine the project's sensitivity to changes in the input variables.
i. (1.) What are the three types of risk that are relevant in capital budgeting?
(2.) How is each of these risk types measured, and how do they relate to one another?
(3.) How is each type of risk used in the capital budgeting process?
(2.) Perform a sensitivity analysis on the unit sales, salvage value, and cost of capital for the project. Assume
that each of these variables can vary from its base-case, or expected, value by plus and minus 10%, 20%, and
30%. Include a sensitivity diagram, and discuss the results.
Here we use an Excel "Data Table" to find the NPVs for changes in unit sales, salvage value, and WACC holding other things const
one variable at a time. This produces the sensitivity analys as shown below.
We summarize the data tables and show the sensitivity analysis graph below:
Sensitivity Analysis
NPV ($)
120,000,000
Units Sold
100,000,000
80,000,000
Salvage Value
60,000,000
40,000,000
WACC
20,000,000
0
-40% -30% -20% -10% 0% 10% 20% 30% 40%
Deviation from Base-Case Value
Range $0 $1,765,114 $0
(3.) What is the primary weakness of sensitivity analysis? What is its primary usefulness?
k. Assume that Sidney Johnson is confident of her estimates of all the variables that affect the project’s cash flows
except unit sales and sales price: If product acceptance is poor, unit sales would be only 900 units a year and the
unit price would only be $160; a strong consumer response would produce sales of 1,600 units and a unit price of
$240. Sidney believes that there is a 25% chance of poor acceptance, a 25% chance of excellent acceptance, and
a 50% chance of average acceptance (the base case).
Scenario analysis extends risk analysis in two ways: (1) It allows us to change more than one variable at a time, hence to see the com
changes in several variables on NPV, and (2) it allows us to bring in the probabilities of changes in the key variables.
(3.) Use the worst-, most likely, and best-case NPVs and probabilities of occurrence to find the project’s expected
NPV, standard deviation, and coefficient of variation.
(3.) Use the worst-, most likely, and best-case NPVs and probabilities of occurrence to find the project’s expected
NPV, standard deviation, and coefficient of variation.
We could find the NPV by entering the value of unit sales and price for each scenario and then recording the NPV (this is what we d
below). Alternatively, we could use Tools, Scenarios to define the inputs for each scenario, which we did and show in the Scenario S
below. In fact, you could even use Tools, Scenarios, and then click the Summary button on the dialog box, and it will automatically
similar to the one below. This is a powerful feature of Excel, and we encourage you to explore it.
Scenario Analysis
Squared Deviation
Scenario Probability Unit Sales Unit Price NPV times Probability
l. Are there problems with scenario analysis? Define simulation analysis, and discuss its principal advantages and
disadvantages.
Monte Carlo simulation is similar to scenario analysis in that different values of key input variables are used. Unlike scenario analy
Carlo simulation draws the input values from specified probability distributions and then computes the NPV. It repeats this proces
even thousands, of times. It then averages the NPVs from each repetition.
(2.) Shrieves typically adds or subtracts 3 percentage points to the overall cost of capital to adjust for risk.
Should the new line be accepted?
The CV of this project is 1.15, which is larger than the CV range of the firm's average project. Consequently, this project is riskier
average project, so management should add 3% to the WACC to risk adjust.
Cost of capital for average projects: 50%
Adjustment for risky projects:
Risk adjusted cost of capital:
flow?
’s other lines by
$37,357,757
e the annual
mportant to include
Year 4
20,000
$2,315.25
$0.00
$46,305,000
0
864
$46,304,136
18,521,654
$27,782,482
864
$27,783,346
Year 4
$46,305,000
5,556,600
roject’s NPV, IRR,
?
Year 3 Year 4
$26,460,576 $27,783,346
(264,600) 5,556,600
4,500,518
$26,195,976 $37,840,464
Years
3 4
$26,195,976 $37,840,464
39,293,964
56,135,160
80,192,025
TV = $213,461,613
Years
3 4
$26,195,976 $37,840,464
$70,098,036 $107,938,500
an risk be quantified; and
f historical data or on
SALVAGE
Variable NPV
Cost $37,357,757
$36,468,868
36,468,868
36,468,868
36,468,868
36,468,868
Value
0% 40%
lue
ness?
Squared Deviation
times Probability
Quick calculation:
$200,000 $200,000
$10,000 $10,000
$30,000 $30,000
4 4
$25,000 $25,000
40% 40%
10% 10%
900 1,250
$160 $200
$100 $100
12% 12%
3% 0%
($48,514) $78,387
1.0% 22.7%
Section 11.7 Scenario Analysis
Monte Carlo simulation is similar to scenario analysis in that different values of key inputs are used Unlike scenario
analysis, Monte Carlo simulation draws a trial set of input values from specified probability distributions and then
computes the NPV for this trial. This process is repeated for hundreds, or even thousands, of trials, with key results
(like NPV) saved from each trial. After running the number of desired trials, the NPVs from the trials can be averaged
estimate the project's expected NPV; the trial results can also be used to provide a histogram showing the project's
possible outcomes.
The green area below is the same project as in the mini case, but we have replaced the inputs fro units sold and sales
price with random variables drawn from normal distributions with the expected values and means shown next to the
inputs. Notice that each time the sheet makes a calculation, the values for unit sales, sales price, and NPV change (Hi
you can make the sheet calculate by hitting the F9 key).
Here is a tip for simulating a project analysis. If you have already done the analysis and it is in a different worksheet,
how many rows it takes. Delete the green area below and add enough rows so that there will be room for your previou
analysis. For example, this model was in the "Model" tab in the file Ch 11 Mini Case.xls, rows 33-132. We went into tha
file, selected Rows 32-135, copied them, and then pasted them into Rows 32-135 of this Worksheet. Because we paste
them into the same row numbers from which we copied them, all the formula references remained correct. We then
edited this worksheet.
c. Calculate the annual sales revenues and costs (other than depreciation). Why is it important to include
inflation when estimating cash flows? See answer to part d.
e. Estimate the required net working capital for each year, and the cash flow due to investments in net working
capital.
g. Calculate the net cash flows for each year. Based on these cash flows, what are the project’s NPV, IRR,
MIRR, and payback? Do these indicators suggest the project should be undertaken?
Projected Net Cash Flows
Year 0 Year 1 Year 2
NPV $33,393
IRR 15.5% PV of InflowsTV of Inflows
$300,399 $439,815
Years
Find MIRR 0 1 2
Net Cash Flows ($267,006) $89,033 $102,274
PV= ($267,006)
To find MIRR, we could now find the discount rate that equates the PV and TV. But it is easier to use the MIRR function.
MIRR = 13.3%
Payback = 3.0
We use a Data Table to perform the simulation (the Data Table is below, shaded bright yellow). When the Data Table is
updated, it will insert new random variables for each of the inputs we allow to change in Panel A above, run the analy
is Panel C above, and then save the NPV for each trial (we also save the input variables for each trial so that we can
verify that they are behaving as we expect). We set the first column of the Data Table (the variable to be changed in ea
row) to numbers from 1-100. We don't really use these numbers anywhere in the analyis, but if we tell the Data Table t
treat these as the Column inputs, Excel will recalculate all items in the Data Table, including the random inputs and th
resulting NPV. In other words, we "trick" Excel into doing a simulation. We tell Excel to insert each of the Column inpu
in the Data Table into the cell immediately below this box. This cell isn't linked to anything else, but each time Excel
updates a row of the Data Table, all the random values will be updated.
Column input cell to "trick" Excel into updating random variables in Data Table: 1
Excel normally updates all values in a Data Table each time any cell that is related to the Data Table changes. In our
case, we have random variables in the Data Table, so each time any cell in the worksheet makes a calculation, the Da
Table is updated. If the Data Table has many rows, updating it can take up to 20 or 30 seconds. With only 100 rows, it
updates very quickly. But if it bothers you, you can set the worksheet to do automatic calculation except for data tabl
You don't need to change anything in this section. It will be updated automatically if you do a simulation. The summ
of the simulation results and the histogram are based on the simulation trials n the Data Table below and are updated
automatically when you do a simulation. You can do an updated simulation by hitting the F9 key.
Median $70,862
Probability of NPV > 0 84.0%
Coefficient of variation 1.16
Probability
NPV ($)
Output of Simulation in Data Table
Sales Price
Trial Number Units Sold Per Unit NPV
1,281 $176 $33,393
1 1281.0704 175.67021 259228.0877
2 1281.0704 175.67021 197047.8282
3 1281.0704 175.67021 81125.23584
4 1281.0704 175.67021 -64095.1588
5 1281.0704 175.67021 70414.44109
6 1281.0704 175.67021 102442.4944
7 1281.0704 175.67021 193440.3363
8 1281.0704 175.67021 221611.1301
9 1281.0704 175.67021 244631.9469
10 1281.0704 175.67021 -32847.563
11 1281.0704 175.67021 78287.5682
12 1281.0704 175.67021 127871.1186
13 1281.0704 175.67021 23395.95444
14 1281.0704 175.67021 4365.752134
15 1281.0704 175.67021 173916.3276
16 1281.0704 175.67021 216054.3455
17 1281.0704 175.67021 92416.23714
18 1281.0704 175.67021 51924.09105
19 1281.0704 175.67021 57638.10225
20 1281.0704 175.67021 40544.23059
21 1281.0704 175.67021 -79916.2055
22 1281.0704 175.67021 86552.03442
23 1281.0704 175.67021 -1358.11365
24 1281.0704 175.67021 16851.48351
25 1281.0704 175.67021 20454.86709
26 1281.0704 175.67021 19554.32969
27 1281.0704 175.67021 252673.8259
28 1281.0704 175.67021 145571.582
29 1281.0704 175.67021 -13365.4705
30 1281.0704 175.67021 18255.36377
31 1281.0704 175.67021 66698.86388
32 1281.0704 175.67021 1650.71614
33 1281.0704 175.67021 69032.35066
34 1281.0704 175.67021 245179.099
35 1281.0704 175.67021 30197.8414
36 1281.0704 175.67021 97312.57353
37 1281.0704 175.67021 137155.162
38 1281.0704 175.67021 -21360.3929
39 1281.0704 175.67021 125042.1481
40 1281.0704 175.67021 36008.22738
41 1281.0704 175.67021 144876.9132
42 1281.0704 175.67021 147316.6362
43 1281.0704 175.67021 61664.09671
44 1281.0704 175.67021 -60248.0384
45 1281.0704 175.67021 75310.95868
46 1281.0704 175.67021 255216.0173
47 1281.0704 175.67021 146850.7773
48 1281.0704 175.67021 -82164.5043
49 1281.0704 175.67021 13847.69148
50 1281.0704 175.67021 -34357.6124
51 1281.0704 175.67021 89665.32839
52 1281.0704 175.67021 7812.993921
53 1281.0704 175.67021 -13590.7081
54 1281.0704 175.67021 63371.64907
55 1281.0704 175.67021 24434.08428
56 1281.0704 175.67021 101108.7475
57 1281.0704 175.67021 65900.38693
58 1281.0704 175.67021 71309.28639
59 1281.0704 175.67021 100001.8034
60 1281.0704 175.67021 4444.52271
61 1281.0704 175.67021 17278.43645
62 1281.0704 175.67021 79270.07042
63 1281.0704 175.67021 93684.34485
64 1281.0704 175.67021 82167.11454
65 1281.0704 175.67021 326199.0229
66 1281.0704 175.67021 227661.7069
67 1281.0704 175.67021 30275.2618
68 1281.0704 175.67021 84600.94297
69 1281.0704 175.67021 135600.6211
70 1281.0704 175.67021 27640.95718
71 1281.0704 175.67021 38618.46896
72 1281.0704 175.67021 23303.42456
73 1281.0704 175.67021 -24208.0757
74 1281.0704 175.67021 39343.47736
75 1281.0704 175.67021 74391.13332
76 1281.0704 175.67021 114045.4416
77 1281.0704 175.67021 852.3201284
78 1281.0704 175.67021 159767.7307
79 1281.0704 175.67021 75591.82522
80 1281.0704 175.67021 59029.44054
81 1281.0704 175.67021 80670.35366
82 1281.0704 175.67021 -52360.5802
83 1281.0704 175.67021 134631.5302
84 1281.0704 175.67021 74414.77672
85 1281.0704 175.67021 192452.477
86 1281.0704 175.67021 158839.6557
87 1281.0704 175.67021 -64704.1492
88 1281.0704 175.67021 -119143.567
89 1281.0704 175.67021 224633.316
90 1281.0704 175.67021 124514.0408
91 1281.0704 175.67021 228436.812
92 1281.0704 175.67021 10877.4874
93 1281.0704 175.67021 -69261.2344
94 1281.0704 175.67021 16202.90759
95 1281.0704 175.67021 56889.83485
96 1281.0704 175.67021 137121.5349
97 1281.0704 175.67021 50004.38788
98 1281.0704 175.67021 176186.9858
99 1281.0704 175.67021 199000.5351
100 1281.0704 175.67021 -31413.6508
1/1/2012
$33,393
al
Remaining
Book Value
$160,800
52,800
16,800
0
o include
Year 4
1,281
$191.96
$109.27
$245,914
139,983
16,800
$89,131
35,652
$53,479
16,800
$70,279
n net working
Year 4
$245,914
29,510
PV, IRR,
Year 3 Year 4
$76,106 $70,279
(860) 29,510
15,000
$75,246 $114,789
Years
3 4
$75,246 $114,789
82,771
123,752
118,503
TV = $439,815
Years
3 4
$75,246 $114,789
($452) $114,337