{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Template"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Template","index":0,"n_rows":15,"n_cols":10,"rows_kept":15,"merged":[[0,0,1,6],[6,0,6,6],[10,9,10,13],[11,9,11,13],[13,0,13,1],[14,0,14,1]]}
["Profitability Index Template"]
[]
[]
["Initial Investment Required ",{"v":-1000000,"d":"$(1,000,000.00)"}]
["Discount Rate",{"v":0.08,"d":"8.0%"}]
[]
["Project A "]
["Year",0,1,{"$f":"C8+1","v":2},{"$f":"D8+1","v":3},{"$f":"E8+1","v":4},{"$f":"F8+1","v":5}]
["Cash Outflows, Initial Investment",{"v":-1000000,"d":"$(1,000,000.00)"},"-","-","-","-","-"]
["Cash Inflows, Future Cash Flows","-",{"v":250000,"d":"$250,000.00"},{"v":300000,"d":"$300,000.00"},{"v":400000,"d":"$400,000.00"},{"v":300000,"d":"$300,000.00"},{"v":500000,"d":"$500,000.00"}]
["Discounted Value",null,{"$f":"C10*$B$5","v":{"v":20000,"d":"$20,000.00"}},{"$f":"D10*$B$5","v":{"v":24000,"d":"$24,000.00"}},{"$f":"E10*$B$5","v":{"v":32000,"d":"$32,000.00"}},{"$f":"F10*$B$5","v":{"v":24000,"d":"$24,000.00"}},{"$f":"G10*$B$5","v":{"v":40000,"d":"$40,000.00"}},null,null,"https://www.excelgraduate.com/"]
["Present Value of Future Cash Flows",{"$f":"B9","v":{"v":-1000000,"d":"$(1,000,000.00)"}},{"$f":"C10-C11","v":{"v":230000,"d":"$230,000.00"}},{"$f":"D10-D11","v":{"v":276000,"d":"$276,000.00"}},{"$f":"E10-E11","v":{"v":368000,"d":"$368,000.00"}},{"$f":"F10-F11","v":{"v":276000,"d":"$276,000.00"}},{"$f":"G10-G11","v":{"v":460000,"d":"$460,000.00"}},null,null,"© 2023 by Excelgraduate | All Rights Reserved."]
[]
["Present Value of Future Cash Flows (NPV) ",null,{"$f":"NPV(B5,C12:G12)+B4","v":{"v":257655.25206902507,"d":"$257,655.25"}}]
["Profitability Index",null,{"$f":"1+(C14/ABS(B4))","v":{"v":1.257655252069025,"d":"$1.26"}}]