Reply
 
Thread Tools Display Modes
  #1   Report Post  
Sochinski
 
Posts: n/a
Default Word 2000 form field calculation HELP!!

I am creating a writable form which includes the ability to autopopulate a
given field with a loans monthly payment amount. the Formula is:

Monthly payment = P r(1+r)^n / (1+r)^n-1

P is Principle(loan amount)
r is percentage rate
n is term of loan (months)

I seem to be having problems with word calculating to the power of n
I am doing this with text fields where the user supplies the loan amount (P)
and the term in years (ie: 15 or 30 years) and the annual percentage rate.
I want the monthly payment to be calculated.
What am i doing wrong????!!!!
Please help me.

Steve

  #2   Report Post  
Cindy M -WordMVP-
 
Posts: n/a
Default

Hi Sochinski,

Could you give us some examples, please, so that we can see what Word is
doing? (Most Wordies aren't accounting/financial experts, oddly enough; those
kind of people tend to work with Excel.) Also, which version of Word is
involved?

I am creating a writable form which includes the ability to autopopulate a
given field with a loans monthly payment amount. the Formula is:

Monthly payment = P r(1+r)^n / (1+r)^n-1

P is Principle(loan amount)
r is percentage rate
n is term of loan (months)

I seem to be having problems with word calculating to the power of n
I am doing this with text fields where the user supplies the loan amount (P)
and the term in years (ie: 15 or 30 years) and the annual percentage rate.
I want the monthly payment to be calculated.


Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

  #3   Report Post  
Greg
 
Posts: n/a
Default

Steve,

With your formula, I think you would have to use something like:

{ =(P*r)*((1+r)^n)/((1+r)^n-1) }

Rember r is going to have to be converted from APR. I.e., 6% will need
to be changed to .06/12 or .005.
You could also use the shorter formula:

{ =P*r/(1-(1+r)^-360) }

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
In typing dates in Word, i.e. "January 12" how do you keep the "1. Carol Microsoft Word Help 2 January 12th 05 09:09 PM
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 11:50 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 05:12 PM
macro in word js Microsoft Word Help 1 December 28th 04 04:01 AM
Desperate Word 2000 Index/SEQ field prob Adrienne Microsoft Word Help 1 December 22nd 04 05:25 PM


All times are GMT +1. The time now is 12:34 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"