Question

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 so you can buy a house when you graduate in three 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) $36,000

B) $38,915

C) $77,507

D) $77,830

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,200 per month. You received quotes from several lenders and determined that the most likely annual interest rate you will be offered is 4.75% for a 30 year, fixed rate mortgage. What is the maximum you can pay for a house? Round to the nearest whole dollar. 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) $230,041

B) $269,866

C) $307,871

D) $308,781

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 #2 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 (no percent sign).

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

7. Assuming you intend to stay in the house for 30 years, which loan should you choose? *hint: Answer using the calculations you did in questions 5 and 6 rather than relying on the “rule of thumb” about EBC and loan choices presented in the text and on the slides.

A) Loan A

B) Loan B

Answer the remaining questions assuming you opted for 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) 15.69 years

B) 17.72 years

C) 30 years

D) 158 years

Please answer all parts of questions with since they connect! Please and thank you and use TVM formulas

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

1]

B) an annuity due. This is because each payment is equal and made at the beginning of the period.

A is incorrect. An ordinary annuity is made at the end of each period.

C is incorrect - An amortization refers to a loan where principal is paid off over time.

D is incorrect - In a perpetuity, cash flows are made forever.

2]

D) $77,830

This is calculated as below :

Change the calculator into "Begin" mode, as each payment is made at the beginning of the month.

I/Y = 5/12 (monthly rate = annual rate / 12 = 5%/12)

N = 36 (3 years with 12 monthly payments each year = 3 * 12 = 36)

PMT = -2000 (monthly payment. This is entered with a negative sign as it is a payment)

PV = 0 (beginning amount in savings is zero)

CPT --> FV

FV is calculated to be $77,830.

3]

Maximum loan amount is calculated as below :

Change the calculator into "End" mode, as each payment is made at the end of the month.

I/Y = 4.75/12 (monthly rate = annual rate / 12 = 4.75%/12)

N = 360 (30 years with 12 monthly payments each year = 30 * 12 = 360)

PMT = -1200 (monthly payment. This is entered with a negative sign as it is a payment)

CPT --> PV

PV is calculated to be $230,041. This is the maximum loan amount.

Maximum cost of house = maximum loan amount + down payment

Maximum cost of house = $230,041 + $77,830 = $307,871

d]

PMI is required if the down payment is less than 20% of the home's price.

In this case, down payment % =  $77,830 / $307,871 = 25%

Therefore, PMI is not required.

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...
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 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...

  • 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 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...

  • 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...

  • 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...

  • 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...

  • Use the following to answer questions 9-12.          Five years later, you are offered your dream...

    Use the following to answer questions 9-12.          Five years later, you are offered your dream job in Costa Rica. You need to sell this house in order to purchase a new one where you are moving. Rents have increased since you purchased the home and you estimate that the home will rent for $1700 per month (net). You have found a high quality tenant willing to sign a five year lease under the following conditions. Rent will be $1,700...

  • 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...

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