ST Alpha - "STIS: What's the formula for calculating Present Value of an equal payment every month over an infinite time frame? -- nm" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 157

STIS: What's the formula for calculating Present Value of an equal payment every month over an infinite time frame? -- nm

Posted by Strongbad (aka Rambler14) Apr 3 '14, 11:52

(No message)

Responses:

=pv(rate,nper,pmt,fv,arrears?) - spamlet Apr 3, 11:54 2
- the mouth on this one -- nm - prayformojo Apr 3, 12:02 1
  - =sumif(range, criteria, sum range) - spamlet Apr 3, 12:17
wiki? -- (link) - Vibia Kincardine Apr 3, 11:53 7
- (everything I can find assumes an n, length of time) -- nm - Strongbad Apr 3, 11:54 4
  - If you're using Excel, just put in 1,000,000. Once you get past that the PV changes aren't material for each additional. -- nm - spamlet Apr 3, 11:55 3
    - Thanks. I should have tried Excel. I'm looking at the P/A charts and they max out at n=100. -- nm - Strongbad Apr 3, 11:56 2
      - Truthfully even at 100 it starts to get really small. -- nm - spamlet Apr 3, 11:57 1
        
        Graci. -- nm - Strongbad Apr 3, 12:03
- calc? -- (link) - Vibia Kincardine Apr 3, 11:53 1
  - yup. life of project (years) -- nm - Strongbad Apr 3, 11:54

Post a message top

Replies are disabled on threads older than 7 days.