|Home > Excel Business Solutions > Business Finance > Business Valuation > Investment NPV and IRR Calculation||Share|
Excel Investment NPV and IRR Calculation
Rate this solution:(2.8/5 from 6 votes)
|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:
(Pricing is available on the next page)
(Updated on 2017-06-01)
Related Excel Solutions for Investment NPV and IRR CalculationFinancial 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 CategoriesBusiness Finance Financial Markets Operations Management Excel Productivity