Excel Business Tools

Project Management

The Project Planning and Management template is designed as a generic, affordable, Excel based solution to plan and manage any project. The ability to build the projects budget as tasks are identified facilitates the processes of business case proposal, valuation analysis, and securing the required funding. Project dynamics can be altered and performance monitored with best practice Earned Value Analysis throughout the complete project...
Excel Business Tools :: Project Planning and Management :: project management solution :: Project Planning and Management template :: Project Management

Portfolio Optimization

The Portfolio Optimization model calculates the optimal capital weightings for a basket of investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions....
Excel Business Tools :: Excel :: portfolio :: optimisation :: optimization :: management :: asset :: allocation :: personal :: wealth :: fund :: management :: sharpe :: ratio :: risk :: optimal :: weighti :: Portfolio Optimization

Project Planning and Management

The Project Planning and Management template is designed as a generic solution to plan and manage any project. Building the budget as tasks are identified facilitates the processes of business case proposal, valuation and funding. Progress can be monitored from automatic creation and updating from remote participant workbooks. Project performance can be monitored with best practice Earned Value Analysis throughout the complete project lifecycle....
Excel Business Tools :: Excel :: template :: spreadsheet :: business :: project :: planning :: management :: tasks :: earned :: value :: analysis :: gantt :: scheduling :: timing :: resources :: performan :: Project Planning and Management

Portfolio Tracking - Monitoring

The Portfolio Performance Monitoring template enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions undertaken during a period are fully accounted for in the periods performance calculations...
Excel Business Tools :: portfolio :: tracking :: monitoring :: excel :: business :: tools :: business :: finance :: spreadsheets :: portfoliotracking-monitoring deluxe :: Portfolio Tracking - Monitoring

Project Planning and Management

The Project Planning and Management template is designed as a generic solution to plan and manage any project. Building the budget as tasks are identified facilitates the processes of business case proposal, valuation and funding. Progress can be monitored from automatic creation and updating from remote participant workbooks. Project performance can be monitored with best practice Earned Value Analysis throughout the complete project lifecycle....
Excel Business Tools :: Excel :: template :: spreadsheet :: business :: project :: planning :: management :: tasks :: earned :: value :: analysis :: gantt :: scheduling :: timing :: resources :: performan :: Project Planning and Management

Multiple Regression Analysis and Forecasting

The Multiple Regression Analysis and Forecasting model provides a solid basis for identifying value drivers and forecasting business plan data. While it utilises a range of commonly employed statistical measures to test the validity of the analysis, results are summarized in text for ease of use. Once relationships have been identified, forecasting can be accomplished based on a range of available methodologies....
Excel Business Tools :: Excel :: forecasting :: multiple :: regression :: template :: spreadsheet :: business :: planning :: plan :: proposal :: statistical :: testing :: multicolinearity :: auto :: cor :: Multiple Regression Analysis and Forecasting

Multiple Regression Analysis and Forecasting

The Multiple Regression Analysis and Forecasting model provides a solid basis for identifying value drivers and forecasting business plan data. While it utilises a range of commonly employed statistical measures to test the validity of the analysis, results are summarized in text for ease of use. Once relationships have been identified, forecasting can be accomplished based on a range of available methodologies....
Excel Business Tools :: Excel :: forecasting :: multiple :: regression :: template :: spreadsheet :: business :: planning :: plan :: proposal :: statistical :: testing :: multicolinearity :: auto :: cor :: Multiple Regression Analysis and Forecasting

Portfolio Performance Monitoring

The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions undertaken during a period are fully accounted for in the period's performance calculations....
Excel Business Tools :: Excel :: portfolio :: monitoring :: valuation :: management :: financial :: investments :: assets :: personal :: wealth :: stocks :: bonds :: shares :: market :: performance :: ret :: Portfolio Performance Monitoring

Investment and Business Valuation

The Investment and Business Valuation template is ideal for evaluating a wide range of investment, and business case scenarios. While it is based on the traditional DCF method of valuation, its also provides ability to evaluate economic value added valuation, accounting impact, and a range of other evaluation parameters. Furthermore, the step-by-step input flow makes usage straightforward, gaining quick results to drive decision making....
Excel Business Tools :: Excel :: investment :: financial :: valuation :: spreadsheet :: template :: EVA :: DCF :: discounted :: cash flow :: economic :: value :: added :: analysis :: business :: evaluatio :: Investment and Business Valuation

Customer Invoicing

The Customer Invoicing Template is an invoice template with the ability to store invoices, products and customers and perform advanced invoice sales reporting. The system allows the insertion, update and quick access to saved products, customers, and historical customer invoices. Product and customer lists can be imported from and exported back to text lists enabling integration with existing inventory and customer reporting management systems...
Excel Business Tools :: customer :: invoicing :: excel :: business :: tools :: business :: finance :: spreadsheets :: customerinvoicing :: Customer Invoicing

Real Option Valuation

The Real Option Valuation model encompasses a suite 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 investment if the returns on the project exceed the hurdle rate. While this is a worthwhile exercise, it fails to consider the myriad of strategic options that are associated with many investments....
Excel Business Tools :: Excel :: real options :: valuation :: template :: spreadsheet :: strategic :: financial :: pricing :: black :: bcholes :: binomial :: option :: Nash :: equilibrium :: game :: theor :: Real Option Valuation

Portfolio Performance Monitoring

The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. The model allows the entering of investment transactions during a reporting period to calculate performance. Furthermore, incremental investment transactions undertaken during a period are fully accounted for in the period's performance calculations....
Excel Business Tools :: Excel :: portfolio :: monitoring :: valuation :: management :: financial :: investments :: assets :: personal :: wealth :: stocks :: bonds :: shares :: market :: performance :: ret :: Portfolio Performance Monitoring

Investment and Business Valuation

The Investment and Business Valuation template is ideal for evaluating a wide range of investment, and business case scenarios. While it is based on the traditional DCF method of valuation, its also provides ability to evaluate economic value added valuation, accounting impact, and a range of other evaluation parameters. Furthermore, the step-by-step input flow makes usage straightforward, gaining quick results to drive decision making....
Excel Business Tools :: Excel :: investment :: financial :: valuation :: spreadsheet :: template :: EVA :: DCF :: discounted :: cash flow :: economic :: value :: added :: analysis :: business :: evaluatio :: Investment and Business Valuation

Portfolio Optimization

The Portfolio Optimization model calculates the optimal capital weightings for a basket of investments that gives the highest return for the least risk. The unique design of the model enables it to be applied to either financial instrument or business portfolios. The ability to apply optimization analysis to a portfolio of businesses represents an excellent framework for driving capital allocation, investment, and divestment decisions....
Excel Business Tools :: Excel :: portfolio :: optimisation :: optimization :: management :: asset :: allocation :: personal :: wealth :: fund :: management :: sharpe :: ratio :: risk :: optimal :: weighti :: Portfolio Optimization

Real Option Valuation

The Real Option Valuation model encompasses a suite 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 investment if the returns on the project exceed the hurdle rate. While this is a worthwhile exercise, it fails to consider the myriad of strategic options that are associated with many investments....
Excel Business Tools :: Excel :: real options :: valuation :: template :: spreadsheet :: strategic :: financial :: pricing :: black :: bcholes :: binomial :: option :: Nash :: equilibrium :: game :: theor :: Real Option Valuation