Financial Modelling

A large pension fund with over $200B in assets under management, on behalf of 20+ clients, needed a model to assist in the annual process whereby clients can change their asset allocations in various investment pools, including real estate, mortgages and infrastructure.

• Collaborated with the client’s finance, tax and legal teams to design a financial transaction model to meet the complex requirements of an investment pool client rebalancing. The model’s outputs needed to include a list of buy/sell transactions, journal entries and updates to legal share registries.
• Conducted extensive testing of the model with financial controllers and external auditors.
• Accepted responsibility to maintain the model and run the model at each annual pool opening.

Cascadia’s financial transaction models are now used on a recurring annual basis to support the client rebalancing process across several multi-billion dollar investment pools.