Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 14
Default calculate loan term for excel 2003

Is there a formula to calculate the term in months without using a termplete?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,440
Default calculate loan term for excel 2003

Look in Help for the NPER() function

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"CHARI" wrote in message
...
Is there a formula to calculate the term in months without using a
termplete?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 418
Default calculate loan term for excel 2003

"CHARI" wrote:
Is there a formula to calculate the term in months
without using a termplete?


Well, the simple answer is: use NPER(). But that comes with lots of
caveats. it would be helpful to know what data you have and why you are
trying to compute the loan term in months.

Consider a loan of $10,000 at 5% with monthly payments of $450. Ostensibly,
you would compute the number of months with:

=nper(5%/12,450,-10000)

Two things to note: (a) the "rate" argument is __monthly__ rate; and (b)
the "pmt" and "pv" arguments must have opposite signs (one negative, one
positive).

But note that with those numbers, NPER returns about 23.37, not an integer
number of months.

Ostensibly, you might use INT, ROUNDUP, or ROUND to compute the integral
number of months. But which you should use depends on lender policy. And in
either case, it is likely to change the amount of the last payment.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to calculate average loan period of a 5 year loan Jayant Excel Worksheet Functions 2 March 26th 08 12:47 AM
using excel to calculate loan amount. mercury Excel Worksheet Functions 1 June 26th 06 08:16 PM
how do i calculate age in term of years, months, days shan Excel Worksheet Functions 1 March 15th 06 11:21 AM
how do i calculate age in term of years, months, days shan Excel Worksheet Functions 3 March 15th 06 06:58 AM
Calculate Term Anita Excel Worksheet Functions 3 December 21st 05 05:27 AM


All times are GMT +1. The time now is 06:33 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"