{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["CAPBUDG.XLT"],"not_rendered":{"external_links":1,"defined_names":6},"read":"whole","date_system":"1904","formulas":"cached_only"}

{"sheet":"CAPBUDG.XLT","index":0,"n_rows":50,"n_cols":77,"rows_kept":50,"flags":["formulas_cached_only"]}
["Capital Budgeting Investment Analysis",{"$nulls":7},"Net Cash Flow Calculation",null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,{"$nulls":10},"MACRS Table",{"$nulls":7},"MACRS Straight Line (27.5)",{"$nulls":6},"MACRS Straight Line (39)"]
[{"$nulls":8},"Cash Inflows",null,"Growth Rate",{"$nulls":45},"Recovery Year",{"$nulls":7},"Month of First",{"$nulls":6},"Month of First"]
["Information on Old Asset",{"$nulls":8},"Revenues with Project",{"v":0,"d":"0.00%"},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":11},3,5,7,10,15,20,null,"Year the Property",null,"Recovery Years",{"$nulls":4},"Year the Property",null,"Recovery Years"]
["Original Installed Cost of Asset",{"$nulls":5},{"v":0,"d":"$0"},null,null,"Revenues without Project",{"v":0,"d":"0.00%"},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},1,{"v":0.3333,"d":"33.33%"},{"v":0.2,"d":"20.00%"},{"v":0.1429,"d":"14.29%"},{"v":0.1,"d":"10.00%"},{"v":0.05,"d":"5.00%"},{"v":0.0375,"d":"3.750%"},null,"Is Placed in Service",null,1,2,28,29,30,"Is Placed in Service",null,1,2,40,41]
["Net Working Capital Required for Asset",{"$nulls":5},{"v":0,"d":"$0"},null,null,"Incremental Revenue",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},2,{"v":0.4445,"d":"44.45%"},{"v":0.32,"d":"32.00%"},{"v":0.2449,"d":"24.49%"},{"v":0.18,"d":"18.00%"},{"v":0.095,"d":"9.50%"},{"v":0.07219,"d":"7.219%"},null,null,1,{"v":0.0348,"d":"3.48%"},{"v":0.0364,"d":"3.64%"},{"v":0.0188,"d":"1.88%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,1,{"v":0.024572649572649572,"d":"2.46%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.0010683760683760646,"d":"0.11%"},{"v":0,"d":"0.00%"}]
["Investment Tax Credit At",{"$nulls":3},{"v":0,"d":"0.00%"},null,{"v":0,"d":"$0"},null,"Cash Outflows",null,"Growth Rate",{"$nulls":45},3,{"v":0.1481,"d":"14.81%"},{"v":0.192,"d":"19.20%"},{"v":0.1749,"d":"17.49%"},{"v":0.144,"d":"14.40%"},{"v":0.0855,"d":"8.55%"},{"v":0.06677,"d":"6.677%"},null,null,2,{"v":0.0318,"d":"3.18%"},{"v":0.0364,"d":"3.64%"},{"v":0.0218,"d":"2.18%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,2,{"v":0.022435897435897436,"d":"2.24%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.0032051282051281937,"d":"0.32%"},{"v":0,"d":"0.00%"}]
["Economic Life of Asset",{"$nulls":5},0,null,null,"Costs with Project",{"v":0,"d":"0.00%"},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},4,{"v":0.0741,"d":"7.41%"},{"v":0.1152,"d":"11.52%"},{"v":0.1249,"d":"12.49%"},{"v":0.1152,"d":"11.52%"},{"v":0.077,"d":"7.70%"},{"v":0.06177,"d":"6.177%"},null,null,3,{"v":0.0288,"d":"2.88%"},{"v":0.0364,"d":"3.64%"},{"v":0.0248,"d":"2.48%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,3,{"v":0.0202991452991453,"d":"2.03%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.005341880341880323,"d":"0.53%"},{"v":0,"d":"0.00%"}]
["Years Depreciated",{"$nulls":5},0,null,null,"Cost without Project",{"v":0,"d":"0.00%"},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},5,null,{"v":0.1152,"d":"11.52%"},{"v":0.0893,"d":"8.93%"},{"v":0.0922,"d":"9.22%"},{"v":0.0693,"d":"6.93%"},{"v":0.05713,"d":"5.713%"},null,null,4,{"v":0.0258,"d":"2.58%"},{"v":0.0364,"d":"3.64%"},{"v":0.0278,"d":"2.78%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,4,{"v":0.018162393162393164,"d":"1.82%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.007478632478632452,"d":"0.75%"},{"v":0,"d":"0.00%"}]
["Straight-Line Depreciation (Otherwise Enter Each Year Individually)",{"$nulls":5},{"$error":"#DIV/0!"},null,null,"Incremental Cost",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},6,null,{"v":0.0576,"d":"5.76%"},{"v":0.0892,"d":"8.92%"},{"v":0.0737,"d":"7.37%"},{"v":0.0623,"d":"6.23%"},{"v":0.05285,"d":"5.285%"},null,null,5,{"v":0.0227,"d":"2.27%"},{"v":0.0364,"d":"3.64%"},{"v":0.0309,"d":"3.09%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,5,{"v":0.016025641025641024,"d":"1.60%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.009615384615384581,"d":"0.96%"},{"v":0,"d":"0.00%"}]
["Accumulated Depreciation",{"$nulls":5},{"v":0,"d":"$0"},null,"Depreciation",{"$nulls":47},7,null,null,{"v":0.0893,"d":"8.93%"},{"v":0.0655,"d":"6.55%"},{"v":0.059,"d":"5.90%"},{"v":0.04888,"d":"4.888%"},null,null,6,{"v":0.0197,"d":"1.97%"},{"v":0.0364,"d":"3.64%"},{"v":0.0339,"d":"3.39%"},{"v":0,"d":"0.00%"},{"v":0,"d":"0.00%"},null,6,{"v":0.013888888888888888,"d":"1.39%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.011752136752136821,"d":"1.18%"},{"v":0,"d":"0.00%"}]
["Book Value",{"$nulls":5},{"v":0,"d":"$0"},null,null,"Depreciation on Building",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},8,null,null,{"v":0.0446,"d":"4.46%"},{"v":0.0655,"d":"6.55%"},{"v":0.059,"d":"5.90%"},{"v":0.04522,"d":"4.522%"},null,null,7,{"v":0.0167,"d":"1.67%"},{"v":0.0364,"d":"3.64%"},{"v":0.0364,"d":"3.64%"},{"v":0.0005,"d":"0.05%"},{"v":0,"d":"0.00%"},null,7,{"v":0.011752136752136752,"d":"1.18%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.01388888888888895,"d":"1.39%"},{"v":0,"d":"0.00%"}]
["Proceeds from Sale of Old Asset",{"$nulls":5},{"v":0,"d":"$0"},null,null,"Depreciation with Project",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},9,{"$nulls":3},{"v":0.0656,"d":"6.56%"},{"v":0.0591,"d":"5.91%"},{"v":0.04462,"d":"4.462%"},null,null,8,{"v":0.0136,"d":"1.36%"},{"v":0.0364,"d":"3.64%"},{"v":0.0364,"d":"3.64%"},{"v":0.0036,"d":"0.36%"},{"v":0,"d":"0.00%"},null,8,{"v":0.009615384615384616,"d":"0.96%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.01602564102564108,"d":"1.60%"},{"v":0,"d":"0.00%"}]
["Tax Effects",{"$nulls":8},"Depreciation without Project",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},10,{"$nulls":3},{"v":0.0655,"d":"6.55%"},{"v":0.059,"d":"5.90%"},{"v":0.04461,"d":"4.461%"},null,null,9,{"v":0.0106,"d":"1.06%"},{"v":0.0364,"d":"3.64%"},{"v":0.0364,"d":"3.64%"},{"v":0.0066,"d":"0.66%"},{"v":0,"d":"0.00%"},null,9,{"v":0.007478632478632479,"d":"0.75%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.01816239316239321,"d":"1.82%"},{"v":0,"d":"0.00%"}]
[null,"Capital Gains Tax Rate",{"$nulls":3},{"v":0,"d":"0.00%"},{"$nulls":3},"Incremental Depreciation",null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},11,{"$nulls":3},{"v":0.0328,"d":"3.28%"},{"v":0.0591,"d":"5.91%"},{"v":0.04462,"d":"4.462%"},null,null,10,{"v":0.0076,"d":"0.76%"},{"v":0.0364,"d":"3.64%"},{"v":0.0364,"d":"3.64%"},{"v":0.0096,"d":"0.96%"},{"v":0,"d":"0.00%"},null,10,{"v":0.005341880341880342,"d":"0.53%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.020299145299145338,"d":"2.03%"},{"v":0,"d":"0.00%"}]
[null,"Marginal Tax Rate",{"$nulls":3},{"v":0,"d":"0.00%"},null,null,"Incremental Earnings Before Taxes",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},12,{"$nulls":4},{"v":0.059,"d":"5.90%"},{"v":0.04461,"d":"4.461%"},null,null,11,{"v":0.0045,"d":"0.45%"},{"v":0.0364,"d":"3.64%"},{"v":0.0364,"d":"3.64%"},{"v":0.0127,"d":"1.27%"},{"v":0,"d":"0.00%"},null,11,{"v":0.003205128205128205,"d":"0.32%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.022435897435897467,"d":"2.24%"},{"v":0,"d":"0.00%"}]
["Tax on Sale of the Old Asset",{"$nulls":5},{"v":0,"d":"$0"},null,"Taxes",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},13,{"$nulls":4},{"v":0.0591,"d":"5.91%"},{"v":0.04462,"d":"4.462%"},null,null,12,{"v":0.0015,"d":"0.15%"},{"v":0.0364,"d":"3.64%"},{"v":0.0364,"d":"3.64%"},{"v":0.0157,"d":"1.57%"},{"v":0,"d":"0.00%"},null,12,{"v":0.0010683760683760683,"d":"0.11%"},{"v":0.02564102564102564,"d":"2.56%"},{"v":0.024572649572649596,"d":"2.46%"},{"v":0,"d":"0.00%"}]
["Recapture of ITC",{"$nulls":5},{"v":0,"d":"$0"},null,"Recapture of Asset Salvage Value",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},14,{"$nulls":4},{"v":0.059,"d":"5.90%"},{"v":0.04461,"d":"4.461%"}]
[{"$nulls":8},"Recapture of Working Capital",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},15,{"$nulls":4},{"v":0.0591,"d":"5.91%"},{"v":0.04462,"d":"4.462%"}]
["Information on New Asset",{"$nulls":7},"Recapture of Land Salvage Value",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},16,{"$nulls":4},{"v":0.0295,"d":"2.95%"},{"v":0.04461,"d":"4.461%"}]
["Cost of New Asset",{"$nulls":5},{"v":0,"d":"$0"},null,"Recapture of Building Salvage Value",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},17,{"$nulls":5},{"v":0.04462,"d":"4.462%"}]
["Delivery and Installation",{"$nulls":5},{"v":0,"d":"$0"},null,"Additional Investment in Working Capital",null,null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"$nulls":10},18,{"$nulls":5},{"v":0.04461,"d":"4.461%"}]
["Net Working Capital Required for Asset",{"$nulls":5},{"v":0,"d":"$0"},{"$nulls":49},19,{"$nulls":5},{"v":0.04462,"d":"4.462%"}]
["Investment Tax Credit %",{"$nulls":5},{"v":0,"d":"0.00%"},null,"Net Cash Flow",null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"$nulls":10},20,{"$nulls":5},{"v":0.04461,"d":"4.461%"}]
["Depreciable Class of Asset (Under MACRS)",{"$nulls":5},0,{"$nulls":49},21,{"$nulls":5},{"v":0.02231,"d":"2.231%"}]
[null,"Class","Enter",{"$nulls":5},"Summary Information",{"$nulls":47},22]
[null,"3-Year",2,{"$nulls":5},"Discount Rate",null,null,{"v":0,"d":"0.00%"},{"$nulls":44},23]
[null,"5-Year",3,{"$nulls":5},"Initial Guess for IRR",null,null,{"v":0,"d":"0.00%"},{"$nulls":44},24]
[null,"7-Year",4,{"$nulls":5},"Net Present Value",null,null,{"v":0,"d":"$0"},{"$nulls":44},25]
[null,"10-Year",5,{"$nulls":5},"IRR",null,null,{"$error":"#NUM!"},{"$nulls":44},26]
[null,"15-Year",6,{"$nulls":5},"Profitability Index",null,null,{"$error":"#DIV/0!"},{"$nulls":44},27]
[null,"20-Year",7,{"$nulls":5},"Payback (Years)",null,null,36,{"$nulls":44},28]
["Economic Life of New Asset",{"$nulls":5},0,{"$nulls":49},29]
[null,"For MACRS Enter Class Life + One Year",{"$nulls":6},"Reinvestment Rate",null,null,{"v":0,"d":"0.00%"},{"$nulls":44},30]
[null,"For Straight-Line Enter Years of Depreciation",{"$nulls":6},"Gross Terminal Value of Cash Flows",null,null,{"v":0,"d":"$0"},{"$nulls":44},31]
["Salvage Value of New Asset",{"$nulls":5},{"v":0,"d":"$0"},null,"Adjusted Net Present Value",null,null,{"v":0,"d":"$0"},{"$nulls":44},32]
["Depreciation Method",{"$nulls":5},0,null,"Adjusted Internal Rate of Return",{"$nulls":47},33]
[null,"(1) - Straight-Line",{"$nulls":54},34]
[null,"(2) - MACRS",{"$nulls":6},"Equivalent Annual Annuity",null,null,{"$error":"#DIV/0!"},{"$nulls":44},35]
["Information on Real Property",{"$nulls":7},"Net Present Value (Infinite Chain)",null,null,{"$error":"#DIV/0!"}]
["Original Cost of Land",{"$nulls":5},{"v":0,"d":"$0"}]
["Estimated Value at End of Project",{"$nulls":5},{"v":0,"d":"$0"},null,"Certainty Equivalent Net Present Value",null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35]
["Cost of Building",{"$nulls":5},{"v":0,"d":"$0"}]
["Class of Property",null,null,"Enter",null,null,0,null,"Risk Free Rate",null,{"v":0,"d":"0.00%"}]
[null,"27.5 (Residential Rental Property)",null,1,{"$nulls":4},"Certainty Equivalent Factors",null,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"39 (Nonresidential Real Property)",null,2,{"$nulls":4},"Certainty Equivalent Cash Flows",null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Month Building Is Placed in Service (1-12)",{"$nulls":5},0]
["Estimated Value at End of Project",{"$nulls":5},{"v":0,"d":"$0"},null,"Certainty Net Present Value",null,null,{"v":0,"d":"$0"}]
["Net Investment",{"$nulls":5},{"v":0,"d":"$0"}]
[{"$nulls":8},"Cumulative Cash Flows",null,null,{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"},{"v":0,"d":"$0"}]
["Life of the Project",{"$nulls":5},0,{"$nulls":4},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36]