Home > Excel Business Solutions > Business Finance > Business Valuation > Investment NPV and IRR Calculation Share

Investment NPV and IRR Calculation

Excel investment npv and irr calculation for business valuation

Excel Investment NPV and IRR Calculation

Rate this solution:
(3.1/5 from 7 votes)
Investment NPV and IRR Calculation screenshot
The Excel Investment NPV and IRR Calculation can create and manipulate ready to use cash flow Excel worksheets to analyze business, capital, share, lease purchase cash flow forecasts for internal use, acquisitions and for calculating best valuation for sale. The program calculates Net Present Values, Internal Rates of Return, Accounting Rate of Return, Share Valuation and Economic Valuations over any forecast period to 15, 20, 30 or 50 years.

Investment NPV and IRR Calculation for Excel 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. The Investment NPV and IRR Calculation for Excel can create and manipulate cash flow worksheets to analyze company acquisitions, capital investments, lease purchases, with combinations of term loan/capital lease financing, calculate daily compound deposit interest, optimize capital budgets and value business cash flows.

To facilitate analysis there is access to web data including:

  • Historical/current inflation indexes
  • US Treasuries (risk free) rates
  • US Constant Maturity rates
  • Current Libor rates
  • Mortgage rates
  • Latest monthly (US) economic statistics
  • Latest monthly Cost of capital average tax rates and beta ratios (risk factors) benchmarks for 101 industry sectors
  • Cost of Capital, Return on Equity, Return on Capital benchmarks, Net Margins & Effective Tax rate averages for 81 countries
  • Monthly statistics with refresh for latest NASDAQ, Dow, Oil Prices and US Government Bond rates. Set Excel to auto refresh each time you open Excel for very latest data.

Get It

(Pricing is available on the next page)
(Updated on 2018-06-01)

Related Excel Solutions for Investment NPV and IRR Calculation

Financial Analysis TemplatesFinancial Analysis  Internal Rate of Return TemplatesFinancial Analysis  Investment and Business ValuationBusiness Valuation  Business Value CalculationBusiness Valuation  NPV and IRR TemplateBusiness Valuation  Multiple Regression ForecastingForecasting and Prediction  Database ConversionConverting and Integrating

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.