a)Upon entering college, you purchase the car of your dreams for $26000. You pay $5200 down and finance the balance for 4 years at 7% compounded monthly. Your monthly payments are $498.09. Set up the spreadsheet to display the outstanding balance for each month for 4 years. As a checkpoint, you should get $16931.98 just after your 10th payment. How much is still owed on the loan just after 30 payments.$ Find the size of the last payment. $ How much interest in total did you spend on the car? $ (b) If you decided to get a 3 year loan instead of a 4 year loan the payments will be $642.25. What will be the total saving in interest from getting a three year loan instead of a 4 year loan?(Note: you do not need a spreadsheet to answer this question.) $ (c) If you decided to get a 5 year loan, the payments will be $411.87. Determine the total amount of interest that will be paid on a 5 year loan $

a)Upon entering college, you purchase the car of your dreams for $26000. You pay $5200 down and finance the balance for 4 years at 7% compounded monthly. Your monthly payments are $498.09. Set up the spreadsheet to display the outstanding balance for each month for 4 years. As a checkpoint, you should get $16931.98 just after your 10th payment. How much is still owed on the loan just after 30 payments.$ Find the size of the last payment. $ How much interest in total did you spend on the car? $ (b) If you decided to get a 3 year loan instead of a 4 year loan the payments will be $642.25. What will be the total saving in interest from getting a three year loan instead of a 4 year loan?(Note: you do not need a spreadsheet to answer this question.) $ (c) If you decided to get a 5 year loan, the payments will be $411.87. Determine the total amount of interest that will be paid on a 5 year loan $

Financial Accounting: The Impact on Decision Makers

10th Edition

ISBN:9781305654174

Author:Gary A. Porter, Curtis L. Norton

Publisher:Gary A. Porter, Curtis L. Norton

Chapter9: Current Liabilities, Contingencies, And The Time Value Of Money

Section: Chapter Questions

Problem 9.18E

See similar textbooks

Similar questions

Suppose you want to have $600, 000 for retirement in 15 years. Your account earns 9% interest. Feel free to use the Online Basic Financial Calculator a) How much would you need to deposit in the account each month? $ b) How much interest will you earn? $
Starting next year, you will need $5,000 annually for 4years to complete your education. (One year from today you will withdraw the first $5,000.)Your uncle deposits an amount today in a bank paying 6% annual interest, which will providethe needed $5,000 payments.a. How large must the deposit be?b. How much will be in the account immediately after you make the first withdrawal?
You want to be able to withdraw $50,000 each year for 30 years. Your account earns 6% interest. a) How much do you need in your account at the beginning? b) How much total money will you pull out of the account? c) How much of that money is interest? Question Help: Video
Please indicate what you entered into your calculator to solve these problems. 1. You graduated with $28,000 in school loans. You will make annual payments of $4,000 at the beginning of each year for the next 10 years. What annual rate of interest are you being charged on your school loans? 2. You bought equipment for $23,000 and agreed to make monthly payments at the end of each quarter for 5 years. Assuming you are being charged 9% interest compounded QUARTERLY, how much will your QUARTERLY payments be? 3. You currently have $750,000 in your building fund. If you start depositing an additional $20,000 per year into this account at the beginning of each year, how much will be in the account after 6 years assuming 5.5% interest compounded annually? 4. You want to start saving for a new car and have decided to put S$90 per month at the beginning of each month into an account which earns 6% compounded monthly. You would like to be able to buy a car for $25,000. (a) How many deposits will…
You plan to buy a new car in three years and begin depositing $250 per month into a savings account that earns 4.5% annual interest, compounded monthly. After three years of deposits, how much money is in the account? What would you need to enter in Excel to help you answer this question?
You have $5,000 on a credit card that charges a 17% interest rate. If you want to pay off the credit card in 4 years, how much will you need to pay each month (assuming you don't charge anything new to the card)? Question Help: Submit Question Video each month Search hp
1. Starting next year, you will need $15,000 annually for 4 years to complete your education. (One year from today you will withdraw the first $15,000.) Your uncle deposits an amount today in a bank paying 8% annual interest, which will provide the needed $15,000 payments. a. How large must the deposit be? Do not round intermediate calculations. Round your answer to the nearest cent. b.How much will be in the account immediately after you make the first withdrawal? Do not round intermediate calculations. Round your answer to the nearest cent. 2. You have saved $3,000 for a down payment on a new car. The largest monthly payment you can afford is $400. The loan will have a 12% APR based on end-of-month payments. What is the most expensive car you can afford if you finance it for 48 months? For 60 months? Do not round intermediate calculations. Round your answers to the nearest cent. 3. You borrow $90,000; the annual loan payments are $12,852.25 for 30 years. What interest rate are you…
1. Exercise One: Jessica decides to take a $25,000 to help her cover her tuition expenses. The tenor of the loan is 10 years, and the interest rate is 6.75%. Repayments will be made on a monthly frequency. Based on the aforementioned information, and the material covered in class, (a) use the PMT function in Excel to find the fixed total payment, (b) verify your answer from (a) by programming the present value annuity formula as shown in class, (c) create an amortization schedule for this loan, (d) create a bar chart showing the Fixed Total Payment, Interest Paid, and Principal Paid.
Starting next year, you will need $25,000 annually for 4 years to complete your education. (One year from today you will withdraw the first $25,000.) Your uncle deposits an amount today in a bank paying 4% annual Interest, which will provide the needed $25,000 payments. a. How large must the deposit be? Do not round Intermediate calculations. Round your answer to the nearest cent. $ b. How much will be in the account immediately after you make the first withdrawal? Do not round intermediate calculations. Round your answer to the nearest cent. $
Suppose that you take out an unsubsidized Stafford loan on September 1 before your junior year for $45004500 and plan to begin paying it back on December 1 after graduation and grace period 27 months later. The interest rate is 6.8%. How much of what you will owe will be interest?$Round your answer to the nearest cent.
Suppose you receive $500 in graduation money. You decide to put it into an account paying 5%. If you deposit $175 into that same account every month for 7 years, how much money will you have at the end? $14,700.00 B $15,200.00 $16,195.49 $18,266.53 (E) $25,482.80
You recently graduated from Miami University and are looking to purchase a new vehicle. The car costs $21,000. The bank quotes you an interest rate of 15 percent APR for a 72-month loan with a 10 percent down payment. What will your monthly payment be? $375.27 $2,835.12 $399.64 $3,150.13 $444.05