{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Introduction","Input","Result"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"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":"Introduction","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[3,3,3,4],[49,3,57,13],[5,3,15,13],[21,3,32,13],[47,3,47,7],[39,3,43,13]]}
[]
[]
[]
[null,null,null,"Rent Calculator"]
[]
[null,null,null,"This rent calculator allows tenants to enter information about their tenancy and proposed amounts of rent waivers and deferrals to assist in determining options for entering payment plans to reduce their rents.  It may also be useful as an indication of what your rent reduction agreement will mean for your financial position during the agreement and afterwards when you have to pay back any rental arrears.\n\nIn NSW you will need to show your income has dropped by 25 per cent (after tax) to gain protection from eviction under the  NSW Government's rent relief package. To view eligibility criteria, please see the NSW Fair Trading website.  Even if you do not qualify for the rent relief package, you can still use this tool as a guide to inform any voluntary negotiations with your landlord.\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Notes about the calculator"]
[]
[null,null,null,"Tenants should consider any financial hardship they may face in the immediate and longer term when assessing whether a rent reduction offer is 'fair and reasonable'.\n\nAs a general rule your housing costs should be no more than 30% of your household income where your income is below a certain threshold. We consider that housing costs includes rent plus other costs required to make the property liveable - your energy and water costs.\n\nAt a minimum, when assessing whether the reduced rent allows for adequate remaining income it may be useful for you to refer (and refer your landlord or agent) to the following as a guide in the NSW context for an absolute baseline on sufficient income after housing costs for other essentials like food and healthcare. We have adjusted these figures in line with inflation and rounded down to the nearest whole dollar:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Single person",null,297]
[null,null,null,null,null,null,"Couple, no children ",null,465]
[null,null,null,null,null,null,"Couple, 1 child ",null,609]
[null,null,null,null,null,null,"Couple, 2 children",null,755]
[null,null,null,null,null,null,"Sole parent, 1 child",null,459]
[]
[null,null,null,"Source: Saunders, P., & Bedford, M. (2017). New Minimum Income for Healthy Living Budget Standards for Low-Paid\nand Unemployed Australians: Summary Report. Sydney: Social Policy Research Centre, UNSW Sydney.\nhttp://doi.org/10.4225/53/5994e24f82386"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Assumptions"]
[]
[null,null,null,"In relation to the rent arrears payment plan after Covid-19:\n\n- If you do not enter an anticipated amount of income after COVID-19, the assumption is that funds will remain at current COVID-19 levels. \n- There is an assumption that after the rent reduction payment plan, the tenant will revert to paying Contract Rent.\n- There is also an assumption  that a user will choose either:  a number of weeks in which to pay back the arrears OR an amount of  arrears  to payback each week. "]

{"sheet":"Input","index":1,"n_rows":61,"n_cols":16,"rows_kept":61,"cut":false,"hidden":false,"merged":[[55,12,55,13],[48,12,48,13],[40,12,42,15],[43,12,46,15],[6,12,17,15],[37,11,38,16],[51,12,51,13],[53,12,53,13],[52,3,52,4],[3,3,3,4],[15,3,15,4],[25,3,25,4],[42,3,42,4],[31,3,31,4],[35,4,35,5],[27,3,27,4],[37,3,37,4],[39,3,40,6],[29,3,29,6]]}
[]
[]
[]
[null,null,null,"Financial position"]
[]
[null,null,null,1,"Weekly pre COVID-19 net household income (after tax)"]
[]
[null,null,null,2,"Current weekly net household income (inc Centrelink, after tax)"]
[]
[null,null,null,3,"Amount of rent in arrears as at current date"]
[]
[null,null,null,4,"Anticipated weekly post COVID-19 net household income (after tax) (if different from current weekly net household income)"]
[]
[]
[]
[null,null,null,"Tenancy agreement"]
[]
[null,null,null,1,"Weekly rent"]
[]
[null,null,null,2,"Lease start date "]
[]
[null,null,null,3,"Lease end date (if applicable)"]
[]
[]
[]
[null,null,null,"Rent reduction arrangement"]
[]
[null,null,null,"Rent Waiver"]
[]
[null,null,null,"A rent waiver is where the landlord agrees not to collect rent or only partial rent for a period. "]
[]
[null,null,null,"Do you wish to include a rent waiver?  (please select yes or no)",null,null,"No"]
[]
[null,null,null,1,"Weekly rent waiver",null,0]
[]
[null,null,null,null,"The percentage of current weekly rent that is being waived is",null,{"$f":"G34/G18","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Rent Deferral",null,null,null,null,null,null,null,"Payments Preview"]
[]
[null,null,null,"Rent deferral is a situation where the rent for a period is still payable, but the actual payment is delayed for a period. You will need to pay this amount back, ideally with an agreed repayment plan."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Please use the information in this box to compare options for negotiation, before applying it to your circumstances."]
[]
[null,null,null,"Do you wish to include a rent deferral? (please select yes or no)",null,null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,"You have chosen to ask for the option of a rent deferral. Once your rent reduction agreement has ended, the deferred amount of rent and any other rent arrears owed will need to be paid back according to a plan."]
[null,null,null,1,"Weekly amount of rent deferral** (in dollar terms)",null,0]
[]
[null,null,null,2,"Deferral period (no. of weeks)"]
[]
[null,null,null,3,"Deferred amount",null,{"$f":"IF(G43=\"Yes\",G45*G47,\"\")","v":""},null,null,null,null,null,"Calculated end date of paying off arrears",null,null,{"$f":"IF(G43=\"Yes\",IF(AND(ISBLANK(G59),ISBLANK(G61)),\" \",IF(ISBLANK(G59),TODAY()+G47*7+G61*7,TODAY()+G47*7+O54*7)),\" \")","v":" "}]
[]
[null,null,null,null,"The percentage of current weekly rent that is being deferred is",null,{"$f":"IF(AND(G43=\"Yes\",G45<>0),G45/G18,\"\")","v":""},null,null,null,null,null,null,null,"With deferral","Waiver only"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Total rent arrears",null,{"$f":"IF(G43=\"Yes\",G10+G49,\" \")","v":" "},{"$f":"G10","v":0}]
[null,null,null,"Rent Arrears"]
[null,null,null,null,null,null,null,null,null,null,null,null,"No. of weeks to pay off when paying fixed amount",null,{"$f":"IF(G43=\"Yes\",IF(AND(ISBLANK(G59),ISBLANK(G61)),\" \",IF(ISBLANK(G61),O52/G59,\"N/A\")),\" \")","v":" "},{"$f":"IF(AND(ISBLANK(G59),ISBLANK(G61)),\" \",IF(ISBLANK(G61),P52/G59,\"N/A\"))","v":" "}]
[null,null,null,1,"Total amount of rent arrears =  rent deferral (deferred amount) + other arrears",null,{"$f":"IF(G43=\"Yes\",G10+G49,G10)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Amount to pay per week when paying over a fixed time period",null,{"$f":"IF(G43=\"Yes\",IF(AND(ISBLANK(G59),ISBLANK(G61)),\" \",IF(ISBLANK(G59),O52/G61,\"N/A\")),\" \")","v":" "},{"$f":"IF(AND(ISBLANK(G59),ISBLANK(G61)),\" \",IF(ISBLANK(G59),P52/G61,\"N/A\"))","v":" "}]
[null,null,null,null,"Please select one of the following."]
[]
[null,null,null,null,"Amount able to be paid back per week for rent arrears."]
[null,null,null,null,"or"]
[null,null,null,null,"Number of weeks to payback the rent arrears"]

{"sheet":"Result","index":2,"n_rows":121,"n_cols":7,"rows_kept":121,"cut":false,"hidden":false,"merged":[[59,3,59,4],[61,3,61,6],[88,3,88,4],[106,3,106,4],[3,3,3,4],[17,3,17,4],[29,3,29,4],[31,3,31,4],[43,3,43,4],[57,3,57,4],[67,3,67,4],[69,3,70,6]]}
[]
[]
[]
[null,null,null,"Financial position"]
[]
[null,null,null,1,"Weekly pre COVID-19 net household income (after tax)",null,{"$f":"Input!G6","v":0}]
[]
[null,null,null,2,"Current weekly net household income (inc Centrelink, after tax)",null,{"$f":"Input!G8","v":0}]
[]
[null,null,null,3,"Amount of rent in arrears as at current date",null,{"$f":"Input!G10","v":0}]
[]
[null,null,null,4,"Anticipated weekly post COVID-19 net household income (after tax)",null,{"$f":"IF(Input!G12=\"\",G8,Input!G12)","v":0}]
[]
[null,null,null,null,"Percentage reduction in income",null,{"$f":" ((G6 - G8) / G6)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,"Tenancy agreement"]
[]
[null,null,null,1,"Weekly rent",null,{"$f":"Input!G18","v":0}]
[]
[null,null,null,2,"Lease start date ",null,{"$f":"Input!G20","v":"00:00:00"}]
[]
[null,null,null,3,"Lease end date",null,{"$f":"Input!G22","v":"00:00:00"}]
[]
[null,null,null,"Rent reduction arrangement","Percentage of income on rent based on pre-covid19 net household income",null,{"$f":"G20/G6","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,"Rent as a proportion of Income:"]
[]
[null,null,null,"A proportional rent reduction based on the percentage of income spent on rent prior to COVID-19, would look like this:"]
[]
[null,null,null,1,"Percentage of income on rent based on pre COVID-19 net household income",null,{"$f":"G26","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,2,"Weekly rent",null,{"$f":"G20","v":0}]
[]
[null,null,null,3,"Proportional rent reduction (waiver + deferral) based rent to pre COVID-19 net household income",null,{"$f":"G20*G26","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Amount of rent payable per week with proportional rent reduction based rent to pre COVID-19 net household income",null,{"$f":"G20-G38","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Amount left of income after new rent paid for other living costs",null,{"$f":"G8-G38","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"A proportional rent reduction based on your reduction of income would look like this:"]
[]
[null,null,null,1,"Percentage reduction in income",null,{"$f":"G14","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,2,"Weekly rent",null,{"$f":"G20","v":0}]
[]
[null,null,null,3,"Proportional rent reduction (waiver + deferral) based on percentage reduction in income",null,{"$f":"G20*G14","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Amount of rent payable per week with proportional rent reduction based on percentage reduction in income",null,{"$f":"G20-G50","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Amount left of income after new rent paid for other living costs",null,{"$f":"G8-G52","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[null,null,null,"Rent reduction arrangement"]
[]
[null,null,null,"Rent Waiver"]
[]
[null,null,null,"A rent waiver is where the landlord agrees not to collect rent or only partial rent for a period. "]
[]
[null,null,null,1,"Weekly rent waiver",null,{"$f":"Input!G34","v":0}]
[]
[null,null,null,null,"Percentage of rent waiver based on contract rent",null,{"$f":"IF(Input!G32=\"Yes\",G64/G20,\"\")","v":""}]
[]
[null,null,null,"Rent Deferral"]
[]
[null,null,null,"Rent deferral is a situation where the rent for a period is still payable, but the actual payment is delayed for a period. You will need to pay this amount back, ideally with an agreed repayment plan."]
[]
[]
[null,null,null,null,"Deferred amount",null,{"$f":"Input!G49","v":""}]
[]
[null,null,null,1,"Weekly amount of rent deferral** (in dollar terms)",null,{"$f":"Input!G45","v":0}]
[]
[null,null,null,null,"Percentage of rent deferral based on contract rent",null,{"$f":"IF(Input!G43=\"Yes\",G75/G20,\"\")","v":""}]
[]
[null,null,null,2,"Deferral period (no. of weeks)",null,{"$f":"Input!G47","v":0}]
[]
[null,null,null,null,"Amount of rent per week with reduction (reduced amount)",null,{"$f":"IF(Input!G43=\"Yes\",G20-(G64+G75),G20-G64)","v":0}]
[]
[null,null,null,null,"Percentage of income on rent based on current weekly net income",null,{"$f":"IF(Input!G43=\"Yes\",G81/G8,\"\")","v":""}]
[]
[null,null,null,null,"Amount left of income after new rent paid for other living costs",null,{"$f":"G8-G81","v":0}]
[]
[]
[]
[null,null,null,"Rent Arrears - repayment plan"]
[]
[null,null,null,1,"Pay total based on a set time period"]
[]
[null,null,null,null,"A weekly payment of the rent arrears in $ terms",null,{"$f":"IF(AND(Input!G59=\"\",Input!G61=\"\"),0,IF(Input!G59=\"\",Input!G55/Input!G61,Input!G59))","v":0}]
[]
[null,null,null,null,"Number of weeks to payback the rent arrears",null,{"$f":"IF(AND(Input!G59=\"\",Input!G61=\"\"),0,IF(Input!G61=\"\",Input!G55/Input!G59,Input!G61))","v":0}]
[]
[null,null,null,null,"Date arrears arrangement will end",null,{"$f":"IF(G93>0,(TODAY()+Input!G55/G93*7),(TODAY()+(G79*7)+(G95*7)))","v":"2020-05-11"}]
[]
[null,null,null,null,"Anticipated weekly post COVID-19 net household income (after tax)",null,{"$f":"G12","v":0}]
[]
[null,null,null,null,"Amount of rent per week after COVID-19 based on payback arrangement",null,{"$f":"G20+G93","v":0}]
[]
[null,null,null,null,"Percentage of income on rent based on current weekly net income",null,{"$f":"G101/G12","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Amount of income available for other living costs after rent",null,{"$f":"G12-G101","v":0}]
[]
[null,null,null,"Other possible payment plans for arrears"]
[]
[null,null,null,1,"Pay total amount up front"]
[]
[null,null,null,null,"Total amount of rent arrears",null,{"$f":"Input!G55","v":0}]
[]
[null,null,null,2,"Pay total over remainder of fixed term based on lease end date (if applicable)"]
[]
[null,null,null,null,"Anticipated weekly post covid19 net household income (after tax) (if different from pre-covid-19 income)",null,{"$f":"G12","v":0}]
[]
[null,null,null,null,"Amount of rent per week after COVID-19 based on lease end date",null,{"$f":"Input!G55/(((G24-TODAY()-G79*7)/7)-1)+G20","v":0}]
[]
[null,null,null,null,"Percentage of income on rent based on current weekly net income",null,{"$f":"G117/G12","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Amount of income available for other living costs after rent",null,{"$f":"G12-G117","v":0}]