{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Discounted Cash Flow Template"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"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":"Discounted Cash Flow Template","index":0,"n_rows":38,"n_cols":12,"rows_kept":38,"cut":false,"hidden":false,"merged":[[4,8,4,9],[4,10,5,10],[4,11,5,11],[1,1,1,3],[2,1,2,3],[1,6,1,7],[2,6,2,7],[1,9,1,10],[2,9,2,10],[4,1,5,1],[4,2,5,2],[4,4,4,5],[1,4,1,5],[2,4,2,5],[37,1,37,11]]}
[null,"DISCOUNTED CASH FLOW TEMPLATE",null,null,null,null,"Complete white fields only.  Shaded fields will calculate automatically.  "]
[null,"COMPANY NAME",null,null,"MANAGER NAME",null,"COMPLETED BY",null,"DATE COMPLETED","INITIAL INVESTMENT",null,0]
[null,null,null,null,null,null,null,null,null,"RATE OF DISCOUNT",null,0]
[]
[null,"YEAR NUMBER","YEAR DATE","INCOME","EXPENSES",null,"CASH OUTFLOW","NET CASH","DISCOUNTED CASH FLOW",null,"PRESENT VALUE","NET PRESENT VALUE"]
[null,null,null,"CASH INFLOW","FIXED","VARIABLE","FIXED + VARIABLE","INFLOW LESS OUTFLOW","PRESENT VALUE","CUMULATIVE PRESENT VALUE"]
[null,1,2018,null,null,null,{"$f":"E7+F7","v":0},{"$f":"D7-G7","v":0},{"$f":"H7/(1+RATE_OF_DISCOUNT)^B7","v":0},{"$f":"SUM(INDEX(I7:I36,1,1):I7)","v":0},{"$f":"J7-INITIAL_INVESTMENT","v":0},{"$f":"NPV(RATE_OF_DISCOUNT,-INITIAL_INVESTMENT,J7)","v":0}]
[null,{"$f":"B7+1","v":2},{"$f":"C7+1","v":2019},null,null,null,{"$f":"E8+F8","v":0},{"$f":"D8-G8","v":0},0,{"$f":"SUM(INDEX(I7:I36,1,1):I8)","v":0},0,0]
[null,{"$f":"B8+1","v":3},2020,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I9)","v":0},0,0]
[null,4,2021,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I10)","v":0},0,0]
[null,5,2022,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I11)","v":0},0,0]
[null,6,2023,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I12)","v":0},0,0]
[null,{"$f":"B12+1","v":7},{"$f":"C12+1","v":2024},null,null,null,{"$f":"E13+F13","v":0},{"$f":"D13-G13","v":0},0,{"$f":"SUM(INDEX(I7:I36,1,1):I13)","v":0},0,0]
[null,{"$f":"B13+1","v":8},{"$f":"C13+1","v":2025},null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I14)","v":0},0,0]
[null,9,2026,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I15)","v":0},0,0]
[null,10,2027,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I16)","v":0},0,0]
[null,11,2028,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I17)","v":0},0,0]
[null,{"$f":"B17+1","v":12},{"$f":"C17+1","v":2029},null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I18)","v":0},0,0]
[null,{"$f":"B18+1","v":13},{"$f":"C18+1","v":2030},null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I19)","v":0},0,0]
[null,14,2031,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I20)","v":0},0,0]
[null,15,2032,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I21)","v":0},0,0]
[null,16,2033,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I22)","v":0},0,0]
[null,{"$f":"B22+1","v":17},{"$f":"C22+1","v":2034},null,null,null,{"$f":"E23+F23","v":0},{"$f":"D23-G23","v":0},0,{"$f":"SUM(INDEX(I7:I36,1,1):I23)","v":0},0,0]
[null,{"$f":"B23+1","v":18},{"$f":"C23+1","v":2035},null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I24)","v":0},0,0]
[null,19,2036,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I25)","v":0},0,0]
[null,20,2037,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I26)","v":0},0,0]
[null,21,2038,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I27)","v":0},0,0]
[null,{"$f":"B27+1","v":22},{"$f":"C27+1","v":2039},null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I28)","v":0},0,0]
[null,{"$f":"B28+1","v":23},{"$f":"C28+1","v":2040},null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I29)","v":0},0,0]
[null,24,2041,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I30)","v":0},0,0]
[null,25,2042,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I31)","v":0},0,0]
[null,26,2043,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I32)","v":0},0,0]
[null,{"$f":"B32+1","v":27},{"$f":"C32+1","v":2044},null,null,null,{"$f":"E33+F33","v":0},{"$f":"D33-G33","v":0},0,{"$f":"SUM(INDEX(I7:I36,1,1):I33)","v":0},0,0]
[null,{"$f":"B33+1","v":28},{"$f":"C33+1","v":2045},null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I34)","v":0},0,0]
[null,29,2046,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I35)","v":0},0,0]
[null,30,2047,null,null,null,0,0,0,{"$f":"SUM(INDEX(I7:I36,1,1):I36)","v":0},0,0]
[]
[null,"CLICK HERE TO CREATE DISCOUNTED CASH FLOW TEMPLATES IN SMARTSHEET"]