{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Inputs","Cash-Flow","Long-Term Analysis","Long-Term with CF to Principal"],"not_rendered":{"charts":6,"images":5,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Inputs","index":0,"n_rows":84,"n_cols":23,"rows_kept":84,"cut":false,"hidden":false,"merged":[[68,0,68,1],[65,3,65,7],[52,0,52,1],[53,0,54,0],[53,1,54,1],[56,0,57,0],[56,1,57,1],[59,0,60,0],[59,1,60,1],[62,0,63,0],[62,1,63,1],[70,3,70,7],[23,2,24,8],[52,3,52,7],[69,3,69,7],[56,3,57,7],[59,3,60,7],[48,2,48,8],[38,3,41,7],[37,3,37,7],[46,2,46,8],[30,2,30,8],[0,0,0,8],[1,0,1,8],[9,1,9,8],[37,0,37,1],[25,2,28,7],[10,1,10,8],[11,1,11,8],[12,1,12,8],[6,0,7,8],[2,0,2,8],[4,0,4,8],[19,2,22,8],[15,2,16,8],[17,2,17,8],[13,1,13,8],[77,3,77,7],[83,0,88,8],[76,3,76,7],[71,3,71,7],[74,3,74,7],[75,3,75,7],[72,3,72,7],[73,3,73,7],[80,0,81,8],[9,9,10,22],[37,9,37,11],[38,9,38,11],[32,9,32,18],[33,12,34,12],[35,9,35,11],[36,9,36,11]]}
["Investment Property Analysis Sheet",null,null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,"Primary Residence",null,null,"Monthly Paid"]
["Provided by Joe Massey with Castle & Cooke Mortgage - Version 7.0",null,null,null,null,null,null,null,null,null,2,null,null,null,null,null,null,null,null,"Investment Property",null,null,"Upfront Single Paid"]
["Joe Massey: 303-809-7769 - Email: jmassey@castlecookemortgage.com - Website: www.LoansByJoeMassey.com \nNMLS: 7538 - CO: 10017422 - Regulated by the Division of Real Estate",null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,4]
["Your Castle Real Estate - 303-962-4272 - Website: www.YourCastle.com"]
[]
["Return on Investment Quadrant™  is a trademark of Real Estate Financial Planner LLC & James Orr - \nWebsite: https://RealEstateFinancialPlanner.com"]
[]
[]
["Instructions -->","1 - Click ENABLE CONTENT if you see the yellow warning at the top. \n2 - Work your way down this sheet inputting the appropriate information in to each YELLOW field"]
[null,"3 - Be sure to input the correct number of units for your subject property (SFR through Four-Plex) "]
["Latest Revision Date: ","4 - Please note that certain lines have comments to provide additional help for you"]
["January 6th, 2023","5 - Once the YELLOW fields are completed, you can view your results on the Cash-Flow Sheet and additional tabs"]
[null,"6 - For detailed video training and FAQs go to www.LoansByJoeMassey.com/investment-spreadsheet"]
[]
["Property Address","Sample Property",{"$f":"(IF($B$20<0.1999,\"Mortgage Insurance is based on best case scenario.  To calculate your estimated mortgage insurance, download the mortgage calculator app:\", \" \"))","v":" "}]
["Number of Units",2]
["Initial Occupancy Status","Primary Residence",{"$f":"(IF($B$20<0.1999,HYPERLINK(\"www.LoansByJoeMassey.com/mortgage-calculator\"), \"\"))","v":""}]
[]
["Down Payment Percentage",0.34463270000000001,{"$f":"IF(B18=\"Primary Residence\",(IF(AND(B17=2,B20<0.15),\"WARNING - Borrower may need more down payment!                              Minimum Down Payment on FHA Duplex is 3.5%                              Minimum Down Payment on Conventional Duplex is 15%\",IF(AND(B17>=3,B20<0.25),\"WARNING - Borrower needs more down payment!                              Minimum Down Payment on Multi-Unit is 25%.\",\" \"))),(IF(AND(B17=1,B20<0.15),\"WARNING - Borrower needs more down payment!                              Minimum Down Payment on SFR is 15%\",IF(AND(B17>=2,B20<0.25),\"WARNING - Borrower needs more down payment!                              Minimum Down Payment on Multi-Unit is 25%.\",\" \"))))","v":" "}]
[]
["Type of Mortgage Insurance ","Upfront Single Paid"]
[null,{"$f":"IF(B22=\"Monthly Paid\",0,1)","v":1}]
["Purchase Price",885000,{"$f":"IF(B29<75000, \"WARNING - Your borrower will need to pay cash for this property.  Minimum loan amount of $75,000\", \" \")","v":" "}]
["Acquisition Costs ",53360]
["Loan Costs",{"$f":"1690+IF(B18=\"Primary Residence\",0)*(IF(B20<0.1999,(B24*(1-B20)*0.02),(IF(B20<0.2499,(B24*(1-B20)*0.01),(B24*(1-B20)*0.0075)))))","v":1690},{"$f":"IF(AND(B17=1,B29>787750),\"WARNING - Borrower needs more down payment! Maximum Conventional Loan Amount on SFR is $787,750\", IF(AND(B17=2,B29>1008450),\"WARNING - Borrower needs more down payment! Maximum Conventional Loan Amount on Duplex is $1,008,450\", IF(AND(B17=3,B29>1219000),\"WARNING - Borrower needs more down payment! Maximum Conventional Loan Amount on Tri-Plex is $1,219,000\", IF(AND(B17=4,B29>1514950),\"WARNING - Borrower needs more down payment! Maximum Conventional Loan Amount on Four-Plex is $1,514,950\", \" \"))))","v":" "}]
["Upfront Mortgage Insurance ",0]
["Down Payment ",{"$f":"B20*B24","v":304999.93950000004}]
["Mortgage Balance",{"$f":"B24-B28","v":580000.06049999991}]
["Initial Investment",{"$f":"SUM(B25:B28)","v":360049.93950000004}]
["Seller Credits",null,{"$f":"IF(B18=\"Primary Residence\",IF(B31>(B24*0.03),\"Seller Concessions can not exceed 3% on a Primary Residence\",\" \"),IF(B31>(B24*0.02),\"Seller Concessions can not exceed 2% on an Investment Property\",\" \"))","v":" "}]
["Initial Repair Costs",-306690]
["Total Initial Investment",{"$f":"B30+B32-IF((B25+B26+B27)>B31,B31,(B25+B26+B27))","v":53359.939500000037}]
[]
["Mortgage Interest Rate",7.2499999999999995E-2]
["Mortgage Term (years) ",30]
["Mortgage Insurance ",{"$f":"IF(B22=\"Monthly Paid\",(IF(B20<0.1999,(B29*0.0043/12), 0)),0)","v":0},"HIDE BEFORE DISTRIBUTION"]
[{"$f":"IF(B18=\"Primary Residence\",\"MONTHLY Rental Income Per Unit AFTER you move out\", \"MONTHLY Rental Income Per Unit\")","v":"MONTHLY Rental Income Per Unit AFTER you move out"},null,null,"Notes regarding monthly rents"]
["Unit #1",2900]
["Unit #2",2900,{"$f":"IF(AND(B40>0,B17<2),\"This rent is not included in total because you do not have 2-unit selected above.\", \" \")","v":" "}]
["Unit #3",0,{"$f":"IF(AND(B41>0,B17<3),\"This rent is not included in total because you do not have 3-unit selected above.\", \" \")","v":" "}]
["Unit #4",0,{"$f":"IF(AND(B42>0,B17<4),\"This rent is not included in total because you do not have 4-unit selected above.\", \" \")","v":" "}]
["Total Rental Income",{"$f":"IF(B17=1, SUM(B39), IF(B17=2, SUM(B39:B40), IF(B17=3, SUM(B39:B41), IF(B17=4, SUM(B39:B42),\" \"))))","v":5800}]
[]
["Vacancy Factor",0.05]
[]
["Annual Rent Increase",0.04,{"$f":"IF(B47>0.05,\"REMINDER - The national average rent increase for the last 40 years is 5%\", \" \")","v":" "}]
[]
["Annual Appreciation Rate",0.05,{"$f":"IF(B49>0.06,\"REMINDER - The national average appreciation for the last 40 years is 6%\", \" \")","v":" "}]
[]
["Effective Tax Rate",0.32]
[]
["Monthly Operating Expenses",null,null,"Comments/Footnotes On Expenses"]
["Do you pay for property management? ","Yes",null,null,null,null,null,null,null,null,"Yes",null,"Hide before distribution"]
[null,null,null,null,null,null,null,null,null,null,"No"]
[]
["Monthly Cost for Property Management - Percentage ",0.1,null,"Industry Average is 10% of gross rents for Property Management"]
[]
["Annual Property Management",{"$f":"IF(B54=\"No\",0,B43*B57*12)","v":6960},"HIDE BEFORE DISTRIBUTION"]
["Monthly Reserves for Maintenance - Percentage",0.08,null,"Generally a range of 7% - 10% of gross rents for repairs/maintenance"]
[]
["Annual Reserves for Maintenance",{"$f":"B60*B43*12","v":5568},"HIDE BEFORE DISTRIBUTION"]
["Is there an HOA","No"]
[]
[]
["Monthly HOA Dues",0,null,"Add any HOA comments here"]
["Annual HOA Dues",{"$f":"IF(B63=\"No\",0,B66*12)","v":0},"HIDE BEFORE DISTRIBUTION"]
[]
["Additional Annual Expenses"]
["Annual Real Estate Taxes",4488,null,"2022 Assessment"]
["Annual Property Insurance",2424]
["Utilities (If paid by owner) "]
[" - Water and Sewer",0]
[" - Trash",0]
[" - Electric",0]
["Landscaping",0]
["Other",0]
["Other",0]
[]
["Any Additional Notes About This Property? "]
[]
[]
[]
["This sheet is for informational purposes only.  This is not a commitment, approval or guarantee to lend.  The figures included in this worksheet are entirely dependent on the information that you input.  These figures and calculations are considered accurate, but not guaranteed.  Joe Massey and Castle & Cooke Mortgage do not represent, warrant or guarantee these numbers.   James Orr and Real Estate Financial Planner LLC do not represent, warrant or guarantee these numbers.  All information is for preliminary analysis and calculations only.  Please contact your tax advisor, CPA, financial planner, attorney, insurance agent, real estate agent or other properly licensed professional for additional information as needed.  "]

{"sheet":"Cash-Flow","index":1,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":false,"merged":[[51,4,51,10],[61,0,64,10],[37,4,37,6],[41,0,41,10],[59,1,60,6],[52,0,53,10],[48,9,48,10],[0,0,0,1],[2,0,2,1],[12,0,12,2],[20,4,20,9],[21,4,21,9],[22,4,22,9],[30,4,30,9],[31,4,31,9],[26,4,26,9],[27,4,27,9],[28,4,28,9],[29,4,29,9],[23,4,23,9],[24,4,24,9],[25,4,25,9]]}
["Cash Flow Analysis of ",null,{"$f":"Inputs!B16","v":"Sample Property"}]
[]
["Number of Units ",null,{"$f":"Inputs!B17","v":2}]
[]
["Cash Investment Breakdown"]
["Purchase Price",null,{"$f":"Inputs!B24","v":885000}]
["Mortgage",null,{"$f":"Inputs!B29","v":580000.06049999991}]
["Down Payment",null,{"$f":"Inputs!B28","v":304999.93950000004}]
["Net Closing Costs to Buyer",null,{"$f":"Inputs!B25+Inputs!B26+Inputs!B27-IF((Inputs!B25+Inputs!B26+Inputs!B27)>Inputs!B31,Inputs!B31,(Inputs!B25+Inputs!B26+Inputs!B27))","v":55050}]
["Repair Costs",null,{"$f":"Inputs!B32","v":-306690}]
["Total Cash Investment ",null,{"$f":"Inputs!B33","v":53359.939500000037}]
[]
["Annual Cash Flow Statement "]
[]
["Annual Income"]
[{"$f":"\"Annual Rental Income @ $\"&E16&\" per month\"","v":"Annual Rental Income @ $5800 per month"},null,{"$f":"Inputs!B43*12","v":69600},null,{"$f":"Inputs!B43","v":5800},"per month"]
[" - Vacancy",{"$f":"Inputs!B45","v":0.05},{"$f":"-C16*Inputs!B45","v":-3480}]
["Expected Annual Rental Income",null,{"$f":"SUM(C16:C17)","v":66120}]
[]
["Annual Expenses",null,null,null,"Comments/Footnotes"]
["Property Management",null,{"$f":"Inputs!B59","v":6960},null,{"$f":"Inputs!D57","v":"Industry Average is 10% of gross rents for Property Management"}]
["Reserves for Repairs and Maintenance",null,{"$f":"Inputs!B62","v":5568},null,{"$f":"Inputs!D60","v":"Generally a range of 7% - 10% of gross rents for repairs/maintenance"}]
["HOA Dues ",null,{"$f":"Inputs!B67","v":0},null,{"$f":"Inputs!D66","v":"Add any HOA comments here"}]
["Real Estate Taxes",null,{"$f":"Inputs!B70","v":4488},null,{"$f":"Inputs!D70","v":"2022 Assessment"}]
["Property Insurance",null,{"$f":"Inputs!B71","v":2424},null,{"$f":"Inputs!D71","v":0}]
["Utilities (If paid by owner) "]
[" - Water and Sewer",null,{"$f":"Inputs!B73","v":0},null,{"$f":"Inputs!D73","v":0}]
[" - Trash",null,{"$f":"Inputs!B74","v":0},null,{"$f":"Inputs!D74","v":0}]
[" - Electric",null,{"$f":"Inputs!B75","v":0},null,{"$f":"Inputs!D75","v":0}]
["Landscaping",null,{"$f":"Inputs!B76","v":0},null,{"$f":"Inputs!D76","v":0}]
[{"$f":"Inputs!A77","v":"Other"},null,{"$f":"Inputs!B77","v":0},null,{"$f":"Inputs!D77","v":0}]
[{"$f":"Inputs!A78","v":"Other"},null,{"$f":"Inputs!B78","v":0},null,{"$f":"Inputs!D78","v":0}]
["Total Annual Expenses",null,{"$f":"SUM(C21:C32)","v":19440}]
[]
["Net Operating Income",null,{"$f":"C18-C33","v":46680}]
[]
["Less: Annual Mortgage Payments",null,{"$f":"PMT(Inputs!B35/12,Inputs!B36*12,Inputs!B29,0)*12","v":-47479.474044510745},null,{"$f":"Inputs!B29","v":580000.06049999991},"@",{"$f":"Inputs!B35","v":7.2499999999999995E-2},"=",{"$f":"-C37/12","v":3956.622837042562}," per month"]
["Less: Annual Mortgage Insurance",null,{"$f":"-Inputs!B37*12","v":0},null,"Estimated Mortgage Insurance",null,null,"=",{"$f":"Inputs!B37","v":0}," per month"]
[]
["Annual Cash Flow Before Taxes",null,{"$f":"C35+C37+C38","v":-799.47404451074544}]
[]
["1st Year Returns"]
["Cash-on-Cash Rate of Return",null,{"$f":"C40/C11","v":-1.4982663998536672E-2},null,{"$f":"C40","v":-799.47404451074544},"÷",{"$f":"C11","v":53359.939500000037},"=",{"$f":"C43","v":-1.4982663998536672E-2}]
[]
["CAP Rate",null,{"$f":"C35/(C6+C10)","v":8.0717954038491468E-2},null,{"$f":"C35","v":46680},"÷",{"$f":"C6+C10","v":578310},"=",{"$f":"C45","v":8.0717954038491468E-2}]
[]
["GRM - Gross Rent Multiplier",null,{"$f":"I47","v":99.708620689655177},null,{"$f":"C6+C10","v":578310},"÷",{"$f":"E16","v":5800},"=",{"$f":"E47/G47","v":99.708620689655177}]
[]
["Cindy's Number",{"$f":"IF(INT((E49-G49)/C3)>1000,\"YES!\",\"NO!\")","v":"NO!"},{"$f":"\"$\"&(INT((E49-G49)/C3))&\" / mo\"","v":"$633 / mo"},null,{"$f":"E16","v":5800},"-",{"$f":"((C23+C24+C25)/12)+I37","v":4532.6228370425615},"/",{"$f":"C3&\" Units\"","v":"2 Units"},{"$f":"\"=  $\"&(INT((E49-G49)/C3))&\" / mo\"","v":"=  $633 / mo"}]
[]
[]
["5 Year After-Tax Return ",null,{"$f":"'Long-Term Analysis'!S50","v":0.58663127200541032},null,"5 Year After Tax Cash-flows + 5 Year Exit - Capital Gains"]
["1st Year Return On Investment QuadrantTM (ROIQ) "]
[]
["Appreciation ",null,{"$f":"((C6*(1+Inputs!B49))-Inputs!B24)/C11","v":0.82927380380556781},{"$f":"((C6*(1+Inputs!B49))-Inputs!B24)","v":44250}]
["Cash Flow ",null,{"$f":"C40/Inputs!B33","v":-1.4982663998536672E-2},{"$f":"C40","v":-799.47404451074544}]
["Debt Paydown ",null,{"$f":"-(CUMPRINC(Inputs!$B$35/12,Inputs!B36*12,Inputs!$B$29,1,12,0))/Inputs!B33","v":0.10520194978184245},{"$f":"-(CUMPRINC(Inputs!$B$35/12,Inputs!B36*12,Inputs!$B$29,1,12,0))","v":5613.5696756411553}]
["Cash Flow From Depreciation ",null,{"$f":"(Inputs!B24*0.85/27.5)*Inputs!B51/Inputs!B33","v":0.16404543609826505},{"$f":"(Inputs!B24*0.85/27.5)*Inputs!B51","v":8753.454545454546}]
["Total ROI ",null,{"$f":"SUM(C55:C58)","v":1.0835385256871386},{"$f":"SUM(D55:D58)","v":57817.550176584955}]
[null,"**Return On Investment QuadrantTM is a trademark of Real Estate Financial Planner LLC"]
[]
[{"$f":"Inputs!A84","v":"This sheet is for informational purposes only.  This is not a commitment, approval or guarantee to lend.  The figures included in this worksheet are entirely dependent on the information that you input.  These figures and calculations are considered accurate, but not guaranteed.  Joe Massey and Castle & Cooke Mortgage do not represent, warrant or guarantee these numbers.   James Orr and Real Estate Financial Planner LLC do not represent, warrant or guarantee these numbers.  All information is for preliminary analysis and calculations only.  Please contact your tax advisor, CPA, financial planner, attorney, insurance agent, real estate agent or other properly licensed professional for additional information as needed.  "}]

{"sheet":"Long-Term Analysis","index":2,"n_rows":82,"n_cols":95,"rows_kept":82,"cut":false,"hidden":false,"merged":[[46,0,48,15],[0,0,0,1],[2,1,2,2],[4,0,4,2]]}
["Cash Flow Analysis for ",null,null,{"$f":"Inputs!B16","v":"Sample Property"},null,null,"Cash Investment Breakdown"]
[null,null,null,null,null,null,"Purchase Price",null,null,null,null,null,{"$f":"Inputs!B24","v":885000}]
[null,"Number of Units ",null,{"$f":"Inputs!B17","v":2},null,null,"Mortgage",null,null,null,null,null,{"$f":"Inputs!B29","v":580000.06049999991}]
[null,null,null,null,null,null,"Down Payment",null,null,null,null,null,{"$f":"Inputs!B28","v":304999.93950000004}]
["Annual Rent Increase",null,null,{"$f":"Inputs!B47","v":0.04},null,null,"Net Closing Costs Paid by Buyer",null,null,null,null,null,{"$f":"Inputs!B25+Inputs!B26+Inputs!B27-IF((Inputs!B25+Inputs!B26+Inputs!B27)>Inputs!B31,Inputs!B31,(Inputs!B25+Inputs!B26+Inputs!B27))","v":55050}]
[null,null,null,null,null,null,"Repair Costs",null,null,null,null,null,{"$f":"Inputs!B32","v":-306690}]
["Annual Cash Flow Statement ",null,null,null,null,null,"Total Cash Investment ",null,null,null,null,null,{"$f":"Inputs!B33","v":53359.939500000037}]
[]
["Annual Income",null,null,"Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5",null,null,"Year 6",null,null,"Year 7",null,null,"Year 8",null,null,"Year 9",null,null,"Year 10",null,null,"Year 11",null,null,"Year 12",null,null,"Year 13",null,null,"Year 14",null,null,"Year 15",null,null,"Year 16",null,null,"Year 17",null,null,"Year 18",null,null,"Year 19",null,null,"Year 20",null,null,"Year 21",null,null,"Year 22",null,null,"Year 23",null,null,"Year 24",null,null,"Year 25",null,null,"Year 26",null,null,"Year 27",null,null,"Year 28",null,null,"Year 29",null,null,"Year 30",null,null,"Year 31"]
["Annual Rental Income",null,null,{"$f":"Inputs!B43*12","v":69600},null,null,{"$f":"D10*(1+$D$5)","v":72384},null,null,{"$f":"G10*(1+$D$5)","v":75279.360000000001},null,null,{"$f":"J10*(1+$D$5)","v":78290.534400000004},null,null,{"$f":"M10*(1+$D$5)","v":81422.155776000014},null,null,{"$f":"P10*(1+$D$5)","v":84679.042007040014},null,null,{"$f":"S10*(1+$D$5)","v":88066.203687321613},null,null,{"$f":"V10*(1+$D$5)","v":91588.851834814486},null,null,{"$f":"Y10*(1+$D$5)","v":95252.405908207074},null,null,{"$f":"AB10*(1+$D$5)","v":99062.502144535363},null,null,{"$f":"AE10*(1+$D$5)","v":103025.00223031678},null,null,{"$f":"AH10*(1+$D$5)","v":107146.00231952945},null,null,{"$f":"AK10*(1+$D$5)","v":111431.84241231064},null,null,{"$f":"AN10*(1+$D$5)","v":115889.11610880306},null,null,{"$f":"AQ10*(1+$D$5)","v":120524.68075315519},null,null,{"$f":"AT10*(1+$D$5)","v":125345.6679832814},null,null,{"$f":"AW10*(1+$D$5)","v":130359.49470261266},null,null,{"$f":"AZ10*(1+$D$5)","v":135573.87449071716},null,null,{"$f":"BC10*(1+$D$5)","v":140996.82947034587},null,null,{"$f":"BF10*(1+$D$5)","v":146636.70264915971},null,null,{"$f":"BI10*(1+$D$5)","v":152502.17075512611},null,null,{"$f":"BL10*(1+$D$5)","v":158602.25758533116},null,null,{"$f":"BO10*(1+$D$5)","v":164946.34788874441},null,null,{"$f":"BR10*(1+$D$5)","v":171544.20180429419},null,null,{"$f":"BU10*(1+$D$5)","v":178405.96987646597},null,null,{"$f":"BX10*(1+$D$5)","v":185542.20867152463},null,null,{"$f":"CA10*(1+$D$5)","v":192963.89701838561},null,null,{"$f":"CD10*(1+$D$5)","v":200682.45289912104},null,null,{"$f":"CG10*(1+$D$5)","v":208709.7510150859},null,null,{"$f":"CJ10*(1+$D$5)","v":217058.14105568934},null,null,{"$f":"CM10*(1+$D$5)","v":225740.46669791691}]
[" - Vacancy",{"$f":"Inputs!B45","v":0.05},null,{"$f":"-D10*Inputs!B45","v":-3480},null,null,{"$f":"-G10*Inputs!$B$45","v":-3619.2000000000003},null,null,{"$f":"-J10*Inputs!$B$45","v":-3763.9680000000003},null,null,{"$f":"-M10*Inputs!$B$45","v":-3914.5267200000003},null,null,{"$f":"-P10*Inputs!$B$45","v":-4071.1077888000009},null,null,{"$f":"-S10*Inputs!$B$45","v":-4233.9521003520013},null,null,{"$f":"-V10*Inputs!$B$45","v":-4403.3101843660806},null,null,{"$f":"-Y10*Inputs!$B$45","v":-4579.4425917407243},null,null,{"$f":"-AB10*Inputs!$B$45","v":-4762.6202954103537},null,null,{"$f":"-AE10*Inputs!$B$45","v":-4953.1251072267687},null,null,{"$f":"-AH10*Inputs!$B$45","v":-5151.2501115158393},null,null,{"$f":"-AK10*Inputs!$B$45","v":-5357.3001159764726},null,null,{"$f":"-AN10*Inputs!$B$45","v":-5571.5921206155326},null,null,{"$f":"-AQ10*Inputs!$B$45","v":-5794.4558054401532},null,null,{"$f":"-AT10*Inputs!$B$45","v":-6026.2340376577595},null,null,{"$f":"-AW10*Inputs!$B$45","v":-6267.28339916407},null,null,{"$f":"-AZ10*Inputs!$B$45","v":-6517.9747351306332},null,null,{"$f":"-BC10*Inputs!$B$45","v":-6778.6937245358586},null,null,{"$f":"-BF10*Inputs!$B$45","v":-7049.8414735172937},null,null,{"$f":"-BI10*Inputs!$B$45","v":-7331.8351324579853},null,null,{"$f":"-BL10*Inputs!$B$45","v":-7625.1085377563059},null,null,{"$f":"-BO10*Inputs!$B$45","v":-7930.1128792665586},null,null,{"$f":"-BR10*Inputs!$B$45","v":-8247.3173944372211},null,null,{"$f":"-BU10*Inputs!$B$45","v":-8577.2100902147104},null,null,{"$f":"-BX10*Inputs!$B$45","v":-8920.2984938232985},null,null,{"$f":"-CA10*Inputs!$B$45","v":-9277.110433576232},null,null,{"$f":"-CD10*Inputs!$B$45","v":-9648.1948509192807},null,null,{"$f":"-CG10*Inputs!$B$45","v":-10034.122644956053},null,null,{"$f":"-CJ10*Inputs!$B$45","v":-10435.487550754297},null,null,{"$f":"-CM10*Inputs!$B$45","v":-10852.907052784467},null,null,{"$f":"-CP10*Inputs!$B$45","v":-11287.023334895846}]
["Expected Annual Rental Income",null,null,{"$f":"SUM(D10:D11)","v":66120},null,null,{"$f":"SUM(G10:G11)","v":68764.800000000003},null,null,{"$f":"SUM(J10:J11)","v":71515.392000000007},null,null,{"$f":"SUM(M10:M11)","v":74376.00768000001},null,null,{"$f":"SUM(P10:P11)","v":77351.047987200014},null,null,{"$f":"SUM(S10:S11)","v":80445.089906688008},null,null,{"$f":"SUM(V10:V11)","v":83662.893502955529},null,null,{"$f":"SUM(Y10:Y11)","v":87009.409243073766},null,null,{"$f":"SUM(AB10:AB11)","v":90489.785612796724},null,null,{"$f":"SUM(AE10:AE11)","v":94109.377037308601},null,null,{"$f":"SUM(AH10:AH11)","v":97873.752118800941},null,null,{"$f":"SUM(AK10:AK11)","v":101788.70220355298},null,null,{"$f":"SUM(AN10:AN11)","v":105860.25029169511},null,null,{"$f":"SUM(AQ10:AQ11)","v":110094.66030336291},null,null,{"$f":"SUM(AT10:AT11)","v":114498.44671549743},null,null,{"$f":"SUM(AW10:AW11)","v":119078.38458411733},null,null,{"$f":"SUM(AZ10:AZ11)","v":123841.51996748203},null,null,{"$f":"SUM(BC10:BC11)","v":128795.18076618131},null,null,{"$f":"SUM(BF10:BF11)","v":133946.98799682857},null,null,{"$f":"SUM(BI10:BI11)","v":139304.86751670172},null,null,{"$f":"SUM(BL10:BL11)","v":144877.06221736979},null,null,{"$f":"SUM(BO10:BO11)","v":150672.1447060646},null,null,{"$f":"SUM(BR10:BR11)","v":156699.0304943072},null,null,{"$f":"SUM(BU10:BU11)","v":162966.99171407949},null,null,{"$f":"SUM(BX10:BX11)","v":169485.67138264267},null,null,{"$f":"SUM(CA10:CA11)","v":176265.0982379484},null,null,{"$f":"SUM(CD10:CD11)","v":183315.70216746634},null,null,{"$f":"SUM(CG10:CG11)","v":190648.33025416499},null,null,{"$f":"SUM(CJ10:CJ11)","v":198274.2634643316},null,null,{"$f":"SUM(CM10:CM11)","v":206205.23400290488},null,null,{"$f":"SUM(CP10:CP11)","v":214453.44336302107}]
[]
["Annual Expenses"]
["Property Management",null,null,{"$f":"Inputs!B59","v":6960},null,null,{"$f":"(G10*Inputs!$B$57)","v":7238.4000000000005},null,null,{"$f":"J10*Inputs!$B$57","v":7527.9360000000006},null,null,{"$f":"M10*Inputs!$B$57","v":7829.0534400000006},null,null,{"$f":"P10*Inputs!$B$57","v":8142.2155776000018},null,null,{"$f":"S10*Inputs!$B$57","v":8467.9042007040025},null,null,{"$f":"V10*Inputs!$B$57","v":8806.6203687321613},null,null,{"$f":"Y10*Inputs!$B$57","v":9158.8851834814486},null,null,{"$f":"AB10*Inputs!$B$57","v":9525.2405908207074},null,null,{"$f":"AE10*Inputs!$B$57","v":9906.2502144535374},null,null,{"$f":"AH10*Inputs!$B$57","v":10302.500223031679},null,null,{"$f":"AK10*Inputs!$B$57","v":10714.600231952945},null,null,{"$f":"AN10*Inputs!$B$57","v":11143.184241231065},null,null,{"$f":"AQ10*Inputs!$B$57","v":11588.911610880306},null,null,{"$f":"AT10*Inputs!$B$57","v":12052.468075315519},null,null,{"$f":"AW10*Inputs!$B$57","v":12534.56679832814},null,null,{"$f":"AZ10*Inputs!$B$57","v":13035.949470261266},null,null,{"$f":"BC10*Inputs!$B$57","v":13557.387449071717},null,null,{"$f":"BF10*Inputs!$B$57","v":14099.682947034587},null,null,{"$f":"BI10*Inputs!$B$57","v":14663.670264915971},null,null,{"$f":"BL10*Inputs!$B$57","v":15250.217075512612},null,null,{"$f":"BO10*Inputs!$B$57","v":15860.225758533117},null,null,{"$f":"BR10*Inputs!$B$57","v":16494.634788874442},null,null,{"$f":"BU10*Inputs!$B$57","v":17154.420180429421},null,null,{"$f":"BX10*Inputs!$B$57","v":17840.596987646597},null,null,{"$f":"CA10*Inputs!$B$57","v":18554.220867152464},null,null,{"$f":"CD10*Inputs!$B$57","v":19296.389701838561},null,null,{"$f":"CG10*Inputs!$B$57","v":20068.245289912105},null,null,{"$f":"CJ10*Inputs!$B$57","v":20870.975101508593},null,null,{"$f":"CM10*Inputs!$B$57","v":21705.814105568934},null,null,{"$f":"CP10*Inputs!$B$57","v":22574.046669791693}]
["Reserves for Repairs and Maintenance",null,null,{"$f":"Inputs!B62","v":5568},null,null,{"$f":"G10*Inputs!B60","v":5790.72},null,null,{"$f":"G16*(1.03)","v":5964.4416000000001},null,null,{"$f":"J16*(1.03)","v":6143.3748480000004},null,null,{"$f":"M16*(1.03)","v":6327.6760934400008},null,null,{"$f":"P16*(1.03)","v":6517.506376243201},null,null,{"$f":"S16*(1.03)","v":6713.0315675304973},null,null,{"$f":"V16*(1.03)","v":6914.4225145564124},null,null,{"$f":"Y16*(1.03)","v":7121.8551899931053},null,null,{"$f":"AB16*(1.03)","v":7335.5108456928983},null,null,{"$f":"AE16*(1.03)","v":7555.5761710636853},null,null,{"$f":"AH16*(1.03)","v":7782.2434561955961},null,null,{"$f":"AK16*(1.03)","v":8015.7107598814646},null,null,{"$f":"AN16*(1.03)","v":8256.1820826779094},null,null,{"$f":"AQ16*(1.03)","v":8503.8675451582476},null,null,{"$f":"AT16*(1.03)","v":8758.9835715129957},null,null,{"$f":"AW16*(1.03)","v":9021.7530786583866},null,null,{"$f":"AZ16*(1.03)","v":9292.4056710181376},null,null,{"$f":"BC16*(1.03)","v":9571.1778411486812},null,null,{"$f":"BF16*(1.03)","v":9858.3131763831425},null,null,{"$f":"BI16*(1.03)","v":10154.062571674636},null,null,{"$f":"BL16*(1.03)","v":10458.684448824875},null,null,{"$f":"BO16*(1.03)","v":10772.444982289622},null,null,{"$f":"BR16*(1.03)","v":11095.618331758311},null,null,{"$f":"BU16*(1.03)","v":11428.48688171106},null,null,{"$f":"BX16*(1.03)","v":11771.341488162392},null,null,{"$f":"CA16*(1.03)","v":12124.481732807264},null,null,{"$f":"CD16*(1.03)","v":12488.216184791483},null,null,{"$f":"CG16*(1.03)","v":12862.862670335227},null,null,{"$f":"CJ16*(1.03)","v":13248.748550445285},null,null,{"$f":"CM16*(1.03)","v":13646.211006958643}]
["HOA Dues ",null,null,{"$f":"Inputs!B67","v":0},null,null,{"$f":"D17*(1.03)","v":0},null,null,{"$f":"G17*(1.03)","v":0},null,null,{"$f":"J17*(1.03)","v":0},null,null,{"$f":"M17*(1.03)","v":0},null,null,{"$f":"P17*(1.03)","v":0},null,null,{"$f":"S17*(1.03)","v":0},null,null,{"$f":"V17*(1.03)","v":0},null,null,{"$f":"Y17*(1.03)","v":0},null,null,{"$f":"AB17*(1.03)","v":0},null,null,{"$f":"AE17*(1.03)","v":0},null,null,{"$f":"AH17*(1.03)","v":0},null,null,{"$f":"AK17*(1.03)","v":0},null,null,{"$f":"AN17*(1.03)","v":0},null,null,{"$f":"AQ17*(1.03)","v":0},null,null,{"$f":"AT17*(1.03)","v":0},null,null,{"$f":"AW17*(1.03)","v":0},null,null,{"$f":"AZ17*(1.03)","v":0},null,null,{"$f":"BC17*(1.03)","v":0},null,null,{"$f":"BF17*(1.03)","v":0},null,null,{"$f":"BI17*(1.03)","v":0},null,null,{"$f":"BL17*(1.03)","v":0},null,null,{"$f":"BO17*(1.03)","v":0},null,null,{"$f":"BR17*(1.03)","v":0},null,null,{"$f":"BU17*(1.03)","v":0},null,null,{"$f":"BX17*(1.03)","v":0},null,null,{"$f":"CA17*(1.03)","v":0},null,null,{"$f":"CD17*(1.03)","v":0},null,null,{"$f":"CG17*(1.03)","v":0},null,null,{"$f":"CJ17*(1.03)","v":0},null,null,{"$f":"CM17*(1.03)","v":0}]
["Real Estate Taxes",null,null,{"$f":"Inputs!B70","v":4488},null,null,{"$f":"D18*(1.03)","v":4622.6400000000003},null,null,{"$f":"G18*(1.03)","v":4761.3192000000008},null,null,{"$f":"J18*(1.03)","v":4904.1587760000011},null,null,{"$f":"M18*(1.03)","v":5051.2835392800016},null,null,{"$f":"P18*(1.03)","v":5202.8220454584016},null,null,{"$f":"S18*(1.03)","v":5358.9067068221539},null,null,{"$f":"V18*(1.03)","v":5519.6739080268189},null,null,{"$f":"Y18*(1.03)","v":5685.264125267624},null,null,{"$f":"AB18*(1.03)","v":5855.8220490256526},null,null,{"$f":"AE18*(1.03)","v":6031.4967104964226},null,null,{"$f":"AH18*(1.03)","v":6212.4416118113159},null,null,{"$f":"AK18*(1.03)","v":6398.8148601656558},null,null,{"$f":"AN18*(1.03)","v":6590.7793059706255},null,null,{"$f":"AQ18*(1.03)","v":6788.5026851497441},null,null,{"$f":"AT18*(1.03)","v":6992.1577657042362},null,null,{"$f":"AW18*(1.03)","v":7201.9224986753634},null,null,{"$f":"AZ18*(1.03)","v":7417.9801736356249},null,null,{"$f":"BC18*(1.03)","v":7640.5195788446936},null,null,{"$f":"BF18*(1.03)","v":7869.7351662100345},null,null,{"$f":"BI18*(1.03)","v":8105.8272211963358},null,null,{"$f":"BL18*(1.03)","v":8349.0020378322261},null,null,{"$f":"BO18*(1.03)","v":8599.4720989671932},null,null,{"$f":"BR18*(1.03)","v":8857.4562619362096},null,null,{"$f":"BU18*(1.03)","v":9123.1799497942957},null,null,{"$f":"BX18*(1.03)","v":9396.8753482881257},null,null,{"$f":"CA18*(1.03)","v":9678.7816087367701},null,null,{"$f":"CD18*(1.03)","v":9969.1450569988738},null,null,{"$f":"CG18*(1.03)","v":10268.219408708841},null,null,{"$f":"CJ18*(1.03)","v":10576.265990970107},null,null,{"$f":"CM18*(1.03)","v":10893.553970699211}]
["Property Insurance",null,null,{"$f":"Inputs!B71","v":2424},null,null,{"$f":"D19*1.03","v":2496.7200000000003},null,null,{"$f":"G19*1.03","v":2571.6216000000004},null,null,{"$f":"J19*1.03","v":2648.7702480000003},null,null,{"$f":"M19*1.03","v":2728.2333554400002},null,null,{"$f":"P19*1.03","v":2810.0803561032003},null,null,{"$f":"S19*1.03","v":2894.3827667862965},null,null,{"$f":"V19*1.03","v":2981.2142497898853},null,null,{"$f":"Y19*1.03","v":3070.6506772835819},null,null,{"$f":"AB19*1.03","v":3162.7701976020894},null,null,{"$f":"AE19*1.03","v":3257.6533035301522},null,null,{"$f":"AH19*1.03","v":3355.3829026360568},null,null,{"$f":"AK19*1.03","v":3456.0443897151385},null,null,{"$f":"AN19*1.03","v":3559.7257214065926},null,null,{"$f":"AQ19*1.03","v":3666.5174930487906},null,null,{"$f":"AT19*1.03","v":3776.5130178402542},null,null,{"$f":"AW19*1.03","v":3889.808408375462},null,null,{"$f":"AZ19*1.03","v":4006.5026606267261},null,null,{"$f":"BC19*1.03","v":4126.6977404455283},null,null,{"$f":"BF19*1.03","v":4250.4986726588941},null,null,{"$f":"BI19*1.03","v":4378.0136328386607},null,null,{"$f":"BL19*1.03","v":4509.3540418238208},null,null,{"$f":"BO19*1.03","v":4644.6346630785356},null,null,{"$f":"BR19*1.03","v":4783.9737029708922},null,null,{"$f":"BU19*1.03","v":4927.4929140600188},null,null,{"$f":"BX19*1.03","v":5075.3177014818193},null,null,{"$f":"CA19*1.03","v":5227.5772325262742},null,null,{"$f":"CD19*1.03","v":5384.4045495020628},null,null,{"$f":"CG19*1.03","v":5545.9366859871252},null,null,{"$f":"CJ19*1.03","v":5712.3147865667388},null,null,{"$f":"CM19*1.03","v":5883.6842301637407}]
["Utilities (If paid by owner) "]
[" - Water and Sewer",null,null,{"$f":"Inputs!B73","v":0},null,null,{"$f":"D21*1.03","v":0},null,null,{"$f":"G21*1.03","v":0},null,null,{"$f":"J21*1.03","v":0},null,null,{"$f":"M21*1.03","v":0},null,null,{"$f":"P21*1.03","v":0},null,null,{"$f":"S21*1.03","v":0},null,null,{"$f":"V21*1.03","v":0},null,null,{"$f":"Y21*1.03","v":0},null,null,{"$f":"AB21*1.03","v":0},null,null,{"$f":"AE21*1.03","v":0},null,null,{"$f":"AH21*1.03","v":0},null,null,{"$f":"AK21*1.03","v":0},null,null,{"$f":"AN21*1.03","v":0},null,null,{"$f":"AQ21*1.03","v":0},null,null,{"$f":"AT21*1.03","v":0},null,null,{"$f":"AW21*1.03","v":0},null,null,{"$f":"AZ21*1.03","v":0},null,null,{"$f":"BC21*1.03","v":0},null,null,{"$f":"BF21*1.03","v":0},null,null,{"$f":"BI21*1.03","v":0},null,null,{"$f":"BL21*1.03","v":0},null,null,{"$f":"BO21*1.03","v":0},null,null,{"$f":"BR21*1.03","v":0},null,null,{"$f":"BU21*1.03","v":0},null,null,{"$f":"BX21*1.03","v":0},null,null,{"$f":"CA21*1.03","v":0},null,null,{"$f":"CD21*1.03","v":0},null,null,{"$f":"CG21*1.03","v":0},null,null,{"$f":"CJ21*1.03","v":0},null,null,{"$f":"CM21*1.03","v":0}]
[" - Trash",null,null,{"$f":"Inputs!B74","v":0},null,null,{"$f":"D22*1.03","v":0},null,null,{"$f":"G22*1.03","v":0},null,null,{"$f":"J22*1.03","v":0},null,null,{"$f":"M22*1.03","v":0},null,null,{"$f":"P22*1.03","v":0},null,null,{"$f":"S22*1.03","v":0},null,null,{"$f":"V22*1.03","v":0},null,null,{"$f":"Y22*1.03","v":0},null,null,{"$f":"AB22*1.03","v":0},null,null,{"$f":"AE22*1.03","v":0},null,null,{"$f":"AH22*1.03","v":0},null,null,{"$f":"AK22*1.03","v":0},null,null,{"$f":"AN22*1.03","v":0},null,null,{"$f":"AQ22*1.03","v":0},null,null,{"$f":"AT22*1.03","v":0},null,null,{"$f":"AW22*1.03","v":0},null,null,{"$f":"AZ22*1.03","v":0},null,null,{"$f":"BC22*1.03","v":0},null,null,{"$f":"BF22*1.03","v":0},null,null,{"$f":"BI22*1.03","v":0},null,null,{"$f":"BL22*1.03","v":0},null,null,{"$f":"BO22*1.03","v":0},null,null,{"$f":"BR22*1.03","v":0},null,null,{"$f":"BU22*1.03","v":0},null,null,{"$f":"BX22*1.03","v":0},null,null,{"$f":"CA22*1.03","v":0},null,null,{"$f":"CD22*1.03","v":0},null,null,{"$f":"CG22*1.03","v":0},null,null,{"$f":"CJ22*1.03","v":0},null,null,{"$f":"CM22*1.03","v":0}]
[" - Electric",null,null,{"$f":"Inputs!B75","v":0},null,null,{"$f":"D23*1.03","v":0},null,null,{"$f":"G23*1.03","v":0},null,null,{"$f":"J23*1.03","v":0},null,null,{"$f":"M23*1.03","v":0},null,null,{"$f":"P23*1.03","v":0},null,null,{"$f":"S23*1.03","v":0},null,null,{"$f":"V23*1.03","v":0},null,null,{"$f":"Y23*1.03","v":0},null,null,{"$f":"AB23*1.03","v":0},null,null,{"$f":"AE23*1.03","v":0},null,null,{"$f":"AH23*1.03","v":0},null,null,{"$f":"AK23*1.03","v":0},null,null,{"$f":"AN23*1.03","v":0},null,null,{"$f":"AQ23*1.03","v":0},null,null,{"$f":"AT23*1.03","v":0},null,null,{"$f":"AW23*1.03","v":0},null,null,{"$f":"AZ23*1.03","v":0},null,null,{"$f":"BC23*1.03","v":0},null,null,{"$f":"BF23*1.03","v":0},null,null,{"$f":"BI23*1.03","v":0},null,null,{"$f":"BL23*1.03","v":0},null,null,{"$f":"BO23*1.03","v":0},null,null,{"$f":"BR23*1.03","v":0},null,null,{"$f":"BU23*1.03","v":0},null,null,{"$f":"BX23*1.03","v":0},null,null,{"$f":"CA23*1.03","v":0},null,null,{"$f":"CD23*1.03","v":0},null,null,{"$f":"CG23*1.03","v":0},null,null,{"$f":"CJ23*1.03","v":0},null,null,{"$f":"CM23*1.03","v":0}]
["Landscaping",null,null,{"$f":"Inputs!B76","v":0},null,null,{"$f":"D24*1.03","v":0},null,null,{"$f":"G24*1.03","v":0},null,null,{"$f":"J24*1.03","v":0},null,null,{"$f":"M24*1.03","v":0},null,null,{"$f":"P24*1.03","v":0},null,null,{"$f":"S24*1.03","v":0},null,null,{"$f":"V24*1.03","v":0},null,null,{"$f":"Y24*1.03","v":0},null,null,{"$f":"AB24*1.03","v":0},null,null,{"$f":"AE24*1.03","v":0},null,null,{"$f":"AH24*1.03","v":0},null,null,{"$f":"AK24*1.03","v":0},null,null,{"$f":"AN24*1.03","v":0},null,null,{"$f":"AQ24*1.03","v":0},null,null,{"$f":"AT24*1.03","v":0},null,null,{"$f":"AW24*1.03","v":0},null,null,{"$f":"AZ24*1.03","v":0},null,null,{"$f":"BC24*1.03","v":0},null,null,{"$f":"BF24*1.03","v":0},null,null,{"$f":"BI24*1.03","v":0},null,null,{"$f":"BL24*1.03","v":0},null,null,{"$f":"BO24*1.03","v":0},null,null,{"$f":"BR24*1.03","v":0},null,null,{"$f":"BU24*1.03","v":0},null,null,{"$f":"BX24*1.03","v":0},null,null,{"$f":"CA24*1.03","v":0},null,null,{"$f":"CD24*1.03","v":0},null,null,{"$f":"CG24*1.03","v":0},null,null,{"$f":"CJ24*1.03","v":0},null,null,{"$f":"CM24*1.03","v":0}]
[{"$f":"Inputs!A77","v":"Other"},null,null,{"$f":"Inputs!B77","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Inputs!A78","v":"Other"},null,null,{"$f":"Inputs!B78","v":0},null,null,{"$f":"D26*1.03","v":0},null,null,{"$f":"G26*1.03","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Total Annual Expenses",null,null,{"$f":"SUM(D15:D26)","v":19440},null,null,{"$f":"SUM(G15:G26)","v":20148.480000000003},null,null,{"$f":"SUM(J15:J26)","v":20825.318400000004},null,null,{"$f":"SUM(M15:M26)","v":21525.357312000004},null,null,{"$f":"SUM(P15:P26)","v":22249.408565760004},null,null,{"$f":"SUM(S15:S26)","v":22998.312978508806},null,null,{"$f":"SUM(V15:V26)","v":23772.941409871109},null,null,{"$f":"SUM(Y15:Y26)","v":24574.195855854567},null,null,{"$f":"SUM(AB15:AB26)","v":25403.01058336502},null,null,{"$f":"SUM(AE15:AE26)","v":26260.353306774181},null,null,{"$f":"SUM(AH15:AH26)","v":27147.226408121936},null,null,{"$f":"SUM(AK15:AK26)","v":28064.668202595913},null,null,{"$f":"SUM(AN15:AN26)","v":29013.754250993323},null,null,{"$f":"SUM(AQ15:AQ26)","v":29995.598720935432},null,null,{"$f":"SUM(AT15:AT26)","v":31011.355798672303},null,null,{"$f":"SUM(AW15:AW26)","v":32062.221153385624},null,null,{"$f":"SUM(AZ15:AZ26)","v":33149.433455970473},null,null,{"$f":"SUM(BC15:BC26)","v":34274.275954352204},null,null,{"$f":"SUM(BF15:BF26)","v":35438.078107473491},null,null,{"$f":"SUM(BI15:BI26)","v":36642.217280168043},null,null,{"$f":"SUM(BL15:BL26)","v":37888.120501222242},null,null,{"$f":"SUM(BO15:BO26)","v":39177.266287014041},null,null,{"$f":"SUM(BR15:BR26)","v":40511.186533209788},null,null,{"$f":"SUM(BU15:BU26)","v":41891.468477094837},null,null,{"$f":"SUM(BX15:BX26)","v":43319.756733211972},null,null,{"$f":"SUM(CA15:CA26)","v":44797.755405084798},null,null,{"$f":"SUM(CD15:CD26)","v":46327.230275908871},null,null,{"$f":"SUM(CG15:CG26)","v":47910.011081204524},null,null,{"$f":"SUM(CJ15:CJ26)","v":49547.993866539786},null,null,{"$f":"SUM(CM15:CM26)","v":51243.143433551071},null,null,{"$f":"SUM(CP15:CP26)","v":52997.495877613284}]
[]
["Net Operating Income",null,null,{"$f":"D12-D27","v":46680},null,null,{"$f":"G12-G27","v":48616.32},null,null,{"$f":"J12-J27","v":50690.073600000003},null,null,{"$f":"M12-M27","v":52850.650368000002},null,null,{"$f":"P12-P27","v":55101.639421440006},null,null,{"$f":"S12-S27","v":57446.776928179199},null,null,{"$f":"V12-V27","v":59889.952093084416},null,null,{"$f":"Y12-Y27","v":62435.213387219199},null,null,{"$f":"AB12-AB27","v":65086.775029431708},null,null,{"$f":"AE12-AE27","v":67849.02373053442},null,null,{"$f":"AH12-AH27","v":70726.525710679009},null,null,{"$f":"AK12-AK27","v":73724.034000957065},null,null,{"$f":"AN12-AN27","v":76846.496040701779},null,null,{"$f":"AQ12-AQ27","v":80099.061582427472},null,null,{"$f":"AT12-AT27","v":83487.090916825124},null,null,{"$f":"AW12-AW27","v":87016.163430731714},null,null,{"$f":"AZ12-AZ27","v":90692.086511511559},null,null,{"$f":"BC12-BC27","v":94520.904811829096},null,null,{"$f":"BF12-BF27","v":98508.909889355069},null,null,{"$f":"BI12-BI27","v":102662.65023653368},null,null,{"$f":"BL12-BL27","v":106988.94171614756},null,null,{"$f":"BO12-BO27","v":111494.87841905057},null,null,{"$f":"BR12-BR27","v":116187.84396109742},null,null,{"$f":"BU12-BU27","v":121075.52323698465},null,null,{"$f":"BX12-BX27","v":126165.91464943069},null,null,{"$f":"CA12-CA27","v":131467.34283286362},null,null,{"$f":"CD12-CD27","v":136988.47189155748},null,null,{"$f":"CG12-CG27","v":142738.31917296047},null,null,{"$f":"CJ12-CJ27","v":148726.2695977918},null,null,{"$f":"CM12-CM27","v":154962.09056935381},null,null,{"$f":"CP12-CP27","v":161455.94748540779}]
[]
["Less: Annual Mortgage Payments",null,null,{"$f":"IF(D37>0,PMT(Inputs!B35/12,Inputs!B36*12,Inputs!B29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(D37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(G37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(J37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(M37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(P37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(S37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(V37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(Y37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AB37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AE37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AH37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AK37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AN37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AQ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AT37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AW37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AZ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BC37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BF37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BI37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BL37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BO37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BR37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BU37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BX37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(CA37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(CD37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(CG37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(CJ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,0]
["Less: Annual Mortgage Insurance",null,null,{"$f":"-Inputs!B37*12","v":0},null,null,{"$f":"IF((D37/$M$2)>0.8,D32,0)","v":0},null,null,{"$f":"IF((G37/$M$2)>0.8,G32,0)","v":0},null,null,{"$f":"IF((J37/$M$2)>0.8,J32,0)","v":0},null,null,{"$f":"IF((M37/$M$2)>0.8,M32,0)","v":0},null,null,{"$f":"IF((P37/$M$2)>0.8,P32,0)","v":0},null,null,{"$f":"IF((S37/$M$2)>0.8,S32,0)","v":0},null,null,{"$f":"IF((V37/$M$2)>0.8,V32,0)","v":0},null,null,{"$f":"IF((Y37/$M$2)>0.8,Y32,0)","v":0},null,null,{"$f":"IF((AB37/$M$2)>0.8,AB32,0)","v":0},null,null,{"$f":"IF((AE37/$M$2)>0.8,AE32,0)","v":0},null,null,{"$f":"IF((AH37/$M$2)>0.8,AH32,0)","v":0},null,null,{"$f":"IF((AK37/$M$2)>0.8,AK32,0)","v":0},null,null,{"$f":"IF((AN37/$M$2)>0.8,AN32,0)","v":0},null,null,{"$f":"IF((AQ37/$M$2)>0.8,AQ32,0)","v":0},null,null,{"$f":"IF((AT37/$M$2)>0.8,AT32,0)","v":0},null,null,{"$f":"IF((AW37/$M$2)>0.8,AW32,0)","v":0},null,null,{"$f":"IF((AZ37/$M$2)>0.8,AZ32,0)","v":0},null,null,{"$f":"IF((BC37/$M$2)>0.8,BC32,0)","v":0},null,null,{"$f":"IF((BF37/$M$2)>0.8,BF32,0)","v":0},null,null,{"$f":"IF((BI37/$M$2)>0.8,BI32,0)","v":0},null,null,{"$f":"IF((BL37/$M$2)>0.8,BL32,0)","v":0},null,null,{"$f":"IF((BO37/$M$2)>0.8,BO32,0)","v":0},null,null,{"$f":"IF((BR37/$M$2)>0.8,BR32,0)","v":0},null,null,{"$f":"IF((BU37/$M$2)>0.8,BU32,0)","v":0},null,null,{"$f":"IF((BX37/$M$2)>0.8,BX32,0)","v":0},null,null,{"$f":"IF((CA37/$M$2)>0.8,CA32,0)","v":0},null,null,{"$f":"IF((CD37/$M$2)>0.8,CD32,0)","v":0},null,null,{"$f":"IF((CG37/$M$2)>0.8,CG32,0)","v":0},null,null,{"$f":"IF((CJ37/$M$2)>0.8,CJ32,0)","v":0},null,null,{"$f":"IF((CM37/$M$2)>0.8,CM32,0)","v":0}]
[]
["Annual Cash Flow Before Taxes",null,null,{"$f":"D29+D31+D32","v":-799.47404451074544},null,null,{"$f":"G29+G31+G32","v":1136.8459554892543},null,null,{"$f":"J29+J31+J32","v":3210.5995554892579},null,null,{"$f":"M29+M31+M32","v":5371.1763234892569},null,null,{"$f":"P29+P31+P32","v":7622.1653769292607},null,null,{"$f":"S29+S31+S32","v":9967.3028836684534},null,null,{"$f":"V29+V31+V32","v":12410.47804857367},null,null,{"$f":"Y29+Y31+Y32","v":14955.739342708453},null,null,{"$f":"AB29+AB31+AB32","v":17607.300984920963},null,null,{"$f":"AE29+AE31+AE32","v":20369.549686023674},null,null,{"$f":"AH29+AH31+AH32","v":23247.051666168263},null,null,{"$f":"AK29+AK31+AK32","v":26244.559956446319},null,null,{"$f":"AN29+AN31+AN32","v":29367.021996191033},null,null,{"$f":"AQ29+AQ31+AQ32","v":32619.587537916726},null,null,{"$f":"AT29+AT31+AT32","v":36007.616872314378},null,null,{"$f":"AW29+AW31+AW32","v":39536.689386220969},null,null,{"$f":"AZ29+AZ31+AZ32","v":43212.612467000814},null,null,{"$f":"BC29+BC31+BC32","v":47041.43076731835},null,null,{"$f":"BF29+BF31+BF32","v":51029.435844844324},null,null,{"$f":"BI29+BI31+BI32","v":55183.176192022933},null,null,{"$f":"BL29+BL31+BL32","v":59509.467671636812},null,null,{"$f":"BO29+BO31+BO32","v":64015.404374539823},null,null,{"$f":"BR29+BR31+BR32","v":68708.369916586671},null,null,{"$f":"BU29+BU31+BU32","v":73596.049192473904},null,null,{"$f":"BX29+BX31+BX32","v":78686.440604919946},null,null,{"$f":"CA29+CA31+CA32","v":83987.868788352876},null,null,{"$f":"CD29+CD31+CD32","v":89508.997847046732},null,null,{"$f":"CG29+CG31+CG32","v":95258.845128449728},null,null,{"$f":"CJ29+CJ31+CJ32","v":101246.79555328106},null,null,{"$f":"CM29+CM31+CM32","v":107482.61652484306},null,null,{"$f":"CP29+CP31+CP32","v":161455.94748540779}]
[]
["Property Value at End of Year",null,null,{"$f":"Inputs!B24*(1+Inputs!B49)","v":929250},null,null,{"$f":"D36*(1+Inputs!$B$49)","v":975712.5},null,null,{"$f":"G36*(1+Inputs!$B$49)","v":1024498.125},null,null,{"$f":"J36*(1+Inputs!$B$49)","v":1075723.03125},null,null,{"$f":"M36*(1+Inputs!$B$49)","v":1129509.1828125},null,null,{"$f":"P36*(1+Inputs!$B$49)","v":1185984.6419531251},null,null,{"$f":"S36*(1+Inputs!$B$49)","v":1245283.8740507814},null,null,{"$f":"V36*(1+Inputs!$B$49)","v":1307548.0677533206},null,null,{"$f":"Y36*(1+Inputs!$B$49)","v":1372925.4711409865},null,null,{"$f":"AB36*(1+Inputs!$B$49)","v":1441571.744698036},null,null,{"$f":"AE36*(1+Inputs!$B$49)","v":1513650.331932938},null,null,{"$f":"AH36*(1+Inputs!$B$49)","v":1589332.8485295849},null,null,{"$f":"AK36*(1+Inputs!$B$49)","v":1668799.4909560643},null,null,{"$f":"AN36*(1+Inputs!$B$49)","v":1752239.4655038677},null,null,{"$f":"AQ36*(1+Inputs!$B$49)","v":1839851.4387790612},null,null,{"$f":"AT36*(1+Inputs!$B$49)","v":1931844.0107180143},null,null,{"$f":"AW36*(1+Inputs!$B$49)","v":2028436.2112539152},null,null,{"$f":"AZ36*(1+Inputs!$B$49)","v":2129858.0218166113},null,null,{"$f":"BC36*(1+Inputs!$B$49)","v":2236350.9229074419},null,null,{"$f":"BF36*(1+Inputs!$B$49)","v":2348168.4690528139},null,null,{"$f":"BI36*(1+Inputs!$B$49)","v":2465576.8925054548},null,null,{"$f":"BL36*(1+Inputs!$B$49)","v":2588855.7371307276},null,null,{"$f":"BO36*(1+Inputs!$B$49)","v":2718298.5239872639},null,null,{"$f":"BR36*(1+Inputs!$B$49)","v":2854213.4501866275},null,null,{"$f":"BU36*(1+Inputs!$B$49)","v":2996924.1226959592},null,null,{"$f":"BX36*(1+Inputs!$B$49)","v":3146770.3288307572},null,null,{"$f":"CA36*(1+Inputs!$B$49)","v":3304108.8452722952},null,null,{"$f":"CD36*(1+Inputs!$B$49)","v":3469314.28753591},null,null,{"$f":"CG36*(1+Inputs!$B$49)","v":3642780.0019127056},null,null,{"$f":"CJ36*(1+Inputs!$B$49)","v":3824919.0020083413},null,null,{"$f":"CM36*(1+Inputs!$B$49)","v":4016164.9521087585}]
["Mortgage Balance at End of Year",null,null,{"$f":"Inputs!B29+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,1,12,0)","v":574386.49082435877},null,null,{"$f":"D37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,13,24,0)","v":568352.13752337557},null,null,{"$f":"G37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,25,36,0)","v":561865.45937291184},null,null,{"$f":"J37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,37,48,0)","v":554892.55087236932},null,null,{"$f":"M37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,49,60,0)","v":547396.96502255136},null,null,{"$f":"P37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,61,72,0)","v":539339.52281925571},null,null,{"$f":"S37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,73,84,0)","v":530678.10846683022},null,null,{"$f":"V37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,85,96,0)","v":521367.44924128626},null,null,{"$f":"Y37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,97,108,0)","v":511358.87885232538},null,null,{"$f":"AB37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,109,120,0)","v":500600.08306738647},null,null,{"$f":"AE37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,121,132,0)","v":489034.82626810478},null,null,{"$f":"AH37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,133,144,0)","v":476602.65750990849},null,null,{"$f":"AK37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,145,156,0)","v":463238.59454834316},null,null,{"$f":"AN37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,157,168,0)","v":448872.78418054746},null,null,{"$f":"AQ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,169,180,0)","v":433430.13712650415},null,null,{"$f":"AT37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,181,192,0)","v":416829.93554161128},null,null,{"$f":"AW37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,193,204,0)","v":398985.41110906401},null,null,{"$f":"AZ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,205,216,0)","v":379803.29150675971},null,null,{"$f":"BC37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,217,228,0)","v":359183.31287813443},null,null,{"$f":"BF37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,229,240,0)","v":337017.69575864321},null,null,{"$f":"BI37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,241,252,0)","v":313190.5817185819},null,null,{"$f":"BL37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,253,264,0)","v":287577.4277776138},null,null,{"$f":"BO37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,265,276,0)","v":260044.35542564036},null,null,{"$f":"BR37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,277,288,0)","v":230447.45084738475},null,null,{"$f":"BU37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,289,300,0)","v":198632.0126930016},null,null,{"$f":"BX37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,301,312,0)","v":164431.74346285232},null,null,{"$f":"CA37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,313,324,0)","v":127667.88027986002},null,null,{"$f":"CD37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,325,336,0)","v":88148.260506040009},null,null,{"$f":"CG37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,337,348,0)","v":45666.317319236201},null,null,{"$f":"CJ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,349,360,0)","v":0},null,null,0]
["Total Equity",null,null,{"$f":"D36-D37","v":354863.50917564123},null,null,{"$f":"G36-G37","v":407360.36247662443},null,null,{"$f":"J36-J37","v":462632.66562708816},null,null,{"$f":"M36-M37","v":520830.48037763068},null,null,{"$f":"P36-P37","v":582112.21778994869},null,null,{"$f":"S36-S37","v":646645.11913386942},null,null,{"$f":"V36-V37","v":714605.76558395114},null,null,{"$f":"Y36-Y37","v":786180.6185120343},null,null,{"$f":"AB36-AB37","v":861566.59228866117},null,null,{"$f":"AE36-AE37","v":940971.66163064959},null,null,{"$f":"AH36-AH37","v":1024615.5056648331},null,null,{"$f":"AK36-AK37","v":1112730.1910196764},null,null,{"$f":"AN36-AN37","v":1205560.8964077211},null,null,{"$f":"AQ36-AQ37","v":1303366.6813233201},null,null,{"$f":"AT36-AT37","v":1406421.301652557},null,null,{"$f":"AW36-AW37","v":1515014.0751764029},null,null,{"$f":"AZ36-AZ37","v":1629450.8001448512},null,null,{"$f":"BC36-BC37","v":1750054.7303098515},null,null,{"$f":"BF36-BF37","v":1877167.6100293074},null,null,{"$f":"BI36-BI37","v":2011150.7732941709},null,null,{"$f":"BL36-BL37","v":2152386.3107868731},null,null,{"$f":"BO36-BO37","v":2301278.3093531136},null,null,{"$f":"BR36-BR37","v":2458254.1685616234},null,null,{"$f":"BU36-BU37","v":2623765.9993392425},null,null,{"$f":"BX36-BX37","v":2798292.1100029578},null,null,{"$f":"CA36-CA37","v":2982338.585367905},null,null,{"$f":"CD36-CD37","v":3176440.9649924352},null,null,{"$f":"CG36-CG37","v":3381166.0270298701},null,null,{"$f":"CJ36-CJ37","v":3597113.6845934694},null,null,{"$f":"CM36-CM37","v":3824919.0020083413},null,null,{"$f":"CP36-CP37","v":4016164.9521087585}]
[]
["ROI QuadrantTM"]
["Appreciation",null,null,{"$f":"D36-$M$2","v":44250},{"$f":"(D36-$M$2)/$M$7","v":0.82927380380556781},null,{"$f":"G36-D36","v":46462.5},{"$f":"(G36-D36)/$M$7","v":0.87073749399584621},null,{"$f":"J36-G36","v":48785.625},{"$f":"(J36-G36)/$M$7","v":0.9142743686956385},null,{"$f":"M36-J36","v":51224.90625},{"$f":"(M36-J36)/$M$7","v":0.9599880871304205},null,{"$f":"P36-M36","v":53786.151562500047},{"$f":"(P36-M36)/$M$7","v":1.0079874914869424},null,{"$f":"S36-P36","v":56475.459140625084},{"$f":"(S36-P36)/$M$7","v":1.0583868660612901},null,{"$f":"V36-S36","v":59299.232097656233},{"$f":"(V36-S36)/$M$7","v":1.1113062093643526},null,{"$f":"Y36-V36","v":62264.193702539196},{"$f":"(Y36-V36)/$M$7","v":1.1668715198325732},null,{"$f":"AB36-Y36","v":65377.403387665981},{"$f":"(AB36-Y36)/$M$7","v":1.2252150958241985},null,{"$f":"AE36-AB36","v":68646.273557049455},{"$f":"(AE36-AB36)/$M$7","v":1.2864758506154117},null,{"$f":"AH36-AE36","v":72078.587234901963},{"$f":"(AH36-AE36)/$M$7","v":1.3507996431461831},null,{"$f":"AK36-AH36","v":75682.516596646979},{"$f":"(AK36-AH36)/$M$7","v":1.4183396253034906},null,{"$f":"AN36-AK36","v":79466.642426479375},{"$f":"(AN36-AK36)/$M$7","v":1.4892566065686661},null,{"$f":"AQ36-AN36","v":83439.974547803402},{"$f":"(AQ36-AN36)/$M$7","v":1.5637194368971004},null,{"$f":"AT36-AQ36","v":87611.973275193479},{"$f":"(AT36-AQ36)/$M$7","v":1.6419054087419536},null,{"$f":"AW36-AT36","v":91992.57193895313},{"$f":"(AW36-AT36)/$M$7","v":1.724000679179051},null,{"$f":"AZ36-AW36","v":96592.200535900891},{"$f":"(AZ36-AW36)/$M$7","v":1.8102007131380053},null,{"$f":"BC36-AZ36","v":101421.81056269608},{"$f":"(BC36-AZ36)/$M$7","v":1.9007107487949082},null,{"$f":"BF36-BC36","v":106492.90109083056},{"$f":"(BF36-BC36)/$M$7","v":1.9957462862346478},null,{"$f":"BI36-BF36","v":111817.54614537209},{"$f":"(BI36-BF36)/$M$7","v":2.0955336005463803},null,{"$f":"BL36-BI36","v":117408.42345264088},{"$f":"(BL36-BI36)/$M$7","v":2.2003102805737029},null,{"$f":"BO36-BL36","v":123278.84462527279},{"$f":"(BO36-BL36)/$M$7","v":2.3103257946023854},null,{"$f":"BR36-BO36","v":129442.78685653629},{"$f":"(BR36-BO36)/$M$7","v":2.4258420843325017},null,{"$f":"BU36-BR36","v":135914.92619936354},{"$f":"(BU36-BR36)/$M$7","v":2.5471341885491352},null,{"$f":"BX36-BU36","v":142710.67250933172},{"$f":"(BX36-BU36)/$M$7","v":2.6744908979765922},null,{"$f":"CA36-BX36","v":149846.20613479801},{"$f":"(CA36-BX36)/$M$7","v":2.808215442875416},null,{"$f":"CD36-CA36","v":157338.516441538},{"$f":"(CD36-CA36)/$M$7","v":2.9486262150191886},null,{"$f":"CG36-CD36","v":165205.44226361485},{"$f":"(CG36-CD36)/$M$7","v":3.096057525770147},null,{"$f":"CJ36-CG36","v":173465.71437679557},{"$f":"(CJ36-CG36)/$M$7","v":3.2508604020586538},null,{"$f":"CM36-CJ36","v":182139.00009563565},{"$f":"(CM36-CJ36)/$M$7","v":3.4134034221615925},null,{"$f":"CP36-CM36","v":191245.95010041725},{"$f":"(CP36-CM36)/$M$7","v":3.5840735932696686}]
["Cash Flow ",null,null,{"$f":"D34","v":-799.47404451074544},{"$f":"D34/$M$7","v":-1.4982663998536672E-2},null,{"$f":"G34","v":1136.8459554892543},{"$f":"G34/$M$7","v":2.1305233216938963E-2},null,{"$f":"J34","v":3210.5995554892579},{"$f":"J34/$M$7","v":6.0168725556543325E-2},null,{"$f":"M34","v":5371.1763234892569},{"$f":"M34/$M$7","v":0.10065934058057269},null,{"$f":"P34","v":7622.1653769292607},{"$f":"P34/$M$7","v":0.14284434068612945},null,{"$f":"S34","v":9967.3028836684534},{"$f":"S34/$M$7","v":0.18679374409089139},null,{"$f":"V34","v":12410.47804857367},{"$f":"V34/$M$7","v":0.23258043702567657},null,{"$f":"Y34","v":14955.739342708453},{"$f":"Y34/$M$7","v":0.28028029047350106},null,{"$f":"AB34","v":17607.300984920963},{"$f":"AB34/$M$7","v":0.32997228163875542},null,{"$f":"AE34","v":20369.549686023674},{"$f":"AE34/$M$7","v":0.38173862033752232},null,{"$f":"AH34","v":23247.051666168263},{"$f":"AH34/$M$7","v":0.4356648805077496},null,{"$f":"AK34","v":26244.559956446319},{"$f":"AK34/$M$7","v":0.4918401370460006},null,{"$f":"AN34","v":29367.021996191033},{"$f":"AN34/$M$7","v":0.55035710818583317},null,{"$f":"AQ34","v":32619.587537916726},{"$f":"AQ34/$M$7","v":0.6113123036415119},null,{"$f":"AT34","v":36007.616872314378},{"$f":"AT34/$M$7","v":0.67480617874977822},null,{"$f":"AW34","v":39536.689386220969},{"$f":"AW34/$M$7","v":0.74094329485176691},null,{"$f":"AZ34","v":43212.612467000814},{"$f":"AZ34/$M$7","v":0.80983248616690773},null,{"$f":"BC34","v":47041.43076731835},{"$f":"BC34/$M$7","v":0.88158703342079914},null,{"$f":"BF34","v":51029.435844844324},{"$f":"BF34/$M$7","v":0.95632484449957611},null,{"$f":"BI34","v":55183.176192022933},{"$f":"BI34/$M$7","v":1.034168642414276},null,{"$f":"BL34","v":59509.467671636812},{"$f":"BL34/$M$7","v":1.1152461608701181},null,{"$f":"BO34","v":64015.404374539823},{"$f":"BO34/$M$7","v":1.1996903477474854},null,{"$f":"BR34","v":68708.369916586671},{"$f":"BR34/$M$7","v":1.2876395768137372},null,{"$f":"BU34","v":73596.049192473904},{"$f":"BU34/$M$7","v":1.3792378679978423},null,{"$f":"BX34","v":78686.440604919946},{"$f":"BX34/$M$7","v":1.4746351165731717},null,{"$f":"CA34","v":83987.868788352876},{"$f":"CA34/$M$7","v":1.5739873316076909},null,{"$f":"CD34","v":89508.997847046732},{"$f":"CD34/$M$7","v":1.6774568840552504},null,{"$f":"CG34","v":95258.845128449728},{"$f":"CG34/$M$7","v":1.7852127648767229},null,{"$f":"CJ34","v":101246.79555328106},{"$f":"CJ34/$M$7","v":1.8974308535953455},null,{"$f":"CM34","v":107482.61652484306},{"$f":"CM34/$M$7","v":2.0142941977069331},null,{"$f":"CP34","v":161455.94748540779},{"$f":"CP34/$M$7","v":3.0257895529549406}]
["Debt Paydown ",null,null,{"$f":"M3-$D$37","v":5613.5696756411344},{"$f":"(M3-D37)/M7","v":0.10520194978184207},null,{"$f":"D37-G37","v":6034.3533009832026},{"$f":"(D37-G37)/$M$7","v":0.11308770882289322},null,{"$f":"G37-J37","v":6486.6781504637329},{"$f":"(G37-J37)/$M$7","v":0.1215645709355373},null,{"$f":"J37-M37","v":6972.908500542515},{"$f":"(J37-M37)/$M$7","v":0.13067684419961739},null,{"$f":"M37-P37","v":7495.5858498179587},{"$f":"(M37-P37)/$M$7","v":0.14047215795321419},null,{"$f":"P37-S37","v":8057.44220329565},{"$f":"(P37-S37)/$M$7","v":0.15100171174848587},null,{"$f":"S37-V37","v":8661.4143524254905},{"$f":"(S37-V37)/$M$7","v":0.16232054296885934},null,{"$f":"V37-Y37","v":9310.6592255439609},{"$f":"(V37-Y37)/$M$7","v":0.17448781450631057},null,{"$f":"Y37-AB37","v":10008.570388960885},{"$f":"(Y37-AB37)/$M$7","v":0.18756712400247152},null,{"$f":"AB37-AE37","v":10758.795784938906},{"$f":"(AB37-AE37)/$M$7","v":0.20162683626991179},null,{"$f":"AE37-AH37","v":11565.256799281691},{"$f":"(AE37-AH37)/$M$7","v":0.21674044063115333},null,{"$f":"AH37-AK37","v":12432.168758196291},{"$f":"(AH37-AK37)/$M$7","v":0.23298693504321313},null,{"$f":"AK37-AN37","v":13364.062961565331},{"$f":"(AK37-AN37)/$M$7","v":0.25045123901546629},null,{"$f":"AN37-AQ37","v":14365.810367795697},{"$f":"(AN37-AQ37)/$M$7","v":0.26922463747912773},null,{"$f":"AQ37-AT37","v":15442.647054043307},{"$f":"(AQ37-AT37)/$M$7","v":0.28940525792843708},null,{"$f":"AT37-AW37","v":16600.201584892871},{"$f":"(AT37-AW37)/$M$7","v":0.31109858332753282},null,{"$f":"AW37-AZ37","v":17844.524432547274},{"$f":"(AW37-AZ37)/$M$7","v":0.33441800346395184},null,{"$f":"AZ37-BC37","v":19182.119602304301},{"$f":"(AZ37-BC37)/$M$7","v":0.35948540763064935},null,{"$f":"BC37-BF37","v":20619.978628625278},{"$f":"(BC37-BF37)/$M$7","v":0.38643182173445423},null,{"$f":"BF37-BI37","v":22165.617119491217},{"$f":"(BF37-BI37)/$M$7","v":0.41539809316109139},null,{"$f":"BI37-BL37","v":23827.114040061308},{"$f":"(BI37-BL37)/$M$7","v":0.44653562697651278},null,{"$f":"BL37-BO37","v":25613.153940968099},{"$f":"(BL37-BO37)/$M$7","v":0.48000717731263698},null,{"$f":"BO37-BR37","v":27533.072351973446},{"$f":"(BO37-BR37)/$M$7","v":0.51598769807400979},null,{"$f":"BR37-BU37","v":29596.904578255606},{"$f":"(BR37-BU37)/$M$7","v":0.55466525741198758},null,{"$f":"BU37-BX37","v":31815.438154383155},{"$f":"(BU37-BX37)/$M$7","v":0.59624202074635291},null,{"$f":"BX37-CA37","v":34200.269230149279},{"$f":"(BX37-CA37)/$M$7","v":0.64093530747255167},null,{"$f":"CA37-CD37","v":36763.863182992296},{"$f":"(CA37-CD37)/$M$7","v":0.6889787268779094},null,{"$f":"CD37-CG37","v":39519.619773820014},{"$f":"(CD37-CG37)/$M$7","v":0.74062339920419107},null,{"$f":"CG37-CJ37","v":42481.943186803808},{"$f":"(CG37-CJ37)/$M$7","v":0.79613926823893377},null,{"$f":"CJ37-CM37","v":45666.317319236201},{"$f":"(CJ37-CM37)/$M$7","v":0.85581651229638611},null,{"$f":"CM37-CP37","v":0},{"$f":"(CM37-CP37)/$M$7","v":0}]
["Cash Flow From Depreciation ",null,null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/2","v":4376.727272727273},{"$f":"(((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/2)/$M$7","v":8.2022718049132526E-2},null,0,0,null,0,0,null,0,0,null,0,0]
["Total Return on Investment",null,null,{"$f":"SUM(D41:D44)","v":57817.550176584933},{"$f":"SUM(E41:E44)","v":1.0835385256871382},null,{"$f":"SUM(G41:G44)","v":62387.153801927001},{"$f":"SUM(H41:H44)","v":1.1691758721339436},null,{"$f":"SUM(J41:J44)","v":67236.357251407535},{"$f":"SUM(K41:K44)","v":1.2600531012859841},null,{"$f":"SUM(M41:M44)","v":72322.445619486316},{"$f":"SUM(N41:N44)","v":1.3553697080088756},null,{"$f":"SUM(P41:P44)","v":77657.35733470181},{"$f":"SUM(Q41:Q44)","v":1.4553494262245512},null,{"$f":"SUM(S41:S44)","v":83253.658773043731},{"$f":"SUM(T41:T44)","v":1.5602277579989323},null,{"$f":"SUM(V41:V44)","v":89124.579044109938},{"$f":"SUM(W41:W44)","v":1.6702526254571535},null,{"$f":"SUM(Y41:Y44)","v":95284.046816246162},{"$f":"SUM(Z41:Z44)","v":1.78568506091065},null,{"$f":"SUM(AB41:AB44)","v":101746.72930700237},{"$f":"SUM(AC41:AC44)","v":1.9067999375636904},null,{"$f":"SUM(AE41:AE44)","v":108528.07357346658},{"$f":"SUM(AF41:AF44)","v":2.0338867433211112},null,{"$f":"SUM(AH41:AH44)","v":115644.35024580646},{"$f":"SUM(AI41:AI44)","v":2.1672504003833515},null,{"$f":"SUM(AK41:AK44)","v":123112.69985674413},{"$f":"SUM(AL41:AL44)","v":2.3072121334909692},null,{"$f":"SUM(AN41:AN44)","v":130951.18192969028},{"$f":"SUM(AO41:AO44)","v":2.4541103898682302},null,{"$f":"SUM(AQ41:AQ44)","v":139178.82699897038},{"$f":"SUM(AR41:AR44)","v":2.6083018141160048},null,{"$f":"SUM(AT41:AT44)","v":147815.69174700571},{"$f":"SUM(AU41:AU44)","v":2.7701622815184344},null,{"$f":"SUM(AW41:AW44)","v":156882.91745552153},{"$f":"SUM(AX41:AX44)","v":2.9400879934566158},null,{"$f":"SUM(AZ41:AZ44)","v":166402.79198090354},{"$f":"SUM(BA41:BA44)","v":3.1184966388671302},null,{"$f":"SUM(BC41:BC44)","v":176398.81547777329},{"$f":"SUM(BD41:BD44)","v":3.3058286259446215},null,{"$f":"SUM(BF41:BF44)","v":186895.77010975473},{"$f":"SUM(BG41:BG44)","v":3.5025483885669431},null,{"$f":"SUM(BI41:BI44)","v":197919.79400234079},{"$f":"SUM(BJ41:BJ44)","v":3.7091457722200127},null,{"$f":"SUM(BL41:BL44)","v":209498.45970979356},{"$f":"SUM(BM41:BM44)","v":3.9261375045185991},null,{"$f":"SUM(BO41:BO44)","v":221660.85748623527},{"$f":"SUM(BP41:BP44)","v":4.1540687557607727},null,{"$f":"SUM(BR41:BR44)","v":234437.68367055096},{"$f":"SUM(BS41:BS44)","v":4.3935147953185139},null,{"$f":"SUM(BU41:BU44)","v":247861.33451554761},{"$f":"SUM(BV41:BV44)","v":4.64508275005723},null,{"$f":"SUM(BX41:BX44)","v":261966.00581408938},{"$f":"SUM(BY41:BY44)","v":4.909413471394382},null,{"$f":"SUM(CA41:CA44)","v":276787.79869875469},{"$f":"SUM(CB41:CB44)","v":5.1871835180539225},null,{"$f":"SUM(CD41:CD44)","v":287988.10474430432},{"$f":"SUM(CE41:CE44)","v":5.3970845440014807},null,{"$f":"SUM(CG41:CG44)","v":299983.90716588462},{"$f":"SUM(CH41:CH44)","v":5.6218936898510607},null,{"$f":"SUM(CJ41:CJ44)","v":317194.4531168805},{"$f":"SUM(CK41:CK44)","v":5.9444305238929331},null,{"$f":"SUM(CM41:CM44)","v":335287.93393971492},{"$f":"SUM(CN41:CN44)","v":6.2835141321649122},null,{"$f":"SUM(CP41:CP44)","v":352701.89758582506},{"$f":"SUM(CQ41:CQ44)","v":6.6098631462246091}]
[]
[{"$f":"Inputs!A84","v":"This sheet is for informational purposes only.  This is not a commitment, approval or guarantee to lend.  The figures included in this worksheet are entirely dependent on the information that you input.  These figures and calculations are considered accurate, but not guaranteed.  Joe Massey and Castle & Cooke Mortgage do not represent, warrant or guarantee these numbers.   James Orr and Real Estate Financial Planner LLC do not represent, warrant or guarantee these numbers.  All information is for preliminary analysis and calculations only.  Please contact your tax advisor, CPA, financial planner, attorney, insurance agent, real estate agent or other properly licensed professional for additional information as needed.  "}]
[]
[]
[null,{"$f":"-M7","v":-53359.939500000037},null,{"$f":"D34*0.7","v":-559.63183115752179},null,null,{"$f":"G34*0.7","v":795.79216884247796},null,null,{"$f":"J34*0.7","v":2247.4196888424804},null,null,{"$f":"M34*0.7","v":3759.8234264424796},null,null,{"$f":"P51+P56","v":525276.59691386169},null,null,{"$f":"IRR(B50:P50)","v":0.58663127200541032},"IRR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P34*0.7","v":5335.5157638504825}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P36*0.93","v":1050443.5400156251},"Net Future value after 7% sales cost "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P52-P37","v":503046.57499307371},"Pre Tax Terminal Value "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P52-M2+M5+M6","v":-86196.459984374931},"Capital Gain Base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P54*0.196","v":-16894.506156937488},"Capital Gains Tax at 19.6%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P53-P55","v":519941.08115001122},"After Tax Terminal Value "]
[]
[]
[]
[null,null,"Year  0","Year 1","Year 2 ","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21","Year 22","Year 23","Year 24","Year 25","Year 26","Year 27","Year 28","Year 29","Year 30","Year 31"]
[null,"Annual Cash Flow Before Taxes",null,{"$f":"D34","v":-799.47404451074544},{"$f":"G34","v":1136.8459554892543},{"$f":"J34","v":3210.5995554892579},{"$f":"M34","v":5371.1763234892569},{"$f":"P34","v":7622.1653769292607},{"$f":"S34","v":9967.3028836684534},{"$f":"V34","v":12410.47804857367},{"$f":"Y34","v":14955.739342708453},{"$f":"AB34","v":17607.300984920963},{"$f":"AE34","v":20369.549686023674},{"$f":"AH34","v":23247.051666168263},{"$f":"AK34","v":26244.559956446319},{"$f":"AN34","v":29367.021996191033},{"$f":"AQ34","v":32619.587537916726},{"$f":"AT34","v":36007.616872314378},{"$f":"AW34","v":39536.689386220969},{"$f":"AZ34","v":43212.612467000814},{"$f":"BC34","v":47041.43076731835},{"$f":"BF34","v":51029.435844844324},{"$f":"BI34","v":55183.176192022933},{"$f":"BL34","v":59509.467671636812},{"$f":"BO34","v":64015.404374539823},{"$f":"BR34","v":68708.369916586671},{"$f":"BU34","v":73596.049192473904},{"$f":"BX34","v":78686.440604919946},{"$f":"CA34","v":83987.868788352876},{"$f":"CD34","v":89508.997847046732},{"$f":"CG34","v":95258.845128449728},{"$f":"CJ34","v":101246.79555328106},{"$f":"CM34","v":107482.61652484306},{"$f":"CP34","v":161455.94748540779}]
[]
[]
[null,"ROI QuadrantTM",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]
[null,"Appreciation",0,{"$f":"D41","v":44250},{"$f":"G41","v":46462.5},{"$f":"J41","v":48785.625},{"$f":"M41","v":51224.90625},{"$f":"P41","v":53786.151562500047},{"$f":"S41","v":56475.459140625084},{"$f":"V41","v":59299.232097656233},{"$f":"Y41","v":62264.193702539196},{"$f":"AB41","v":65377.403387665981},{"$f":"AE41","v":68646.273557049455},{"$f":"AH41","v":72078.587234901963},{"$f":"AK41","v":75682.516596646979},{"$f":"AN41","v":79466.642426479375},{"$f":"AQ41","v":83439.974547803402},{"$f":"AT41","v":87611.973275193479},{"$f":"AW41","v":91992.57193895313},{"$f":"AZ41","v":96592.200535900891},{"$f":"BC41","v":101421.81056269608},{"$f":"BF41","v":106492.90109083056},{"$f":"BI41","v":111817.54614537209},{"$f":"BL41","v":117408.42345264088},{"$f":"BO41","v":123278.84462527279},{"$f":"BR41","v":129442.78685653629},{"$f":"BU41","v":135914.92619936354},{"$f":"BX41","v":142710.67250933172},{"$f":"CA41","v":149846.20613479801},{"$f":"CD41","v":157338.516441538},{"$f":"CG41","v":165205.44226361485},{"$f":"CJ41","v":173465.71437679557},{"$f":"CM41","v":182139.00009563565},{"$f":"CP41","v":191245.95010041725}]
[null,"Cash Flow ",0,{"$f":"D42","v":-799.47404451074544},{"$f":"G42","v":1136.8459554892543},{"$f":"J42","v":3210.5995554892579},{"$f":"M42","v":5371.1763234892569},{"$f":"P42","v":7622.1653769292607},{"$f":"S42","v":9967.3028836684534},{"$f":"V42","v":12410.47804857367},{"$f":"Y42","v":14955.739342708453},{"$f":"AB42","v":17607.300984920963},{"$f":"AE42","v":20369.549686023674},{"$f":"AH42","v":23247.051666168263},{"$f":"AK42","v":26244.559956446319},{"$f":"AN42","v":29367.021996191033},{"$f":"AQ42","v":32619.587537916726},{"$f":"AT42","v":36007.616872314378},{"$f":"AW42","v":39536.689386220969},{"$f":"AZ42","v":43212.612467000814},{"$f":"BC42","v":47041.43076731835},{"$f":"BF42","v":51029.435844844324},{"$f":"BI42","v":55183.176192022933},{"$f":"BL42","v":59509.467671636812},{"$f":"BO42","v":64015.404374539823},{"$f":"BR42","v":68708.369916586671},{"$f":"BU42","v":73596.049192473904},{"$f":"BX42","v":78686.440604919946},{"$f":"CA42","v":83987.868788352876},{"$f":"CD42","v":89508.997847046732},{"$f":"CG42","v":95258.845128449728},{"$f":"CJ42","v":101246.79555328106},{"$f":"CM42","v":107482.61652484306},{"$f":"CP42","v":161455.94748540779}]
[null,"Debt Paydown ",0,5613.5696756411344,6034.3533009832026,6486.6781504637329,6972.908500542515,7495.5858498179587,8057.44220329565,8661.4143524254905,9310.6592255439609,10008.570388960885,10758.795784938906,11565.256799281691,12432.168758196291,13364.062961565331,14365.810367795697,15442.647054043307,16600.201584892871,17844.524432547274,19182.119602304301,20619.978628625278,22165.617119491217,23827.114040061308,25613.153940968099,27533.072351973446,29596.904578255606,31815.438154383155,34200.269230149279,36763.863182992296,39519.619773820014,42481.943186803808,45666.317319236201,0]
[null,"Depreciation",0,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,4376.727272727273,0,0,0,0]
[null,"Total Return on Investment",0,57817.550176584933,62387.153801927001,67236.357251407535,72322.445619486316,77657.35733470181,83253.658773043731,89124.579044109938,95284.046816246162,101746.72930700237,108528.07357346658,115644.35024580646,123112.69985674413,130951.18192969028,139178.82699897038,147815.69174700571,156882.91745552153,166402.79198090354,176398.81547777329,186895.77010975473,197919.79400234079,209498.45970979356,221660.85748623527,234437.68367055096,247861.33451554761,261966.00581408938,276787.79869875469,287988.10474430432,299983.90716588462,317194.4531168805,335287.93393971492,352701.89758582506]
[]
[null,null,"Positive Cash Flow Achieved in Year #",{"$f":"MATCH(TRUE,D61:AH61>0,0)","v":2}]
[]
[]
[]
[null,"ROI QuadrantTM",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]
[null,"Appreciation",0,{"$f":"E41","v":0.82927380380556781},{"$f":"H41","v":0.87073749399584621},{"$f":"K41","v":0.9142743686956385},{"$f":"N41","v":0.9599880871304205},{"$f":"Q41","v":1.0079874914869424},{"$f":"T41","v":1.0583868660612901},{"$f":"W41","v":1.1113062093643526},{"$f":"Z41","v":1.1668715198325732},{"$f":"AC41","v":1.2252150958241985},{"$f":"AF41","v":1.2864758506154117},{"$f":"AI41","v":1.3507996431461831},{"$f":"AL41","v":1.4183396253034906},{"$f":"AO41","v":1.4892566065686661},{"$f":"AR41","v":1.5637194368971004},{"$f":"AU41","v":1.6419054087419536},{"$f":"AX41","v":1.724000679179051},{"$f":"BA41","v":1.8102007131380053},{"$f":"BD41","v":1.9007107487949082},{"$f":"BG41","v":1.9957462862346478},{"$f":"BJ41","v":2.0955336005463803},{"$f":"BM41","v":2.2003102805737029},{"$f":"BP41","v":2.3103257946023854},{"$f":"BS41","v":2.4258420843325017},{"$f":"BV41","v":2.5471341885491352},{"$f":"BY41","v":2.6744908979765922},{"$f":"CB41","v":2.808215442875416},{"$f":"CE41","v":2.9486262150191886},{"$f":"CH41","v":3.096057525770147},{"$f":"CK41","v":3.2508604020586538},{"$f":"CN41","v":3.4134034221615925},{"$f":"CQ41","v":3.5840735932696686}]
[null,"Cash Flow ",0,{"$f":"E42","v":-1.4982663998536672E-2},{"$f":"H42","v":2.1305233216938963E-2},{"$f":"K42","v":6.0168725556543325E-2},{"$f":"N42","v":0.10065934058057269},{"$f":"Q42","v":0.14284434068612945},{"$f":"T42","v":0.18679374409089139},{"$f":"W42","v":0.23258043702567657},{"$f":"Z42","v":0.28028029047350106},{"$f":"AC42","v":0.32997228163875542},{"$f":"AF42","v":0.38173862033752232},{"$f":"AI42","v":0.4356648805077496},{"$f":"AL42","v":0.4918401370460006},{"$f":"AO42","v":0.55035710818583317},{"$f":"AR42","v":0.6113123036415119},{"$f":"AU42","v":0.67480617874977822},{"$f":"AX42","v":0.74094329485176691},{"$f":"BA42","v":0.80983248616690773},{"$f":"BD42","v":0.88158703342079914},{"$f":"BG42","v":0.95632484449957611},{"$f":"BJ42","v":1.034168642414276},{"$f":"BM42","v":1.1152461608701181},{"$f":"BP42","v":1.1996903477474854},{"$f":"BS42","v":1.2876395768137372},{"$f":"BV42","v":1.3792378679978423},{"$f":"BY42","v":1.4746351165731717},{"$f":"CB42","v":1.5739873316076909},{"$f":"CE42","v":1.6774568840552504},{"$f":"CH42","v":1.7852127648767229},{"$f":"CK42","v":1.8974308535953455},{"$f":"CN42","v":2.0142941977069331},{"$f":"CQ42","v":3.0257895529549406}]
[null,"Debt Paydown ",0,{"$f":"E43","v":0.10520194978184207},{"$f":"H43","v":0.11308770882289322},{"$f":"K43","v":0.1215645709355373},{"$f":"N43","v":0.13067684419961739},{"$f":"Q43","v":0.14047215795321419},{"$f":"T43","v":0.15100171174848587},{"$f":"W43","v":0.16232054296885934},{"$f":"Z43","v":0.17448781450631057},{"$f":"AC43","v":0.18756712400247152},{"$f":"AF43","v":0.20162683626991179},{"$f":"AI43","v":0.21674044063115333},{"$f":"AL43","v":0.23298693504321313},{"$f":"AO43","v":0.25045123901546629},{"$f":"AR43","v":0.26922463747912773},{"$f":"AU43","v":0.28940525792843708},{"$f":"AX43","v":0.31109858332753282},{"$f":"BA43","v":0.33441800346395184},{"$f":"BD43","v":0.35948540763064935},{"$f":"BG43","v":0.38643182173445423},{"$f":"BJ43","v":0.41539809316109139},{"$f":"BM43","v":0.44653562697651278},{"$f":"BP43","v":0.48000717731263698},{"$f":"BS43","v":0.51598769807400979},{"$f":"BV43","v":0.55466525741198758},{"$f":"BY43","v":0.59624202074635291},{"$f":"CB43","v":0.64093530747255167},{"$f":"CE43","v":0.6889787268779094},{"$f":"CH43","v":0.74062339920419107},{"$f":"CK43","v":0.79613926823893377},{"$f":"CN43","v":0.85581651229638611},{"$f":"CQ43","v":0}]
[null,"Depreciation",0,{"$f":"E44","v":0.16404543609826505},{"$f":"H44","v":0.16404543609826505},{"$f":"K44","v":0.16404543609826505},{"$f":"N44","v":0.16404543609826505},{"$f":"Q44","v":0.16404543609826505},{"$f":"T44","v":0.16404543609826505},{"$f":"W44","v":0.16404543609826505},{"$f":"Z44","v":0.16404543609826505},{"$f":"AC44","v":0.16404543609826505},{"$f":"AF44","v":0.16404543609826505},{"$f":"AI44","v":0.16404543609826505},{"$f":"AL44","v":0.16404543609826505},{"$f":"AO44","v":0.16404543609826505},{"$f":"AR44","v":0.16404543609826505},{"$f":"AU44","v":0.16404543609826505},{"$f":"AX44","v":0.16404543609826505},{"$f":"BA44","v":0.16404543609826505},{"$f":"BD44","v":0.16404543609826505},{"$f":"BG44","v":0.16404543609826505},{"$f":"BJ44","v":0.16404543609826505},{"$f":"BM44","v":0.16404543609826505},{"$f":"BP44","v":0.16404543609826505},{"$f":"BS44","v":0.16404543609826505},{"$f":"BV44","v":0.16404543609826505},{"$f":"BY44","v":0.16404543609826505},{"$f":"CB44","v":0.16404543609826505},{"$f":"CE44","v":8.2022718049132526E-2},{"$f":"CH44","v":0},{"$f":"CK44","v":0},{"$f":"CN44","v":0},{"$f":"CQ44","v":0}]
[null,"Total Return on Investment",0,{"$f":"E45","v":1.0835385256871382},{"$f":"H45","v":1.1691758721339436},{"$f":"K45","v":1.2600531012859841},{"$f":"N45","v":1.3553697080088756},{"$f":"Q45","v":1.4553494262245512},{"$f":"T45","v":1.5602277579989323},{"$f":"W45","v":1.6702526254571535},{"$f":"Z45","v":1.78568506091065},{"$f":"AC45","v":1.9067999375636904},{"$f":"AF45","v":2.0338867433211112},{"$f":"AI45","v":2.1672504003833515},{"$f":"AL45","v":2.3072121334909692},{"$f":"AO45","v":2.4541103898682302},{"$f":"AR45","v":2.6083018141160048},{"$f":"AU45","v":2.7701622815184344},{"$f":"AX45","v":2.9400879934566158},{"$f":"BA45","v":3.1184966388671302},{"$f":"BD45","v":3.3058286259446215},{"$f":"BG45","v":3.5025483885669431},{"$f":"BJ45","v":3.7091457722200127},{"$f":"BM45","v":3.9261375045185991},{"$f":"BP45","v":4.1540687557607727},{"$f":"BS45","v":4.3935147953185139},{"$f":"BV45","v":4.64508275005723},{"$f":"BY45","v":4.909413471394382},{"$f":"CB45","v":5.1871835180539225},{"$f":"CE45","v":5.3970845440014807},{"$f":"CH45","v":5.6218936898510607},{"$f":"CK45","v":5.9444305238929331},{"$f":"CN45","v":6.2835141321649122},{"$f":"CQ45","v":6.6098631462246091}]
[]
[null,null,"100%+ ROIQ Achieved in Year #",{"$f":"MATCH(TRUE,D80:AH80>1,0)","v":1}]

{"sheet":"Long-Term with CF to Principal","index":3,"n_rows":83,"n_cols":95,"rows_kept":83,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,1,2,2],[4,0,4,2],[46,0,48,15]]}
["Cash Flow Analysis for ",null,null,{"$f":"Inputs!B16","v":"Sample Property"},null,null,"Cash Investment Breakdown"]
[null,null,null,null,null,null,"Purchase Price",null,null,null,null,null,{"$f":"Inputs!B24","v":885000}]
[null,"Number of Units ",null,{"$f":"Inputs!B17","v":2},null,null,"Mortgage",null,null,null,null,null,{"$f":"Inputs!B29","v":580000.06049999991}]
[null,null,null,null,null,null,"Down Payment",null,null,null,null,null,{"$f":"Inputs!B28","v":304999.93950000004}]
["Annual Rent Increase",null,null,{"$f":"'Long-Term Analysis'!D5","v":0.04},null,null,"Net Closing Costs paid by Buyer",null,null,null,null,null,{"$f":"Inputs!B25+Inputs!B26+Inputs!B27-IF((Inputs!B25+Inputs!B26+Inputs!B27)>Inputs!B31,Inputs!B31,(Inputs!B25+Inputs!B26+Inputs!B27))","v":55050}]
[null,null,null,null,null,null,"Repair Costs",null,null,null,null,null,{"$f":"Inputs!B32","v":-306690}]
["Annual Cash Flow Statement ",null,null,null,null,null,"Total Cash Investment ",null,null,null,null,null,{"$f":"Inputs!B33","v":53359.939500000037}]
[]
["Annual Income",null,null,"Year 1",null,null,"Year 2",null,null,"Year 3",null,null,"Year 4",null,null,"Year 5",null,null,"Year 6",null,null,"Year 7",null,null,"Year 8",null,null,"Year 9",null,null,"Year 10",null,null,"Year 11",null,null,"Year 12",null,null,"Year 13",null,null,"Year 14",null,null,"Year 15",null,null,"Year 16",null,null,"Year 17",null,null,"Year 18",null,null,"Year 19",null,null,"Year 20",null,null,"Year 21",null,null,"Year 22",null,null,"Year 23",null,null,"Year 24",null,null,"Year 25",null,null,"Year 26",null,null,"Year 27",null,null,"Year 28",null,null,"Year 29",null,null,"Year 30",null,null,"Year 31"]
["Annual Rental Income",null,null,{"$f":"Inputs!B43*12","v":69600},null,null,{"$f":"D10*(1+$D$5)","v":72384},null,null,{"$f":"G10*(1+$D$5)","v":75279.360000000001},null,null,{"$f":"J10*(1+$D$5)","v":78290.534400000004},null,null,{"$f":"M10*(1+$D$5)","v":81422.155776000014},null,null,{"$f":"P10*(1+$D$5)","v":84679.042007040014},null,null,{"$f":"S10*(1+$D$5)","v":88066.203687321613},null,null,{"$f":"V10*(1+$D$5)","v":91588.851834814486},null,null,{"$f":"Y10*(1+$D$5)","v":95252.405908207074},null,null,{"$f":"AB10*(1+$D$5)","v":99062.502144535363},null,null,{"$f":"AE10*(1+$D$5)","v":103025.00223031678},null,null,{"$f":"AH10*(1+$D$5)","v":107146.00231952945},null,null,{"$f":"AK10*(1+$D$5)","v":111431.84241231064},null,null,{"$f":"AN10*(1+$D$5)","v":115889.11610880306},null,null,{"$f":"AQ10*(1+$D$5)","v":120524.68075315519},null,null,{"$f":"AT10*(1+$D$5)","v":125345.6679832814},null,null,{"$f":"AW10*(1+$D$5)","v":130359.49470261266},null,null,{"$f":"AZ10*(1+$D$5)","v":135573.87449071716},null,null,{"$f":"BC10*(1+$D$5)","v":140996.82947034587},null,null,{"$f":"BF10*(1+$D$5)","v":146636.70264915971},null,null,{"$f":"BI10*(1+$D$5)","v":152502.17075512611},null,null,{"$f":"BL10*(1+$D$5)","v":158602.25758533116},null,null,{"$f":"BO10*(1+$D$5)","v":164946.34788874441},null,null,{"$f":"BR10*(1+$D$5)","v":171544.20180429419},null,null,{"$f":"BU10*(1+$D$5)","v":178405.96987646597},null,null,{"$f":"BX10*(1+$D$5)","v":185542.20867152463},null,null,{"$f":"CA10*(1+$D$5)","v":192963.89701838561},null,null,{"$f":"CD10*(1+$D$5)","v":200682.45289912104},null,null,{"$f":"CG10*(1+$D$5)","v":208709.7510150859},null,null,{"$f":"CJ10*(1+$D$5)","v":217058.14105568934},null,null,{"$f":"CM10*(1+$D$5)","v":225740.46669791691}]
[" - Vacancy",{"$f":"Inputs!B45","v":0.05},null,{"$f":"-D10*Inputs!B45","v":-3480},null,null,{"$f":"-G10*Inputs!$B$45","v":-3619.2000000000003},null,null,{"$f":"-J10*Inputs!$B$45","v":-3763.9680000000003},null,null,{"$f":"-M10*Inputs!$B$45","v":-3914.5267200000003},null,null,{"$f":"-P10*Inputs!$B$45","v":-4071.1077888000009},null,null,{"$f":"-S10*Inputs!$B$45","v":-4233.9521003520013},null,null,{"$f":"-V10*Inputs!$B$45","v":-4403.3101843660806},null,null,{"$f":"-Y10*Inputs!$B$45","v":-4579.4425917407243},null,null,{"$f":"-AB10*Inputs!$B$45","v":-4762.6202954103537},null,null,{"$f":"-AE10*Inputs!$B$45","v":-4953.1251072267687},null,null,{"$f":"-AH10*Inputs!$B$45","v":-5151.2501115158393},null,null,{"$f":"-AK10*Inputs!$B$45","v":-5357.3001159764726},null,null,{"$f":"-AN10*Inputs!$B$45","v":-5571.5921206155326},null,null,{"$f":"-AQ10*Inputs!$B$45","v":-5794.4558054401532},null,null,{"$f":"-AT10*Inputs!$B$45","v":-6026.2340376577595},null,null,{"$f":"-AW10*Inputs!$B$45","v":-6267.28339916407},null,null,{"$f":"-AZ10*Inputs!$B$45","v":-6517.9747351306332},null,null,{"$f":"-BC10*Inputs!$B$45","v":-6778.6937245358586},null,null,{"$f":"-BF10*Inputs!$B$45","v":-7049.8414735172937},null,null,{"$f":"-BI10*Inputs!$B$45","v":-7331.8351324579853},null,null,{"$f":"-BL10*Inputs!$B$45","v":-7625.1085377563059},null,null,{"$f":"-BO10*Inputs!$B$45","v":-7930.1128792665586},null,null,{"$f":"-BR10*Inputs!$B$45","v":-8247.3173944372211},null,null,{"$f":"-BU10*Inputs!$B$45","v":-8577.2100902147104},null,null,{"$f":"-BX10*Inputs!$B$45","v":-8920.2984938232985},null,null,{"$f":"-CA10*Inputs!$B$45","v":-9277.110433576232},null,null,{"$f":"-CD10*Inputs!$B$45","v":-9648.1948509192807},null,null,{"$f":"-CG10*Inputs!$B$45","v":-10034.122644956053},null,null,{"$f":"-CJ10*Inputs!$B$45","v":-10435.487550754297},null,null,{"$f":"-CM10*Inputs!$B$45","v":-10852.907052784467},null,null,{"$f":"-CP10*Inputs!$B$45","v":-11287.023334895846}]
["Expected Annual Rental Income",null,null,{"$f":"SUM(D10:D11)","v":66120},null,null,{"$f":"SUM(G10:G11)","v":68764.800000000003},null,null,{"$f":"SUM(J10:J11)","v":71515.392000000007},null,null,{"$f":"SUM(M10:M11)","v":74376.00768000001},null,null,{"$f":"SUM(P10:P11)","v":77351.047987200014},null,null,{"$f":"SUM(S10:S11)","v":80445.089906688008},null,null,{"$f":"SUM(V10:V11)","v":83662.893502955529},null,null,{"$f":"SUM(Y10:Y11)","v":87009.409243073766},null,null,{"$f":"SUM(AB10:AB11)","v":90489.785612796724},null,null,{"$f":"SUM(AE10:AE11)","v":94109.377037308601},null,null,{"$f":"SUM(AH10:AH11)","v":97873.752118800941},null,null,{"$f":"SUM(AK10:AK11)","v":101788.70220355298},null,null,{"$f":"SUM(AN10:AN11)","v":105860.25029169511},null,null,{"$f":"SUM(AQ10:AQ11)","v":110094.66030336291},null,null,{"$f":"SUM(AT10:AT11)","v":114498.44671549743},null,null,{"$f":"SUM(AW10:AW11)","v":119078.38458411733},null,null,{"$f":"SUM(AZ10:AZ11)","v":123841.51996748203},null,null,{"$f":"SUM(BC10:BC11)","v":128795.18076618131},null,null,{"$f":"SUM(BF10:BF11)","v":133946.98799682857},null,null,{"$f":"SUM(BI10:BI11)","v":139304.86751670172},null,null,{"$f":"SUM(BL10:BL11)","v":144877.06221736979},null,null,{"$f":"SUM(BO10:BO11)","v":150672.1447060646},null,null,{"$f":"SUM(BR10:BR11)","v":156699.0304943072},null,null,{"$f":"SUM(BU10:BU11)","v":162966.99171407949},null,null,{"$f":"SUM(BX10:BX11)","v":169485.67138264267},null,null,{"$f":"SUM(CA10:CA11)","v":176265.0982379484},null,null,{"$f":"SUM(CD10:CD11)","v":183315.70216746634},null,null,{"$f":"SUM(CG10:CG11)","v":190648.33025416499},null,null,{"$f":"SUM(CJ10:CJ11)","v":198274.2634643316},null,null,{"$f":"SUM(CM10:CM11)","v":206205.23400290488},null,null,{"$f":"SUM(CP10:CP11)","v":214453.44336302107}]
[]
["Annual Expenses"]
["Property Management",null,null,{"$f":"Inputs!B59","v":6960},null,null,{"$f":"(G10*Inputs!$B$57)","v":7238.4000000000005},null,null,{"$f":"J10*Inputs!$B$57","v":7527.9360000000006},null,null,{"$f":"M10*Inputs!$B$57","v":7829.0534400000006},null,null,{"$f":"P10*Inputs!$B$57","v":8142.2155776000018},null,null,{"$f":"S10*Inputs!$B$57","v":8467.9042007040025},null,null,{"$f":"V10*Inputs!$B$57","v":8806.6203687321613},null,null,{"$f":"Y10*Inputs!$B$57","v":9158.8851834814486},null,null,{"$f":"AB10*Inputs!$B$57","v":9525.2405908207074},null,null,{"$f":"AE10*Inputs!$B$57","v":9906.2502144535374},null,null,{"$f":"AH10*Inputs!$B$57","v":10302.500223031679},null,null,{"$f":"AK10*Inputs!$B$57","v":10714.600231952945},null,null,{"$f":"AN10*Inputs!$B$57","v":11143.184241231065},null,null,{"$f":"AQ10*Inputs!$B$57","v":11588.911610880306},null,null,{"$f":"AT10*Inputs!$B$57","v":12052.468075315519},null,null,{"$f":"AW10*Inputs!$B$57","v":12534.56679832814},null,null,{"$f":"AZ10*Inputs!$B$57","v":13035.949470261266},null,null,{"$f":"BC10*Inputs!$B$57","v":13557.387449071717},null,null,{"$f":"BF10*Inputs!$B$57","v":14099.682947034587},null,null,{"$f":"BI10*Inputs!$B$57","v":14663.670264915971},null,null,{"$f":"BL10*Inputs!$B$57","v":15250.217075512612},null,null,{"$f":"BO10*Inputs!$B$57","v":15860.225758533117},null,null,{"$f":"BR10*Inputs!$B$57","v":16494.634788874442},null,null,{"$f":"BU10*Inputs!$B$57","v":17154.420180429421},null,null,{"$f":"BX10*Inputs!$B$57","v":17840.596987646597},null,null,{"$f":"CA10*Inputs!$B$57","v":18554.220867152464},null,null,{"$f":"CD10*Inputs!$B$57","v":19296.389701838561},null,null,{"$f":"CG10*Inputs!$B$57","v":20068.245289912105},null,null,{"$f":"CJ10*Inputs!$B$57","v":20870.975101508593},null,null,{"$f":"CM10*Inputs!$B$57","v":21705.814105568934},null,null,{"$f":"CP10*Inputs!$B$57","v":22574.046669791693}]
["Reserves for Repairs and Maintenance",null,null,{"$f":"Inputs!B62","v":5568},null,null,{"$f":"G10*Inputs!B60","v":5790.72},null,null,{"$f":"G16*(1.03)","v":5964.4416000000001},null,null,{"$f":"J16*(1.03)","v":6143.3748480000004},null,null,{"$f":"M16*(1.03)","v":6327.6760934400008},null,null,{"$f":"P16*(1.03)","v":6517.506376243201},null,null,{"$f":"S16*(1.03)","v":6713.0315675304973},null,null,{"$f":"V16*(1.03)","v":6914.4225145564124},null,null,{"$f":"Y16*(1.03)","v":7121.8551899931053},null,null,{"$f":"AB16*(1.03)","v":7335.5108456928983},null,null,{"$f":"AE16*(1.03)","v":7555.5761710636853},null,null,{"$f":"AH16*(1.03)","v":7782.2434561955961},null,null,{"$f":"AK16*(1.03)","v":8015.7107598814646},null,null,{"$f":"AN16*(1.03)","v":8256.1820826779094},null,null,{"$f":"AQ16*(1.03)","v":8503.8675451582476},null,null,{"$f":"AT16*(1.03)","v":8758.9835715129957},null,null,{"$f":"AW16*(1.03)","v":9021.7530786583866},null,null,{"$f":"AZ16*(1.03)","v":9292.4056710181376},null,null,{"$f":"BC16*(1.03)","v":9571.1778411486812},null,null,{"$f":"BF16*(1.03)","v":9858.3131763831425},null,null,{"$f":"BI16*(1.03)","v":10154.062571674636},null,null,{"$f":"BL16*(1.03)","v":10458.684448824875},null,null,{"$f":"BO16*(1.03)","v":10772.444982289622},null,null,{"$f":"BR16*(1.03)","v":11095.618331758311},null,null,{"$f":"BU16*(1.03)","v":11428.48688171106},null,null,{"$f":"BX16*(1.03)","v":11771.341488162392},null,null,{"$f":"CA16*(1.03)","v":12124.481732807264},null,null,{"$f":"CD16*(1.03)","v":12488.216184791483},null,null,{"$f":"CG16*(1.03)","v":12862.862670335227},null,null,{"$f":"CJ16*(1.03)","v":13248.748550445285},null,null,{"$f":"CM16*(1.03)","v":13646.211006958643}]
["HOA Dues ",null,null,{"$f":"Inputs!B67","v":0},null,null,{"$f":"D17*(1.03)","v":0},null,null,{"$f":"G17*(1.03)","v":0},null,null,{"$f":"J17*(1.03)","v":0},null,null,{"$f":"M17*(1.03)","v":0},null,null,{"$f":"P17*(1.03)","v":0},null,null,{"$f":"S17*(1.03)","v":0},null,null,{"$f":"V17*(1.03)","v":0},null,null,{"$f":"Y17*(1.03)","v":0},null,null,{"$f":"AB17*(1.03)","v":0},null,null,{"$f":"AE17*(1.03)","v":0},null,null,{"$f":"AH17*(1.03)","v":0},null,null,{"$f":"AK17*(1.03)","v":0},null,null,{"$f":"AN17*(1.03)","v":0},null,null,{"$f":"AQ17*(1.03)","v":0},null,null,{"$f":"AT17*(1.03)","v":0},null,null,{"$f":"AW17*(1.03)","v":0},null,null,{"$f":"AZ17*(1.03)","v":0},null,null,{"$f":"BC17*(1.03)","v":0},null,null,{"$f":"BF17*(1.03)","v":0},null,null,{"$f":"BI17*(1.03)","v":0},null,null,{"$f":"BL17*(1.03)","v":0},null,null,{"$f":"BO17*(1.03)","v":0},null,null,{"$f":"BR17*(1.03)","v":0},null,null,{"$f":"BU17*(1.03)","v":0},null,null,{"$f":"BX17*(1.03)","v":0},null,null,{"$f":"CA17*(1.03)","v":0},null,null,{"$f":"CD17*(1.03)","v":0},null,null,{"$f":"CG17*(1.03)","v":0},null,null,{"$f":"CJ17*(1.03)","v":0},null,null,{"$f":"CM17*(1.03)","v":0}]
["Real Estate Taxes",null,null,{"$f":"Inputs!B70","v":4488},null,null,{"$f":"D18*(1.03)","v":4622.6400000000003},null,null,{"$f":"G18*(1.03)","v":4761.3192000000008},null,null,{"$f":"J18*(1.03)","v":4904.1587760000011},null,null,{"$f":"M18*(1.03)","v":5051.2835392800016},null,null,{"$f":"P18*(1.03)","v":5202.8220454584016},null,null,{"$f":"S18*(1.03)","v":5358.9067068221539},null,null,{"$f":"V18*(1.03)","v":5519.6739080268189},null,null,{"$f":"Y18*(1.03)","v":5685.264125267624},null,null,{"$f":"AB18*(1.03)","v":5855.8220490256526},null,null,{"$f":"AE18*(1.03)","v":6031.4967104964226},null,null,{"$f":"AH18*(1.03)","v":6212.4416118113159},null,null,{"$f":"AK18*(1.03)","v":6398.8148601656558},null,null,{"$f":"AN18*(1.03)","v":6590.7793059706255},null,null,{"$f":"AQ18*(1.03)","v":6788.5026851497441},null,null,{"$f":"AT18*(1.03)","v":6992.1577657042362},null,null,{"$f":"AW18*(1.03)","v":7201.9224986753634},null,null,{"$f":"AZ18*(1.03)","v":7417.9801736356249},null,null,{"$f":"BC18*(1.03)","v":7640.5195788446936},null,null,{"$f":"BF18*(1.03)","v":7869.7351662100345},null,null,{"$f":"BI18*(1.03)","v":8105.8272211963358},null,null,{"$f":"BL18*(1.03)","v":8349.0020378322261},null,null,{"$f":"BO18*(1.03)","v":8599.4720989671932},null,null,{"$f":"BR18*(1.03)","v":8857.4562619362096},null,null,{"$f":"BU18*(1.03)","v":9123.1799497942957},null,null,{"$f":"BX18*(1.03)","v":9396.8753482881257},null,null,{"$f":"CA18*(1.03)","v":9678.7816087367701},null,null,{"$f":"CD18*(1.03)","v":9969.1450569988738},null,null,{"$f":"CG18*(1.03)","v":10268.219408708841},null,null,{"$f":"CJ18*(1.03)","v":10576.265990970107},null,null,{"$f":"CM18*(1.03)","v":10893.553970699211}]
["Property Insurance",null,null,{"$f":"Inputs!B71","v":2424},null,null,{"$f":"D19*1.03","v":2496.7200000000003},null,null,{"$f":"G19*1.03","v":2571.6216000000004},null,null,{"$f":"J19*1.03","v":2648.7702480000003},null,null,{"$f":"M19*1.03","v":2728.2333554400002},null,null,{"$f":"P19*1.03","v":2810.0803561032003},null,null,{"$f":"S19*1.03","v":2894.3827667862965},null,null,{"$f":"V19*1.03","v":2981.2142497898853},null,null,{"$f":"Y19*1.03","v":3070.6506772835819},null,null,{"$f":"AB19*1.03","v":3162.7701976020894},null,null,{"$f":"AE19*1.03","v":3257.6533035301522},null,null,{"$f":"AH19*1.03","v":3355.3829026360568},null,null,{"$f":"AK19*1.03","v":3456.0443897151385},null,null,{"$f":"AN19*1.03","v":3559.7257214065926},null,null,{"$f":"AQ19*1.03","v":3666.5174930487906},null,null,{"$f":"AT19*1.03","v":3776.5130178402542},null,null,{"$f":"AW19*1.03","v":3889.808408375462},null,null,{"$f":"AZ19*1.03","v":4006.5026606267261},null,null,{"$f":"BC19*1.03","v":4126.6977404455283},null,null,{"$f":"BF19*1.03","v":4250.4986726588941},null,null,{"$f":"BI19*1.03","v":4378.0136328386607},null,null,{"$f":"BL19*1.03","v":4509.3540418238208},null,null,{"$f":"BO19*1.03","v":4644.6346630785356},null,null,{"$f":"BR19*1.03","v":4783.9737029708922},null,null,{"$f":"BU19*1.03","v":4927.4929140600188},null,null,{"$f":"BX19*1.03","v":5075.3177014818193},null,null,{"$f":"CA19*1.03","v":5227.5772325262742},null,null,{"$f":"CD19*1.03","v":5384.4045495020628},null,null,{"$f":"CG19*1.03","v":5545.9366859871252},null,null,{"$f":"CJ19*1.03","v":5712.3147865667388},null,null,{"$f":"CM19*1.03","v":5883.6842301637407}]
["Utilities (If paid by owner) "]
[" - Water and Sewer",null,null,{"$f":"Inputs!B73","v":0},null,null,{"$f":"D21*1.03","v":0},null,null,{"$f":"G21*1.03","v":0},null,null,{"$f":"J21*1.03","v":0},null,null,{"$f":"M21*1.03","v":0},null,null,{"$f":"P21*1.03","v":0},null,null,{"$f":"S21*1.03","v":0},null,null,{"$f":"V21*1.03","v":0},null,null,{"$f":"Y21*1.03","v":0},null,null,{"$f":"AB21*1.03","v":0},null,null,{"$f":"AE21*1.03","v":0},null,null,{"$f":"AH21*1.03","v":0},null,null,{"$f":"AK21*1.03","v":0},null,null,{"$f":"AN21*1.03","v":0},null,null,{"$f":"AQ21*1.03","v":0},null,null,{"$f":"AT21*1.03","v":0},null,null,{"$f":"AW21*1.03","v":0},null,null,{"$f":"AZ21*1.03","v":0},null,null,{"$f":"BC21*1.03","v":0},null,null,{"$f":"BF21*1.03","v":0},null,null,{"$f":"BI21*1.03","v":0},null,null,{"$f":"BL21*1.03","v":0},null,null,{"$f":"BO21*1.03","v":0},null,null,{"$f":"BR21*1.03","v":0},null,null,{"$f":"BU21*1.03","v":0},null,null,{"$f":"BX21*1.03","v":0},null,null,{"$f":"CA21*1.03","v":0},null,null,{"$f":"CD21*1.03","v":0},null,null,{"$f":"CG21*1.03","v":0},null,null,{"$f":"CJ21*1.03","v":0},null,null,{"$f":"CM21*1.03","v":0}]
[" - Trash",null,null,{"$f":"Inputs!B74","v":0},null,null,{"$f":"D22*1.03","v":0},null,null,{"$f":"G22*1.03","v":0},null,null,{"$f":"J22*1.03","v":0},null,null,{"$f":"M22*1.03","v":0},null,null,{"$f":"P22*1.03","v":0},null,null,{"$f":"S22*1.03","v":0},null,null,{"$f":"V22*1.03","v":0},null,null,{"$f":"Y22*1.03","v":0},null,null,{"$f":"AB22*1.03","v":0},null,null,{"$f":"AE22*1.03","v":0},null,null,{"$f":"AH22*1.03","v":0},null,null,{"$f":"AK22*1.03","v":0},null,null,{"$f":"AN22*1.03","v":0},null,null,{"$f":"AQ22*1.03","v":0},null,null,{"$f":"AT22*1.03","v":0},null,null,{"$f":"AW22*1.03","v":0},null,null,{"$f":"AZ22*1.03","v":0},null,null,{"$f":"BC22*1.03","v":0},null,null,{"$f":"BF22*1.03","v":0},null,null,{"$f":"BI22*1.03","v":0},null,null,{"$f":"BL22*1.03","v":0},null,null,{"$f":"BO22*1.03","v":0},null,null,{"$f":"BR22*1.03","v":0},null,null,{"$f":"BU22*1.03","v":0},null,null,{"$f":"BX22*1.03","v":0},null,null,{"$f":"CA22*1.03","v":0},null,null,{"$f":"CD22*1.03","v":0},null,null,{"$f":"CG22*1.03","v":0},null,null,{"$f":"CJ22*1.03","v":0},null,null,{"$f":"CM22*1.03","v":0}]
[" - Electric",null,null,{"$f":"Inputs!B75","v":0},null,null,{"$f":"D23*1.03","v":0},null,null,{"$f":"G23*1.03","v":0},null,null,{"$f":"J23*1.03","v":0},null,null,{"$f":"M23*1.03","v":0},null,null,{"$f":"P23*1.03","v":0},null,null,{"$f":"S23*1.03","v":0},null,null,{"$f":"V23*1.03","v":0},null,null,{"$f":"Y23*1.03","v":0},null,null,{"$f":"AB23*1.03","v":0},null,null,{"$f":"AE23*1.03","v":0},null,null,{"$f":"AH23*1.03","v":0},null,null,{"$f":"AK23*1.03","v":0},null,null,{"$f":"AN23*1.03","v":0},null,null,{"$f":"AQ23*1.03","v":0},null,null,{"$f":"AT23*1.03","v":0},null,null,{"$f":"AW23*1.03","v":0},null,null,{"$f":"AZ23*1.03","v":0},null,null,{"$f":"BC23*1.03","v":0},null,null,{"$f":"BF23*1.03","v":0},null,null,{"$f":"BI23*1.03","v":0},null,null,{"$f":"BL23*1.03","v":0},null,null,{"$f":"BO23*1.03","v":0},null,null,{"$f":"BR23*1.03","v":0},null,null,{"$f":"BU23*1.03","v":0},null,null,{"$f":"BX23*1.03","v":0},null,null,{"$f":"CA23*1.03","v":0},null,null,{"$f":"CD23*1.03","v":0},null,null,{"$f":"CG23*1.03","v":0},null,null,{"$f":"CJ23*1.03","v":0},null,null,{"$f":"CM23*1.03","v":0}]
["Landscaping",null,null,{"$f":"Inputs!B76","v":0},null,null,{"$f":"D24*1.03","v":0},null,null,{"$f":"G24*1.03","v":0},null,null,{"$f":"J24*1.03","v":0},null,null,{"$f":"M24*1.03","v":0},null,null,{"$f":"P24*1.03","v":0},null,null,{"$f":"S24*1.03","v":0},null,null,{"$f":"V24*1.03","v":0},null,null,{"$f":"Y24*1.03","v":0},null,null,{"$f":"AB24*1.03","v":0},null,null,{"$f":"AE24*1.03","v":0},null,null,{"$f":"AH24*1.03","v":0},null,null,{"$f":"AK24*1.03","v":0},null,null,{"$f":"AN24*1.03","v":0},null,null,{"$f":"AQ24*1.03","v":0},null,null,{"$f":"AT24*1.03","v":0},null,null,{"$f":"AW24*1.03","v":0},null,null,{"$f":"AZ24*1.03","v":0},null,null,{"$f":"BC24*1.03","v":0},null,null,{"$f":"BF24*1.03","v":0},null,null,{"$f":"BI24*1.03","v":0},null,null,{"$f":"BL24*1.03","v":0},null,null,{"$f":"BO24*1.03","v":0},null,null,{"$f":"BR24*1.03","v":0},null,null,{"$f":"BU24*1.03","v":0},null,null,{"$f":"BX24*1.03","v":0},null,null,{"$f":"CA24*1.03","v":0},null,null,{"$f":"CD24*1.03","v":0},null,null,{"$f":"CG24*1.03","v":0},null,null,{"$f":"CJ24*1.03","v":0},null,null,{"$f":"CM24*1.03","v":0}]
[{"$f":"Inputs!A77","v":"Other"},null,null,{"$f":"Inputs!B77","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$f":"Inputs!A78","v":"Other"},null,null,{"$f":"Inputs!B78","v":0},null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
["Total Annual Expenses",null,null,{"$f":"SUM(D15:D26)","v":19440},null,null,{"$f":"SUM(G15:G26)","v":20148.480000000003},null,null,{"$f":"SUM(J15:J26)","v":20825.318400000004},null,null,{"$f":"SUM(M15:M26)","v":21525.357312000004},null,null,{"$f":"SUM(P15:P26)","v":22249.408565760004},null,null,{"$f":"SUM(S15:S26)","v":22998.312978508806},null,null,{"$f":"SUM(V15:V26)","v":23772.941409871109},null,null,{"$f":"SUM(Y15:Y26)","v":24574.195855854567},null,null,{"$f":"SUM(AB15:AB26)","v":25403.01058336502},null,null,{"$f":"SUM(AE15:AE26)","v":26260.353306774181},null,null,{"$f":"SUM(AH15:AH26)","v":27147.226408121936},null,null,{"$f":"SUM(AK15:AK26)","v":28064.668202595913},null,null,{"$f":"SUM(AN15:AN26)","v":29013.754250993323},null,null,{"$f":"SUM(AQ15:AQ26)","v":29995.598720935432},null,null,{"$f":"SUM(AT15:AT26)","v":31011.355798672303},null,null,{"$f":"SUM(AW15:AW26)","v":32062.221153385624},null,null,{"$f":"SUM(AZ15:AZ26)","v":33149.433455970473},null,null,{"$f":"SUM(BC15:BC26)","v":34274.275954352204},null,null,{"$f":"SUM(BF15:BF26)","v":35438.078107473491},null,null,{"$f":"SUM(BI15:BI26)","v":36642.217280168043},null,null,{"$f":"SUM(BL15:BL26)","v":37888.120501222242},null,null,{"$f":"SUM(BO15:BO26)","v":39177.266287014041},null,null,{"$f":"SUM(BR15:BR26)","v":40511.186533209788},null,null,{"$f":"SUM(BU15:BU26)","v":41891.468477094837},null,null,{"$f":"SUM(BX15:BX26)","v":43319.756733211972},null,null,{"$f":"SUM(CA15:CA26)","v":44797.755405084798},null,null,{"$f":"SUM(CD15:CD26)","v":46327.230275908871},null,null,{"$f":"SUM(CG15:CG26)","v":47910.011081204524},null,null,{"$f":"SUM(CJ15:CJ26)","v":49547.993866539786},null,null,{"$f":"SUM(CM15:CM26)","v":51243.143433551071},null,null,{"$f":"SUM(CP15:CP26)","v":52997.495877613284}]
[]
["Net Operating Income",null,null,{"$f":"D12-D27","v":46680},null,null,{"$f":"G12-G27","v":48616.32},null,null,{"$f":"J12-J27","v":50690.073600000003},null,null,{"$f":"M12-M27","v":52850.650368000002},null,null,{"$f":"P12-P27","v":55101.639421440006},null,null,{"$f":"S12-S27","v":57446.776928179199},null,null,{"$f":"V12-V27","v":59889.952093084416},null,null,{"$f":"Y12-Y27","v":62435.213387219199},null,null,{"$f":"AB12-AB27","v":65086.775029431708},null,null,{"$f":"AE12-AE27","v":67849.02373053442},null,null,{"$f":"AH12-AH27","v":70726.525710679009},null,null,{"$f":"AK12-AK27","v":73724.034000957065},null,null,{"$f":"AN12-AN27","v":76846.496040701779},null,null,{"$f":"AQ12-AQ27","v":80099.061582427472},null,null,{"$f":"AT12-AT27","v":83487.090916825124},null,null,{"$f":"AW12-AW27","v":87016.163430731714},null,null,{"$f":"AZ12-AZ27","v":90692.086511511559},null,null,{"$f":"BC12-BC27","v":94520.904811829096},null,null,{"$f":"BF12-BF27","v":98508.909889355069},null,null,{"$f":"BI12-BI27","v":102662.65023653368},null,null,{"$f":"BL12-BL27","v":106988.94171614756},null,null,{"$f":"BO12-BO27","v":111494.87841905057},null,null,{"$f":"BR12-BR27","v":116187.84396109742},null,null,{"$f":"BU12-BU27","v":121075.52323698465},null,null,{"$f":"BX12-BX27","v":126165.91464943069},null,null,{"$f":"CA12-CA27","v":131467.34283286362},null,null,{"$f":"CD12-CD27","v":136988.47189155748},null,null,{"$f":"CG12-CG27","v":142738.31917296047},null,null,{"$f":"CJ12-CJ27","v":148726.2695977918},null,null,{"$f":"CM12-CM27","v":154962.09056935381},null,null,{"$f":"CP12-CP27","v":161455.94748540779}]
[]
["Less: Annual Mortgage Payments",null,null,{"$f":"PMT(Inputs!B35/12,Inputs!B36*12,Inputs!B29,0)*12","v":-47479.474044510745},null,null,{"$f":"IF(D37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(G37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(J37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(M37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(P37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(S37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(V37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(Y37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AB37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AE37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AH37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AK37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AN37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AQ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AT37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AW37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(AZ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BC37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-47479.474044510745},null,null,{"$f":"IF(BF37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(BI37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(BL37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(BO37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(BR37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(BU37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(BX37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(CA37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(CD37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(CG37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(CJ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0},null,null,{"$f":"IF(CM37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":0}]
["Less: Annual Mortgage Insurance",null,null,{"$f":"-Inputs!B37*12","v":0},null,null,{"$f":"IF((D37/$M$2)>0.8,D32,0)","v":0},null,null,{"$f":"IF((G37/$M$2)>0.8,G32,0)","v":0},null,null,{"$f":"IF((J37/$M$2)>0.8,J32,0)","v":0},null,null,{"$f":"IF((M37/$M$2)>0.8,M32,0)","v":0},null,null,{"$f":"IF((P37/$M$2)>0.8,P32,0)","v":0},null,null,{"$f":"IF((S37/$M$2)>0.8,S32,0)","v":0},null,null,{"$f":"IF((V37/$M$2)>0.8,V32,0)","v":0},null,null,{"$f":"IF((Y37/$M$2)>0.8,Y32,0)","v":0},null,null,{"$f":"IF((AB37/$M$2)>0.8,AB32,0)","v":0},null,null,{"$f":"IF((AE37/$M$2)>0.8,AE32,0)","v":0},null,null,{"$f":"IF((AH37/$M$2)>0.8,AH32,0)","v":0},null,null,{"$f":"IF((AK37/$M$2)>0.8,AK32,0)","v":0},null,null,{"$f":"IF((AN37/$M$2)>0.8,AN32,0)","v":0},null,null,{"$f":"IF((AQ37/$M$2)>0.8,AQ32,0)","v":0},null,null,{"$f":"IF((AT37/$M$2)>0.8,AT32,0)","v":0},null,null,{"$f":"IF((AW37/$M$2)>0.8,AW32,0)","v":0},null,null,{"$f":"IF((AZ37/$M$2)>0.8,AZ32,0)","v":0},null,null,{"$f":"IF((BC37/$M$2)>0.8,BC32,0)","v":0},null,null,{"$f":"IF((BF37/$M$2)>0.8,BF32,0)","v":0},null,null,{"$f":"IF((BI37/$M$2)>0.8,BI32,0)","v":0},null,null,{"$f":"IF((BL37/$M$2)>0.8,BL32,0)","v":0},null,null,{"$f":"IF((BO37/$M$2)>0.8,BO32,0)","v":0},null,null,{"$f":"IF((BR37/$M$2)>0.8,BR32,0)","v":0},null,null,{"$f":"IF((BU37/$M$2)>0.8,BU32,0)","v":0},null,null,{"$f":"IF((BX37/$M$2)>0.8,BX32,0)","v":0},null,null,{"$f":"IF((CA37/$M$2)>0.8,CA32,0)","v":0},null,null,{"$f":"IF((CD37/$M$2)>0.8,CD32,0)","v":0},null,null,{"$f":"IF((CG37/$M$2)>0.8,CG32,0)","v":0},null,null,{"$f":"IF((CJ37/$M$2)>0.8,CJ32,0)","v":0},null,null,{"$f":"IF((CM37/$M$2)>0.8,CM32,0)","v":0}]
[]
["Annual Cash Flow Before Taxes**",null,null,{"$f":"D29+D31+D32","v":-799.47404451074544},null,null,{"$f":"G29+G31+G32","v":1136.8459554892543},null,null,{"$f":"J29+J31+J32","v":3210.5995554892579},null,null,{"$f":"M29+M31+M32","v":5371.1763234892569},null,null,{"$f":"P29+P31+P32","v":7622.1653769292607},null,null,{"$f":"S29+S31+S32","v":9967.3028836684534},null,null,{"$f":"V29+V31+V32","v":12410.47804857367},null,null,{"$f":"Y29+Y31+Y32","v":14955.739342708453},null,null,{"$f":"AB29+AB31+AB32","v":17607.300984920963},null,null,{"$f":"AE29+AE31+AE32","v":20369.549686023674},null,null,{"$f":"AH29+AH31+AH32","v":23247.051666168263},null,null,{"$f":"AK29+AK31+AK32","v":26244.559956446319},null,null,{"$f":"AN29+AN31+AN32","v":29367.021996191033},null,null,{"$f":"AQ29+AQ31+AQ32","v":32619.587537916726},null,null,{"$f":"AT29+AT31+AT32","v":36007.616872314378},null,null,{"$f":"AW29+AW31+AW32","v":39536.689386220969},null,null,{"$f":"AZ29+AZ31+AZ32","v":43212.612467000814},null,null,{"$f":"BC29+BC31+BC32","v":47041.43076731835},null,null,{"$f":"BF29+BF31+BF32","v":51029.435844844324},null,null,{"$f":"BI29+BI31+BI32","v":102662.65023653368},null,null,{"$f":"BL29+BL31+BL32","v":106988.94171614756},null,null,{"$f":"BO29+BO31+BO32","v":111494.87841905057},null,null,{"$f":"BR29+BR31+BR32","v":116187.84396109742},null,null,{"$f":"BU29+BU31+BU32","v":121075.52323698465},null,null,{"$f":"BX29+BX31+BX32","v":126165.91464943069},null,null,{"$f":"CA29+CA31+CA32","v":131467.34283286362},null,null,{"$f":"CD29+CD31+CD32","v":136988.47189155748},null,null,{"$f":"CG29+CG31+CG32","v":142738.31917296047},null,null,{"$f":"CJ29+CJ31+CJ32","v":148726.2695977918},null,null,{"$f":"CM29+CM31+CM32","v":154962.09056935381},null,null,{"$f":"CP29+CP31+CP32","v":161455.94748540779}]
["**All Cash Flows are Reinvested to Reduce the principal balance "]
["Property Value at End of Year",null,null,{"$f":"Inputs!B24*(1+Inputs!B49)","v":929250},null,null,{"$f":"D36*(1+Inputs!$B$49)","v":975712.5},null,null,{"$f":"G36*(1+Inputs!$B$49)","v":1024498.125},null,null,{"$f":"J36*(1+Inputs!$B$49)","v":1075723.03125},null,null,{"$f":"M36*(1+Inputs!$B$49)","v":1129509.1828125},null,null,{"$f":"P36*(1+Inputs!$B$49)","v":1185984.6419531251},null,null,{"$f":"S36*(1+Inputs!$B$49)","v":1245283.8740507814},null,null,{"$f":"V36*(1+Inputs!$B$49)","v":1307548.0677533206},null,null,{"$f":"Y36*(1+Inputs!$B$49)","v":1372925.4711409865},null,null,{"$f":"AB36*(1+Inputs!$B$49)","v":1441571.744698036},null,null,{"$f":"AE36*(1+Inputs!$B$49)","v":1513650.331932938},null,null,{"$f":"AH36*(1+Inputs!$B$49)","v":1589332.8485295849},null,null,{"$f":"AK36*(1+Inputs!$B$49)","v":1668799.4909560643},null,null,{"$f":"AN36*(1+Inputs!$B$49)","v":1752239.4655038677},null,null,{"$f":"AQ36*(1+Inputs!$B$49)","v":1839851.4387790612},null,null,{"$f":"AT36*(1+Inputs!$B$49)","v":1931844.0107180143},null,null,{"$f":"AW36*(1+Inputs!$B$49)","v":2028436.2112539152},null,null,{"$f":"AZ36*(1+Inputs!$B$49)","v":2129858.0218166113},null,null,{"$f":"BC36*(1+Inputs!$B$49)","v":2236350.9229074419},null,null,{"$f":"BF36*(1+Inputs!$B$49)","v":2348168.4690528139},null,null,{"$f":"BI36*(1+Inputs!$B$49)","v":2465576.8925054548},null,null,{"$f":"BL36*(1+Inputs!$B$49)","v":2588855.7371307276},null,null,{"$f":"BO36*(1+Inputs!$B$49)","v":2718298.5239872639},null,null,{"$f":"BR36*(1+Inputs!$B$49)","v":2854213.4501866275},null,null,{"$f":"BU36*(1+Inputs!$B$49)","v":2996924.1226959592},null,null,{"$f":"BX36*(1+Inputs!$B$49)","v":3146770.3288307572},null,null,{"$f":"CA36*(1+Inputs!$B$49)","v":3304108.8452722952},null,null,{"$f":"CD36*(1+Inputs!$B$49)","v":3469314.28753591},null,null,{"$f":"CG36*(1+Inputs!$B$49)","v":3642780.0019127056},null,null,{"$f":"CJ36*(1+Inputs!$B$49)","v":3824919.0020083413},null,null,{"$f":"CM36*(1+Inputs!$B$49)","v":4016164.9521087585}]
["Mortgage Balance at End of Year",null,null,{"$f":"IF(D34>0,(IF((Inputs!B29+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,1,12,0)-D34)>0,(Inputs!B29+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,1,12,0)-D34),0)),(Inputs!B29+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,1,12,0)))","v":574386.49082435877},null,null,{"$f":"IF(G34>0,(IF((D37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,13,24,0)-G34)>0,(D37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,13,24,0)-G34),0)),D37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,13,24,0))","v":567215.29156788636},null,null,{"$f":"IF(J34>0,(IF((G37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,25,36,0)-J34)>0,(G37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,25,36,0)-J34),0)),G37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,25,36,0))","v":557518.01386193337},null,null,{"$f":"IF(M34>0,(IF((J37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,37,48,0)-M34)>0,(J37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,37,48,0)-M34),0)),J37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,37,48,0))","v":545173.92903790157},null,null,{"$f":"IF(P34>0,(IF((M37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,49,60,0)-P34)>0,(M37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,49,60,0)-P34),0)),M37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,49,60,0))","v":530056.1778111544},null,null,{"$f":"IF(S34>0,(IF((P37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,61,72,0)-S34)>0,(P37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,61,72,0)-S34),0)),P37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,61,72,0))","v":512031.43272419024},null,null,{"$f":"IF(V34>0,(IF((S37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,73,84,0)-V34)>0,(S37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,73,84,0)-V34),0)),S37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,73,84,0))","v":490959.54032319109},null,null,{"$f":"IF(Y34>0,(IF((V37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,85,96,0)-Y34)>0,(V37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,85,96,0)-Y34),0)),V37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,85,96,0))","v":466693.1417549387},null,null,{"$f":"IF(AB34>0,(IF((Y37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,97,108,0)-AB34)>0,(Y37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,97,108,0)-AB34),0)),Y37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,97,108,0))","v":439077.27038105682},null,null,{"$f":"IF(AE34>0,(IF((AB37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,109,120,0)-AE34)>0,(AB37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,109,120,0)-AE34),0)),AB37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,109,120,0))","v":407948.92491009424},null,null,{"$f":"IF(AH34>0,(IF((AE37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,121,132,0)-AH34)>0,(AE37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,121,132,0)-AH34),0)),AE37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,121,132,0))","v":373136.61644464429},null,null,{"$f":"IF(AK34>0,(IF((AH37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,133,144,0)-AK34)>0,(AH37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,133,144,0)-AK34),0)),AH37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,133,144,0))","v":334459.8877300017},null,null,{"$f":"IF(AN34>0,(IF((AK37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,145,156,0)-AN34)>0,(AK37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,145,156,0)-AN34),0)),AK37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,145,156,0))","v":291728.80277224537},null,null,{"$f":"IF(AQ34>0,(IF((AN37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,157,168,0)-AQ34)>0,(AN37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,157,168,0)-AQ34),0)),AN37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,157,168,0))","v":244743.40486653295},null,null,{"$f":"IF(AT34>0,(IF((AQ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,169,180,0)-AT34)>0,(AQ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,169,180,0)-AT34),0)),AQ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,169,180,0))","v":193293.14094017528},null,null,{"$f":"IF(AW34>0,(IF((AT37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,181,192,0)-AW34)>0,(AT37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,181,192,0)-AW34),0)),AT37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,181,192,0))","v":137156.24996906143},null,null,{"$f":"IF(AZ34>0,(IF((AW37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,193,204,0)-AZ34)>0,(AW37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,193,204,0)-AZ34),0)),AW37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,193,204,0))","v":76099.113069513347},null,null,{"$f":"IF(BC34>0,(IF((AZ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,205,216,0)-BC34)>0,(AZ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,205,216,0)-BC34),0)),AZ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,205,216,0))","v":9875.5626998907101},null,null,{"$f":"IF(BF34>0,(IF((BC37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,217,228,0)-BF34)>0,(BC37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,217,228,0)-BF34),0)),BC37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,217,228,0))","v":0},null,null,{"$f":"IF(BI34>0,(IF((BF37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,229,240,0)-BI34)>0,(BF37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,229,240,0)-BI34),0)),BF37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,229,240,0))","v":0},null,null,{"$f":"IF(BL34>0,(IF((BI37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,241,252,0)-BL34)>0,(BI37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,241,252,0)-BL34),0)),BI37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,241,252,0))","v":0},null,null,{"$f":"IF(BO34>0,(IF((BL37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,253,264,0)-BO34)>0,(BL37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,253,264,0)-BO34),0)),BL37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,253,264,0))","v":0},null,null,{"$f":"IF(BR34>0,(IF((BO37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,265,276,0)-BR34)>0,(BO37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,265,276,0)-BR34),0)),BO37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,265,276,0))","v":0},null,null,{"$f":"IF(BU34>0,(IF((BR37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,277,288,0)-BU34)>0,(BR37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,277,288,0)-BU34),0)),BR37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,277,288,0))","v":0},null,null,{"$f":"IF(BX34>0,(IF((BU37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,289,300,0)-BX34)>0,(BU37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,289,300,0)-BX34),0)),BU37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,289,300,0))","v":0},null,null,{"$f":"IF(CA34>0,(IF((BX37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,301,312,0)-CA34)>0,(BX37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,301,312,0)-CA34),0)),BX37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,301,312,0))","v":0},null,null,{"$f":"IF(CD34>0,(IF((CA37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,313,324,0)-CD34)>0,(CA37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,313,324,0)-CD34),0)),CA37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,313,324,0))","v":0},null,null,{"$f":"IF(CG34>0,(IF((CD37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,325,336,0)-CG34)>0,(CD37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,325,336,0)-CG34),0)),CD37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,325,336,0))","v":0},null,null,{"$f":"IF(CJ34>0,(IF((CG37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,337,348,0)-CJ34)>0,(CG37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,337,348,0)-CJ34),0)),CG37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,337,348,0))","v":0},null,null,{"$f":"IF(CM34>0,(IF((CJ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,349,360,0)-CM34)>0,(CJ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,349,360,0)-CM34),0)),CJ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,349,360,0))","v":0},null,null,0]
["Total Equity",null,null,{"$f":"D36-D37","v":354863.50917564123},null,null,{"$f":"G36-G37","v":408497.20843211364},null,null,{"$f":"J36-J37","v":466980.11113806663},null,null,{"$f":"M36-M37","v":530549.10221209843},null,null,{"$f":"P36-P37","v":599453.00500134565},null,null,{"$f":"S36-S37","v":673953.20922893495},null,null,{"$f":"V36-V37","v":754324.33372759027},null,null,{"$f":"Y36-Y37","v":840854.9259983818},null,null,{"$f":"AB36-AB37","v":933848.20075992972},null,null,{"$f":"AE36-AE37","v":1033622.8197879418},null,null,{"$f":"AH36-AH37","v":1140513.7154882937},null,null,{"$f":"AK36-AK37","v":1254872.9607995832},null,null,{"$f":"AN36-AN37","v":1377070.6881838189},null,null,{"$f":"AQ36-AQ37","v":1507496.0606373348},null,null,{"$f":"AT36-AT37","v":1646558.2978388858},null,null,{"$f":"AW36-AW37","v":1794687.7607489529},null,null,{"$f":"AZ36-AZ37","v":1952337.0981844019},null,null,{"$f":"BC36-BC37","v":2119982.4591167206},null,null,{"$f":"BF36-BF37","v":2236350.9229074419},null,null,{"$f":"BI36-BI37","v":2348168.4690528139},null,null,{"$f":"BL36-BL37","v":2465576.8925054548},null,null,{"$f":"BO36-BO37","v":2588855.7371307276},null,null,{"$f":"BR36-BR37","v":2718298.5239872639},null,null,{"$f":"BU36-BU37","v":2854213.4501866275},null,null,{"$f":"BX36-BX37","v":2996924.1226959592},null,null,{"$f":"CA36-CA37","v":3146770.3288307572},null,null,{"$f":"CD36-CD37","v":3304108.8452722952},null,null,{"$f":"CG36-CG37","v":3469314.28753591},null,null,{"$f":"CJ36-CJ37","v":3642780.0019127056},null,null,{"$f":"CM36-CM37","v":3824919.0020083413},null,null,{"$f":"CP36-CP37","v":4016164.9521087585}]
[]
["ROI QuadrantTM"]
["Appreciation",null,null,{"$f":"D36-$M$2","v":44250},{"$f":"(D36-$M$2)/$M$7","v":0.82927380380556781},null,{"$f":"G36-D36","v":46462.5},{"$f":"(G36-D36)/$M$7","v":0.87073749399584621},null,{"$f":"J36-G36","v":48785.625},{"$f":"(J36-G36)/$M$7","v":0.9142743686956385},null,{"$f":"M36-J36","v":51224.90625},{"$f":"(M36-J36)/$M$7","v":0.9599880871304205},null,{"$f":"P36-M36","v":53786.151562500047},{"$f":"(P36-M36)/$M$7","v":1.0079874914869424},null,{"$f":"S36-P36","v":56475.459140625084},{"$f":"(S36-P36)/$M$7","v":1.0583868660612901},null,{"$f":"V36-S36","v":59299.232097656233},{"$f":"(V36-S36)/$M$7","v":1.1113062093643526},null,{"$f":"Y36-V36","v":62264.193702539196},{"$f":"(Y36-V36)/$M$7","v":1.1668715198325732},null,{"$f":"AB36-Y36","v":65377.403387665981},{"$f":"(AB36-Y36)/$M$7","v":1.2252150958241985},null,{"$f":"AE36-AB36","v":68646.273557049455},{"$f":"(AE36-AB36)/$M$7","v":1.2864758506154117},null,{"$f":"AH36-AE36","v":72078.587234901963},{"$f":"(AH36-AE36)/$M$7","v":1.3507996431461831},null,{"$f":"AK36-AH36","v":75682.516596646979},{"$f":"(AK36-AH36)/$M$7","v":1.4183396253034906},null,{"$f":"AN36-AK36","v":79466.642426479375},{"$f":"(AN36-AK36)/$M$7","v":1.4892566065686661},null,{"$f":"AQ36-AN36","v":83439.974547803402},{"$f":"(AQ36-AN36)/$M$7","v":1.5637194368971004},null,{"$f":"AT36-AQ36","v":87611.973275193479},{"$f":"(AT36-AQ36)/$M$7","v":1.6419054087419536},null,{"$f":"AW36-AT36","v":91992.57193895313},{"$f":"(AW36-AT36)/$M$7","v":1.724000679179051},null,{"$f":"AZ36-AW36","v":96592.200535900891},{"$f":"(AZ36-AW36)/$M$7","v":1.8102007131380053},null,{"$f":"BC36-AZ36","v":101421.81056269608},{"$f":"(BC36-AZ36)/$M$7","v":1.9007107487949082},null,{"$f":"BF36-BC36","v":106492.90109083056},{"$f":"(BF36-BC36)/$M$7","v":1.9957462862346478},null,{"$f":"BI36-BF36","v":111817.54614537209},{"$f":"(BI36-BF36)/$M$7","v":2.0955336005463803},null,{"$f":"BL36-BI36","v":117408.42345264088},{"$f":"(BL36-BI36)/$M$7","v":2.2003102805737029},null,{"$f":"BO36-BL36","v":123278.84462527279},{"$f":"(BO36-BL36)/$M$7","v":2.3103257946023854},null,{"$f":"BR36-BO36","v":129442.78685653629},{"$f":"(BR36-BO36)/$M$7","v":2.4258420843325017},null,{"$f":"BU36-BR36","v":135914.92619936354},{"$f":"(BU36-BR36)/$M$7","v":2.5471341885491352},null,{"$f":"BX36-BU36","v":142710.67250933172},{"$f":"(BX36-BU36)/$M$7","v":2.6744908979765922},null,{"$f":"CA36-BX36","v":149846.20613479801},{"$f":"(CA36-BX36)/$M$7","v":2.808215442875416},null,{"$f":"CD36-CA36","v":157338.516441538},{"$f":"(CD36-CA36)/$M$7","v":2.9486262150191886},null,{"$f":"CG36-CD36","v":165205.44226361485},{"$f":"(CG36-CD36)/$M$7","v":3.096057525770147},null,{"$f":"CJ36-CG36","v":173465.71437679557},{"$f":"(CJ36-CG36)/$M$7","v":3.2508604020586538},null,{"$f":"CM36-CJ36","v":182139.00009563565},{"$f":"(CM36-CJ36)/$M$7","v":3.4134034221615925},null,{"$f":"CP36-CM36","v":191245.95010041725},{"$f":"(CP36-CM36)/$M$7","v":3.5840735932696686}]
["Cash Flow ",null,null,{"$f":"IF(D37>0,IF(D34<0,D34,0),D34)","v":-799.47404451074544},{"$f":"D42/$M$7","v":-1.4982663998536672E-2},null,{"$f":"IF(G37>0,IF(G34<0,G34,0),G34)","v":0},{"$f":"G42/$M$7","v":0},null,{"$f":"IF(J37>0,IF(J34<0,J34,0),J34)","v":0},{"$f":"J42/$M$7","v":0},null,{"$f":"IF(M37>0,IF(M34<0,M34,0),M34)","v":0},{"$f":"M42/$M$7","v":0},null,{"$f":"IF(P37>0,IF(P34<0,P34,0),P34)","v":0},{"$f":"P42/$M$7","v":0},null,{"$f":"IF(S37>0,IF(S34<0,S34,0),S34)","v":0},{"$f":"S42/$M$7","v":0},null,{"$f":"IF(V37>0,IF(V34<0,V34,0),V34)","v":0},{"$f":"V42/$M$7","v":0},null,{"$f":"IF(Y37>0,IF(Y34<0,Y34,0),Y34)","v":0},{"$f":"Y42/$M$7","v":0},null,{"$f":"IF(AB37>0,IF(AB34<0,AB34,0),AB34)","v":0},{"$f":"AB42/$M$7","v":0},null,{"$f":"IF(AE37>0,IF(AE34<0,AE34,0),AE34)","v":0},{"$f":"AE42/$M$7","v":0},null,{"$f":"IF(AH37>0,IF(AH34<0,AH34,0),AH34)","v":0},{"$f":"AH42/$M$7","v":0},null,{"$f":"IF(AK37>0,IF(AK34<0,AK34,0),AK34)","v":0},{"$f":"AK42/$M$7","v":0},null,{"$f":"IF(AN37>0,IF(AN34<0,AN34,0),AN34)","v":0},{"$f":"AN42/$M$7","v":0},null,{"$f":"IF(AQ37>0,IF(AQ34<0,AQ34,0),AQ34)","v":0},{"$f":"AQ42/$M$7","v":0},null,{"$f":"IF(AT37>0,IF(AT34<0,AT34,0),AT34)","v":0},{"$f":"AT42/$M$7","v":0},null,{"$f":"IF(AW37>0,IF(AW34<0,AW34,0),AW34)","v":0},{"$f":"AW42/$M$7","v":0},null,{"$f":"IF(AZ37>0,IF(AZ34<0,AZ34,0),AZ34)","v":0},{"$f":"AZ42/$M$7","v":0},null,{"$f":"IF(BC37>0,IF(BC34<0,BC34,0),BC34)","v":0},{"$f":"BC42/$M$7","v":0},null,{"$f":"IF(BF37>0,IF(BF34<0,BF34,0),BF34)","v":51029.435844844324},{"$f":"BF42/$M$7","v":0.95632484449957611},null,{"$f":"IF(BI37>0,IF(BI34<0,BI34,0),BI34)","v":102662.65023653368},{"$f":"BI42/$M$7","v":1.9239648919866861},null,{"$f":"IF(BL37>0,IF(BL34<0,BL34,0),BL34)","v":106988.94171614756},{"$f":"BL42/$M$7","v":2.0050424104425284},null,{"$f":"IF(BO37>0,IF(BO34<0,BO34,0),BO34)","v":111494.87841905057},{"$f":"BO42/$M$7","v":2.0894865973198957},null,{"$f":"IF(BR37>0,IF(BR34<0,BR34,0),BR34)","v":116187.84396109742},{"$f":"BR42/$M$7","v":2.1774358263861475},null,{"$f":"IF(BU37>0,IF(BU34<0,BU34,0),BU34)","v":121075.52323698465},{"$f":"BU42/$M$7","v":2.2690341175702526},null,{"$f":"IF(BX37>0,IF(BX34<0,BX34,0),BX34)","v":126165.91464943069},{"$f":"BX42/$M$7","v":2.364431366145582},null,{"$f":"IF(CA37>0,IF(CA34<0,CA34,0),CA34)","v":131467.34283286362},{"$f":"CA42/$M$7","v":2.4637835811801012},null,{"$f":"IF(CD37>0,IF(CD34<0,CD34,0),CD34)","v":136988.47189155748},{"$f":"CD42/$M$7","v":2.5672531336276605},null,{"$f":"IF(CG37>0,IF(CG34<0,CG34,0),CG34)","v":142738.31917296047},{"$f":"CG42/$M$7","v":2.6750090144491332},null,{"$f":"IF(CJ37>0,IF(CJ34<0,CJ34,0),CJ34)","v":148726.2695977918},{"$f":"CJ42/$M$7","v":2.7872271031677558},null,{"$f":"IF(CM37>0,IF(CM34<0,CM34,0),CM34)","v":154962.09056935381},{"$f":"CM42/$M$7","v":2.9040904472793434},null,{"$f":"IF(CP37>0,IF(CP34<0,CP34,0),CP34)","v":161455.94748540779},{"$f":"CP42/$M$7","v":3.0257895529549406}]
["Debt Paydown ",null,null,{"$f":"M3-$D$37","v":5613.5696756411344},{"$f":"(M3-D37)/M7","v":0.10520194978184207},null,{"$f":"D37-G37","v":7171.199256472406},{"$f":"(D37-G37)/$M$7","v":0.13439294203983124},null,{"$f":"G37-J37","v":9697.2777059529908},{"$f":"(G37-J37)/$M$7","v":0.18173329649208061},null,{"$f":"J37-M37","v":12344.084824031801},{"$f":"(J37-M37)/$M$7","v":0.23133618478019063},null,{"$f":"M37-P37","v":15117.751226747176},{"$f":"(M37-P37)/$M$7","v":0.28331649863934283},null,{"$f":"P37-S37","v":18024.745086964162},{"$f":"(P37-S37)/$M$7","v":0.33779545583937831},null,{"$f":"S37-V37","v":21071.892400999146},{"$f":"(S37-V37)/$M$7","v":0.39490097999453561},null,{"$f":"V37-Y37","v":24266.398568252393},{"$f":"(V37-Y37)/$M$7","v":0.45476810497981124},null,{"$f":"Y37-AB37","v":27615.871373881877},{"$f":"(Y37-AB37)/$M$7","v":0.51753940564122747},null,{"$f":"AB37-AE37","v":31128.34547096258},{"$f":"(AB37-AE37)/$M$7","v":0.58336545660743411},null,{"$f":"AE37-AH37","v":34812.308465449954},{"$f":"(AE37-AH37)/$M$7","v":0.65240532113890293},null,{"$f":"AH37-AK37","v":38676.728714642581},{"$f":"(AH37-AK37)/$M$7","v":0.72482707208921315},null,{"$f":"AK37-AN37","v":42731.084957756335},{"$f":"(AK37-AN37)/$M$7","v":0.8008083472012989},null,{"$f":"AN37-AQ37","v":46985.397905712423},{"$f":"(AN37-AQ37)/$M$7","v":0.88053694112063963},null,{"$f":"AQ37-AT37","v":51450.263926357671},{"$f":"(AQ37-AT37)/$M$7","v":0.96421143667821507},null,{"$f":"AT37-AW37","v":56136.89097111384},{"$f":"(AT37-AW37)/$M$7","v":1.0520418781792997},null,{"$f":"AW37-AZ37","v":61057.136899548088},{"$f":"(AW37-AZ37)/$M$7","v":1.1442504896308596},null,{"$f":"AZ37-BC37","v":66223.550369622637},{"$f":"(AZ37-BC37)/$M$7","v":1.2410724410514482},null,{"$f":"BC37-BF37","v":9875.5626998907101},{"$f":"(BC37-BF37)/$M$7","v":0.18507447333014129},null,{"$f":"BF37-BI37","v":0},{"$f":"(BF37-BI37)/$M$7","v":0},null,{"$f":"BI37-BL37","v":0},{"$f":"(BI37-BL37)/$M$7","v":0},null,{"$f":"BL37-BO37","v":0},{"$f":"(BL37-BO37)/$M$7","v":0},null,{"$f":"BO37-BR37","v":0},{"$f":"(BO37-BR37)/$M$7","v":0},null,{"$f":"BR37-BU37","v":0},{"$f":"(BR37-BU37)/$M$7","v":0},null,{"$f":"BU37-BX37","v":0},{"$f":"(BU37-BX37)/$M$7","v":0},null,{"$f":"BX37-CA37","v":0},{"$f":"(BX37-CA37)/$M$7","v":0},null,{"$f":"CA37-CD37","v":0},{"$f":"(CA37-CD37)/$M$7","v":0},null,{"$f":"CD37-CG37","v":0},{"$f":"(CD37-CG37)/$M$7","v":0},null,{"$f":"CG37-CJ37","v":0},{"$f":"(CG37-CJ37)/$M$7","v":0},null,{"$f":"CJ37-CM37","v":0},{"$f":"(CJ37-CM37)/$M$7","v":0},null,{"$f":"CM37-CP37","v":0},{"$f":"(CM37-CP37)/$M$7","v":0}]
["Cash Flow From Depreciation ",null,null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":8753.454545454546},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.16404543609826505},null,{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/2","v":4376.727272727273},{"$f":"(((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/2)/$M$7","v":8.2022718049132526E-2},null,0,0,null,0,0,null,0,0,null,0,0]
["Total Return on Investment",null,null,{"$f":"SUM(D41:D44)","v":57817.550176584933},{"$f":"SUM(E41:E44)","v":1.0835385256871382},null,{"$f":"SUM(G41:G44)","v":62387.15380192695},{"$f":"SUM(H41:H44)","v":1.1691758721339425},null,{"$f":"SUM(J41:J44)","v":67236.357251407535},{"$f":"SUM(K41:K44)","v":1.2600531012859841},null,{"$f":"SUM(M41:M44)","v":72322.445619486345},{"$f":"SUM(N41:N44)","v":1.3553697080088762},null,{"$f":"SUM(P41:P44)","v":77657.357334701766},{"$f":"SUM(Q41:Q44)","v":1.4553494262245503},null,{"$f":"SUM(S41:S44)","v":83253.65877304379},{"$f":"SUM(T41:T44)","v":1.5602277579989334},null,{"$f":"SUM(V41:V44)","v":89124.579044109923},{"$f":"SUM(W41:W44)","v":1.6702526254571533},null,{"$f":"SUM(Y41:Y44)","v":95284.046816246133},{"$f":"SUM(Z41:Z44)","v":1.7856850609106496},null,{"$f":"SUM(AB41:AB44)","v":101746.7293070024},{"$f":"SUM(AC41:AC44)","v":1.906799937563691},null,{"$f":"SUM(AE41:AE44)","v":108528.07357346658},{"$f":"SUM(AF41:AF44)","v":2.0338867433211112},null,{"$f":"SUM(AH41:AH44)","v":115644.35024580646},{"$f":"SUM(AI41:AI44)","v":2.1672504003833506},null,{"$f":"SUM(AK41:AK44)","v":123112.6998567441},{"$f":"SUM(AL41:AL44)","v":2.3072121334909683},null,{"$f":"SUM(AN41:AN44)","v":130951.18192969025},{"$f":"SUM(AO41:AO44)","v":2.4541103898682302},null,{"$f":"SUM(AQ41:AQ44)","v":139178.82699897038},{"$f":"SUM(AR41:AR44)","v":2.6083018141160048},null,{"$f":"SUM(AT41:AT44)","v":147815.69174700571},{"$f":"SUM(AU41:AU44)","v":2.7701622815184335},null,{"$f":"SUM(AW41:AW44)","v":156882.91745552153},{"$f":"SUM(AX41:AX44)","v":2.9400879934566158},null,{"$f":"SUM(AZ41:AZ44)","v":166402.79198090354},{"$f":"SUM(BA41:BA44)","v":3.1184966388671302},null,{"$f":"SUM(BC41:BC44)","v":176398.81547777329},{"$f":"SUM(BD41:BD44)","v":3.3058286259446215},null,{"$f":"SUM(BF41:BF44)","v":176151.35418102014},{"$f":"SUM(BG41:BG44)","v":3.3011910401626308},null,{"$f":"SUM(BI41:BI44)","v":223233.65092736032},{"$f":"SUM(BJ41:BJ44)","v":4.1835439286313312},null,{"$f":"SUM(BL41:BL44)","v":233150.819714243},{"$f":"SUM(BM41:BM44)","v":4.3693981271144962},null,{"$f":"SUM(BO41:BO44)","v":243527.17758977792},{"$f":"SUM(BP41:BP44)","v":4.563857828020546},null,{"$f":"SUM(BR41:BR44)","v":254384.08536308826},{"$f":"SUM(BS41:BS44)","v":4.7673233468169141},null,{"$f":"SUM(BU41:BU44)","v":265743.90398180275},{"$f":"SUM(BV41:BV44)","v":4.9802137422176527},null,{"$f":"SUM(BX41:BX44)","v":277630.04170421691},{"$f":"SUM(BY41:BY44)","v":5.2029677002204391},null,{"$f":"SUM(CA41:CA44)","v":290067.00351311616},{"$f":"SUM(CB41:CB44)","v":5.4360444601537825},null,{"$f":"SUM(CD41:CD44)","v":298703.71560582274},{"$f":"SUM(CE41:CE44)","v":5.5979020666959816},null,{"$f":"SUM(CG41:CG44)","v":307943.76143657533},{"$f":"SUM(CH41:CH44)","v":5.7710665402192802},null,{"$f":"SUM(CJ41:CJ44)","v":322191.98397458741},{"$f":"SUM(CK41:CK44)","v":6.0380875052264091},null,{"$f":"SUM(CM41:CM44)","v":337101.09066498943},{"$f":"SUM(CN41:CN44)","v":6.3174938694409359},null,{"$f":"SUM(CP41:CP44)","v":352701.89758582506},{"$f":"SUM(CQ41:CQ44)","v":6.6098631462246091}]
[]
[{"$f":"Inputs!A84","v":"This sheet is for informational purposes only.  This is not a commitment, approval or guarantee to lend.  The figures included in this worksheet are entirely dependent on the information that you input.  These figures and calculations are considered accurate, but not guaranteed.  Joe Massey and Castle & Cooke Mortgage do not represent, warrant or guarantee these numbers.   James Orr and Real Estate Financial Planner LLC do not represent, warrant or guarantee these numbers.  All information is for preliminary analysis and calculations only.  Please contact your tax advisor, CPA, financial planner, attorney, insurance agent, real estate agent or other properly licensed professional for additional information as needed.  "}]
[]
[]
[null,{"$f":"-M7","v":-53359.939500000037},null,{"$f":"D34*0.7","v":-559.63183115752179},null,null,{"$f":"G34*0.7","v":795.79216884247796},null,null,{"$f":"J34*0.7","v":2247.4196888424804},null,null,{"$f":"M34*0.7","v":3759.8234264424796},null,null,{"$f":"P51+P56","v":542617.38412525866},null,null,{"$f":"IRR(B50:P50)","v":0.5968037703662763},"IRR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P34*0.7","v":5335.5157638504825}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P36*0.93","v":1050443.5400156251},"Net Future value after 7% sales cost "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P52-P37","v":520387.36220447067},"Pre Tax Terminal Value "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P52-M2+M5+M6","v":-86196.459984374931},"Capital Gain Base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P54*0.196","v":-16894.506156937488},"Capital Gains Tax at 19.6%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P53-P55","v":537281.86836140812},"After Tax Terminal Value "]
[]
[]
[]
[null,null,"Year  0","Year 1","Year 2 ","Year 3","Year 4","Year 5","Year 6","Year 7","Year 8","Year 9","Year 10","Year 11","Year 12","Year 13","Year 14","Year 15","Year 16","Year 17","Year 18","Year 19","Year 20","Year 21","Year 22","Year 23","Year 24","Year 25","Year 26","Year 27","Year 28","Year 29","Year 30","Year 31"]
[null,"Annual Cash Flow Before Taxes",null,{"$f":"D34","v":-799.47404451074544},{"$f":"G34","v":1136.8459554892543},{"$f":"J34","v":3210.5995554892579},{"$f":"M34","v":5371.1763234892569},{"$f":"P34","v":7622.1653769292607},{"$f":"S34","v":9967.3028836684534},{"$f":"V34","v":12410.47804857367},{"$f":"Y34","v":14955.739342708453},{"$f":"AB34","v":17607.300984920963},{"$f":"AE34","v":20369.549686023674},{"$f":"AH34","v":23247.051666168263},{"$f":"AK34","v":26244.559956446319},{"$f":"AN34","v":29367.021996191033},{"$f":"AQ34","v":32619.587537916726},{"$f":"AT34","v":36007.616872314378},{"$f":"AW34","v":39536.689386220969},{"$f":"AZ34","v":43212.612467000814},{"$f":"BC34","v":47041.43076731835},{"$f":"BF34","v":51029.435844844324},{"$f":"BI34","v":102662.65023653368},{"$f":"BL34","v":106988.94171614756},{"$f":"BO34","v":111494.87841905057},{"$f":"BR34","v":116187.84396109742},{"$f":"BU34","v":121075.52323698465},{"$f":"BX34","v":126165.91464943069},{"$f":"CA34","v":131467.34283286362},{"$f":"CD34","v":136988.47189155748},{"$f":"CG34","v":142738.31917296047},{"$f":"CJ34","v":148726.2695977918},{"$f":"CM34","v":154962.09056935381},{"$f":"CP34","v":161455.94748540779}]
[]
[]
[null,"ROI QuadrantTM",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]
[null,"Appreciation",0,{"$f":"D41","v":44250},{"$f":"G41","v":46462.5},{"$f":"J41","v":48785.625},{"$f":"M41","v":51224.90625},{"$f":"P41","v":53786.151562500047},{"$f":"S41","v":56475.459140625084},{"$f":"V41","v":59299.232097656233},{"$f":"Y41","v":62264.193702539196},{"$f":"AB41","v":65377.403387665981},{"$f":"AE41","v":68646.273557049455},{"$f":"AH41","v":72078.587234901963},{"$f":"AK41","v":75682.516596646979},{"$f":"AN41","v":79466.642426479375},{"$f":"AQ41","v":83439.974547803402},{"$f":"AT41","v":87611.973275193479},{"$f":"AW41","v":91992.57193895313},{"$f":"AZ41","v":96592.200535900891},{"$f":"BC41","v":101421.81056269608},{"$f":"BF41","v":106492.90109083056},{"$f":"BI41","v":111817.54614537209},{"$f":"BL41","v":117408.42345264088},{"$f":"BO41","v":123278.84462527279},{"$f":"BR41","v":129442.78685653629},{"$f":"BU41","v":135914.92619936354},{"$f":"BX41","v":142710.67250933172},{"$f":"CA41","v":149846.20613479801},{"$f":"CD41","v":157338.516441538},{"$f":"CG41","v":165205.44226361485},{"$f":"CJ41","v":173465.71437679557},{"$f":"CM41","v":182139.00009563565},{"$f":"CP41","v":191245.95010041725}]
[null,"Cash Flow ",0,{"$f":"D42","v":-799.47404451074544},{"$f":"G42","v":0},{"$f":"J42","v":0},{"$f":"M42","v":0},{"$f":"P42","v":0},{"$f":"S42","v":0},{"$f":"V42","v":0},{"$f":"Y42","v":0},{"$f":"AB42","v":0},{"$f":"AE42","v":0},{"$f":"AH42","v":0},{"$f":"AK42","v":0},{"$f":"AN42","v":0},{"$f":"AQ42","v":0},{"$f":"AT42","v":0},{"$f":"AW42","v":0},{"$f":"AZ42","v":0},{"$f":"BC42","v":0},{"$f":"BF42","v":51029.435844844324},{"$f":"BI42","v":102662.65023653368},{"$f":"BL42","v":106988.94171614756},{"$f":"BO42","v":111494.87841905057},{"$f":"BR42","v":116187.84396109742},{"$f":"BU42","v":121075.52323698465},{"$f":"BX42","v":126165.91464943069},{"$f":"CA42","v":131467.34283286362},{"$f":"CD42","v":136988.47189155748},{"$f":"CG42","v":142738.31917296047},{"$f":"CJ42","v":148726.2695977918},{"$f":"CM42","v":154962.09056935381},{"$f":"CP42","v":161455.94748540779}]
[null,"Debt Paydown ",0,5613.5696756411344,7171.199256472406,9697.2777059529908,12344.084824031801,15117.751226747176,18024.745086964162,21071.892400999146,24266.398568252393,27615.871373881877,31128.34547096258,34812.308465449954,38676.728714642581,42731.084957756335,46985.397905712423,51450.263926357671,56136.89097111384,61057.136899548088,66223.550369622637,9875.5626998907101,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Depreciation",0,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,8753.454545454546,4376.727272727273,0,0,0,0]
[null,"Total Return on Investment",0,57817.550176584933,62387.15380192695,67236.357251407535,72322.445619486345,77657.357334701766,83253.65877304379,89124.579044109923,95284.046816246133,101746.7293070024,108528.07357346658,115644.35024580646,123112.6998567441,130951.18192969025,139178.82699897038,147815.69174700571,156882.91745552153,166402.79198090354,176398.81547777329,176151.35418102014,223233.65092736032,233150.819714243,243527.17758977792,254384.08536308826,265743.90398180275,277630.04170421691,290067.00351311616,298703.71560582274,307943.76143657533,322191.98397458741,337101.09066498943,352701.89758582506]
[]
[null,null,"Positive Cash Flow Achieved in Year #",{"$f":"MATCH(TRUE,D61:AH61>0,0)","v":2}]
[]
[]
[]
[null,"ROI QuadrantTM",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]
[null,"Appreciation",0,{"$f":"E41","v":0.82927380380556781},{"$f":"H41","v":0.87073749399584621},{"$f":"K41","v":0.9142743686956385},{"$f":"N41","v":0.9599880871304205},{"$f":"Q41","v":1.0079874914869424},{"$f":"T41","v":1.0583868660612901},{"$f":"W41","v":1.1113062093643526},{"$f":"Z41","v":1.1668715198325732},{"$f":"AC41","v":1.2252150958241985},{"$f":"AF41","v":1.2864758506154117},{"$f":"AI41","v":1.3507996431461831},{"$f":"AL41","v":1.4183396253034906},{"$f":"AO41","v":1.4892566065686661},{"$f":"AR41","v":1.5637194368971004},{"$f":"AU41","v":1.6419054087419536},{"$f":"AX41","v":1.724000679179051},{"$f":"BA41","v":1.8102007131380053},{"$f":"BD41","v":1.9007107487949082},{"$f":"BG41","v":1.9957462862346478},{"$f":"BJ41","v":2.0955336005463803},{"$f":"BM41","v":2.2003102805737029},{"$f":"BP41","v":2.3103257946023854},{"$f":"BS41","v":2.4258420843325017},{"$f":"BV41","v":2.5471341885491352},{"$f":"BY41","v":2.6744908979765922},{"$f":"CB41","v":2.808215442875416},{"$f":"CE41","v":2.9486262150191886},{"$f":"CH41","v":3.096057525770147},{"$f":"CK41","v":3.2508604020586538},{"$f":"CN41","v":3.4134034221615925},{"$f":"CQ41","v":3.5840735932696686}]
[null,"Cash Flow ",0,{"$f":"E42","v":-1.4982663998536672E-2},{"$f":"H42","v":0},{"$f":"K42","v":0},{"$f":"N42","v":0},{"$f":"Q42","v":0},{"$f":"T42","v":0},{"$f":"W42","v":0},{"$f":"Z42","v":0},{"$f":"AC42","v":0},{"$f":"AF42","v":0},{"$f":"AI42","v":0},{"$f":"AL42","v":0},{"$f":"AO42","v":0},{"$f":"AR42","v":0},{"$f":"AU42","v":0},{"$f":"AX42","v":0},{"$f":"BA42","v":0},{"$f":"BD42","v":0},{"$f":"BG42","v":0.95632484449957611},{"$f":"BJ42","v":1.9239648919866861},{"$f":"BM42","v":2.0050424104425284},{"$f":"BP42","v":2.0894865973198957},{"$f":"BS42","v":2.1774358263861475},{"$f":"BV42","v":2.2690341175702526},{"$f":"BY42","v":2.364431366145582},{"$f":"CB42","v":2.4637835811801012},{"$f":"CE42","v":2.5672531336276605},{"$f":"CH42","v":2.6750090144491332},{"$f":"CK42","v":2.7872271031677558},{"$f":"CN42","v":2.9040904472793434},{"$f":"CQ42","v":3.0257895529549406}]
[null,"Debt Paydown ",0,{"$f":"E43","v":0.10520194978184207},{"$f":"H43","v":0.13439294203983124},{"$f":"K43","v":0.18173329649208061},{"$f":"N43","v":0.23133618478019063},{"$f":"Q43","v":0.28331649863934283},{"$f":"T43","v":0.33779545583937831},{"$f":"W43","v":0.39490097999453561},{"$f":"Z43","v":0.45476810497981124},{"$f":"AC43","v":0.51753940564122747},{"$f":"AF43","v":0.58336545660743411},{"$f":"AI43","v":0.65240532113890293},{"$f":"AL43","v":0.72482707208921315},{"$f":"AO43","v":0.8008083472012989},{"$f":"AR43","v":0.88053694112063963},{"$f":"AU43","v":0.96421143667821507},{"$f":"AX43","v":1.0520418781792997},{"$f":"BA43","v":1.1442504896308596},{"$f":"BD43","v":1.2410724410514482},{"$f":"BG43","v":0.18507447333014129},{"$f":"BJ43","v":0},{"$f":"BM43","v":0},{"$f":"BP43","v":0},{"$f":"BS43","v":0},{"$f":"BV43","v":0},{"$f":"BY43","v":0},{"$f":"CB43","v":0},{"$f":"CE43","v":0},{"$f":"CH43","v":0},{"$f":"CK43","v":0},{"$f":"CN43","v":0},{"$f":"CQ43","v":0}]
[null,"Depreciation",0,{"$f":"E44","v":0.16404543609826505},{"$f":"H44","v":0.16404543609826505},{"$f":"K44","v":0.16404543609826505},{"$f":"N44","v":0.16404543609826505},{"$f":"Q44","v":0.16404543609826505},{"$f":"T44","v":0.16404543609826505},{"$f":"W44","v":0.16404543609826505},{"$f":"Z44","v":0.16404543609826505},{"$f":"AC44","v":0.16404543609826505},{"$f":"AF44","v":0.16404543609826505},{"$f":"AI44","v":0.16404543609826505},{"$f":"AL44","v":0.16404543609826505},{"$f":"AO44","v":0.16404543609826505},{"$f":"AR44","v":0.16404543609826505},{"$f":"AU44","v":0.16404543609826505},{"$f":"AX44","v":0.16404543609826505},{"$f":"BA44","v":0.16404543609826505},{"$f":"BD44","v":0.16404543609826505},{"$f":"BG44","v":0.16404543609826505},{"$f":"BJ44","v":0.16404543609826505},{"$f":"BM44","v":0.16404543609826505},{"$f":"BP44","v":0.16404543609826505},{"$f":"BS44","v":0.16404543609826505},{"$f":"BV44","v":0.16404543609826505},{"$f":"BY44","v":0.16404543609826505},{"$f":"CB44","v":0.16404543609826505},{"$f":"CE44","v":8.2022718049132526E-2},{"$f":"CH44","v":0},{"$f":"CK44","v":0},{"$f":"CN44","v":0},{"$f":"CQ44","v":0}]
[null,"Total Return on Investment",0,{"$f":"E45","v":1.0835385256871382},{"$f":"H45","v":1.1691758721339425},{"$f":"K45","v":1.2600531012859841},{"$f":"N45","v":1.3553697080088762},{"$f":"Q45","v":1.4553494262245503},{"$f":"T45","v":1.5602277579989334},{"$f":"W45","v":1.6702526254571533},{"$f":"Z45","v":1.7856850609106496},{"$f":"AC45","v":1.906799937563691},{"$f":"AF45","v":2.0338867433211112},{"$f":"AI45","v":2.1672504003833506},{"$f":"AL45","v":2.3072121334909683},{"$f":"AO45","v":2.4541103898682302},{"$f":"AR45","v":2.6083018141160048},{"$f":"AU45","v":2.7701622815184335},{"$f":"AX45","v":2.9400879934566158},{"$f":"BA45","v":3.1184966388671302},{"$f":"BD45","v":3.3058286259446215},{"$f":"BG45","v":3.3011910401626308},{"$f":"BJ45","v":4.1835439286313312},{"$f":"BM45","v":4.3693981271144962},{"$f":"BP45","v":4.563857828020546},{"$f":"BS45","v":4.7673233468169141},{"$f":"BV45","v":4.9802137422176527},{"$f":"BY45","v":5.2029677002204391},{"$f":"CB45","v":5.4360444601537825},{"$f":"CE45","v":5.5979020666959816},{"$f":"CH45","v":5.7710665402192802},{"$f":"CK45","v":6.0380875052264091},{"$f":"CN45","v":6.3174938694409359},{"$f":"CQ45","v":6.6098631462246091}]
[null,null,"Mortgage Balance at End of Year",{"$f":"D37","v":574386.49082435877},{"$f":"G37","v":567215.29156788636},{"$f":"J37","v":557518.01386193337},{"$f":"M37","v":545173.92903790157},{"$f":"P37","v":530056.1778111544},{"$f":"S37","v":512031.43272419024},{"$f":"V37","v":490959.54032319109},{"$f":"Y37","v":466693.1417549387},{"$f":"AB37","v":439077.27038105682},{"$f":"AE37","v":407948.92491009424},{"$f":"AH37","v":373136.61644464429},{"$f":"AK37","v":334459.8877300017},{"$f":"AN37","v":291728.80277224537},{"$f":"AQ37","v":244743.40486653295},{"$f":"AT37","v":193293.14094017528},{"$f":"AW37","v":137156.24996906143},{"$f":"AZ37","v":76099.113069513347},{"$f":"BC37","v":9875.5626998907101},{"$f":"BF37","v":0},{"$f":"BI37","v":0},{"$f":"BL37","v":0},{"$f":"BO37","v":0},{"$f":"BR37","v":0},{"$f":"BU37","v":0},{"$f":"BX37","v":0},{"$f":"CA37","v":0},{"$f":"CD37","v":0},{"$f":"CG37","v":0},{"$f":"CJ37","v":0},{"$f":"CM37","v":0},{"$f":"CP37","v":0}]
[]
[null,null,"Property Paid Off in Year #",{"$f":"MATCH(TRUE,D81:AH81=0,0)","v":19}]