|
Contact us: admin@mlnsoft.com |
Quick calculations of Net Present Values, Discounted Cash Flows, Internal Rate of Return, Accounting Rate of Return, Daily Loan Interest, Asset Replacement Investments, Capital Optimisations, Profit and Mark Up Forecasts, Project Valuations.
With Investment-Calc PRO you can create and manipulate ready to use cash flow Excel worksheets to analyse business, capital, share, lease purchase cash flow forecasts for internal use, for acquisitions, and for calculating best valuation for sale. The program calculates Net Present Values, Internal Rates of Return, Accounting Rate of Return, Share Valuation & Economic Valuations over any forecast period to 15, 20, 30 or 50 years. Investment-Calc incorporates self generating tables, that calculate yearly asset depreciation values for any yearly capital purchase program, prepares tax calculations, calculates annual lease and loan finance costs and repayments, compounds money values and transfers all values automatically into user's spreadsheets to help save time.
The Cash Flow Forecasting template below will help you prepare a 1-15 year cash flow forecast quickly based on annual sales, gross margin, expenses and capital budget forecasts for rapid calculation of Net Present Value, Internal Rate of Return, Accounting Rate of Return & Economic Valuation. With Investment-Calc PRO you can create and manipulate cash flow worksheets to analyse company acquisitions, capital investments, lease purchases, with combinations of term loan/capital lease financing, and calculate daily compound deposit interest, optimise capital budgets and value business cash flows.
Investment-Calc provides a complete library of pre-programmed tables which supply automatic calculations of annual repayments of loan & lease principal, interest payments due, depreciation charges, taxes and timing of tax payments, and enters these values into the spreadsheets to speed up the calculations.
You can change any key variable in the Sensitivity Analysis calculations to locate the maximum rate of return position.
The NPV-IRR analysis spreadsheet provides after tax NPV, IRR and pay back periods values for any capital investment or cost recovery program over any period to 30 years. Investment-Calc PRO calculates annual depreciation charges based on varying annual capital investments added throughout any budget period.
The NPV-IRR worksheet calculates annual cash flows and Net Present Values using accelerated depreciation tax calculations if required.
The capital investment projections are recalculated by changing assumptions in the NPV-IRR Sensitivity Forecast. In this example the investment, earnings and working capital forecasts have been lowered to create higher rates of return than the original. Experiment with the Sensitivity Forecasting to locate the maximum rate of return combinations.
There are two Economic Value Added worksheets. The first calculates EVA from the 15-year cash flow forecasting worksheet budget data (see first screen). The second supplies departmental or divisional EVA templates. The individual EVA results are consolidated to calculate the overall company EVA score. If the consolidated EVA<0 the company can locate departments/divisions responsible for dragging the overall EVA score down and take remedial action.
The Capital Investment Appraisal worksheet supplies a quicker route to calculation of Net Present Values of forecast cash flows over 1-30 years by automating calculations using constant ratios. Depreciation, loan repayments and tax calculations are calculated in prepared tables.
The Daily Interest Tables spreadsheet will instantly calculate compounded interest totals for an investment deposit for you over any number of days (D) covering any date periods. New interest rates, additions and withdrawals can be entered into the table. The table automatically stops calculating after D number of days has elapsed from the starting date.
Investment-Calc PRO provides a quick way to value company shares using current free cash flows with forecast growth rate forecasts (can be negative!), the number of shares and Present value calculations over the next 20 years.
PV Table 1 calculates PV of annual recurring amount. Table automatically enters recurring amount for as many years (periods) as are selected and either discounts or compounds as required.
PV Table 2 calculates the PV of any future amount received between the present and any period to 30 years. Table automatically enters the amount into the year selected and calculates PV.
New Version 7.3
Many capital investment project forecasts do not conform to the simple rigid structure of a single investment outlay in period one followed by cash flows over future periods. Construction projects for example require continuing investment expenses over many periods with later final or staged completion payments. Calculating the Present Value of future income receipts in any irregular pattern is another non-conforming type of present value calculation requirement.
Version 7.3 supplies tools to handle the rate of return and present value of any forecast pattern of cash flow income and expenses.
New features in version 7.3 help users create quick forecasts using a simple list method of forecasting cash income/expenses and month #, (columns C-E below) making entering data very simple and snappy. No more searching for the correct columns or periods to create or change a forecast, simply enter the forecast data in a simple list in columns C-E, and the program sends the data to the correct period and recalculates Present Values, Profits, Mark Ups and Internal Rate of Returns. The forecast can be created in any list sequence, so that changing or new assumptions can be incorporated very quickly, easily and simply. The 50-year cash flow forecasting grid is next right in the program.
