Investment-Calc 7.5.xls. Provides a combo pack of three programs for investment analysis. Used by thousands of businesses from all over the world it incorporates new quick short cuts including new instant annuity factors for Net Present Value and Internal Rate of Return for any business investment project analysis. Plus 30 page Guide, tutorial and demonstrations of project analysis.
Cash flow accounting. Budgeting and tracking cash flows throughout every accounting period. Allocates payable and receivable between due, paid and late. Includes cash burn 150 days forecasting.
Loan Amortization Manager - Multi user amortization web software. Share this multi account amortization software among work colleagues. Weekly, bi-monthly, monthly amortization schedules, save account records, edit loan repayments and interest rates at any time during repayment.
Business Budgeting PRO. Helps you prepare a 12 month business budget in double quick time. Includes actual monthly reporting and variance analysis for the current month and cumulative total and variances year to date. Over 30 product rows and 100 expense categories plus cost of sales for each product/service line.
Asset Registerpro.xls. Straight line or declining balance monthly depreciation calculations. Assets can be allocated to any one of 10 classes and 10 locations. Depreciation and book value for each class and locations are summarized for the current month end.
QuickValue. Quick valuation of any business using value benchmarks by sectors.
Financial ratio analysis. Balance sheet, income statement and cash flow analysis calculates 50 key ratios, including operating ratios, shareholder returns, working capital, debt, sales days, inventory turnover, and liquidity.
Company performance analysis.
Funding Plan PRO.xls. Ten years plan supplies p/l , cash flows and balance sheet presentations plan for raising finance. Easy templates leads you through the data required to prepare a 10 year financial plan, provides variance options, Plan summary and EBITDA value.
Inventory Manager PRO. Determine the best inventory re-order schedules (includes safety stocks), optimize the lowest cost re-order quantities, establish ordering frequencies and lot sizes, receive alerts when you need to re-order, includes seasonality, trends and forecasting, quality control inventory analysis. Improve efficiencies and enhance customer service with INVENTORY MANAGER PRO.
Statistics for Business.xls. Business Statistics. Average, Moving Average, Mean, Median, Mode, Range, Frequency, Seasonality Trends, Correlation, Variance, Regression formula, Significance (T-Test), Sigma and six sigma.
BONUS TEMPLATES with OPEN FORMULAS:
- What if Excel templates:
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.
What if capital assumptions change? (xls) Capital investment "what if" analysis supplied in one compact table.
What if financial ratios change? (xls) Calculates key financial ratios for successive periods within a compact Excel table spreadsheet.
What if currencies change? (xls) Instant calculation of 24 leading cross currency rates in real time within Excel.
What if costs change? (xls) A very handy cost calculator.
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.
- Securities & investments analysis templates:
Portfolio rate of return. (xls)
Bond yields & amortization (xls)
Treasury yields & amortization. (xls)
Bond pricing & IOD. (xls)
Company valuation. (xls)
Terminal (Closure/Sale) value. (xls)
Net Present Value & Internal Rate of Return #1. (xls)
Net Present Value & Internal Rate of Return #2. (xls)
Net Present Value & Internal Rate of Return #3. (xls)
Present value of an amount to be received in the future. (xls)
Future value of an investment or savings amount. (xls)
Rates of return & growth transformed to compound annual rates. (xls)
Net Present Value of rental leasing. (xls)
Present value of Capital Budget Cash Flows. (xls)-
- Capital projects analysis templates:
Project Appraisal Excel Template. (xls)
Construction projects rate of return. (xls)
Capital Project Cash Analysis. (xls)
Cash flow amortization schedule #1. (xls)
Cash flow amortization schedule #2. (xls)
- Balance sheet analysis template:
Altman Ratio Scores. (xls)
- Borrowing capacity template:
Extra borrowing capacity with balloon. (xls)
- Balanced Scorecard calculations:
Balanced Scorecard budgeting. (xls)
- Tools > Useful tools for Excel:
Date stamp formula. (xls)
Credit card validity check. (xls)
Moving average formula (max 500). (xls)
Filling in the Blanks. (xls)
Intentional Circular Calculations. (xls)
- Tools > Add-in Functions:
Fifty five extra financial functions (VBA) add-in. (xla)
The files listed above are downloadable as a zip file (3MB) or you can select CD shipping ($6.95 extra). |
