I am looking for the correct formula to calculate sales run rate for a 13 period fiscal year in Excel? Can anyone help.
I am looking for the correct formula to calculate sales run rate for a 13 period fiscal year in Excel? Can anyone help.
I do not thing there is a template for the same. Quite as simple as that is not, but it is obvious that such figures should be treated with caution. Because very few companies over the years have reported steady business, but to live with strong seasonal fluctuations. Intelligent methods can already take into account such variables but realistic. However, the bill largely depends on how the raw data are obtained and what kind of indicators are chosen for the operating profit (in terms of capital costs, depreciation and taxes, etc.)
I do not think there is a any kind of template for the same. The process looks a bit complicated to perform.
Bookmarks