{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Overview","Dataset-1","MIRR Function","Dataset-2","Comparing Projects with MIRR","VBA Code","MIRR vs IRR Functions"],"not_rendered":{"charts":0,"images":0,"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":"Overview","index":0,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"MIRR Function"]
[]
[null,"Returns the internal rate of return for a series of periodic cash flows, considering both cost of investment and interest "]
[null,"=MIRR (values, finance_rate, reinvest_rate)"]
[]
[null,"Year","Cash Flow",null,"Discount Rate",0.1,">> finance_rate"]
[null,0,-1000,">> values","Reinvest Rate",7.4999999999999997E-2,">> reinvest_rate"]
[null,1,200,">> values"]
[null,2,300,">> values"]
[null,3,500,">> values","MIRR",{"$f":"MIRR(C8:C18,F7,F8)","v":0.17136492886834009},{"$f":"_xlfn.FORMULATEXT(F11)","v":"=MIRR(C8:C18,F7,F8)"},">> Formula"]
[null,4,750,">> values"]

{"sheet":"Dataset-1","index":1,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Yearly Cash Flow of Project Alpha"]
[]
[null,"Year","Cash Flow",null,"Discount Rate",0.1]
[null,0,-50000,null,"Reinvest Rate",7.4999999999999997E-2]
[null,1,5000]
[null,2,8500]
[null,3,8000]
[null,4,9000]
[null,5,10000]
[null,6,9500]
[null,7,11000]
[null,8,13500]
[null,9,15000]
[null,10,20000]

{"sheet":"MIRR Function","index":2,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Using MIRR Function",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Year","Cash Flow",null,"Discount Rate",0.1,null,null,null,null,null,"Year","Cash Flow",null,"Discount Rate",0.1]
[null,0,-50000,null,"Reinvest Rate",7.4999999999999997E-2,null,null,null,null,null,0,-50000,null,"Reinvest Rate",7.4999999999999997E-2]
[null,1,5000,null,null,null,null,null,null,null,null,1,5000]
[null,2,8500,null,"MIRR",{"$f":"MIRR(C5:C15,F4,F5)","v":0.11184018390948625},null,null,null,null,null,2,8500,null,"MIRR"]
[null,3,8000,null,null,null,null,null,null,null,null,3,8000]
[null,4,9000,null,null,null,null,null,null,null,null,4,9000]
[null,5,10000,null,null,null,null,null,null,null,null,5,10000]
[null,6,9500,null,null,null,null,null,null,null,null,6,9500]
[null,7,11000,null,null,null,null,null,null,null,null,7,11000]
[null,8,13500,null,null,null,null,null,null,null,null,8,13500]
[null,9,15000,null,null,null,null,null,null,null,null,9,15000]
[null,10,20000,null,null,null,null,null,null,null,null,10,20000]

{"sheet":"Dataset-2","index":3,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"Yearly Cash Flow of Projects Alpha and Beta"]
[]
[null,"Year","Cash Flow of Alpha","Cash Flow of Beta",null,"Discount Rate",0.1]
[null,0,-50000,-50000,null,"Reinvest Rate",7.4999999999999997E-2]
[null,1,5000,2700]
[null,2,8500,3500]
[null,3,8000,4000]
[null,4,9000,5000]
[null,5,10000,8000]
[null,6,9500,12000]
[null,7,11000,15000]
[null,8,13500,17000]
[null,9,15000,20000]
[null,10,20000,25000]

{"sheet":"Comparing Projects with MIRR","index":4,"n_rows":15,"n_cols":17,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,6],[1,11,1,16]]}
[]
[null,"Yearly Cash Flow of Projects Alpha and Beta",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Year","Cash Flow of Alpha","Cash Flow of Beta",null,"Discount Rate",0.1,null,null,null,null,"Year","Cash Flow of Alpha","Cash Flow of Beta",null,"Discount Rate",0.1]
[null,0,-50000,-50000,null,"Reinvest Rate",7.4999999999999997E-2,null,null,null,null,0,-50000,-50000,null,"Reinvest Rate",7.4999999999999997E-2]
[null,1,5000,2700,null,null,null,null,null,null,null,1,5000,2700]
[null,2,8500,3500,null,"MIRR of Alpha",{"$f":"MIRR(C5:C15,G4,G5)","v":0.11184018390948625},null,null,null,null,2,8500,3500,null,"MIRR of Alpha"]
[null,3,8000,4000,null,"MIRR of Beta",{"$f":"MIRR(D5:D15,G4,G5)","v":9.6899191049749867E-2},null,null,null,null,3,8000,4000,null,"MIRR of Beta"]
[null,4,9000,4500,null,null,null,null,null,null,null,4,9000,4500]
[null,5,10000,6000,null,null,null,null,null,null,null,5,10000,6000]
[null,6,9500,8000,null,null,null,null,null,null,null,6,9500,8000]
[null,7,11000,15000,null,null,null,null,null,null,null,7,11000,15000]
[null,8,13500,17000,null,null,null,null,null,null,null,8,13500,17000]
[null,9,15000,20000,null,null,null,null,null,null,null,9,15000,20000]
[null,10,20000,22000,null,null,null,null,null,null,null,10,20000,22000]

{"sheet":"VBA Code","index":5,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Applying VBA Code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Year","Cash Flow",null,"Discount Rate",0.1,null,null,null,null,null,"Year","Cash Flow",null,"Discount Rate",0.1]
[null,0,-50000,null,"Reinvest Rate",7.4999999999999997E-2,null,null,null,null,null,0,-50000,null,"Reinvest Rate",7.4999999999999997E-2]
[null,1,5000,null,null,null,null,null,null,null,null,1,5000]
[null,2,8500,null,null,null,null,null,null,null,null,2,8500,null,"MIRR"]
[null,3,8000,null,null,null,null,null,null,null,null,3,8000]
[null,4,9000,null,null,null,null,null,null,null,null,4,9000]
[null,5,10000,null,null,null,null,null,null,null,null,5,10000]
[null,6,9500,null,null,null,null,null,null,null,null,6,9500]
[null,7,11000,null,null,null,null,null,null,null,null,7,11000]
[null,8,13500,null,null,null,null,null,null,null,null,8,13500]
[null,9,15000,null,null,null,null,null,null,null,null,9,15000]
[null,10,20000,null,null,null,null,null,null,null,null,10,20000]

{"sheet":"MIRR vs IRR Functions","index":6,"n_rows":15,"n_cols":16,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Comapring MIRR and IRR Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Year","Cash Flow",null,"Discount Rate",0.1,null,null,null,null,null,"Year","Cash Flow",null,"Discount Rate",0.1]
[null,0,-50000,null,"Reinvest Rate",7.4999999999999997E-2,null,null,null,null,null,0,-50000,null,"Reinvest Rate",7.4999999999999997E-2]
[null,1,5000,null,null,null,null,null,null,null,null,1,5000]
[null,2,8500,null,"MIRR",{"$f":"MIRR(C5:C15,F4,F5)","v":0.11184018390948625},null,null,null,null,null,2,8500,null,"MIRR",{"$f":"MIRR(M5:M15,P4,P5)","v":0.11184018390948625}]
[null,3,8000,null,"IRR",{"$f":"IRR(C5:C15)","v":0.14132160789788806},null,null,null,null,null,3,8000,null,"IRR",{"$f":"IRR(M5:M15)","v":0.14132160789788806}]
[null,4,9000,null,null,null,null,null,null,null,null,4,9000]
[null,5,10000,null,null,null,null,null,null,null,null,5,10000]
[null,6,9500,null,null,null,null,null,null,null,null,6,9500]
[null,7,11000,null,null,null,null,null,null,null,null,7,11000]
[null,8,13500,null,null,null,null,null,null,null,null,8,13500]
[null,9,15000,null,null,null,null,null,null,null,null,9,15000]
[null,10,20000,null,null,null,null,null,null,null,null,10,20000]