How do I calculate amortization to show months? in Excel New users  
 |  Edit my Profile  |  Help
 
     
   
 
 
 
Maria 6/1/2005 4:58 PM PST
  Question
  I am trying to set up a spread sheet where I can determine the number of
months it will take after investing about $2mil at a 10% rate to see my first
return.
 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
 
 
Niek Otten 6/2/2005 12:44 AM PST
  Answer
  Look in HELP for the NPER function. Don't forget to divide your % by 12 if
you need the number of months.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Maria" <Maria@discussions.microsoft.com> wrote in message
news:8619030B-6582-4C02-AC2D-CCE1D06D0327@microsoft.com...
>I am trying to set up a spread sheet where I can determine the number of
> months it will take after investing about $2mil at a 10% rate to see my
> first
> return.


 
  Was this post helpful to you?  
 
 
  Reply | Print post   TopTop  
 
 
  Return to Microsoft Communities  Notify me of replies