You plan to use a 15 year mortgage obtained from a local bank t purchase a house worth $124,000.00. The mortgage rate offered to you is 7.75%. You will make a down payment of 20% of the purchase price. a. Calculate your monthly payments on this mortgage. List in a spreadsheet the cash flow the bank expects to receive from you. Submit the spreadsheet with your answers. b. Calculate the amount of interest and principal for the 60th payment. Show your work. c. Calculate the amount of interest and principal to be paid on the 180th payment. Show your work. d. What is the amount of interest paid over the life of this mortgage?

Please build an excel spreadsheet and show the formulas  to answer a. through g. using the information below You bought a house with price of $250,000. Your LTV (loan-to-value ratio) is 80%. You choose the 30-year mortgage with interest rate 6%. Assuming the total transaction cost is $10,000. a. What is your loan amount? b. What is your monthly payment? c. What will be the loan balance at the end of nine years? d. What is the effective borrowing cost if the loan will be prepaid at the end of nine years? e. In the monthly payment, how much you pay for the principle and how much you pay for the interest in the 1st and the 2nd month? f. What will be your interest payments for the first 5 years (year 1 to year 5) and the last 5 years (year 26 to year 30)? g. What is your annual percentage rate (APR)?

The Becker family is getting a home loan to finance a $260,000 mortgage. While looking for a mortgage, they found two alternatives: Mortgage A 30-year loan with an interest rate of 3.611% and a monthly payment of $1,184. Mortgage B 15-year loan with an interest rate of 2.7% Recall: Loan Payment Formula.png| A. Calculate the total amount paid for Mortgage A. B. Calculate the total interest paid for Mortgage A. C. Calculate the monthly payment for Mortgage B. D. Calculate the total amount paid for Mortgage B. E. Calculate the total interest paid for Mortgage B. F. Write a two or more sentences giving the Becker family some advice about which mortgage to choose. G. Why might the Becker family not take your advice from part c)? Answer in one or two sentences.

The Becker family is getting a home loan to finance a $260,000 mortgage. While looking for a mortgage, they found two alternatives: Mortgage A 30-year loan with an interest rate of 3.611% and a monthly payment of $1,184. Mortgage B 15-year loan with an interest rate of 2.7% Recall: Calculate the total amount paid for Mortgage A. Calculate the total interest paid for Mortgage A. Calculate the monthly payment for Mortgage B. Calculate the total amount paid for Mortgage B. Calculate the total interest paid for Mortgage B. Write a two or more sentences giving the Becker family some advice about which mortgage to choose. Why might the Becker family not take your advice from part c)? Answer in one or two sentences.

Tim wants to borrow $400,000 from Bank of America on a 30-year mortgage at 6% interest rate. a. What would Tim's monthly payments be on his mortgage? b. Amortize the loan and determine: Interest expense for the first quarter of the loan. Cash flows for the first quarter of the loan. Loan balance at the end of the first quarter of the loan. Please show your calculations, part b is very important. If you are using the TVM chart, please state whether you used PVoA, FVoA, PVoSA, FVoSA.

You plan to purchase an $80,000 house using a 15-year mortgage obtained from your local bank. The mortgage rate offered to you is 8.00 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage.b. Calculate the amount of interest and, separately, principal paid in the 127th payment.c. Calculate the amount of interest and, separately, principal paid in the 159th payment.d. Calculate the amount of interest paid over the life of this mortgage.

Find the monthly house payment necessary to amortize the following loan. 9) In order to purchase a home, a family borrows $121,000 at 3.0% for 30 yr. What is their monthly payment? Round the answer to the nearest cent.

You plan to purchase a $160,000 house using a 15-year mortgage obtained from your local credit union. The mortgage rate offered to you is 6.5 percent. You will make a down payment of 15 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Calculate the amount of interest and, separately, principal paid in the 25th payment. c. Calculate the amount of interest and, separately, principal paid in the 80th payment. d. Calculate the amount of interest paid over the life of this mortgage. (For all requirements, do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) a. Monthly payment b. Amount of interest Amount of principal Amount of interest Amount of principal d. Amount of interest paid C. Amount

A friend asks to borrow $54 from you and in return will pay you $57 in one year. If your bank is offering a 5.7% interest rate on deposits and loans: a. How much would you have in one year if you deposited the $54 instead? b. How much money could you borrow today if you pay the bank $57 in one year? c. Should you loan the money to your friend or deposit it in the bank? a. How much would you have in one year if you deposited the $54 instead? If you deposit the money in the bank today you will have $ in one year. (Round to the nearest cent.)

Use an online loan calculator to determine the regular payment amount, rounded to the nearest dollar. The price of a home is $148,000. The bank requires a 20% down payment and three points at the time of closing The cost of the home is financed with a 30-year fixed rate mortgage at 85% Complete parts (a) through (e) below -CHEDD a. Find the required down payment $0 b. Find the amount of the mortgage How much must be paid for the three points at closing? (Round to the nearest dolar as needed) d. Find the monthly payment (excluding escrowed taxes and insurance) (Round to the nearest dollar as needed) e. Find the total cost of interest over 30 years (Round to the nearest dolar as needed)