You are buying a junkmobile for $2000. Dealer offers 2 options. Option 1: you pay cash and get 15% discount today. Option 2: "0% financing". Specifically, you pay nothing today,a nd pay full price of $2000 in 1 year. On the other hand, a bank would loan you money for 10%. If you don't have money today, would you take dealer's 0% financing or bank loan? Please answer the question with supporting work.

please show the excel functions you used to explain the work! please

Data View Tell me - 397 Draw Page Layout Formulas Review Connections Properties Get Data from Refresh Data Picture Stocks All Edit Links Currencies Con Geography Automatic peo A1 data fx You are buying a junkmobile for $2000. Dealer offers 2 options. Option 1: you and B D E Powe 1 You are buying a junkmobile for $2000. Dealer offers 2 options. Option 1: you pay cash and get 15% discount today. Option 2: "C 2 List price of junkmobile 2,000.00 3 cash payment discount 15% 4 Bank rate of interest 10% 5 Year Payment in Payment with cash credit 7 8 -1,700.00 0.00 9 1 -2,000.00 10 11 12 13 14 6 0 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 26