Microsoft excel..
Armyone123
Diaz_exploring_e02_grader_h3.xlsxPayment
| Inputs | Intermediate Calculations | |||
| Negotiated Cost of Vehicle | $ 35,000.00 | |||
| Additional Down Payment | $ 5,000.00 | |||
| Date of First Payment | ||||
| Credit Rating | Excellent | |||
| Constants | Outputs | |||
| Sales Tax Rate | 5% | |||
| Term of Loan in Years | 5 | |||
| # of Payments Per Year | 12 | |||
| Credit | Down Payment | APR | Total Monthly Payment | |
| Excellent | 0.05 | 0.0325 | ||
| Good | 0.1 | 0.035 | ||
| Fair | 0.15 | 0.0425 | ||
| Poor | 0.2 | 0.0525 |
