
Publisher's description
The Customer Invoicing Template is an Excel invoice template with the ability to store invoices, products and customers and perform advanced invoice sales reporting. The database structure of the invoice 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. Key features of the Customer Invoicing Template include: Control panel to establish predefined content for the invoice template and facilitate efficient customer invoice management; Add, update, access and remove products, customers and orders quickly and easily; Capacity to save 65000 products, 65000 customers, and 1.3 million orders; Locate and load previously saved invoices in the system; Import and export customer and product lists in CSV text file formats for integration with existing inventory and customer management systems; Export invoices to Excel worksheets or Microsoft InfoPath XML files; Automatic product inventory stock level adjustment; Update of amount paid for invoices by customers for calculation of uncollected revenue outstanding; Sales reporting for the analysis of product and customer profitability and performance with ranking options.
Bond Yield Calculator |
The Bond Yield to Maturity calculator for Excel and OpenOffice Calc enables the automatic generation of scheduled bond payments and the calculation of resulting yield to maturity.
Investment and Business Valuation |
The Investment and Business Valuation template is ideal for evaluating a wide range of investment, financial analysis and business case scenarios. Analysis performed includes accounting impact, Economic Value Added, and NPV of cash flows.
Portfolio Optimization |
The Portfolio Optimization model calculates the optimal capital weightings for a basket of financial investments that gives the highest return for the least risk. Results display action required and probability analysis through Monte Carlo simulation
Portfolio Performance Monitoring |
The Portfolio Performance Monitoring model enables the ongoing monitoring and periodic valuation of a portfolio of financial investments. Amount and timing of investment and divestment transactions are taken into account in performance calculations.
Project Planning and Management |
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.
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. Option pricing tools include Black-Scholes, Binomial, and Game Theory.
Regression Analysis and Forecasting |
The Multiple Regression Analysis and Forecasting template provides a solid basis for identifying value drivers and forecasting business plan data. Advanced statistical tests performed include significance, auto correlation, and multi colinearity.