Question

Your local bank is offering an interest rate of 5.3% APR, compounded monthly, on a 60-month...

Your local bank is offering an interest rate of 5.3% APR, compounded monthly, on a 60-month loan. If all you can pay is $250 per month, what is the maximum loan you can afford to get for a new car?

PLEASE TRY TO BE A SIMPLE AS POSSIBLE, preferably using excel!

Homework Answers

Answer #1
Loan amount $ 13,151.55
Working:
Price of car today is the present value of cash flows in future.
Present Value of Cash flows = Annuity * Present value of annuity of 1
= $       250.00 * 52.60619
= $ 13,151.55
Present value of annuity of 1 = (1-(1+i)^-n)/i Where,
= (1-(1+0.004417)^-60)/0.004417 i 5.3%/12 = 0.004417
= 52.6061913 n = 60
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
2. A local credit union is advertising a car loan with an APR of 6.75%. If...
2. A local credit union is advertising a car loan with an APR of 6.75%. If interest is compounded monthly, (a) what is the interest rate per compounding period, and (b) what is the effective annual interest rate (i.e., the APY)? 3. Your local credit union is offering a 5.1% APR mortgage with monthly compounding (i.e., you pay them once a month). A regional bank nearby is offering a 5.0% APR mortgage with bi-monthly compounding (i.e., you pay them twice...
John borrows ​$46,000 from a local bank at an APR of 9.6​%, compounded monthly. His monthly...
John borrows ​$46,000 from a local bank at an APR of 9.6​%, compounded monthly. His monthly payments are ​$46,000​ (A/P,0.8​%,58​)=​$994 for a 58​-month loan. If John makes an extra payment on the first month of each​ year, his repayment duration for the loan will be reduced to how many​ months? ​John's repayment duration for the loan will be reduced to ______months
Oppenheimer Bank is offering 30​-year mortgage with an APR 5% based on monthly compounding. With this...
Oppenheimer Bank is offering 30​-year mortgage with an APR 5% based on monthly compounding. With this mortgage your monthly payments would be $1,970 per month. In​ addition, Oppenheimer Bank offers you the following​ deal: Instead of making the monthly payment of $1,970 every​ month, you can make half the payment every two weeks​ (so that you will make 52/2 =26 payments per​ year). With this​ plan, how long will it take to pay off the mortgage if the EAR of...
Oppenheimer Bank is offering a 30 year mortgage with an APR of 4.78% based on monthly...
Oppenheimer Bank is offering a 30 year mortgage with an APR of 4.78% based on monthly compounding. With this mortgage your monthly payment would be $1,986 every month, you can make half the payment every two weeks (so that you will make 52/2 =26 payment per year). With this plan, how long will it take to pay off the mortgage if the EAR of the loan is unchanged? The number of payments will be _____, which is approximately ____ years.
​E-Loan, an online lending​ service, recently offered 60​-month auto loans at 4.5 %compounded monthly to applicants...
​E-Loan, an online lending​ service, recently offered 60​-month auto loans at 4.5 %compounded monthly to applicants with good credit ratings. If you have a good credit rating and can afford monthly payments of $ 511 how much can you borrow from​ E-Loan? What is the total interest you will pay for this​ loan?
​E-Loan, an online lending​ service, recently offered 60​-month auto loans at 6% compounded monthly to applicants...
​E-Loan, an online lending​ service, recently offered 60​-month auto loans at 6% compounded monthly to applicants with good credit ratings. If you have a good credit rating and can afford monthly payments of $296​, how much can you borrow from​ E-Loan? What is the total interest you will pay for this​ loan?
You have saved $5,000 for a down payment on a new car. The largest monthly payment...
You have saved $5,000 for a down payment on a new car. The largest monthly payment you can afford is $300. The loan will have a 8% APR based on end-of-month payments. What is the most expensive car you can afford if you finance it for 60 months? Answer: $19,795.53 Please show all work and formulas used with a calculator, not excel.
Oppenheimer Bank is offering a 30​-year mortgage with an APR of 4.84% based on monthly compounding....
Oppenheimer Bank is offering a 30​-year mortgage with an APR of 4.84% based on monthly compounding. With this mortgage your monthly payments would be $2,040 per month. In​ addition, Oppenheimer Bank offers you the following​ deal: Instead of making the monthly payment of $2,040 every​ month, you can make half the payment every two weeks​ (so that you will make 52/2=26 payments per​ year). With this​ plan, how long will it take to pay off the mortgage if the EAR...
Your bank offers you a 36-month, 3% APR car loan for a $50000 new Mercedes SLK300...
Your bank offers you a 36-month, 3% APR car loan for a $50000 new Mercedes SLK300 Roadster. What will your monthly payment be?
You borrowed $20,000 from a bank at an interest rate of 12%, compounded monthly. This loan...
You borrowed $20,000 from a bank at an interest rate of 12%, compounded monthly. This loan will be repaid in 60 equal monthly installments over 5 years. Immediately after your 30th payment if you want to pay the remainder of the loan in a single payment, the amount is close to:
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT