In cell B6, enter a formula to calculate the total paid over the life of the loan (the monthly payment amount * the number of payments). Use cell references. ***The question presented is in regards to sheet number 2, titled "NewTruck" in document)

Top't Corn Sales (July) Truck Location Old Bay Truffle Sea Salt and Caramel Total Farragut Square $ 2,100 $ 2,510 $ 3,540 $ 8,150 George Washington $ 900 $ 525 $ 1,660 $ 3,085 Georgetown $ 800 $ 1,005 $ 1,225 $ 3,030 K Street $ 1,150 $ 2,100 $ 2,010 $ 5,260 July Sales by Location July Sales by Popcorn Type $4,000 K Street; 23% $3,500 $3,000 Farragut Square; 42% $2,500 $2,000 $1,500 $1,000 Georgetown; 16% $500 $George Washington; 18% Old Bay Column B Truffle Column C Column D Sea Salt and Caramel Column E Price Loan Term (in months) Interest (annual) $42,000.00 12 8% Monthly Payment Total Payments $3,653.51 Online Sales During Buy 1 Get 1 Free Sale Date Quantity 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 6/30/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/1/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 Item 6 Old Bay 12 Original Blend 4 Original Blend 8 Sea Salt and Caramel 5 Sea Salt and Caramel 8 Truffle 2 Truffle 2 Original Blend 4 Old Bay 14 Truffle 8 Sea Salt and Caramel 10 Original Blend 2 Original Blend 4 Old Bay 2 Old Bay 4 Sea Salt and Caramel 2 Old Bay 2 Sea Salt and Caramel 5 Truffle 10 Original Blend 5 Old Bay 2 Original Blend 2 Sea Salt and Caramel 4 Original Blend 2 Old Bay 4 Old Bay 8 Old Bay 10 Original Blend 6 Sea Salt and Caramel 4 Sea Salt and Caramel 2 Sea Salt and Caramel 6 Truffle 12 Truffle 6 Original Blend 2 Truffle 2 Old Bay 4 Old Bay 6 Sea Salt and Caramel 10 Sea Salt and Caramel 2 Sea Salt and Caramel 2 Original Blend 4 Original Blend 14 Original Blend 12 Original Blend 10 Original Blend State MD OH CA MO NJ VA DC AL MD DC MS NC VA NJ NJ NY ID OH NY AL MD NC MS VA MD MD VA WV CA MO MS NY NY OH NY MD DC MS AL NC AL DC NY WV OH 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/2/2014 7/3/2014 7/3/2014 7/3/2014 7/3/2014 7/3/2014 7/3/2014 7/3/2014 7/3/2014 7/3/2014 7/4/2014 7/4/2014 7/4/2014 7/4/2014 7/4/2014 7/4/2014 7/4/2014 7/4/2014 7/4/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 7/5/2014 2 Truffle 2 Old Bay 2 Sea Salt and Caramel 4 Old Bay 2 Old Bay 4 Original Blend 4 Original Blend 2 Truffle 4 Original Blend 4 Original Blend 2 Sea Salt and Caramel 6 Sea Salt and Caramel 2 Old Bay 2 Truffle 4 Old Bay 2 Truffle 6 Old Bay 6 Original Blend 8 Original Blend 2 Sea Salt and Caramel 2 Old Bay 4 Old Bay 4 Original Blend 8 Truffle 12 Sea Salt and Caramel 2 Sea Salt and Caramel 2 Old Bay 2 Old Bay 4 Sea Salt and Caramel 2 Sea Salt and Caramel 6 Original Blend 2 Original Blend 4 Truffle 6 Old Bay 2 Old Bay 4 Old Bay 4 Truffle 2 Original Blend 6 Sea Salt and Caramel 6 Original Blend 8 Truffle 2 Old Bay 2 Original Blend 4 Old Bay 4 Original Blend 2 Sea Salt and Caramel 6 Original Blend 4 Original Blend VA VA DC MD WV AL SC SC OH NY NJ NJ NY NY OH DC CA AL MS OH CA DC CA VA NJ WV MD DC NJ NY MD AL VA MD MD VA NY OH CA CA CA MD MD VA VA MS NC WV 7/5/2014 7/5/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 7/6/2014 2 Old Bay 6 Truffle 2 Old Bay 2 Truffle 4 Original Blend 2 Original Blend 6 Sea Salt and Caramel 2 Truffle 2 Truffle 4 Sea Salt and Caramel 8 Old Bay 10 Old Bay 2 Original Blend 4 Truffle 10 Truffle 4 Truffle 12 Original Blend 2 Sea Salt and Caramel 2 Old Bay 4 Sea Salt and Caramel 2 Sea Salt and Caramel 6 Truffle 10 Sea Salt and Caramel 4 Old Bay WV OH MD OH CA MD VA MD VA AL MD WV WV CA CA MO WV DC DC MD VA AL MS NC