Open main menu
Home
Random
Donate
Recent changes
Special pages
Community portal
Preferences
About Stockhub
Disclaimers
Search
User menu
Talk
Contributions
Create account
Log in
Editing
Brookfield Renewable Partners L.P.
(section)
Warning:
You are not logged in. Your IP address will be publicly visible if you make any edits. If you
log in
or
create an account
, your edits will be attributed to your username, along with other benefits.
Anti-spam check. Do
not
fill this in!
=== Forecasts === The following table shows the forecast financials for the next 10 years, and the calculation of free cash flow, which will be used in the DCF valuation of the company. {| class="wikitable" |+Forecast Financials ! '''Units ($m)''' !'''2023''' !'''2024''' !'''2025''' !'''2026''' !'''2027''' !'''2028''' !'''2029''' !'''2030''' !'''2031''' !'''2032''' |- | '''Total Revenue''' | 4,608.35 | 4,792.07 | 4,975.78 | 5,159.49 | 5,343.21 | 5,526.92 | 5,710.64 | 5,894.35 | 6,078.06 | 6,261.78 |- | '''Cost of sales''' | - 624.11 | - 662.89 | - 702.73 | - 743.64 | - 785.61 | - 828.65 | - 872.76 | - 917.93 | - 964.16 | - 1,011.47 |- | '''Selling, general and admin expenses''' | - 993.52 | - 1,009.17 | - 1,022.98 | - 1,034.95 | - 1,045.09 | - 1,053.38 | - 1,059.85 | - 1,064.47 | - 1,067.26 | - 1,068.21 |- | '''Other Operating Expenses''' | - 208.43 | - 216.73 | - 225.04 | - 233.35 | - 241.66 | - 249.97 | - 258.28 | - 266.59 | - 274.90 | - 283.21 |- | '''Depreciation''' | 1,633.06 | 1,734.58 | 1,838.89 | 1,946.00 | 2,055.90 | 2,168.59 | 2,284.08 | 2,402.35 | 2,523.42 | 2,647.28 |- | '''EBIT''' | ''' 1,149.24''' | ''' 1,168.70''' | ''' 1,186.14''' | ''' 1,201.55''' | ''' 1,214.95''' | ''' 1,226.32''' | ''' 1,235.68''' | ''' 1,243.01''' | ''' 1,248.32''' | ''' 1,251.62''' |- | '''CapEx''' | - 1,099.80 | - 1,143.65 | - 1,187.49 | - 1,231.34 | - 1,275.18 | - 1,319.03 | - 1,362.87 | - 1,406.71 | - 1,450.56 | - 1,494.40 |- | '''Current Assets''' | 4,390.84 | 4,967.86 | 5,544.88 | 6,121.90 | 6,698.91 | 7,275.93 | 7,852.95 | 8,429.97 | 9,006.99 | 9,584.01 |- | '''Cash''' | 1,046.50 | 1,150.44 | 1,388.07 | 1,492.01 | 1,729.64 | 1,833.57 | 2,071.20 | 2,175.14 | 2,412.77 | 2,516.71 |- | '''Current Liabilities''' | 5,388.16 | 6,143.79 | 6,899.42 | 7,655.05 | 8,410.68 | 9,166.31 | 9,921.94 | 10,677.57 | 11,433.20 | 12,188.83 |- |'''NCWC''' | - 2,043.82 | - 2,326.37 | - 2,742.61 | - 3,025.16 | - 3,441.40 | - 3,723.95 | - 4,140.19 | - 4,422.74 | - 4,838.98 | - 5,121.53 |- | '''NCWC (inc/dec)''' | 553.82 | 282.55 | 416.24 | 282.55 | 416.24 | 282.55 | 416.24 | 282.55 | 416.24 | 282.55 |- | '''FCF''' | ''' 1,994.97''' | ''' 1,796.75''' | ''' 2,004.69''' | ''' 1,946.44''' | ''' 2,156.77''' | ''' 2,100.91''' | ''' 2,313.63''' | ''' 2,260.17''' | ''' 2,475.28''' | ''' 2,424.21''' |} [[File:FCF Growth.png]] The table below shows the assumptions used to calculate the forecasts in the table above, in the case of revenue, current assets, cash and current liabilities, the built in forecast function in excel was used to provide more accurate values. {| class="wikitable" |+Assumptions ! !'''2018''' !'''2019''' !'''2020''' !'''2021''' !'''2022''' !'''2023''' !'''2024''' !'''2025''' !'''2026''' !'''2027''' !'''2028''' !'''2029''' !'''2030''' !'''2031''' !'''2032''' |- | '''Cost of sales % of revenue''' |12.1% |12.7% |14.4% |14.5% |13.3% |13.5% |13.8% |14.1% |14.4% |14.7% |15.0% |15.3% |15.6% |15.9% |16.2% |- | '''SG&A % of revenue''' |24.0% |22.6% |25.8% |26.1% |22.1% |21.6% |21.1% |20.6% |20.1% |19.6% |19.1% |18.6% |18.1% |17.6% |17.1% |- | '''Other expenses % of revenue''' |4.0% |5.1% |8.9% |2.2% |2.4% |4.5% |4.5% |4.5% |4.5% |4.5% |4.5% |4.5% |4.5% |4.5% |4.5% |- | '''Depreciation % of revenue''' |30.4% |32.1% |36.4% |36.9% |34.7% |35.4% |36.2% |37.0% |37.7% |38.5% |39.2% |40.0% |40.8% |41.5% |42.3% |- | '''CapEx % of revenue''' |6.2% |4.9% |11.9% |48.3% |48.0% |23.9% |23.9% |23.9% |23.9% |23.9% |23.9% |23.9% |23.9% |23.9% |23.9% |} The graphs below show the forecast models for revenue, current assets, cash and current liabilities. [[File:Revenue Forecast.png|Revenue Forecasts based on historical revenues.]] [[File:Current Assets Forecast.png|Assets Forecast.]] [[File:Cash Forecast.png|Cash Forecast.]] [[File:Current Liabilities Forecast.png|Current Liabilities Forecast.]]
Summary:
Please note that all contributions to Stockhub may be edited, altered, or removed by other contributors. If you do not want your writing to be edited mercilessly, then do not submit it here.
You are also promising us that you wrote this yourself, or copied it from a public domain or similar free resource (see
Stockhub:Copyrights
for details).
Do not submit copyrighted work without permission!
Cancel
Editing help
(opens in new window)