Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to figure out how to use functions in Excel to calculate an
annuity from a present amount. Do you happen to know how I would do this? For Example: Present Amount = $100,000 Period = 30 years (annual payments at beginning of each year) Interest Rate = 6% / year Annual Amount of Withdrawel Available = ? Value at end of 30yr period = $0 Thank for your assistance, James Richey |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Present Value of a Continuously Compounded Annuity Payment | Excel Worksheet Functions | |||
Present value of individual uneven payments | Excel Discussion (Misc queries) | |||
How to calculate the accumulated payments from an annuity at yr 10 | Excel Worksheet Functions | |||
How do I calculate the accumulated payments from an annuity at yr | New Users to Excel | |||
How can I figure present value of a stream of payments? | New Users to Excel |