Overview

The free excel template help the user
to calculates the weighted average cost of capital for the long-term funding used
by the firms, supplied by its creditors (or lenders) and the owners (or shareholders),

Inputs in the green cells only 

Equity financing (Column C, Row 8): The
long-term funding supplied by the shareholders includes both common stock and
preferred stock, common stock includes outstanding common stock and retained
earnings

 Debt financing (Column C, Row 9): The long-term
funding supplied by the creditors is long term debt only. Accounts payable,
accrued expenses, and other non-debt or current liabilities are excluded, short
term seasonal debt is also excluded, if the short-term debt is continuing as a
revolving, so that debt can be included as part of long-term debt

 Risk free rate (Column F, Row 8): is
return of an investment with zero risk, approximated by the return on very
short government treasury bond

Market risk premium (Column F, Row 9): is
difference between expected return on a market portfolio and risk-free rate

Levered beta (Column F, Row 10): is a
measure of market risk

Debt interest (Column I, Row 8): it is annual
interest on long term debt

Corporate tax (Column I, Row 9): tax on
net profit

 Outputs

 After you fill the green cells, the
data will dynamically flow into the following below

 Capital structure weights

Cost of equity using CAPM formula

Cost of debt after tax

Weighted average cost of capital

First dashboard showing the impact of
changing capital structure on WACC

Second dashboard showing the impact of
changing levered beta on WACC

 If you have inquiries please contact us

Reviews Add a review
No reviews yet

More From ECF Consultancy

Browse our top rated business templates. See All
Startup Business Plan - Rental Heavy Machinery
158
0
Industry Overview One of the major factors driving the growth of the market is the growing construction industry especially in…
Startup Business Plan - Boat Trip
455
1
 Industry Overview The sailing, sightseeing cruise, and boating tour space saw a 44% growth during the recent years. This industry…
Monthly Profit & Loss Statement for a Small Business
627
1
 General Overview The model is profit and loss statement with variance analysis The model is constructed for small business to…
Startup Business Plan - Concrete Production & Supply
492
0
Industry Overview The global concrete industry market is expected to significantly grow for the 10 coming years. Growing investments in…
Startup Business Plan - Consulting Firm
907
0
 What is Investment Consulting? An investment consulting is a financial professional who provides investors with investment products, advice and planning.…
Startup Business Plan - FMCG Distribution
986
0
 General overview It is not secret that starting any business plan from scratch is not easy.   If you dream…
See All