Question

In: Finance

You are buying a car and need to borrow $15,000. You agreed to pay off the...

You are buying a car and need to borrow $15,000. You agreed to pay off the loan in 5 years by making monthly payments. The interest rate is 8%. Determine the monthly payment amount.  

Solutions

Expert Solution

Loan amount for Car = $15000

Calculating the Monthly Payment of Loan:-

Where, P = loan amount = $15,000

r = Periodic Interest rate =8%/12 =0.666%

n= no of periods = 5 years*12 = 60

Monthly Payment = $304.39

Monthly Payment as per Excel Function:-

If you need any clarification, you can ask in comments.     

If you like my answer, then please up-vote as it will be motivating

We were unable to transcribe this image

Monthly Payment = 15,000 * 0.00666 * (1 + 0.00666) 60 (1 + 0.00666)00 – 1

We were unable to transcribe this image

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

(a) You need to pay off a car loan within the next two years. The payment...
(a) You need to pay off a car loan within the next two years. The payment will be $4,000 every month. Today you have made a single deposit into a return-guaranteed investment account that will allow you to cope with all the monthly payments. This account earns an effective annual interest rate of 12.68250301%. The first payment will be made in one month. (i) Calculate the corresponding monthly rate for the investment account. (ii) “You need to have at least...
(a) You need to pay off a car loan within the next two years. The payment...
(a) You need to pay off a car loan within the next two years. The payment will be $4,000 every month. Today you have made a single deposit into a return-guaranteed investment account that will allow you to cope with all the monthly payments. This account earns an effective annual interest rate of 12.68250301%. The first payment will be made in one month. (i) Calculate the corresponding monthly rate for the investment account. (ii) “You need to have at least...
You borrow $2,400 to pay for a Caribbean vacation and will pay it off over 2...
You borrow $2,400 to pay for a Caribbean vacation and will pay it off over 2 years with regular monthly payments. What is the regular payment if interest is charged on the loan amount at APR of 12% interest is charged monthly on the balance still owed. Round up to the next whole dollar. Create an amortization table (balance sheet) for this loan. What is the amount of the balloon payment (the last payment)? What is the total amount of...
You borrow $24,000 to buy a car. The loan is to be paid off in quarterly...
You borrow $24,000 to buy a car. The loan is to be paid off in quarterly installments over four years at 10 percent interest annually. The first payment is due one quarter from today. What is the amount of each quarterly payment? a) $1,745 b) $1,794 c) $1,838 d) $1,876 I need the hand-written formula, not the calculator input.
You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate...
You are buying a car and will borrow $31,837 with a 5-year loan. The interest rate is 4.46%, what is your monthly payment?
Today, you borrowed $20,000 at 5.5% with quarterly compounding. You have agreed to pay off the...
Today, you borrowed $20,000 at 5.5% with quarterly compounding. You have agreed to pay off the loan over 5 years by making equal weekly payments. If you were solving for your unknown weekly payment amount using the annuity present value equation, what interest rate would you use? (Hint: You don't actually need to solve for your unknown payment amount.)
You borrow $80,000 at 5.00% per year and will pay off the loan in equal payments...
You borrow $80,000 at 5.00% per year and will pay off the loan in equal payments starting one year after the loan is made over a period of ten years. What are the annual end-of-year payments? Determine the amount of interest and principal that are paid each year. What is the total interest paid for the loan? If you are using the excel please show me the code or equation to do it myself
You have agreed to pay off an $8,000 loan in 30 monthly payments of $298.79 per...
You have agreed to pay off an $8,000 loan in 30 monthly payments of $298.79 per month. The annual interest rate is 9% on the unpaid balance. (a) How much of the first month’s payment will apply towards reducing the principal of $8,000? (b) What is the unpaid balance (on the principal) after 12 monthly payments have been made?
Suppose you're considering taking out a car loan for $15,000. Loan #1 allows you to borrow...
Suppose you're considering taking out a car loan for $15,000. Loan #1 allows you to borrow at 8% interest for 3 years, while Loan #2 charges 6% interest for 5 years. Which will cost you less in the long run?
1. You are considering buying a new car. Price is $23,000 and you will pay down...
1. You are considering buying a new car. Price is $23,000 and you will pay down payment of $3000. If you plan to incase the car over a 50 month period at a nominal interest of 12% what would be you monthly payment? A. $ 613.25 B. $ 510.25 C. $ 480. 65 D. $ 620.50 2. The conflict of interest exists between stockholders and creditors in a corporation because stockholders may A. Increase the firms investment risk level B....
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT