Question

In: Finance

39) You are looking to purchase a property for 400,000. You have received two quotes. The...

39) You are looking to purchase a property for 400,000. You have received two quotes. The first quote is an 90% ltv 360-month amortization with a rate of 6%. The second offer comes from two sources. The first mortgage is 65% at 4.5% with 360-month amortization and the second mortgage takes the leverage to 90% at a rate of 12% with 360-month amortization. Which deal would you take?  
                                                          

Solutions

Expert Solution

ANSWER : OPTION 1 is better

As the monthly payments in Option 1 ($ $2,158.38) is less than the Total Monthly payments in option 2 ($ 2345.99).

Calculation of Monthly payments in both the proposals:

OPTION 1:

Particulars in formula Values Calculation
Purchase price 400000
Loan Amount PV 360000 =400000*90%
Number of Periods NPER 360
Annual Rate 6%
Rate Per period RATE 0.005 =Annual Rate/12
Monthly Payments PMT $2,158.38
Formulae used "=PMT(0.005,360,360000)"
"=PMT(RATE,NPER,PV)"

MONTHLY PAYMENTS IN OPTION 1 = $2158.38

OPTION 2

First mortgage

Particulars in formula Values Calculation
Purchase price 400000
Loan Amount PV 260000 =400000*65%
Number of Periods NPER 360
Annual Rate 5%
Rate Per period RATE 0.00375 =Annual Rate/12
Monthly Payments PMT $1,317.38
Formulae used "=-PMT(0.00375,360,260000)"
"=-PMT(RATE,NPER,PV)"
Second mortgage:
Particulars in formula Values Calculation
Purchase price 400000
Loan Amount PV 100000 =400000*25%
Number of Periods NPER 360
Annual Rate 12%
Rate Per period RATE 0.01 =Annual Rate/12
Monthly Payments PMT $1,028.61
Formulae used "=-PMT(0.01,360,100000)"
"=-PMT(RATE,NPER,PV)"

TOTAL MONTHLY PAYMENTS UNDER OPTION 2 = $1,317.38 + $1,028.61 = $ 2345.99


Related Solutions

Assume you wish to purchase a property for $400,000 and you are evaluating two mortgage choices....
Assume you wish to purchase a property for $400,000 and you are evaluating two mortgage choices. You are only able to afford a 10% downpayment, so you have the following options. The first option is a 4.75% fully amortizing, monthly payment, fixed rate loan for 30 years with $2000 in origination fees and no points. This loan is for 90% of the purchase price. Alternatively, you can borrow 80% of the purchase price at a rate of 3.875%, with $4000...
Steven is looking to purchase an investment property, and is interested in a particular apartment on...
Steven is looking to purchase an investment property, and is interested in a particular apartment on London Street. This apartment costs $500,000. Steven has also estimated that the other upfront costs for purchasing the apartment will total $5,000. Steven has also spoken to his real estate agent Ray and his banker Jane, and gathered the following additional information: Strata for the apartment is estimated at $700 per quarter in arrears. Council rates are estimated at $500 per year payable in...
Problem 39: You have just turned 30 years old, have just received your MBA, and have...
Problem 39: You have just turned 30 years old, have just received your MBA, and have accepted your first job. Now you must decide how much money to put into your RRSP. Your RRSP works as follows: Every dollar in the plan earns 7% per year. You cannot make withdrawals until your 65th birthday. After that point, you can make withdrawals as you see fit. You decide that you will plan to live to 100 and work until you turn...
As the community health LPN, you have received a referral for a 39-year old Indonesian lady...
As the community health LPN, you have received a referral for a 39-year old Indonesian lady for staple removal, post-op emergency cholecystectomy. Upon arrival to the home, you observe broken glass around the entrance of the basement apartment and note it is in desperate need of repairs. One of the windows has been boarded up and the step has a board missing and the wood looks rotten. The client answers the door, carrying a 2-year child on her hip and...
As the community health LPN, you have received a referral for a 39-year old Indonesian lady...
As the community health LPN, you have received a referral for a 39-year old Indonesian lady for staple removal, post-op emergency cholecystectomy. Upon arrival to the home, you observe broken glass around the entrance of the basement apartment and note it is in desperate need of repairs. One of the windows has been boarded up and the step has a board missing and the wood looks rotten. The client answers the door, carrying a 2-year child on her hip and...
As the community health LPN, you have received a referral for a 39-year old Indonesian lady...
As the community health LPN, you have received a referral for a 39-year old Indonesian lady for staple removal, post-op emergency cholecystectomy. Upon arrival to the home, you observe broken glass around the entrance of the basement apartment and note it is in desperate need of repairs. One of the windows has been boarded up and the step has a board missing and the wood looks rotten. The client answers the door, carrying a 2-year child on her hip and...
You have bought a property and have four different options on how to pay for the property purchase. The four options are:
                     Part a. You have bought a property and have four different options on how to pay for the property purchase. The four options are: $ 200,000 p.a. paid every year for five years with the first payment paid at the end of the first year. $250,000 p.a. for six years with the first payment paid at the end of the first year. $1,000,000 at the end of the fifth year...
Suppose that you have decided to purchase a house for $400,000 using an adjustable-rate mortgage with...
Suppose that you have decided to purchase a house for $400,000 using an adjustable-rate mortgage with the terms provided below. Loan-to-value ratio: 90% Index rate: one-year Treasury yield (currently 3.00%) Margin: 250 basis points Amortization: 15 years with monthly payments and compounding Annual cap: 1.5 percentage points Lifetime cap: 5 percentage points Adjustment period: Annually Teaser Rate 2.50% What is the monthly payment during the first year of the loan? a. $2400.44,b. $2133.73,c. $3268.33, d. $2667.16, e. None of the...
You are considering two loans to finance a purchase of a property valued at $100,000 at...
You are considering two loans to finance a purchase of a property valued at $100,000 at LTV of 70%. Loan A is a fixed-rate mortgage with amortization term of 30 years. The annual interest rate is 8% and the payments are made monthly. Prepayment penalty if the loan is paid off within first 10 years is 3%. Loan B is an adjustable rate mortgage with an amortization term of 30 years. The initial rate is 4%, but the rate is...
Part a. You have bought a property and have four different options on how to pay for the property purchase. The four options are
Part a.            You have bought a property and have four different options on how to pay for the property purchase. The four options are:$ 200,000 p.a. paid every year for five years with the first payment paid at the end of the first year.$250,000 p.a. for six years with the first payment paid at the end of the first year.$1,000,000 at the end of the fifth year and $1,250,000 at the end of the 10th year.A $20,000 deposit paid now...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT