Spreadsheet: 741431d1627040602-reverse-formula-for-financial-planning-sample-workbook
Sheet: Forecast

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.7954395826109955 | 0.7322896402555653 | 0.8725714232875517 | 0.8234962945691743 | 0.8496800926876434 | 0.827 | 0.8496800926876434 | 0.7596800926876435 | 0.8496800926876434 | 0.8496800926876434 | 0.7564827902685091 | 0.8285098578314113
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.2045604173890045 | 0.2677103597444347 | 0.1274285767124483 | 0.1765037054308257 | 0.1503199073123566 | 0.173 | 0.1503199073123566 | 0.2403199073123565 | 0.1503199073123566 | 0.1503199073123566 | 0.2435172097314909 | 0.1714901421685887
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | g2n% | 0.7410035454041022 | 0.6139133785300589 | 0.6289364836791439 | 0.6125486240374897 | 0.6073899933517075 | 0.7409405210633495 | 0.6854364778296037 | 0.6198679157120015 | 0.6400228895409955 | 0.6211694529035353 | 0.6899620459998244 | 0.7219279218324717
 | 202101 | 202102 | 202103 | 202104 | 202105 | 202106 | 202107 | 202108 | 202109 | 202110 | 202111 | 202112 |  |  |  | 202101 | 202102 | 202103 | 202104 | 202105 | 202106 | 202107 | 202108 | 202109 | 202110 | 202111 | 202112 |  |  |  | 202101 | 202102 | 202103 | 202104 | 202105 | 202106 | 202107 | 202108 | 202109 | 202110 | 202111 | 202112
GROSS | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | FY |  | NET OD | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | FY |  | NET ED | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | FY
 | Fact Data | Fact Data | Fact Data | Fact Data |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | Fact Data | Fact Data | Fact Data | Fact Data | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS | 2000 | 2000 | 2000 | 2000
1 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 57.21882561456967
2 | 1000 | 1000 | 1000 | 1000 |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  | 164.1128284808271
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
3.1 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |  |  |  |  |  |  |  | 3.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.1 |  |  |  | 1520.588166662599
3.2 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |  |  |  |  |  |  |  | 3.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.2 |  |  |  | 443.8269369133056
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
4.1 |  |  |  |  | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |  |  | 4.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.1
4.2 |  |  |  |  | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 |  |  | 4.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.2
5 |  |  |  |  |  |  |  |  |  |  | 1000 | 1000 |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
GD shares |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS shares |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NS shares
1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0.2 | 0.28 | 0.11 | 0.12
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
3.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.1 | 0.35 | 0.26 | 0.6 | 0.6
3.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3.2 | 0.12 | 0.3 | 0.0722804747154431 | 0.2030550590344508
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
4.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.1
4.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.2
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0