You are considering the purchase of a new car and taking out a loan. Here are the terms.
· Loan Amount: $35,000
· Interest rate: 6.5% (Annual), compounded monthly
· Term: 60 months
Task #1: Determine the total cost of the loan (Payment per month * number of months). Payment per month can be found using the PMT function. =PMT(rate/12,term_in_months,loan_amount)
Task #2: Now that you have the total cost of the car and the initial loan amount, determine the total amount of interest paid on the life of the loan.
Task #3: Compute and show on the spreadsheet, the monthly balance and interest paid each month for all 60 months.
· Interest is paid each month on the previous month’s balance.
· The balance for each month is the previous month’s balance, plus interest, minus the payment.
Also answer these questions
Assume that you can negotiate some of the terms. Determine how much you could save if you could negotiate a 10% better price, lower interest rate, or shorter term. You don’t have to re-calculate the monthly balance for each scenario. This can easily be done by changing the values in the PMT function. If you have the total cost computed automatically, you can make the change and the new value will be computed.
Task #4: Recalculate total cost, total interest paid and monthly payment, with price lowered to $31,500 (10% off).
Task #5: Recalculate total cost, total interest paid and monthly payment, with interest lowered to 6.1%.
Task #6: Recalculate total cost, total interest paid and monthly payment, with length of loan reduced to 54 months.
Task #7: Which of the 3 choices (Tasks 4, 5, 6) saves you the most total money (lowest total cost)? Mark clearly on the Excel sheet.
Task #8: Which of the 4 choices (original problem and Tasks 4, 5, 6) gives you the lowest total interest on the life of the loan? Mark clearly on the Excel sheet.
Task #9: Which of the 4 choices (original problem and Tasks 4, 5, 6) allows you to pay you the lowest monthly payments? Mark clearly on the Excel sheet.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more