How to calculate the risk free rate of return on Securities

The other posters who are familiar with CAP-M are correct. The proxy for the risk free rate of return are US Treasuries. You can find the rates of return for Treasuries on either yahoo finance or google finance.
You may also notice that betas tend to differ slightly - it depends on whether they're historical, forward looking, based on consensus, etc.
You can also find the rate of return on the market (use the S&P Index) at either google finance or yahoo finance.

Here's part of an article on the Capital Asset Pricing Model from Investopedia.com:

Here is the formula:

rj = rf + b(rm-rf)
where:
rj= expected return on asset j
rf= ten year US Treasury rate (the "risk free" rate)
b= beta
rm=market return


CAPM's starting point is the risk-free rate - typically a 10-year government bond yield. To this is added a premium that equity investors demand to compensate them for the extra risk they accept. This equity market premium consists of the expected return from the market as a whole less the risk-free rate of return. The equity risk premium is multiplied by a coefficient that Sharpe called "beta".

Beta
According to CAPM, beta is the only relevant measure of a stock's risk. It measures a stock's relative volatility - that is, it shows how much the price of a particular stock jumps up and down compared with how much the stock market as a whole jumps up and down. If a share price moves exactly in line with the market, then the stock's beta is 1. A stock with a beta of 1.5 would rise by 15% if the market rose by 10%, and fall by 15% if the market fell by 10%. (For further reading, see Beta: Gauging Price Fluctuations and Beta: Know The Risk.)

Beta is found by statistical analysis of individual, daily share price returns, in comparison with the market's daily returns over precisely the same period. In their classic 1972 study titled "The Capital Asset Pricing Model: Some Empirical Tests", financial economists Fischer Black, Michael C. Jensen and Myron Scholes confirmed a linear relationship between the financial returns of stock portfolios and their betas. They studied the price movements of the stocks on the New York Stock Exchange between 1931 and 1965.

How to calculate market return using historical data For Portfolio Management

The link is broken for some reason (could be me or maybe it's on your side)... however, I don't need it to help you.

CAPM:

Stock Return = Beta (Rm - Rf) + Rf
Where Rf = Risk Free rate and Rm = Market return

"Market return" should be the geometric average return from inception (the earliest date) to today. If you're looking for market return of 1984, then you take the price of the market on December 31, divide by the price on 1 January and then subtract one. The Risk Free rate is the long-term sovereign rate (should be given to you).

Market risk is the standard deviation of the market (on a daily basis). This is the sum of the square differences from the mean divided by the number of days (minus one).

Working capital

    Net Working Capital = Current Assets − Current Liabilities
    Net Operating Working Capital = Current Assets − Non Interest-bearing Current Liabilities
    Equity Working Capital = Current Assets − Current Liabilities − Long-term Debt

Inventory turnover & Inventory turnover in days ratio calculation

During the year, ABCD Company had a cost of goods sold of $1,344. inventory at the end of year was $ 422. in this case, Inventory Turnover can be calculated as follows:

Inventory Turn Over = Cost of Goods Sold/ Inventory
                                   = 1344/422
                                   = 3.2 Times


ABCD sold off or turned over entire inventory 3.2 times. The higher the ratio is, the more efficiently we are managing inventory. Now Inventory turnover in days ratio calculation


Inventory Turn Over in days = 365* days/ Inventory Turn over
                                                = 365 days/3.2
                                                = 114 days


* the days can be assume 360 days also.

Turnover ratio

Turnover ratio:

---

• Cash to sales = Cash/sales
• Accounts receivable to sales = Accounts receivable/sales
• Inventory to sales = Inventory/sales
• Quick assets to sales = Quick assets/sales
• Current assets to sales = Current assets/sales
• Working capital to sales =Working capital/sales
• Net worth to sales = Net worth/sales
• Total assets to sales = Total assets/sales

Turnover measure or asset management is known as assets utilization ratio. it described how efficiently or intensively a firm use its assets to generates sales.

Liquid assets to current debt ratio

Liquid assets to current debt ratio:

---

• Cash to current liabilities = Cash/current liabilities
• Quick assets to current liabilities = Quick assets/current liabilities
• Current ratio = Current Assets/Current Liabilities


Liquid assets to current debt test ratio help find the portion of liquid assets in per Unit current debt .

How to calculate Liquid assets to total assets ratio

Liquid assets to total assets ratio:

---

• Cash to total assets = Cash/total assets
• Quick assets to total assets = Quick assets/total assets
• Current assets to total assets = Current assets to total assets
• Working capital to total assets = Working capital/total assets

these ratio test helps company to calculate how much liquid assets is available in total assets

Leverage Ratio or Equity Multiplier

Leverage Ratio, another name is Equity Multiplier is calculated by Total Assets per unit or Dollar of stockholders' Equity.

It is calculated by Total Assets divided Equity or 1+debt equity ratio

Equity Multiplier :1) Total Assets/ Equity

                                2) 1+ debt equity ratio 

Debt-equity ratio: Total Debt/Total Equity

the equity multiplier is a way of examining how a company uses debt to finance its assets. A higher equity multiplier indicates higher financial leverage, which means the company is relying more on debt to finance its assets.

Interest coverage ratio = EBIT/Interest Expense

A ratio used to determine how easily a company can pay interest on outstanding debt. The interest coverage ratio is calculated by dividing a company's earnings before interest and taxes (EBIT) of one period by the company's interest expenses of the same period:



Interest coverage ratio = EBIT/Interest Expense


The lower the ratio, the more the company is burdened by debt expense. And the result is depends on industry average.

Leverage Ratio / Debt to total Assets Ratios

Leverage Ratio / Debt to total Assets Ratio:

---

• Current liabilities to total assets = Current liabilities/total assets
• Long-term liabilities to total assets= Long-term liabilities/total assets
• Current plus long-term liabilities to total assets= Current plus long-term liabilities/total assets
• Current plus long-term plus preferred stock to total assets = Current plus long-term plus preferred stock/ total assets
• Interest coverage ratio = EBIT/Interest Expense 
• Capitalization ratio (long term debt / LTD + stockholders equity)

---

The capitalization ratio measures the debt component of a company's capital structure, or capitalization (i.e., the sum of long-term debt liabilities and shareholders' equity) to support a company's operations and growth.

Long-term debt is divided by the sum of long-term debt and shareholders' equity. This ratio is considered to be one of the more meaningful of the "debt" ratios - it delivers the key insight into a company's use of leverage.

There is no right amount of debt. Leverage varies according to industries, a company's line of business and its stage of development. Nevertheless, common sense tells us that low debt and high equity levels in the capitalization ratio indicate investment quality.

Ratios of Profitability Measures Calculation or Formula

Profitability Measures:

---

• Gross Income to sales = Gross Income/sales
• Gross income to net worth = Gross income/net worth
• Gross Income to total assets = Gross Income/total assets
• Gross income to total debt = Gross income/total debt
• Net income to sales = Net income/sales
• Net income to net worth (ROI)= Net income/net worth
• Net income to total assets (ROA) = Net income/total assets
• Net income to total debt = Net income/total deb
• Effective Tax Rate = (Income tax / Pre tax income)

Formula or Calculation of Cash Flow Coverage Ratio

Cash Flow Coverage Ratio (Operating cash flow / Short term debt)

---

This ratio measures the ability of the company's operating cash flow to meet its obligations - including its liabilities or ongoing concern costs.

The operating cash flow is simply the amount of cash generated by the company from its main operations, which are used to keep the business funded.

The larger the operating cash flow coverage for these items, the greater the company's ability to meet its obligations, along with giving the company more cash flow to expand its business, withstand hard times, and not be burdened by debt servicing and the restrictions typically included in credit agreements.

Free Cash Flow/Operating Cash Ratio

Free Cash Flow/Operating Cash Ratio (Free cash flow /Operating cash flow)

---

The free cash flow/operating cash flow ratio measures the relationship between free cash flow and operating cash flow.

Free cash flow is most often defined as operating cash flow minus capital expenditures, which, in analytical terms, are considered to be an essential outflow of funds to maintain a company's competitiveness and efficiency.

The cash flow remaining after this deduction is considered "free" cash flow, which becomes available to a company to use for expansion, acquisitions, and/or financial stability to weather difficult market conditions. The higher the percentage of free cash flow embedded in a company's operating cash flow, the greater the financial strength of the company.

Cash flow Ratios

Cash flow Ratio:

·         Cash inflow to sales= Cash Inflow/ sales

·         Cash outflow to sales = Cash outflow /sales

·         Operating cash flow to sales = Operating cash flow/sales

·         Financing cash flow to sales = Operating cash flow/sales

·         Investing cash flow to sales = Investing cash flow/sales

·         Cash flow to net wroth = Cash flow/net wroth

·         Cash flow to total assets = Cash flow/total assets

       Cash flow to total debt = Cash flow/total debt

·         This coverage ratio compares a company's operating cash flow to its total debt, which, for purposes of this ratio, is defined as the sum of short-term borrowings, the current portion of long-term debt and long-term debt. This ratio provides an indication of a company's ability to cover total debt with its yearly cash flow from operations. The higher the percentage ratio, the better the company's ability to carry its total debt.

Five Factors of ROE (Return On Equity) decomposition

This Five Factors of ROE decomposition is given bellow:

Normally ROE= NI/Equity but in five factors decomposition addition 4 items in total 6 items needed. those are:

NI=Net Income

EBT= Earning Before Tax

EBIT=Earning Before Interest & Tax

Sales= Total sales Amount

TA=Total Assets, &

Equity= or Total Equity.

Download as word formate