Question

In: Finance

NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An investor has $60,000 to invest in a...

NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS.

An investor has $60,000 to invest in a 280,000 property. He can obtain either a $220,000 loan at 9.5 percent for 20 years or a $180,000 loan at 9 percent for 20 years and second mortgage for $40,000 at 13 percent for 20 years. All loans require monthly payments and are fully amortizing

a. Which alternative should the borrower choose, assuming he will own the property for the full loan term?

b. Would your answer change if the borrower plans to own the property only five years?

c. Would your answers to (a) and (b) change if the second mortgage had a 10 year term?

Solutions

Expert Solution

Sol. a.

Here, we need to calculate the monthly payments to compare both the options.

To calculate the same, we will use the Present Value of Ordinary Annuity formula as we already have the loan amount (present value) and payments need to be made at equal intervals (monthly).

Here, C will be the monthly payment.

i will be the interest rate of loan.

n will be the no. of installments.

Using the above formula in excel, we get the below results:

So, we shall choose the option 1 as the EMI is less.

Sol. b.

We shall choose option 1 only as the duration of holding the property would not affect the EMIs.

Sol. c.

(a) If we change mortgage term to 10 years, the EMI for Option 2 (B) would be 597

Total EMI for Option 2 = 1620 + 597 = 2217 for the first 10 years and 1620 for the next 10 years.

In this case, we need to calculate the Present Value of all the EMIs of both the options to decide which option is better.

Also, we would need to assume a risk free rate to calculate the same.

Calculating the Present Value of all EMIs in excel sheet we get:

If Risk Free Rate < 10% then PV 1 < PV 2

If Risk Free Rate = 10% then PV 1 = PV 2

If Risk Free Rate > 10% then PV 1 > PV 2

So depending upon the risk free rate, we shall choose which is better alternative.

(b) If property is hold for any tenure less than 10 years then we shall choose option 1 only as the EMIs for the first 10 years are less.


Related Solutions

NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An ARM for 100,000 is made at the...
NEEDS TO BE DONE IN EXCEL WITH CALCULATIONS. An ARM for 100,000 is made at the time when the expected start rate is 5 percent. The Loan will be made with a teaser rate of 2 percent for the first year, after which the rate will be reset. The loan is fully amortizing, has a maturity of 25 years, and payments will be made monthly. a. What will be the payments during the first year? b. Assuming that the reset...
An investor has $60,000 to invest in a $280,000 property. He can obtain either a $220,000...
An investor has $60,000 to invest in a $280,000 property. He can obtain either a $220,000 loan at 9.5 percent for 20 years or a $180,000 loan at 9 percent for 20 years and a second mortgage for $40,000 at 13 percent for 20 years. All loans require monthly payments and are fully amortizing. a. Which alternative should the borrower choose, assuming he will own the property for the full loan term? b. Would your answer change if the borrower...
1. An investor has $60,000 to invest in a $280,000 property. He can obtain either (option...
1. An investor has $60,000 to invest in a $280,000 property. He can obtain either (option A) a $220,000 loan at 9.5 percent for 20 years; or (option B) a $180,000 loan at 8.75 percent for 20 years and a second mortgage for $40,000 at 13 percent for 20 years. All loans require monthly payments and are fully amortizing. How much more would be the effective cost % if you went forward with option A instead of option B. I.e.,...
The Ratio Calculations should be done in a table in Excel and included with your submission....
The Ratio Calculations should be done in a table in Excel and included with your submission. The following ratios should be included for Pier 1 for 2 years: calculate these ratios below is a link to 10-K form Working Capital Current Ratio Total Debt to Total Equity Ratio Times Interest Earned RNOA ROCE Show calculations for pier 1 https://investors.pier1.com/financial-information/annual-reports
PLEASE SOLVE IN EXCEL WITH CALCULATIONS. An investor is considering the acquisition of a "distressed property"...
PLEASE SOLVE IN EXCEL WITH CALCULATIONS. An investor is considering the acquisition of a "distressed property" which is on Northlake Bank's REO list. the property is available for $200,000 and the investor estimates that he can borrow $160,000 at 8 percent interest and that the property will require the following total expenditures during the next year Inspection      $500 Title search   $1,000 Renovation.   $13,000 Landscaping $ 800 Loan Interest $12,800 Insurance.     $ 1800 Property Taxes $ 6000 Selling Expenses $8000 a....
Calculations must be done in Excel - Using the capital budgeting method of; Tax Effects, then...
Calculations must be done in Excel - Using the capital budgeting method of; Tax Effects, then Cash flows, then NPV. As the financial advisor to All Star Manufacturing you are evaluating the following new investment in a manufacturing project: - The project has a useful life of 12 years. Land costs $6m and is estimated to have a resale value of $10m at the completion of the project. Buildings cost $5m, with allowable depreciation of 10% pa reducing balance and...
Calculations must be done in Excel Polycorp is considering an investment in new plant of $3.2...
Calculations must be done in Excel Polycorp is considering an investment in new plant of $3.2 million. The project will be partially financed with a loan of $2,000,000 which will be repaid over the next five years in equal annual end of year instalments at a rate of 6.20 percent pa. The rest of the project will be financed by equity. Assume straight-line depreciation over a five-year life, and no taxes. The project’s cash flows before loan repayments and interest...
Calculations must be done in Excel As the financial advisor to Upmarket Car Rentals you are...
Calculations must be done in Excel As the financial advisor to Upmarket Car Rentals you are evaluating the following types of cars to add to the fleet: - Speedster: - A sporty convertible with a cost of $120,000 and a useful life of 4 years. It will produce rental income of $80,000 per year and operating costs of $15,000 per year. A major service is required after 2 years costing $20,000. A salvage value of $30,000 is expected after 4...
This needs to be done in Excel and that is where I am having issues Healthy...
This needs to be done in Excel and that is where I am having issues Healthy Snacks Co. produces snack mixes. Recently, the company has decided to introduce a new snack mix that has peanuts, raisins, pretzels, dries cranberries, sunflower seeds and pistachios. Each bag of the new snack is designed in order to hold 250 grams of the snack. The company has decided to market the new product with a emphasis on its health benefits. After consulting nutritionists, Healthy...
NEEDS TO BE DONE IN EXCEL. A price level adjusted mortage (PLAM) is made with the...
NEEDS TO BE DONE IN EXCEL. A price level adjusted mortage (PLAM) is made with the following terms: Amount=$95,000 Initial interest rate= 4 percent Term= 30 Years Points= 6 percent Payments to be reset at the beginning of each year. Assuming inflation is expected to increase at the rate of 6 percent per year for the next five years: a. Compute the payments at the beginning of each year (BOY) b. what is the loan balance at the end of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT