Spreadsheet: 858195d1706938578-solve-for-multiple-objective-cells-in-solver-sff-2024-solver-copy-3
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 | Total Income: Levies plus Interest | Prev Yr Closing Bal plus Total Income | Anticipated Expenses | Closing Balance | % Variance in Annual SF Levy | [NAME] | 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 |  | 9099.75 | 3255 |  |  |  |  |  |  | -25
3 | 2025-12-31 00:00:00 |  | 32000.44999999998 | 3255 |  |  |  |  |  |  | -25
4 | 2026-12-31 00:00:00 |  | 0 | 3255 |  |  |  |  |  |  | -25
5 | 2027-12-31 00:00:00 |  | 3838.95703125 | 3255 |  |  |  |  |  |  | -25 |  | Bitumen repairs
6 | 2028-12-31 00:00:00 |  | 2879.2177734375 | 3255 |  |  |  |  |  |  | -25
7 | 2029-12-31 00:00:00 |  | 7485.9662109375 | 3255 |  |  |  |  |  |  | 0 |  | [NAME]
8 | 2030-12-31 00:00:00 |  | 2879.2177734375 | 3255 |  |  |  |  |  |  | 0
9 | 2031-12-31 00:00:00 |  | 2879.2177734375 | 3255 |  |  |  |  |  |  | 0
10 | 2032-12-31 00:00:00 |  | 2879.2177734375 | 3255 |  |  |  |  |  |  | 0 |  | Bitumen repairs
11 | 2033-12-31 00:00:00 |  | 2879.2177734375 | 3255 |  |  |  |  |  |  | 0 |  | Electrical rework
12 | 2034-12-31 00:00:00 |  | 2879.2177734375 | 3255 |  |  |  |  |  |  | 0 |  | [NAME]
13 | 2035-12-31 00:00:00 |  | 2879.2177734375 | 3255 |  |  |  |  |  |  | 0
14 | 2036-12-31 00:00:00 |  | 2879.2177734375 | 3255 |  |  |  |  |  |  | 0
15 | 2037-12-31 00:00:00 |  | 2879.2177734375 | 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 | Total Income: Levies plus Interest | Prev Yr Closing Bal plus Total Income | Anticipated Expenses | Closing Balance | % Variance in Annual SF Levy | [NAME] | 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
3 | 2024-12-31 00:00:00 | 50000 |  |  |  |  |  |  | 50000 | Interest earned April - Dec (9 months)
4 | 2025-12-31 00:00:00 | 50000 |  |  |  |  |  |  | 50000 | First full year of earnings
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 | 50000