#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default payback period

is there a formula to which i can type in a cell that well analyse
information given in the cells above to find out how long a project would
take before it is paid back???

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,624
Default payback period

Take a look at the NPER() function in XL Help.

In article ,
Kake wrote:

is there a formula to which i can type in a cell that well analyse
information given in the cells above to find out how long a project would
take before it is paid back???

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default payback period


sorry but that formula was not much help as i was not given a interest
standard rate to use however look in the pay back period i have posted what
one of the sections is

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
Determine payback period to reach fixed dollar amount. JP Excel Worksheet Functions 1 May 8th 07 09:16 PM
Payback Period rk0909 Excel Discussion (Misc queries) 1 April 12th 07 04:27 PM
Payback Period Plum Excel Discussion (Misc queries) 1 October 21st 06 10:25 AM
How to create data tables and is there a payback period function Austen T Excel Worksheet Functions 0 July 18th 06 05:08 PM
Period to Period percentage change? cs120 Excel Discussion (Misc queries) 1 September 18th 05 12:05 PM


All times are GMT +1. The time now is 07:13 AM.

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

About Us

"It's about Microsoft Excel"