{"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":8,"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 Synergy One Lending - 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@s1l.com - Website: www.LoansByJoeMassey.com \nNMLS: 7538 - CO: 10017422 - Regulated by the Division of Real Estate\n© 2011 Joe Massey",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":"Mortgage Insurance is based on best case scenario.  To calculate your estimated mortgage insurance, download the mortgage calculator app:"}]
["Number of Units",2]
["Initial Occupancy Status","Primary Residence",{"$f":"(IF($B$20<0.1999,HYPERLINK(\"www.LoansByJoeMassey.com/mortgage-calculator\"), \"\"))","v":"www.LoansByJoeMassey.com/mortgage-calculator"}]
[]
["Down Payment Percentage",0.05,{"$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":"WARNING - Borrower may need more down payment!                              Minimum Down Payment on FHA Duplex is 3.5%                              Minimum Down Payment on Conventional Duplex is 15%"}]
[]
["Type of Mortgage Insurance ","Upfront Single Paid"]
[null,{"$f":"IF(B22=\"Monthly Paid\",0,1)","v":1}]
["Purchase Price",725000,{"$f":"IF(B29<75000, \"WARNING - Your borrower will need to pay cash for this property.  Minimum loan amount of $75,000\", \" \")","v":" "}]
["Acquisition Costs ",21000]
["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":36250}]
["Mortgage Balance",{"$f":"B24-B28","v":688750}]
["Initial Investment",{"$f":"SUM(B25:B28)","v":58940}]
["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",0]
["Total Initial Investment",{"$f":"B30+B32-IF((B25+B26+B27)>B31,B31,(B25+B26+B27))","v":58940}]
[]
["Mortgage Interest Rate",6.4899999999999999E-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",2550]
["Unit #2",1150,{"$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":3700}]
[]
["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.03,{"$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? ","No",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,null,"Industry Average is 10% of gross rents for Property Management"]
[]
["Annual Property Management",{"$f":"IF(B54=\"No\",0,B43*B57*12)","v":0},"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":3552},"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",3500,null,"2022 Assessment"]
["Annual Property Insurance",3000]
["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 Synergy One Lending 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.  This spreadsheet is copyrighted as of 2011 through present day.  Any use modifications or distributions are only with permission of Joe Massey. "]

{"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":725000}]
["Mortgage",null,{"$f":"Inputs!B29","v":688750}]
["Down Payment",null,{"$f":"Inputs!B28","v":36250}]
["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":22690}]
["Repair Costs",null,{"$f":"Inputs!B32","v":0}]
["Total Cash Investment ",null,{"$f":"Inputs!B33","v":58940}]
[]
["Annual Cash Flow Statement "]
[]
["Annual Income"]
[{"$f":"\"Annual Rental Income @ $\"&E16&\" per month\"","v":"Annual Rental Income @ $3700 per month"},null,{"$f":"Inputs!B43*12","v":44400},null,{"$f":"Inputs!B43","v":3700},"per month"]
[" - Vacancy",{"$f":"Inputs!B45","v":0.05},{"$f":"-C16*Inputs!B45","v":-2220}]
["Expected Annual Rental Income",null,{"$f":"SUM(C16:C17)","v":42180}]
[]
["Annual Expenses",null,null,null,"Comments/Footnotes"]
["Property Management",null,{"$f":"Inputs!B59","v":0},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":3552},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":3500},null,{"$f":"Inputs!D70","v":"2022 Assessment"}]
["Property Insurance",null,{"$f":"Inputs!B71","v":3000},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":10052}]
[]
["Net Operating Income",null,{"$f":"C18-C33","v":32128}]
[]
["Less: Annual Mortgage Payments",null,{"$f":"PMT(Inputs!B35/12,Inputs!B36*12,Inputs!B29,0)*12","v":-52186.079169493241},null,{"$f":"Inputs!B29","v":688750},"@",{"$f":"Inputs!B35","v":6.4899999999999999E-2},"=",{"$f":"-C37/12","v":4348.8399307911031}," 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":-20058.079169493241}]
[]
["1st Year Returns"]
["Cash-on-Cash Rate of Return",null,{"$f":"C40/C11","v":-0.34031352510168378},null,{"$f":"C40","v":-20058.079169493241},"÷",{"$f":"C11","v":58940},"=",{"$f":"C43","v":-0.34031352510168378}]
[]
["CAP Rate",null,{"$f":"C35/(C6+C10)","v":4.4314482758620689E-2},null,{"$f":"C35","v":32128},"÷",{"$f":"C6+C10","v":725000},"=",{"$f":"C45","v":4.4314482758620689E-2}]
[]
["GRM - Gross Rent Multiplier",null,{"$f":"I47","v":195.94594594594594},null,{"$f":"C6+C10","v":725000},"÷",{"$f":"E16","v":3700},"=",{"$f":"E47/G47","v":195.94594594594594}]
[]
["Cindy's Number",{"$f":"IF(INT((E49-G49)/C3)>1000,\"YES!\",\"NO!\")","v":"NO!"},{"$f":"\"$\"&(INT((E49-G49)/C3))&\" / mo\"","v":"$-596 / mo"},null,{"$f":"E16","v":3700},"-",{"$f":"((C23+C24+C25)/12)+I37","v":4890.5065974577701},"/",{"$f":"C3&\" Units\"","v":"2 Units"},{"$f":"\"=  $\"&(INT((E49-G49)/C3))&\" / mo\"","v":"=  $-596 / mo"}]
[]
[]
["5 Year After-Tax Return ",null,{"$f":"'Long-Term Analysis'!S50","v":5.3354876136446627E-3},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.36901934170342721},{"$f":"((C6*(1+Inputs!B49))-Inputs!B24)","v":21750}]
["Cash Flow ",null,{"$f":"C40/Inputs!B33","v":-0.34031352510168378},{"$f":"C40","v":-20058.079169493241}]
["Debt Paydown ",null,{"$f":"-(CUMPRINC(Inputs!$B$35/12,Inputs!B36*12,Inputs!$B$29,1,12,0))/Inputs!B33","v":0.13086106742830261},{"$f":"-(CUMPRINC(Inputs!$B$35/12,Inputs!B36*12,Inputs!$B$29,1,12,0))","v":7712.9513142241558}]
["Cash Flow From Depreciation ",null,{"$f":"(Inputs!B24*0.85/27.5)*Inputs!B51/Inputs!B33","v":0.12166455871919055},{"$f":"(Inputs!B24*0.85/27.5)*Inputs!B51","v":7170.909090909091}]
["Total ROI ",null,{"$f":"SUM(C55:C58)","v":0.28123144274923662},{"$f":"SUM(D55:D58)","v":16575.781235640006}]
[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 Synergy One Lending 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.  This spreadsheet is copyrighted as of 2011 through present day.  Any use modifications or distributions are only with permission of Joe Massey. "}]

{"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":725000}]
[null,"Number of Units ",null,{"$f":"Inputs!B17","v":2},null,null,"Mortgage",null,null,null,null,null,{"$f":"Inputs!B29","v":688750}]
[null,null,null,null,null,null,"Down Payment",null,null,null,null,null,{"$f":"Inputs!B28","v":36250}]
["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":22690}]
[null,null,null,null,null,null,"Repair Costs",null,null,null,null,null,{"$f":"Inputs!B32","v":0}]
["Annual Cash Flow Statement ",null,null,null,null,null,"Total Cash Investment ",null,null,null,null,null,{"$f":"Inputs!B33","v":58940}]
[]
["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":44400},null,null,{"$f":"D10*(1+$D$5)","v":46176},null,null,{"$f":"G10*(1+$D$5)","v":48023.040000000001},null,null,{"$f":"J10*(1+$D$5)","v":49943.961600000002},null,null,{"$f":"M10*(1+$D$5)","v":51941.720064000001},null,null,{"$f":"P10*(1+$D$5)","v":54019.388866560002},null,null,{"$f":"S10*(1+$D$5)","v":56180.164421222406},null,null,{"$f":"V10*(1+$D$5)","v":58427.370998071303},null,null,{"$f":"Y10*(1+$D$5)","v":60764.465837994154},null,null,{"$f":"AB10*(1+$D$5)","v":63195.044471513924},null,null,{"$f":"AE10*(1+$D$5)","v":65722.846250374481},null,null,{"$f":"AH10*(1+$D$5)","v":68351.760100389467},null,null,{"$f":"AK10*(1+$D$5)","v":71085.83050440505},null,null,{"$f":"AN10*(1+$D$5)","v":73929.263724581251},null,null,{"$f":"AQ10*(1+$D$5)","v":76886.434273564504},null,null,{"$f":"AT10*(1+$D$5)","v":79961.891644507094},null,null,{"$f":"AW10*(1+$D$5)","v":83160.367310287387},null,null,{"$f":"AZ10*(1+$D$5)","v":86486.782002698892},null,null,{"$f":"BC10*(1+$D$5)","v":89946.253282806851},null,null,{"$f":"BF10*(1+$D$5)","v":93544.103414119134},null,null,{"$f":"BI10*(1+$D$5)","v":97285.867550683906},null,null,{"$f":"BL10*(1+$D$5)","v":101177.30225271126},null,null,{"$f":"BO10*(1+$D$5)","v":105224.39434281972},null,null,{"$f":"BR10*(1+$D$5)","v":109433.37011653252},null,null,{"$f":"BU10*(1+$D$5)","v":113810.70492119383},null,null,{"$f":"BX10*(1+$D$5)","v":118363.13311804159},null,null,{"$f":"CA10*(1+$D$5)","v":123097.65844276325},null,null,{"$f":"CD10*(1+$D$5)","v":128021.56478047378},null,null,{"$f":"CG10*(1+$D$5)","v":133142.42737169273},null,null,{"$f":"CJ10*(1+$D$5)","v":138468.12446656043},null,null,{"$f":"CM10*(1+$D$5)","v":144006.84944522285}]
[" - Vacancy",{"$f":"Inputs!B45","v":0.05},null,{"$f":"-D10*Inputs!B45","v":-2220},null,null,{"$f":"-G10*Inputs!$B$45","v":-2308.8000000000002},null,null,{"$f":"-J10*Inputs!$B$45","v":-2401.152},null,null,{"$f":"-M10*Inputs!$B$45","v":-2497.1980800000001},null,null,{"$f":"-P10*Inputs!$B$45","v":-2597.0860032000001},null,null,{"$f":"-S10*Inputs!$B$45","v":-2700.9694433280001},null,null,{"$f":"-V10*Inputs!$B$45","v":-2809.0082210611204},null,null,{"$f":"-Y10*Inputs!$B$45","v":-2921.3685499035655},null,null,{"$f":"-AB10*Inputs!$B$45","v":-3038.2232918997079},null,null,{"$f":"-AE10*Inputs!$B$45","v":-3159.7522235756965},null,null,{"$f":"-AH10*Inputs!$B$45","v":-3286.1423125187243},null,null,{"$f":"-AK10*Inputs!$B$45","v":-3417.5880050194737},null,null,{"$f":"-AN10*Inputs!$B$45","v":-3554.2915252202529},null,null,{"$f":"-AQ10*Inputs!$B$45","v":-3696.4631862290626},null,null,{"$f":"-AT10*Inputs!$B$45","v":-3844.3217136782255},null,null,{"$f":"-AW10*Inputs!$B$45","v":-3998.0945822253548},null,null,{"$f":"-AZ10*Inputs!$B$45","v":-4158.0183655143692},null,null,{"$f":"-BC10*Inputs!$B$45","v":-4324.3391001349446},null,null,{"$f":"-BF10*Inputs!$B$45","v":-4497.3126641403423},null,null,{"$f":"-BI10*Inputs!$B$45","v":-4677.2051707059572},null,null,{"$f":"-BL10*Inputs!$B$45","v":-4864.2933775341953},null,null,{"$f":"-BO10*Inputs!$B$45","v":-5058.8651126355635},null,null,{"$f":"-BR10*Inputs!$B$45","v":-5261.2197171409862},null,null,{"$f":"-BU10*Inputs!$B$45","v":-5471.6685058266266},null,null,{"$f":"-BX10*Inputs!$B$45","v":-5690.5352460596914},null,null,{"$f":"-CA10*Inputs!$B$45","v":-5918.1566559020794},null,null,{"$f":"-CD10*Inputs!$B$45","v":-6154.8829221381629},null,null,{"$f":"-CG10*Inputs!$B$45","v":-6401.0782390236891},null,null,{"$f":"-CJ10*Inputs!$B$45","v":-6657.1213685846369},null,null,{"$f":"-CM10*Inputs!$B$45","v":-6923.406223328022},null,null,{"$f":"-CP10*Inputs!$B$45","v":-7200.3424722611426}]
["Expected Annual Rental Income",null,null,{"$f":"SUM(D10:D11)","v":42180},null,null,{"$f":"SUM(G10:G11)","v":43867.199999999997},null,null,{"$f":"SUM(J10:J11)","v":45621.887999999999},null,null,{"$f":"SUM(M10:M11)","v":47446.76352},null,null,{"$f":"SUM(P10:P11)","v":49344.634060800003},null,null,{"$f":"SUM(S10:S11)","v":51318.419423232001},null,null,{"$f":"SUM(V10:V11)","v":53371.156200161284},null,null,{"$f":"SUM(Y10:Y11)","v":55506.002448167739},null,null,{"$f":"SUM(AB10:AB11)","v":57726.242546094443},null,null,{"$f":"SUM(AE10:AE11)","v":60035.292247938225},null,null,{"$f":"SUM(AH10:AH11)","v":62436.70393785576},null,null,{"$f":"SUM(AK10:AK11)","v":64934.172095369991},null,null,{"$f":"SUM(AN10:AN11)","v":67531.538979184799},null,null,{"$f":"SUM(AQ10:AQ11)","v":70232.800538352196},null,null,{"$f":"SUM(AT10:AT11)","v":73042.112559886285},null,null,{"$f":"SUM(AW10:AW11)","v":75963.797062281737},null,null,{"$f":"SUM(AZ10:AZ11)","v":79002.348944773024},null,null,{"$f":"SUM(BC10:BC11)","v":82162.442902563955},null,null,{"$f":"SUM(BF10:BF11)","v":85448.940618666515},null,null,{"$f":"SUM(BI10:BI11)","v":88866.898243413176},null,null,{"$f":"SUM(BL10:BL11)","v":92421.574173149711},null,null,{"$f":"SUM(BO10:BO11)","v":96118.437140075694},null,null,{"$f":"SUM(BR10:BR11)","v":99963.174625678745},null,null,{"$f":"SUM(BU10:BU11)","v":103961.70161070589},null,null,{"$f":"SUM(BX10:BX11)","v":108120.16967513414},null,null,{"$f":"SUM(CA10:CA11)","v":112444.97646213952},null,null,{"$f":"SUM(CD10:CD11)","v":116942.77552062509},null,null,{"$f":"SUM(CG10:CG11)","v":121620.4865414501},null,null,{"$f":"SUM(CJ10:CJ11)","v":126485.3060031081},null,null,{"$f":"SUM(CM10:CM11)","v":131544.7182432324},null,null,{"$f":"SUM(CP10:CP11)","v":136806.50697296171}]
[]
["Annual Expenses"]
["Property Management",null,null,{"$f":"Inputs!B59","v":0},null,null,{"$f":"(G10*Inputs!$B$57)","v":0},null,null,{"$f":"J10*Inputs!$B$57","v":0},null,null,{"$f":"M10*Inputs!$B$57","v":0},null,null,{"$f":"P10*Inputs!$B$57","v":0},null,null,{"$f":"S10*Inputs!$B$57","v":0},null,null,{"$f":"V10*Inputs!$B$57","v":0},null,null,{"$f":"Y10*Inputs!$B$57","v":0},null,null,{"$f":"AB10*Inputs!$B$57","v":0},null,null,{"$f":"AE10*Inputs!$B$57","v":0},null,null,{"$f":"AH10*Inputs!$B$57","v":0},null,null,{"$f":"AK10*Inputs!$B$57","v":0},null,null,{"$f":"AN10*Inputs!$B$57","v":0},null,null,{"$f":"AQ10*Inputs!$B$57","v":0},null,null,{"$f":"AT10*Inputs!$B$57","v":0},null,null,{"$f":"AW10*Inputs!$B$57","v":0},null,null,{"$f":"AZ10*Inputs!$B$57","v":0},null,null,{"$f":"BC10*Inputs!$B$57","v":0},null,null,{"$f":"BF10*Inputs!$B$57","v":0},null,null,{"$f":"BI10*Inputs!$B$57","v":0},null,null,{"$f":"BL10*Inputs!$B$57","v":0},null,null,{"$f":"BO10*Inputs!$B$57","v":0},null,null,{"$f":"BR10*Inputs!$B$57","v":0},null,null,{"$f":"BU10*Inputs!$B$57","v":0},null,null,{"$f":"BX10*Inputs!$B$57","v":0},null,null,{"$f":"CA10*Inputs!$B$57","v":0},null,null,{"$f":"CD10*Inputs!$B$57","v":0},null,null,{"$f":"CG10*Inputs!$B$57","v":0},null,null,{"$f":"CJ10*Inputs!$B$57","v":0},null,null,{"$f":"CM10*Inputs!$B$57","v":0},null,null,{"$f":"CP10*Inputs!$B$57","v":0}]
["Reserves for Repairs and Maintenance",null,null,{"$f":"Inputs!B62","v":3552},null,null,{"$f":"G10*Inputs!B60","v":3694.08},null,null,{"$f":"G16*(1.03)","v":3804.9023999999999},null,null,{"$f":"J16*(1.03)","v":3919.0494720000002},null,null,{"$f":"M16*(1.03)","v":4036.6209561600003},null,null,{"$f":"P16*(1.03)","v":4157.7195848448},null,null,{"$f":"S16*(1.03)","v":4282.4511723901442},null,null,{"$f":"V16*(1.03)","v":4410.9247075618487},null,null,{"$f":"Y16*(1.03)","v":4543.252448788704},null,null,{"$f":"AB16*(1.03)","v":4679.5500222523651},null,null,{"$f":"AE16*(1.03)","v":4819.9365229199366},null,null,{"$f":"AH16*(1.03)","v":4964.5346186075349},null,null,{"$f":"AK16*(1.03)","v":5113.4706571657607},null,null,{"$f":"AN16*(1.03)","v":5266.8747768807334},null,null,{"$f":"AQ16*(1.03)","v":5424.8810201871556},null,null,{"$f":"AT16*(1.03)","v":5587.6274507927701},null,null,{"$f":"AW16*(1.03)","v":5755.2562743165536},null,null,{"$f":"AZ16*(1.03)","v":5927.9139625460502},null,null,{"$f":"BC16*(1.03)","v":6105.7513814224321},null,null,{"$f":"BF16*(1.03)","v":6288.9239228651049},null,null,{"$f":"BI16*(1.03)","v":6477.5916405510579},null,null,{"$f":"BL16*(1.03)","v":6671.9193897675896},null,null,{"$f":"BO16*(1.03)","v":6872.0769714606176},null,null,{"$f":"BR16*(1.03)","v":7078.2392806044363},null,null,{"$f":"BU16*(1.03)","v":7290.5864590225692},null,null,{"$f":"BX16*(1.03)","v":7509.3040527932462},null,null,{"$f":"CA16*(1.03)","v":7734.5831743770441},null,null,{"$f":"CD16*(1.03)","v":7966.6206696083555},null,null,{"$f":"CG16*(1.03)","v":8205.6192896966058},null,null,{"$f":"CJ16*(1.03)","v":8451.7878683875042},null,null,{"$f":"CM16*(1.03)","v":8705.3415044391295}]
["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":3500},null,null,{"$f":"D18*(1.03)","v":3605},null,null,{"$f":"G18*(1.03)","v":3713.15},null,null,{"$f":"J18*(1.03)","v":3824.5445},null,null,{"$f":"M18*(1.03)","v":3939.280835},null,null,{"$f":"P18*(1.03)","v":4057.45926005},null,null,{"$f":"S18*(1.03)","v":4179.1830378515006},null,null,{"$f":"V18*(1.03)","v":4304.558528987046},null,null,{"$f":"Y18*(1.03)","v":4433.6952848566571},null,null,{"$f":"AB18*(1.03)","v":4566.7061434023572},null,null,{"$f":"AE18*(1.03)","v":4703.7073277044283},null,null,{"$f":"AH18*(1.03)","v":4844.8185475355613},null,null,{"$f":"AK18*(1.03)","v":4990.1631039616286},null,null,{"$f":"AN18*(1.03)","v":5139.8679970804778},null,null,{"$f":"AQ18*(1.03)","v":5294.0640369928924},null,null,{"$f":"AT18*(1.03)","v":5452.8859581026791},null,null,{"$f":"AW18*(1.03)","v":5616.4725368457594},null,null,{"$f":"AZ18*(1.03)","v":5784.9667129511326},null,null,{"$f":"BC18*(1.03)","v":5958.5157143396664},null,null,{"$f":"BF18*(1.03)","v":6137.2711857698569},null,null,{"$f":"BI18*(1.03)","v":6321.3893213429528},null,null,{"$f":"BL18*(1.03)","v":6511.0310009832419},null,null,{"$f":"BO18*(1.03)","v":6706.3619310127397},null,null,{"$f":"BR18*(1.03)","v":6907.5527889431223},null,null,{"$f":"BU18*(1.03)","v":7114.779372611416},null,null,{"$f":"BX18*(1.03)","v":7328.2227537897588},null,null,{"$f":"CA18*(1.03)","v":7548.0694364034516},null,null,{"$f":"CD18*(1.03)","v":7774.5115194955551},null,null,{"$f":"CG18*(1.03)","v":8007.7468650804221},null,null,{"$f":"CJ18*(1.03)","v":8247.9792710328347},null,null,{"$f":"CM18*(1.03)","v":8495.4186491638193}]
["Property Insurance",null,null,{"$f":"Inputs!B71","v":3000},null,null,{"$f":"D19*1.03","v":3090},null,null,{"$f":"G19*1.03","v":3182.7000000000003},null,null,{"$f":"J19*1.03","v":3278.1810000000005},null,null,{"$f":"M19*1.03","v":3376.5264300000008},null,null,{"$f":"P19*1.03","v":3477.8222229000007},null,null,{"$f":"S19*1.03","v":3582.1568895870009},null,null,{"$f":"V19*1.03","v":3689.621596274611},null,null,{"$f":"Y19*1.03","v":3800.3102441628494},null,null,{"$f":"AB19*1.03","v":3914.3195514877348},null,null,{"$f":"AE19*1.03","v":4031.7491380323668},null,null,{"$f":"AH19*1.03","v":4152.7016121733377},null,null,{"$f":"AK19*1.03","v":4277.282660538538},null,null,{"$f":"AN19*1.03","v":4405.6011403546945},null,null,{"$f":"AQ19*1.03","v":4537.7691745653356},null,null,{"$f":"AT19*1.03","v":4673.902249802296},null,null,{"$f":"AW19*1.03","v":4814.1193172963649},null,null,{"$f":"AZ19*1.03","v":4958.5428968152564},null,null,{"$f":"BC19*1.03","v":5107.2991837197142},null,null,{"$f":"BF19*1.03","v":5260.5181592313056},null,null,{"$f":"BI19*1.03","v":5418.3337040082451},null,null,{"$f":"BL19*1.03","v":5580.8837151284924},null,null,{"$f":"BO19*1.03","v":5748.3102265823472},null,null,{"$f":"BR19*1.03","v":5920.7595333798181},null,null,{"$f":"BU19*1.03","v":6098.3823193812132},null,null,{"$f":"BX19*1.03","v":6281.33378896265},null,null,{"$f":"CA19*1.03","v":6469.7738026315301},null,null,{"$f":"CD19*1.03","v":6663.8670167104765},null,null,{"$f":"CG19*1.03","v":6863.7830272117908},null,null,{"$f":"CJ19*1.03","v":7069.696518028145},null,null,{"$f":"CM19*1.03","v":7281.7874135689899}]
["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":10052},null,null,{"$f":"SUM(G15:G26)","v":10389.08},null,null,{"$f":"SUM(J15:J26)","v":10700.752400000001},null,null,{"$f":"SUM(M15:M26)","v":11021.774972000001},null,null,{"$f":"SUM(P15:P26)","v":11352.42822116},null,null,{"$f":"SUM(S15:S26)","v":11693.001067794799},null,null,{"$f":"SUM(V15:V26)","v":12043.791099828646},null,null,{"$f":"SUM(Y15:Y26)","v":12405.104832823505},null,null,{"$f":"SUM(AB15:AB26)","v":12777.257977808209},null,null,{"$f":"SUM(AE15:AE26)","v":13160.575717142458},null,null,{"$f":"SUM(AH15:AH26)","v":13555.392988656731},null,null,{"$f":"SUM(AK15:AK26)","v":13962.054778316435},null,null,{"$f":"SUM(AN15:AN26)","v":14380.916421665926},null,null,{"$f":"SUM(AQ15:AQ26)","v":14812.343914315905},null,null,{"$f":"SUM(AT15:AT26)","v":15256.714231745384},null,null,{"$f":"SUM(AW15:AW26)","v":15714.415658697744},null,null,{"$f":"SUM(AZ15:AZ26)","v":16185.848128458678},null,null,{"$f":"SUM(BC15:BC26)","v":16671.42357231244},null,null,{"$f":"SUM(BF15:BF26)","v":17171.566279481813},null,null,{"$f":"SUM(BI15:BI26)","v":17686.713267866267},null,null,{"$f":"SUM(BL15:BL26)","v":18217.314665902257},null,null,{"$f":"SUM(BO15:BO26)","v":18763.834105879323},null,null,{"$f":"SUM(BR15:BR26)","v":19326.749129055705},null,null,{"$f":"SUM(BU15:BU26)","v":19906.551602927379},null,null,{"$f":"SUM(BX15:BX26)","v":20503.748151015199},null,null,{"$f":"SUM(CA15:CA26)","v":21118.860595545655},null,null,{"$f":"SUM(CD15:CD26)","v":21752.426413412028},null,null,{"$f":"SUM(CG15:CG26)","v":22404.999205814387},null,null,{"$f":"SUM(CJ15:CJ26)","v":23077.149181988818},null,null,{"$f":"SUM(CM15:CM26)","v":23769.463657448483},null,null,{"$f":"SUM(CP15:CP26)","v":24482.547567171936}]
[]
["Net Operating Income",null,null,{"$f":"D12-D27","v":32128},null,null,{"$f":"G12-G27","v":33478.119999999995},null,null,{"$f":"J12-J27","v":34921.135599999994},null,null,{"$f":"M12-M27","v":36424.988548000001},null,null,{"$f":"P12-P27","v":37992.205839640003},null,null,{"$f":"S12-S27","v":39625.418355437199},null,null,{"$f":"V12-V27","v":41327.365100332638},null,null,{"$f":"Y12-Y27","v":43100.897615344235},null,null,{"$f":"AB12-AB27","v":44948.984568286236},null,null,{"$f":"AE12-AE27","v":46874.716530795769},null,null,{"$f":"AH12-AH27","v":48881.310949199033},null,null,{"$f":"AK12-AK27","v":50972.117317053555},null,null,{"$f":"AN12-AN27","v":53150.622557518873},null,null,{"$f":"AQ12-AQ27","v":55420.456624036291},null,null,{"$f":"AT12-AT27","v":57785.398328140902},null,null,{"$f":"AW12-AW27","v":60249.38140358399},null,null,{"$f":"AZ12-AZ27","v":62816.50081631435},null,null,{"$f":"BC12-BC27","v":65491.019330251511},null,null,{"$f":"BF12-BF27","v":68277.374339184695},null,null,{"$f":"BI12-BI27","v":71180.184975546901},null,null,{"$f":"BL12-BL27","v":74204.259507247451},null,null,{"$f":"BO12-BO27","v":77354.603034196363},null,null,{"$f":"BR12-BR27","v":80636.425496623036},null,null,{"$f":"BU12-BU27","v":84055.150007778517},null,null,{"$f":"BX12-BX27","v":87616.421524118938},null,null,{"$f":"CA12-CA27","v":91326.115866593856},null,null,{"$f":"CD12-CD27","v":95190.349107213056},null,null,{"$f":"CG12-CG27","v":99215.487335635713},null,null,{"$f":"CJ12-CJ27","v":103408.15682111928},null,null,{"$f":"CM12-CM27","v":107775.25458578393},null,null,{"$f":"CP12-CP27","v":112323.95940578978}]
[]
["Less: Annual Mortgage Payments",null,null,{"$f":"IF(D37>0,PMT(Inputs!B35/12,Inputs!B36*12,Inputs!B29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(D37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(G37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(J37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(M37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(P37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(S37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(V37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(Y37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AB37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AE37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AH37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AK37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AN37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AQ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AT37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AW37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AZ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BC37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BF37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BI37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BL37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BO37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BR37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BU37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BX37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(CA37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(CD37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(CG37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(CJ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},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":-20058.079169493241},null,null,{"$f":"G29+G31+G32","v":-18707.959169493246},null,null,{"$f":"J29+J31+J32","v":-17264.943569493247},null,null,{"$f":"M29+M31+M32","v":-15761.09062149324},null,null,{"$f":"P29+P31+P32","v":-14193.873329853239},null,null,{"$f":"S29+S31+S32","v":-12560.660814056042},null,null,{"$f":"V29+V31+V32","v":-10858.714069160604},null,null,{"$f":"Y29+Y31+Y32","v":-9085.1815541490068},null,null,{"$f":"AB29+AB31+AB32","v":-7237.0946012070053},null,null,{"$f":"AE29+AE31+AE32","v":-5311.362638697472},null,null,{"$f":"AH29+AH31+AH32","v":-3304.7682202942087},null,null,{"$f":"AK29+AK31+AK32","v":-1213.9618524396865},null,null,{"$f":"AN29+AN31+AN32","v":964.54338802563143},null,null,{"$f":"AQ29+AQ31+AQ32","v":3234.3774545430497},null,null,{"$f":"AT29+AT31+AT32","v":5599.3191586476605},null,null,{"$f":"AW29+AW31+AW32","v":8063.3022340907482},null,null,{"$f":"AZ29+AZ31+AZ32","v":10630.421646821109},null,null,{"$f":"BC29+BC31+BC32","v":13304.940160758269},null,null,{"$f":"BF29+BF31+BF32","v":16091.295169691453},null,null,{"$f":"BI29+BI31+BI32","v":18994.10580605366},null,null,{"$f":"BL29+BL31+BL32","v":22018.180337754209},null,null,{"$f":"BO29+BO31+BO32","v":25168.523864703122},null,null,{"$f":"BR29+BR31+BR32","v":28450.346327129795},null,null,{"$f":"BU29+BU31+BU32","v":31869.070838285275},null,null,{"$f":"BX29+BX31+BX32","v":35430.342354625696},null,null,{"$f":"CA29+CA31+CA32","v":39140.036697100615},null,null,{"$f":"CD29+CD31+CD32","v":43004.269937719815},null,null,{"$f":"CG29+CG31+CG32","v":47029.408166142472},null,null,{"$f":"CJ29+CJ31+CJ32","v":51222.077651626038},null,null,{"$f":"CM29+CM31+CM32","v":55589.175416290687},null,null,{"$f":"CP29+CP31+CP32","v":112323.95940578978}]
[]
["Property Value at End of Year",null,null,{"$f":"Inputs!B24*(1+Inputs!B49)","v":746750},null,null,{"$f":"D36*(1+Inputs!$B$49)","v":769152.5},null,null,{"$f":"G36*(1+Inputs!$B$49)","v":792227.07500000007},null,null,{"$f":"J36*(1+Inputs!$B$49)","v":815993.88725000015},null,null,{"$f":"M36*(1+Inputs!$B$49)","v":840473.70386750018},null,null,{"$f":"P36*(1+Inputs!$B$49)","v":865687.91498352517},null,null,{"$f":"S36*(1+Inputs!$B$49)","v":891658.55243303091},null,null,{"$f":"V36*(1+Inputs!$B$49)","v":918408.30900602182},null,null,{"$f":"Y36*(1+Inputs!$B$49)","v":945960.55827620253},null,null,{"$f":"AB36*(1+Inputs!$B$49)","v":974339.37502448866},null,null,{"$f":"AE36*(1+Inputs!$B$49)","v":1003569.5562752234},null,null,{"$f":"AH36*(1+Inputs!$B$49)","v":1033676.6429634801},null,null,{"$f":"AK36*(1+Inputs!$B$49)","v":1064686.9422523845},null,null,{"$f":"AN36*(1+Inputs!$B$49)","v":1096627.550519956},null,null,{"$f":"AQ36*(1+Inputs!$B$49)","v":1129526.3770355547},null,null,{"$f":"AT36*(1+Inputs!$B$49)","v":1163412.1683466213},null,null,{"$f":"AW36*(1+Inputs!$B$49)","v":1198314.5333970201},null,null,{"$f":"AZ36*(1+Inputs!$B$49)","v":1234263.9693989307},null,null,{"$f":"BC36*(1+Inputs!$B$49)","v":1271291.8884808987},null,null,{"$f":"BF36*(1+Inputs!$B$49)","v":1309430.6451353256},null,null,{"$f":"BI36*(1+Inputs!$B$49)","v":1348713.5644893853},null,null,{"$f":"BL36*(1+Inputs!$B$49)","v":1389174.9714240669},null,null,{"$f":"BO36*(1+Inputs!$B$49)","v":1430850.2205667889},null,null,{"$f":"BR36*(1+Inputs!$B$49)","v":1473775.7271837927},null,null,{"$f":"BU36*(1+Inputs!$B$49)","v":1517988.9989993065},null,null,{"$f":"BX36*(1+Inputs!$B$49)","v":1563528.6689692857},null,null,{"$f":"CA36*(1+Inputs!$B$49)","v":1610434.5290383643},null,null,{"$f":"CD36*(1+Inputs!$B$49)","v":1658747.5649095152},null,null,{"$f":"CG36*(1+Inputs!$B$49)","v":1708509.9918568006},null,null,{"$f":"CJ36*(1+Inputs!$B$49)","v":1759765.2916125047},null,null,{"$f":"CM36*(1+Inputs!$B$49)","v":1812558.25036088}]
["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":681037.04868577584},null,null,{"$f":"D37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,13,24,0)","v":672808.36521688383},null,null,{"$f":"G37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,25,36,0)","v":664029.46478400496},null,null,{"$f":"J37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,37,48,0)","v":654663.55672571645},null,null,{"$f":"M37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,49,60,0)","v":644671.39034599741},null,null,{"$f":"P37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,61,72,0)","v":634011.0904222083},null,null,{"$f":"S37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,73,84,0)","v":622637.98171419138},null,null,{"$f":"V37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,85,96,0)","v":610504.40173904225},null,null,{"$f":"Y37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,97,108,0)","v":597559.50102692994},null,null,{"$f":"AB37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,109,120,0)","v":583749.03002087492},null,null,{"$f":"AE37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,121,132,0)","v":569015.1117274249},null,null,{"$f":"AH37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,133,144,0)","v":553295.99916545057},null,null,{"$f":"AK37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,145,156,0)","v":536525.81659657729},null,null,{"$f":"AN37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,157,168,0)","v":518634.28345279925},null,null,{"$f":"AQ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,169,180,0)","v":499546.41980431095},null,null,{"$f":"AT37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,181,192,0)","v":479182.23213322891},null,null,{"$f":"AW37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,193,204,0)","v":457456.37809634232},null,null,{"$f":"AZ37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,205,216,0)","v":434277.80887197901},null,null,{"$f":"BC37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,217,228,0)","v":409549.38759213174},null,null,{"$f":"BF37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,229,240,0)","v":383167.48226076848},null,null,{"$f":"BI37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,241,252,0)","v":355021.5314523264},null,null,{"$f":"BL37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,253,264,0)","v":324993.58097031678},null,null,{"$f":"BO37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,265,276,0)","v":292957.78952426719},null,null,{"$f":"BR37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,277,288,0)","v":258779.90135338926},null,null,{"$f":"BU37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,289,300,0)","v":222316.68358684078},null,null,{"$f":"BX37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,301,312,0)","v":183415.32598266835},null,null,{"$f":"CA37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,313,324,0)","v":141912.80052985367},null,null,{"$f":"CD37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,325,336,0)","v":97635.17822968011},null,null,{"$f":"CG37+CUMPRINC(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,337,348,0)","v":50396.900193183741},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":65712.951314224163},null,null,{"$f":"G36-G37","v":96344.134783116169},null,null,{"$f":"J36-J37","v":128197.61021599511},null,null,{"$f":"M36-M37","v":161330.33052428369},null,null,{"$f":"P36-P37","v":195802.31352150277},null,null,{"$f":"S36-S37","v":231676.82456131687},null,null,{"$f":"V36-V37","v":269020.57071883953},null,null,{"$f":"Y36-Y37","v":307903.90726697957},null,null,{"$f":"AB36-AB37","v":348401.05724927259},null,null,{"$f":"AE36-AE37","v":390590.34500361374},null,null,{"$f":"AH36-AH37","v":434554.44454779848},null,null,{"$f":"AK36-AK37","v":480380.64379802952},null,null,{"$f":"AN36-AN37","v":528161.12565580721},null,null,{"$f":"AQ36-AQ37","v":577993.26706715673},null,null,{"$f":"AT36-AT37","v":629979.95723124384},null,null,{"$f":"AW36-AW37","v":684229.93621339242},null,null,{"$f":"AZ36-AZ37","v":740858.15530067775},null,null,{"$f":"BC36-BC37","v":799986.16052695166},null,null,{"$f":"BF36-BF37","v":861742.50088876695},null,null,{"$f":"BI36-BI37","v":926263.16287455708},null,null,{"$f":"BL36-BL37","v":993692.03303705901},null,null,{"$f":"BO36-BO37","v":1064181.3904537503},null,null,{"$f":"BR36-BR37","v":1137892.4310425217},null,null,{"$f":"BU36-BU37","v":1214995.8258304035},null,null,{"$f":"BX36-BX37","v":1295672.3154124657},null,null,{"$f":"CA36-CA37","v":1380113.3429866172},null,null,{"$f":"CD36-CD37","v":1468521.7285085106},null,null,{"$f":"CG36-CG37","v":1561112.3866798352},null,null,{"$f":"CJ36-CJ37","v":1658113.0916636169},null,null,{"$f":"CM36-CM37","v":1759765.2916125047},null,null,{"$f":"CP36-CP37","v":1812558.25036088}]
[]
["ROI QuadrantTM"]
["Appreciation",null,null,{"$f":"D36-$M$2","v":21750},{"$f":"(D36-$M$2)/$M$7","v":0.36901934170342721},null,{"$f":"G36-D36","v":22402.5},{"$f":"(G36-D36)/$M$7","v":0.38008992195453001},null,{"$f":"J36-G36","v":23074.57500000007},{"$f":"(J36-G36)/$M$7","v":0.39149261961316711},null,{"$f":"M36-J36","v":23766.812250000075},{"$f":"(M36-J36)/$M$7","v":0.40323739820156218},null,{"$f":"P36-M36","v":24479.816617500037},{"$f":"(P36-M36)/$M$7","v":0.41533452014760835},null,{"$f":"S36-P36","v":25214.211116024991},{"$f":"(S36-P36)/$M$7","v":0.42779455575203584},null,{"$f":"V36-S36","v":25970.637449505739},{"$f":"(V36-S36)/$M$7","v":0.44062839242459684},null,{"$f":"Y36-V36","v":26749.756572990911},{"$f":"(Y36-V36)/$M$7","v":0.45384724419733474},null,{"$f":"AB36-Y36","v":27552.249270180706},{"$f":"(AB36-Y36)/$M$7","v":0.46746266152325594},null,{"$f":"AE36-AB36","v":28378.816748286132},{"$f":"(AE36-AB36)/$M$7","v":0.48148654136895369},null,{"$f":"AH36-AE36","v":29230.18125073472},{"$f":"(AH36-AE36)/$M$7","v":0.49593113761002239},null,{"$f":"AK36-AH36","v":30107.086688256706},{"$f":"(AK36-AH36)/$M$7","v":0.51080907173832213},null,{"$f":"AN36-AK36","v":31010.299288904411},{"$f":"(AN36-AK36)/$M$7","v":0.52613334389047184},null,{"$f":"AQ36-AN36","v":31940.608267571544},{"$f":"(AQ36-AN36)/$M$7","v":0.54191734420718607},null,{"$f":"AT36-AQ36","v":32898.826515598688},{"$f":"(AT36-AQ36)/$M$7","v":0.55817486453340159},null,{"$f":"AW36-AT36","v":33885.791311066598},{"$f":"(AW36-AT36)/$M$7","v":0.57492011046940272},null,{"$f":"AZ36-AW36","v":34902.365050398745},{"$f":"(AZ36-AW36)/$M$7","v":0.59216771378348732},null,{"$f":"BC36-AZ36","v":35949.436001910595},{"$f":"(BC36-AZ36)/$M$7","v":0.60993274519699003},null,{"$f":"BF36-BC36","v":37027.919081968023},{"$f":"(BF36-BC36)/$M$7","v":0.62823072755290166},null,{"$f":"BI36-BF36","v":38138.756654426921},{"$f":"(BI36-BF36)/$M$7","v":0.64707764937948631},null,{"$f":"BL36-BI36","v":39282.919354059733},{"$f":"(BL36-BI36)/$M$7","v":0.66648997886087091},null,{"$f":"BO36-BL36","v":40461.406934681581},{"$f":"(BO36-BL36)/$M$7","v":0.68648467822669801},null,{"$f":"BR36-BO36","v":41675.249142721994},{"$f":"(BR36-BO36)/$M$7","v":0.70707921857349831},null,{"$f":"BU36-BR36","v":42925.506617003819},{"$f":"(BU36-BR36)/$M$7","v":0.72829159513070607},null,{"$f":"BX36-BU36","v":44213.271815513726},{"$f":"(BX36-BU36)/$M$7","v":0.75014034298462384},null,{"$f":"CA36-BX36","v":45539.669969979208},{"$f":"(CA36-BX36)/$M$7","v":0.7726445532741637},null,{"$f":"CD36-CA36","v":46905.860069078626},{"$f":"(CD36-CA36)/$M$7","v":0.79582388987238928},null,{"$f":"CG36-CD36","v":48313.035871150903},{"$f":"(CG36-CD36)/$M$7","v":0.81969860656855964},null,{"$f":"CJ36-CG36","v":49762.426947285421},{"$f":"(CJ36-CG36)/$M$7","v":0.84428956476561623},null,{"$f":"CM36-CJ36","v":51255.299755704124},{"$f":"(CM36-CJ36)/$M$7","v":0.86961825170858709},null,{"$f":"CP36-CM36","v":52792.958748375298},{"$f":"(CP36-CM36)/$M$7","v":0.89570679925984553}]
["Cash Flow ",null,null,{"$f":"D34","v":-20058.079169493241},{"$f":"D34/$M$7","v":-0.34031352510168378},null,{"$f":"G34","v":-18707.959169493246},{"$f":"G34/$M$7","v":-0.31740684033751687},null,{"$f":"J34","v":-17264.943569493247},{"$f":"J34/$M$7","v":-0.29292405106028585},null,{"$f":"M34","v":-15761.09062149324},{"$f":"M34/$M$7","v":-0.267409070605586},null,{"$f":"P34","v":-14193.873329853239},{"$f":"P34/$M$7","v":-0.24081902493812757},null,{"$f":"S34","v":-12560.660814056042},{"$f":"S34/$M$7","v":-0.21310927746956299},null,{"$f":"V34","v":-10858.714069160604},{"$f":"V34/$M$7","v":-0.1842333571286156},null,{"$f":"Y34","v":-9085.1815541490068},{"$f":"Y34/$M$7","v":-0.15414288351118097},null,{"$f":"AB34","v":-7237.0946012070053},{"$f":"AB34/$M$7","v":-0.12278748899231431},null,{"$f":"AE34","v":-5311.362638697472},{"$f":"AE34/$M$7","v":-9.0114737677256057E-2},null,{"$f":"AH34","v":-3304.7682202942087},{"$f":"AH34/$M$7","v":-5.6070041063695432E-2},null,{"$f":"AK34","v":-1213.9618524396865},{"$f":"AK34/$M$7","v":-2.0596570282315686E-2},null,{"$f":"AN34","v":964.54338802563143},{"$f":"AN34/$M$7","v":1.6364835222694798E-2},null,{"$f":"AQ34","v":3234.3774545430497},{"$f":"AQ34/$M$7","v":5.4875762717052079E-2},null,{"$f":"AT34","v":5599.3191586476605},{"$f":"AT34/$M$7","v":9.5000325053404486E-2},null,{"$f":"AW34","v":8063.3022340907482},{"$f":"AW34/$M$7","v":0.13680526355769848},null,{"$f":"AZ34","v":10630.421646821109},{"$f":"AZ34/$M$7","v":0.18036005508688682},null,{"$f":"BC34","v":13304.940160758269},{"$f":"BC34/$M$7","v":0.22573702342650609},null,{"$f":"BF34","v":16091.295169691453},{"$f":"BF34/$M$7","v":0.27301145520345188},null,{"$f":"BI34","v":18994.10580605366},{"$f":"BI34/$M$7","v":0.32226172049632951},null,{"$f":"BL34","v":22018.180337754209},{"$f":"BL34/$M$7","v":0.37356939833312197},null,{"$f":"BO34","v":25168.523864703122},{"$f":"BO34/$M$7","v":0.42701940727355142},null,{"$f":"BR34","v":28450.346327129795},{"$f":"BR34/$M$7","v":0.48270014128146921},null,{"$f":"BU34","v":31869.070838285275},{"$f":"BU34/$M$7","v":0.54070361110086995},null,{"$f":"BX34","v":35430.342354625696},{"$f":"BX34/$M$7","v":0.60112559135774846},null,{"$f":"CA34","v":39140.036697100615},{"$f":"CA34/$M$7","v":0.66406577361894492},null,{"$f":"CD34","v":43004.269937719815},{"$f":"CD34/$M$7","v":0.72962792564845291},null,{"$f":"CG34","v":47029.408166142472},{"$f":"CG34/$M$7","v":0.79792005711134151},null,{"$f":"CJ34","v":51222.077651626038},{"$f":"CJ34/$M$7","v":0.86905459198551127},null,{"$f":"CM34","v":55589.175416290687},{"$f":"CM34/$M$7","v":0.94314854795199676},null,{"$f":"CP34","v":112323.95940578978},{"$f":"CP34/$M$7","v":1.9057339566642311}]
["Debt Paydown ",null,null,{"$f":"M3-$D$37","v":7712.9513142241631},{"$f":"(M3-D37)/M7","v":0.13086106742830272},null,{"$f":"D37-G37","v":8228.6834688920062},{"$f":"(D37-G37)/$M$7","v":0.13961118881730583},null,{"$f":"G37-J37","v":8778.9004328788724},{"$f":"(G37-J37)/$M$7","v":0.1489463934998112},null,{"$f":"J37-M37","v":9365.9080582885072},{"$f":"(J37-M37)/$M$7","v":0.15890580349997468},null,{"$f":"M37-P37","v":9992.1663797190413},{"$f":"(M37-P37)/$M$7","v":0.16953115676482933},null,{"$f":"P37-S37","v":10660.299923789105},{"$f":"(P37-S37)/$M$7","v":0.1808669820798966},null,{"$f":"S37-V37","v":11373.108708016924},{"$f":"(S37-V37)/$M$7","v":0.19296078568064004},null,{"$f":"V37-Y37","v":12133.579975149129},{"$f":"(V37-Y37)/$M$7","v":0.20586325034185832},null,{"$f":"Y37-AB37","v":12944.900712112314},{"$f":"(Y37-AB37)/$M$7","v":0.21962844777930632},null,{"$f":"AB37-AE37","v":13810.471006055013},{"$f":"(AB37-AE37)/$M$7","v":0.23431406525373283},null,{"$f":"AE37-AH37","v":14733.918293450028},{"$f":"(AE37-AH37)/$M$7","v":0.24998164732694311},null,{"$f":"AH37-AK37","v":15719.112561974325},{"$f":"(AH37-AK37)/$M$7","v":0.26669685378307306},null,{"$f":"AK37-AN37","v":16770.182568873279},{"$f":"(AK37-AN37)/$M$7","v":0.28452973479594978},null,{"$f":"AN37-AQ37","v":17891.533143778041},{"$f":"(AN37-AQ37)/$M$7","v":0.30355502449572513},null,{"$f":"AQ37-AT37","v":19087.863648488303},{"$f":"(AQ37-AT37)/$M$7","v":0.32385245416505432},null,{"$f":"AT37-AW37","v":20364.187671082036},{"$f":"(AT37-AW37)/$M$7","v":0.34550708637736743},null,{"$f":"AW37-AZ37","v":21725.854036886594},{"$f":"(AW37-AZ37)/$M$7","v":0.36860967147754659},null,{"$f":"AZ37-BC37","v":23178.569224363309},{"$f":"(AZ37-BC37)/$M$7","v":0.39325702789893635},null,{"$f":"BC37-BF37","v":24728.421279847273},{"$f":"(BC37-BF37)/$M$7","v":0.41955244791054075},null,{"$f":"BF37-BI37","v":26381.905331363261},{"$f":"(BF37-BI37)/$M$7","v":0.44760613049479575},null,{"$f":"BI37-BL37","v":28145.950808442081},{"$f":"(BI37-BL37)/$M$7","v":0.47753564317003871},null,{"$f":"BL37-BO37","v":30027.950482009619},{"$f":"(BL37-BO37)/$M$7","v":0.50946641469307119},null,{"$f":"BO37-BR37","v":32035.791446049581},{"$f":"(BO37-BR37)/$M$7","v":0.54353226070664373},null,{"$f":"BR37-BU37","v":34177.888170877937},{"$f":"(BR37-BU37)/$M$7","v":0.57987594453474611},null,{"$f":"BU37-BX37","v":36463.217766548478},{"$f":"(BU37-BX37)/$M$7","v":0.61864977547588185},null,{"$f":"BX37-CA37","v":38901.35760417243},{"$f":"(BX37-CA37)/$M$7","v":0.66001624710166995},null,{"$f":"CA37-CD37","v":41502.525452814676},{"$f":"(CA37-CD37)/$M$7","v":0.70414871823574277},null,{"$f":"CD37-CG37","v":44277.622300173563},{"$f":"(CD37-CG37)/$M$7","v":0.75123213946680634},null,{"$f":"CG37-CJ37","v":47238.278036496369},{"$f":"(CG37-CJ37)/$M$7","v":0.80146382824052209},null,{"$f":"CJ37-CM37","v":50396.900193183741},{"$f":"(CJ37-CM37)/$M$7","v":0.85505429577848224},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":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/2","v":3585.4545454545455},{"$f":"(((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/2)/$M$7","v":6.0832279359595273E-2},null,0,0,null,0,0,null,0,0,null,0,0]
["Total Return on Investment",null,null,{"$f":"SUM(D41:D44)","v":16575.781235640014},{"$f":"SUM(E41:E44)","v":0.28123144274923673},null,{"$f":"SUM(G41:G44)","v":19094.133390307852},{"$f":"SUM(H41:H44)","v":0.32395882915350949},null,{"$f":"SUM(J41:J44)","v":21759.440954294787},{"$f":"SUM(K41:K44)","v":0.36917952077188299},null,{"$f":"SUM(M41:M44)","v":24542.538777704434},{"$f":"SUM(N41:N44)","v":0.41639868981514139},null,{"$f":"SUM(P41:P44)","v":27449.018758274931},{"$f":"SUM(Q41:Q44)","v":0.46571121069350063},null,{"$f":"SUM(S41:S44)","v":30484.759316667147},{"$f":"SUM(T41:T44)","v":0.51721681908156003},null,{"$f":"SUM(V41:V44)","v":33655.941179271147},{"$f":"SUM(W41:W44)","v":0.57102037969581187},null,{"$f":"SUM(Y41:Y44)","v":36969.064084900121},{"$f":"SUM(Z41:Z44)","v":0.62723216974720264},null,{"$f":"SUM(AB41:AB44)","v":40430.964471995103},{"$f":"SUM(AC41:AC44)","v":0.68596817902943852},null,{"$f":"SUM(AE41:AE44)","v":44048.834206552761},{"$f":"SUM(AF41:AF44)","v":0.74735042766462112},null,{"$f":"SUM(AH41:AH44)","v":47830.240414799628},{"$f":"SUM(AI41:AI44)","v":0.81150730259246062},null,{"$f":"SUM(AK41:AK44)","v":51783.146488700433},{"$f":"SUM(AL41:AL44)","v":0.87857391395827011},null,{"$f":"SUM(AN41:AN44)","v":55915.934336712409},{"$f":"SUM(AO41:AO44)","v":0.94869247262830703},null,{"$f":"SUM(AQ41:AQ44)","v":60237.427956801723},{"$f":"SUM(AR41:AR44)","v":1.0220126901391537},null,{"$f":"SUM(AT41:AT44)","v":64756.91841364374},{"$f":"SUM(AU41:AU44)","v":1.0986922024710508},null,{"$f":"SUM(AW41:AW44)","v":69484.19030714847},{"$f":"SUM(AX41:AX44)","v":1.1788970191236592},null,{"$f":"SUM(AZ41:AZ44)","v":74429.549825015536},{"$f":"SUM(BA41:BA44)","v":1.2628019990671111},null,{"$f":"SUM(BC41:BC44)","v":79603.854477941262},{"$f":"SUM(BD41:BD44)","v":1.3505913552416229},null,{"$f":"SUM(BF41:BF44)","v":85018.544622415837},{"$f":"SUM(BG41:BG44)","v":1.4424591893860848},null,{"$f":"SUM(BI41:BI44)","v":90685.67688275293},{"$f":"SUM(BJ41:BJ44)","v":1.538610059089802},null,{"$f":"SUM(BL41:BL44)","v":96617.959591165112},{"$f":"SUM(BM41:BM44)","v":1.6392595790832218},null,{"$f":"SUM(BO41:BO44)","v":102828.79037230341},{"$f":"SUM(BP41:BP44)","v":1.744635058912511},null,{"$f":"SUM(BR41:BR44)","v":109332.29600681046},{"$f":"SUM(BS41:BS44)","v":1.8549761792808017},null,{"$f":"SUM(BU41:BU44)","v":116143.37471707612},{"$f":"SUM(BV41:BV44)","v":1.9705357094855127},null,{"$f":"SUM(BX41:BX44)","v":123277.74102759699},{"$f":"SUM(BY41:BY44)","v":2.0915802685374447},null,{"$f":"SUM(CA41:CA44)","v":130751.97336216134},{"$f":"SUM(CB41:CB44)","v":2.2183911327139691},null,{"$f":"SUM(CD41:CD44)","v":134998.11000506769},{"$f":"SUM(CE41:CE44)","v":2.2904328131161806},null,{"$f":"SUM(CG41:CG44)","v":139620.06633746694},{"$f":"SUM(CH41:CH44)","v":2.3688508031467075},null,{"$f":"SUM(CJ41:CJ44)","v":148222.78263540781},{"$f":"SUM(CK41:CK44)","v":2.5148079849916494},null,{"$f":"SUM(CM41:CM44)","v":157241.37536517857},{"$f":"SUM(CN41:CN44)","v":2.667821095439066},null,{"$f":"SUM(CP41:CP44)","v":165116.91815416509},{"$f":"SUM(CQ41:CQ44)","v":2.8014407559240766}]
[]
[{"$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 Synergy One Lending 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.  This spreadsheet is copyrighted as of 2011 through present day.  Any use modifications or distributions are only with permission of Joe Massey. "}]
[]
[]
[null,{"$f":"-M7","v":-58940},null,{"$f":"D34*0.7","v":-14040.655418645269},null,null,{"$f":"G34*0.7","v":-13095.571418645271},null,null,{"$f":"J34*0.7","v":-12085.460498645272},null,null,{"$f":"M34*0.7","v":-11032.763435045268},null,null,{"$f":"P51+P56","v":111484.65617891258},null,null,{"$f":"IRR(B50:P50)","v":5.3354876136446627E-3},"IRR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P34*0.7","v":-9935.7113308972657}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P36*0.93","v":781640.5445967752},"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":136969.15425077779},"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":79330.544596775202},"Capital Gain Base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P54*0.196","v":15548.78674096794},"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":121420.36750980985},"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":-20058.079169493241},{"$f":"G34","v":-18707.959169493246},{"$f":"J34","v":-17264.943569493247},{"$f":"M34","v":-15761.09062149324},{"$f":"P34","v":-14193.873329853239},{"$f":"S34","v":-12560.660814056042},{"$f":"V34","v":-10858.714069160604},{"$f":"Y34","v":-9085.1815541490068},{"$f":"AB34","v":-7237.0946012070053},{"$f":"AE34","v":-5311.362638697472},{"$f":"AH34","v":-3304.7682202942087},{"$f":"AK34","v":-1213.9618524396865},{"$f":"AN34","v":964.54338802563143},{"$f":"AQ34","v":3234.3774545430497},{"$f":"AT34","v":5599.3191586476605},{"$f":"AW34","v":8063.3022340907482},{"$f":"AZ34","v":10630.421646821109},{"$f":"BC34","v":13304.940160758269},{"$f":"BF34","v":16091.295169691453},{"$f":"BI34","v":18994.10580605366},{"$f":"BL34","v":22018.180337754209},{"$f":"BO34","v":25168.523864703122},{"$f":"BR34","v":28450.346327129795},{"$f":"BU34","v":31869.070838285275},{"$f":"BX34","v":35430.342354625696},{"$f":"CA34","v":39140.036697100615},{"$f":"CD34","v":43004.269937719815},{"$f":"CG34","v":47029.408166142472},{"$f":"CJ34","v":51222.077651626038},{"$f":"CM34","v":55589.175416290687},{"$f":"CP34","v":112323.95940578978}]
[]
[]
[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":21750},{"$f":"G41","v":22402.5},{"$f":"J41","v":23074.57500000007},{"$f":"M41","v":23766.812250000075},{"$f":"P41","v":24479.816617500037},{"$f":"S41","v":25214.211116024991},{"$f":"V41","v":25970.637449505739},{"$f":"Y41","v":26749.756572990911},{"$f":"AB41","v":27552.249270180706},{"$f":"AE41","v":28378.816748286132},{"$f":"AH41","v":29230.18125073472},{"$f":"AK41","v":30107.086688256706},{"$f":"AN41","v":31010.299288904411},{"$f":"AQ41","v":31940.608267571544},{"$f":"AT41","v":32898.826515598688},{"$f":"AW41","v":33885.791311066598},{"$f":"AZ41","v":34902.365050398745},{"$f":"BC41","v":35949.436001910595},{"$f":"BF41","v":37027.919081968023},{"$f":"BI41","v":38138.756654426921},{"$f":"BL41","v":39282.919354059733},{"$f":"BO41","v":40461.406934681581},{"$f":"BR41","v":41675.249142721994},{"$f":"BU41","v":42925.506617003819},{"$f":"BX41","v":44213.271815513726},{"$f":"CA41","v":45539.669969979208},{"$f":"CD41","v":46905.860069078626},{"$f":"CG41","v":48313.035871150903},{"$f":"CJ41","v":49762.426947285421},{"$f":"CM41","v":51255.299755704124},{"$f":"CP41","v":52792.958748375298}]
[null,"Cash Flow ",0,{"$f":"D42","v":-20058.079169493241},{"$f":"G42","v":-18707.959169493246},{"$f":"J42","v":-17264.943569493247},{"$f":"M42","v":-15761.09062149324},{"$f":"P42","v":-14193.873329853239},{"$f":"S42","v":-12560.660814056042},{"$f":"V42","v":-10858.714069160604},{"$f":"Y42","v":-9085.1815541490068},{"$f":"AB42","v":-7237.0946012070053},{"$f":"AE42","v":-5311.362638697472},{"$f":"AH42","v":-3304.7682202942087},{"$f":"AK42","v":-1213.9618524396865},{"$f":"AN42","v":964.54338802563143},{"$f":"AQ42","v":3234.3774545430497},{"$f":"AT42","v":5599.3191586476605},{"$f":"AW42","v":8063.3022340907482},{"$f":"AZ42","v":10630.421646821109},{"$f":"BC42","v":13304.940160758269},{"$f":"BF42","v":16091.295169691453},{"$f":"BI42","v":18994.10580605366},{"$f":"BL42","v":22018.180337754209},{"$f":"BO42","v":25168.523864703122},{"$f":"BR42","v":28450.346327129795},{"$f":"BU42","v":31869.070838285275},{"$f":"BX42","v":35430.342354625696},{"$f":"CA42","v":39140.036697100615},{"$f":"CD42","v":43004.269937719815},{"$f":"CG42","v":47029.408166142472},{"$f":"CJ42","v":51222.077651626038},{"$f":"CM42","v":55589.175416290687},{"$f":"CP42","v":112323.95940578978}]
[null,"Debt Paydown ",0,7712.9513142241631,8228.6834688920062,8778.9004328788724,9365.9080582885072,9992.1663797190413,10660.299923789105,11373.108708016924,12133.579975149129,12944.900712112314,13810.471006055013,14733.918293450028,15719.112561974325,16770.182568873279,17891.533143778041,19087.863648488303,20364.187671082036,21725.854036886594,23178.569224363309,24728.421279847273,26381.905331363261,28145.950808442081,30027.950482009619,32035.791446049581,34177.888170877937,36463.217766548478,38901.35760417243,41502.525452814676,44277.622300173563,47238.278036496369,50396.900193183741,0]
[null,"Depreciation",0,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,3585.4545454545455,0,0,0,0]
[null,"Total Return on Investment",0,16575.781235640014,19094.133390307852,21759.440954294787,24542.538777704434,27449.018758274931,30484.759316667147,33655.941179271147,36969.064084900121,40430.964471995103,44048.834206552761,47830.240414799628,51783.146488700433,55915.934336712409,60237.427956801723,64756.91841364374,69484.19030714847,74429.549825015536,79603.854477941262,85018.544622415837,90685.67688275293,96617.959591165112,102828.79037230341,109332.29600681046,116143.37471707612,123277.74102759699,130751.97336216134,134998.11000506769,139620.06633746694,148222.78263540781,157241.37536517857,165116.91815416509]
[]
[null,null,"Positive Cash Flow Achieved in Year #",{"$f":"MATCH(TRUE,D61:AH61>0,0)","v":13}]
[]
[]
[]
[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.36901934170342721},{"$f":"H41","v":0.38008992195453001},{"$f":"K41","v":0.39149261961316711},{"$f":"N41","v":0.40323739820156218},{"$f":"Q41","v":0.41533452014760835},{"$f":"T41","v":0.42779455575203584},{"$f":"W41","v":0.44062839242459684},{"$f":"Z41","v":0.45384724419733474},{"$f":"AC41","v":0.46746266152325594},{"$f":"AF41","v":0.48148654136895369},{"$f":"AI41","v":0.49593113761002239},{"$f":"AL41","v":0.51080907173832213},{"$f":"AO41","v":0.52613334389047184},{"$f":"AR41","v":0.54191734420718607},{"$f":"AU41","v":0.55817486453340159},{"$f":"AX41","v":0.57492011046940272},{"$f":"BA41","v":0.59216771378348732},{"$f":"BD41","v":0.60993274519699003},{"$f":"BG41","v":0.62823072755290166},{"$f":"BJ41","v":0.64707764937948631},{"$f":"BM41","v":0.66648997886087091},{"$f":"BP41","v":0.68648467822669801},{"$f":"BS41","v":0.70707921857349831},{"$f":"BV41","v":0.72829159513070607},{"$f":"BY41","v":0.75014034298462384},{"$f":"CB41","v":0.7726445532741637},{"$f":"CE41","v":0.79582388987238928},{"$f":"CH41","v":0.81969860656855964},{"$f":"CK41","v":0.84428956476561623},{"$f":"CN41","v":0.86961825170858709},{"$f":"CQ41","v":0.89570679925984553}]
[null,"Cash Flow ",0,{"$f":"E42","v":-0.34031352510168378},{"$f":"H42","v":-0.31740684033751687},{"$f":"K42","v":-0.29292405106028585},{"$f":"N42","v":-0.267409070605586},{"$f":"Q42","v":-0.24081902493812757},{"$f":"T42","v":-0.21310927746956299},{"$f":"W42","v":-0.1842333571286156},{"$f":"Z42","v":-0.15414288351118097},{"$f":"AC42","v":-0.12278748899231431},{"$f":"AF42","v":-9.0114737677256057E-2},{"$f":"AI42","v":-5.6070041063695432E-2},{"$f":"AL42","v":-2.0596570282315686E-2},{"$f":"AO42","v":1.6364835222694798E-2},{"$f":"AR42","v":5.4875762717052079E-2},{"$f":"AU42","v":9.5000325053404486E-2},{"$f":"AX42","v":0.13680526355769848},{"$f":"BA42","v":0.18036005508688682},{"$f":"BD42","v":0.22573702342650609},{"$f":"BG42","v":0.27301145520345188},{"$f":"BJ42","v":0.32226172049632951},{"$f":"BM42","v":0.37356939833312197},{"$f":"BP42","v":0.42701940727355142},{"$f":"BS42","v":0.48270014128146921},{"$f":"BV42","v":0.54070361110086995},{"$f":"BY42","v":0.60112559135774846},{"$f":"CB42","v":0.66406577361894492},{"$f":"CE42","v":0.72962792564845291},{"$f":"CH42","v":0.79792005711134151},{"$f":"CK42","v":0.86905459198551127},{"$f":"CN42","v":0.94314854795199676},{"$f":"CQ42","v":1.9057339566642311}]
[null,"Debt Paydown ",0,{"$f":"E43","v":0.13086106742830272},{"$f":"H43","v":0.13961118881730583},{"$f":"K43","v":0.1489463934998112},{"$f":"N43","v":0.15890580349997468},{"$f":"Q43","v":0.16953115676482933},{"$f":"T43","v":0.1808669820798966},{"$f":"W43","v":0.19296078568064004},{"$f":"Z43","v":0.20586325034185832},{"$f":"AC43","v":0.21962844777930632},{"$f":"AF43","v":0.23431406525373283},{"$f":"AI43","v":0.24998164732694311},{"$f":"AL43","v":0.26669685378307306},{"$f":"AO43","v":0.28452973479594978},{"$f":"AR43","v":0.30355502449572513},{"$f":"AU43","v":0.32385245416505432},{"$f":"AX43","v":0.34550708637736743},{"$f":"BA43","v":0.36860967147754659},{"$f":"BD43","v":0.39325702789893635},{"$f":"BG43","v":0.41955244791054075},{"$f":"BJ43","v":0.44760613049479575},{"$f":"BM43","v":0.47753564317003871},{"$f":"BP43","v":0.50946641469307119},{"$f":"BS43","v":0.54353226070664373},{"$f":"BV43","v":0.57987594453474611},{"$f":"BY43","v":0.61864977547588185},{"$f":"CB43","v":0.66001624710166995},{"$f":"CE43","v":0.70414871823574277},{"$f":"CH43","v":0.75123213946680634},{"$f":"CK43","v":0.80146382824052209},{"$f":"CN43","v":0.85505429577848224},{"$f":"CQ43","v":0}]
[null,"Depreciation",0,{"$f":"E44","v":0.12166455871919055},{"$f":"H44","v":0.12166455871919055},{"$f":"K44","v":0.12166455871919055},{"$f":"N44","v":0.12166455871919055},{"$f":"Q44","v":0.12166455871919055},{"$f":"T44","v":0.12166455871919055},{"$f":"W44","v":0.12166455871919055},{"$f":"Z44","v":0.12166455871919055},{"$f":"AC44","v":0.12166455871919055},{"$f":"AF44","v":0.12166455871919055},{"$f":"AI44","v":0.12166455871919055},{"$f":"AL44","v":0.12166455871919055},{"$f":"AO44","v":0.12166455871919055},{"$f":"AR44","v":0.12166455871919055},{"$f":"AU44","v":0.12166455871919055},{"$f":"AX44","v":0.12166455871919055},{"$f":"BA44","v":0.12166455871919055},{"$f":"BD44","v":0.12166455871919055},{"$f":"BG44","v":0.12166455871919055},{"$f":"BJ44","v":0.12166455871919055},{"$f":"BM44","v":0.12166455871919055},{"$f":"BP44","v":0.12166455871919055},{"$f":"BS44","v":0.12166455871919055},{"$f":"BV44","v":0.12166455871919055},{"$f":"BY44","v":0.12166455871919055},{"$f":"CB44","v":0.12166455871919055},{"$f":"CE44","v":6.0832279359595273E-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":0.28123144274923673},{"$f":"H45","v":0.32395882915350949},{"$f":"K45","v":0.36917952077188299},{"$f":"N45","v":0.41639868981514139},{"$f":"Q45","v":0.46571121069350063},{"$f":"T45","v":0.51721681908156003},{"$f":"W45","v":0.57102037969581187},{"$f":"Z45","v":0.62723216974720264},{"$f":"AC45","v":0.68596817902943852},{"$f":"AF45","v":0.74735042766462112},{"$f":"AI45","v":0.81150730259246062},{"$f":"AL45","v":0.87857391395827011},{"$f":"AO45","v":0.94869247262830703},{"$f":"AR45","v":1.0220126901391537},{"$f":"AU45","v":1.0986922024710508},{"$f":"AX45","v":1.1788970191236592},{"$f":"BA45","v":1.2628019990671111},{"$f":"BD45","v":1.3505913552416229},{"$f":"BG45","v":1.4424591893860848},{"$f":"BJ45","v":1.538610059089802},{"$f":"BM45","v":1.6392595790832218},{"$f":"BP45","v":1.744635058912511},{"$f":"BS45","v":1.8549761792808017},{"$f":"BV45","v":1.9705357094855127},{"$f":"BY45","v":2.0915802685374447},{"$f":"CB45","v":2.2183911327139691},{"$f":"CE45","v":2.2904328131161806},{"$f":"CH45","v":2.3688508031467075},{"$f":"CK45","v":2.5148079849916494},{"$f":"CN45","v":2.667821095439066},{"$f":"CQ45","v":2.8014407559240766}]
[]
[null,null,"100%+ ROIQ Achieved in Year #",{"$f":"MATCH(TRUE,D80:AH80>1,0)","v":14}]

{"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":725000}]
[null,"Number of Units ",null,{"$f":"Inputs!B17","v":2},null,null,"Mortgage",null,null,null,null,null,{"$f":"Inputs!B29","v":688750}]
[null,null,null,null,null,null,"Down Payment",null,null,null,null,null,{"$f":"Inputs!B28","v":36250}]
["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":22690}]
[null,null,null,null,null,null,"Repair Costs",null,null,null,null,null,{"$f":"Inputs!B32","v":0}]
["Annual Cash Flow Statement ",null,null,null,null,null,"Total Cash Investment ",null,null,null,null,null,{"$f":"Inputs!B33","v":58940}]
[]
["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":44400},null,null,{"$f":"D10*(1+$D$5)","v":46176},null,null,{"$f":"G10*(1+$D$5)","v":48023.040000000001},null,null,{"$f":"J10*(1+$D$5)","v":49943.961600000002},null,null,{"$f":"M10*(1+$D$5)","v":51941.720064000001},null,null,{"$f":"P10*(1+$D$5)","v":54019.388866560002},null,null,{"$f":"S10*(1+$D$5)","v":56180.164421222406},null,null,{"$f":"V10*(1+$D$5)","v":58427.370998071303},null,null,{"$f":"Y10*(1+$D$5)","v":60764.465837994154},null,null,{"$f":"AB10*(1+$D$5)","v":63195.044471513924},null,null,{"$f":"AE10*(1+$D$5)","v":65722.846250374481},null,null,{"$f":"AH10*(1+$D$5)","v":68351.760100389467},null,null,{"$f":"AK10*(1+$D$5)","v":71085.83050440505},null,null,{"$f":"AN10*(1+$D$5)","v":73929.263724581251},null,null,{"$f":"AQ10*(1+$D$5)","v":76886.434273564504},null,null,{"$f":"AT10*(1+$D$5)","v":79961.891644507094},null,null,{"$f":"AW10*(1+$D$5)","v":83160.367310287387},null,null,{"$f":"AZ10*(1+$D$5)","v":86486.782002698892},null,null,{"$f":"BC10*(1+$D$5)","v":89946.253282806851},null,null,{"$f":"BF10*(1+$D$5)","v":93544.103414119134},null,null,{"$f":"BI10*(1+$D$5)","v":97285.867550683906},null,null,{"$f":"BL10*(1+$D$5)","v":101177.30225271126},null,null,{"$f":"BO10*(1+$D$5)","v":105224.39434281972},null,null,{"$f":"BR10*(1+$D$5)","v":109433.37011653252},null,null,{"$f":"BU10*(1+$D$5)","v":113810.70492119383},null,null,{"$f":"BX10*(1+$D$5)","v":118363.13311804159},null,null,{"$f":"CA10*(1+$D$5)","v":123097.65844276325},null,null,{"$f":"CD10*(1+$D$5)","v":128021.56478047378},null,null,{"$f":"CG10*(1+$D$5)","v":133142.42737169273},null,null,{"$f":"CJ10*(1+$D$5)","v":138468.12446656043},null,null,{"$f":"CM10*(1+$D$5)","v":144006.84944522285}]
[" - Vacancy",{"$f":"Inputs!B45","v":0.05},null,{"$f":"-D10*Inputs!B45","v":-2220},null,null,{"$f":"-G10*Inputs!$B$45","v":-2308.8000000000002},null,null,{"$f":"-J10*Inputs!$B$45","v":-2401.152},null,null,{"$f":"-M10*Inputs!$B$45","v":-2497.1980800000001},null,null,{"$f":"-P10*Inputs!$B$45","v":-2597.0860032000001},null,null,{"$f":"-S10*Inputs!$B$45","v":-2700.9694433280001},null,null,{"$f":"-V10*Inputs!$B$45","v":-2809.0082210611204},null,null,{"$f":"-Y10*Inputs!$B$45","v":-2921.3685499035655},null,null,{"$f":"-AB10*Inputs!$B$45","v":-3038.2232918997079},null,null,{"$f":"-AE10*Inputs!$B$45","v":-3159.7522235756965},null,null,{"$f":"-AH10*Inputs!$B$45","v":-3286.1423125187243},null,null,{"$f":"-AK10*Inputs!$B$45","v":-3417.5880050194737},null,null,{"$f":"-AN10*Inputs!$B$45","v":-3554.2915252202529},null,null,{"$f":"-AQ10*Inputs!$B$45","v":-3696.4631862290626},null,null,{"$f":"-AT10*Inputs!$B$45","v":-3844.3217136782255},null,null,{"$f":"-AW10*Inputs!$B$45","v":-3998.0945822253548},null,null,{"$f":"-AZ10*Inputs!$B$45","v":-4158.0183655143692},null,null,{"$f":"-BC10*Inputs!$B$45","v":-4324.3391001349446},null,null,{"$f":"-BF10*Inputs!$B$45","v":-4497.3126641403423},null,null,{"$f":"-BI10*Inputs!$B$45","v":-4677.2051707059572},null,null,{"$f":"-BL10*Inputs!$B$45","v":-4864.2933775341953},null,null,{"$f":"-BO10*Inputs!$B$45","v":-5058.8651126355635},null,null,{"$f":"-BR10*Inputs!$B$45","v":-5261.2197171409862},null,null,{"$f":"-BU10*Inputs!$B$45","v":-5471.6685058266266},null,null,{"$f":"-BX10*Inputs!$B$45","v":-5690.5352460596914},null,null,{"$f":"-CA10*Inputs!$B$45","v":-5918.1566559020794},null,null,{"$f":"-CD10*Inputs!$B$45","v":-6154.8829221381629},null,null,{"$f":"-CG10*Inputs!$B$45","v":-6401.0782390236891},null,null,{"$f":"-CJ10*Inputs!$B$45","v":-6657.1213685846369},null,null,{"$f":"-CM10*Inputs!$B$45","v":-6923.406223328022},null,null,{"$f":"-CP10*Inputs!$B$45","v":-7200.3424722611426}]
["Expected Annual Rental Income",null,null,{"$f":"SUM(D10:D11)","v":42180},null,null,{"$f":"SUM(G10:G11)","v":43867.199999999997},null,null,{"$f":"SUM(J10:J11)","v":45621.887999999999},null,null,{"$f":"SUM(M10:M11)","v":47446.76352},null,null,{"$f":"SUM(P10:P11)","v":49344.634060800003},null,null,{"$f":"SUM(S10:S11)","v":51318.419423232001},null,null,{"$f":"SUM(V10:V11)","v":53371.156200161284},null,null,{"$f":"SUM(Y10:Y11)","v":55506.002448167739},null,null,{"$f":"SUM(AB10:AB11)","v":57726.242546094443},null,null,{"$f":"SUM(AE10:AE11)","v":60035.292247938225},null,null,{"$f":"SUM(AH10:AH11)","v":62436.70393785576},null,null,{"$f":"SUM(AK10:AK11)","v":64934.172095369991},null,null,{"$f":"SUM(AN10:AN11)","v":67531.538979184799},null,null,{"$f":"SUM(AQ10:AQ11)","v":70232.800538352196},null,null,{"$f":"SUM(AT10:AT11)","v":73042.112559886285},null,null,{"$f":"SUM(AW10:AW11)","v":75963.797062281737},null,null,{"$f":"SUM(AZ10:AZ11)","v":79002.348944773024},null,null,{"$f":"SUM(BC10:BC11)","v":82162.442902563955},null,null,{"$f":"SUM(BF10:BF11)","v":85448.940618666515},null,null,{"$f":"SUM(BI10:BI11)","v":88866.898243413176},null,null,{"$f":"SUM(BL10:BL11)","v":92421.574173149711},null,null,{"$f":"SUM(BO10:BO11)","v":96118.437140075694},null,null,{"$f":"SUM(BR10:BR11)","v":99963.174625678745},null,null,{"$f":"SUM(BU10:BU11)","v":103961.70161070589},null,null,{"$f":"SUM(BX10:BX11)","v":108120.16967513414},null,null,{"$f":"SUM(CA10:CA11)","v":112444.97646213952},null,null,{"$f":"SUM(CD10:CD11)","v":116942.77552062509},null,null,{"$f":"SUM(CG10:CG11)","v":121620.4865414501},null,null,{"$f":"SUM(CJ10:CJ11)","v":126485.3060031081},null,null,{"$f":"SUM(CM10:CM11)","v":131544.7182432324},null,null,{"$f":"SUM(CP10:CP11)","v":136806.50697296171}]
[]
["Annual Expenses"]
["Property Management",null,null,{"$f":"Inputs!B59","v":0},null,null,{"$f":"(G10*Inputs!$B$57)","v":0},null,null,{"$f":"J10*Inputs!$B$57","v":0},null,null,{"$f":"M10*Inputs!$B$57","v":0},null,null,{"$f":"P10*Inputs!$B$57","v":0},null,null,{"$f":"S10*Inputs!$B$57","v":0},null,null,{"$f":"V10*Inputs!$B$57","v":0},null,null,{"$f":"Y10*Inputs!$B$57","v":0},null,null,{"$f":"AB10*Inputs!$B$57","v":0},null,null,{"$f":"AE10*Inputs!$B$57","v":0},null,null,{"$f":"AH10*Inputs!$B$57","v":0},null,null,{"$f":"AK10*Inputs!$B$57","v":0},null,null,{"$f":"AN10*Inputs!$B$57","v":0},null,null,{"$f":"AQ10*Inputs!$B$57","v":0},null,null,{"$f":"AT10*Inputs!$B$57","v":0},null,null,{"$f":"AW10*Inputs!$B$57","v":0},null,null,{"$f":"AZ10*Inputs!$B$57","v":0},null,null,{"$f":"BC10*Inputs!$B$57","v":0},null,null,{"$f":"BF10*Inputs!$B$57","v":0},null,null,{"$f":"BI10*Inputs!$B$57","v":0},null,null,{"$f":"BL10*Inputs!$B$57","v":0},null,null,{"$f":"BO10*Inputs!$B$57","v":0},null,null,{"$f":"BR10*Inputs!$B$57","v":0},null,null,{"$f":"BU10*Inputs!$B$57","v":0},null,null,{"$f":"BX10*Inputs!$B$57","v":0},null,null,{"$f":"CA10*Inputs!$B$57","v":0},null,null,{"$f":"CD10*Inputs!$B$57","v":0},null,null,{"$f":"CG10*Inputs!$B$57","v":0},null,null,{"$f":"CJ10*Inputs!$B$57","v":0},null,null,{"$f":"CM10*Inputs!$B$57","v":0},null,null,{"$f":"CP10*Inputs!$B$57","v":0}]
["Reserves for Repairs and Maintenance",null,null,{"$f":"Inputs!B62","v":3552},null,null,{"$f":"G10*Inputs!B60","v":3694.08},null,null,{"$f":"G16*(1.03)","v":3804.9023999999999},null,null,{"$f":"J16*(1.03)","v":3919.0494720000002},null,null,{"$f":"M16*(1.03)","v":4036.6209561600003},null,null,{"$f":"P16*(1.03)","v":4157.7195848448},null,null,{"$f":"S16*(1.03)","v":4282.4511723901442},null,null,{"$f":"V16*(1.03)","v":4410.9247075618487},null,null,{"$f":"Y16*(1.03)","v":4543.252448788704},null,null,{"$f":"AB16*(1.03)","v":4679.5500222523651},null,null,{"$f":"AE16*(1.03)","v":4819.9365229199366},null,null,{"$f":"AH16*(1.03)","v":4964.5346186075349},null,null,{"$f":"AK16*(1.03)","v":5113.4706571657607},null,null,{"$f":"AN16*(1.03)","v":5266.8747768807334},null,null,{"$f":"AQ16*(1.03)","v":5424.8810201871556},null,null,{"$f":"AT16*(1.03)","v":5587.6274507927701},null,null,{"$f":"AW16*(1.03)","v":5755.2562743165536},null,null,{"$f":"AZ16*(1.03)","v":5927.9139625460502},null,null,{"$f":"BC16*(1.03)","v":6105.7513814224321},null,null,{"$f":"BF16*(1.03)","v":6288.9239228651049},null,null,{"$f":"BI16*(1.03)","v":6477.5916405510579},null,null,{"$f":"BL16*(1.03)","v":6671.9193897675896},null,null,{"$f":"BO16*(1.03)","v":6872.0769714606176},null,null,{"$f":"BR16*(1.03)","v":7078.2392806044363},null,null,{"$f":"BU16*(1.03)","v":7290.5864590225692},null,null,{"$f":"BX16*(1.03)","v":7509.3040527932462},null,null,{"$f":"CA16*(1.03)","v":7734.5831743770441},null,null,{"$f":"CD16*(1.03)","v":7966.6206696083555},null,null,{"$f":"CG16*(1.03)","v":8205.6192896966058},null,null,{"$f":"CJ16*(1.03)","v":8451.7878683875042},null,null,{"$f":"CM16*(1.03)","v":8705.3415044391295}]
["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":3500},null,null,{"$f":"D18*(1.03)","v":3605},null,null,{"$f":"G18*(1.03)","v":3713.15},null,null,{"$f":"J18*(1.03)","v":3824.5445},null,null,{"$f":"M18*(1.03)","v":3939.280835},null,null,{"$f":"P18*(1.03)","v":4057.45926005},null,null,{"$f":"S18*(1.03)","v":4179.1830378515006},null,null,{"$f":"V18*(1.03)","v":4304.558528987046},null,null,{"$f":"Y18*(1.03)","v":4433.6952848566571},null,null,{"$f":"AB18*(1.03)","v":4566.7061434023572},null,null,{"$f":"AE18*(1.03)","v":4703.7073277044283},null,null,{"$f":"AH18*(1.03)","v":4844.8185475355613},null,null,{"$f":"AK18*(1.03)","v":4990.1631039616286},null,null,{"$f":"AN18*(1.03)","v":5139.8679970804778},null,null,{"$f":"AQ18*(1.03)","v":5294.0640369928924},null,null,{"$f":"AT18*(1.03)","v":5452.8859581026791},null,null,{"$f":"AW18*(1.03)","v":5616.4725368457594},null,null,{"$f":"AZ18*(1.03)","v":5784.9667129511326},null,null,{"$f":"BC18*(1.03)","v":5958.5157143396664},null,null,{"$f":"BF18*(1.03)","v":6137.2711857698569},null,null,{"$f":"BI18*(1.03)","v":6321.3893213429528},null,null,{"$f":"BL18*(1.03)","v":6511.0310009832419},null,null,{"$f":"BO18*(1.03)","v":6706.3619310127397},null,null,{"$f":"BR18*(1.03)","v":6907.5527889431223},null,null,{"$f":"BU18*(1.03)","v":7114.779372611416},null,null,{"$f":"BX18*(1.03)","v":7328.2227537897588},null,null,{"$f":"CA18*(1.03)","v":7548.0694364034516},null,null,{"$f":"CD18*(1.03)","v":7774.5115194955551},null,null,{"$f":"CG18*(1.03)","v":8007.7468650804221},null,null,{"$f":"CJ18*(1.03)","v":8247.9792710328347},null,null,{"$f":"CM18*(1.03)","v":8495.4186491638193}]
["Property Insurance",null,null,{"$f":"Inputs!B71","v":3000},null,null,{"$f":"D19*1.03","v":3090},null,null,{"$f":"G19*1.03","v":3182.7000000000003},null,null,{"$f":"J19*1.03","v":3278.1810000000005},null,null,{"$f":"M19*1.03","v":3376.5264300000008},null,null,{"$f":"P19*1.03","v":3477.8222229000007},null,null,{"$f":"S19*1.03","v":3582.1568895870009},null,null,{"$f":"V19*1.03","v":3689.621596274611},null,null,{"$f":"Y19*1.03","v":3800.3102441628494},null,null,{"$f":"AB19*1.03","v":3914.3195514877348},null,null,{"$f":"AE19*1.03","v":4031.7491380323668},null,null,{"$f":"AH19*1.03","v":4152.7016121733377},null,null,{"$f":"AK19*1.03","v":4277.282660538538},null,null,{"$f":"AN19*1.03","v":4405.6011403546945},null,null,{"$f":"AQ19*1.03","v":4537.7691745653356},null,null,{"$f":"AT19*1.03","v":4673.902249802296},null,null,{"$f":"AW19*1.03","v":4814.1193172963649},null,null,{"$f":"AZ19*1.03","v":4958.5428968152564},null,null,{"$f":"BC19*1.03","v":5107.2991837197142},null,null,{"$f":"BF19*1.03","v":5260.5181592313056},null,null,{"$f":"BI19*1.03","v":5418.3337040082451},null,null,{"$f":"BL19*1.03","v":5580.8837151284924},null,null,{"$f":"BO19*1.03","v":5748.3102265823472},null,null,{"$f":"BR19*1.03","v":5920.7595333798181},null,null,{"$f":"BU19*1.03","v":6098.3823193812132},null,null,{"$f":"BX19*1.03","v":6281.33378896265},null,null,{"$f":"CA19*1.03","v":6469.7738026315301},null,null,{"$f":"CD19*1.03","v":6663.8670167104765},null,null,{"$f":"CG19*1.03","v":6863.7830272117908},null,null,{"$f":"CJ19*1.03","v":7069.696518028145},null,null,{"$f":"CM19*1.03","v":7281.7874135689899}]
["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":10052},null,null,{"$f":"SUM(G15:G26)","v":10389.08},null,null,{"$f":"SUM(J15:J26)","v":10700.752400000001},null,null,{"$f":"SUM(M15:M26)","v":11021.774972000001},null,null,{"$f":"SUM(P15:P26)","v":11352.42822116},null,null,{"$f":"SUM(S15:S26)","v":11693.001067794799},null,null,{"$f":"SUM(V15:V26)","v":12043.791099828646},null,null,{"$f":"SUM(Y15:Y26)","v":12405.104832823505},null,null,{"$f":"SUM(AB15:AB26)","v":12777.257977808209},null,null,{"$f":"SUM(AE15:AE26)","v":13160.575717142458},null,null,{"$f":"SUM(AH15:AH26)","v":13555.392988656731},null,null,{"$f":"SUM(AK15:AK26)","v":13962.054778316435},null,null,{"$f":"SUM(AN15:AN26)","v":14380.916421665926},null,null,{"$f":"SUM(AQ15:AQ26)","v":14812.343914315905},null,null,{"$f":"SUM(AT15:AT26)","v":15256.714231745384},null,null,{"$f":"SUM(AW15:AW26)","v":15714.415658697744},null,null,{"$f":"SUM(AZ15:AZ26)","v":16185.848128458678},null,null,{"$f":"SUM(BC15:BC26)","v":16671.42357231244},null,null,{"$f":"SUM(BF15:BF26)","v":17171.566279481813},null,null,{"$f":"SUM(BI15:BI26)","v":17686.713267866267},null,null,{"$f":"SUM(BL15:BL26)","v":18217.314665902257},null,null,{"$f":"SUM(BO15:BO26)","v":18763.834105879323},null,null,{"$f":"SUM(BR15:BR26)","v":19326.749129055705},null,null,{"$f":"SUM(BU15:BU26)","v":19906.551602927379},null,null,{"$f":"SUM(BX15:BX26)","v":20503.748151015199},null,null,{"$f":"SUM(CA15:CA26)","v":21118.860595545655},null,null,{"$f":"SUM(CD15:CD26)","v":21752.426413412028},null,null,{"$f":"SUM(CG15:CG26)","v":22404.999205814387},null,null,{"$f":"SUM(CJ15:CJ26)","v":23077.149181988818},null,null,{"$f":"SUM(CM15:CM26)","v":23769.463657448483},null,null,{"$f":"SUM(CP15:CP26)","v":24482.547567171936}]
[]
["Net Operating Income",null,null,{"$f":"D12-D27","v":32128},null,null,{"$f":"G12-G27","v":33478.119999999995},null,null,{"$f":"J12-J27","v":34921.135599999994},null,null,{"$f":"M12-M27","v":36424.988548000001},null,null,{"$f":"P12-P27","v":37992.205839640003},null,null,{"$f":"S12-S27","v":39625.418355437199},null,null,{"$f":"V12-V27","v":41327.365100332638},null,null,{"$f":"Y12-Y27","v":43100.897615344235},null,null,{"$f":"AB12-AB27","v":44948.984568286236},null,null,{"$f":"AE12-AE27","v":46874.716530795769},null,null,{"$f":"AH12-AH27","v":48881.310949199033},null,null,{"$f":"AK12-AK27","v":50972.117317053555},null,null,{"$f":"AN12-AN27","v":53150.622557518873},null,null,{"$f":"AQ12-AQ27","v":55420.456624036291},null,null,{"$f":"AT12-AT27","v":57785.398328140902},null,null,{"$f":"AW12-AW27","v":60249.38140358399},null,null,{"$f":"AZ12-AZ27","v":62816.50081631435},null,null,{"$f":"BC12-BC27","v":65491.019330251511},null,null,{"$f":"BF12-BF27","v":68277.374339184695},null,null,{"$f":"BI12-BI27","v":71180.184975546901},null,null,{"$f":"BL12-BL27","v":74204.259507247451},null,null,{"$f":"BO12-BO27","v":77354.603034196363},null,null,{"$f":"BR12-BR27","v":80636.425496623036},null,null,{"$f":"BU12-BU27","v":84055.150007778517},null,null,{"$f":"BX12-BX27","v":87616.421524118938},null,null,{"$f":"CA12-CA27","v":91326.115866593856},null,null,{"$f":"CD12-CD27","v":95190.349107213056},null,null,{"$f":"CG12-CG27","v":99215.487335635713},null,null,{"$f":"CJ12-CJ27","v":103408.15682111928},null,null,{"$f":"CM12-CM27","v":107775.25458578393},null,null,{"$f":"CP12-CP27","v":112323.95940578978}]
[]
["Less: Annual Mortgage Payments",null,null,{"$f":"PMT(Inputs!B35/12,Inputs!B36*12,Inputs!B29,0)*12","v":-52186.079169493241},null,null,{"$f":"IF(D37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(G37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(J37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(M37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(P37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(S37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(V37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(Y37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AB37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AE37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AH37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AK37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AN37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AQ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AT37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AW37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(AZ37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BC37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BF37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BI37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BL37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BO37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BR37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BU37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},null,null,{"$f":"IF(BX37>0,PMT(Inputs!$B$35/12,Inputs!$B$36*12,Inputs!$B$29,0)*12,0)","v":-52186.079169493241},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":-20058.079169493241},null,null,{"$f":"G29+G31+G32","v":-18707.959169493246},null,null,{"$f":"J29+J31+J32","v":-17264.943569493247},null,null,{"$f":"M29+M31+M32","v":-15761.09062149324},null,null,{"$f":"P29+P31+P32","v":-14193.873329853239},null,null,{"$f":"S29+S31+S32","v":-12560.660814056042},null,null,{"$f":"V29+V31+V32","v":-10858.714069160604},null,null,{"$f":"Y29+Y31+Y32","v":-9085.1815541490068},null,null,{"$f":"AB29+AB31+AB32","v":-7237.0946012070053},null,null,{"$f":"AE29+AE31+AE32","v":-5311.362638697472},null,null,{"$f":"AH29+AH31+AH32","v":-3304.7682202942087},null,null,{"$f":"AK29+AK31+AK32","v":-1213.9618524396865},null,null,{"$f":"AN29+AN31+AN32","v":964.54338802563143},null,null,{"$f":"AQ29+AQ31+AQ32","v":3234.3774545430497},null,null,{"$f":"AT29+AT31+AT32","v":5599.3191586476605},null,null,{"$f":"AW29+AW31+AW32","v":8063.3022340907482},null,null,{"$f":"AZ29+AZ31+AZ32","v":10630.421646821109},null,null,{"$f":"BC29+BC31+BC32","v":13304.940160758269},null,null,{"$f":"BF29+BF31+BF32","v":16091.295169691453},null,null,{"$f":"BI29+BI31+BI32","v":18994.10580605366},null,null,{"$f":"BL29+BL31+BL32","v":22018.180337754209},null,null,{"$f":"BO29+BO31+BO32","v":25168.523864703122},null,null,{"$f":"BR29+BR31+BR32","v":28450.346327129795},null,null,{"$f":"BU29+BU31+BU32","v":31869.070838285275},null,null,{"$f":"BX29+BX31+BX32","v":35430.342354625696},null,null,{"$f":"CA29+CA31+CA32","v":39140.036697100615},null,null,{"$f":"CD29+CD31+CD32","v":95190.349107213056},null,null,{"$f":"CG29+CG31+CG32","v":99215.487335635713},null,null,{"$f":"CJ29+CJ31+CJ32","v":103408.15682111928},null,null,{"$f":"CM29+CM31+CM32","v":107775.25458578393},null,null,{"$f":"CP29+CP31+CP32","v":112323.95940578978}]
["**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":746750},null,null,{"$f":"D36*(1+Inputs!$B$49)","v":769152.5},null,null,{"$f":"G36*(1+Inputs!$B$49)","v":792227.07500000007},null,null,{"$f":"J36*(1+Inputs!$B$49)","v":815993.88725000015},null,null,{"$f":"M36*(1+Inputs!$B$49)","v":840473.70386750018},null,null,{"$f":"P36*(1+Inputs!$B$49)","v":865687.91498352517},null,null,{"$f":"S36*(1+Inputs!$B$49)","v":891658.55243303091},null,null,{"$f":"V36*(1+Inputs!$B$49)","v":918408.30900602182},null,null,{"$f":"Y36*(1+Inputs!$B$49)","v":945960.55827620253},null,null,{"$f":"AB36*(1+Inputs!$B$49)","v":974339.37502448866},null,null,{"$f":"AE36*(1+Inputs!$B$49)","v":1003569.5562752234},null,null,{"$f":"AH36*(1+Inputs!$B$49)","v":1033676.6429634801},null,null,{"$f":"AK36*(1+Inputs!$B$49)","v":1064686.9422523845},null,null,{"$f":"AN36*(1+Inputs!$B$49)","v":1096627.550519956},null,null,{"$f":"AQ36*(1+Inputs!$B$49)","v":1129526.3770355547},null,null,{"$f":"AT36*(1+Inputs!$B$49)","v":1163412.1683466213},null,null,{"$f":"AW36*(1+Inputs!$B$49)","v":1198314.5333970201},null,null,{"$f":"AZ36*(1+Inputs!$B$49)","v":1234263.9693989307},null,null,{"$f":"BC36*(1+Inputs!$B$49)","v":1271291.8884808987},null,null,{"$f":"BF36*(1+Inputs!$B$49)","v":1309430.6451353256},null,null,{"$f":"BI36*(1+Inputs!$B$49)","v":1348713.5644893853},null,null,{"$f":"BL36*(1+Inputs!$B$49)","v":1389174.9714240669},null,null,{"$f":"BO36*(1+Inputs!$B$49)","v":1430850.2205667889},null,null,{"$f":"BR36*(1+Inputs!$B$49)","v":1473775.7271837927},null,null,{"$f":"BU36*(1+Inputs!$B$49)","v":1517988.9989993065},null,null,{"$f":"BX36*(1+Inputs!$B$49)","v":1563528.6689692857},null,null,{"$f":"CA36*(1+Inputs!$B$49)","v":1610434.5290383643},null,null,{"$f":"CD36*(1+Inputs!$B$49)","v":1658747.5649095152},null,null,{"$f":"CG36*(1+Inputs!$B$49)","v":1708509.9918568006},null,null,{"$f":"CJ36*(1+Inputs!$B$49)","v":1759765.2916125047},null,null,{"$f":"CM36*(1+Inputs!$B$49)","v":1812558.25036088}]
["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":681037.04868577584},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":672808.36521688383},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":664029.46478400496},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":654663.55672571645},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":644671.39034599741},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":634011.0904222083},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":622637.98171419138},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":610504.40173904225},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":597559.50102692994},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":583749.03002087492},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":569015.1117274249},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":553295.99916545057},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":535561.27320855169},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":514435.36261023057},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":489748.17980309459},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":461320.68989792181},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":428964.41421421408},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":392480.9048290925},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":351661.18837955379},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":306285.17724213685},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":256121.04609594058},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":200924.57174922782},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":140438.43397604843},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":74391.474966885216},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":2497.914845711035},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":65712.951314224163},null,null,{"$f":"G36-G37","v":96344.134783116169},null,null,{"$f":"J36-J37","v":128197.61021599511},null,null,{"$f":"M36-M37","v":161330.33052428369},null,null,{"$f":"P36-P37","v":195802.31352150277},null,null,{"$f":"S36-S37","v":231676.82456131687},null,null,{"$f":"V36-V37","v":269020.57071883953},null,null,{"$f":"Y36-Y37","v":307903.90726697957},null,null,{"$f":"AB36-AB37","v":348401.05724927259},null,null,{"$f":"AE36-AE37","v":390590.34500361374},null,null,{"$f":"AH36-AH37","v":434554.44454779848},null,null,{"$f":"AK36-AK37","v":480380.64379802952},null,null,{"$f":"AN36-AN37","v":529125.66904383281},null,null,{"$f":"AQ36-AQ37","v":582192.18790972547},null,null,{"$f":"AT36-AT37","v":639778.19723246014},null,null,{"$f":"AW36-AW37","v":702091.47844869946},null,null,{"$f":"AZ36-AZ37","v":769350.119182806},null,null,{"$f":"BC36-BC37","v":841783.06456983811},null,null,{"$f":"BF36-BF37","v":919630.70010134485},null,null,{"$f":"BI36-BI37","v":1003145.4678931888},null,null,{"$f":"BL36-BL37","v":1092592.5183934448},null,null,{"$f":"BO36-BO37","v":1188250.3996748391},null,null,{"$f":"BR36-BR37","v":1290411.7865907406},null,null,{"$f":"BU36-BU37","v":1399384.2522169075},null,null,{"$f":"BX36-BX37","v":1515491.0841535954},null,null,{"$f":"CA36-CA37","v":1563528.6689692857},null,null,{"$f":"CD36-CD37","v":1610434.5290383643},null,null,{"$f":"CG36-CG37","v":1658747.5649095152},null,null,{"$f":"CJ36-CJ37","v":1708509.9918568006},null,null,{"$f":"CM36-CM37","v":1759765.2916125047},null,null,{"$f":"CP36-CP37","v":1812558.25036088}]
[]
["ROI QuadrantTM"]
["Appreciation",null,null,{"$f":"D36-$M$2","v":21750},{"$f":"(D36-$M$2)/$M$7","v":0.36901934170342721},null,{"$f":"G36-D36","v":22402.5},{"$f":"(G36-D36)/$M$7","v":0.38008992195453001},null,{"$f":"J36-G36","v":23074.57500000007},{"$f":"(J36-G36)/$M$7","v":0.39149261961316711},null,{"$f":"M36-J36","v":23766.812250000075},{"$f":"(M36-J36)/$M$7","v":0.40323739820156218},null,{"$f":"P36-M36","v":24479.816617500037},{"$f":"(P36-M36)/$M$7","v":0.41533452014760835},null,{"$f":"S36-P36","v":25214.211116024991},{"$f":"(S36-P36)/$M$7","v":0.42779455575203584},null,{"$f":"V36-S36","v":25970.637449505739},{"$f":"(V36-S36)/$M$7","v":0.44062839242459684},null,{"$f":"Y36-V36","v":26749.756572990911},{"$f":"(Y36-V36)/$M$7","v":0.45384724419733474},null,{"$f":"AB36-Y36","v":27552.249270180706},{"$f":"(AB36-Y36)/$M$7","v":0.46746266152325594},null,{"$f":"AE36-AB36","v":28378.816748286132},{"$f":"(AE36-AB36)/$M$7","v":0.48148654136895369},null,{"$f":"AH36-AE36","v":29230.18125073472},{"$f":"(AH36-AE36)/$M$7","v":0.49593113761002239},null,{"$f":"AK36-AH36","v":30107.086688256706},{"$f":"(AK36-AH36)/$M$7","v":0.51080907173832213},null,{"$f":"AN36-AK36","v":31010.299288904411},{"$f":"(AN36-AK36)/$M$7","v":0.52613334389047184},null,{"$f":"AQ36-AN36","v":31940.608267571544},{"$f":"(AQ36-AN36)/$M$7","v":0.54191734420718607},null,{"$f":"AT36-AQ36","v":32898.826515598688},{"$f":"(AT36-AQ36)/$M$7","v":0.55817486453340159},null,{"$f":"AW36-AT36","v":33885.791311066598},{"$f":"(AW36-AT36)/$M$7","v":0.57492011046940272},null,{"$f":"AZ36-AW36","v":34902.365050398745},{"$f":"(AZ36-AW36)/$M$7","v":0.59216771378348732},null,{"$f":"BC36-AZ36","v":35949.436001910595},{"$f":"(BC36-AZ36)/$M$7","v":0.60993274519699003},null,{"$f":"BF36-BC36","v":37027.919081968023},{"$f":"(BF36-BC36)/$M$7","v":0.62823072755290166},null,{"$f":"BI36-BF36","v":38138.756654426921},{"$f":"(BI36-BF36)/$M$7","v":0.64707764937948631},null,{"$f":"BL36-BI36","v":39282.919354059733},{"$f":"(BL36-BI36)/$M$7","v":0.66648997886087091},null,{"$f":"BO36-BL36","v":40461.406934681581},{"$f":"(BO36-BL36)/$M$7","v":0.68648467822669801},null,{"$f":"BR36-BO36","v":41675.249142721994},{"$f":"(BR36-BO36)/$M$7","v":0.70707921857349831},null,{"$f":"BU36-BR36","v":42925.506617003819},{"$f":"(BU36-BR36)/$M$7","v":0.72829159513070607},null,{"$f":"BX36-BU36","v":44213.271815513726},{"$f":"(BX36-BU36)/$M$7","v":0.75014034298462384},null,{"$f":"CA36-BX36","v":45539.669969979208},{"$f":"(CA36-BX36)/$M$7","v":0.7726445532741637},null,{"$f":"CD36-CA36","v":46905.860069078626},{"$f":"(CD36-CA36)/$M$7","v":0.79582388987238928},null,{"$f":"CG36-CD36","v":48313.035871150903},{"$f":"(CG36-CD36)/$M$7","v":0.81969860656855964},null,{"$f":"CJ36-CG36","v":49762.426947285421},{"$f":"(CJ36-CG36)/$M$7","v":0.84428956476561623},null,{"$f":"CM36-CJ36","v":51255.299755704124},{"$f":"(CM36-CJ36)/$M$7","v":0.86961825170858709},null,{"$f":"CP36-CM36","v":52792.958748375298},{"$f":"(CP36-CM36)/$M$7","v":0.89570679925984553}]
["Cash Flow ",null,null,{"$f":"IF(D37>0,IF(D34<0,D34,0),D34)","v":-20058.079169493241},{"$f":"D42/$M$7","v":-0.34031352510168378},null,{"$f":"IF(G37>0,IF(G34<0,G34,0),G34)","v":-18707.959169493246},{"$f":"G42/$M$7","v":-0.31740684033751687},null,{"$f":"IF(J37>0,IF(J34<0,J34,0),J34)","v":-17264.943569493247},{"$f":"J42/$M$7","v":-0.29292405106028585},null,{"$f":"IF(M37>0,IF(M34<0,M34,0),M34)","v":-15761.09062149324},{"$f":"M42/$M$7","v":-0.267409070605586},null,{"$f":"IF(P37>0,IF(P34<0,P34,0),P34)","v":-14193.873329853239},{"$f":"P42/$M$7","v":-0.24081902493812757},null,{"$f":"IF(S37>0,IF(S34<0,S34,0),S34)","v":-12560.660814056042},{"$f":"S42/$M$7","v":-0.21310927746956299},null,{"$f":"IF(V37>0,IF(V34<0,V34,0),V34)","v":-10858.714069160604},{"$f":"V42/$M$7","v":-0.1842333571286156},null,{"$f":"IF(Y37>0,IF(Y34<0,Y34,0),Y34)","v":-9085.1815541490068},{"$f":"Y42/$M$7","v":-0.15414288351118097},null,{"$f":"IF(AB37>0,IF(AB34<0,AB34,0),AB34)","v":-7237.0946012070053},{"$f":"AB42/$M$7","v":-0.12278748899231431},null,{"$f":"IF(AE37>0,IF(AE34<0,AE34,0),AE34)","v":-5311.362638697472},{"$f":"AE42/$M$7","v":-9.0114737677256057E-2},null,{"$f":"IF(AH37>0,IF(AH34<0,AH34,0),AH34)","v":-3304.7682202942087},{"$f":"AH42/$M$7","v":-5.6070041063695432E-2},null,{"$f":"IF(AK37>0,IF(AK34<0,AK34,0),AK34)","v":-1213.9618524396865},{"$f":"AK42/$M$7","v":-2.0596570282315686E-2},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":0},{"$f":"BF42/$M$7","v":0},null,{"$f":"IF(BI37>0,IF(BI34<0,BI34,0),BI34)","v":0},{"$f":"BI42/$M$7","v":0},null,{"$f":"IF(BL37>0,IF(BL34<0,BL34,0),BL34)","v":0},{"$f":"BL42/$M$7","v":0},null,{"$f":"IF(BO37>0,IF(BO34<0,BO34,0),BO34)","v":0},{"$f":"BO42/$M$7","v":0},null,{"$f":"IF(BR37>0,IF(BR34<0,BR34,0),BR34)","v":0},{"$f":"BR42/$M$7","v":0},null,{"$f":"IF(BU37>0,IF(BU34<0,BU34,0),BU34)","v":0},{"$f":"BU42/$M$7","v":0},null,{"$f":"IF(BX37>0,IF(BX34<0,BX34,0),BX34)","v":0},{"$f":"BX42/$M$7","v":0},null,{"$f":"IF(CA37>0,IF(CA34<0,CA34,0),CA34)","v":39140.036697100615},{"$f":"CA42/$M$7","v":0.66406577361894492},null,{"$f":"IF(CD37>0,IF(CD34<0,CD34,0),CD34)","v":95190.349107213056},{"$f":"CD42/$M$7","v":1.6150381592672727},null,{"$f":"IF(CG37>0,IF(CG34<0,CG34,0),CG34)","v":99215.487335635713},{"$f":"CG42/$M$7","v":1.6833302907301615},null,{"$f":"IF(CJ37>0,IF(CJ34<0,CJ34,0),CJ34)","v":103408.15682111928},{"$f":"CJ42/$M$7","v":1.7544648256043311},null,{"$f":"IF(CM37>0,IF(CM34<0,CM34,0),CM34)","v":107775.25458578393},{"$f":"CM42/$M$7","v":1.8285587815708166},null,{"$f":"IF(CP37>0,IF(CP34<0,CP34,0),CP34)","v":112323.95940578978},{"$f":"CP42/$M$7","v":1.9057339566642311}]
["Debt Paydown ",null,null,{"$f":"M3-$D$37","v":7712.9513142241631},{"$f":"(M3-D37)/M7","v":0.13086106742830272},null,{"$f":"D37-G37","v":8228.6834688920062},{"$f":"(D37-G37)/$M$7","v":0.13961118881730583},null,{"$f":"G37-J37","v":8778.9004328788724},{"$f":"(G37-J37)/$M$7","v":0.1489463934998112},null,{"$f":"J37-M37","v":9365.9080582885072},{"$f":"(J37-M37)/$M$7","v":0.15890580349997468},null,{"$f":"M37-P37","v":9992.1663797190413},{"$f":"(M37-P37)/$M$7","v":0.16953115676482933},null,{"$f":"P37-S37","v":10660.299923789105},{"$f":"(P37-S37)/$M$7","v":0.1808669820798966},null,{"$f":"S37-V37","v":11373.108708016924},{"$f":"(S37-V37)/$M$7","v":0.19296078568064004},null,{"$f":"V37-Y37","v":12133.579975149129},{"$f":"(V37-Y37)/$M$7","v":0.20586325034185832},null,{"$f":"Y37-AB37","v":12944.900712112314},{"$f":"(Y37-AB37)/$M$7","v":0.21962844777930632},null,{"$f":"AB37-AE37","v":13810.471006055013},{"$f":"(AB37-AE37)/$M$7","v":0.23431406525373283},null,{"$f":"AE37-AH37","v":14733.918293450028},{"$f":"(AE37-AH37)/$M$7","v":0.24998164732694311},null,{"$f":"AH37-AK37","v":15719.112561974325},{"$f":"(AH37-AK37)/$M$7","v":0.26669685378307306},null,{"$f":"AK37-AN37","v":17734.725956898881},{"$f":"(AK37-AN37)/$M$7","v":0.30089457001864406},null,{"$f":"AN37-AQ37","v":21125.910598321119},{"$f":"(AN37-AQ37)/$M$7","v":0.35843078721277771},null,{"$f":"AQ37-AT37","v":24687.182807135978},{"$f":"(AQ37-AT37)/$M$7","v":0.41885277921845909},null,{"$f":"AT37-AW37","v":28427.489905172784},{"$f":"(AT37-AW37)/$M$7","v":0.48231234993506589},null,{"$f":"AW37-AZ37","v":32356.275683707732},{"$f":"(AW37-AZ37)/$M$7","v":0.54896972656443388},null,{"$f":"AZ37-BC37","v":36483.509385121579},{"$f":"(AZ37-BC37)/$M$7","v":0.6189940513254425},null,{"$f":"BC37-BF37","v":40819.716449538711},{"$f":"(BC37-BF37)/$M$7","v":0.69256390311399241},null,{"$f":"BF37-BI37","v":45376.011137416936},{"$f":"(BF37-BI37)/$M$7","v":0.76986785099112542},null,{"$f":"BI37-BL37","v":50164.131146196276},{"$f":"(BI37-BL37)/$M$7","v":0.85110504150316046},null,{"$f":"BL37-BO37","v":55196.474346712756},{"$f":"(BL37-BO37)/$M$7","v":0.93648582196662289},null,{"$f":"BO37-BR37","v":60486.137773179391},{"$f":"(BO37-BR37)/$M$7","v":1.0262324019881133},null,{"$f":"BR37-BU37","v":66046.959009163213},{"$f":"(BR37-BU37)/$M$7","v":1.1205795556356162},null,{"$f":"BU37-BX37","v":71893.560121174174},{"$f":"(BU37-BX37)/$M$7","v":1.2197753668336304},null,{"$f":"BX37-CA37","v":2497.914845711035},{"$f":"(BX37-CA37)/$M$7","v":4.2380638712436969E-2},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":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"(Inputs!$B$24*0.85/27.5)*Inputs!$B$51","v":7170.909090909091},{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/$M$7","v":0.12166455871919055},null,{"$f":"((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/2","v":3585.4545454545455},{"$f":"(((Inputs!$B$24*0.85/27.5)*Inputs!$B$51)/2)/$M$7","v":6.0832279359595273E-2},null,0,0,null,0,0,null,0,0,null,0,0]
["Total Return on Investment",null,null,{"$f":"SUM(D41:D44)","v":16575.781235640014},{"$f":"SUM(E41:E44)","v":0.28123144274923673},null,{"$f":"SUM(G41:G44)","v":19094.133390307852},{"$f":"SUM(H41:H44)","v":0.32395882915350949},null,{"$f":"SUM(J41:J44)","v":21759.440954294787},{"$f":"SUM(K41:K44)","v":0.36917952077188299},null,{"$f":"SUM(M41:M44)","v":24542.538777704434},{"$f":"SUM(N41:N44)","v":0.41639868981514139},null,{"$f":"SUM(P41:P44)","v":27449.018758274931},{"$f":"SUM(Q41:Q44)","v":0.46571121069350063},null,{"$f":"SUM(S41:S44)","v":30484.759316667147},{"$f":"SUM(T41:T44)","v":0.51721681908156003},null,{"$f":"SUM(V41:V44)","v":33655.941179271147},{"$f":"SUM(W41:W44)","v":0.57102037969581187},null,{"$f":"SUM(Y41:Y44)","v":36969.064084900121},{"$f":"SUM(Z41:Z44)","v":0.62723216974720264},null,{"$f":"SUM(AB41:AB44)","v":40430.964471995103},{"$f":"SUM(AC41:AC44)","v":0.68596817902943852},null,{"$f":"SUM(AE41:AE44)","v":44048.834206552761},{"$f":"SUM(AF41:AF44)","v":0.74735042766462112},null,{"$f":"SUM(AH41:AH44)","v":47830.240414799628},{"$f":"SUM(AI41:AI44)","v":0.81150730259246062},null,{"$f":"SUM(AK41:AK44)","v":51783.146488700433},{"$f":"SUM(AL41:AL44)","v":0.87857391395827011},null,{"$f":"SUM(AN41:AN44)","v":55915.93433671238},{"$f":"SUM(AO41:AO44)","v":0.94869247262830647},null,{"$f":"SUM(AQ41:AQ44)","v":60237.427956801752},{"$f":"SUM(AR41:AR44)","v":1.0220126901391542},null,{"$f":"SUM(AT41:AT44)","v":64756.918413643754},{"$f":"SUM(AU41:AU44)","v":1.0986922024710513},null,{"$f":"SUM(AW41:AW44)","v":69484.19030714847},{"$f":"SUM(AX41:AX44)","v":1.1788970191236592},null,{"$f":"SUM(AZ41:AZ44)","v":74429.549825015565},{"$f":"SUM(BA41:BA44)","v":1.2628019990671118},null,{"$f":"SUM(BC41:BC44)","v":79603.854477941262},{"$f":"SUM(BD41:BD44)","v":1.3505913552416229},null,{"$f":"SUM(BF41:BF44)","v":85018.544622415822},{"$f":"SUM(BG41:BG44)","v":1.4424591893860845},null,{"$f":"SUM(BI41:BI44)","v":90685.676882752945},{"$f":"SUM(BJ41:BJ44)","v":1.5386100590898022},null,{"$f":"SUM(BL41:BL44)","v":96617.959591165098},{"$f":"SUM(BM41:BM44)","v":1.6392595790832218},null,{"$f":"SUM(BO41:BO44)","v":102828.79037230343},{"$f":"SUM(BP41:BP44)","v":1.7446350589125115},null,{"$f":"SUM(BR41:BR44)","v":109332.29600681047},{"$f":"SUM(BS41:BS44)","v":1.8549761792808019},null,{"$f":"SUM(BU41:BU44)","v":116143.37471707612},{"$f":"SUM(BV41:BV44)","v":1.9705357094855127},null,{"$f":"SUM(BX41:BX44)","v":123277.74102759699},{"$f":"SUM(BY41:BY44)","v":2.0915802685374447},null,{"$f":"SUM(CA41:CA44)","v":94348.530603699939},{"$f":"SUM(CB41:CB44)","v":1.6007555243247362},null,{"$f":"SUM(CD41:CD44)","v":145681.66372174624},{"$f":"SUM(CE41:CE44)","v":2.4716943284992574},null,{"$f":"SUM(CG41:CG44)","v":147528.5232067866},{"$f":"SUM(CH41:CH44)","v":2.5030288972987211},null,{"$f":"SUM(CJ41:CJ44)","v":153170.5837684047},{"$f":"SUM(CK41:CK44)","v":2.5987543903699475},null,{"$f":"SUM(CM41:CM44)","v":159030.55434148805},{"$f":"SUM(CN41:CN44)","v":2.6981770332794035},null,{"$f":"SUM(CP41:CP44)","v":165116.91815416509},{"$f":"SUM(CQ41:CQ44)","v":2.8014407559240766}]
[]
[{"$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 Synergy One Lending 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.  This spreadsheet is copyrighted as of 2011 through present day.  Any use modifications or distributions are only with permission of Joe Massey. "}]
[]
[]
[null,{"$f":"-M7","v":-58940},null,{"$f":"D34*0.7","v":-14040.655418645269},null,null,{"$f":"G34*0.7","v":-13095.571418645271},null,null,{"$f":"J34*0.7","v":-12085.460498645272},null,null,{"$f":"M34*0.7","v":-11032.763435045268},null,null,{"$f":"P51+P56","v":111484.65617891258},null,null,{"$f":"IRR(B50:P50)","v":5.3354876136446627E-3},"IRR"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P34*0.7","v":-9935.7113308972657}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P36*0.93","v":781640.5445967752},"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":136969.15425077779},"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":79330.544596775202},"Capital Gain Base"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P54*0.196","v":15548.78674096794},"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":121420.36750980985},"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":-20058.079169493241},{"$f":"G34","v":-18707.959169493246},{"$f":"J34","v":-17264.943569493247},{"$f":"M34","v":-15761.09062149324},{"$f":"P34","v":-14193.873329853239},{"$f":"S34","v":-12560.660814056042},{"$f":"V34","v":-10858.714069160604},{"$f":"Y34","v":-9085.1815541490068},{"$f":"AB34","v":-7237.0946012070053},{"$f":"AE34","v":-5311.362638697472},{"$f":"AH34","v":-3304.7682202942087},{"$f":"AK34","v":-1213.9618524396865},{"$f":"AN34","v":964.54338802563143},{"$f":"AQ34","v":3234.3774545430497},{"$f":"AT34","v":5599.3191586476605},{"$f":"AW34","v":8063.3022340907482},{"$f":"AZ34","v":10630.421646821109},{"$f":"BC34","v":13304.940160758269},{"$f":"BF34","v":16091.295169691453},{"$f":"BI34","v":18994.10580605366},{"$f":"BL34","v":22018.180337754209},{"$f":"BO34","v":25168.523864703122},{"$f":"BR34","v":28450.346327129795},{"$f":"BU34","v":31869.070838285275},{"$f":"BX34","v":35430.342354625696},{"$f":"CA34","v":39140.036697100615},{"$f":"CD34","v":95190.349107213056},{"$f":"CG34","v":99215.487335635713},{"$f":"CJ34","v":103408.15682111928},{"$f":"CM34","v":107775.25458578393},{"$f":"CP34","v":112323.95940578978}]
[]
[]
[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":21750},{"$f":"G41","v":22402.5},{"$f":"J41","v":23074.57500000007},{"$f":"M41","v":23766.812250000075},{"$f":"P41","v":24479.816617500037},{"$f":"S41","v":25214.211116024991},{"$f":"V41","v":25970.637449505739},{"$f":"Y41","v":26749.756572990911},{"$f":"AB41","v":27552.249270180706},{"$f":"AE41","v":28378.816748286132},{"$f":"AH41","v":29230.18125073472},{"$f":"AK41","v":30107.086688256706},{"$f":"AN41","v":31010.299288904411},{"$f":"AQ41","v":31940.608267571544},{"$f":"AT41","v":32898.826515598688},{"$f":"AW41","v":33885.791311066598},{"$f":"AZ41","v":34902.365050398745},{"$f":"BC41","v":35949.436001910595},{"$f":"BF41","v":37027.919081968023},{"$f":"BI41","v":38138.756654426921},{"$f":"BL41","v":39282.919354059733},{"$f":"BO41","v":40461.406934681581},{"$f":"BR41","v":41675.249142721994},{"$f":"BU41","v":42925.506617003819},{"$f":"BX41","v":44213.271815513726},{"$f":"CA41","v":45539.669969979208},{"$f":"CD41","v":46905.860069078626},{"$f":"CG41","v":48313.035871150903},{"$f":"CJ41","v":49762.426947285421},{"$f":"CM41","v":51255.299755704124},{"$f":"CP41","v":52792.958748375298}]
[null,"Cash Flow ",0,{"$f":"D42","v":-20058.079169493241},{"$f":"G42","v":-18707.959169493246},{"$f":"J42","v":-17264.943569493247},{"$f":"M42","v":-15761.09062149324},{"$f":"P42","v":-14193.873329853239},{"$f":"S42","v":-12560.660814056042},{"$f":"V42","v":-10858.714069160604},{"$f":"Y42","v":-9085.1815541490068},{"$f":"AB42","v":-7237.0946012070053},{"$f":"AE42","v":-5311.362638697472},{"$f":"AH42","v":-3304.7682202942087},{"$f":"AK42","v":-1213.9618524396865},{"$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":0},{"$f":"BI42","v":0},{"$f":"BL42","v":0},{"$f":"BO42","v":0},{"$f":"BR42","v":0},{"$f":"BU42","v":0},{"$f":"BX42","v":0},{"$f":"CA42","v":39140.036697100615},{"$f":"CD42","v":95190.349107213056},{"$f":"CG42","v":99215.487335635713},{"$f":"CJ42","v":103408.15682111928},{"$f":"CM42","v":107775.25458578393},{"$f":"CP42","v":112323.95940578978}]
[null,"Debt Paydown ",0,7712.9513142241631,8228.6834688920062,8778.9004328788724,9365.9080582885072,9992.1663797190413,10660.299923789105,11373.108708016924,12133.579975149129,12944.900712112314,13810.471006055013,14733.918293450028,15719.112561974325,17734.725956898881,21125.910598321119,24687.182807135978,28427.489905172784,32356.275683707732,36483.509385121579,40819.716449538711,45376.011137416936,50164.131146196276,55196.474346712756,60486.137773179391,66046.959009163213,71893.560121174174,2497.914845711035,0,0,0,0,0]
[null,"Depreciation",0,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,7170.909090909091,3585.4545454545455,0,0,0,0]
[null,"Total Return on Investment",0,16575.781235640014,19094.133390307852,21759.440954294787,24542.538777704434,27449.018758274931,30484.759316667147,33655.941179271147,36969.064084900121,40430.964471995103,44048.834206552761,47830.240414799628,51783.146488700433,55915.93433671238,60237.427956801752,64756.918413643754,69484.19030714847,74429.549825015565,79603.854477941262,85018.544622415822,90685.676882752945,96617.959591165098,102828.79037230343,109332.29600681047,116143.37471707612,123277.74102759699,94348.530603699939,145681.66372174624,147528.5232067866,153170.5837684047,159030.55434148805,165116.91815416509]
[]
[null,null,"Positive Cash Flow Achieved in Year #",{"$f":"MATCH(TRUE,D61:AH61>0,0)","v":13}]
[]
[]
[]
[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.36901934170342721},{"$f":"H41","v":0.38008992195453001},{"$f":"K41","v":0.39149261961316711},{"$f":"N41","v":0.40323739820156218},{"$f":"Q41","v":0.41533452014760835},{"$f":"T41","v":0.42779455575203584},{"$f":"W41","v":0.44062839242459684},{"$f":"Z41","v":0.45384724419733474},{"$f":"AC41","v":0.46746266152325594},{"$f":"AF41","v":0.48148654136895369},{"$f":"AI41","v":0.49593113761002239},{"$f":"AL41","v":0.51080907173832213},{"$f":"AO41","v":0.52613334389047184},{"$f":"AR41","v":0.54191734420718607},{"$f":"AU41","v":0.55817486453340159},{"$f":"AX41","v":0.57492011046940272},{"$f":"BA41","v":0.59216771378348732},{"$f":"BD41","v":0.60993274519699003},{"$f":"BG41","v":0.62823072755290166},{"$f":"BJ41","v":0.64707764937948631},{"$f":"BM41","v":0.66648997886087091},{"$f":"BP41","v":0.68648467822669801},{"$f":"BS41","v":0.70707921857349831},{"$f":"BV41","v":0.72829159513070607},{"$f":"BY41","v":0.75014034298462384},{"$f":"CB41","v":0.7726445532741637},{"$f":"CE41","v":0.79582388987238928},{"$f":"CH41","v":0.81969860656855964},{"$f":"CK41","v":0.84428956476561623},{"$f":"CN41","v":0.86961825170858709},{"$f":"CQ41","v":0.89570679925984553}]
[null,"Cash Flow ",0,{"$f":"E42","v":-0.34031352510168378},{"$f":"H42","v":-0.31740684033751687},{"$f":"K42","v":-0.29292405106028585},{"$f":"N42","v":-0.267409070605586},{"$f":"Q42","v":-0.24081902493812757},{"$f":"T42","v":-0.21310927746956299},{"$f":"W42","v":-0.1842333571286156},{"$f":"Z42","v":-0.15414288351118097},{"$f":"AC42","v":-0.12278748899231431},{"$f":"AF42","v":-9.0114737677256057E-2},{"$f":"AI42","v":-5.6070041063695432E-2},{"$f":"AL42","v":-2.0596570282315686E-2},{"$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},{"$f":"BJ42","v":0},{"$f":"BM42","v":0},{"$f":"BP42","v":0},{"$f":"BS42","v":0},{"$f":"BV42","v":0},{"$f":"BY42","v":0},{"$f":"CB42","v":0.66406577361894492},{"$f":"CE42","v":1.6150381592672727},{"$f":"CH42","v":1.6833302907301615},{"$f":"CK42","v":1.7544648256043311},{"$f":"CN42","v":1.8285587815708166},{"$f":"CQ42","v":1.9057339566642311}]
[null,"Debt Paydown ",0,{"$f":"E43","v":0.13086106742830272},{"$f":"H43","v":0.13961118881730583},{"$f":"K43","v":0.1489463934998112},{"$f":"N43","v":0.15890580349997468},{"$f":"Q43","v":0.16953115676482933},{"$f":"T43","v":0.1808669820798966},{"$f":"W43","v":0.19296078568064004},{"$f":"Z43","v":0.20586325034185832},{"$f":"AC43","v":0.21962844777930632},{"$f":"AF43","v":0.23431406525373283},{"$f":"AI43","v":0.24998164732694311},{"$f":"AL43","v":0.26669685378307306},{"$f":"AO43","v":0.30089457001864406},{"$f":"AR43","v":0.35843078721277771},{"$f":"AU43","v":0.41885277921845909},{"$f":"AX43","v":0.48231234993506589},{"$f":"BA43","v":0.54896972656443388},{"$f":"BD43","v":0.6189940513254425},{"$f":"BG43","v":0.69256390311399241},{"$f":"BJ43","v":0.76986785099112542},{"$f":"BM43","v":0.85110504150316046},{"$f":"BP43","v":0.93648582196662289},{"$f":"BS43","v":1.0262324019881133},{"$f":"BV43","v":1.1205795556356162},{"$f":"BY43","v":1.2197753668336304},{"$f":"CB43","v":4.2380638712436969E-2},{"$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.12166455871919055},{"$f":"H44","v":0.12166455871919055},{"$f":"K44","v":0.12166455871919055},{"$f":"N44","v":0.12166455871919055},{"$f":"Q44","v":0.12166455871919055},{"$f":"T44","v":0.12166455871919055},{"$f":"W44","v":0.12166455871919055},{"$f":"Z44","v":0.12166455871919055},{"$f":"AC44","v":0.12166455871919055},{"$f":"AF44","v":0.12166455871919055},{"$f":"AI44","v":0.12166455871919055},{"$f":"AL44","v":0.12166455871919055},{"$f":"AO44","v":0.12166455871919055},{"$f":"AR44","v":0.12166455871919055},{"$f":"AU44","v":0.12166455871919055},{"$f":"AX44","v":0.12166455871919055},{"$f":"BA44","v":0.12166455871919055},{"$f":"BD44","v":0.12166455871919055},{"$f":"BG44","v":0.12166455871919055},{"$f":"BJ44","v":0.12166455871919055},{"$f":"BM44","v":0.12166455871919055},{"$f":"BP44","v":0.12166455871919055},{"$f":"BS44","v":0.12166455871919055},{"$f":"BV44","v":0.12166455871919055},{"$f":"BY44","v":0.12166455871919055},{"$f":"CB44","v":0.12166455871919055},{"$f":"CE44","v":6.0832279359595273E-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":0.28123144274923673},{"$f":"H45","v":0.32395882915350949},{"$f":"K45","v":0.36917952077188299},{"$f":"N45","v":0.41639868981514139},{"$f":"Q45","v":0.46571121069350063},{"$f":"T45","v":0.51721681908156003},{"$f":"W45","v":0.57102037969581187},{"$f":"Z45","v":0.62723216974720264},{"$f":"AC45","v":0.68596817902943852},{"$f":"AF45","v":0.74735042766462112},{"$f":"AI45","v":0.81150730259246062},{"$f":"AL45","v":0.87857391395827011},{"$f":"AO45","v":0.94869247262830647},{"$f":"AR45","v":1.0220126901391542},{"$f":"AU45","v":1.0986922024710513},{"$f":"AX45","v":1.1788970191236592},{"$f":"BA45","v":1.2628019990671118},{"$f":"BD45","v":1.3505913552416229},{"$f":"BG45","v":1.4424591893860845},{"$f":"BJ45","v":1.5386100590898022},{"$f":"BM45","v":1.6392595790832218},{"$f":"BP45","v":1.7446350589125115},{"$f":"BS45","v":1.8549761792808019},{"$f":"BV45","v":1.9705357094855127},{"$f":"BY45","v":2.0915802685374447},{"$f":"CB45","v":1.6007555243247362},{"$f":"CE45","v":2.4716943284992574},{"$f":"CH45","v":2.5030288972987211},{"$f":"CK45","v":2.5987543903699475},{"$f":"CN45","v":2.6981770332794035},{"$f":"CQ45","v":2.8014407559240766}]
[null,null,"Mortgage Balance at End of Year",{"$f":"D37","v":681037.04868577584},{"$f":"G37","v":672808.36521688383},{"$f":"J37","v":664029.46478400496},{"$f":"M37","v":654663.55672571645},{"$f":"P37","v":644671.39034599741},{"$f":"S37","v":634011.0904222083},{"$f":"V37","v":622637.98171419138},{"$f":"Y37","v":610504.40173904225},{"$f":"AB37","v":597559.50102692994},{"$f":"AE37","v":583749.03002087492},{"$f":"AH37","v":569015.1117274249},{"$f":"AK37","v":553295.99916545057},{"$f":"AN37","v":535561.27320855169},{"$f":"AQ37","v":514435.36261023057},{"$f":"AT37","v":489748.17980309459},{"$f":"AW37","v":461320.68989792181},{"$f":"AZ37","v":428964.41421421408},{"$f":"BC37","v":392480.9048290925},{"$f":"BF37","v":351661.18837955379},{"$f":"BI37","v":306285.17724213685},{"$f":"BL37","v":256121.04609594058},{"$f":"BO37","v":200924.57174922782},{"$f":"BR37","v":140438.43397604843},{"$f":"BU37","v":74391.474966885216},{"$f":"BX37","v":2497.914845711035},{"$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":26}]