You plan to purchase a $320,000 house using a 15-year mortgage obtained from your bank. The mortgage rate offered to you is 5.20 percent. You will make a down payment of 15 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. (1) Construct the amortization schedule for the mortgage. b. (2) How much total interest is paid on this mortgage? Answer is not complete. Complete this question by entering your answers in the tabs below. Req B1 Amortization Schedule Construct the amortization schedule for the mortgage? (D Req A Req B2 Total Interest,

Show the first two lines of the amortization table for your new home mortgage, assuming a sellingprice of $118,500, a down payment of 6%, annual interest rate 5.3% compounded monthly, andmonthly payments on a 30-year mortgage. (Please help by solving through calculator)

A homebuyer wishes to take out a mortgage of $200,000 for a 40-year period. What monthly payment is required if the interest rate is 11%? What is the total amount paid during the term of the loan? Carry out all calculations exactly and round the final answers only. Carry out all calculations exactly and round the final answer for the monthly payment to two decimal places and the final answer for the total amount paid to the nearest integer. The required monthly payment is $L The total amount paid during the term of the loan is $

Use PMT formula on the image uploaded to determine the regular payment​ amount, rounded to the nearest cent. The cost of a home is financed with a $150,000 20​-year fixed-rate mortgage at 3.5​%.   a. Find the monthly payments and the total interest for the loan.   b. Prepare a loan amortization schedule for the first three months of the mortgage. ______________________________________________________________ a. The monthly payment is ​$________.. ​(Do not round until the final answer. Then round to the nearest cent as​ needed.)   - The total interest for the loan is $_______. ​(Use the answer from part a to find this answer. Round to the nearest cent as​ needed.)   b. Fill out the loan amortization schedule for the first three months of the mortgage below.   Payment Number Interest Principal Loan Balance   1 ​$ ​$ ​$   2 ​$ ​$ ​$   3 ​$ ​$ ​$   ​(Use the answer from part a to find these answers. Round to the…

Answer the following question using a spreadsheet and the material in the appendix. You would like to buy a house. Assume that given your income, you can afford to pay $12,000 a year to a lender for the next 30 years. If the interest rate is 7% how much can you borrow today based on your ability to pay? What about if the interest rate is 3%? Maximum mortgage at 7%: $     Maximum mortgage at 3%: $

A lender offers you a $125,000, 30 year mortgage with monthly payments of $769.65. What’s the interest rate?

2 . Please answer the whole answer there is more than one answer that needs to be answered

You have just sold your house for $950,000 in cash. Your mortgage was originally a 30-year mortgage with monthly payments and an initial balance of $740,000. The mortgage is currently exactly 18.5 years old, and you have just made a payment. If the interest rate on the mortgage is 6.75% (APR), how much cash will you have from the sale once you pay off the mortgage? (Note: Be careful not to round any intermediate steps less than six decimal places.) Cash that remains after payoff of mortgage is $ (Round to the nearest cent.)

Please eolve this question on excell and show formulas please.

please help me