BONUS TEMPLATES with OPEN FORMULAS

What if Excel templates

Microsoft Excel
What if profit modelling? (xls) A handy compact Excel table calculates profits, working capital, cash flows and valuation (P/e ratio), unit costs and break even levels when the following variables change > unit sales, revenues, sales growth rates, direct costs, payroll costs, G&A costs, loan costs, depreciation, receivable accounts, payable accounts, inventory levels and the effective tax rate. Calculates 12 month profit/loss schedule, working capital forecasts, free cash flow, profit margins, profit contributions, operating profit, unit profits, unit selling costs, unit standard costs, unit labor costs, break even units, break even volume, return on assets, return on equity, return on capital employed, annualized eps, receivable days, payable days, inventory days. Really useful table provides a quick snapshot of year end calculations when any combination of variables changes.

 

Microsoft Excelalt
What if capital assumptions change? (xls) Capital investment "what if" analysis supplied in one compact table. Calculates net present values and internal rate of return for any combination of pricing, direct costs, operating efficiencies, maintenance costs, employee costs, energy costs and other variables. Supplies key operating ratios under any combination of assumptions.

 

Microsoft Excelalt
What if financial ratios change? (xls) Calculates key financial ratios for successive periods within a compact Excel table spreadsheet. You can compare up to five successive periods and the trend changes.

 

Microsoft Excelalt
What if currencies change? (xls) Instant calculation of 24 leading cross currency rates in real time within Excel. Imports current rates for US dollar, AUS$, Can$, Euro, Brazilian Real, Chinese Yuan, HK$, India Rupee, Japanese Yen, Malaysian Ringgit, Mexican Peso, NZ $, Singapore $, SA Rand, South Korean Won, Taiwan $, Swiss F, Thai Baht, Venezuelan Bolivar and cross calculates between rates. Updates each time you open the workbook without having to look up rates on the web. Two page workbook.

 

Microsoft Excelalt
What if costs change? (xls) Excel template calculates operating p/l for any combination changes in direct costs, capacity utilization, direct costs, material utilization, payroll costs, utility costs with this neat handy spreadsheet. A very handy cost calculator.

 

Microsoft Excelalt
What price to fill spare capacity? (xls) Excel template calculates the optimal price/demand table and chart that yields maximum profits to fill the spare capacity you define. You need to input demand levels at two differing price levels for the spreadsheet to calculate the change of demand with price (elasticity). Provides the formulas for calculating price/demand elasticity and the sequences which create the max profit/price curve/chart.

Securities & investments analysis templates

Microsoft Excelalt
Portfolio rate of return. (xls) A very handy spreadsheet and formulas if you want to track the return and annual rate of return from a series of buy and sell share transactions. You can select the NASD 30/360 or 365 days calculation formula. Quick and handy rate of return calculator for shares.

 

Microsoft Excelalt
Bond yields & amortization (xls) This spreadsheet amortizes any bond to maturity, calculates Original Issue Discount, yield to maturity and the annual yield to maturity using the Excel IRR function.

 

Microsoft Excelalt
Treasury yields & amortization. (xls) This spreadsheet amortizes Government bonds to maturity, calculates Original Issue Discount, yield to maturity and the annual yield to maturity using the Excel IRR function.

 

Microsoft Excelalt
Bond pricing & IOD. (xls) This spreadsheet calculates the Original Issue Discount to yield a target maturity and annual yield to maturity. Plus formulas within 7–10.

 

Microsoft Excelalt
Company valuation. (xls) This spreadsheet calculates company value of using EBITDA multiples adjusting for cash, working capital, real estate and long term liabilities.

 

Microsoft Excelalt
Terminal (Closure/Sale) value. (xls) A very useful spreadsheet formulates the closure (sale) valuation to a cash flow forecast. Computes the present value of a hypothetical future sale applying a market driven EBITDA multiple, which adds to the present value of cash flows calculated from the forecast. A useful weapon valuing acquisitions or negotiating a sale.

 

Microsoft Excelalt
Net Present Value & Internal Rate of Return #1. (xls) NPV formulas and calculations with 10 inputs for cash flow, working capital additional capital and disposals, calculates up to 50 years.

 

Microsoft Excelalt
Net Present Value & Internal Rate of Return #2. (xls) NPV formulas and calculations with 10 inputs for cash flow, working capital additional capital and disposals, calculate up to 120 months.

 

Microsoft Excelalt
Net Present Value & Internal Rate of Return #3. (xls) NPV and annual IRR formulas and value when input dates and timing of cash flows are irregular.

 

Microsoft Excelalt
Present value of an amount to be received in the future. (xls) Present value of an amount due in the future calculated from today's date.

 

Microsoft Excelalt
Future value of an investment or savings amount. (xls) Present value of an amount due in the future calculated from any starting date.

 

Microsoft Excelalt
Rates of return & growth transformed to compound annual rates. (xls) This spreadsheet transform a series of sales figures into continuously compounding annual rates of growth or rates of return measured from a fixed starting date such as the start of a year.

 

Microsoft Excelalt
Net Present Value of rental leasing. (xls) Decision making rental lease or purchase spreadsheet calculates the after tax net present value of a rental lease accounting for tax relief.

 

Microsoft Excelalt
Present value of Capital Budget Cash Flows. (xls) Excel template plus formula sequences for capital budgeting calculates net present value and internal rate of return of a capital budget. 225 expense elements, average and total cash flow calculations, plus net present values and internal rate of return.

Capital projects analysis templates

Microsoft Excelalt
Project Appraisal Excel Template. (xls) Quick calculations of EBITDA, payback, net present value, internal rate of return over 20 years incorporating working capital.

 

Microsoft Excelalt
Construction projects rate of return. (xls) Specially tailored spreadsheet calculates the rate of return for construction projects with alternative scenarios. You can vary the debt to equity ratio; change the number of pre-construction periods, construction periods, and holding periods after completion before sale, incorporate tax relief on debt interest (if applicable), incorporate rent or lease income, apply a series of variable interest rates on the debt portion of financing. Calculates the annualized rate of return (internal rate of return) on owners' equity.

 

Microsoft Excelalt
Capital Project Cash Analysis. (xls) Capital budget cash analysis that will stretch to any length of time line horizon. Over 10,000 cost elements plus date due payable or receivable. Calculate cash flows in and cash flows out on any date over any time horizon. Cash burn calculation at any interval for planning.

 

Microsoft Excelalt
Cash flow amortization schedule #1. (xls) A very useful Excel template and formulas for amortizing business loans to calculate after tax net payments and effective after tax interest rate (using the internal rate of return method). Incorporates arrangement and lender fees and tax shelters within the amortization table. Calculates pre and after tax cash flows and the pre and post tax effective interest rates (the internal rate of return). The number of repayment periods per annum can be 1–52. There are a maximum 360 payment periods. Fixed rate loan schedule.

 

Microsoft Excelalt
Cash flow amortization schedule #2. (xls) Excel template provides the same calculations as #24 above plus an extra column added to enter variable loan rates into any amortization period. Adjusts the amortization schedule with repayment calculations as interest rates change. Variable rate loan schedule.

Balance sheet analysis template

 

Microsoft Excelalt
Altman Ratio Scores. (xls) Altman ratio solvency formulas and template provides quick calculation of Altman Z scores for any firm. Altman ratios predict insolvency, or confirm financial well being based on score. (Two linked templates).

Borrowing capacity template

Microsoft Excelalt
Extra borrowing capacity with balloon. (xls) You can borrow more with a balloon option. This template works out how much more you can borrow with a ceiling monthly repayment.

Balanced Scorecard calculations

Microsoft Excelalt
Balanced Scorecard budgeting. (xls). With these dual templates you can enter your targets for a balanced scorecard budget (make percentage changes to existing values and create fixed financial targets) that will improve your current financial results. Run what if percentage changes for revenue improvement (by customer growth, product types and market share), target changes in cost reduction/productivity, asset utilization, free cash flow and working capital. The second template calculates your balanced scorecard budget, a new balance sheet and cash flows.

Tools > Useful tools for Excel

Microsoft Excelalt
Date stamp formula. (xls) Spreadsheet and formulas which will monitor task completions within Excel with this fixed time/date stamp formula for Excel.

 

Microsoft Excelalt
Credit card validity check. (xls) Visa, MasterCard, Amex and Discover credit card numbers (13, 15 or 16 digits) can be validated* with Excel using this complex checksum formula. Saves time and money with a one time check routine if you are processing credit cards.
alt
* (Validated means checking whether the credit card number represents a real credit card. It does not say whether the credit card is active or delinquent).

 

Microsoft Excelalt
Moving average formula (max 500). (xls) A nice solution for Excel which ignores zero values so that you can build your own records of moving averages from within a large range table.

 

Microsoft Excelalt
Filling in the Blanks. (xls) This formula spreadsheet shows you how to fill the blanks when you have large imported lists of data imported from other applications which creates problems with sort and filtering. Our template shows you how to clean up imported data lists so that you can work with the data more easily within Excel.

 

Microsoft Excelalt
Intentional Circular Calculations. (xls) Excel tells us when a formula creates a circular loop which needs unpicking. You can use intentional circular loops to perform some very neat financial calculations. This spreadsheet shows you how with two examples. (1) the formula that maintains the record of all time high value ever entered (orders, sale rep performance, outputs) into your constantly changing updated list of values, (2) formula that calculates and recalculate sequences of random numbers between 1–100 (creates unique codes or lottery numbers).

Tools > Add-in Functions

Microsoft Excel Add-Inalt
Fifty five extra financial functions (VBA) add-in. (xla) More than fifty additional financial functions (VBA codes) provide you with several short cut commands for repetitive financial calculations. From Quick() (Quick Ratio) and CRNT (current ratio) to CC() (Cost of capital) to Disc (discount factors for net present value calculations) our pack of quick shortcut Excel functions helps you to speed up your financial calculations.

The bonus spreadsheets above are supplied with Excel Templates Gold Edition.

System Requirements

Requires: Excel 97 or later. Web data requires Excel 2000 or later and Windows XP/2000/2003 or later.

Purchase Details

Purchase includes full use of our online Business WebLinks Directory, used by Business Executives, Professional Advisors, Capital Providers, Entrepreneurs, Franchises, International Trading Companies, Universities, Government.

Order

gold_edition.jpg (32999 bytes)

Excel Templates - All Programs Complete Set Gold Edition

30-day money back guarantee!

Buy Online  $149.95
Regular Price : $299.95

More Millennium Software

Business & Finance

Material Resources Planning Systems    Accounting  Amortization   Business    Business Plan Automation   Finance 

  Info Managers   Inventory Systems  Bar Code Fonts   Legal    Planners/Schedulers   Presentation Tools

  Project Management   Internet Marketing

Management Systems (  

Contact  Management    Document   Management   Sales Management

Real Estate   Vehicles   Venture Capital

Business Using Mail, Phone, or Email

Publishing     Gem Management    Rental   Repair   Travel  )

  Software for MS Excel (Accounting    Analysis     Budgeting     Calculators    Cars   Cash Flow      Charting     Checks      Converters      E-Books     Finance     Forecasting    Employment      Inventory        Investment      IRR   Management    Marketing    NPV   Planners       Project Management      Quality Control    Schedulers )

Business Software

MS Excel Add-ins, Spreadsheets, Templates

Copyright © Millennium Software All Rights Reserved