Here's how to calculate ... months into the future. This figure is commonly used when companies forecast earnings for one year. Once you know how to format the formula in Excel, you can analyze ...