Please review the excel sheets and recalculate Present Value Payback using 5.75%, then using 8.75% cost of money, and then using 11.75% cost of money.

Please look at excel sheet to see how it show be formatted. Thank you in advance!

I have uploaded the spreadsheets below!

You do not have to type the whole spreadsheet, ONLY the answers! :)

G 100% % 123 Defaul 10 + B 25 A1 fx A B C D E F G H K 71 Continuing Value 10,189,989.27 72 73 Total Cash Flows -1,205,000.00 1,022,724.54 2,451,441.28 2,373,263.54 2,217,589.10 902,809.42 1,075,570.06 1,089,071.31 2,037,997.85 74 75 76 Net Present Value 77 The Net Present Value is calculated below with 5.75% Cost of Capital: 78 79 Year 0 1 2 3 4 5 6 7 8 80 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 -64,325.40 0.00 81 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 1, 153,396.71 2,037,997.85 82 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 1,089,071.31 2,037,997.85 B3 Present Value of Future Cash Flows at 5.75% $10,430,340.35 84 Net Present Value at 5.75% $9,225,340.35 85 86 Net Present Value 87 The Net Present Value is calculated below with 8.75% Cost of Capital: 88 89 Year 0 1 2 3 4 5 6 7 8 Total Ammunition Clean Cash Flow 01 NOC AC On 779 C1 07 090 10 3 097 01 no noc on n nn Week 7 +100% $ % .0 .00 123 Defaul 10 B I A A1 fx A B C D E F G H J 89 Year 0 1 2 3 4 5 6 7 8 90 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 -64,325.40 0.00 91 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 1, 153,396.71 2,037,997.85 92 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 1,089,071.31 2,037,997.85 93 Present Value of Future Cash Flows at 8.75% $9,334,958.38 94 Net Present Value at 8.75% $8, 129,958.38 95 96 Net Present Value 97 The Net Present Value is calculated below with 11.75% Cost of Capital: 98 99 Year 0 1 2 3 4 5 6 7 8 100 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 -64,325.40 0.00 101 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 1, 153,396.71 2,037,997.85 102 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 1,089,071.31 2,037,997.85 103 Present Value of Future Cash Flows at 11.75% $8,409,468.24 104 Net Present Value at 11.75% $7,204,468.24 105 106 1075 100% Y $ % .0 .00 123 Defaul Y 10 B I A A1 Y fx A B C D E F G H J K 106 107 108 109 110 Payback Period 111 Year 0 1 2 3 4 5 6 7 8 112 Cash Flows -1,205,000.00 1022724.54 2451441.27 2373263.54 2217589.1 902809.42 1075570.06 1089071.31 2037997.85 113 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 9,927,469.24 11,965,467.09 114 115 Payback period 1.074354406 1.07 years 116 117 118 Present Value Payback Period 119 Year 0 2 3 5 6 7 8 120 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 1,089,071.31 2,037,997.85 121 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 $5,670, 108.26 $11,711,637.81 122 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 $31,821,598.11 $43,533,235.92 123 124 Present value payback period 1.059025225 1.05 years