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

Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes