You plan to buy a house in October 2022. The sale price is $539,000. You need to pay 10% down payments and borrow the additional 90% from Wells Fargo Bank with a 15-year, 3.75% fixed-rate mortgage loan. You need to pay an equal MONTHLY payment starting from December 1, 2022 for a total of 15 years. (1) Calculate your expected monthly mortgage payment. (2) Develop the full amortization table for your mortgage loan. (3) When you prepare your 2023 tax filing, what is the total mortgage interest payment that you can consider for the tax deduction?

You plan to buy a house in October 2022. The sale price is $539,000. You need to pay 10% down payments and borrow the additional 90% from Wells Fargo Bank with a 15-year, 3.75% fixed-rate mortgage loan. You need to pay an equal MONTHLY payment starting from December 1, 2022 for a total of 15 years. (1) Calculate your expected monthly mortgage payment. (2) Develop the full amortization table for your mortgage loan. (3) When you prepare your 2023 tax filing, what is the total mortgage interest payment that you can consider for the tax deduction?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 27M

See similar textbooks

Similar questions

Please explain how to do this in Excel. Please explain how you did it and what the results mean.You plan to buy a house in December 2023. The sale price is $650,000. You need to pay 20% down payments and borrow the additional 80% from Bank of America with a 30-year, 7.2% fixed-rate mortgage loan. You need to pay an equal MONTHLY payment starting from January 1, 2024, for a total of 30 years. (1) Calculate your expected monthly mortgage payment. (2) Develop the full amortization table for your mortgage loan. (3) When you prepare your 2024 tax filing, what is the total mortgage interest payment that you can consider for the tax deduction?
Today is 1 July 2021. You are looking to purchase an investment property today (after months of research and negotiations). You have spoken to Peter, the loan specialist at Harrison Bank, to negotiate the terms of your mortgage. You and Peter have agreed to the following terms: You will borrow $390,000 today in order to purchase your chosen property. This mortgage will be repaid by level monthly repayments. Your first repayment to the bank will occur exactly 1 month from today, on 1 August 2021, and the final repayment will occur exactly 27 years from today, on 1 July 2048. Peter has arranged for an interest rate of 7.4% p.a. effective to be locked in for the life of this loan. c) Calculate the equivalent effective monthly rate. Give your answer as a percentage to 4 decimal places
Today is 1 July 2021. You are looking to purchase an investment property today (after months of research and negotiations). You have spoken to Peter, the loan specialist at Harrison Bank, to negotiate the terms of your mortgage. You and Peter have agreed to the following terms: You will borrow S490,000 today in order to purchase your chosen property. This mortgage will be repaid by level monthly repayments. Your first repayment to the bank will occur exactly 1 month from today, on 1 August 2021, and the final repayment will occur exactly 24 years from today, on 1 July 2045. Peter has arranged for an interest rate of 3% p.a. effective to be locked in for the life of this loan. 1)Calculate the size of the level monthly repayment needed in order to fully repay the loan by 1 July 2045. Give your answer to the nearest cent, and do NOT include a dollar sígn 2) Determine the value of L12. Give your answer to the nearest cent, and do NOT include a dollar sign
You are considering purchasing a new home. You will need to borrow AED 4,000,000 to purchase the home. A mortgage company offers you a 10-year fixed rate mortgage at 12% APR. If you borrow the money from this mortgage company, what is your monthly mortgage payment
You are considering an option to purchase or rent a single residential property. You can rent it for $2,000 per month and the owner would be responsible for maintenance, property insurance, and property taxes. Alternatively, you can purchase this property for $200,000 and finance it with an 80 percent mortgage loan at 4 percent fixed-rate interest that will fully amortize over a 30-year period. The loan requires monthly payments. The loan can be prepaid at any time with no penalty. You have done research in the market area and found that (1) properties have historically appreciated at an annual rate of 2 percent per year, and rents on similar properties have also increased at 2 percent annually; (2) maintenance and insurance are currently $1,500.00 each per year and they have been increasing at a rate of 3 percent per year; (3) you are in a 24 percent marginal tax rate and plan to occupy the property as your principal residence for at least four years; (4) the capital gains exclusion…
I need help solving this on excel 9.You a buying a home for $425,000 and would like to determine the monthly mortgage payment. You can obtain a $340,000 30-year fixed-rate mortgage at 3.5%. What is your monthly payment?
You are planning on buying a new house and want to make sure you can afford the monthly payments. The house you picked will necessitate you borrow $300,000. You think you can get the following. mortgage terms: borrow $300,000 at a fixed quoted (nominal) annual rate of 3.775%; to be paid off in equal monthly payments over 15 years.Compute the required monthly payment, and prepare an amortization table, showing for each month the beginning balance, payment, payment applied to interest, payment applied to principal, and ending. balance. (Assume monthly compounding) (solution needs to be in excel)
Liz Rogers just closed a $320,000 fixed-rate mortgage loan. The stated mortgage interest rate is 3.375% per year. The loan is to be repaid in 180 equal, consecutive, monthly, and end-of-month payments. The first monthly payment is due on July 31, 2020. Ignore all closing costs. How much of the payment to be made in August 2029 will represent the interest payment?
You need a 30-year, fixed-rate mortgage to buy a new home for $400,000. Your mortgage bank will lend you the money at a 6 percent APR for a 360 month loan. You can only afford a monthly payment of $1000. How much downpayment should you put at the time of purchase? Please show your work using excel formulas.
In the Excel Payment Function file that follows, you are looking to see what your basic mortgage payment will be if you buy a home for $250,000. It will be a 30-year mortgage. The interest your bank will charge will be 7.5%. In cell C5, create a function that determines what your monthly payment will be.
Suppose you borrow $20,000 at the start of 2022 to buy a car. Your loan is for 4 years at an effective rate of 0.5% per month. Your first uniform monthly payment to pay back the loan is due at the end of January 2022. Please answer the following questions: a. What is your uniform monthly payment if you pay it off over 48 months? b. What is the remaining balance of your car loan immediately after making the 36th monthly payment at the end of year 3? c. Suppose instead you send the bank a check for $550 every month. Rounding off to the nearest number of months, how many months are required to pay off the loan by paying $550 each month assuming that the bank applies the proper portion of each payment to interest or principle at 0.5% per month?
Suppose you borrow $20,000 at the start of 2022 to buy a car. Your loan is for 4 years at an effective rate of 0.5% per month. Your first uniform monthly payment to pay back the loan is due at the end of January 2022. Please answer the following questions: a. What is your uniform monthly payment if you pay it off over 48 months? b. What is the remaining balance of your car loan immediately after making the 36th monthly payment at the end of year 3? c. Suppose instead you send the bank a check for $550 every month. Rounding off to the nearest number of months, how many months are required to pay off the loan by paying $550 each month assuming that the bank applies the proper portion of each payment to interest or principle at 0.5% per month? Display equations used.