Excel Business Finance Spreadsheets provides business and financial spreadsheets to assist in budgeting, forecasting and expense control.

Excel Software Tools

business and finance templates for excel

Excel Business & Financial Templates - Complete Set plus Libor Futures Curve in Excel

~~$169.95~~ Now Only $152.95 Purchase Now

Financial Statement Forecasting Pro for Excel

~~$95.95~~ Now Only $62.95 More Information

Monte Carlo Financial Modeling

~~$69.95~~ Now Only $62.95 More Information

Financial Ratio Calc

~~$69.95~~ Now Only $62.95 More Information

Excel Costing and Expense Controls

~~$69.95~~ Now Only $62.95 More Information

Excel Business Financial Templates - Complete Set Review

The Complete Excel Business and Finance Templates

Excel Finance and Business Spreadsheets offers 150 business and finance templates that will assist you in forecasting cash flows, analyzing investments, setting up budgets and mock-up financial forecasts and statements efficiently.

Cash Forecasting
Asset Register
Investment-Calc
Inventory Control & Scheduling
Risk Analysis Sales forecasting
Instant Balance Sheets
Costing & expense control
Financial ratios
Libor Futures Curve in Excel - Libor curve predicts the movement of long term interest rates.

Cash Forecasting – Forecasts are updated daily with the 150 days spreadsheet.

Excel spreadsheets that will output 150 days ahead and show daily closing balances that can allow you to prepare your cash forecasts quickly.

Save time and money with the Asset Register workbook that will assist in updating, recording, and tracking assets.

Prepare monthly budgets for several profit centers with the consolidating budget Excel workbook.

Investment-Calc makes available forecasting and risk control spreadsheets and investment capital analysis. In addition you can calculate ROIC and discounted cash flows, cost of capital, Present values and internal rates of return, Synergy net present values.

This program also includes an Investment Rate of Return with formulas and Calculations and 30 page guide including worked examples. Keep track of your loan accounts with the Lease/Loan Accounting template. You can consolidate monthly interest and repayment, current outstanding balances and you can forecast yearly cumulative balances and totals until repayment. Another large file we will send to you via file sharing.

Cash control and forecasting workbooks supplies extra cash managing oversight for any company.

Keep track of 3,000 inventory items with the Inventory Control & Scheduling. You can compute and save month end inventories.

Monte Carlo methods will help you to with investment return risk and break even analysis and Risk Analysis Sales forecasting probability and analysis.

Instant Balance Sheets offers you fast calculations of bank balance forecasting

Costing & expense control including cost drivers, activity based costing, allocate overhead costs by department, economic batch quantities and allocates depreciation costs.

Financial ratios. Income statement, balance sheet, and cash flow analysis calculates 50 key ratios, including shareholder returns, operating ratios, debt, sales days, working capital, liquidity and inventory turnover.

FastPlan analyses and prepares 5 year financial plans. You can develop income forecasts and cash flows, financial forecasts with simulated balance sheets, including expenses by item and monthly sales forecasting.

Plus bonus software to assist you in transferring Excel workbooks into your Apple iPad with a magic file index which Apple iPad does not supply.

Plus Rewards Program for iPad apps.

Libor Futures Curve in Excel. The LIBOR Eurodollar curve will predict longer-term interest rates providing a importnat direction for investment decisions and discount rates.

Features

Investment-Calc .xls INVESTMENT-CALC PRO IRR/ NPV Solutions/Libor curve - for analyzing capital investments. Over 20 templates for evaluating cash flow present values and projects, calculates payback analysis and break even month analysis, plus IRR and NPV valuations plus Libor Futures curve. Includes a Quick Guide to investment calculations which provides all the equations and formulas for calculating the rate of return by means of time value methods.

Cash flow reporting spreadsheets.xls (monthly and daily) - merges up to five individual revenue centers into one complete report. Daily cash receipts, capital expenditures, expenses by categories and loan and lease payments. Daily closing cash balances for p/l centers and mixed together.

Cash Flow forecasting.xls (150 days ahead forecasting)- forecasts closing cash balances up to 150 days ahead by taking payables and receivables list and computing the banking day of payment or receipt. Input any number of days ahead for a quick snapshot of closing daily cash balance at any future date.

MasterBudgetspro.xls (monthly budget and reporting with variances and ytd). Run up to 10 departmental budget with Master Budgets. Create your overhead budget and allocate fixed expenses to each department. Reports monthly profit and loss for each department and variances by individual revenue and expense categories. Year to date report summarizes the entire budget for any month end. You can set any month end date to start your budget. You can vary the reporting analysis month end to track each divisional performance or combined figures at any month end date.

Asset Registerpro.xls (10,000 asset records). Straight line monthly depreciation calculations for a maximum 10,000 assets, plus year to date totals and net book values. Assets can be allocated to any one of 25 classes. Depreciation and book value for each class are summarized for the current month end. Figures recalculates when you change the month end date. Incorporates net impact of disposals.

Company performance ratios.xls (Monthly and five years). Balance sheet, income statement and cash flow statements yield 50 key ratios, operating, shareholder, working capital, debt, sales days, inventory turnover, and liquidity.

QuickValue Pro.xls. Input the firms cash flows or project and forecast revenue and expenses into the templates and calculate the discounted cash flow value and the per share present value.

FastPlan.xls (five year forecasting). Create monthly revenue and expense forecasts and this programs turns your figures into five year (monthly) balance sheets, income and cash flow forecasts. Produces operating and core ratios and return on capital data.

CURRENCY > You can set the currency to any symbol by opening the Format menu in Excel and selecting Cells from the drop down list, which produces the Format Cells table. Click Currency and then choose the currency you want to work with from the Symbol panel. In CheckMy Loans the currency defaults to your local currency setting.

Screenshots

excel business spreadsheets