What is the buyers irr with the higher loan amount

Assignment Help Finance Basics
Reference no: EM133715898

It is December 31, 2019. You are considering purchasing a property offered for sale at 1540 Georgesville Road, Columbus, Ohio. A brochure is enclosed.

Price: You tried to negotiate the price down but failed. There are no transaction costs.

Rent: Rent is paid at the end of each month. The first payment will be on January 31.

Financing: You start discussing different financing structures with your local bank. Loan payments are at the end of the month.

1. The loan officer examines the rent schedule and notices that the rent is guaranteed until the end of August 2031.

She is offering you to use the entire rent amount during the guaranteed rent period to pay off the loan. In other words, the bank will collect the entire rent payment during the guaranteed period (you get zero income).

The loan is fully amortized over the loan term (i.e., the balance is $0 at the end of the term).

The interest rate on the loan is 5.1%.

What maximum amount would the bank be willing to lend you under these conditions?

HINT: Set up the cash flow schedule and amortization table. Then, vary the loan amount until it is fully amortized over the life of the loan.

Check the LTV of each loan amount to ensure you are using the correct interest rate.

2.What is the monthly IRR for the lender on this loan?

Enter your response as XX.xx%, e.g., for an answer of 5.13% (or 0.0513) type "5.13".

3.Now, suppose that you plan to sell the property in August 2031. Let's find the anticipated sales price, based on the following assumptions:

The tenant renews the rental contract as specified in the rent schedule at $10,212 monthly.
The exit cap rate is 6.90% + 0.5% = 7.40%
For simplicity, assume that the sales price can be calculated as (monthly NOI * 12 / Cap rate)
Calculate the sales price that you will expect to receive in August 2031.

4.Assume that the anticipated sales price is $1,700,000. Assume also the bank lent you $1,050,000 and that the loan was completely paid off using the rent payments until Aug 2031. This means the cash flows to the investor (you) are the net purchase amount (purchase price minus the loan amount; in negative sign), and the sales price in 2031.

What is the leveraged annual IRR to the investor ("cash-on-cash")?

Note: When calculating the IRR, Excel might show an Error. You may need to "guess" the IRR: "=IRR(CELLRANGE, 0.01).

After you calculate the monthly IRR, use the following formula: AnnualIRR=(1+MonthlyIRR)12-1

Enter your response as XX.xx%, e.g., for an answer of 5.13% (or 0.0513) type "5.13".

5. You convinced the loan officer to allow $1,000,000 of unpaid balance to remain outstanding in August 2031. The balance will be paid once you sell the property.

The loan officer agrees but increases the interest rate on this loan to 5.4%.

Recalculate the maximum amount that the lender will lend.

6. What will be the lender's IRR in this case?

Enter your response as XX.xx%, e.g., for an answer of 5.13% (or 0.0513) type "5.13".

7.What is the buyer's IRR with the higher loan amount? Assume that you borrowed $1,580,000 and that you will owe $1,000,000 in Aug 2031. This amount will be paid out of the sales price. As before, assume that the sales price will be $1,700,000.

Reference no: EM133715898

Questions Cloud

Define what it means by a replicating portfolio in this mark : Define what it means by a replicating portfolio in this market. (b) Define what it means by a portfolio that leads to an arbitrage.
How does race-ethnicity influence constructions of gender : How does race/ethnicity influence constructions of gender? Use points from Tough Guise 2 and Killing Us Softly 4 to discuss how constructions of masculinity.
Analyze financial measures for why microsoft would be : Analyze financial measures for why Microsoft would be the projected future leader of the artificial intelligence industry. It is expected that you will discuss
What roles did african american women play in various wars : What roles did African American women play in various wars? How have their roles changed in modern day military services?
What is the buyers irr with the higher loan amount : What is the buyers IRR with the higher loan amount? Assume that you borrowed $1,580,000 and that you will owe $1,000,000 in Aug 2031
Planning for patient with aspergers disorder : Planning for a patient with Aspergers disorder will be facilitated if the nurse understands that this disorder is different from autism.
Example of a positive and a negative effect of globalization : Example of a positive and a negative effect of globalization.
What is louises debt payments-to-income ratio : What is Louises debt payments-to-income ratio - Her monthly credit payments for Visa, MasterCard, and Discover cards are $43, $33, and $20, respectively
Many communities-especially underserved ones : Many communities, especially underserved ones, face resource constraints. These limitations can affect access to healthcare services,

Reviews

Write a Review

Finance Basics Questions & Answers

  Financial reporting and analysis

Finance is about Gunns Ltd, a company in dealing with forestry products in Australia. The company has also been listed in Australian Stock Exchange. As many companies producing forestry products, even Gunns Ltd is facing various problems. Due to the ..

  A report on financial accounting

This report is specific for a core understanding for Financial Accounting and its relevant factors.

  Describe the types of financial ratios

Describe the types of financial ratios and other financial performance measures that are used during venture's successful life cycle.

  Differences between sole proprietorship and corporation

Briefly describe the major differences between a sole proprietorship and a corporation

  Prepare a cash budget statement

Calculate the expected value of the apartment in 20 years' time. What is the mortgage loan repayment at the beginning of each month

  What are the implied interest rates

What are the implied interest rates in Europe and the U.S.?

  State pricing theory and no-arbitrage pricing theory

State pricing theory and no-arbitrage pricing theory

  Small business administration

Identify the likely stage for each venture and describe the type of financing each venture is likely to be seeking and identify potential sources for that financing.

  Effect of financial leverage

The Effect of Financial Leverage and working capital management

  Evaluate the basis for the payment to the lender

Evaluate the basis for the payment to the lender and basis for the payment to the company-counterparty.

  Importance of opps, ipps, mpfs and dmepos

Research and discuss the differences and importance of : OPPS, IPPS, MPFS and DMEPOS.

  Time value of money

Time Value of Money project

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd