Need help to calculate NPV and IRR for scenario analysis for Ride Aid : Best case NPV and IRR, Most likely case NPV and IRR and worse case NPV and IRR

how can I do this in Excel, additional info on WACC is: WEIGHTED AVERAGE COST OF CAPITAL= Wd*Kd + We*Ke Wd= Weight of debt = 0.945 Kd = Cost of debt= 3.79 We= Weight of equity= 0.055 Ke= Cost of equity= 14.40 WACC = 0.945*3.79 + 0.055*14.40 = 3.58155 + 0.792 = 4.37355% rounded 4.37%

here is information of FCF

FCF Calculation	2015	2016	2017	2018	2019	2020
EBIT		1,124,165,775	1,102,625,054	1,145,026,364	1,188,614,050	1,233,369,332
Taxes		168,624,866	165,393,758	171,753,955	178,292,108	185,005,400
NOPAT		955,540,909	937,231,296	973,272,409	1,010,321,943	1,048,363,933
Dep		40,000	72,169,981	82,634,448	94,291,498	107,266,965
CAPEX	400,000	721,299,807	104,644,672	116,570,500	129,754,673	144,325,983
ChgONWC	(4,175,621,450)	(187,902,965)	(196,358,599)	(205,194,736)	(214,428,499)	(224,077,781)
Residual Value						2,861,971,216
FCF	(5,224,778,550)	422,184,067	1,101,115,203	1,144,531,092	1,189,287,266	4,097,353,912
Intial Payment	9,400,000,000
NPV	478,640,912
IRR	12%