How to calculate the NPV, Benefit to Cost Ratio, IRR, and Payback Period in a simple formula using the below information in table.

 

year 0 1 2 3 4 5 6 7 K K K K K K K K TC TR K 1,502,400,000.00 K 1,502,400,000.00 10,139,700,000.00 801,600,000.00 834,000,000.00 K 1,502,400,000.00 866,400,000.00 1,502,400,000.00 920,400,000.00 K 1,502,400,000.00 952,800,000.00 K 1,502,400,000.00 1,006,800,000.00 K 1,502,400,000.00 1,039,200,000.00 K 1,502,400,000.00 Cash flow Discount rate 10% PV accumulated cash flow