Mr. and Mrs. Smith have just purchased a $600,000 house and have made a down payment of $120,000. They can amortize the balance at 4% compounded monthly for 30 years. 1. Using Excel, calculate monthly payments. 2. Using Excel, calculate equity they have in their house (that is, what is the sum of the down payment and amount paid on the loan) after 20 years? 3. Using Excel, populate the following amortization table:

Mr. and Mrs. Smith have just purchased a $600,000 house and have made a down payment of $120,000. They can amortize the balance at 4% compounded monthly for 30 years. 1. Using Excel, calculate monthly payments. 2. Using Excel, calculate equity they have in their house (that is, what is the sum of the down payment and amount paid on the loan) after 20 years? 3. Using Excel, populate the following amortization table:

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter4: Time Value Of Money

Section: Chapter Questions

Problem 25PROB

See similar textbooks

Similar questions

2. Mr. and Mrs. Smith have just purchased a $600,000 house and have made a down payment of $120,000. They can amortize the balance at 4% for 30 years. a. Using Excel (FORMULA) , calculate monthly payments. b. Using Excel (FORMULA), calculate equity they have in their house (that is, what is the sum of the down payment and amount paid on the loan) after 20 years? c. Using Excel (FORMULA), populate the following amortization table:
Mr. and Mrs. Smith have just purchased a $600,000 house and have made a down payment of$120,000. They can amortize the balance at 4% for 30 years. Using Excel, populate the following amortization table: payment number 1, 60,180,240,300,360 monthly payment principle interest amount paid on loan
A family buys a home by taking out a 15-year fixed-rate mortgage of $240,000 at 4.3% interest. What is their monthly payment? Round their answer up to the next whole dollar. How much will they pay over the course of 15 years? With this payment, much interest will they pay over the life of the loan? Complete the first three lines of this amortization table, using the payment you found above. Round each entry in the table to the nearest cent. Payment Number Interest Payment Principal Payment Balance of Loan 1 2 3 Submit Question
A few years ago a couple purchased an office space by financing RA for n years, paying periodic installment of Rp with an interest of r% compounded bimonthly (every 2 months). They have made t payments and wish to know how much they owe on the mortgage at the end of t payments, which they are considering paying off with an inheritance they received. 1. Construct a mathematical model to illustrate the value owed on the loan after t payments. 2. Give an explicit formula for computing the current balance on the loan account after n periods. 3. If the couple signed the contract by financing R80000 for 10 years, paying periodic installments of R1880 with an interest of 18% compounded binmonthly. What is the current value on the mortgage after 6 months?
A couple has decided to purchase a $160000 house using a down payment of $11000. They can amortize the balance at 6% over 25 years. a) What is their monthly payment? Payment = $ b) What is the total interest paid? Total interest paid = $ c) What is the equity after 5 years? Equity after 5 years = $ d) What is the equity after 20 years? Equity after 20 years = $
A couple has decided to purchase a $90000 house using a down payment of $18000. They can amortize the balance at 11% over 20 years. a) What is their monthly payment? Answer= $ b) What is the total interest paid? Answer $ c) What is the equity after 5 yeare? Answer = $ d) What is the equity after 15 years? Answer = $
Jim and Joan Miller are borrowing $120,000 at 6.5% per annum compounded monthly for 30 years (360 months) to purchase a home. Their monthly payment is determined to be $758.48. A recursive formula for their balance after each monthly payment has been made. A determination of Jim and Joan's balance after the first payment. Don't forget the interest affecting their payment create a table showing their balance after each monthly payment. Determine when the balance will be below $75,000. Determine when the balance will be paid off. Determine the interest expense when the loan is paid.(find the total paid, and subtract 120,000 from it).
In order to buy a vacation home, Neal and Lilly took out a 20-year mortgage for $220,000 at an annual interest rate of 6%. After 10 years, they refinanced the unpaid balance of $142,125 at an annual rate of 4%. Use the table to find the monthly payments on the original loan; the monthly payments on the new loan; and the total amount saved on interest by refinancing. Click the icon to view a table of monthly payments on a $1,000 loan. The monthly payments on the original loan are $ (Type an integer or a decimal.)
Jim and Joan Miller are borrowing $120,000 at 6.5% per annum compounded monthly for 30 years to purchase a home. Their monthly payment is determined to be $758.48. You need to present Jim and Joan with a report detailing the following: A recursive formula for their balance after each monthly payment has been made. A determination of Jim and Joan's balance after the first payment. Use a spreadsheet or graphing utility to create a table showing their balance after each monthly payment. Determine when the balance will be below $75,000. Determine when the balance will be paid off. Determine the interest expense when the loan is paid.
Dr. & Mr. Baker were delighted to find a house for sale that they loved which required them to borrow $ 140,000. They need to decide between a 20-year or 30-year loan. Both loans charge interest at a rate of 9.6% per year compounded monthFind the total amount paid over the life of the 20-year loan. $ (e.) Find the total amount paid over the life of the 30-year loan. $ (f.) Find the total savings by going with the 20-year loan.
Shirley Trembley bought a house for $185,300. She put 20% down and obtains a simple interest amortized loan for the rest at 6 3 8 % for thirty years. (Round your answers to the nearest cent.) (a) Find her monthly payment.$ (b) Find the total interest.$ (c) Prepare an amortization schedule for the first two months of the loan. PaymentNumber PrincipalPortion InterestPortion TotalPayment Balance 0 $ 1 $ $ $ $ 2 $ $ $ $ (d) Most lenders will approve a home loan only if the total of all the borrower's monthly payments, including the home loan payment, is no more than 38% of the borrower's monthly income. How much must Shirley make to qualify for the loan?$ per month
Susan would like to buy a car. She went to the bank and got a loan for $40,000 at the annual interest rate of 4%, for 4 years. Calculate the monthly payment. Calculate the interest on the payment. Calculate the total payment. Make complete amortization schedule on excel