Thanks for the warning. I plan to add the previous year's cash flow to the NPV formula. NPV(x,x:x)+x
I'm confused about all the variables and how to organize my information.
Please explain to me the steps to calculating Net Present Value. I know Excel has a formula for this, but I need further explanation. Please give detail like listed below.
For example here is an IRR calcualtion:
In an excel spreadsheet...
1) Input your total costs for the project in one...
Terry,
Maybe you can recommend I do something else. I know it says programmer next to my name, but I program in MIMI (a proprietary language) not VBA.
Here's what I am trying to do.
I want to create a report to measure forecast accuracy using the following 3 text files:
Actual Orders -...
Thanks for your recommendation. I believe this is the answer I was looking for. I found it on a google search.
Action: Rename
New Name: "Table1_" & Format$(Date, "MMDD")
Object Type: "Table"
Old Name: "Table1"
Save the macro, then run it. Notice...
I have a table T_Statistical_Forecast and would like to append the current month to the table name.
For example: T_Statistical_Forecast_April
or T_Statistical_Forecast_4
Please advise me.
Thanks.
Please tell me how to rename a Table (in a way that can be run from a Macro) to incorporate the DateUpdate field.
I would ideally like to append the current Month to a table name as it is being imported.
Thanks!
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.