Portfolio research and capital planning · Field guide · October 9, 2026
Schedule reviews of investment assumptions
Inputs become stale at different rates. A signed financing term, an operating quote and an annual revenue estimate should each have a review trigger appropriate to the decision they support. Use a refresh calendar to identify when the model must be updated before the next approval.
Evidence to assemble
Gather the source records before completing the worksheet. A missing record should remain an open question. Keep the original alongside any summary so the next person can trace the decision.
| Input | Record with it |
|---|---|
| Input source register | Record the source, document date, reviewer and unresolved question. |
| Contract and quote expiry dates | Record the source, document date, reviewer and unresolved question. |
| Operating reporting schedule | Record the source, document date, reviewer and unresolved question. |
| Upcoming approval dates | Record the source, document date, reviewer and unresolved question. |
Work through the decision
- Assign a review trigger to material inputs.
- Name the person who will obtain updates.
- Record changes and unchanged confirmations.
- Refresh the decision model before reuse.
For each action, name the person responsible for preparing the response and the person who approves it. Record what evidence would close the item. If new information changes cost, timing or scope, update the affected plan and identify who needs the revised version.
Common failure to avoid
A recently edited spreadsheet can still contain old inputs. Track the source date rather than relying on the file modification date.
Worked example
A hypothetical owner revisits a purchase model after a lender quote expires. The review updates the financing assumption and identifies which capital and cash-flow outputs need recalculating.
This is an illustrative workflow, not a client case study or a forecast. Replace the example’s facts with the records for your own project.
Complete your planning worksheet
Use the fields to connect evidence, action and approval. Your entries stay in this page and are included only when you choose to download them. They are not sent to a server and are not saved after a page reload.
Close the handoff
A finished worksheet should identify the result, its evidence and any remaining owner. If the result is uncertain, record the next action instead of marking the whole task complete. Keep the worksheet with the relevant source file and tell the receiving person which version applies.