Business Growth Strategy

I need you to write about the business growth strategy of BinDawood company and to do the DCF evaluation projection of only the( depreciation and the SG&A) in excell sheet starting from 2018 to year 2025 and to write justification i have the excel sheet ready you will only do the projections  of the highlited part

    (in million) Historical Period CAGR Projection Period Sensitivity Analysis
2018 2019 2020 (18 – 20) 2021 2022 2023 2024 2025 Input Output Perpetuity growth %
Sales 4,554 4,844 5,157 6% 5,497 5,865 6,258 6,677 7,125 Wacc Calculation Enterprise value ## 26,011 -1.0% -0.5% 0.0% 0.5% 1.0%
% growth 6.4% 6.5% 6.6% 6.7% 6.7% 6.7% 6.7% Target Capital Structure Present value of Free Cash Flow 6,785 WACC -2.0% 0 0 0 0 0
COGS 3,001 3,199 3,485 8% 3,732 4,516 4,819 5,142 5,486 Debt to Total Capitalization 65.79% -1.0% #DIV/0! 0 0 0 0
% sales 65.9% 66.0% 67.6% 67.9% 77.0% 77.0% 77.0% 77.0% Equity to Total Capitalization 34.21% Terminal Value 25,320 0.0% 0 0 #DIV/0! 0 0
Gross Profit 1553 1645 1672 4% 1764 1349 1439 1536 1639 Debt to Equity Ratio 1.9234 Discount Factor 0.76 1.0% 0 0 0 0 #DIV/0!
% margin 34.1% 34.0% 32.4% 32.1% 23.0% 23.0% 23.0% 23.0% Present Value of Terminal Value 19,226 2.0% 0 0 0 0 0
SG&A 1,047 1,006 1,002 -2% 0 0 0 0 0 Cost of Equity % of Enterprise Value 74%
% of sales 22.99% 20.77% 19.43% Risk-free rate 3.06%
EBIT 506 639 670 15% 1,764 1,349 1,439 1,536 1,639 Market risk Premium 6.08% Enterprise value 26,011
% margin 11.1% 13.2% 13.0% 32.1% 23.0% 23.0% 23.0% 23.0% Levered Beta -0.19 Less: Total debt 3,456,710
Plus: Depreciation & Amortization 155,523 160,093 165,448 0 0 0 0 0     Cost of Equity 1.9% Plus: Cash and Cash Equi. 232,197
% of sales 34 33 32 Net Debt 3,224,513
EBITDA 156,029 160,732 166,118 3% 1,764 1,349 1,439 1,536 1,639 Cost of Debt Less: Preferred Stock 0
% margin 34 33 32 0 0 0 0 0 Cost of Debt 8.82% Less: Noncontrolling Interest 0
Taxes 0 34 36 38 41 Taxes 2.5% Implied Equity Value -3,198,502
% of EBIT 0 0 0     After Tax Cost of Debt 8.6% Fully Diluted Outstanding shares 114,130,000
EBIAT 506 639 670 1,764 1,315 1,403 1,497 1,598 Implied share price -0.03
Less: Capex 144 42 46 0 0 0 0 0 WACC 6.31%
% sales 3.2% 0.9% 0.9%
Less: Incr./(Dec.) in NWC 181 377 -36 -311 0 63 0 0
Unlevered Free Cash Flow 155,704 160,313 166,108 2,075 1,315 1,340 1,497 1,598
WACC 6.3%
Discount Period 0.5 1.5 2.5 3.5 4.5
Discount Factor 0.97 0.91 0.86 0.81 0.76
Present value of free cash flow 2,013 1,200 1,150 1,209 1,213
Terminal Value
Terminal Year Free Cash Flow 1,598
Perpetuity Growth Rate 0.0%
Terminal Value 25,320
Discount Period 4.5
Discount Factor 0.8
   Present Value of Terminal Value 19,226
% of Enterprise Value 74%
    (in million) Actual Forecast period
Net Working Capital 2017 2018 2019 2020 2021 2022 2023 2024 2025
Account receivables 145 157 260 313
Inventory 760 806 919 1,000
Prepaid expenses and other 0 53 52 61
Total Current Assets 905 1,016 1,231 1,374 0 0 0 0 0
% sales 22.3% 25.4% 26.6% 0.0% 0.0% 0.0% 0.0% 0.0%
Account payable 1,152 1,059 884 1,063
Accrued Liabilities
Other Current Liabilities 27 50 63 63 63 63
Total Current Liabilities 1,179 1,109 947 1,126 63 63 0 0 0
% sales -24.4% -19.6% -21.8% 1.1% 1.1% 0.0% 0.0% 0.0%
Net Working Capital -274 -93 284 248 -63 -63 0 0 0
% sales -2% 6% 5% -1% -1% 0% 0% 0%

Complete Answer:

Get Instant Help in Homework Asap
Get Instant Help in Homework Asap
Calculate your paper price
Pages (550 words)
Approximate price: -