Ubuntu
openoffice.org package

Need Formula For Annuity Calculation in OpenOffice

Asked by Reid Nunn

It has to be in there, but I could not find it, even after showing results for Annuity search in open office spreadsheet.

Facts. Lump sum deposit, fixed interest rate, monthly payout, 20 years

Thanks

Question information

Language:
English Edit question
Status:
Answered
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Tony Pursell (ajpursell) said : 		#1

Hi Reid

I think the function you want is PMT. Call up the Function Wizard, select Category 'Financial', scroll down the list to PMT. To get more information on a Function, click Help while it is highlighted.

Tony

PS If this answers your question, please mark it as Solved

Can you help with this problem?

Provide an answer of your own, or ask Reid Nunn for more information if necessary.

To post a message you must log in.