writer
5,435
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + + + + + − *'''Where 'rate'''' is the discount rate to apply to the cash flows − *'V' is a series of cash flows that corresponds to a schedule of payments in dates − *'dates' is a schedule of payment dates.
no edit summary
'''XNPV'''('''R''','''V''', '''dates''')
<div style="font-size:30px">'''XNPV(Rate,V,Dates)'''</div><br/>
*<math>Rate</math> is the discount rate to apply to the cash flows
*<math>V</math> is a series of cash flows that corresponds to a schedule of payments in dates
*<math>Dates</math> is a schedule of payment dates.
==Description==
==Description==
*This function computes the net present value for a schedule of cash flows that is not essentially periodic.
*This function computes the net present value for a schedule of cash flows that is not essentially periodic.