Calculate the nominal annual cost of trade credit (i.e., a percentage rate) under each of the following, then briefly explain the how this knowledge can be used to better manage cash with a focus on the up-stream and down-stream supply chain. Note: Be sure to show all intermediate computations using cell references and formulas within the accompanying Excel file. (worth up to 20 points) Please show the calculations 3 1. 1/15, net 20 A9 Problem #5 Calculate the nominal annual cost of trade credit (i.e., a percentage rate) under each of the following, then briefly explain the how this knowledge can be used to better manage cash with a focus on the up-stream and down-stream supply chain. Note: Be sure to show all intermediate computations using cell references and formulas within the accompanying Excel file. (worth up to 20 points) Please show the calculations N 3 1. 1/15, net 20 4 2. 2/10, net 60 5 3.3/10, net 45 6 4. 2/10, net 45 7 5. 2/15, net 40 8 9 10 11 12