Question

miguel currently pays 950 for rent each month and has decided to purchase a home. the...

miguel currently pays 950 for rent each month and has decided to purchase a home. the home he wants costs $156,000. he has a down payment for 25,000 and has already secured 4.75% on a 20-year mortgage. what would Miguel need to type into Excel to figure the maximum amount that he could borrow?
Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

The maximum amount that can be borrowed can be find using the excel function PV(rate, period, amt)

Rate of 4.75% assumed as yearly rate, the period is for 20 years and the amount that Miguel is willing to pay is taken as 12 months equivalent of rent ,ie, 11400 $. By inserting the function with appropriate figures, we can find that Maximum amount he could borrow is $145129.63.

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Paul wants to purchase his own home. He currently lives in an​ apartment, and his rent...
Paul wants to purchase his own home. He currently lives in an​ apartment, and his rent is being paid by his parents.​ Paul's parents have informed him that they would not pay his mortgage payments. Paul has no​ savings but can save ​$366 per month. The home he desires costs ​$148,000​ and his real estate broker informs him that a down payment of 20​% would be required. If Paul can earn 4​% on his​ savings, how long will it take...
1) You have decided that you want to buy a home in 6 years. You believe...
1) You have decided that you want to buy a home in 6 years. You believe you can afford a house that is $190,000. a) If you want to have 15% for a down payment, how much will you need to have for the down payment? Down payment = $. DO NOT TYPE COMMAS OR ANSWERS WILL BE MARKED INCORRECT. Round your answer to 2 decimal places as needed. b) You decide to start investing money now so that you...
1. Ben has a home and is ready to purchase his first rental property. Ben found...
1. Ben has a home and is ready to purchase his first rental property. Ben found a property that needs some work so he can get a low price. He will use his own cash. The home is listed for $125,000 and it will need about $25,000 of rehab expense while he does the work himself over one year, at which time he will rent it out. He thinks that he will wait until the second year to do the...
A client of Mr. Richards wants to purchase a large commercial building. The building costs $20...
A client of Mr. Richards wants to purchase a large commercial building. The building costs $20 million and he will make a down payment of 15% and finance the rest with a local bank. The bank terms are 10-year bullet loan with 30-year amortization at 4.5% interest. The building earns annual rent of $2,500,000 and it pays annual taxes of $1,000,000 per year. What will be the annual cash flow from the building? What will be the ROI on the...
I was looking at the solution to the following question on this site. I could not...
I was looking at the solution to the following question on this site. I could not understand why use 12 when working out the NPER. Since the monthly payments start 1 month after should you not use 11? Question 3. (a) A family member is thinking about funding his granddaughter’s university education in 8 years when she is expected to enrol at UWI, St. Augustine. He opens a special savings account, where he can receive a lump sum in 8...
In its ongoing efforts to make the student life easier, Large Mart is currently attempting to...
In its ongoing efforts to make the student life easier, Large Mart is currently attempting to develop a “study pillow” which will allow students to upload study material into their brain whilst sleeping. However, Large Mart has recently discovered that an American company called Bpple already holds a patent for this type of device. As a result, Large Mart has given up on its development attempts and decided to sell the Bpple product, which is called iSLEEP. In order to...
****FOR THIS HOMEWORK ASSIGNMENT, YOU MUST SHOW ALL WORK (CALCUATIONS) AND DRAW TIME LINES. 1) Jane...
****FOR THIS HOMEWORK ASSIGNMENT, YOU MUST SHOW ALL WORK (CALCUATIONS) AND DRAW TIME LINES. 1) Jane is 25 years old and was able to save $25,000.    After doing some research, she identifies a stock called HPG Industries that has a dividend yield of 7% that has been consistent for the past 10 years. Based on this information, she decides to invest in this stock. Considering that HPG Industries pays the dividend consistently, how many years will it take for Jane...
In its ongoing efforts to make the student life easier, Large Mart is currently attempting to...
In its ongoing efforts to make the student life easier, Large Mart is currently attempting to develop a “study pillow” which will allow students to upload study material into their brain whilst sleeping. However, Large Mart has recently discovered that an American company called Bpple already holds a patent for this type of device. As a result, Large Mart has given up on its development attempts and decided to sell the Bpple product, which is called iSLEEP. In order to...
In its ongoing efforts to make the student life easier, Large Mart is currently attempting to...
In its ongoing efforts to make the student life easier, Large Mart is currently attempting to develop a “study pillow” which will allow students to upload study material into their brain whilst sleeping. However, Large Mart has recently discovered that an American company called Bpple already holds a patent for this type of device. As a result, Large Mart has given up on its development attempts and decided to sell the Bpple product, which is called iSLEEP. In order to...
In its ongoing efforts to make the student life easier, Large Mart is currently attempting to...
In its ongoing efforts to make the student life easier, Large Mart is currently attempting to develop a “study pillow” which will allow students to upload study material into their brain whilst sleeping. However, Large Mart has recently discovered that an American company called Bpple already holds a patent for this type of device. As a result, Large Mart has given up on its development attempts and decided to sell the Bpple product, which is called iSLEEP. In order to...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT