Please answer all parts in Excel

16-b (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: E. (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 J is %. (Round to two decimal places.) i Data Table X (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 Credit terms J 1715 net 40 EOM 3/20 net 100 EOM L 1/10 net 60 EOM M 4/20 nel 90 EOM Enter your answer in the answe 2 parts 8 remaining Print Done psov xj wiat