ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   monthy payout on an annuity (https://www.excelbanter.com/excel-worksheet-functions/143334-monthy-payout-annuity.html)

pallison

monthy payout on an annuity
 
I'm trying to calculate the monthly payment I would receive on a one time
contribution, fixed growth rate over a fixed period. Darned if I can find an
excel function/formula for it.

Ron Rosenfeld

monthy payout on an annuity
 
On Fri, 18 May 2007 11:14:01 -0700, pallison
wrote:

I'm trying to calculate the monthly payment I would receive on a one time
contribution, fixed growth rate over a fixed period. Darned if I can find an
excel function/formula for it.


Use the PMT function
--ron


All times are GMT +1. The time now is 02:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com