Formula Used
The calculator models one periodic cycle with this Fourier expansion:
f(x) = a0 / 2 + Σ[an cos(2πnx / T) + bn sin(2πnx / T)]
a0 = (2 / N) Σ yj
an = (2 / N) Σ yj cos(2πnj / N)
bn = (2 / N) Σ yj sin(2πnj / N)
Here, T is the full period, N is the number of samples, and n is the harmonic number. Optional detrending subtracts a linear trend before computing the periodic coefficients.
How to Use This Calculator
- Enter one full cycle of equally spaced financial values.
- Set the cycle length, such as 12 for monthly data.
- Choose how many harmonics you want to include.
- Enable detrending when your values rise or fall strongly.
- Press the calculate button to view coefficients and forecasts.
- Use the CSV or PDF button to save your result.
Example Data Table
| Month | Revenue | Possible cycle note |
|---|---|---|
| 1 | $120,000 | Start of cycle |
| 2 | $135,000 | Early growth |
| 3 | $148,000 | Demand improving |
| 4 | $162,000 | Mid-cycle lift |
| 5 | $176,000 | High season starts |
| 6 | $190,000 | Strong activity |
| 7 | $210,000 | Peak demand |
| 8 | $198,000 | Peak fades |
| 9 | $182,000 | Cooling period |
| 10 | $168,000 | Lower activity |
| 11 | $152,000 | Late-cycle decline |
| 12 | $140,000 | Cycle resets |
Fourier Analysis for Finance
Financial data often moves in repeating waves. Monthly sales rise near holidays. Cash flow can fall after large billing cycles. Returns may show weak seasonal pressure. A Fourier series helps break those movements into simple sine and cosine waves. Each wave is called a harmonic. The first harmonic shows the broadest cycle. Higher harmonics add sharper turns and smaller details.
Why This Calculator Helps
This calculator uses your periodic finance values as one full cycle. The values can be monthly revenue, weekly demand, quarterly margin, or portfolio return changes. It estimates the average level, harmonic coefficients, amplitude, phase, and fitted value. The chart then compares actual data with the reconstructed curve. This makes hidden seasonality easier to inspect.
Financial Planning Uses
A finance team can use the expansion to study cash rhythm. A retailer can estimate seasonal peaks. A subscription firm can compare renewal waves. An analyst can check whether a pattern is driven by one main cycle or several smaller cycles. The tool also creates future fitted points. These are not guaranteed predictions. They are structured cycle projections based on the supplied period.
Reading the Results
The a coefficient controls cosine strength. The b coefficient controls sine strength. Amplitude shows the size of each harmonic. Phase shows where the wave shifts inside the cycle. A large first harmonic means the pattern is smooth and broad. Strong higher harmonics mean the data has sharper jumps.
Better Inputs Give Better Signals
Use values from a stable period. Keep spacing equal between points. Do not mix weekly and monthly observations. Remove one-time events when possible. For growing data, try the detrend option. It separates a straight growth line from the repeating wave. This helps the cycle become clearer.
Practical Limits
Fourier expansion is descriptive. It does not replace risk review, valuation, or market research. Sudden shocks can break old cycles. Use the output as a planning guide. Compare it with business context, budgets, and recent market changes. The best results come from clean data and realistic judgment. The calculator is also useful for teaching seasonality, because each harmonic can be viewed, compared, exported, and explained without complex setup.
FAQs
1. What does this calculator measure?
It measures the harmonic structure of periodic financial data. It estimates average level, sine coefficients, cosine coefficients, amplitudes, phases, fitted values, and future cycle points from your supplied series.
2. Can I use monthly revenue data?
Yes. Monthly revenue is a strong use case. Enter 12 equally spaced values and set the period to 12. The output will show annual seasonality through harmonic waves.
3. What is a harmonic?
A harmonic is a repeating wave inside the full cycle. The first harmonic covers the broadest wave. Higher harmonics capture sharper seasonal turns and smaller repeating movements.
4. Should I use detrending?
Use detrending when the series rises or falls strongly over time. It removes a straight trend before finding the repeating pattern, then adds that trend back to fitted values.
5. Are the forecasts guaranteed?
No. The forecast points are cycle projections based on the past period. They should support planning, not replace financial judgment, risk checks, or market research.
6. How many harmonics should I choose?
Start with three to six harmonics for 12 monthly values. More harmonics may fit details, but too many can overfit noise and make forecasts less useful.
7. What does amplitude mean?
Amplitude shows the strength of a harmonic. A larger amplitude means that harmonic has greater influence on the financial cycle and contributes more visible wave movement.
8. Can I export the results?
Yes. Use the CSV button for spreadsheet work. Use the PDF button for a quick report containing summary metrics, coefficient rows, and forecast rows.