The Portfolio Optimization template identifies the optimal capital weightings for a portfolio of financial investments that gives the highest return for the lowest risk based on the return risk profile and correlation between individual investments. The design of the portfolio optimization model enables it to be applied to either financial instrument or business stream portfolios. The portfolio optimization template is intuitive and flexible with help icons throughout to assist with input and interpretation of output results. Input of historical data for the analysis is supported by options to specify absolute prices or returns, number of current units held and a tool to download long time periods of financial market data for securities from the internet. Advanced optimization options include setting minimum and maximum constraints for weightings in the optimal portfolio and risk analysis options for overall volatility under the Sharpe ratio, downside risk or semi-deviation under the Sortino ratio and gain/loss under the Omega ratio. Optimization analyzes the probability of attaining a target return via Monte Carlo simulation. The portfolio optimization results are displayed with weighting charts and return distributions as well as acquisition and liquidation actions required. The optimization process saves possible portfolios along the extremities of the efficient frontier. Pivotal profiles for minimum and maximum return, risk, and ratios can be subsequently loaded for analysis. Technical analysis is provided with back tested total return from signal trading and automatic optimization of technical period constants for each investment or the total portfolio that results in the highest back tested return. Technical analysis indicators with detailed charting and back testing analysis include simple moving average (SMA), rate of change (ROC), moving average convergence/divergence (MACD), relative strength index (RSI) and Bollinger Bands. The template is compatible with Excel 97-2013 for Windows and Excel 2011 or 2004 for Mac as a cross platform portfolio optimization solution.
What is new in this release:
Compatible with Excel 2016.
What is new in version 5.0:
Save as XLSM feature for recent versions of Excel and enhanced exporting functions.
Microsoft Excel 97-2013
Like it? Share with your friends!
Other Windows Software of Developer «Business Spreadsheets»:
Bond Yield Calculator The Bond Yield Calculator for Excel or Open Office Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity. The bond yield to maturity calculator is designed to handle odd first time periods and i
Portfolio Performance Monitoring The Excel Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model enables the entering of investment transactions during a reporting period to calculate performance.
Project Management Template for Excel The Project Management template for Excel is designed as a generic Excel based solution to plan and manage projects. The ability to build the project budget as tasks are identified assists with the requirements for business case project proposals, valuatio
Multiple Regression Analysis and Forecasting The Multiple Regression Analysis and Forecasting template enables the confident identification of value drivers and forecasting business plan or scientific data. The multiple regression process utilizes commonly employed statistical measures to test the va
Real Options Valuation The Real Option Valuation template combines a set of option pricing tools to quantify the embedded strategic value for a range of financial analysis and investment scenarios. Traditional discounted cash flow investment analysis will only accept an investme
Excel Invoice Template The Excel invoice template is a complete customer invoicing system with the ability to store invoices, products and customers as well as monitor inventory levels and perform advanced invoice sales reporting. The architecture of the Excel invoice template a
Excel Business Valuation The Excel Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business plan scenarios. Business valuation is based on the traditional discounted cash flow method but also evaluates economic
Visual Cash Double entry system with automatic account creation organized in 14 classes. personal accounting professional. Pre installed with most accounts and concepts necessary to start counting. Intuitive generation of entries, as well as predefined seats. Full pro
OpenMiracle Openmiracle is an opensource accounting ERP released under GPL. It includes all accounting, inventory, payroll features as that of any traditional, expensive, and proprietary software available. Its suitable for Micro, Small and Medium business. OpenMiracl
Comland SAM (Spanish) Comland S.A.M is designed to facilitate administrative and commercial tasks from independent professionals to multinational companies. For developers, the adoption of the GNU OpenSource license version 3 (GPL-3.0), allows you to get the source code for fre
Abacre Cloud Restaurant Point of Sale Abacre Cloud Restaurant Point of Sale is 100% free restaurant management system consisting of two main parts: classical software for Windows working with database located in the cloud and web-based part representing restaurant's web site. It is a complete
MoneyWorks Cashbook MoneyWorks Cashbook (formerly CashWorks) is an integrated cashbook and general ledger that is the ideal accounting system for cash based businesses and bookkeepers doing accounts for other organizations. MoneyWorks Cashbook allows you to enter transactions
Indicator Analysis Included is a tool which allows you to download stock data (in original format as well as XML) from Yahoo. Finance according to a list of symbols or you can use a sample symbol list from NYSE. The program is bundled with several basic technical analysis in
F-Billing Revolution 2013 F-Billing Revolution 2013 is a soultion for unlimited invoices, orders, payments, customers and products. Network ready, supports multiple users at the same time over your LAN network. It supports Unicode characters allowing easy handling of international
SalesMate + Manage the day-to-day activities of your Sales at your fingertips using our new generation software Salesmate +, an ultimate, general purpose inexpensive Point Of Sale Software. This Point of Sale package is designed specially for independent, single-store
MoneyWorks Express MoneyWorks Express provides all the ease of use of MoneyWorks Cashbook plus the Accounts Receivable and Accounts Payable functionality required by the larger business. Share data files between platforms or even have Mac and Windows computers accessing the
Service Invoicing Template A service invoice, bill of service or service receipt is a document that is provided when collecting due payments for services rendered. The invoice template can be used as a repair invoice template, consulting invoice template, contractor invoice template
Supported Operating Systems:
Windows 10 |
Windows 2000 |
Windows 2003 |
Windows 7 |
Windows 8 |
Windows 98 |
Windows Me |
Windows NT |
Windows Vista |
Windows XP |
Comments on :
Comments not found
Windows Software - Free Windows Downloads, Apps, Games, Freeware, Skype, Media Player, Antivirus, Gimp, Live, Starter for Windows XP, Vista, 7, 8, 10