{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Suggested rent","Sources of income"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"Suggested rent","index":0,"n_rows":11,"n_cols":6,"rows_kept":11,"merged":[[1,1,1,4]]}
[]
[null,"Rent affordability calculator",{"$nulls":3}," "]
[null,"Total annual income before tax",null,null,{"v":65000,"d":"$65,000"}]
[null," ","Safe  25%","Acceptable 30%","Aggressive 35%"]
[null,"Suggested monthly rent",{"$f":"IFERROR(Total_Income*0.25/12,\"\")","v":{"v":1354.1666666666667,"d":"$1,354"}},{"$f":"IFERROR(Total_Income*0.3/12,\"\")","v":{"v":1625,"d":"$1,625"}},{"$f":"IFERROR(Total_Income*0.35/12,\"\")","v":{"v":1895.8333333333333,"d":"$1,896"}}]
[null,"Estimated utilities",{"$f":"IFERROR(C5*0.2,\"\")","v":{"v":270.83333333333337,"d":"$271"}},{"$f":"IFERROR(D5*0.2,\"\")","v":{"v":325,"d":"$325"}},{"v":379.1666666666667,"d":"$379"}]
[null,"Maximum housing expense",{"$f":"IFERROR(C5+C6,\"\")","v":{"v":1625,"d":"$1,625"}},{"$f":"IFERROR(D5+D6,\"\")","v":{"v":1950,"d":"$1,950"}},{"v":2275,"d":"$2,275"}]
[null,"Target savings to move out",{"$f":"IFERROR(C5*3,\"\")","v":{"v":4062.5,"d":"$4,063"}},{"$f":"IFERROR(D5*3,\"\")","v":{"v":4875,"d":"$4,875"}},{"v":5687.5,"d":"$5,688"}]
[null,"DISCLAIMER: "]
[null,"All calculations are suggestions. "]
[null,"All personal and financial factors should be considered before signing a lease."]

{"sheet":"Sources of income","index":1,"n_rows":5,"n_cols":4,"rows_kept":5,"merged":[[1,1,1,3]]}
[]
[null,"Source of income"]
[null,"Total annual income before tax",null,{"$f":"SUMIF(tblIncome[Frequency],\"Per Year\",tblIncome[Amount (before tax)])+SUMIF(tblIncome[Frequency],\"Per Month\",tblIncome[Amount (before tax)])*12+SUMIF(tblIncome[Frequency],\"Per Week\",tblIncome[Amount (before tax)])*72","v":{"v":65000,"d":"$65,000"}}]
[null,"Sources","Amount (before tax)","Frequency"]
[null,"Salary",{"v":65000,"d":"$65,000"},"per year"]