The Excel Portfolio Performance Tracking Template allows the performance of financial investment portfolios to be monitored and tracked on an ongoing basis with periodic valuation. Investment transactions can be entered during reporting periods and are accounted in calculating individual investment and overall portfolio performance. The portfolio performance tracking template can be refreshed at the end of the specified reporting period to archive transactions, reset start values and begin a new period for tracking the portfolio value and return.
The periodic number of units and corresponding prices for each investment are set in the Value sheet. New investment products can be added and removed to each asset class of the portfolio by using the prompted functions provided. Asset class category titles can be renamed for customization to portfolio dynamics and unused categories hidden and shown throughout the portfolio analysis as required. Start and end dates for the reporting period along with portfolio name and numeric denomination are entered here for display purposes through the portfolio tracking model. The capital contribution and initial investment date is used for calculating the returns since inception in the portfolio performance. The starting and ending values for each investment drive the initial performance calculation and overall portfolio valuation. A button is also provided to roll over the portfolio to a new reporting period whereby investment transaction data is saved to a history log and investment end values copied over to starting values.
Each investment in the portfolio can have an unlimited number of transactions during the reporting period that affect the overall performance. Transactions are divided into two types which are distributions and investments; however the combination of transactions can be utilized to account for all types of cash flows to and from the investment. The reinvestment of dividends, for example, can be entered as a positive distribution and corresponding positive investment on the same date. New input rows can be added to accommodate more transactions for an individual investment by using the button provided for this task. Calculated information regarding the timing and magnitude of investments is stored in separate columns to the right for the portfolio performance analysis for the period.
The portfolio performance analysis accounts to the intra period transactions for each investment to track the time weighted returns over the reporting period. The capital add or withdrawn as well any distributions are used with the start and end values to calculate the net return over the period and annualized return since inception for each investment. The net return over the period analyzes the investment and distribution transactions and their timings that were recorded for each investment. The annual return since inception uses the prior period return that is saved when the portfolio is rolled over to a new reporting period. Help icons for the performance returns are provided to detail the calculation method used for analysis.
The current weighting of the portfolio by asset category is presented by a pie chart and the associated data table is display with capital allocation values. The line chart tracks the trends of the portfolio valuation and performance over time by the values saved a snapshot intervals. Portfolio tracking snapshots can be taken at any time and interval to monitor the portfolio and historical performance trend on an ongoing basis. Snapshots are saved by clicking the button provided and can be removed selectively from the historical time series.
This software is not reviewed yet.
The invoice template for Excel is a complete customer invoicing system with ability to store created invoices, products and customer details, manage inventory and perform advanced order sales reporting.
The Multiple Regression Analysis and Forecasting template provides a reliable identification of value drivers and forecasting business plan data. Advanced statistical tests performed include significance, autocorrelation and multicollinearity.
The Real Option Valuation template provides a set of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Option pricing models include Black-Scholes, Binomial, and Game Theory.
The Project Planning and Management template is designed as a generic solution to plan and manage any project from start to finish. Automated features include Gantt scheduling, participant workbook creation and progress update from remote files.
The Portfolio Optimization template optimizes capital weightings for portfolios of financial investments that maximizes return and minimizes risk. Technical analysis constant parameters are optimized to maximize back tested returns on signal trading.