Topic 1 Class Exercise: Car Loan Worksheet Formulation
A local car dealer has asked you to develop a spreadsheet-based computer model to assist potential buyers in analyzing various alternatives when purchasing a new car. The worksheet should allow users to specify the Purchase Price of the car, as well as the Down Payment they are thinking of placing at the time of purchase, and the value of the Trade-In vehicle if applicable. The amount of the loan is based on these inputs.
The dealership makes loans of 1-5 years (the following table displays the interest rates based on the term of the
OR
PayPal Gateway not configured
OR
PayPal Gateway not configured