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»:
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.
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
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
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
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
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
Fanurio Fanurio is a time tracking and billing application designed to help freelancers manage their work and be paid for it. Here is a list with its most important features: * Organize your work per client using projects * Idle time detection to help you record a
QuickReports QuickReports works directly with QuickBooks to auto-generate reports and have them sent straight to your email or smartphone. Set it and forget it! Once you complete the easy setup, QuickReports will run without even being logged into QuickBooks. This save
Emerald Shuttering Stores Software In Shuttering Stores, The businessman provides items to its customers on rental basis. Items are issued and received at different time intervals. At the end of month a bill is to be dispatched to every customer. In manual working Bill generation is a very
InFile InFile is the electronic file cabinet specifically designed for QuickBooks users. InFile provides you with a uniform, centralized, and secure method to store, manage, find, and share all of your company s documents from your desktop or network. InFile work
xBooks Are you tired of exporting QuickBooks Excel reports, cutting and pasting, and reformatting them to get the information you need? Now with XBooks you can format your reports in Excel and simply refresh them with QuickBooks data without leaving Excel simply
Gamao Gamao allows your company to:
Manage the flow of input and output hardware
Improve your service.
Check for service.
Refine the maintenance policy.
Gamao is used to manage the input stream and all materials coming.
Several states are available within
MindFusion Scheduling for Silverlight MindFusion.Scheduling is a calendar and scheduling component for Silverlight. The control supports yearly, monthly, weekly and daily schedule views. Each view provides a distinct layout of the time cells and can display events such as appointments and meet
Organizer 2010 Standard Bill Manager Simple and Easy to use Billing and payment manager Software along with customer details, item wise tax modules, Maintain customer payment details like cash/cheque along with part or full payment Multi PC, Multi UserLimitations:50-entry trial
WorldAcct.com Accounting Software 5User WorldAcct.com Accounting Software provides a fully comprehensive set of accounting platform, especially for all Individuals, Enterprises, Organisations, CPAs, Professional Accountants, Financial Specialists, etc, for both business and social environment, t
MyMicroBalance MyMicroBalance is your private and free cash basis accounting software. It's easy to use and will help you in saving money efficiently. MyMicroBalance offers a lot of easy to use features, like a clear representation of your receipts and expenditures, char
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