Profit and Loss Spreadsheet

May Va's annual itemised monthly Profit & Loss forecast showing fixed and variable costs set against income.


Profit and Loss Forecast (2019)

Simple moving average

The simplest form of a moving average, appropriately known as a simple moving average (SMA), is calculated by taking the arithmetic mean of a given set of values. In other words, a set of numbers, or prices in the case of financial instruments, are added together and then divided by the number of prices in the set. For example, to calculate a basic 10-day moving average on - May Va's Profit & Loss Forecast - you would add up the closing prices from the past 10 days and then divide the result by 10

Time series data Example: Ratio analysis

Realization of the fact that "Time is Money" in business activities, the dynamic decision technologies presented here, have been a necessary tool for applying to a wide range of managerial decisions successfully where time and money are directly related. In making strategic decisions under uncertainty, we all make forecasts. We may not think that we are forecasting, but our choices will be directed by our anticipation of results of our actions or inactions.

Indecision and delays are the parents of failure. This site is intended to help managers and administrators do a better job of anticipating, and hence a better job of managing uncertainty, by using effective forecasting and other predictive techniques.