show me the function

818 B Treasury Bills Days to Maturity Bid Yield 9/26/2019 23 12/12/2019 8/13/2020 100 345 7 8 Required: 9 Treasury Bill Face Value: 10 Days in a Year: $10,000 360 11 Using the table and information above, please calculate the prices using Bank Discount Method: 12 13 (Use cells A4 to D10 from the given information to complete this question.) 14 15 Maturity Price at which Dealer Will Buy 16 Price at which Dealer Will Sell $9,987,67 17 9/26/2019 12/12/2019 8/13/2020 $9,987.60 $9,948.10 18 $9,840.62 19 20 21 22 Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work Graded Worksheet -NMASCHNISSAN 1 2 3 4 5 6 fx=89/(1+C6*86/810) Maturity 0.01943 0.01878 0.0169 D Ask Yield 8 00 59 0.01933 0.01868 0.0168 81