Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am looking for the right formula to use for the following
scenario. If I had $500,000 in an account at 5% interest per year over a 15 year period and wanted the ending balance to be $250,000, how much can I draw out per month and meet the criteria of still having $250,000 at the end. I used PPMT but the results don't look correct to me. Thanks, Steve |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Financial Modeling | Excel Discussion (Misc queries) | |||
Financial functions | Excel Worksheet Functions | |||
financial functions dll | Excel Worksheet Functions | |||
Excel question for financial model | Excel Discussion (Misc queries) | |||
Question about financial calculation PMT | Excel Worksheet Functions |