Assignment#1 Loan Amortization
Need Help Writing an Essay?
Tell us about your assignment and we will find the best writer for your project
Get Help Now!Bill has $25,000 in an investment account earning 6 percent per year. Bill decides to purchase a new car with a sticker price of $25,000. The car dealer offers Bill either $2,000 cash back or 2% financing for 5 years. If Bill takes the financing, he will make 60 equal monthly payments. Otherwise, he will pay $23,000 today for the car.
(a) Calculate the monthly payment required if Bill agrees to the sticker price of $25,000 and finances the car at 2% per year.
(b) Prepare the amortization schedule for the loan using an Excel spreadsheet.
(c) Prepare a graph in Excel that shows the portion of each payment that goes to interest and the portion that goes to principal.
(d) Based on the time value of money, should Bill take the $2,000 cash back or the 2% financing? Clearly explain and defend your choice.
Apply appropriate analytical techniques to a given business problem, generate and compare alternatives, and develop a solution. you must use Excel to solve this problem. you have 15 hours from now
Papershost.com is your go-to destination for swift and trustworthy essay writing assistance. Our comprehensive writing services encompass essays, coursework, research papers, and more, ensuring a seamless solution for all your academic needs. Entrust your writing assignments to our skilled writers and bid farewell to concerns and stress. Rest assured, your college papers are secure in our capable hands, promising a hassle-free and reliable experience.
Do not let academic stress weigh you down. PapersHost.com is here to empower you with exceptional essay and assignment writing services. Place your order today and experience the difference of working with a dedicated team committed to your academic success.
Get Unstuck! Get Paper Writing Help. All papers are plagiarism-free and pass Turnitin, SafeAssign, LopesWrite, etc. Hire Your Personal Essay Writer Today!
