Please provide how calculations are set up in excel if possible.

P16-6 (similar to) Early Payment discount decisions Prairie Manufacturing has four possible suppliers, all of which offer different credit terms. Except for the differences in credit terms, their products and services are virtually identical. The credit terms offered by these suppliers are shown in the following table: 5 (Note: Assume a 365-day year.) a. Calculate the approximate cost of giving up the cash discount from each supplier. b. If the firm needs short-term funds, which are currently available from its commercial bank at 8%, and if each of the suppliers is viewed separately, which, if any, of the suppliers' cash discounts should the firm give up? c. Now assume that the firm could stretch by 30 days its accounts payable (net period only) from supplier M. What impact, if any, would that have on your answer in part b relative to this supplier? a. The approximate cost of giving up the cash discount from supplier Jis %. (Round to two decimal places.) - X Data Table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Supplier J K L M Credit terms 2/5 net 30 EOM 2/30 net 100 EOM 2/15 net 80 EOM 4/20 net 90 EOM Print Done