Market value of long term securities
Not what you're looking for?
The Savings and Loan (S&L) industry had an extremely difficult time during the 1980s, as interest rate levels reached new highs. The following problem illustrates the nature of these difficulties.
i) Assume an S&L's balance sheet is as follows. While this balance sheet is obviously over-simplified, it represents an approximation of the financial condition of many S&Ls. All values represent market values.
Assets: Liabilities and Equity:
Mortgage Loans $1,000,000 Deposits $1,300,000
Other Assets $600,000 Equity $300,000
Total Assets $1,600,000 Total L&E $1,600,000
ii) Assume the mortgage loan portfolio consists of 30-year, fixed-rate mortgages with an average interest rate of 5% per year. The present value of these mortgages (their principal) is currently $1,000,000.
iii) Find the monthly payment for this mortgage loan portfolio, using Excel's PMT function. (HINT: Set PV = outstanding principal, NPER = the life of the mortgages (in months), and RATE = the average interest rate (per month) for the mortgage loan portfolio.) FOR THIS PORTION I USED EXCEL'S PMT FUNCTION AND ARRIVED AT $50k FOR THE PAYMENT.
iv) Use your answer to part (iii) to determine the new market value of the mortgage loan portfolio, assuming that the market rate of interest rises to 9% per year. (HINT: Use Excel to find the PV of this portfolio, defining NPER as above, RATE = 8% per year divided by 12, and PMT = the value you obtained in part [a], problem 1) In the 1980s, actual market rates of interest rose by much more than this, with mortgage rates in the range of 12% or more uncommon. FOR THIS PORTION I USED EXCEL'S PV FUNCTION AND ARRIVED AT $6,814,714.71 THIS APPEARS TO BE HIGH AND I CANNOT FIGURE OUT WHY. I USED RATE=.0066667, NPER=360, PMT=-50,000.
v) Calculate the decline in market value of the mortgage loan portfolio that occurred by comparing your answer in part (iv) to the value of the portfolio as revealed in the balance sheet above.BY USING MY ANSWERS ABOVE THIS WOULD APPEAR TO ME THAT THE VALUE HAS RISEN NOT DECLINE. THIS IS WHY I THINK iv ABOVE IS INCORRECT. I NEED TO BE SHOWN WHERE I MISCALCULATED.
vi) Compare this decline in market value to the amount of equity on the S&L's balance sheet. Is the institution now insolvent? Explain.
I NEED HELP WITH iv, v, and vi. IT APPEARS AS THOUGH I PERFORMED iv INCORRECTLY.
Purchase this Solution
Solution Summary
The solution explains how to determine the value of long term securities using excel function
Solution Preview
iii) In this part you have taken the interest rate as 5% which is annual rate while the period is based on months and so the monthly payments are coming very high. With ...
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Six Sigma for Process Improvement
A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Marketing Management Philosophies Quiz
A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.