Software Search, Categories and Specials
Ozgrid, Experts in Microsoft Excel Spreadsheets
Javascript DHTML Drop Down Menu Powered by dhtml-menu-builder.com

Active DataXL - Download

 

AnalyserXL - Download

 

DownloaderXL - Download

 

Smart VBA - Download

 

TraderXL - Download

Cash Flow Excel Worksheets

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

 

NPV - IRR Analysis for Periodic Cash Flows Start

There are 18 NPV/IRR business applications in the standard edition version. Investment-Calc provides all the "financial models" you need to calculate the NPV/ROIC and IRR of business investments, and provides calculators to work out the present value of future receivables or payables, and the PV of future cash flows

  Menu of templates and information pages 1Menu of templates and information pages 2Menu of templates and information pages 3

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.

Overview Investment-Calc of our tried and tested investment return analysis tool for Excel – contains over 50 NPV/IRR – ROI – ROR – EVA – Beta – Risk Analysis – Project Evaluation – LookUp Current Market Returns/Rates – Cost of Capital – Capital Budgets – Options – cash flow forecast templates, plus lots of help instructions & guides, financial databases and tables with current values for imported financial data.

Menu of templates and information page The program calculates Internal Rates of Return, ROIC, Payback, after tax cash flows, present values, Accounting Rate of Return, Share Valuation & Economic Valuations with variable equity/debt financing ratios, and risk analysis over any forecast period. Investment-Calc incorporates self generating tables that calculate straight line and MACRS depreciation and tax calculations.

Investment-Calc 7.3 provides:

  1. Excel calculators for: Present values, cost of capital, rate of return required, discount rates, continuous adjustments, Continuing Value, Share Valuation.
  2. Linked spreadsheets for creation of business investment evaluation models using discounted cash flow with quick and easy adjusters to review alternative assumptions and resulting returns.
  3. Imported financial data from useful web sites, converted to Excel databases for easy referencing.

Below are a selection of 8 screen graphics out of 65 calculators, spreadsheets, help guides, explanations and templates provided: Present Value & Compounding calculators for Excel from/to any future date. T-Bill rate values are imported via Web Query.

Present Value & Compounding calculators for Excel from/to any future date. T-Bill rate values are imported via Web Query

Imported financial data transposed to easy lookup combo boxes.

Imported financial data transposed to easy lookup combo boxes

Start calculating NPV & IRR using Goal Seek as well as Excel IRR.

Start calculating NPV & IRR using Goal Seek as well as Excel IRR Start calculating NPV & IRR using Goal Seek as well as Excel IRR

Preparing Base Case Investment Appraisal and risk adjustment figures using these instructions and templates.

Preparing Base Case Investment Appraisal and risk adjustment figures using these instructions and templates Preparing Base Case Investment Appraisal and risk adjustment figures using these instructions and templates

After tax analysis Base Case forecast adjusted by varying unit volumes and price levels.

After tax analysis Base Case forecast adjusted by varying unit volumes and price levels

After tax analysis Base Case forecast adjusted by varying unit volumes and price levels.

After tax analysis Base Case forecast adjusted by varying unit volumes and price levels

Use Continuing Value calculations to include project value beyond the forecast period

Use Continuing Value calculations to include project value beyond the forecast period

Quick NPV/IRR forecasting schedules for annual projections (to 60 years) and monthly (to 120 months).

Quick NPV/IRR forecasting schedules for annual projections (to 60 years) and monthly (to 120 months) Quick NPV/IRR forecasting schedules for annual projections (to 60 years) and monthly (to 120 months)

Share Valuation:
Value on earnings or cash flow projections.

Share Valuation:<BR>Value on earnings or cash flow projections

Basic accounting returns & EBIT forecasting, and IRR of a profit forecast.

Basic accounting returns & EBIT forecasting, and IRR of a profit forecast

Capital Project analysis with detailed expense and income itemizations.

Capital Project analysis with detailed expense and income itemizations

Valuing a lease purchase.

Valuing a lease purchase

Portfolio rate of return and annualized rate of return using 365/360 day options.

Portfolio rate of return and annualized rate of return using 365/360 day options

NPV - IRR Analysis for Periodic Cash Flows Start

NPV - IRR Analysis for Periodic Cash Flows $169.95  Secure Payment Options Buy as Part of All Excel Templates Gold Edition - HUGE Value - 80% Discount!

Special ! Free Choice of Complete Excel Training Course OR Excel Add-ins Collection on all purchases totaling over $70.00. ALL purchases totaling over $150.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.

See Also: Excel Templates Index (BEST VALUE! All Excel Templates Gold Edition) or, All Software



Instant Download and Money Back Guarantee on Most Software

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft

Some of our more popular products are below...
Convert Excel Spreadsheets To Webpages | Trading In Excel | Construction Estimators | Finance Templates & Add-ins Bundle | Code-VBA | Smart-VBA | Print-VBA | Excel Data Manipulation & Analysis | Convert MS Office Applications To...... | Analyzer Excel | Downloader Excel | MSSQL Migration Toolkit | Monte Carlo Add-in | Excel Costing Templates