Is anyone knowledgeable about Microsoft Excel?

[Tony_FLADEM]

I need some help.

I am doing a computer assignment for my accounting class and I need to know the Microsoft Excel function for the present value for a single payment in 12 years.

The function included in excel is for the present value of an annuity.

I know how to find the present value, I just need to find it using Excel and I don't have much experience with that program.

Any help is very much appreciated.

[MidwestTransplant]

1. Use th Fx button or from Insert, drop down to Function

[ret5hd]

2. from excel help...

NPV Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

on edit:

and

PV Returns the present value of an investment

[T Roosevelt]

3. From Excel help

PV
See Also

Returns the present value of an investment. The present value is the total amount that a series of future payments is worth now. For example, when you borrow money, the loan amount is the present value to the lender.

Syntax

PV(rate,nper,pmt,fv,type)