|
 Excel Templates For Net Present Value and IRR |
|
Publisher :
Millennium Software Inc
|
| Date added :
10-Mar-2003
|
Rating :
|
| size :
0 K
|
| Language :
English
|
| License :
Shareware - Time Limit
|
| Limit Price :
$ 99.95
|
| OS :
Windows 98/NT/2000/ME/XP/VISTA
|
| UpdateDate :
26-Sep-2007
|
| Requirements :
128MB RAM,10 MB of hard-disk space for program installion.
|
|
|
|
 |
Excel Templates For Net Present Value and IRR Information |
|
| Investment-Calc 7.5 provides three Excel workbooks for investment analysis. Used by thousands of businesses from all over the world it incorporates new quick short cuts including instant annuity factor method for Net Present Value and Internal Rate of Return and ready made NPV & IRR cash flow solutions for up to 35 project comparisons. Plus 30 page Guide explaining net present value calculations and internal rate of return, tutorial and demonstrations of project analysis. Capital budgeting NPV & IRR templates. Company valuation template. EBIT/ROIC forecasting spreadsheet. Present Value Calculators (6 tables) Project Analysis NPV & IRR templates. Weighted cost of capital calculator. Risk analysis explained. Sensitivity analysis NPV & IRR templates. Quick Cash flow NPV-IRR to 60 years spreadsheet. Quick Cash flow NPV-IRR to 120 months spreadsheet. Dynamic charting explained. Portfolio Return and annual ROR table. Constant bond yield amortization spreadsheets, yield to maturity and original issue discount calculations. Annuity factors short cut to investment return analysis templates. ANY CURRENCY > Click Currency and then choose the currency you want to work with from the Symbol panel. Zip file download: The download contains four files, Investment-Calc 7.5, bond yield templates, the demo tutorial and the Quick Guide. |
|
Screenshot |
|
|
|
|
|
|
|
|
|
Reviews Of Excel Templates For Net Present Value and IRR |
|
| No opinions. Be the first! |
|
|
 |
|
| 1. Financial Excel All Programs Edition |
03/Sep/2003
|
Rating :
The Financial Excel All Programs Edition provides over 100 business finance spreadsheets, Excel add ? ins and Excel Learning Modules.
<P>
The list below provides a partial description of all the Exel workbooks and zip file collections which are downloadable or delivered on CD.
<P>
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.
<P>
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.
<P>
12 month budgeting spreadsheets for 1-10 departments. Consolidates individual budgets year to date and provides monthly variance analysis.
<P>
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.
<P>
Standard Costing templates (complete collection) provides equipment, employee and materials data values to calculate standard costs.
<P>
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.
<P>
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.
<P>
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.
<P>
The price of our Financial Excel All Programs Collection will be increased on September 1, 2008 by 25% and this notification provides customers with the opportunity to purchase before this price increase.
<P>
Download all 100 financial Excel files, or order the CD version.
<P>
You can download a zipped file containing 12 bonus excel files/workbooks/templates immediately after purchase including Balanced Scorecard, Capital Project Appraisal, Excel Amortization, Source & Application of Cash flows, Financial Models. THESE ARE NOT OUR PRINCIPAL FINANCIAL APLLICATIONS SEE BELOW.
<P>
Despite the notice below that "You will be able to download the product immediately after ordering!", there will be a small time delay as explained above.
|
|
|
|
| 2. Standard Costing Templates 5.0 |
03/Sep/2003
|
Rating :
Standard Costing Templates for Excel helps you calculate product costs using different costing systems. Standard Costing Templates includes abc system and correct overhead allocation methods.
|
|
|
|
| 3. Monthly Financial Ratios Windex (2) |
10/Mar/2003
|
Rating :
Monthly Financial Ratio Templates - for Excel.Compare two consecutive monthly financial periods with Windex. Calculates all the major financial ratios for comparsion between periods.
|
|
|
|
| 4. Lease/Loan Organizer |
24/Mar/2006
|
Rating :
Lease/Loan Organizer reports the repayment status, interest expense and remaining balances for up to 3,000 capital leases at any selected month end. Users can create up to 100 individual Master Lease ID categories with 3,000 sub-components or classify leases by Class or locations. Lease interest, outstanding balances and current month principal repayment are consolidated for each single Master Lease ID.
|
|
|
|
| 5. QuickValue PRO 5.0 |
10/Mar/2003
|
Rating :
QuickValue PRO 5.0 is our latest version (February 2006) of this tried and tested business valuation analysis tool for Excel popularly including current valuation benchmarks which are updated monthly.
|
|
|
|
|
|
