I added some of the excel sheet
The Net Present Value is calculated below with 5.75% Cost of Capital: Year 3 5 6 Total Acquisition Stage Cash Flow -1,205,000.00 81.035.46 20,772.51 6.192.04 87,829.10 -3,927.94 28,096.99 Total Operating Stage Cash Flow 1,103,760.00 2,472,213.78 2,379,455.58 2, 129,760.00 906,737.36 1, 103,667.05 Total Cash Flows -1,205,000.00 1,022,724.54 2,451,441.27 2,373,263.54 2,217,589.10 902,809.42 1,075,570.06 Present Value of Future Cash Flows at 5.75% $10,430,340.35 Net Present Value The Net Present Value is calculated below with 8.75% Cost of Capital: Year 5 6 Total Acquisition Stage Cash Flow -1,205,000.00 81,035.46 -20,772.51 -6,192.04 87,829.10 -3,927.94 28,096.99 Total Operating Stage Cash Flow 1,103,760.00 2,472,213.78 2,379,455.58 2,129,760.00 906,737.36 1,103,667.05 Total Cash Flows -1,205,000.00 1,022,724.54 2,451,441.27 2,373,263.54 2,217,589.10 902,809.42 1,075,570.06 Present Value of Future Cash Flows at 8.75% $9,334,958.38 Net Present Value The Net Present Value is calculated below with 11.75% Cost of Capital: Year 5 Total Acquisition Stage Cash Flow -1,205,000.00 81,035.46 -20,772.51 6.192.04 87,829.10 -3,927.94 -28,096.99 Total Operating Stage Cash Flow 1,103,760.00 2,472,213.78 2,379,455.58 2,129,760.00 906,737.36 1,103,667.05 Total Cash Flows -1,205,000.00 1,022,724.54 2,451,441.27 2,373,263.54 2,217,589.10 902,809.42 1,075,570.06 Present Value of Future Cash Flows at 11.75% $8,409,468.24 Payback Period Year 3 5 6 Cash Flows -1,205,000.00 1022724.54 2451441.27 2373263.54 2217589.1 902809.42 1075570.06 Accumulated cash flow -1,205,000.00 -182,275.46 2,269,165.81 4,642,429.35 6,860,018.45 7,762,827.87 8,838,397.93 Payback period 1.074354406 1.07 years Present Value Payback Period Year 5 Cash Flows -1,205,000.00 1,022,724.54 2,451,441.27 2,373,263.54 2,217,589.10 902,809.42 1,075,570.06 Present Value each year $1,205,000.00 $946,967.17 $4,371,568.79 $6, 116,130.32 $7,344,936.38 $3,604,656.23 $4,972,230.96 Accumulated present value -1,205,000.00 -$258,032.83 $4,113,535.96 $10,229,666.28 $17,574,602.66 $21,179,258.89 $26,151,489.85