As a graduating senior with a promising career in finance, Central Bank offers you a mortgage of $200,000. You may choose between a 30-year mortgage with an interest rate of 4.375% or a 15-year mortgage at 3.500%. Both interest rates are annual stated rates with interest compounded monthly. Assume that for 30-year mortgage, the bank requires you to pay 1% point. Compute an amortization table that shows the amount of interest you can report for taxes and amount of principal payment each year for each loan. Use two different ways to do it as we did in class: with and without using the functions PPMT and IPMT. PLEASE USE EXCEL and show functions

As a graduating senior with a promising career in finance, Central Bank offers you a mortgage of $200,000. You may choose between a 30-year mortgage with an interest rate of 4.375% or a 15-year mortgage at 3.500%. Both interest rates are annual stated rates with interest compounded monthly. Assume that for 30-year mortgage, the bank requires you to pay 1% point. Compute an amortization table that shows the amount of interest you can report for taxes and amount of principal payment each year for each loan. Use two different ways to do it as we did in class: with and without using the functions PPMT and IPMT. PLEASE USE EXCEL and show functions

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 15P

See similar textbooks

Similar questions

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 A Req B1 Amortization Schedule Month 1 2 3 179 180 Construct the amortization schedule for the mortgage? (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Req 82 Total Interest Amortization Schedule for the 15-Year Mortgage Interest Cumulative Principal Principal 272,000.00 270,999.26 Cumulative Interest Ending Balance
You are purchasing a house and you are considering getting a fixed-rate mortgage (FRM) for $750,000. Your bank offers you a standard fully-amortizing 30-year mortgage that requires monthly payments and has an interest rate of 4.8% (APR with monthly compounding). Compute the required monthly payments for the mortgage.
You plan to use a 15 year mortgage obtained from a local bank to 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?
You plan to purchase a $100,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 8.25 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 25th payment. (pls show solution)
You plan to purchase a $310,000 house using a 15-year mortgage obtained from your bank. The mortgage rate offered to you is 5.10 percent. You will make a down payment of 20 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?
You plan to purchase a $350,000 house using a 15-year mortgage obtained from your bank. The mortgage rate offered to you is 5.50 percent. You will make a down payment of 20 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the mortgage. How much total interest is paid on this mortgage? (Do not round intermediate calculations. Round your answer to 2 decimal places. (e.g., 32.16))
A borrower has taken out a 30-year mortgage for $104,000 at an annual rate of 12%. a. Use the table to find the monthly payment for this mortgage. b. Construct the first three lines of an amortization schedule for this mortgage. c. Assume that the borrower has decided to pay an extra $200 per month to pay off the mortga more quickly. Find the first three lines of your payment schedule under this assumption. Click the icon to view a table of monthly payments on a $1,000 loan. a. The monthly payments for this mortgage are $ (Type an integer or a decimal.) Enter your answer in the answer box and then click Check Answer. 6 parts remainino Olear All Cherk Answe javascript:doExercise(3): Copyright © 2020 Pearson Education Inc. All rights reserved. | 99 a 立

You plan to borrow $25,000 at a 3.4% annual interest rate compounded annually. The terms require you to amortize the loan with 5 equal payments each made at the end of each year. You would like to construct an amortization schedule showing details of the payments. Answer the following questions, and choose the closest answer from the possible choices following each question: 1.To find the interest repaid in period 1 only in the financial calculator amortization worksheet, you enter P2 = 2.To find the interest repaid in period 1 only in the financial calculator amortization worksheet, you enter P1 = 3.How much total interest is repaid in periods 1 to 2?
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)
Suppose you are interested in taking an FHA mortgage loan for $250,000 in order to purchase your principal residence. In order to do so, you must pay an additional up-front mortgage insurance premium (UFMIP) of 1.0% of the mortgage balance. If the interest rate on the fully-amortizing mortgage loan is 5% and the term is 30 years and the UFMIP is financed (i.e., it is included in the loan amount), what is the dollar portion of your monthly mortgage payment that is designated to cover the UFMIP? A. $2,500.00B. $1,119.41C. $159.67D. $13.42
Assume that a broker agent introduces you to a local bank, and that bank offers you their lowest interest rate at 3.25% APR, with a 10-year fixed interest rate or 20-year fixed interest rate. 1) If you want a 10-year, fixed mortgage loan, find the monthly mortgage payment for a house that you will borrow $500,000 with no down payment. 2) Determine the total amount paid over the full term of the loan. 3) How much interest will be paid on the loan over the 10 years?
You plan to purchase a $240,000 house using a 30-year mortgage obtained from your local credit union. The mortgage rate offered to you is 8 percent. You will make a down payment of 10 percent of the purchase price. a. Calculate your monthly payments on this mortgage. b. Construct the amortization schedule for the first six payments. Complete this question by entering your answers in the tabs below. Required A Required B Construct the amortization schedule for the first six payments. (Do not round intermediate calculations. Round your answers to 2 decimal places. (e.g., 32.16)) Amortization Schedule for first 6 payments (months) Month Beginning Loan Balance Payment Interest Principal Ending Loan Balance 1 2 3 4 5 6