How would I use Excel formulas to find these boxes?

1 1) 2 3 Base Case Car Value 4 5 Down Payment % 6 Loan Amount Term (months) 7 8 9 Payment 10 APR Monthly Rate 11 Payment per $1000 financed 12 13 EAR Total Interest paid 14 2) 15 16 Increase in APR +1% Car Value 17 18 Down Payment % 19 Loan Amount Term (months) 20 21 22 Payment 23 APR +1% Monthly Rate 24 25 EAR Total Interest paid 26 c 3) Amount Financed Amount Financed/ $1000 Payment Payment per $1000 Financed 48 4) How do your calculations compare to the advertisement per $1000 financed? 2.90% 10% 48 Current Price $27,895 2023 ACCORD SEDAN Finance 2.9% APR 24-48 mosl 3.9% APR 49-60 mos