accounting case

profileworkprovider1
case_2_example.xlsx

Sheet1

A (100,000.00) 40,000.00 50,000.00 50,000.00 50,000.00 50,000.00
B (1,300,000.00) 60,000.00 60,000.00 60,000.00 60,000.00 60,000.00
Delta -1200000 20000 10000 10000 10000 10000
NPV NPV W/GROWTH IRR IRR W/GROWTH
A $58,912.10 $80,448.43 37% 42%
B ($1,098,870.69) ($1,072,552.79) -35% -30%
DELTA ($1,157,782.80) ($1,153,001.22) -57% -52%
discount rate 15%
growth rate 0.05

Sheet2

Sheet3