You are interested in purchasing a house but unfortunately you don't have any money for a down payment. Luckily the house you are looking at buying is only $325, 000 and the bank currently has an offer where they will lock in your interest rate for the entire length of the mortgage. The rate that they are offering is 4.5% interest over 15 years. Develop a worksheet that will show the monthly payment, the beginning and ending balance for each year of the loan, the annual cost of the loan, and the annual interest paid for each year of the loan. Please show Formulas

You are interested in purchasing a house but unfortunately you don't have any money for a down payment. Luckily the house you are looking at buying is only $325, 000 and the bank currently has an offer where they will lock in your interest rate for the entire length of the mortgage. The rate that they are offering is 4.5% interest over 15 years. Develop a worksheet that will show the monthly payment, the beginning and ending balance for each year of the loan, the annual cost of the loan, and the annual interest paid for each year of the loan. Please show Formulas

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

We suggest the use of a spreadsheet to create the amortization tables. You take out a 30-year mortgage for $80,000 at 9.25%, to be paid off monthly. Construct an amortization table showing how much you will pay in interest each year for the first 15 years and how much goes toward paying off the principal. If you sell your house after 15 years, how much will you still owe on the mortgage according to the amortization table? HINT [See Example 8.] (Round your answer to the nearest cent.) $
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.
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 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? how would i calculate this in excel?
Watch the video and then solve the problem given below. Click here to watch the video. You are considering a loan with an annual rate of 8%. The mortgage is $130,000 with 180 monthly payments of $1242.35 for 15 years. Complete the first two months of the amortization table. (Simplify your answers. Round to the nearest cent as needed.) Payment number Interest payment Principal payment Balance of loan 1
You borrow $333,000 to purchase a home. Your mortgage requires monthly payments over the next 23 years, with the first payment due one month from today. The annualized interest rate for the loan is4.2%. What will be your remaining loan balance immediately following payment #28? Hint: you do not need to create an amortization schedule to answer this question. Do not round intermediate steps. Enter your answer as a positive number, and round to the nearest penny.
After a conversation with your banker, you’ve agreed to a 20% down payment on your $182,188 home. To keep this problem and your calculations relatively brief, assume that the bank has offered you a mortgage loan for $145,750 that carries a 6% interest rate, semiannual payments of $26,905, and a 3-year term. Remember, the process is the same when you are preparing for either 6 semiannual payments of nearly $27,000 or 360 monthly payments of $873.85 for a 30-year conventional mortgage.Complete the following loan amortization table by entering the correct answers. Notes: 1. As all values are denominated in U.S. dollars, you do not have to enter any dollar signs. 2. Round all interest payments down to the nearest whole dollar. 3. Rounding creates a situation in which the numbers in the loan’s final payment are often unequal. Notice in this problem, the ending balance for payment 6 is –$2. Therefore, your final payment would actually be reduced by $2 to $26,903. In the real world,…
I need a detailed explanation on how to solve this problem: You want to buy a house for $245,000, on a 35-year, fixed rate mortgage. The bank offers you a 420 month, 5.4% APR mortgage. You can only afford to pay $850 per month. But you offer to pay off the remaining balance at the end of the loan in a single balloon payment. - How much will the balloon payment be for you to keep the monthly payment at $850?
You are considering buying a new home and are planning to take out a 30-year, $300,000 mortgage. You are told that the interest rate on your loan will be 3%. You want to figure out how much you will have to pay on the mortgage each month. To analyze your potential loan, you have decided to use Microsoft Excel to calculate the monthly payments. To earn full credit your spreadsheet must contain the following elements: Calculate the required monthly payment using a built-in Excel function. Reference the interest rate via a cell name rather than a cell location Build a 360-month amortization table including the outstanding loan balance at the end of each month. Suppose instead of paying the required monthly payment, you decide to pay an extra $250 per month. How much sooner will you be able to pay off your loan?
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% APR for a 360 month loan. You can only afford a monthly payment of $1000. How much down payment should you put at the time of purchase? Please show work.
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? Plese show your work.