Choose natures and projects.
Due / settled installments. Contractual Amount is the installment from the acquisition Excel. Settlement Amount is cash actually settled (blank until Finance settles). Cost basis (Y) = acquisition price + capex. For one installment, click Open on that row — you do not need to tick it. Tick 2 or more rows to use Batch settlement above. In the row menu: Edit payment (discount) · Submit payment (queue AP) · Settle + transfer note · Void / write-off (note required).
|
Project Unit Code
|
Label
|
Due
|
Contractual Amount | Settlement Amount |
Status
|
Settled
|
Forex
|
Actions | |
|---|---|---|---|---|---|---|---|---|---|
| Open this tab to load the schedule. | |||||||||
Who may sell FGI stock and at what fee (CoS). Projects follow the Nature / Project scope above. Select one or more units (ASC / ORT per-unit agents), or leave units empty for the whole project. Fee may be a % of sale price or a fixed amount in the project currency.
| Seller | Fee | From | Scope | |
|---|---|---|---|---|
| Select a project to load appointments. | ||||
Monthly liquidity from unsettled acquisition calls, costs, Finance-dated TC inflows, and rent dues. Scope follows the master project filter above.
| Month | Calls | Costs | TC | Rent | Net |
|---|---|---|---|---|---|
| Open this tab to load cash calendar. | |||||
Portfolio sensitivity for unsold units in scope. Returns / ROE sit in the master banner above; this matrix shows cash and TC tranche impact by price delta. Drill-down per unit on Unit Economics.
Project return if the price scenario applies to the selected scope only:
| Price Δ% | Sold return % | Unsold return % | Total return % | Sold ROE % | Unsold ROE % | Total ROE % | Total profit | Below target |
|---|
| Price Δ% | Commission % | Unsold units | TAC | Deposit return % | TC1 | TC2 |
|---|---|---|---|---|---|---|
| Run matrix to compare scenarios. | ||||||
Unsold units with an upcoming deposit milestone — candidates for price cuts to protect cash flow.
| Unit | Stack | Severity | Days on market | Next deposit | Amount | Days to due | |
|---|---|---|---|---|---|---|---|
| Open this tab to load alerts. | |||||||