- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Can someone please provide an Excel formula
Posted on 2/18/13 at 9:45 am
Posted on 2/18/13 at 9:45 am
for calculating the present value of $495,092 with charged interest of 1.5% per month for 4 months?
Posted on 2/18/13 at 9:46 am to Chaz95
If you know how to write and read python code, I've got homemade finance scripts that handle this
//ETA: I spend a considerable amount of free time coin roll hunting, script development, and reading. My finance scripts are not pretty, but I am right now cleaning them up and integrating them to build a clean program that will handle calculating present value, future value of several things.
The current program I am working on is going to be used to help me determine if buying a specific car can be justified. Right now I am listing which specific factors will be necessary for myself in the purchase, and then expand it to include more factors in the decision making.
//ETA: I spend a considerable amount of free time coin roll hunting, script development, and reading. My finance scripts are not pretty, but I am right now cleaning them up and integrating them to build a clean program that will handle calculating present value, future value of several things.
The current program I am working on is going to be used to help me determine if buying a specific car can be justified. Right now I am listing which specific factors will be necessary for myself in the purchase, and then expand it to include more factors in the decision making.
This post was edited on 2/18/13 at 9:52 am
Posted on 2/18/13 at 10:02 am to Chaz95
quote:
for calculating the present value of $495,092 with charged interest of 1.5% per month for 4 months?
Not sure if serious
Posted on 2/18/13 at 10:05 am to Powerman
Or if you just want one formula and don't want to see everything else
Posted on 2/18/13 at 10:06 am to Powerman
(no message)
This post was edited on 4/6/13 at 1:02 pm
Posted on 2/18/13 at 3:03 pm to Chaz95
+XIRR and +XNPV can compute many uniquely timed values.
Posted on 2/18/13 at 5:35 pm to Chaz95
Formula: =PV(.015,4,0,495092)
Present Value: $466,467.87
....assuming $495,092 was your FV (what you had 4 months from now after earning 1.5% interest monthly for 4 months).
Present Value: $466,467.87
....assuming $495,092 was your FV (what you had 4 months from now after earning 1.5% interest monthly for 4 months).
This post was edited on 2/18/13 at 6:02 pm
Posted on 2/18/13 at 9:56 pm to rickgrimes
quote:
the present value of $495,092 with charged interest of 1.5% per month for 4 months
I still have no idea how anybody can read this and know what it means. There's like 3 different ambiguities in there.
Popular
Back to top
Follow TigerDroppings for LSU Football News