Financial Excel All Programs Edition provides over 100 business finance spreadsheets, Excel add - ins and Excel Learning Modules.
Investment-Calc 2008 workbooks 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. The new 2008 edition includes acquisition synergy net present values, cost of capital accounting for risk, terminal (to infinity) net present values plus an updated Quick Guide to Investment Decisions.
Project investment analysis: Inputs unit volume and unit price plus adjustments for sensitivity, cost of sale, company expenses, investment amount, debt/equity, tax rate, depreciation rule. Calculates EBITDA, operating and after tax profits, average annual income and ROIC, net present values & IRR.
12 month budgeting spreadsheets for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis.
Asset Register 2008. 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 calculated each month end.
Standard Costing templates (complete collection) provides equipment, employee and materials data values to calculate standard costs.
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.
FastPlan 2008 for five year financial plans. Three separate workbooks to halp develop quick five year monthly forecasts - P/L-Balance Sheet and Cash Flows - all from monthly revenue and expense budgets. No previous accounting experience required.
Cash Flow Forecasting 2008 generates daily, weekly & monthly cash flow forecasts to 150 day horizon from Excel list of accounts payable and receivable accounts. If you need to calculate cash flows 3 years ahead use the extra CASH BURN forecasting spreadsheet provided within this zip file.