I need an Excel financial forecast (forecast full year 2024 to 2028) and reason for assumptions and DCF analysis (FCF AND FCFE) for PROCTER AND GAMBLE. i HAVE ATTACHED procter and gamble financials. i HAVE ATTACHED A SAMPLE.

ABC Inc
FY14 FY15 FY16 FY17 FY18 FY19 FY20 FY21 FY22 FY23 FY24E FY25E FY26E FY27E FY28E
DEC ’14 DEC ’15 DEC ’16 DEC ’17 DEC ’18 DEC ’19 DEC ’20 DEC ’21 DEC ’22 DEC ’23
Sales 88.99 107.01 135.99 177.87 232.89 280.52 386.06 469.82 513.98 574.79
Sales growth (Y-o-Y) 20.2% 27.1% 30.8% 30.9% 20.5% 37.6% 21.7% 9.4% 11.8% 12-15% 12.0% 12.0% 10.0% 10.0% 8.0%
Cost of Goods Sold (COGS) incl. D&A 62.75 71.65 88.27 111.93 139.16 165.54 233.31 272.34 288.83 304.74
COGS excluding D&A 59.53 66.00 82.21 102.74 123.82 143.75 208.06 238.05 246.91 256.08 – 0 – 0 – 0 – 0 – 0
% sales 66.9% 61.7% 60.5% 57.8% 53.2% 51.2% 53.9% 50.7% 48.0% 44.6% Avg = 50%, trending down, industry average =40% 45.0% 44.0% 43.0% 42.0% 41.0%