Spreadsheet: 857741d1706671275-solve-for-multiple-objective-cells-in-solver-sff-2024-solver-copy
Sheet: 5 CFF 75K Inv

 | Remara Interest earned - $75,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 75K /Macquarie 75K | Anticipated Expenses | Closing Balance | % Variance in Annual SF Levy |  | Forecast Major Anticipated Expense Item | Amount
 |  |  | ([NAME]. GST) | Invest 75K | Invest 75K | Total Interest | Excl GST
1 | 2023-12-31 00:00:00 |  |  |  | - |  |  |  | 147143
2 | 2024-12-31 00:00:00 |  |  | 2441 |  |  |  |  | -25
3 | 2025-12-31 00:00:00 |  |  | 2441 |  |  |  |  | -25
4 | 2026-12-31 00:00:00 |  |  | 2441 |  |  |  |  | -25
5 | 2027-12-31 00:00:00 |  |  | 2441 |  |  |  |  | -25 |  | Bitumen repairs
6 | 2028-12-31 00:00:00 |  |  | 2441 |  |  |  |  | -25
7 | 2029-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0 |  | [NAME]
8 | 2030-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0
9 | 2031-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0
10 | 2032-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0 |  | Bitumen repairs
11 | 2033-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0 |  | Electrical rework
12 | 2034-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0 |  | [NAME]
13 | 2035-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0
14 | 2036-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0
15 | 2037-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 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 75K /Macquarie 75K | Anticipated Expenses | Closing Balance | % Variance in Annual SF Levy |  | Forecast Major Anticipated Expense Item | Amount
 |  |  | ([NAME]. GST) | Invest 75K | Invest 75K | Total Interest | Excl GST
1 | 2023-12-31 00:00:00 |  |  |  |  |  |  |  | 147143
2 | 2024-12-31 00:00:00 |  |  | 2441 |  |  |  |  | -25
3 | 2025-12-31 00:00:00 |  |  | 2441 |  |  |  |  | -25
4 | 2026-12-31 00:00:00 |  |  | 5119 |  |  |  |  | -25
5 | 2027-12-31 00:00:00 |  |  | 2441 |  |  |  |  | -25 |  | Bitumen repairs
6 | 2028-12-31 00:00:00 |  |  | 2441 |  |  |  |  | -25
7 | 2029-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0 |  | [NAME]
8 | 2030-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0
9 | 2031-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0
10 | 2032-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0 |  | Bitumen repairs
11 | 2033-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0 |  | Electrical rework
12 | 2034-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0 |  | [NAME]
13 | 2035-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0
14 | 2036-12-31 00:00:00 |  |  | 2441 |  |  |  |  | 0
15 | 2037-12-31 00:00:00 |  |  | 2441 | 6825 |  |  |  | 0 |  | Bitumen repairs
 | Remara Interest earned - $75,000 Investment
Year | Year To | Initial Investment | Interest earned | Tax paid | Net Earnings after tax |  | Closing Investment Balance
1 | 2023-12-30 00:00:00
2 | 2024-12-31 00:00:00 | 75000 |  |  |  |  | 75000 | Interest earned April - Dec (9 months)
3 | 2025-12-31 00:00:00 | 75000 |  |  |  |  | 75000 | First full year of earnings
4 | 2026-12-31 00:00:00 | 75000 |  |  |  |  | 75000
5 | 2027-12-31 00:00:00 | 75000 |  |  |  |  | 75000
6 | 2028-12-31 00:00:00 | 75000 |  |  |  |  | 75000 |  | Macquarie interest adjusted to reflect redirection of funds to Remara
7 | 2029-12-31 00:00:00 | 75000 |  |  |  |  | 75000 |  | Amt Invested | TD interest | Tax paid | Net after tax
8 | 2030-12-31 00:00:00 | 75000 |  |  |  |  | 75000 |  | 100000
9 | 2031-12-31 00:00:00 | 75000 |  |  |  |  | 75000 |  | 75000
10 | 2032-12-31 00:00:00 | 75000 |  |  |  |  | 75000 |  | 50000
11 | 2033-12-31 00:00:00 | 75000 |  |  |  |  | 75000
12 | 2034-12-31 00:00:00 | 75000 |  |  |  |  | 75000
13 | 2035-12-31 00:00:00 | 75000 |  |  |  |  | 75000
14 | 2036-12-31 00:00:00 | 75000 |  |  |  |  | 75000
15 | 2037-12-31 00:00:00 | 75000 |  |  |  |  | 75000