 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008formula for 2% annual sales increases
need for projected csah flow report.thanks Not much info to go on, but one way: B1: = A1 * 1.02 > need for projected csah flow report.thanks Thanks.Can you advise how to apply the 2% increase to each succeeding year as a formula ?Thanks. > Not much info to go on, but one way: > > B1: = A1 * 1.02 > > > need for projected csah flow report.thanks Yes, just keep mulitplying the previous year by 1.02. If you want to calculate multiple years in one formula, you want the future value function. PV=Starting Cash Flow IntRate=2% Nper=Number of years Regards, Fred. > Thanks.Can you advise how to apply the 2% increase to each succeeding year > as [quoted text clipped - 5 lines] >> >> > need for projected csah flow report.thanks Thanks for the assist. > Yes, just keep mulitplying the previous year by 1.02. > [quoted text clipped - 16 lines] > >> > >> > need for projected csah flow report.thanks
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.