Please help to complete the yellow rectangles

Problem: Joe Tulkin owns Tulkin Wholesale Co. He sells paper, tape, file folders, and other office supplies to about 120 retailers in nearby cities. His average retailer-customer spends about $900 a month. When Tulkin started business in 1991, competing wholesalers were giving retailers invoice terms of 3/10, net 30. Tulkin never gave the issue much thought-he just used the same invoice terms when he billed customers. At that time, about half of his customers took the discount. Recently, he noticed a change in the way his customers were paying their bills. Checking his records, he found that 90 percent of the retailers were taking the cash discount. With so many retailers taking the cash discount, it seems to have become a price reduction. In addition, Tulkin learned that other wholesalers were changing their invoice terms. Tulkin decides he should rethink his invoice terms. He knows he could change the percent rate on the cash discount, the number of days the discount is offered, or the number of days before the face amount is due. Changing any of these, or any combination, will change the interest rate at which a buyer is, in effect, borrowing money if he does not take the discount. Tulkin decides that it will be easier to evaluate the effect of different invoice terms if he sets up a spreadsheet to let him change the terms and quickly see the effective interest rate for each change. Spreadsheet The spreadsheet values outlined in yellow can be changed in order to determine possible outcomes. You can find the initial values in the corresponding blue cells in columns E and F. Start by entering the initial values into columns B and C. Then review the questions below and adjust the values in columns B and C to determine the correct answers. D 1 Initial 2 Situation Situation 3 Cash Discount % 3% 4 Days to Pay to Get Cash Discount 10 5 Days to Pay Net Involce Value 30 Days per Year 365 7 Approximate Effective Interest Rate NaN 54.75% 8 Average Monthly Invoice Face Amount $ 900.00 9 Number of Customers 10 Percent Who Take Cash Discount 50% 11 Total Face Value of Involoes (Gross Sales) $ 0.00 $ 108,000.00 12 Total of Monthly Cash Discounts $ 0.00 $ 1,620.00 13 Net Sales (Gross Sales Minus Cash Discounts) $ 0.00 $ 106,380.00 14 Ratio of Total Discounts to Total Face Value NaN 0.015 B 6 120 Problem: Joe Tulkin owns Tulkin Wholesale Co. He sells paper, tape, file folders, and other office supplies to about 120 retailers in nearby cities. His average retailer-customer spends about $900 a month. When Tulkin started business in 1991, competing wholesalers were giving retailers invoice terms of 3/10, net 30. Tulkin never gave the issue much thought-he just used the same invoice terms when he billed customers. At that time, about half of his customers took the discount. Recently, he noticed a change in the way his customers were paying their bills. Checking his records, he found that 90 percent of the retailers were taking the cash discount. With so many retailers taking the cash discount, it seems to have become a price reduction. In addition, Tulkin learned that other wholesalers were changing their invoice terms. Tulkin decides he should rethink his invoice terms. He knows he could change the percent rate on the cash discount, the number of days the discount is offered, or the number of days before the face amount is due. Changing any of these, or any combination will change the interest rate at which a buyer is, in effect, borrowing money if he does not take the discount. Tulkin decides that it will be easier to evaluate the effect of different invoice terms if he sets up a spreadsheet to let him change the terms and quickly see the effective interest rate for each change. Spreadsheet The spreadsheet values outlined in yellow can be changed in order to determine possible outcomes. You can find the initial values in the corresponding blue cells in columns E and F. Start by entering the initial values into columns B and C. Then review the questions below and adjust the values in columns B and C to determine the correct answers. D 1 Initial 2 Situation Situation 3 Cash Discount % 3% 4 Days to Pay to Get Cash Discount 10 5 Days to Pay Net Involce Value 30 Days per Year 365 7 Approximate Effective Interest Rate NaN 54.75% 8 Average Monthly Invoice Face Amount $ 900.00 9 Number of Customers 10 Percent Who Take Cash Discount 50% 11 Total Face Value of Invoices (Gross Sales) $ 0.00 $ 108,000.00 12 Total of Monthly Cash Discounts $ 0.00 $ 1,620.00 13 Net Sales (Gross Sales Minus Cash Discounts) $ 0.00 $ 106,380.00 14 Ratio of Total Discounts to Total Face Value NaN 0.015 B 6 120 Questions: a. With 90 percent of Tulkin's customers now taking the discount, what is the total monthly cash discount amount? $900.00 $1,620.00 $2,916.00 $13,244.00 O $48,600 b. If Tulkin changes his invoice terms to 1/5, net 20, what interest rate is each buyer paying by not taking the cash discount? 14.60% 24.33% 36.50% 54.75% 90.00% c. With 1/5, net 20 terms, would more or fewer buyers be likely to take the discount? More buyers would take the discount Fewer buyers would take the discount The number of buyers taking the discount would not change d. Tulkin thinks 10 customers will switch to other wholesalers if he changes his invoice terms to 2/10, net 30, while 60 percent of the remaining customers will take the discount. For this situation, what will the total gross sales (total invoice) amount be? $97,812.00 $99,000.00 O $105,084.00 $106,380.00 $108,000.00 e. Using the terms from the previous question, what would the total net sales receipts after the total cash discount be? $97,812.00 $99,000.00 $105,084.00 $106,380.00 $108,000.00