Have you ever struggled with modifying your AFP document while on the go? Well, DocHub has an excellent solution for that! Access this cloud editor from any internet-connected device. It allows users to Revise formula in AFP files quickly and anytime needed.
DocHub will surprise you with what it offers. It has robust functionality to make whatever updates you want to your paperwork. And its interface is so straightforward that the whole process from beginning to end will take you only a few clicks.
When you complete modifying and sharing, you can save your updated AFP document on your device or to the cloud as it is or with an Audit Trail that includes all alterations applied. Also, you can save your paperwork in its initial version or turn it into a multi-use template - complete any document management task from anyplace with DocHub. Sign up today!
foreign fairhurst and what Id like to take you through today is how to build a rolling forecast model now I know theres lots of fancy software out there that will do it for you but Im going to show you a method just using plain old standard Excel standard Excel formulas and maybe just a little bit of formatting so its going to look like this when we finished it so its just going to be a chart so we can see our actual and our forecast we can put in our assumptions that go in here and its going to roll out forward at any point in time it will roll forward for 12 months so lets get started so Ive set it up for you like this so weve got our start date here so our start date is based on this number here and then everything rolls forward from there so we say a current month plus 365. weve also set this up with actual and budget so Ive used some if to say if its less than or equal to the current month give me actual otherwise budget and Ive also used some Flags here so flags are