Question

In: Finance

Emma has not yet decided whether she wants to rent or buy a property here in...

Emma has not yet decided whether she wants to rent or buy a property here in Oxford and she is asking your team to help her make this financial decision. Her monthly budget is $1,500 to cover any housing expenses including rent or owners’ costs (example: mortgage, hazard insurance, property taxes, and Home Owner Association fees). A good start of the analysis is by applying financial concepts such as the “time value of money.” Emma’s contract is for three years and is renewable for three more. Her plan is to stay in the Oxford area for no more than 8 years. Even if her job continues to work out well, she will try to move from the location she selects to a bigger house.

Estimate the maximum house value she can afford to buy. Assume the mortgage is fixed rate, 30 years maturity, 80% LTV, with no points. The interest rate that she was quoted is 4.8% with monthly payments. The property tax rate in the city of Oxford is 0.7% per year of the property value; the hazard insurance premium is 0.5% per year, and that on average you should consider $50 per month for maintenance. Determine the required monthly payment for the mortgage and the maximum house value she can afford if she buys. With this maximum house value select one that Emma can afford and follow the instruction for the case.

Solutions

Expert Solution

Let's say that A be the mortgage amount Emma is able to pay per month to service the mortgage.

Frequency = monthly, Period = month

Interest rate per period, R = Interest rate per month = 4.8% / 12 = 0.40%

Number of periods, N = nos. of months in 30 years = 12 x 30 = 360

Hence, the present value of mortgage payments = Loan amount = PV of annuities, A = A / R x [1 - (1 + R)-N]

= A / 0.4% x [1 - (1 + 0.4%)-360] =  190.60A

LTV = 80%

Hence, maximum value of house = Loan amount / LTV = 190.60A / 80% = 238.25A

Property tax rate in the city of Oxford = 0.7% per year of the property value = 0.7% x 238.25A = 1.67A

Monthly property tax = 1.67A / 12 = 0.14A

The hazard insurance premium = 0.5% per year

Hence monthly payment = 0.5% x 238.25A / 12 = 0.10A

$50 per month for maintenance

Monthly budget towards house = $ 1,500

Hence, Monthly mortgage payment + monthly property tax + monthly hazard insurance premium + monthly maintenance expense = 1,500

Hence, A + 0.14A + 0.10A + 50 = 1,500

Or, 1.24A = 1,500 - 50 = 1,450

Hence, A = 1,450 / 1.24 = $ 1,169.35

Hence, the required monthly payment for the mortgage, A = $ 1,169.35

and the maximum house value she can afford if she buys =  238.25A = $ 278,599 (can be rounded off to $ 278,600 as well)


Related Solutions

Emma Jones s plain to move this coming summer. She has not yet decided whether she...
Emma Jones s plain to move this coming summer. She has not yet decided whether she wants to rent or buy a property here in Mississippi. Her monthly budget is $1500 to cover any housing expenses including rent or owners' costs (example: mortgage, hazard insurance, property taxes, and Home Owner Association fees). Estimated the maximum house value she can afford to buy. Assume the mortgage is fixed rate, 30 years maturity, 80% LTV, with no points. The interest rate that...
In January 2004, Mr. Pandit decided to buy a residential property and rent to various tenants....
In January 2004, Mr. Pandit decided to buy a residential property and rent to various tenants. On 1st January 2004, he borrowed Rs. 30 Lakhs from a housing bank on a condition of repaying the loan in 10 annual installments with an interest @10% per annum. He put in his own savings of Rs. 15 Lakhs and bought a property having 5 flats in a fast developing locality. The cost of the property was Rs. 30 Lakhs comprising land valued...
Juanita is deciding whether to buy a dress that she wants, as well as where to buy it.
Juanita is deciding whether to buy a dress that she wants, as well as where to buy it. Three stores carry the same dress, but it is more convenient for Juanita to get to some stores than others. For example, she can go to her local store, located 15 minutes away from where she works, and pay a marked-up price of $103 for the dress:StoreTravel Time Each WayPrice of a Dress(Minutes)(Dollars per dress)Local Department Store15103Across Town3089Neighboring City6063Juanita makes $16 an...
Juanita is deciding whether to buy a dress that she wants, as well as where to buy it
Juanita is deciding whether to buy a dress that she wants, as well as where to buy it. Three stores carry the same dress, but it is more convenient for Juanita to get to some stores than others. For example, she can go to her local store, located 15 minutes away from where she works, and pay a marked-up price of $129 for the dress:StoreTravel Time Each Way (Minutes)Price of a Dress (Dollars per dress)Local Department Store15129Across Town3086Neighboring City6063Juanita makes \(\$...
Juanita is deciding whether to buy a skirt that she wants, as well as where to...
Juanita is deciding whether to buy a skirt that she wants, as well as where to buy it. Three stores carry the same skirt, but it is more convenient for Juanita to get to some stores than others. For example, she can go to her local store, located 15 minutes away from where she works, and pay a marked-up price of $130 for the skirt:Travel Time Each WayPrice of a SkirtStore(Minutes)(Dollars per skirt)Local Department Store15130Across Town3086Neighboring City6060Juanita makes $70 an...
Hazel Nutt plans on living in NYC. Hazel is considering whether she should buy or rent....
Hazel Nutt plans on living in NYC. Hazel is considering whether she should buy or rent. If Ms. Nutt buys the Co-Op apartment it will cost $550,000.  This price includes all closing costs. Annual home ownership information: Property taxes:  1.5% of the property price Insurance:  1% of the property price Maintenance:  1.5% of the property price Mortgage loan:  Assume Hazel will get a $450,000, 4%, 30-year interest only (IO) loan. There are no closing costs or points for the mortgage. Hazel’s marginal income tax rate...
. Determining opportunity cost Juanita is deciding whether to buy a suit that she wants, as...
. Determining opportunity cost Juanita is deciding whether to buy a suit that she wants, as well as where to buy it. Three stores carry the same suit, but it is more convenient for Juanita to get to some stores than others. For example, she can go to her local store, located 15 minutes away from where she works, and pay a marked-up price of $129 for the suit:    Store Travel Time Each Way Price of a Suit (Minutes)...
Determining opportunity cost Juanita is deciding whether to buy a skirt that she wants, as well...
Determining opportunity cost Juanita is deciding whether to buy a skirt that she wants, as well as where to buy it. Three stores carry the same skirt, but it is more convenient for Juanita to get to some stores than others. For example, she can go to her local store, located 15 minutes away from where she works, and pay a marked-up price of $100 for the skirt: Store Travel Time Each Way Price of a Skirt (Minutes) (Dollars per...
Article: Anheuser-Busch Orders 40 Tesla Semi Trucks (Brewer hasn't yet decided whether to buy vehicles outright...
Article: Anheuser-Busch Orders 40 Tesla Semi Trucks (Brewer hasn't yet decided whether to buy vehicles outright or lease them as it seeks to cut fuel costs and vehicle emissions. Forget the Clydesdales. Anheuser-Busch has reserved 40 of Tesla Inc.’sTSLA -1.15% all-electric Semi trucks, as the maker of Budweiser seeks to reduce fuel costs and vehicle emissions. The U.S. subsidiary of Anheuser-Busch InBev BUD -2.22% NV plans to use the trucks for shipments to wholesalers within 150 to 200 miles of...
Ed wants to buy a property for $320,000 and wants a CPM loan for 80%. A...
Ed wants to buy a property for $320,000 and wants a CPM loan for 80%. A lender indicates the loan can be obtained for 30 years at 5.5% with an origination loan fee of $1,200 and 2 points. If Ed repays the loan after five years, is the effective interest cost different from the APR? If so, why? The effective interest cost is the same as the APR. Although there was less time over which to spread the origination loan...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT