Spreadsheet: 857741d1706671275-solve-for-multiple-objective-cells-in-solver-sff-2024-solver-copy
Sheet: 4 CF Forecast 50K Inv

 | Remara Interest earned - $50,000 Investment
 | SCENARIO A - INCLUDING BITUMEN RESURFACING YRS 7, 12, 15
Year | Year To | Opening Balance | Total Levy Contributions | Macquarie Interest (after tax) | [NAME] (after tax) | Remara 50K /Macquarie 100K | Anticipated Expenses | Closing Balance | % Variance in Annual SF Levy |  | Forecast Major Anticipated Expense Item | Amount
 |  |  | ([NAME]. GST) | Invest 100K | Invest 50K | Total Interest | Excl GST
1 | 2023-12-31 00:00:00 |  |  |  | 0 |  |  | 207372 | 147143
2 | 2024-12-31 00:00:00 |  |  | 3255 | 3413 |  |  |  | -25
3 | 2025-12-31 00:00:00 |  |  | 3255 |  |  |  |  | -25
4 | 2026-12-31 00:00:00 |  |  | 3255 |  |  |  |  | -25
5 | 2027-12-31 00:00:00 |  |  | 3255 |  |  |  |  | -25 |  | Bitumen repairs
6 | 2028-12-31 00:00:00 |  |  | 3255 |  |  |  |  | -25
7 | 2029-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0 |  | [NAME]
8 | 2030-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0
9 | 2031-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0
10 | 2032-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0 |  | Bitumen repairs
11 | 2033-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0 |  | Electrical rework
12 | 2034-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0 |  | [NAME]
13 | 2035-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0
14 | 2036-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0
15 | 2037-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0 |  | Topcoat & repair Bitumen
 | SCENARIO B - EXCLUDING BITUMEN RESURFACING
Year | Year To | Opening Balance | Total Levy Contributions | Macquarie Interest (after tax) | [NAME] (after tax) | Remara 50K /Macquarie 100K | Anticipated Expenses | Closing Balance | % Variance in Annual SF Levy |  | Forecast Major Anticipated Expense Item | Amount
 |  |  | ([NAME]. GST) | Invest 100K | Invest 50K | Total Interest | Excl GST
1 | 2023-12-31 00:00:00 | 242275 |  |  |  |  |  |  | 147143
2 | 2024-12-31 00:00:00 |  |  | 3255 | 3413 |  |  |  | -25
3 | 2025-12-31 00:00:00 |  |  | 3255 |  |  |  |  | -25
4 | 2026-12-31 00:00:00 |  |  | 3255 |  |  |  |  | -25
5 | 2027-12-31 00:00:00 |  |  | 3255 |  |  |  |  | -25 |  | Bitumen repairs
6 | 2028-12-31 00:00:00 |  |  | 3255 |  |  |  |  | -25
7 | 2029-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0
8 | 2030-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0
9 | 2031-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0
10 | 2032-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0 |  | Bitumen repairs
11 | 2033-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0 |  | Electrical rework
12 | 2034-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0
13 | 2035-12-31 00:00:00 |  |  | 3255 |  |  |  |  | 0
14 | 2036-12-31 00:00:00 |  |  | 3255 | 4550 |  |  |  | 0
15 | 2037-12-31 00:00:00 |  |  | 3255 | 4550 |  |  |  | 0 |  | Bitumen repairs
 | Remara Interest earned - $50,000 Investment
Year |  | Initial Investment | Interest earned | Tax paid | Net Earnings after tax |  | Closing Investment Balance
1 | Year To
2 | 2023-12-30 00:00:00 | 50000 |  |  |  |  | 50000 | Interest earned April - Dec (9 months)
3 | 2024-12-31 00:00:00 | 50000 |  |  |  |  | 50000 | First full year of earnings
4 | 2025-12-31 00:00:00 | 50000 |  |  |  |  | 50000
5 | 2026-12-31 00:00:00 | 50000 |  |  |  |  | 50000
6 | 2027-12-31 00:00:00 | 50000 |  |  |  |  | 50000 |  | Macquarie interest adjusted to reflect redirection of funds to Remara
7 | 2028-12-31 00:00:00 | 50000 |  |  |  |  | 50000 |  | Amt Invested | TD interest | Tax paid | Net after tax
8 | 2029-12-31 00:00:00 | 50000 |  |  |  |  | 50000 |  | 100000
9 | 2030-12-31 00:00:00 | 50000 |  |  |  |  | 50000 |  | 75000
10 | 2031-12-31 00:00:00 | 50000 |  |  |  |  | 50000 |  | 50000
11 | 2032-12-31 00:00:00 | 50000 |  |  |  |  | 50000
12 | 2033-12-31 00:00:00 | 50000 |  |  |  |  | 50000
13 | 2034-12-31 00:00:00 | 50000 |  |  |  |  | 50000
14 | 2035-12-31 00:00:00 | 50000 |  |  |  |  | 50000
15 | 2036-12-31 00:00:00 | 50000 |  |  |  |  | 50000
 | 2037-12-31 00:00:00