{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Guide","Model"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Guide","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"merged":[[4,1,8,1]]}
[]
[null,"DISCOUNTED CASH FLOW"]
[]
[]
[null,"A dollar received today is better than a dollar received a year from now. This discounted cash flow workbook will allow  you to evaluate the present value of  future cash at your desired discounted rate.","Discounting rate is the level of return an investor desires from investments. The selection of discounting rate is the desired risk rate of return a person is willing to accept in order to receive given amount of cash at a future date for a dollar invested today. The determining of discount rate can be benchmarked with risk free rate plus inflation rate. Risk free rate is the treasury bills market rate which is referred as risk free rate because it is government back investment, the inflation is added to adjust the effect of eroding future purchase value of the dollar. An alternative in determining the selection discounting rate is applying the rate of return of similar alternative available projects."]
[]
[null,null,"Weighted cost of capital is widely used as the discounting rate. Discount cash flow adjust estimates the amount to be received from investments adjusted for the time value of money. The purpose is to analysis the attractiveness of investments using weighted cost of capital, weighted cost of capital is the average cost for the total capital of a company. Weighted average cost of capital is usually applied by companies."]
[]
[null,null,"The cash inflow cannot be evaluated for infinity and instead terminal values are used. This is because the infinity cash inflows are not easy to estimate. Although discounted cash inflow is a strong tool for evaluating projects, it suffers shortfalls of garbage in garbage out. A small change in cash flows can result into a distorted valuation of the project.     "]
[]
[null,null,"The discounted cash flow template allows the users to plug in cash in flow and select the desired discounting rate. For the purpose of evaluating business where the variable and fixed cost can be determined, the template allows the user to plug in fixed cost and variable cost. The template calculates the net inflow, discounts the inflows and calculates the total present value of cash flows from beginning to the last low of keyed in data. If there are no expenses identified and the valuation is for the regular cash flow, the user should enter the data on cash inflow column and the template will perform the calculation."]
[]
[null,null,"Discounted cash flows values the business worth today based on the value of the money it will generate in future. The analysis tries to generate what the business is worth today by discounting cash inflows at a required rate of return. Required rate of return is the rate of return a business owner expects to earn from investments. "]

{"sheet":"Model","index":1,"n_rows":37,"n_cols":10,"rows_kept":37,"merged":[[1,1,2,6],[1,7,1,8],[2,7,2,8],[5,2,5,3],[5,6,5,7]]}
[]
[null,"DISCOUNTED CASH FLOW",{"$nulls":5},"INITIAL OUTLAY/INVESTMENT",null,{"v":100,"d":"$100.00"}]
[{"$nulls":7},"DISCOUNT RATE",null,{"v":0.09,"d":"9%"}]
[null,"FOR BUSINESS VALUATION/INVESTMENT"]
[]
[null,"INCOME","EXPENSES",{"$nulls":3},"DISCOUNTED CASH FLOW"]
["Year","Cash Inflow","Fixed Cost","Variable Cost","Cash Outflow","Net Cash Inflow/Outflow","Present Value of Cash flow","Cumulative Present Value of Cash Inflow","Present Value","Net Present Value"]
[1,{"v":65000,"d":"$65,000.00"},{"v":50000,"d":"$50,000.00"},null,{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":50000,"d":"$50,000.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":15000,"d":"$15,000.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":13761.467889908256,"d":"$13,761.47"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":13761.467889908256,"d":"$13,761.47"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":13661.467889908256,"d":"$13,661.47"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":11491.009081649907,"d":"$11,491.01"}}]
[2,{"v":80500,"d":"$80,500.00"},{"v":50000,"d":"$50,000.00"},null,{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":50000,"d":"$50,000.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":30500,"d":"$30,500.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":25671.239794630077,"d":"$25,671.24"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":39432.707684538334,"d":"$39,432.71"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":39332.707684538334,"d":"$39,332.71"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":33097.9780191384,"d":"$33,097.98"}}]
[3,{"v":85750,"d":"$85,750.00"},{"v":50000,"d":"$50,000.00"},null,{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":50000,"d":"$50,000.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":35750,"d":"$35,750.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":27605.559412183044,"d":"$27,605.56"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":67038.26709672138,"d":"$67,038.27"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":66938.26709672138,"d":"$66,938.27"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":56333.02507930424,"d":"$56,333.03"}}]
[4,{"v":90000,"d":"$90,000.00"},{"v":55000,"d":"$55,000.00"},null,{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":55000,"d":"$55,000.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":35000,"d":"$35,000.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":24794.882387281876,"d":"$24,794.88"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":91833.14948400325,"d":"$91,833.15"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":91733.14948400325,"d":"$91,733.15"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":77202.38152007679,"d":"$77,202.38"}}]
[5,{"v":85000,"d":"$85,000.00"},{"v":65000,"d":"$65,000.00"},null,{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":65000,"d":"$65,000.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":20000,"d":"$20,000.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":12998.627725966906,"d":"$12,998.63"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":104831.77720997015,"d":"$104,831.78"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":104731.77720997015,"d":"$104,731.78"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":88143.06641694314,"d":"$88,143.07"}}]
[6,{"v":98500,"d":"$98,500.00"},{"v":70000,"d":"$70,000.00"},null,{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":70000,"d":"$70,000.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":28500,"d":"$28,500.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":16993.61881605765,"d":"$16,993.62"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":121825.3960260278,"d":"$121,825.40"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":121725.3960260278,"d":"$121,725.40"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":102446.25538761701,"d":"$102,446.26"}}]
[7,{"v":102500,"d":"$102,500.00"},{"v":70000,"d":"$70,000.00"},null,{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":70000,"d":"$70,000.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":32500,"d":"$32,500.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":17778.61295740781,"d":"$17,778.61"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[8,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[9,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[10,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[11,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[12,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[13,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[14,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[15,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[16,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[17,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[18,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[19,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[20,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[21,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[22,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[23,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[24,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[25,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[26,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[27,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[28,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[29,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]
[30,{"$nulls":3},{"$f":"(Table1[[#This Row],[Fixed Cost]]+Table1[[#This Row],[Variable Cost]])","v":{"v":0,"d":"$0.00"}},{"$f":"(Table1[[#This Row],[Cash Inflow]]-Table1[[#This Row],[Cash Outflow]])","v":{"v":0,"d":"$0.00"}},{"$f":"Table1[[#This Row],[Net Cash Inflow/Outflow]]/(1+DiscountRate)^Table1[[#This Row],[Year]]","v":{"v":0,"d":"$0.00"}},{"$f":"SUM(INDEX(Table1[Present Value of Cash flow],1,1):Table1[[#This Row],[Present Value of Cash flow]])","v":{"v":139604.0089834356,"d":"$139,604.01"}},{"$f":"(Table1[[#This Row],[Cumulative Present Value of Cash Inflow]]-InitialInvestment)","v":{"v":139504.0089834356,"d":"$139,504.01"}},{"$f":"NPV(DiscountRate,-InitialInvestment,Table1[[#This Row],[Cumulative Present Value of Cash Inflow]])","v":{"v":117410.1582218968,"d":"$117,410.16"}}]