PV of a single payment at the end of 10 years

[PJF]

How can I calculate the PV of a payment of, say, $100,000 payable in full at
the end of 10 years? There are no periodic payments. The annual % rate is
5%?

Any help would be appreciated.

Regards,

PJF

 

[Bernie Deitrick]

PJF

=100000*1.05^10

HTH,
Bernie
MS Excel MVP

 

[PJF]

Bernie,

I'm most grateful. Thanks for the quick response.

PJF

 

[joeu2004]

How can I calculate the PV of a payment of, say, $100,000 payable in full at
the end of 10 years? There are no periodic payments. The annual % rate is
5%?

If you mean that the payout in 10 years will be $100,000, the PV is

=pv(5%, 10, 0, -100000)

By the way, that can be computed alternatively by:

=100000*(1.05)^(1/10)

But if you mean the FV (future value), as I suspect:

=fv(5%, 10, 0, -100000)

That can be computed alternatively by:

=100000*(1.05)^10

 

[joeu2004]

Errata....

If you mean that the payout in 10 years will be $100,000, the PV is
=pv(5%, 10, 0, -100000)
By the way, that can be computed alternatively by:
=100000*(1.05)^(1/10)

Correction: =100000/1.05^10

 

[PJF]

Sincerest thanks to all for your prompt and effective help. When I sent the
solution to my 30-something daughter, her comment was: "Dad, you rock!"<g>

PJF

 

[Bernie Deitrick]

Sincerest thanks to all for your prompt and effective help. When I sent the

solution to my 30-something daughter, her comment was: "Dad, you rock!"<g>

Computer to connect to the Internet - $1,000
Software for computer - $250
ISP monthly fee - $39.95
MS newsgroups: Free, but painful
"Dad, you rock!" Priceless


Bernie

 

[PJF]

Bernie,

I used to write Excel VBA code like Rachmaninoff performed on the piano.
That was years ago. Haven't even opened Excel in the years since. But I
made copious use of the programming newsgroup whenever I ran into a brick
wall. And, thankfully, someone, if not many, came up with at least one
workable string of code. It often "saved the day." So, although I concur
with everything else you itemized, I have to say that MS newsgroups were far
from painful, they often saved my backside! I couldn't be more grateful.
And yes, my daughter's comment was priceless! She's a real sweetie!

Thanks for your comment. It's most appreciated.