Assignment#1 Loan Amortization â Due Tuesday, October 6th, 2015 at thebeginnin

Assignment#1 Loan Amortization â Due Tuesday, October 6th, 2015 at thebeginning of class â HARD COPIES ONLY â DO NOT EMAIL TO MEBill has $25,000 in an investment account earning 6 percent per year. Bill decides topurchase 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 make60 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,000and 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 interestand 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.

Our Service Charter

1. Professional & Expert Writers: Topnotch Essay only hires the best. Our writers are specially selected and recruited, after which they undergo further training to perfect their skills for specialization purposes. Moreover, our writers are holders of masters and Ph.D. degrees. They have impressive academic records, besides being native English speakers.

2. Top Quality Papers: Our customers are always guaranteed of papers that exceed their expectations. All our writers have +5 years of experience. This implies that all papers are written by individuals who are experts in their fields. In addition, the quality team reviews all the papers before sending them to the customers.

3. Plagiarism-Free Papers: All papers provided by Topnotch Essay are written from scratch. Appropriate referencing and citation of key information are followed. Plagiarism checkers are used by the Quality assurance team and our editors just to double-check that there are no instances of plagiarism.

4. Timely Delivery: Time wasted is equivalent to a failed dedication and commitment. Topnotch Essay is known for timely delivery of any pending customer orders. Customers are well informed of the progress of their papers to ensure they keep track of what the writer is providing before the final draft is sent for grading.

5. Affordable Prices: Our prices are fairly structured to fit in all groups. Any customer willing to place their assignments with us can do so at very affordable prices. In addition, our customers enjoy regular discounts and bonuses.

6. 24/7 Customer Support: At Topnotch Essay, we have put in place a team of experts who answer to all customer inquiries promptly. The best part is the ever-availability of the team. Customers can make inquiries anytime.