Question 12 goes with question 15.
uestion 12 O out of 10 Jessica has bought her first new cart She has an add-on interest loan (an uncommon type of simple interest loan in which all the interest is calculated up front and to the balance at the beginning), which means that if she makes her payments as scheduled, the balance will decrease linearly For tax purposes she needs to know what the loan balance was at the end of December (month 4) but she can only find the statements from the ends of October 2) November, and February. The chart below shows what she owed at the end of the months she has statements for: Month October November February Statement Number 2 3 6 Balance $13849.60 $13,610.81 $12.894.44 Use the statement numbers and the balances in Excel to determine the equation for Jessica's balance, B, as a function of which month, m, it is. Write the equation bel using the correct variables. Round all values to 2 decimal place and use a comma in numbers larger than 1000 VI - mb] tion 15 How many years will Jessica's car loan last before she has it paid off? "y, September 19, 2019 11:14:49 AM EDT uestion 12 O out of 10 Jessica has bought her first new cart She has an add-on interest loan (an uncommon type of simple interest loan in which all the interest is calculated up front and to the balance at the beginning), which means that if she makes her payments as scheduled, the balance will decrease linearly For tax purposes she needs to know what the loan balance was at the end of December (month 4) but she can only find the statements from the ends of October 2) November, and February. The chart below shows what she owed at the end of the months she has statements for: Month October November February Statement Number 2 3 6 Balance $13849.60 $13,610.81 $12.894.44 Use the statement numbers and the balances in Excel to determine the equation for Jessica's balance, B, as a function of which month, m, it is. Write the equation bel using the correct variables. Round all values to 2 decimal place and use a comma in numbers larger than 1000 VI - mb] tion 15 How many years will Jessica's car loan last before she has it paid off? "y, September 19, 2019 11:14:49 AM EDT