2 Area One-Variable Data Table: APR 5 Cost of Car 20,000 2,000 4.00% Calculated Results for Each APR Down Payment 7 Annual Percentage Rate (APR) 8 No. Years for Loan 4.00% 4.25% 4.50% 4.75% 5.00% 2.a 2.b 2.c 2.d 2.0 Payments Per Year 12 Output Area Amount of Loan 1.a. 1.b. 1.c 1.d 1.e 1.f Periodic Rate No. Payment Periods Monthly Payment Total to Repay Loan Total Interest Paid 1. Write the formulas in the cells above that calculate each amount. Use the appropriate cell references