Excel Templates for Cash Flow Forecasting Cash Flow Templates provide cash flow reports and forecasts to forecast exact cash positions ahead with quick look up of any daily balance 1-120 days forward using simple listings of payable and receivables.
The Summary report combines depreciation totals , book values, disposals to the current or adjusted month end date.
The capacity is up to 10,000 asset records plus 25 asset categories.
Depreciation calculations can be switched backwards or forwards in time.
Universal Pricing Calculations The Universal Pricing Excel Templates calculate price - demand elasticities and relationships and uses standard accounting formulas to give the exact price which will produce the maximum profit for any product.
Net Present Value (NPV) and Internal Rate of Return (IRR) The NPV and IRR Excel templates calculate the NPV/ROIC and IRR of business investments, and provide calculators to work out the present value of future receivables or payables and the present value of future cash flows.
Asset Register The Asset Register can be used within any country with S/L depreciation rules.
Calculates straight line monthly depreciation and book values by item and by asset category (office supplies, computers, equipment, etc).
This extensive collection contains multiple Excel templates/workbooks for business finance applications and financial analysis.
Financial Analysis Templates for Excel help to plan business finances and budgets, analyze and track fixed assets, cash flows and investment projects net present values and internal rate of return.
Included in the financial analysis template library are the following Excel templates offered as a comprehensive bundle here at a considerable discount to the combined prices.
Links are provided here, where available, to read more about each template or purchase individually.