{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Input Data","Report"],"not_rendered":{"charts":2,"images":4,"macros":1,"external_links":0,"defined_names":22,"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":26,"n_cols":2,"rows_kept":26,"cut":false,"hidden":false,"merged":[[23,0,25,0],[0,0,0,2],[1,1,1,2],[2,0,4,0],[5,0,22,0]]}
["Investment Return Analyzer - Instructions"]
["Item","Description"]
["1) Introduction","The \"Investment Return Analyzer\" tool allows evaluating the profitability of projects through cash flow analysis. The tool consists of:"]
[null,"- A main sheet called \"Input Data,\" where the project's parameters are entered."]
[null,"- Additional temporary sheets generated for each analyzed project."]
["2) Operation","2.1. Enter project data in the \"Input Data\" sheet. The following fields must be completed:"]
[null,"1. Project Name."]
[null,"2. Number of periods to analyze (number of years or months of the analysis)."]
[null,"3. Discount rate (for the Net Present Value calculation)."]
[null,"2.2. Subsequently, enter expenses and revenues, considering:"]
[null,"- Based on the entered \"Number of Periods,\" a table will be generated with the same number of rows."]
[null,"- In this table, the user will be able to enter the revenue and expense values corresponding to each period."]
[null,"- Note: The cash flow will be calculated automatically by subtracting expenses from revenues."]
[null,"2.3. Report Generation"]
[null,"When pressing the \"Generate Report\" button, a new sheet will be created with a detailed analysis of the project, including:"]
[null,"2.3.1. Financial indicators:"]
[null,"- Net Present Value (NPV): The present value of a project's cash flows minus the initial investment. If positive, the project is profitable."]
[null,"- Internal Rate of Return (IRR): The rate of return that makes the NPV zero. If it is higher than the cost of capital, the project is viable."]
[null,"- Return on Investment (ROI): The percentage of profit relative to the initial investment. It is used to measure profitability."]
[null,"- Payback: The time it takes to recover the initial investment with the generated cash flows."]
[null,"2.3.2. Visualization of the results"]
[null,"- Two (2) charts with key indicators."]
[null,"- Two (2) tables with a detailed breakdown of the calculations."]
["3) Additional Notes","- Make sure to enable macros in Excel for the tool to function properly."]
[null,"- The sheet generated with the calculations is temporary and can be deleted when analyzing a new project."]
[null,"- If you need help, contact technical support."]

{"sheet":"Input Data","index":1,"n_rows":24,"n_cols":15,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,1,23,3],[23,5,23,7],[23,9,23,11],[23,13,23,15],[21,1,21,3],[21,5,21,7],[21,9,21,11],[21,13,21,15],[22,1,22,3],[22,5,22,7],[22,9,22,11],[22,13,22,15],[19,1,19,3],[19,5,19,7],[19,9,19,11],[19,13,19,15],[20,1,20,3],[20,5,20,7],[20,9,20,11],[20,13,20,15],[17,1,17,3],[17,5,17,7],[17,9,17,11],[17,13,17,15],[18,1,18,3],[18,5,18,7],[18,9,18,11],[18,13,18,15],[15,1,15,3],[15,5,15,7],[15,9,15,11],[15,13,15,15],[16,1,16,3],[16,5,16,7],[16,9,16,11],[16,13,16,15],[13,1,13,3],[13,5,13,7],[13,9,13,11],[13,13,13,15],[14,1,14,3],[14,5,14,7],[14,9,14,11],[14,13,14,15],[12,5,12,7],[12,9,12,11],[12,13,12,15],[0,14,0,15],[9,1,9,3],[4,4,4,11],[6,4,6,11],[8,1,8,3],[8,5,8,7],[8,9,8,11],[8,13,8,15],[0,1,0,13],[2,1,2,3],[4,1,4,3],[6,1,6,3],[2,4,2,11],[9,9,9,11],[9,5,9,7],[9,13,9,15],[24,13,24,15],[24,1,24,3],[24,5,24,7],[24,9,24,11],[10,1,10,3],[10,5,10,7],[10,9,10,11],[10,13,10,15],[11,1,11,3],[11,5,11,7],[11,9,11,11],[11,13,11,15],[12,1,12,3]]}
[null,"Investment Return Analyzer",null,null,null,null,null,null,null,null,null,null,null,null,"smartcodebuilders.com"]
[]
[null,"Project Name:",null,null,"Test Project N° 1"]
[]
[null,"Number of Periods:",null,null,15]
[]
[null,"Discount Rate:",null,null,0.3]
[]
[null,"Periods",null,null,null,"Outflows",null,null,null,"Revenue",null,null,null,"Cash Flow"]
[null,0,null,null,null,2560,null,null,null,null,null,null,null,{"$f":"+J10-F10","v":-2560}]
[null,1,null,null,null,null,null,null,null,2000,null,null,null,2000]
[null,2,null,null,null,null,null,null,null,2100,null,null,null,2100]
[null,3,null,null,null,null,null,null,null,2000,null,null,null,2000]
[null,4,null,null,null,null,null,null,null,1900,null,null,null,1900]
[null,5,null,null,null,null,null,null,null,2500,null,null,null,2500]
[null,6,null,null,null,null,null,null,null,2650,null,null,null,2650]
[null,7,null,null,null,null,null,null,null,2450,null,null,null,2450]
[null,8,null,null,null,null,null,null,null,2000,null,null,null,2000]
[null,9,null,null,null,null,null,null,null,2350,null,null,null,2350]
[null,10,null,null,null,null,null,null,null,2600,null,null,null,2600]
[null,11,null,null,null,null,null,null,null,2450,null,null,null,2450]
[null,12,null,null,null,null,null,null,null,2100,null,null,null,2100]
[null,13,null,null,null,null,null,null,null,2500,null,null,null,2500]
[null,14,null,null,null,null,null,null,null,2500,null,null,null,2500]

{"sheet":"Report","index":2,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":true,"merged":[[45,2,45,4],[46,2,46,4],[40,2,40,4],[41,2,41,4],[42,2,42,4],[43,2,43,4],[44,2,44,4],[35,2,35,4],[36,2,36,4],[37,2,37,4],[38,2,38,4],[39,2,39,4],[34,10,34,11],[34,8,34,9],[33,8,33,9],[31,2,31,4],[32,2,32,4],[33,2,33,4],[32,10,32,11],[33,10,33,11],[31,10,31,11],[31,8,31,9],[32,8,32,9],[34,2,34,4],[0,11,0,12],[2,1,2,3],[2,4,2,9],[4,1,4,3],[4,4,4,9],[10,4,10,9],[12,4,12,9],[14,4,14,9],[14,1,14,3],[12,1,12,3],[10,1,10,3],[6,1,6,3],[6,4,6,9],[0,1,0,10],[8,1,8,3],[8,4,8,9]]}
[null,"Report Test Project N° 23",null,null,null,null,null,null,null,null,null,"smartcodebuilders.com"]
[]
[null,"Project Name:",null,null,"Test Project N° 23"]
[]
[null,"Number of Periods:",null,null,15]
[]
[null,"Discount Rate:",null,null,0.3]
[]
[null,"Net Present Value (NPV):",null,null,{"$f":"NPV(30%,'Input Data'!N10:N24)","v":3413.6065300200676}]
[]
[null,"Internal Rate of Return (IRR):",null,null,{"$f":"IRR('Input Data'!N10:N24)","v":0.805514152568366}]
[]
[null,"Return On Investment (ROI):",null,null,{"$f":"SUM('Input Data'!N10:N24)/'Input Data'!F10","v":11.5390625}]
[]
[null,"Payback:",null,null,{"$f":"INDEX(B33:B47, MATCH(TRUE, (C33:C47>0), 0) - 1) + ABS(INDEX(C33:C47, MATCH(TRUE, (C33:C47>0), 0) - 1) / (INDEX(C33:C47, MATCH(TRUE, (C33:C47>0), 0)) - INDEX(C33:C47, MATCH(TRUE, (C33:C47>0), 0) - 1)))","v":1.2666666666666666}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Period","Cumulative Cash Flow",null,null,null,null,null,"Concept",null,"Amount"]
[null,0,{"$f":"+'Input Data'!N10","v":-2560},null,null,null,null,null,"Total Revenue",null,{"$f":"SUM('Input Data'!J10:J24)","v":32100}]
[null,1,{"$f":"+C33+ 'Input Data'!N11","v":-560},null,null,null,null,null,"Total Expenses",null,{"$f":"SUM('Input Data'!F10:F24)","v":2560}]
[null,2,{"$f":"+C34+ 'Input Data'!N12","v":1540},null,null,null,null,null,"Net Profit",null,{"$f":"+Report_TotalRevenue-Report_TotalCosts","v":29540}]
[null,3,{"$f":"+C35+ 'Input Data'!N13","v":3540}]
[null,4,{"$f":"+C36+ 'Input Data'!N14","v":5440}]
[null,5,{"$f":"+C37+ 'Input Data'!N15","v":7940}]
[null,6,{"$f":"+C38+ 'Input Data'!N16","v":10590}]
[null,7,{"$f":"+C39+ 'Input Data'!N17","v":13040}]
[null,8,{"$f":"+C40+ 'Input Data'!N18","v":15040}]
[null,9,{"$f":"+C41+ 'Input Data'!N19","v":17390}]
[null,10,{"$f":"+C42+ 'Input Data'!N20","v":19990}]
[null,11,{"$f":"+C43+ 'Input Data'!N21","v":22440}]
[null,12,{"$f":"+C44+ 'Input Data'!N22","v":24540}]
[null,13,{"$f":"+C45+ 'Input Data'!N23","v":27040}]
[null,14,{"$f":"+C46+ 'Input Data'!N24","v":29540}]