In: Finance
The Ellis Corporation has heavy lease commitments. Prior to SFAS No. 13, it merely footnoted lease obligations in the balance sheet, which appeared as follows: Use Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. In $ millions In $ millions Current assets $ 75 Current liabilities $ 35 Fixed assets 75 Long-term liabilities 20 Total liabilities $ 55 Stockholders' equity 95 Total assets $ 150 Total liabilities and stockholders' equity $ 150 The footnotes stated that the company had $15 million in annual capital lease obligations for the next 15 years. a. Discount these annual lease obligations back to the present at a 11 percent discount rate. (Do not round intermediate calculations. Round your answer to the nearest million. Input your answer in millions of dollars (e.g., $6,100,000 should be input as "6").) b. Construct a revised balance sheet that includes lease obligations. (Do not round intermediate calculations. Round your answers to the nearest million. Input your answer in millions of dollars (e.g., $6,100,000 should be input as "6").) c. Compute the total debt to total asset ratio for the original and revised balance sheets. (Input your answers as a percent rounded to 2 decimal places.) d. Compute the total debt to total equity ratio for the original and revised balance sheets. (Input your answers as a percent rounded to 2 decimal places.) e. In an efficient capital market environment, should the consequences of SFAS No. 13, as viewed in the answers to parts c and d, change stock prices and credit ratings? Yes No
We have following balance sheet given
| 
 Labilities  | 
 Amt  | 
 Assets  | 
 Amt  | 
| 
 Current assets  | 
 75  | 
 Current liabilities  | 
 35  | 
| 
 Fixed assets  | 
 75  | 
 Long-term liabilities  | 
 20  | 
| 
 Total liabilities  | 
 55  | 
||
| 
 Stockholders' equity  | 
 95  | 
||
| 
 Total Assets  | 
 150  | 
 Total liabilities and stockholders' equity  | 
 150  | 
$15 million in annual capital lease obligations for the next 15 years.
a.
Discounting of lease at 11%
PV of leases = $15,000,000 × ({1 ? [1 / (1.11) 15 ]} / 0.11)
= 7.19 * 15000000 = $107863043
= $108 million rounded
b.
Revised Balance sheet
| 
 Labilities  | 
 Amt  | 
 Assets  | 
 Amt  | 
| 
 Current assets  | 
 75  | 
 Current liabilities  | 
 35  | 
| 
 Fixed assets  | 
 75  | 
 Long-term liabilities  | 
 20  | 
| 
 Leased Property  | 
 108  | 
 Obligations under capital lease  | 
 108  | 
| 
 Total liabilities  | 
 163  | 
||
| 
 Stockholders' equity  | 
 95  | 
||
| 
 Total Assets  | 
 258  | 
 Total liabilities and stockholders' equity  | 
 258  | 
c.
Total debt to total asset ratio
Total debt = $55 million
Total assets = $150 million
Therefore ratio = 55/150 = 0.3667 = 36.67%
Revised: Total debt = $163 million
Total assets = $258 million
Therefore ratio = 163/258 = 0.6317 = 63.17%
d.
Total debt to total equity ratio
Total debt = $55 million
Total equity = $95 million
Therefore ratio = 55/95 = 0.5789 = 57.89%
Revised: Total debt = $163 million
Total equity = $95 million
Therefore ratio = 163/95 = 1.7157 = 171.57%
e. No, no change will be observed since the required information is available before preparing a balance sheet.
Note:
For financial calculator:
| 
 N  | 
 R  | 
 PV  | 
 PMT  | 
 FV  | 
| 
 15  | 
 11  | 
 CPT PV - 107863043  | 
 15000000  | 
 0  |