Spreadsheet: 483673d1475770450-properly-calculating-a-profit-split-based-on-expense-recovery-attachment-book4
Sheet: Split

 |  |  | Number of the Period |  |  |  | 1
 |  |  | Beginning of the Period |  |  |  | 2017-03-01 00:00:00
 |  |  | End of the Period |  |  |  | 2017-08-31 00:00:00 | 2018-02-28 00:00:00 | 2018-08-31 00:00:00 | 2019-02-28 00:00:00 | 2019-08-31 00:00:00 | 2020-02-29 00:00:00 | 2020-08-31 00:00:00 | 2021-02-28 00:00:00 | 2021-08-31 00:00:00 | 2022-02-28 00:00:00 | 2022-08-31 00:00:00 | 2023-02-28 00:00:00 | 2023-08-31 00:00:00 | 2024-02-29 00:00:00 | 2024-08-31 00:00:00 | 2025-02-28 00:00:00 | 2025-08-31 00:00:00 | 2026-02-28 00:00:00 | 2026-08-31 00:00:00 | 2027-02-28 00:00:00 | 2027-08-31 00:00:00 | 2028-02-29 00:00:00 | 2028-08-31 00:00:00 | 2029-02-28 00:00:00 | 2029-08-31 00:00:00 | 2030-02-28 00:00:00 | 2030-08-31 00:00:00 | 2031-02-28 00:00:00 | 2031-08-31 00:00:00 | 2032-02-29 00:00:00 | 2032-08-31 00:00:00 | 2033-02-28 00:00:00 | 2033-08-31 00:00:00 | 2034-02-28 00:00:00 | 2034-08-31 00:00:00 | 2035-02-28 00:00:00 | 2035-08-31 00:00:00 | 2036-02-29 00:00:00 | 2036-08-31 00:00:00 | 2037-02-28 00:00:00 | 2037-08-31 00:00:00 | 2038-02-28 00:00:00 | 2038-08-31 00:00:00 | 2039-02-28 00:00:00
 |  |  | Year |  |  |  | 1 | 1 | 2 | 2 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 6 | 7 | 7 | 8 | 8 | 9 | 9 | 10 | 10 | 11 | 11 | 12 | 12 | 13 | 13 | 14 | 14 | 15 | 15 | 16 | 16 | 17 | 17 | 18 | 18 | 19 | 19 | 20 | 20 | 21 | 21 | 22 | 22
 |  |  | Split | 0.6 | What we are owed
 |  |  | Up to | 1.5 | Recovered in Expenses
 |  |  | After 1.5, then | 0.5 | What we are owed
 |  |  | SPLIT CALCULATION | Units
 |  |  | Capex | CAD |  |  | -32467532.46753247 | -32467532.46753247 | -32467532.46753247 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Opex | CAD |  |  | 0 | 0 | 0 | -2666280 | -2719605.6 | -2719605.6 | -2773997.712 | -2773997.712 | -2829477.66624 | -2829477.66624 | -2886067.219564801 | -2886067.219564801 | -2943788.563956096 | -2943788.563956096 | -3002664.335235218 | -3002664.335235218 | -3062717.621939922 | -3062717.621939922 | -3123971.97437872 | -3123971.97437872 | -3186451.413866295 | -3186451.413866295 | -3250180.44214362 | -3250180.44214362 | -3315184.050986493 | -3315184.050986493 | -3381487.732006223 | -3381487.732006223 | -3449117.486646348 | -3449117.486646348 | -3518099.836379274 | -3518099.836379274 | -3588461.83310686 | -3588461.83310686 | -3660231.069768998 | -3660231.069768998 | -3733435.691164377 | -3733435.691164377 | -3808104.404987664 | -3808104.404987664 | -3884266.493087418 | -3884266.493087418 | -3961951.822949166 | 0
 |  |  | Cumulative capex + opex | CAD
 |  |  | 1.5X Cumulative capex + Opex | CAD
 |  |  | Total Revenue | CAD |  |  | 0 | 0 | 0 | 24773135.9017572 | 25183740.36421725 | 26765066.71089777 | 27050299.94415335 | 29174010.63253994 | 29657557.77009585 | 31272440.9677476 | 31790768.71859424 | 32554815.06148563 | 33094397.63156549 | 32734675.91817892 | 33094397.63156549 | 32554815.06148563 | 33094397.63156549 | 32554815.06148563 | 29627929.84025559 | 29144865.76677316 | 29627929.84025559 | 29305887.12460064 | 27139183.73367412 | 26696697.04236422 | 27139183.73367412 | 26696697.04236422 | 24591181.76741214 | 24190238.58642172 | 24591181.76741214 | 24323886.31341853 | 23702343.87220447 | 23315892.61341853 | 23702343.87220447 | 23315892.61341853 | 23702343.87220447 | 23315892.61341853 | 23702343.87220447 | 22565533.08594249 | 22813505.97699681 | 22441546.64041534 | 22813505.97699681 | 21858649.32507987 | 22220947.38019169 | 0
 |  |  | Cumulative  Total Revenue | CAD
 |  |  | Owed | CAD
 |  |  | Cumulative Owed | CAD
 |  |  | Applicable split
 |  |  |  | CAD
 |  |  | % of capex + opex recovered | %
 |  |  |  | CAD
 |  |  | Project Company Share of Total Revenue