You borrow $40,000 to buy a car. The loan is to be paid off in 10 equal monthly payments at 12% interest annually. The first payment is due one month from today. What is the amount of each monthly payment? (Round to nearest ones)
Solution: Calculation of Monthly Payment to repay the loan of $40,000 in 10 Months
Following are the steps to be followed on Microsoft Excel to calculate the Monthly payment:
Step 1: Click on "FORMULAS" tab at the top of Microsoft
Excel
Step 2: Select the option "Financial"
Step 3: Under "Financial" select the option "PMT"
Step 4: Insert Rate = 0.12/12 Nper = 10 PV = -40000
PMT = $4,223.28
Therefore, the Monthly Payment to repay the loan of $40,000 in 10 Months at an interest rate of 12% annually is $4,223.28
You borrow $40,000 to buy a car. The loan is to be paid off in 10...
You borrow $30,000 to buy a boat. The loan is to be paid off in monthly installments over one year at 18% interest annually. The first payment is due one month from today. What is the amount of each monthly payment? (EV of $1. PV of $1. EVA of $1. PVA of $1. FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) ed Multiple Choice $2,500 $2,384 Submitted Multiple Choice Ο $2,500. Ο $2,384. Ο...
When you borrow money to buy a house or a car, you pay off the loan in monthly payments, but the interest is always accruing on the outstanding balance. This makes the determination of your monthly payme on a loan more complicated than you might expect. If you borrow P dollars at a monthly interest rate ofras decimal) and wish to pay off the note in months, then your monthly payment M = M(Prt) in dollars can be calculated using...
When you borrow money to buy a house, a car, or for some other purpose, you repay the loan by making periodic payments over a certain period of time. Of course, the lending company will charge interest on the loan. Every periodic payment consists of the interest on the loan and the payment toward the principal amount. To be specific, suppose that you borrow $1,000 at an interest rate of 7.2% per year and the payments are monthly. Suppose that...
Mrs. Landingham recently purchased a new car. In addition to her down payment she will borrow $10,000 to pay for the car, which she will pay back with 60 equal monthly payments over the next five years. The stated annual interest rate is 12%, compounded monthly. If she receives the loan today and makes her first payment one month from today, what will be the amount of her first payment? I've tried so many times and I don't have any...
In order to buy a car, you borrow $35,000 from a friend at 12%/year compounded monthly for 4 years. You plan to repay the loan with 48 equal monthly payments. a. How much are the monthly payments? b. How much interest in in the 23rd payment? c. What is the remaining balance after the 37th payment?
You are looking to buy a car. You can afford $730 in monthly payments for five years. In addition to the loan, you can make a $830 down payment. If interest rates are 10.00 percent APR, what price of car can you afford (loan plus down payment)? (Do not round Intermediate calculations and round your final answer to 2 decimal places.) Present value To borrow $3,700, you are offered an add-on interest loan at 9.3 percent with 12 monthly payments....
A commercial bank will loan you $27,817 for 3 years to buy a car. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 13.32 percent of the unpaid balance. What is the amount of the monthly payments? Round the answer to two decimal places.
A commercial bank will loan you $33,732 for 4 years to buy a car. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 7.29 percent of the unpaid balance. What is the amount of the monthly payments? Round the answer to two decimal places.
A commercial bank will loan you $40,283 for 6 years to buy a car. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 4.81 percent of the unpaid balance. What is the amount of the monthly payments? Round the answer to two decimal places.
A commercial bank will loan you $50,753 for 3 years to buy a car. The loan must be repaid in equal monthly payments at the end of the month. The annual interest rate on the loan is 6.46 percent of the unpaid balance. What is the amount of the monthly payments? Round the answer to two decimal places.