Explore BrainMass
Share

Real Estate Loan Calculations

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Problem 1: A loan was made 10 years ago with an original balance of $1,000,000.00 at a
fixed interest rate of 8.00% with equal monthly payments for 30 years.

A. How much is the monthly payment?
B. What is the balance today?
C. What will the balance be at the end of 5 more years?
D. When will the balance be paid down to 50% of the original balance?
E. How much would the borrower have to pay each month from now on in order to
repay the remaining balance in 10 more years?

Problem 2: An adjustable rate loan has a 2.50% margin with change caps of 2% per year
and a life cap of 5%. The start rate is 5%. The interest rate changes every 12 months.
Calculate the following for a $1,000,000 loan at these terms.
A. What is the payment for the first year?
B. What is the loan balance at the end of the first year?
C. Calculate the worst case scenario of payments for the first 4 years of this loan.
That means you will assume that the interest rate increases by the maximum
amount each year.
D. When the interest rate is adjusted for the first year, the loan index is 5.25%. What
interest rate will the borrower pay during the second year of this loan?
E. When the interest rate is adjusted for the first year, the loan index is 3.75%. What
interest rate will the borrower pay during the second year of this loan?

Problem 3: A lender makes a loan at Hybrid Option ARM at a fixed rate of 6.50%
interest for 7 years. The minimum required payment is calculated as 60% of the fully
amortized payment using a 30 year repayment term. The loan will recast if the balance
reaches 115% of the original amount. If the balance is recast, the borrower will be
required to pay the remaining balance over the remaining term at the full interest rate.

The minimum monthly payment is $10,000.00 per month.
A. What is the original amount of the loan?
B. If the borrower makes the minimum monthly payments, when will the loan
recast?
C. What will the new payment be for the month after the loan is recast?
D. What payment would be required so that the borrower would not hit the recast
until the end of 7 years (the fixed interest rate period of this loan.)?

© BrainMass Inc. brainmass.com October 16, 2018, 7:26 pm ad1c9bdddf
https://brainmass.com/business/finance/real-estate-loan-calculations-116021

Attachments

Solution Summary

This solution assists in specific real estate loan calculations

$2.19
Similar Posting

Finance: M1, M2 money supply; discount rates, bank's total assets, equity capital ratio

Determine the size of the M1 money supply using the following information. Currency plus traveler's checks $25 million, Negotiable CDs $10 million, Demand deposits $13 million Other checkable deposits $12 million

Following are components of the M1 money supply at the end of last year. What will be the size of the M1 money supply at the end of next year if currency grows by 10 percent, demand deposits grow by 5 percent, other checkable deposits grow by 8 percent, and the amount of traveler's checks stays the same?

Currency $700 billion
Demand deposits $300 billion
Other checkable deposits $300 billion
Traveler's checks $10 billion

Assume that a country estimates its M1 money supply at $20 million. A broader measure of the money supply, M2, is $50 million. The country's gross domestic product is $100 million. Production or real output for the country is 500,000 units or products.

a. Determine the velocity of money based on the M1 money supply.
b. Determine the velocity of money based on the M2 money supply.
c. Determine the average price for the real output

The One Product economy, which produces and sells only personal computers (PCs), expects that it can sell 500 more, or 12,500 PCs, next year. Nominal GDP was $20 million this year, and the money supply was $7 million. The central bank for the One Product economy plans to increase the money supply by 10 percent next year.

a. What was the average selling price for the personal computers this year?
b. What is the expected average selling price next year for personal computers if the velocity of money remains at this year's turnover rate? What percentage change in price level is expected to occur?
c. If the objective is to keep the price level the same next year (i.e., no inflation), what percentage increase in the money supply should the central bank plan for?
d. How would your answer in (c) change if the velocity of money is expected to be three times next year? What is it now?

The following three one-year 'discount' loans are available to you:
Loan A: $120,000 at a 7 percent discount rate
Loan B: $110,000 at a 6 percent discount rate
Loan C: $130,000 at a 6.5 percent discount rate

a. Determine the dollar amount of interest you would pay on each loan and indicate the amount of net proceeds each loan would provide. Which loan would provide you with the most upfront money when the loan takes place?
b. Calculate the percent interest rate or effective cost of each loan. Which one has the lowest cost?

Following are selected balance sheet accounts for Third State Bank: vault cash _ $2 million; U.S. government securities _ $5 million; demand deposits _ $13 million; non transactional accounts _ $20 million; cash items in process of collection _$4 million; loans to individuals _$7 million; loans secured by real estate _$9 million; federal funds purchased _$4 million; and bank premises _$11 million.

a. From these accounts, select only the asset accounts and calculate the bank's total assets.
b. Calculate the total liabilities for Third State Bank.
c. Based on the totals for assets and liabilities, determine the
amount in the owners' capital account.

Let's assume that you have been asked to calculate risk-based capital ratios for a bank with the following accounts:
Cash _ $5 million
Government securities _ $7 million
Mortgage loans _ $30 million
Other loans _ $50 million
Fixed assets _ $10 million
Intangible assets _ $4 million
Loan-loss reserves _ $5 million
Owners' equity _ $5 million
Trust-preferred securities _ $3 million

Cash assets and government securities are not considered risky. Loans secured by real estate have a 50 percent weighting factor. All other loans have a 100 percent weighting factor in terms of riskiness.

a. Calculate the equity capital ratio.
b. Calculate the Tier 1 Ratio using risk-adjusted assets.
c. Calculate the Total Capital (Tier 1 plus Tier 2) Ratio using risk-adjusted assets.

This problem focuses on bank capital management and various capital ratio measures. Following are recent balance sheet accounts for Prime First National Bank. Cash assets $ 17 million Demand deposits $50 million Loans secured by Time & savings
real estate 40 deposits 66
Commercial loans 45 Federal funds
purchased 15
Government Trust-preferred
securities owned 16 securities 2
Goodwill 5
Bank fixed assets 15 Owners' capital 5
Total assets $138 million Total liabilities $138 million
and owners'
capital
All amounts are in millions of dollars.

Note: The bank has loan-loss reserves of $10 million. The real estate
and commercial loans shown on the balance sheet are net of the
loan-loss reserves.

a. Calculate the equity capital ratio. How could the bank increase its equity capital ratio?
b. Risk-adjusted assets are estimated using the following weightings process: cash and government securities _.00; real estate loans _.50; commercial and other loans _ 1.00.
Calculate the risk-adjusted assets amount for the bank.
c. Calculate the Tier 1 Ratio based on the information provided and the risk-adjusted assets estimate from Part b.
d. Calculate the Total Capital (Tier 1 plus Tier 2) Ratio based on the information provided and the risk-adjusted assets estimate from Part b.
e. What actions could the bank management team take to improve the bank's Tier 1 and Total Capital ratios?

View Full Posting Details