FINC615_Unit4IP - FIN 615 NPV and IRR calculations Cost of Capital Time\/yr Cash flow Input here Discounted CF NPV 10.00 0 1 2 3 4 9875000 9875000

FINC615_Unit4IP - 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###9875000987500098750009875000Discounted CF-3E+007 8977272.73 8161157.02 7419233.666744757.87NPV10538626 =cf1/((1+n)^=cf2/((1+n)^=cf3/((1+n)^=cf4/((1+n)^PV factor1111IRR22.19%
5148750009236204.68=cf5/((1+n)^5)1
Net Income StatementGiven ValuesSales (revenue)25,000,000Initial Investment Outlay30,000,000Less: Cost of Goods10,000,000Equipment25,000,000Less: Depreciation5,000,000Net Working Capital5,000,000Less: SGA2,500,000GPM60%Net Income Before Tax

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture