Spreadsheet: 792941d1661241220-xmirr-function-does-anyone-know-where-i-can-get-the-workbook-used-in-this-video-xmirr
Sheet: Sheet1

 | CFs |  |  |  |  |  |  |  | CFs
2010-01-01 00:00:00 | -400 |  | 0.04 | annl finance rate |  |  | monthly finance rate | 2010-01-01 00:00:00 | -400
2011-01-01 00:00:00 | -300 |  | 0.09 | annl reinvest rate |  |  | monthly reinvest rate | 2010-02-01 00:00:00 | 0
2012-01-01 00:00:00 | -100 |  |  | [NAME] (wrong!) |  |  | monthly [NAME] | 2010-03-01 00:00:00 | 0
2013-01-01 00:00:00 | -200 |  |  | XMIRR (XNPV) |  |  | annlzd [NAME] (correct) | 2010-04-01 00:00:00 | 0
2014-01-01 00:00:00 | 400 |  |  | XMIRR (SUM) |  |  |  | 2010-05-01 00:00:00 | 0
2014-04-01 00:00:00 | 650 |  |  |  |  |  |  | 2010-06-01 00:00:00 | 0
2015-04-01 00:00:00 | 900 |  |  |  |  |  |  | 2010-07-01 00:00:00 | 0
2016-04-01 00:00:00 | 100 |  |  |  |  |  |  | 2010-08-01 00:00:00 | 0
2017-04-01 00:00:00 | 200 |  |  |  |  |  |  | 2010-09-01 00:00:00 | 0
2018-04-01 00:00:00 | 400 |  |  |  |  |  |  | 2010-10-01 00:00:00 | 0
2019-04-01 00:00:00 | 300 |  |  |  |  |  |  | 2010-11-01 00:00:00 | 0
2020-04-01 00:00:00 | 100 |  |  |  |  |  |  | 2010-12-01 00:00:00 | 0
2021-04-01 00:00:00 | 500 |  |  |  |  |  |  | 2011-01-01 00:00:00 | -300
2022-04-01 00:00:00 | 300 |  |  |  |  |  |  | 2011-02-01 00:00:00 | 0
2023-04-01 00:00:00 | 300 |  |  |  |  |  |  | 2011-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2011-04-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2011-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2011-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2011-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2011-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2011-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2011-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2011-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2011-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-01-01 00:00:00 | -100
 |  |  |  |  |  |  |  | 2012-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-04-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2012-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-01-01 00:00:00 | -200
 |  |  |  |  |  |  |  | 2013-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-04-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2013-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-01-01 00:00:00 | 400
 |  |  |  |  |  |  |  | 2014-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-04-01 00:00:00 | 650
 |  |  |  |  |  |  |  | 2014-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2014-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-04-01 00:00:00 | 900
 |  |  |  |  |  |  |  | 2015-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2015-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-04-01 00:00:00 | 100
 |  |  |  |  |  |  |  | 2016-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2016-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-04-01 00:00:00 | 200
 |  |  |  |  |  |  |  | 2017-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2017-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-04-01 00:00:00 | 400
 |  |  |  |  |  |  |  | 2018-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2018-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-04-01 00:00:00 | 300
 |  |  |  |  |  |  |  | 2019-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2019-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-04-01 00:00:00 | 100
 |  |  |  |  |  |  |  | 2020-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2020-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-04-01 00:00:00 | 500
 |  |  |  |  |  |  |  | 2021-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2021-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-04-01 00:00:00 | 300
 |  |  |  |  |  |  |  | 2022-05-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-06-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-07-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-08-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-09-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-11-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2022-12-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2023-01-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2023-02-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2023-03-01 00:00:00 | 0
 |  |  |  |  |  |  |  | 2023-04-01 00:00:00 | 300