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.
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.0 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.0 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.
More Details: Investment-Calc For NPV, IRR, ROI + Portfolio ROR | Cash flow Excel worksheets | Sensitivity Analysis calculations | NPV-IRR worksheet | EVA & Capital Investment Appraisal | Daily Interest Tables Spreadsheet | PV & Monthly Cash Flows
NPV - IRR Analysis for Periodic Cash Flows
$169.95 $69.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 $69.00. ALL purchases totaling over $138.00 gets you BOTH! Purchases MUST be made via this site. Send payment proof to [email protected] 31 days after purchase date.
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