Question

In: Finance

1. Deciding to Buy. Dave and Diane Starr of New Orleans, Louisiana, both of whom are...

1. Deciding to Buy. Dave and Diane Starr of New Orleans, Louisiana, both of whom are in their late 20s, currently are renting an unfurnished two-bedroom apartment for $1,200 per month, plus $230 for utilities and $34 for insurance. They have found a condominium they can buy for $170,000 with a 20 percent down payment and a 30-year, 6.5 percent mortgage. Principal and interest payments are estimated at $860 per month, with property taxes amounting to $150 per month and a homeowner's insurance premium of $900 per year. Closing costs are estimated at $4,200. The monthly homeowners association fee is $275, and utility costs are estimated at $240 per month. The Starrs have a combined income of $90,000 per year, with take-home pay of $5,800 per month. They are in the 25 percent tax bracket, pay $225 per month on an installment loan (ten payments left), and have $39,000 in savings and investments outside of their retirement accounts.

(d) Available financial information suggests that mortgage rates might increase over the next several months. If the Starrs wait until the rates increase 1/2 of 1 percent, how much more will they spend on their monthly mortgage payment?

N

30 x 12 = 360

30 x 12 = 360

I/Y

6.5 / 12 = 0.5417

7 / 12 = 0.5833

PV

170,000 x (1 - 0.20) = 136,000

170,000 x (1 - 0.20) = 136,000

PMT

CPT

CPT

FV

0

0

Total payments (PMT x 360)

Total financing costs (Total payments - PV)

Solutions

Expert Solution

Ans.

Total cost of house is $170,000

Total loan to be taken = 170,000 x (1 - 0.20) = $136,000

Current annual Interest rates = 6.5%, current monthly interest rate = 6.5% / 12= 0.5417%

number of monthly periods = 30 * 12 = 360

Monthly installment (payment) on loan = $860 (859.6)

If interest rate increases by 0.5% to 7%, Monthly interest rate = 7%/12 = 0.583%

using excel formula,

Monthly installment for new monthly interest rate of 0.583% =PMT(0.583%,360,-136000,0)

New Monthly payment = $904.8

Increase in monthly mortgage payment = 904.8 - 859.6

Increase in monthly mortgage payment = $45.2

They will have around $45 additionally on monthly mortgage payment if interest increase by 0.5% to 7%

N 30 x 12 = 360 30 x 12 = 360
I/Y 6.5 / 12 = 0.5417 7 / 12 = 0.5833
PV 170,000 x (1 - 0.20) = 136,000 170,000 x (1 - 0.20) = 136,000
PMT CPT CPT
FV 0 0
Total payments (PMT x 360) 859.6*360= 309,461 904.8*360= 325,732
Total financing costs (Total payments - PV) (309,461-136,000) = 173,461 (325,732-136,000) = 189,732

Related Solutions

In this discussion, you are the IT manager for a four-year university in New Orleans, Louisiana....
In this discussion, you are the IT manager for a four-year university in New Orleans, Louisiana. The IT department supports the computer network requirements for over 6,000 students, 300 faculty members, and 200 staff members – plus a conference network for distinguished guests. See Exploration 2 for tips on how to complete this discussion. Instructions In your initial response, address the following points: Describe the major areas that you need to include in your Emergency Action Plan and why they...
In 2011, New Orleans, Louisiana experienced an aggressive recession as compared to the rest of country....
In 2011, New Orleans, Louisiana experienced an aggressive recession as compared to the rest of country. With unemployment rates topping 15%, the city was faced with many challenges financially, economically, and socially. In addition to the financial challenges, the city was also experiencing political instability and corruption. Various major city officials were being investigated for fraud, bribery, and other criminal charges. Spark Electric, operating as a natural monopoly, was the only company in the area providing electric services to New...
Haydel enterprises owned and operated a bakery in New Orleans, Louisiana, selling pastries such as Mardi...
Haydel enterprises owned and operated a bakery in New Orleans, Louisiana, selling pastries such as Mardi Gras king cakes. Haydel asked an artist to design a “bead dog” to replicate the dogs made out of beads thrown at Mardi Gras celebrations. Haydel registered the words “MarDi Gras BeaD DOG” and the bead dog design as trademarks covering items such as king cake pastries, jewelry, and clothing. Over a six-year period, Haydel sold about 80 clothing items and 300 jewelry items...
Haydel enterprises owned and operated a bakery in New Orleans, Louisiana, selling pastries such as Mardi...
Haydel enterprises owned and operated a bakery in New Orleans, Louisiana, selling pastries such as Mardi Gras king cakes. Haydel asked an artist to design a “bead dog” to replicate the dogs made out of beads thrown at Mardi Gras celebrations. Haydel registered the words “MarDi Gras BeaD DOG” and the bead dog design as trademarks covering items such as king cake pastries, jewelry, and clothing. Over a six-year period, Haydel sold about 80 clothing items and 300 jewelry items...
The port of South Louisiana, located along 54 miles of the Mississippi River between New Orleans...
The port of South Louisiana, located along 54 miles of the Mississippi River between New Orleans and Baton Rouge, is the largest bulk cargo port in the world. The U.S. Army Corps of Engineers reports that the port handles a mean of 4.5 million tons of cargo per week.† Assume that the number of tons of cargo handled per week is normally distributed with a standard deviation of 0.89 million tons. (a) What is the probability that the port handles...
The port of South Louisiana, located along 54 miles of the Mississippi River between New Orleans...
The port of South Louisiana, located along 54 miles of the Mississippi River between New Orleans and Baton Rouge, is the largest bulk cargo port in the world. The U.S. Army Corps of Engineers reports that the port handles a mean of 4.5 million tons of cargo per week (USA Today, September 25, 2012). Assume that the number of tons of cargo handled per week is normally distributed with a standard deviation of .82 million tons. a. What is the...
In August in September 2005, hurricanes Katrina and Rita caused extraordinary flooding in New Orleans, Louisiana....
In August in September 2005, hurricanes Katrina and Rita caused extraordinary flooding in New Orleans, Louisiana. Many homes were severely damaged or destroyed, and of those that survived, many required extensive cleaning. It was thought that cleaning flood-damaged homes might present a health hazard due to the large amount of mold present in many of the homes. In a sample of 365 residents of Orleans Parish who had participated in the cleaning of one or more homes, 77 had experienced...
After deciding to buy a new car, you can either lease the car or purchase it...
After deciding to buy a new car, you can either lease the car or purchase it on a two-year loan. The car you wish to buy costs $36,000. The dealer has a special leasing arrangement where you pay $101 today and $501 per month for the next two years. If you purchase the car, you will pay it off in monthly payments over the next two years at an APR of 5 percent. You believe you will be able to...
7. After deciding to buy a new car, you can either lease the car or purchase...
7. After deciding to buy a new car, you can either lease the car or purchase it on a three-year loan. The car you wish to buy costs $44,000. The dealer has a special leasing arrangement where you pay $1,000 per month, at the beginning of each month, for the next three years. If you purchase the car, you will pay it off in monthly payments over the next three years at a 3.6% APR. You believe you will be...
Your company is deciding whether to buy a new production equipment worth $25 mil and has...
Your company is deciding whether to buy a new production equipment worth $25 mil and has employed a consultant to evaluate the decision. Your boss is unhappy with the following report: 1 2 ... 9 10 Revenue $30,000 $30,000 $30,000 $30,000 COGS $18,000 $18,000 $18,000 $18,000 Gross Profit $12,000 $12,000 $12,000 $12,000 SG&A $2,000 $2,000 $2,000 $2,000 Depreciation $2,500 $2,500 $2,500 $2,500 Operating Income $7,500 $7,500 $7,500 $7,500 Income Tax $2,625 $2,625 $2,625 $2,625 Net Income $4,875 $$,875 $4,875 $4,875...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT