Home > Portfolio Performance Tracking User Guide > Understanding the Model Structure Help Topic Share

Understanding the Model Structure

Help for understanding the model structure in the portfolio performance tracking template for Excel

User Guide Navigation:
Business Spreadsheets User Guides: Project Planning and Management Multiple Regression Analysis and Forecasting Investment and Business Valuation Real Options Valuation Portfolio Optimization Portfolio Performance Tracking Customer Invoicing
Portfolio Performance Tracking Help Topics: Understanding the Model Structure Managing Portfolio Products Entering Transactions Executing Reports Understanding the Reports

The 'Value' sheet calculates the net gain or loss over the valuation period. It is also provides buttons for critical functions including adding new products, deleting existing products, hiding or unhiding product categories, and rolling over the portfolio to a new reporting period. Details of new products are entered into this sheet, as are market valuations of products at the time of reporting. Parameters entered and displayed on this sheet are:


The 'Trans' sheet is for manually entering transactions on products as they occur. It also calculates incremental returns from distributions. This sheet records transactions for the reporting period which are then taken into account when calculating the performance of each investment. Parameters entered and displayed on this sheet are:


The 'Perf' sheet calculates and displays the performance of the portfolio over the reporting period by taking into account the transactions over the period and the valuation parameters. Information on formulas utilized to calculate performance is provided in corresponding help icons. There is no manual entry in this sheet. Parameters displayed on this sheet are:


The 'Graph' sheet automatically creates a pie chart illustrating current portfolio weightings. Performance 'Snapshots' can be created here to visualize the overall value and periodic return of the portfolio over time. Clicking the 'Take Snapshot' button populates the table and performance chart with a new observation consisting of the reporting date, total value and overall return from the 'Value' sheet. Snapshot observations can be removed from the chart by selecting the row to be removed and clicking the 'Remove Selected Snapshot' button.


The 'History' sheet stores all transactions prior to the current valuation period, in chronological order.