[Example] Forecast budgeted revenue/expenses for stock market

[taylor.r113y]

Hi Open Office and forum users,

Attached is a completed document that is composed of several worksheets, to budget and forecast revenue and plan expenses, in relation to income from stock market fluctuations or opportunities.

It does not help forecast stock market, unfortunately.
Forecasting stock market is called technicals.
But,
This set of spreadsheets is excellent for people who have autism, and cannot control their anxiety about uncertainty of "what, how, how much, when, where...".
It converts the unknown into known parameters, with minimal input.

This document is abridged, in order so it could be attached as a whole. The original runs until the end of January 2028.

This document is an edited version of an original. The original is a personal and purpose-built document for my life and lifestyle.

I hope users of this document will find its utility rewarding.

Any questions, do not hesitate to ask.

Thanks.

[taylor.r113y]

First worksheet, "Timeline".
Top row is frozen for clarity.
First and second column: date and day.

Column C: bank balance at start of day.

Column D: Trading account at start of day.

Column E: Position size.

Notes on Column E: Position Size will depend on the margin requirements.
Margin requirements for a position, increase, over time.
Because you are assuming stock market size increases over time.
So,
This is adjusted to a separate sheet, "Margin Working",
Which takes its numbers from a separate sheet, "Margins".
I have put these on separate sheets for clarity.

Column F: Number of pts per day.

Notes on Column F: To determine this, I went through several stages and thinking processes.
After some time, I decided that weekly points, at the end of the week, was more suitable.
Most recently, I decided against this.
The separate worksheets "Points Working" and "Points" are for the calculation of this number.

If you prefer total cumulative points at the end of the week, I have another sheet, on another page, a little before this one, which is "Solved".

Column J: Withdrawals are the amount of money going into your bank account. This is taxable, and I have approximated this to 15%, when the pot is over the value of £20,000.

Column L: This equation determines whether supplementary income is necessary, or at what point trading income is sufficient to sustain expenses.

"Holidays" are on a separate worksheet too.

Thanks.