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

Pv annuity factor 1000 800 annual after tax cash

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))))
Image of page 214

Subscribe to view the full document.

Completed Data Table Dialog Box +((1/
Image of page 215
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+
Image of page 216

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))))
Image of page 217
  • Spring '18

What students are saying

  • Left Quote Icon

    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.

    Student Picture

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

  • Left Quote Icon

    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.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    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.

    Student Picture

    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