Balance Sheet and Market Value of Your Company's Liabilities and Equity
Refer to Time Warner's most recent balance sheet. Review the 'liabilities and equity side' of the balance sheet.
(a) Short term liabilities (or debt)
Find out from the balance sheet of the company the total of the short term liabilities (also called 'short term debt'). You may assume that the market value of the short term debt is equal to the balance sheet or the 'book value' of the short term debt.
(b) Long term liabilities (or debt)
You may assume that the market value of the long term liabilities is equal to the balance sheet values.
The market value of equity is by definition equal to the number of shares outstanding times the market price per share. Find out the number of shares outstanding and the recent price per share. Then multiply one by the other in order to find the market value of equity of your company. If you have a problem finding the number of shares outstanding you may go to http://finance.google.com and insert the name of your company (Time Warner). The market value of equity of your company is what is called 'Mkt Cap' (that is, Market Capitalization) that is market capitalization. An alternative site is http://finance.yahoo.com where again you insert Time Warner's name and get the market capitalization.
(d) The Market Value of the Enterprise
Now prepare a table that contains the following:
Company name:...(Time Warner)
Source of Funds Balance sheet Values
As of .... (date) Market Values
As of ... (date)
Short term liabilities
Long term liabilities
Total shareholders equity
Total liabilities and equity
Compute the debt ratio of Time Warner(total liabilities divided by the total liabilities plus equity) and the debt to equity ratio, (total liabilities divided by total equity) once based on balance sheet values and once based on 'market values'. What can you learn from comparing each of these ratios when they are based on 'balance sheet values' and when they are based on 'market values'? Write a two to three page report on the results of your computations.
Kindly see the attached file for the calculations.
The above ratios indicates solvency position
The long-term creditor is concerned with both the near-term and the long-term ability of a firm to meet its commitments. Long-term creditors are usually protected to some degree by restrictive covenants, or rules, in loan agreements that restrict the firm's ability to take actions that are not in the best interests of the creditors. Before entering into a loan agreement, creditors very carefully examine the firm's financial condition and pay particular attention to the following two ratios.
Debt-to-Equity Ratio. Long-term creditors would like a reasonable balance between the capital provided ...
This explains the steps to compute Balance Sheet and Market Value for Time Warner
Time Warner's: Capital Structure and Cost of Capital
For this task, you are computing and report on the weighted average cost of capital (WACC) estimate for Time Warner.
To this end it will be useful to use the following table:
COMPANY NAME:____________________________ Balance sheet date:_______________
Market values date:_______________
SOURCE BOOK VALUE MARKET VALUE PROPORTIONS COST (%) PRODUCT
(a) (b) (c) (d) (e) (f) = (d) x (e)
Short term liabilities
Long term liabilities
The book values in column (b) are values that appeared in the most recent balance sheet of Time Warner. You are to add together all of the items that appear under shareholders' equity into one number - the total.
The total of the book value is of course equal to the 'book' or 'balance sheet' value of the firm's assets.
In column (c) insert your estimates of the 'market values'.
- For short term liabilities: you are to assume that the market value is equal to the 'book value'.
- For long term liabilities - use the present value of the long term liabilities that you have estimated in SLP3. Please review your work on the former section of the Session Long Project.
- For equity - the market value of equity is the total number of shares outstanding times the market price per share as of the date that you are working on the SLP. Please state the date for which you obtained this market price in the line that spells "Market value date" above.
- Now add the three items in the Market Value column. The sum total of the three items in the market value column, column (c), is the market value of the enterprise.
In column (d) insert the proportion of each item. You do this by dividing each number in column (c) by the total of this column. Please write the proportions up to four digits after the decimal point. The sum of these proportions must add up to 1.0000.
In column (e) you insert the cost of each of the sources of financing:
- For short term liabilities please find out what is the present rate of interest that companies pay on short term loans. You may ask your banker or consult the following web site: http://www.thefinancials.com/free/EX_Interest_MajorST.html.
- You may assume that Time Warner is currently paying the non-financial CD rate (Third line in the table of the web site). The cost of short term liabilities is the after tax cost, that is: the interest rate times (1 - T), where T is the corporate tax rate that you may assume T = 0.34 (that is 34%.)
- For long term liabilities: either use the yield to maturity of your corporate bonds (if available) by taking an average of the different bonds that were issued by Time Warner and that are traded, or you may assume that you company pays on its long term liabilities an interest rate that is about 1% higher than the present yield to maturity of a 5-year US Government bond. You therefore find out the present yield to maturity on a 5-year US Government bond, for example here, http://www.bloomberg.com/markets/rates/index.html and add 1% to that yield. You then multiply the result by (1 - T) because interest on company's debt are deductible for tax purposes and the effective after tax cost of debt is the yield the company is to pay times (1 - T).
- For equity: Use the beta of Time Warner and the computation of the cost of equity from the previous report of the Session Long Project to insert the cost of equity (in %). Note: the cost of equity is not a deductible expense for tax purposes and therefore this number is not multiplied by (1 - T). It follows that the most expensive source of funds is shareholder's money.
Do not sum up the numbers in column (e).
In column (f) you simply insert the product of each number in column (d) by the corresponding number in column (e).
You now add up the first three numbers in column (f).
The sum of these numbers is Time Warner's weighted average cost of capital (WACC.)
Prepare a report describing the computations of the weighted average cost of capital of Time Warner. You'll be using the report for the final part of the Session Long Project.View Full Posting Details