FINC615_Unit5IP - FIN 615 NPV and IRR Calculations Cost of Capital Time\/yr Cash flow Input here Discounted CF-4E 007 8609090.91 7826446.28 7114951.16

FINC615_Unit5IP - FIN 615 NPV and IRR Calculations Cost of...

This preview shows page 1 - 4 out of 4 pages.

FIN 615 NPV and IRR CalculationsCost of Capital10.00%Time/yr01234Cash flow Input here###9,470,0009,470,0009,470,0009,470,000Discounted CF-4E+007 8609090.91 7826446.28 7114951.166468137.42NPV-996643 =cf1/((1+n)^=cf2/((1+n)^=cf3/((1+n)^=cf4/((1+n)^PV factor1111IRR9.08%
514,470,0008984731.54=cf5/((1+n)^5)1
Net IncomeGiven ValuesSales (revenue)27,000,000Initial Investment Outlay-40,000,000Less: Cost of Goods13,500,000Equipment35,000,000Less: Depreciation7,000,000Net Working Capital5,000,000Less: SGA2,700,000GPM50%Net Income Before Tax

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture