Use Excel to answer this question: You want to borrow money from your bank to purchase a car. The maximum amount you are willing to pay is $450 per month. How much can you borrow if the loan lasts for 7 years, your first payment starts today, and the interest rate is 4.5% APR under monthly compounding? O $32,495.13 O $29,489.45 O $31,576.98 O $27,456.87

Use Excel to answer this question: You want to borrow money from your bank to purchase a car. The maximum amount you are willing to pay is $450 per month. How much can you borrow if the loan lasts for 7 years, your first payment starts today, and the interest rate is 4.5% APR under monthly compounding? O $32,495.13 O $29,489.45 O $31,576.98 O $27,456.87

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 3PB: Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate...

See similar textbooks

Similar questions

Use the tables in Appendix B to answer the following questions. A. If you would like to accumulate $4,200 over the next 6 years when the interest rate is 8%, how much do you need to deposit in the account? B. If you place $8,700 in a savings account, how much will you have at the end of 12 years with an interest rate of 8%? C. You invest $2,000 per year, at the end of the year, for 20 years at 10% interest. How much will you have at the end of 20 years? D. You win the lottery and can either receive $500,000 as a lump sum or $60,000 per year for 20 years. Assuming you can earn 3% interest, which do you recommend and why?
Calculating interest earned and future value of savings account. If you put 6,000 in a savings account that pays interest at the rate of 3 percent, compounded annually, how much will you have in five years? (Hint: Use the future value formula.) How much interest will you earn during the five years? If you put 6,000 each year into a savings account that pays interest at the rate of 4 percent a year, how much would you have after five years?
Suppose you take out a 36-month installment loan to finance a delivery van for $26,100. The payments are $989 per month, and the total finance charge is $9,504. After 25 months, you decide to pay off the loan. After calculating the finance charge rebate, find your loan payoff (in $). (Round your answer to the nearest cent.) Need Help? Read It Watch It Master It
Pls help on ur own.Suppose you take out a car loan that requires you to pay $8,000 now, $5,000 at the end of year 1, and $7,000 at the end of year 2. The interest rate is 5% now and increases to 9% in the next year. What is the present value of the payments?
K You have just taken out a five-year loan from a bank to buy an engagement ring. The ring costs $5,500. You plan to put down $1,200 and borrow $4,300. You will need to make annual payments of $1,200 at the end of each year. Show the timeline of the loan from your perspective. How would the timeline differ if you created it from the bank's perspective? Show the timeline of the loan from your perspective. (Select the best choice below.) OA. Year Cash Flow $4,300 0 OB. Year 0 Cash Flow - $1,200 OC. Year Cash Flow $5,500 0 OD. Year 1 - $1,200 1 $1,200 2 Cash Flow - $4,300 $1,200 - $1,200 2 $1,200 - $1,200 - $1,200 2 $1,200 3 - $1,200 3 $1,200 3 - $1,200 3 $1,200 - $1,200 4 $1,200 4 - $1,200 4 $1,200 5 - $1,200 5 $1,200 5 - $1,200 5 $1,200
< A friend asks to borrow $51 from you and in return will pay you $54 in one year. If your bank is offering a 6.2% interest rate on deposits and loans: a. How much would you have in one year if you deposited the $51 instead? b. How much money could you borrow today if you pay the bank $54 in one year? c. Should you loan the money to your friend or deposit it in the bank?
Suppose you take out a car loan that requires you to pay $7,000 now, $4,000 at the end of year 1, and $6,000 at the end of year 2. The interest rate is 5% now and increases to 10% in the next year. What is the present value of the payments? Enter your response below rounded to 2 decimal places. Number
Imagine you have a credit card balance of $1,000 that you would like to pay off within one year. The annual interest rate on that credit card is 16%, but interest compounds monthly, and you are required to make a payment each month. What amount would you have to pay monthly to pay off this balance within one year? Question options: a $90.71 b $80.66 c $83.33 d $99.12
Give typing answer with explanation and conclusion Suppose your gross monthly income is $5,900 and your current monthly payments are $575. If the bank will allow you to pay up to 36% of gross monthly income (less current monthly payments) for a monthly house payment, what is the maximum loan you can obtain if the rate for a 30-year mortgage is 4.65%? (Round your answer to the nearest cent.)
You want to buy a car, and a local bank will lend you $20,000. The loan will be fully amortized over 5 years (60 months), and nominal annual interest rate will be 6%. What will be the monthly loan payment? $275.75 $444.89 $304.81 $386.66 $295.78
You are looking to buy a car that costs $15,000. Your bank has told you that they will give a five year loan with an APR of 5% that compounds monthly. What is your monthly payment? $304 $299 $256 $283
Solve the following problems. Round your results to the nearest cent as needed. You need a loan to purchase a car. After the down payment, you need to borrow $24, 200. If a bank offers you a loan at 6.9% for 6 years, how much will your monthly payment be? How much will you pay in interest? Your monthly payment will be $ dollars You will pay a total of $ dollars TVM Calculator in interest