{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Examples","Function"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Step 1: Press ALT F8 to get Function"]
[]
[null,null,"Step 2: Change the Macros in to\"  This Workbook\""]
[]
[null,null,"Step 3: Select the xmirr_function and press CNTL, A"]
[]
[null,null,"Step 4: Copy the entire contents"]
[]
[null,null,"Step 5: Open your workbook and copy the contents into a macro"]

{"sheet":"Examples","index":1,"n_rows":23,"n_cols":9,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Example"]
[]
[null,"Re-investment Rate",7.0000000000000007E-2]
[null,null,"2017-01-01",{"$f":"EDATE(C4,12)","v":"2018-01-01"},{"$f":"EDATE(D4,12)","v":"2019-01-01"},"2020-01-01","2021-01-01","2022-01-01","2023-01-01"]
[null,"Cash Flow",-1000,300,300,300,300,300,300]
[]
[null,"MIRR",{"$f":"xmirr(C5:I5,C4:I4,C3,C3)","v":0.13567311881969579}]
[null,"XIRR",{"$f":"XIRR(C5:I5,C4:I4)","v":0.19898074269294738}]
[]
[null,"Re-investment Rate",0.1]
[null,null,"2017-01-01",{"$f":"EDATE(C11,1)","v":"2017-02-01"},{"$f":"EDATE(D11,1)","v":"2017-03-01"},"2017-04-01","2017-05-01","2017-06-01","2017-07-01"]
[null,"Cash Flow",-1000,180,170,160,150,190,190]
[]
[null,"MIRR",{"$f":"xmirr(C12:I12,C11:I11,C10,C10)","v":0.12563435996643024}]
[null,"XIRR",{"$f":"XIRR(C12:I12,C11:I11)","v":0.14415940642356875}]
[]
[]
[null,"Re-investment Rate",7.0000000000000007E-2]
[null,null,"2017-01-01",{"$f":"EDATE(C19,12)","v":"2018-01-01"},{"$f":"EDATE(D19,12)","v":"2019-01-01"},{"$f":"EDATE(E19,12)","v":"2020-01-01"},{"$f":"EDATE(F19,12)","v":"2021-01-01"},{"$f":"EDATE(G19,12)","v":"2022-01-01"},{"$f":"EDATE(H19,12)","v":"2023-01-01"}]
[null,"Cash Flow",-1000,0,0,0,0,0,2000]
[]
[null,"MIRR",{"$f":"xmirr(C20:I20,C19:I19,C18,C18)","v":0.12240286598069061}]
[null,"XIRR",{"$f":"XIRR(C20:I20,C19:I19)","v":0.12240286469459533}]

{"sheet":"Function","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}