Pv annuity factor 1000 800 annual after tax cash

PV Annuity Factor 10.00% 8.00%
Annual after-tax cash inflow $100,000 #NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
Notes:
1. Cell B11 contains the input cell (to do the base-level NPV analysis)
2. Cells C11:C19 contain the values that Excel will substitute, sequentially,
into the input cell, B12
3. Cell D10 contains the NPV formula
Row input cell =
B12
Column
input cell
= B11
Formula
cell =
C10
List of values that Excel substitutes in the
column input cell , B11
List of cell values that
Excel substitutes in the
Row Input cell, B12
Formula Cell (C10):
=B10+(B12*(((1/(1+B11)^1))+((1/(1+B11)^2))+((1/(1+B11)^3))+
(1+B11)^4))+((1/(1+B11)^5))))

Completed Data Table Dialog Box
+((1/

Pr. 12-62: Sensitivity Analysis--One Variable Data Table
Item Year(s) CF
Net Investment outlay 0 ($350,000)
Annual after-tax cash infl 1-5 $100,000
Discount Rate 10%
PV Annuity Factor 3.791 (Appendix C, Table 2)
NPV Analysis
Net Investment Outlay ($350,000) $29,079
PV Annuity Factor 10.00% 8.00%
Annual after-tax cash infl $100,000 #NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
#NAME?
Notes:
1. Cell B11 contains the input cell (to do the base-level NPV analysis)
2. Cells C11:C19 contain the values that Excel will substitute, sequentially,
into the input cell, B12
3. Cell D10 contains the NPV formula
This (D10) is the for
cell (which will be u
to create the table o
NPVs for the discou
rates specified in
C11:C19)
This(B11) is the "input cell"
You will create (in D11: D19) a
table of NPVs--one for each of
the discount rates listed in
C11: C19.
Formula Cell (D10):
=B10+(B12*(((1/(1+
(1+B11)^4))+((1/(1+

Completed Data Table Dialog Box
rmula
used
of
unt
:
+B11)^1))+((1/(1+B11)^2))+((1/(1+B11)^3))+((1/
+B11)^5))))