Spreadsheet: 714774d1611360721-help-with-a-string-of-if-statements-cashflow-template-online-example-updated-expected-outcome-conorg-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3 |  |  |  | Year 4 |  |  |  | Year 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019-09-30 00:00:00 | 2019-12-31 00:00:00 | 2020-03-31 00:00:00 | 2020-06-30 00:00:00 | 2020-09-30 00:00:00 | 2020-12-31 00:00:00 | 2021-03-31 00:00:00 | 2021-06-30 00:00:00 | 2021-09-30 00:00:00 | 2021-12-31 00:00:00 | 2022-03-31 00:00:00 | 2022-06-30 00:00:00 | 2022-09-30 00:00:00 | 2022-12-31 00:00:00 | 2023-03-31 00:00:00 | 2023-06-30 00:00:00 | 2023-09-30 00:00:00 | 2023-12-31 00:00:00 | 2024-03-31 00:00:00 | 2024-06-30 00:00:00
Property Address | Tenant | Lease Start | Lease Break Exercised? | Lease Break Date | Lease Break Start. | Lease Break End. | Lease Expiry | Lease [NAME] | [NAME] | Rent | Rent Post Void | Post Void Lease Expiry | VOID (# [NAME]) | Q3 2019 | Q4 2019 | Q1 2020 | Q2 2020 | Q3 2020 | Q4 2020 | Q1 2021 | Q2 2021 | Q3 2021 | Q4 2021 | Q1 2022 | Q2 2022 | Q3 2022 | [NAME] | Q1 2023 | Q2 2023 | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024
 |  |  |  | 2020-12-09 00:00:00 |  |  | 2021-02-10 00:00:00 |  |  | 10000 | 7000 | 2020-12-09 00:00:00 | 1
 |  |  | Yes | 2022-04-10 00:00:00 |  |  | 2020-04-09 00:00:00 |  |  |  |  | 2021-04-09 00:00:00 | 3
Expected Outcome 1 | Tenant 1 | 2020-01-01 00:00:00 | Yes | 2020-12-09 00:00:00 |  |  | 2021-02-10 00:00:00 |  |  | 10000 | 7000 | 44174 | 1 | 2500 | 2500 | 2500 | 2500 | 2500 | 2500 | Void | Void | 1750 | 1750 | 1750 | 1750 | 1750 | 1750 | 1750 | 1750 | 1750 | 1750 | 1750 | 1750
Expected Outcome 2 | [NAME] | 2020-01-01 00:00:00 | Yes | 2023-05-30 00:00:00 |  |  | 2022-06-20 00:00:00 |  |  | 900000 | 624000 | 2022-06-20 00:00:00 | 1 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | 225000 | Void | 156000 | 156000 | 156000 | Void | 156000 | 156000 | 156000 | 156000
Expected Outcome 3 | Tenant 3 | 2019-09-05 00:00:00 | Yes | 2022-04-10 00:00:00 |  |  | 2020-04-09 00:00:00 |  |  | 1000000 | 680000 | 2021-04-09 00:00:00 | 3 | 250000 | 250000 | 250000 | Void | Void | Void |  | Void | Void | Void | 170000 | 170000 | 170000 | 170000 | 170000 | 170000 | 170000 | 170000 | 170000 | 170000
Initial Loan Requirement |  |  |  |  | Opening Bal
Property Value |  |  |  |  | [NAME]
Annuity Loan Profile on |  |  |  |  | [NAME]
Term |  |  |  |  | Closing LTV
Gross Rent
Interest p.a.
Service Charges & Costs - lessee
Profit before tax
Tax Payable (estimated) @
Total Interest, Expenses & Tax
Cashflow available pre Principal Repayments p.a.
Net Cashflow Available per above
Add back interest
Cashflow available for Debt Servicing
Cashflow after Debt Servicing
Gross Interest Cover
DSCR Pre Tax
DSCR Post Tax
Surplus Cashflow Available p.a. - pre tax
Surplus Cashflow Available p.a. - post tax
Tax Calculation
Rent
Expenses
Interest
Interest Dissalowed |  |  |  | 0
Capital Allowance |  |  |  | 0
Taxable Surplus
Tax Payable @
Rent Reserve
Opening reserve |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Surplus Cashflow Available p.a. - post tax
Cumulative reserve