Calculate IRR,NPV, and Payout for your project using a 10% rate. Provide formula and calculations using excel

Capital Investment Project Assumptions in Real Dollars Initial Investment Total Revenue Total Operating charges Inflation rate estimated for 10 years Inflation rate estimated for 10 years Percen $ 40,000,000.00 $ 325,000,000.00 $ 70,838,096.71 $ 11,375,000.00 3.50% Average cost per bed per day is $7,000 Bed Workers 150 600 Salaries, wages and benefits Other operating expenses Supplies Expense Depreciation and Amortization Lease and Rental Total operating charges $ $ $ $ $ 5 55,071,292.71 15,000,000.00 300,000.00 465,804.00 1,000.00 70,838,097 Total Revenue S325,000,000.00 Income Statement Total Revenue Operating Expense Operation Income $ | $ $ 1 325,000,000 $ 70,838,097 $ 254,161,903 $ 2 336,375,000 $ 73,317,430 $ 263,057,570 $ 347,750,000 76,983,302 270,766,698 $ $ $ 4 359,125,000 $ 80,832,467 $ 278,292,533 $ 370,500,000 $ 84,874,090 $ 285,625,910 $ 789 381,875,000 $ 393,250,000 $ 404,625,000 $ 416,000,000 $ 89,117,795 $ 93,573,684 $ 98,252,368 $ 103,164,987 $ 292,757,205 $ 299,676,316 $ 306,372,632 $ 312,835,013 $ 10 427,375,000 108,323,236 319,051,764 Net Operating Income Depreciation Net Cash Flow $ $ $ 254,161,903 $ 1,000,000 $ 255,161,903 $ 263,057,570 $ 1,000,000 $ 264,057,570 $ 270,766,698 1,000,000 271,766,698 $ $ $ 278,292.533 $ 1,000,000 $ 279,292,533 $ 285,625,910 1,000,000 286,625,910 $ $ $ 292,757,205 1,000,000 293,757,205 $ $ $ 299,676,316 1,000,000 300,676,316 $ $ $ 306,372,632 $ 1,000,000 $ 307,372,632 $ 312,835,013 $ 1,000,000 $ 313,835,013 $ 319,051,764 1,000,000 320,051,764 Capital Investment Project Assumptions in Real Dollars Initial Investment Total Revenue Total Operating charges Inflation rate estimated for 10 years Inflation rate estimated for 10 years Percen $ 40,000,000.00 $ 325,000,000.00 $ 70,838,096.71 $ 11,375,000.00 3.50% Average cost per bed per day is $7,000 Bed Workers 150 600 Salaries, wages and benefits Other operating expenses Supplies Expense Depreciation and Amortization Lease and Rental Total operating charges $ $ $ $ $ 5 55,071,292.71 15,000,000.00 300,000.00 465,804.00 1,000.00 70,838,097 Total Revenue S325,000,000.00 Income Statement Total Revenue Operating Expense Operation Income $ | $ $ 1 325,000,000 $ 70,838,097 $ 254,161,903 $ 2 336,375,000 $ 73,317,430 $ 263,057,570 $ 347,750,000 76,983,302 270,766,698 $ $ $ 4 359,125,000 $ 80,832,467 $ 278,292,533 $ 370,500,000 $ 84,874,090 $ 285,625,910 $ 789 381,875,000 $ 393,250,000 $ 404,625,000 $ 416,000,000 $ 89,117,795 $ 93,573,684 $ 98,252,368 $ 103,164,987 $ 292,757,205 $ 299,676,316 $ 306,372,632 $ 312,835,013 $ 10 427,375,000 108,323,236 319,051,764 Net Operating Income Depreciation Net Cash Flow $ $ $ 254,161,903 $ 1,000,000 $ 255,161,903 $ 263,057,570 $ 1,000,000 $ 264,057,570 $ 270,766,698 1,000,000 271,766,698 $ $ $ 278,292.533 $ 1,000,000 $ 279,292,533 $ 285,625,910 1,000,000 286,625,910 $ $ $ 292,757,205 1,000,000 293,757,205 $ $ $ 299,676,316 1,000,000 300,676,316 $ $ $ 306,372,632 $ 1,000,000 $ 307,372,632 $ 312,835,013 $ 1,000,000 $ 313,835,013 $ 319,051,764 1,000,000 320,051,764