Purchase Solution

Calculating Maximum amount of Loan

Not what you're looking for?

Ask Custom Question

Deflections, LLC, currently net leases its headquarters office building for $70,000 per month, and this lease has two years left to run. (Under a commercial fully net lease, the tenant pays for all maintenance, repairs, insurance and property taxes.) Deflections considers the rent to be less than the current market rate, but expected growth in its headquarters staff will require it to spend $1 million in repartitioning, wiring and lighting this office space. As an alternative, it is considering building its own HQ building and financing it with a down payment of $1 million and the remainder with a mortgage loan. Develop the following four alternatives for financing the project:

a. If this mortgage loan would be at 6.5% annual interest, amortized in equal monthly P&I payments over 25 years, and the company limits these payments to the same $70,000 per month, how much can it finance with this loan?

b. If this mortgage loan would be at 7.79% annual interest, amortized in equal monthly P&I payments over 30 years, and the company limits these payments to $55,000 per month, how much can it finance with this loan?

c. If this mortgage loan would be at 5.75% annual interest, amortized in equal monthly P&I payments over 25 years, and the company limits these payments to $62,000 per month, how much can it finance with this loan?

Purchase this Solution
Solution Summary

Solution describes the steps to calculate maximum loan amount possible with different combinations of annual interest rate and maximum monthly payments.

Solution Preview

Solution:

a. If this mortgage loan would be at 6.5% annual interest, amortized in equal monthly P&I payments over 25 years, and the company limits these payments to the same $70,000 per month, how much can it finance with this loan?

Rate of interest per month=r=6.5%/12=0.5417%
Number of installment=n=25*12=300
Maximum Monthly Payments=C=$70000
Present Value of annuity=C/r*(1-1/(1+r)^n)
=70000/0.5417%*(1-1/(1+0.5417%)^300)
=$10,366,805
Amount that can be financed with this Loan amount=$10,366,805

b. If ...

Solution provided by:
Lokesh Jain, MSc
Education
  • BEng (Hons) , Birla Institute of Technology and Science, India
  • MSc (Hons) , Birla Institute of Technology and Science, India
Recent Feedback
  • "Thank you"
  • "Really great step by step solution"
  • "I had tried another service before Brain Mass and they pale in comparison. This was perfect."
  • "Thanks Again! This is totally a great service!"
  • "Thank you so much for your help!"
Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Operations Management

This quiz tests a student's knowledge about Operations Management

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

View More Free Quizzes
Related BrainMass Solutions

  • Cost of short-term bank loan-Line of credit

    Again, assume the full amount of the loan is outstanding for a whole year.

  • Present Value of an annuity

    The bank will give you a loan @ 8.25% APR compounded monthly, which should be paid off in 3 years. But, the bank says my maximum monthly payment can be no more than $250.00. Closing costs are 8% of the loan amount.

  • Calculating loan amount

    =$7,173,255.37 Amount that can be financed with this Loan amount =$7,173,255.37 Solution explains the steps to determine maximum amount that can be financed in the given situations.

  • Calculating loan amount

    =$5977712.81 Amount that can be financed with this Loan amount =$5977712.81 Solution explains the steps to determine maximum amount that can be financed in the given situations.

  • Calculating the Mexican Peso Cost of a Dollar Loan

    573895 Calculating the Mexican Peso Cost of a Dollar Loan Suppose on that on January 1st a Mexican firm borrows $20 million from Citibank (USA) for one year at 8.00% interest per annum. The loan was taken when the spot rate was USD/MXP3.40.

  • Calculating dollar cost of a JPY loan

    Value of loan in dollar terms=100/120 =$ 0.8333 million Repayment amount at the end of 1 year=100*(1+3%)=103 JPY Repayment amount at the end of 1 year in dollar terms=103/95=$ 1.0842 million Percent dollar cost=(1.0842-0.8333)/0.8333=30.1%.

  • Calculating Bank Fees on a Loan

    451976 Calculating Bank Fees on a Loan You take a loan on $500,000 for 30 years at the annual nominal interest rate of 6% compounded monthly. The loan installments also have to be paid monthly. The bank's APR is 6.7%.

  • Calculating EMI for a loan

    steps for calculating EMI and total interest paid during the loan period.

  • Managerial Finance

    Using the free cash flow valuation method, what is the maximum amount you would be willing to pay for this company? 5. Knowing that you are bidding against your classmates for this company, what amount would you choose to bid?

View More Related Solutions