Doris purchased a Steinway concert piano for $132,000 with a down payment of 25%, and a loan for the balance. If she made equal monthly payments of $1650 at 4.95% compounded semi-annually, how long will it take to pay off the loan? (Give your answer in years and months) PLEASE PROVIDE FINANCIAL CALCULATOR TABLE

Doris purchased a Steinway concert piano for $132,000 with a down payment of 25%, and a loan for the balance. If she made equal monthly payments of $1650 at 4.95% compounded semi-annually, how long will it take to pay off the loan? (Give your answer in years and months) PLEASE PROVIDE FINANCIAL CALCULATOR TABLE

Intermediate Accounting: Reporting And Analysis

3rd Edition

ISBN:9781337788281

Author:James M. Wahlen, Jefferson P. Jones, Donald Pagach

Publisher:James M. Wahlen, Jefferson P. Jones, Donald Pagach

ChapterM: Time Value Of Money Module

Section: Chapter Questions

Problem 11RE: Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the...

See similar textbooks

Similar questions

Answer all subpart. Vanna has just financed the purchase of a home for $200 000.She agreed to repay the loan by making equal monthly blended payments of $3000 each at 4%/a compounded monthly. a.Create an amortization table using a Microsott Excel spreadsheet.In your answer include all the formulas used. b.How long will it take to repay the loan? c.How much will be the final payment? d.Determine how much interest she will pay for her loan.
Find the monthly payment for the loan indicated. yo purchase a home, a family borrowed $97,000 at an annual interest rate of 6.3% for 20 years. $____
Jen Logan bought a home in lowa for $110,000. She put down 20% and obtained a mortgage for 30 years at 51%. What are Jen's monthly payment and total interest cost of the loan? (Use Table 15.1.) Note: Round the intermediate calculation and final answers to the nearest cent. Monthly payment Total interest cost
please answer with correct calculations and explanations. QUESTION: Kari is purchasing a home for $220,000. The down payment is 25% and the balance will be financed with a year mortgage at 8% and 4 discount points. Kari made a deposit of $30,000 (applied to the doen payment) when the sales contract was signed. Kari also has three expenses: credit report, $70; appraisal fee, $110; title insurance premium, 1% of amount financed; title search, $200; and attorney's fees, $500. Find the closing costs (in $).
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
Samuel Ames owes 20,000 to a friend. He wants to know how much he would have to pay if he paid the debt in 3 annual installments at the end of each year, which would include interest at 14%. Draw a time line for the problem. Indicate what table to use. Look up the table value and place it in a brief formula. Solve.
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.
O CONSUMER MATHEMATICS Finding the monthly payment, total payment, and interest for a... When Laura bought her house, she got her mortgage through a bank. The mortgage was a personal, amortized loan for $99,500, at an interest rate of 3.75%, with monthly payments for a term of 40 years. For each part, do not round any intermediate computations and round your final answers to the nearest cent. If necessary, refer to the list of financial formulas. (a) Find Laura's monthly payment. (b) If Laura pays the monthly payment each month for the full term, find her total amount to repay the loan. $0 (c) If Laura pays the monthly payment each month for the full term, find the total amount of interest she will pay. $0 X Monthly Payment Formula M= P r 12 r 1- ( 1 + 12 ) - 12t
Sarah graduated from college with $29000 in student loan debt. The annual rate on her loans is 6 percent simple interest, and she will make monthly payments for 10 years. What is the remaining balance on her loan after five years, or 60 months? (Hint: Use the amortization function on your financial calculator or Excel Worksheet 5.6.) O $14500 O $16654 O $9682 $19318
Repaying a Loan While Mary Corens was a student at the University of Tennessee, she borrowed $10,000 in student loans at an annual interest rate of 10%. If Mary repays $1,300 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number. year(s)
Repaying a Loan While Mary Corens was a student at the University of Tennessee, she borrowed $9,000 in student loans at an annual interest rate of 10%. If Mary repays $1,300 per year, then how long (to the nearest year) will it take her to repay the loan? Do not round intermediate calculations. Round your answer to the nearest whole number.
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