Business Finance

Our Complete Templates 2008 Collection provides over150 business finance spreadsheets with new Excel productivity add–ins and Excel learning programs including VBA routines included. Plus 12 months full corporate membership of our Global Business Ideas Network. Save a total $2,400.

Investment-Calc 7.5 PRO for Present values and internal rate of return of periodic cash flows, future values of money flows, present values compounded between dates, present values of a recurring amount, present value of periodic investments, analysis of capital projects.

Project investment analysis: Input volumes, pricing, direct and variable costs,plus adjustments for sensitivity levels, includes risk analysis, vary debt/equity ratios, vary tax rates, calculate EBITDA, operating and after tax profits, average annual income, ROIC, net present values & IRR. Compare up to 30 projects. PLUS: Project cash flow analysis workbook. Financial modelling workbook. Project valuation analysis workbook. 12 month budgeting spreadsheets for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis.

Asset Register PRO. Straight line depreciation register for 10,000 assets. Assets may be allocated to any one of 25 classes and 25 locations. Depreciation and book value for each class and locations are recalculated at the end of each month. Standard Costing templates (complete collection).

QuickValue. Quick valuation of any business using 5 years prior or forecast financials.
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. Includes Economic Value Added results (EVA).
FastPlan 9.16 for five year financial plans. Develop your 5 year monthly budgets and FastPlan transfoms these into balance sheets, income forecasts and cash flows.

Using a quick copy/paste (or export from Quicken, SAP etc) into our accounts receivable and payable spreadsheets you can see how your cash is going to work out for 90 days ahead.

Everything is so easy with Excel. Excel links all your receivable and payable accounts together to provide a day by day cash flow summary. If you need to calculate your cash burn each day for 150 days ahead use the cash forecasting spreadsheet.

Determine your profit by product and supplier. Product and Supplier Profitability allows you to identify the true costs associated with your products. It does this by considering initial costs (purchase, transport, receiving, and reject), on-going costs (storage, overheads), as well as finance and customer return costs. Calculations are presented in both Form and Table view for effective display. Supplier/Product profiles are created in Form view and cost analysis by unit and profile applied. Sensitivity functions allow you to test variations for Stockturn and Customer Returns. Each profile can be saved to the Table view providing a database of profiles with Sub Totals by supplier and calculations for the Total Business. A Template feature allows you to set up standard profiles. This software is suitable for all resale business operations regardless of size. It allows you to build a complete product/supplier database with a cost breakdown and analysis for each profile, each supplier and the Total Business. From this you can critically compare suppliers and products to determine true profit contributions.

The Business Valuation Model Excel 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 with sensitivity analysis, investment return, and a business valuation. It is compact, easy to use, and requires minimal inputs. Outputs include a 3 year performance forecast with the ability to apply Sensitivity Analysis and produce Optimistic, Expected and Pessimistic forecasts. A Return on Investment and Business Valuation are provided for each forecast. Outputs are presented in tabular and graphical form. The model is easy to use and interpret.
Quantity: The Number of Licenses you purchase is the maximum Number of Users and the maximum Number of Computer Systems the purchased software can be installed on or that can access the software if on a network.

Pricing and Breakeven Analysis uses break even analysis to calculate your current business break even point using revenue, variable, and fixed cost inputs. This is combined with price elasticity (estimates for price and sales volume variations) to produce revenue and surplus (profit/loss) forecasts by price. The model determines the Optimum Pricing to maximize your surplus and can be applied to new or established businesses, product/service lines, or individual items. It is compact, easy to use, and requires minimal inputs. Outputs include break even charts for Current, Increased, Decreased, and Optimum pricing. Each break even chart is a graphical display of the break even analysis including the break even point considering price elasticity. Extended Price Analysis determines Optimum Pricing to maximize your business surplus. The Revenue, Surplus, and Number of Sales are calculated for prices ranging from -50% to +50% of the current price. Pricing and Breakeven Analysis incorporates break even analysis, break even charts, break even points and price elasticity to determine the impact of pricing on your business and optimum pricing.

Quantity: The number of licenses you purchase is the maximum Number of Users and the maximum Number of Computer Systems the purchased software can be installed on or that can access the software if on a network.