Suppose you plan to purchase a $250,000 home. You plan to put 5% down, and take a loan from the bank for the remaining amount. The bank has offered you a 30-year loan with a 4.5% APR (compounded monthly). Calculate the total interest paid to the bank in the 2nd year of the loan
Suppose you plan to purchase a $250,000 home. You plan to put 5% down, and take...
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...
You are planning to purchase a house that costs $620,000. You plan to put 20% down and borrow the remainder. You have been pre-approved, based on your credit score and income, for a 30-year loan with an interest rate of 4.53%. 1. Use function “PMT” to calculate your mortgage payment. 2. Use function “PV” to calculate the loan amount given a payment of $2650 per month. What is the most that you can borrow? 3. Use function “RATE” to calculate...
Suppose you purchase your first home by making a $10,000 down payment on a debt of $150,000. The bank charges an APR of 4.8% compounded monthly for a 30 year mortgage. Your monthly payment on the remaining $140,000 is $787.00. (Do not enter $ sign and round answers to the nearest cent: Examples: 650.35, 12000.00) a) You elect to payoff the entire loan after you pay 240 payments (120 payments remain). How much must you pay to payoff the loan...
2. You purchase a home for $240,000, putting 10% down, and financing the rest with a fixed APR of 5.9% for 30 years. a) Find the amount that you finance. 12 pts) b) Calculate the monthly payment. [4 pts] c) What was the total amount that you paid to the bank for your loan? [2 pts) d) How much did you pay in interest over the term of the loan? [2 pts
5. Calculating Take-home Pay, and Length of Savings: Because
it is such a large amount, most people, when deciding to buy a
home, need to plan ahead and start saving for the down payment.
Using the average starting salary in the career you chose after
graduation as a guideline (from #2), calculate your monthly
take-home pay; this is your net monthly pay after you have an
average of 30% taken out for income taxes.
Monthly take-home (net) pay after 30%...
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...
20 home, a n annual aid back 1 monthly thly 14. [20pts] The Bob's plan to purchase a home for $250,000. They will pay 20% down and finance the remainder for 30 years at 6% interest, compounded monthly. a. How large are their monthly payments? b. If they were to increase their monthly payments by $300, how long would it take to pay off the loan? - a) 2-P(rin T121
20 home, a n annual aid back 1 monthly thly...
You are looking at buying a home with an asking price of $225,000. Since the market is hot, you plan to put in an offer for full asking price. You also plan to put a $45,000 down payment and finance the remainder. Your bank is offering you a 30-year loan at 4.125% APR (compounded monthly). Assume your first payment is made one month from today. a. What would be your monthly loan payment? b. Assuming you paid all of your...
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...
A3-8 Suppose you want to borrow $200,000 to purchase a home. You have found terms that include a 30-year note with a nominal rate of 7.0% com - pounded monthly. The loan includes payment of 2.5 points, which will be paid out of the loan at closing. One point is equal to 1% of the loan value.) A) Calculate the monthly mortgage payment. B) How much interest is paid in the 2nd month's payment? C) How much principal is paid...