In this exercise you will show how XNPV is based on daily interest rates. In the spreadsheet below, fill in all the cells marked??? and show that the sum of the entries E5:E10 gives the same result as cell B12.

Transcribed Image Text:

1 A Discount rate 2 Daily interest rate 3 B 8% ??? 4 Date Cash flow 5 15-Mar-22 -1,500 6 18-Apr-23 250 7 22-Jun-23 155 8 15-Nov-24 610 9 16-Feb-25 222 10 19-Oct-25 100 11 12 NPV 0 D E F Days between Present value based on days dates from initial date ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? ??? -380.076