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

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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Susan Bentley will purchase a home for $257,000. She will use a down payment of 20% and finance the remaining portion at 3.9% compounded monthly for 30 years. (a) What will be the monthly payment? (b) How much will remain on the loan after making payments for 5 years? (c) How much interest will be paid on the total amount of the loan over the course of 30 years? (Solve with Loans and Amortization)
While Mary Corens was a student at the University of Tennessee, she borrowed $12,000 in student loans at an annual interest rate of 7%. If Mary repays $1,700 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.
Kerri James is considering the purchase of a car, which will cost her $24,600. She will borrow the entire purchase price and make monthly payments over the next six years. The first payment is due next month and the annual interest rate is 3.00%. She will owe $____ on the car immediately following the 18th payment. A. 18,858.19 B. 18,531.57 C. 20,757.33 D. 19,184.00 E. 23,258.56
The Johnson family bought a quad and were able to finance it with a simple interest loan for 36 months at 11% interest. They are going to pay the loan off 3 months early. The balance after 33 months is $1,400. Find the amount of the final payment.
You decide to do some remodeling in the kitchen. Your parents agree to lend you the money, but you insist on paying them interest. The agreement is that they will lend you $6000.00 at a simple interest rate of 1.5% per year. In how many months will the interest be $360.
Today, Julie borrowed $5000 to purchase furniture for her new house. She can repay the loan in either of the two ways described below. (a) Five equal annual installments with interest determined at 5% per year. (b) One payment 3 years from now with interest determined at 7% per year. Show how to solve for each option, and please show how you solved it mathematically
After Shipra got a job, the first thing she bought was a new car. She took out an amortized loan for $45,000—with no ($0) down payment. She agreed to pay off the loan by making annual payments for the next four years at the end of each year. Her bank is charging her an interest rate of 10% per year. Yesterday, she called to ask that you help her compute the annual payments necessary to repay her loan. Calculate the annual payment and complete the following loan amortization table: Year Beginning Amount Payment Interest Paid Principal Paid Ending Balance 1 $45,000.00 2 3 4 -$0.02
Pat bought a home for $165,000 and made a $25,000 down payment. She got a fixed rate mortgage at 5% for 30 years. What will her payments be? What is the total interest over the life of the loan?
A. Solve the following problems and show your complete solution. 1. Anna bought a diamond necklace worth P185,000. Securing 15% down payment, they agreed to pay the remaining for 1 year with 12% annual interest rate. a. How much is the down payment? b. How much is the mortgage loan? 00 c. How much is the monthly amortization? d. Create an amortization table. HRISTIA
To start a new business, Alysha intends to borrow $25.000 from a local bank. If the bank asks her to repay the loan in 5 equal annual instalments of $6,935.24, determine the bank's effective annual interest rate on the ipan transaction. With annual compounding, what nominal rate would the bank quote for this loan?
After starting your first full-time job out of college, you decide to buy a new car for $12,000. Using Excel, create a complete amortization table for this car-loan: You make 36 equal end- of-month payments. The discount rate is 7.25% compounded monthly. How much would you owe after the 15th payment is made? Use excel to solve
Jill Mock wants to add a small hair salon to her home. The addition will cost $12,100. She will make a down payment of $2000 and finance the balance at 10.9% interest for 5 years (60) months). Find the monthly payment using a calculator Round your answer to the nearest cent. The monthly payment is S X