FILL IN ALL THE GRAY BOXES -- DO NOT CHANGE THE YELLOW BOXES!!!!! 131 FOR HD SUPPLY (HDS) - FIND THEIR HISTORICAL FREE CASH FLOWS. - USE THE "WEY RATIOS/FWANCIALS" SECTION ON FIRA TO FILL THE FOLLOWING TABLE: YEAR ENDING 2016-01 2017-01 2018-01 2019-01 2020-01 513 502 OPERATING CASH FLOWS CAP SPENDING FREE CASH FLOW 564 -115 469 -156 336 400 571 YEAR OVER YEAR GROWTH %> 28.57% -5.56% 14.95% 21.75% 14 USING HDS PAST ONLY THESE NUMBERS), WHAT IS YOUR ESTIMATE OF THE PERCENTAGE GROWTH RATE PER YEAR GOING FORWARD? 14.93% THIS TABLE COMES FROM FINRA FOR HDS - USE IT TO ANSWER THE QUESTIONS BELOW HD Supply Holdings Ine HDS *** Annual Gamings Estats IM 11 1 1 - w 112 21 15) 20 DAYS AGO ANALYSTS ON WALL STREET THOUGHT HDS EARNINGS WOULD GROW AT WHAT RATE FOR 01/2022?? 2.50% 16 WHAT IS THE CURRENT MEAN ESTIMATE GROWTH FOR 01/2022 13.40% 171 WHY DO YOU THINK IT CHANGED? Due to the purchase of the recent acquisition USE THIS NEW "MEAN" GROWTH RATE FORECAST TO GROW HDS CASHFLOWS FOR 2022 AND 2023. THEN 3% AFTER THAT 2021 and 2022: Mean growth estimate 13.40% 2023 and 2024: Une 6 2025: 39 2026 and forward USE A CONSTANT GROWTH RATE OF 2% --YOUR ESTIMATES SHOULD BE BASED ON THE NUMBERS IN THE TABLE ABOVE FOR 2020-01, oduited for GROWTH 18) YOUR ESTIMATES FOR THE FUTURE -- FILL IN THE TABLE FOR YEARS ENDING 2021-01, 2022 2023, 2024 1 E 2000-01 2021-01 2022-01 2 2023-01 3 2074-01 4 2005-01 s 2007-21 FILLS IN FROM ARONF) 571 617.61 73.72 77.31 R25.04 R49.71 86.78 35 2. porcen 19] CALCULATE NET PRESENT VALUE 14744.57 hetin ve (USE COWAC.-CROWTH NATF) -----> plus free cash flows 543 734 cquals total cash flows 647.51 734.28 778 825 225.04 850 15/9416 pv coulvalent: WACC FROM PREV SHEET ---> 7.085 NET PRESENT VALUE-> SO 1 $0.00 ? $0.00 1 $0.00 201 CALCULATE IRR $0.00 $0.00 IRR -- 21 WAS HD WISE TO TAKE ON THIS PROJECT EXPLAIN) 22] WHAT IS THE IRRIF HDS ONLY GROWS BY 2.5% THROUGH TIMES - THEN 18 AFTER THAT?? - NOTE THAT THIS IS HOW FAST ANALYSTS THOUGHT THEY WOULD GROW JUST 30 DAYS AGO 23) READ THE ATTACHED ARTICLE - DO YOU SEE ANOTHER (COMPETITIVE) MOTIVE FOR HD TO BUY HDS777 OTHER THAN WHAT IS STATED IN THEIR NEWS RELEASE? COULD THIS IMPACT THEIR FINANCIAL ESTI httrus://www.bloombers.comews/articles/2000-11-15/home-cepat-to-buy-farmer-it-to-sub-in-9-1-billion-deal FILL IN ALL THE GRAY BOXES -- DO NOT CHANGE THE YELLOW BOXES!!!!! 131 FOR HD SUPPLY (HDS) - FIND THEIR HISTORICAL FREE CASH FLOWS. - USE THE "WEY RATIOS/FWANCIALS" SECTION ON FIRA TO FILL THE FOLLOWING TABLE: YEAR ENDING 2016-01 2017-01 2018-01 2019-01 2020-01 513 502 OPERATING CASH FLOWS CAP SPENDING FREE CASH FLOW 564 -115 469 -156 336 400 571 YEAR OVER YEAR GROWTH %> 28.57% -5.56% 14.95% 21.75% 14 USING HDS PAST ONLY THESE NUMBERS), WHAT IS YOUR ESTIMATE OF THE PERCENTAGE GROWTH RATE PER YEAR GOING FORWARD? 14.93% THIS TABLE COMES FROM FINRA FOR HDS - USE IT TO ANSWER THE QUESTIONS BELOW HD Supply Holdings Ine HDS *** Annual Gamings Estats IM 11 1 1 - w 112 21 15) 20 DAYS AGO ANALYSTS ON WALL STREET THOUGHT HDS EARNINGS WOULD GROW AT WHAT RATE FOR 01/2022?? 2.50% 16 WHAT IS THE CURRENT MEAN ESTIMATE GROWTH FOR 01/2022 13.40% 171 WHY DO YOU THINK IT CHANGED? Due to the purchase of the recent acquisition USE THIS NEW "MEAN" GROWTH RATE FORECAST TO GROW HDS CASHFLOWS FOR 2022 AND 2023. THEN 3% AFTER THAT 2021 and 2022: Mean growth estimate 13.40% 2023 and 2024: Une 6 2025: 39 2026 and forward USE A CONSTANT GROWTH RATE OF 2% --YOUR ESTIMATES SHOULD BE BASED ON THE NUMBERS IN THE TABLE ABOVE FOR 2020-01, oduited for GROWTH 18) YOUR ESTIMATES FOR THE FUTURE -- FILL IN THE TABLE FOR YEARS ENDING 2021-01, 2022 2023, 2024 1 E 2000-01 2021-01 2022-01 2 2023-01 3 2074-01 4 2005-01 s 2007-21 FILLS IN FROM ARONF) 571 617.61 73.72 77.31 R25.04 R49.71 86.78 35 2. porcen 19] CALCULATE NET PRESENT VALUE 14744.57 hetin ve (USE COWAC.-CROWTH NATF) -----> plus free cash flows 543 734 cquals total cash flows 647.51 734.28 778 825 225.04 850 15/9416 pv coulvalent: WACC FROM PREV SHEET ---> 7.085 NET PRESENT VALUE-> SO 1 $0.00 ? $0.00 1 $0.00 201 CALCULATE IRR $0.00 $0.00 IRR -- 21 WAS HD WISE TO TAKE ON THIS PROJECT EXPLAIN) 22] WHAT IS THE IRRIF HDS ONLY GROWS BY 2.5% THROUGH TIMES - THEN 18 AFTER THAT?? - NOTE THAT THIS IS HOW FAST ANALYSTS THOUGHT THEY WOULD GROW JUST 30 DAYS AGO 23) READ THE ATTACHED ARTICLE - DO YOU SEE ANOTHER (COMPETITIVE) MOTIVE FOR HD TO BUY HDS777 OTHER THAN WHAT IS STATED IN THEIR NEWS RELEASE? COULD THIS IMPACT THEIR FINANCIAL ESTI httrus://www.bloombers.comews/articles/2000-11-15/home-cepat-to-buy-farmer-it-to-sub-in-9-1-billion-deal