{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Calculating IRR","Use of  IRR Function","Using VBA","Manually Calculating","Applying Goal Seek Feature","Using XIRR Function","Monthly Cash Flow","Using MIRR Function","Calculating IRR for Real Estate","IRR Compared"],"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":"Calculating IRR","index":0,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Calculating IRR"]
[]
[null,"Year","Cash Flow"]
[null,0,-1000]
[null,1,200]
[null,2,500]
[null,3,200]
[null,4,150]
[null,5,500]

{"sheet":"Use of  IRR Function","index":1,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Use of  IRR Function",null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Year","Cash Flow",null,null,null,null,null,"Year","Cash Flow"]
[null,0,-1000,null,null,null,null,null,0,-1000]
[null,1,200,null,null,null,null,null,1,200]
[null,2,500,null,null,null,null,null,2,500]
[null,3,200,null,null,null,null,null,3,200]
[null,4,150,null,null,null,null,null,4,150]
[null,5,500,null,null,null,null,null,5,500]
[]
[null,"IRR (Internal Rate of Return)",{"$f":"IRR(C5:C10)","v":0.15714941412670425},null,null,null,null,null,"IRR (Internal Rate of Return)"]

{"sheet":"Using VBA","index":2,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9]]}
[]
[null,"Using VBA",null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Year","Cash Flow",null,null,null,null,null,"Year","Cash Flow"]
[null,0,-1000,null,null,null,null,null,0,-1000]
[null,1,200,null,null,null,null,null,1,200]
[null,2,500,null,null,null,null,null,2,500]
[null,3,200,null,null,null,null,null,3,200]
[null,4,150,null,null,null,null,null,4,150]
[null,5,500,null,null,null,null,null,5,500]
[]
[null,"IRR (Internal Rate of Return)",0.1571494141267045,null,null,null,null,null,"IRR (Internal Rate of Return)"]

{"sheet":"Manually Calculating","index":3,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3],[10,1,10,2],[1,8,1,10],[10,8,10,9]]}
[]
[null,"Manually Calculating",null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Year","Cash Flow ","Present Value",null,null,null,null,"Year","Cash Flow ","Present Value"]
[null,0,-1000,null,null,null,null,null,0,-1000]
[null,1,200,{"$f":"C6/(1+$C$13)^B6","v":172.41379310344828},null,null,null,null,1,200,{"$f":"J6/(1+$C$13)^I6","v":172.41379310344828}]
[null,2,500,{"$f":"C7/(1+$C$13)^B7","v":371.58145065398338},null,null,null,null,2,500,{"$f":"J7/(1+$C$13)^I7","v":371.58145065398338}]
[null,3,200,128.13153470827012,null,null,null,null,3,200,{"$f":"J8/(1+$C$13)^I8","v":128.13153470827012}]
[null,4,150,82.843664682071207,null,null,null,null,4,150,{"$f":"J9/(1+$C$13)^I9","v":82.843664682071207}]
[null,5,500,238.05650770710119,null,null,null,null,5,500,{"$f":"J10/(1+$C$13)^I10","v":238.05650770710119}]
[null,"Sum of Present Values",null,{"$f":"SUM(D6:D10)","v":993.02695085487426},null,null,null,null,"Sum of Present Values",null,{"$f":"SUM(K6:K10)","v":993.02695085487426}]
[]
[null,"IRR(Internal Rate of Return)",0.16,null,null,null,null,null,"IRR(Internal Rate of Return)"]

{"sheet":"Applying Goal Seek Feature","index":4,"n_rows":13,"n_cols":10,"rows_kept":13,"cut":false,"hidden":false,"merged":[[10,1,10,2],[1,1,1,3],[1,7,1,9],[10,7,10,8]]}
[]
[null,"Applying Goal Seek Feature",null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Year","Cash Flow","Present Value",null,null,null,"Year","Cash Flow","Present Value"]
[null,0,-1000,null,null,null,null,0,-1000]
[null,1,200,{"$f":"C6/(1+$C$13)^B6","v":172.83852679818119},null,null,null,1,200,{"$f":"I6/(1+$C$13)^H6","v":172.83852679818119}]
[null,2,500,{"$f":"C7/(1+$C$13)^B7","v":373.41445432206996},null,null,null,2,500,{"$f":"I7/(1+$C$13)^H7","v":373.41445432206996}]
[null,3,200,{"$f":"C8/(1+$C$13)^B8","v":129.08080834034661},null,null,null,3,200,{"$f":"I8/(1+$C$13)^H8","v":129.08080834034661}]
[null,4,150,{"$f":"C9/(1+$C$13)^B9","v":83.663012817989568},null,null,null,4,150,{"$f":"I9/(1+$C$13)^H9","v":83.663012817989568}]
[null,5,500,{"$f":"C10/(1+$C$13)^B10","v":241.00319804931112},null,null,null,5,500,{"$f":"I10/(1+$C$13)^H10","v":241.00319804931112}]
[null,"Sum of Present Values",null,{"$f":"SUM(D6:D10)","v":1000.0000003278985},null,null,null,"Sum of Present Values",null,{"$f":"SUM(J6:J10)","v":1000.0000003278985}]
[]
[null,"IRR (Internal Rate of Return)",0.15714941399341201,null,null,null,null,"IRR (Internal Rate of Return)"]

{"sheet":"Using XIRR Function","index":5,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,7,1,8]]}
[]
[null,"Using XIRR Function for Uneven Cash Flow",null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Date","Net Cash Flow",null,null,null,null,"Date","Net Cash Flow"]
[null,"2017-12-31",-200000,null,null,null,null,"2017-12-31",-200000]
[null,"2018-07-30",-9000,null,null,null,null,"2018-07-30",-9000]
[null,"2018-08-12",-9000,null,null,null,null,"2018-08-12",-9000]
[null,"2019-05-26",7500,null,null,null,null,"2019-05-26",7500]
[null,"2019-12-27",19000,null,null,null,null,"2019-12-27",19000]
[null,"2020-11-07",22000,null,null,null,null,"2020-11-07",22000]
[null,"2020-12-18",24000,null,null,null,null,"2020-12-18",24000]
[null,"2021-12-15",25000,null,null,null,null,"2021-12-15",25000]
[null,"2022-02-13",26000,null,null,null,null,"2022-02-13",26000]
[null,"2022-08-02",26000,null,null,null,null,"2022-08-02",26000]
[null,"2022-11-22",60000,null,null,null,null,"2022-11-22",60000]
[null,"2024-03-23",26000,null,null,null,null,"2024-03-23",26000]
[null,"2024-06-10",26000,null,null,null,null,"2024-06-10",26000]
[]
[null,"IRR (Internal Rate of Return)",{"$f":"XIRR(C5:C17,B5:B17)","v":4.3885859847068776E-2},null,null,null,null,"IRR (Internal Rate of Return)"]

{"sheet":"Monthly Cash Flow","index":6,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,3],[18,1,19,1],[1,8,1,10],[18,8,19,8]]}
[]
[null,"Calculating IRR for Monthly Cash Flow",null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,null,"Date","Net Cash Flow",null,null,null,null,null,"Date","Net Cash Flow"]
[null,"Initial investment","2017-12-31",-200000,null,null,null,null,"Initial investment","2017-12-31",-200000]
[null,"Month 1","2018-01-31",-9000,null,null,null,null,"Month 1","2018-01-31",-9000]
[null,"Month 2","2018-02-28",-9000,null,null,null,null,"Month 2","2018-02-28",-9000]
[null,"Month 3","2018-03-31",7500,null,null,null,null,"Month 3","2018-03-31",7500]
[null,"Month 4","2018-04-30",19000,null,null,null,null,"Month 4","2018-04-30",19000]
[null,"Month 5","2018-05-31",22000,null,null,null,null,"Month 5","2018-05-31",22000]
[null,"Month 6","2018-06-30",24000,null,null,null,null,"Month 6","2018-06-30",24000]
[null,"Month 7","2018-07-31",25000,null,null,null,null,"Month 7","2018-07-31",25000]
[null,"Month 8","2018-08-31",26000,null,null,null,null,"Month 8","2018-08-31",26000]
[null,"Month 9","2018-09-30",26000,null,null,null,null,"Month 9","2018-09-30",26000]
[null,"Month 10","2018-10-31",26000,null,null,null,null,"Month 10","2018-10-31",26000]
[null,"Month 11","2018-11-30",26000,null,null,null,null,"Month 11","2018-11-30",26000]
[null,"Month 12","2018-12-31",26000,null,null,null,null,"Month 12","2018-12-31",26000]
[]
[null,"IRR (Internal Rate of Return)","IRR",{"$f":"IRR(D5:D17)*12","v":6.504448222759418E-2},null,null,null,null,"IRR (Internal Rate of Return)","IRR"]
[null,null,"XIRR",{"$f":"XIRR(D5:D17,C5:C17)","v":6.7224696278572096E-2},null,null,null,null,null,"XIRR"]

{"sheet":"Using MIRR Function","index":7,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,8,1,9],[11,3,11,5],[12,3,12,5]]}
[]
[null,"Using MIRR Function",null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,"Period","Cash Flow",null,null,null,null,null,"Period","Cash Flow"]
[null,0,-5000,null,null,null,null,null,0,-5000]
[null,1,700,null,null,null,null,null,1,700]
[null,2,900,null,null,null,null,null,2,900]
[null,3,1600,null,null,null,null,null,3,1600]
[null,4,1500,null,null,null,null,null,4,1500]
[null,5,700,null,null,null,null,null,5,700]
[]
[null,"Finance rate",0.12,"<-- You took a bank loan to invest 5000 at this rate",null,null,null,null,"Finance rate"]
[null,"Reinvestment rate",0.2,"<-- You're reinveting your money with a new project at this rate",null,null,null,null,"Reinvestment rate"]
[]
[null,"MIRR",{"$f":"MIRR(C5:C10,C12,C13)","v":9.3312247079064603E-2},null,null,null,null,null,"MIRR"]

{"sheet":"Calculating IRR for Real Estate","index":8,"n_rows":10,"n_cols":18,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,7],[1,11,1,17]]}
[]
[null,"Calculating IRR for Real Estate",null,null,null,null,null,null,null,null,null,"Do It YourSelf"]
[]
[null,null,"Initial Investment","Year 1","Year 2","Year 3","Year 4","Year 5",null,null,null,null,"Initial Investment","Year 1","Year 2","Year 3","Year 4","Year 5"]
[null,null,-200000,null,null,null,null,null,null,null,null,null,-200000]
[null,"Rental Cash Flow",null,14000,15200,15500,16000,16800,null,null,null,"Rental Cash Flow",null,14000,15200,15500,16000,16800]
[null,"Resale Proceeds",null,null,null,null,null,350000,null,null,null,"Resale Proceeds",null,null,null,null,null,350000]
[null,"Total Cash Flow",{"$f":"SUM(C5:C7)","v":-200000},{"$f":"SUM(D5:D7)","v":14000},15200,15500,16000,366800,null,null,null,"Total Cash Flow"]
[]
[null,"IRR",{"$f":"IRR(C8:H8)","v":0.18105401431541757},null,null,null,null,null,null,null,null,"IRR"]

{"sheet":"IRR Compared","index":9,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[3,1,3,2],[3,4,3,5],[1,1,1,5]]}
[]
[null,"Comparing IRR"]
[]
[null,"Project A",null,null,"Project B"]
[null,"Initial Investment",-5000,null,"Initial Investment",-2000]
[null,"Year 1",700,null,"Year 1",400]
[null,"Year 2",900,null,"Year 2",700]
[null,"Year 3",1600,null,"Year 3",500]
[null,"Year 4",1500,null,"Year 4",400]
[null,"Year 5",700,null,"Year 5",300]
[]
[null,"IRR (A)",{"$f":"IRR(C5:C10)","v":2.5196175200568494E-2},null,"IRR( B)",{"$f":"IRR(F5:F10)","v":5.2314494813118229E-2}]