Question

Use the following to answer questions 1-4. You currently live (rent free) in your parents' basement but it's a bit awkwa...

Use the following to answer questions 1-4.

You currently live (rent free) in your parents' basement but it's a bit awkward when you bring dates home. Your friends are looking for a new roommate and have asked if you're interested in moving in. Your share of the rent (which includes all utilities) will be $800 per month, due at the beginning of the month, and you will be signing a two-year lease.

You parents think you should save your money so you can buy a house when you graduate in two years. If you stay living in your parents' basement, and deposit the money you save by not having to pay rent into a savings account at the beginning of each month, your parents have offered to give you a gift equal to the amount you have saved towards a down payment on your first home. Assume the bank is offering a 5% annual interest rate, compounding monthly, on new savings accounts

1. Your monthly rent payment in this example would be considered _________________.

A. an ordinary annuity

B. an annuity due

C. amortization

D. a perpetuity

2. If you take your parents up on their offer, how much will have (in total) for a down payment on a home when you graduate? Round your final answer to the nearest whole dollar. * Hint: remember your parents have offered to match what you save on your own

A. $3,444

B. $20,465

C. $40,297

D. $40,465

3. Suppose you took your parents up on their offer and are now getting ready to graduate. You have decided that you can afford a house payment of $1,000 per month. You received quotes from several lenders and determined that the most likely annual interest rate you will be offered is 4.25% for a 30 year, fixed rate mortgage. What is the maximum you can pay for a house?  Hints: (1) Mortgage payments are in arrears (meaning they are paid at the END of the time period). Be sure your calculator is in the correct mode before solving. (2) After you solve for the maximum loan amount, don't forget to add on your down payment to determine the sales price!

A. $203,277

B. $223,509

C. $243,742

D. $249,927

4. Would you be required to pay PMI with this loan?

A. Yes

B. No

Use the following to answer questions 5-7.

You have selected the lender you will be using and completed the application process. You are excited to find out that your credit score was better than you originally thought when estimating how much you could spend on a house. You are being offered a lower interest rate than you were originally quoted on two different loan options. Both are 30 year, fixed rate mortgages with payments of $1,000 per month and origination fees equal to 2% of the loan amount. * hints (1) Assume these loans have zero PMI (2) you have additional money set aside to cover closing costs so you are using the full amount from #3 as a down payment.

  • Loan A has an APR of 4% with no points.
  • Loan B has an APR of 3.90% with 1.5 points.

5. What is your Effective borrowing cost if you select Loan A? Enter your answer as a whole number with 3 decimal points

6. What is your Effective borrowing cost if you select Loan B? Enter your answer as a whole number with 3 decimal points

7. Assuming you intend to stay in the house for 30 years, which loan should you choose?

Answer the remaining questions in this assignment assuming you selected Loan A.

8. You decide to rent out a room in your new home to your best friend for $500 per month. If you add the extra money to your monthly house payment, how many years will it take you to pay off your mortgage?

A. 12 years

B. 15.69 years

C. 30 years

D. 188 years

Please answer all parts of the question!

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1. Option B is connect. Sunce the payments are made at the beginning of each month A is incorrect as in the case of an ordina

Add a comment
Know the answer?
Add Answer to:
Use the following to answer questions 1-4. You currently live (rent free) in your parents' basement but it's a bit awkwa...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Use the following to answer questions 1-4. You currently live (rent free) in your parents' basement...

    Use the following to answer questions 1-4. You currently live (rent free) in your parents' basement but it's a bit awkward when you bring dates home. Your friends are looking for a new roommate and have asked if you're interested in moving in. Your share of the rent (which includes all utilities) will be $1,000 per month, due at the beginning of the month, and you will be signing a three-year lease. You parents think you should save your money...

  • Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan...

    Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use the function “PMT” to calculate your mortgage payment. Calculate the total cost of the home purchase. (Down payment plus principal (loan amount) plus interest.) Calculate how much interest you will pay in total? Assume that you plan to pay...

  • You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the...

    You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1700 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given a payment of $1700...

  • Use the following information to answer the next two questions. (1) You plan to purchase your...

    Use the following information to answer the next two questions. (1) You plan to purchase your dream home in 10 years.  Currently, it would cost you $500,000 to purchase the land and build the house to your specifications, but you believe this cost will grow by 3% per year. You have decided to place equal monthly payments into an investment account that earns 5% annually in order to make a 20% down payment on the home when you purchase it in...

  • Mortgage Analysis You are planning to purchase a house that costs $480,000. You plan to put...

    Mortgage Analysis You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.25% on a 30-year mortgage. (Use Excel) Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1550 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given...

  • 8. What are the adusn Due: November 4, 2019 1. EXCEL Spreadsheet: a. You must use...

    8. What are the adusn Due: November 4, 2019 1. EXCEL Spreadsheet: a. You must use the FINANCIAL FUNCTIONS in EXCEL to calculate your answers. b. All calculations must be done in Excel. Do not calculate anything on your calculator and just enter the number into Excel (if you do this, you will not receive credit for this assignment). Do the calculation within the cell. c You must reference cells from your base case. (Only input variables that change for...

  • 5. 14 points. Your na points. Your parents are selling their vacation home and have 2...

    5. 14 points. Your na points. Your parents are selling their vacation home and have 2 offers. Their friend has $100,000 today and $120.000 for each of the next three ye and $120.000 for each of the next three years. A broker has offered to pay them 5400.000 today the relevant discount rate is , which offer should they choose? Show calculations ve 2 offers. Their friend has offered to pay them 6. 29 total points. You have decided that...

  • Due: November 4.2019 1. EXCEL Spreadsheet: a. You must use the FINANCIAL FUNCTIONS in EXCEL to...

    Due: November 4.2019 1. EXCEL Spreadsheet: a. You must use the FINANCIAL FUNCTIONS in EXCEL to calculate your answers b. All calculations must be done in Excel Do not calculate anything on your calculator and just enter the number into Excel (if you do this, you will not receive credit for this assignment). Do the calculation within the cell c. You must reference cells from your base case (Only input variables that change for each requirement.) d. Your spreadsheet should...

  • Analyze this saving plan and enter your answer in Questions 4-10. If you use Excel functions...

    Analyze this saving plan and enter your answer in Questions 4-10. If you use Excel functions to calculate the answers, submit the completed Excel file as a group and make sure to include the names of your group members who work on the problem. A 30-year old wants to make a saving plan to meet the following three goals: §  First Goal: To save $150,000 in 5 years for the down payment to purchase a house, which is estimated to be...

  • You are planning to buy a new house. You currently have 535,000 and your bank told...

    You are planning to buy a new house. You currently have 535,000 and your bank told you that you would need a 15% down payment Jus an additional 4% in closing costs. If the house that you want to buy costs $250.000 and you can make a 7% annual return on your avestment, determine the following: When will you have enough money for the down payment and closing costs, assuming that the $35.000 is the only investment that you make?...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT