PV Annuity Factor 1000 800 Annual after tax cash inflow 100000 NAME NAME NAME

# Pv annuity factor 1000 800 annual after tax cash

• 217

This preview shows page 214 - 217 out of 217 pages.

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)))) Subscribe to view the full document.

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+ Subscribe to view the full document.

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

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern