| Excel Financial Analysis and Modelling | www.DotXLS.com "Yes, Excel can do that!" |
|
Monte Carlo Simulation in Excel The Monte Carlo Add-In for Excel adds comprehensive Monte Carlo simluation ability to your spreadsheets and Excel applications. Includes 20 random distribution generation functions. Run simulations against not just random data, but any Excel formula. Output simulation results right back into your spreadsheets for charting or further analysis. Provides persistent simulation data and access to simulations through VBA. Ultimate Excel Loan Calculator 29 Microsoft Excel worksheets to calculate mortgage payments or see if you qualify for a home equity line, student loan consolidations or to calculate monthly auto lease payments and more…. Decision Assistant Model The Decision Assistant Model allows you to value a decision and determine the impact on your business. It calculates the range of possible outcomes for your decision, their likelihood of occurring, the average outcome, and the probability of the outcome being positive (profitable). It applies three decision return estimates (Pessimistic, Middle, and Optimistic) and associated decision costs. Profit Contribution Breakdown Profit Contribution Breakdown allows you to identify the level of surplus/profit generated by components of your business. By applying relative indicators to reflect the amount of variable and fixed expense (resource) a component consumes surplus and contribution levels are calculated. Pricing and Breakeven Analysis Pricing and Breakeven Analysis Excel will determine the impact of a price change on your business. It calculates current breakeven points using revenue, variable cost, and fixed cost inputs. These are combined with estimates for price and sales volume variations to produce revenue and surplus (profit/loss) forecasts by price. Forecast and Budget Builder The Forecast and Budget Builder Excel is a streamlined tool for developing a 3 year business forecast and a 12 month budget. It requires minimal inputs and generates Optimistic to Pessimistic forecasts for your business. From your forecasts a 12 month master budget is built. Business Valuation Model The Business Valuation Model combines relative indicators for future performance with basic financial data (Revenue, Variable, and Fixed Costs) to value the business. This valuation method can be used for business purchase, sale, or establishment. The model uniquely applies your intuitive business and market knowledge to provide a 3 year performance forecast and a business valuation. The model is compact and easy to use with minimal input requirements. Five Year Budget Tool for Business The Budget Tool Business Excel provides an effective means to generate a budget for up to five years. Full flexibility allows you to add Revenue, Variable Cost, and Fixed Cost categories and lines to suit any business. Operation is via an easy to use toolbar and function buttons. Budget Compiler QuickBooks The Budget Compiler will apply and format your Profit and Loss data from QuickBooks. Using this information it will compile a flexible Excel Profit and Loss report allowing you to select the amount of detail displayed and use the data for performance review and budget formulation. Multiple Regression Forecasting The Multiple Regression Forecasting template provides a solid basis for identifying value drivers and forecasting 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. |
|
