Wednesday, March 30, 2022

Queen of France

Retirements 55-64 w-Pre Paids & "Dividend Helper"

windsor castle
Windsor Castle, from my ancestors.

Retirement: Ecological & also an Economic Booster

An xlsx sheet for New Governments (large or small), or revamping older ones, towards a "Pre-Paid", Social Retirement System. Also included is... a Dividend Helper to assign specific companies & estimate one's monthly income.

Social Retirement 55*-64

There's a quick calc, with many variables possible.
Results are: a government with an exacting social payment, the same for all.
Which allows for retirement at 64, & Pre-Paid beginning (compounded int. since a child) as early as 2039. Prior 2039, social taxation continues for workers, with a flat rate income tax approx. 12.5%
Pre-Paid meaning: the social system pays for the retirees every yr automatically, without any further social taxations required. Citizens would no longer be taxed for retirement, during their lifetimes.
The accrued money works instead of over-working the people, all due to Dividends.
*55 retiree age group means, the Pre-Paid system would be far later, in 2065.
Further Pre-Paid Result: is less impact on the environment due to less work & stress for retirement savings.
(Property tax-free, with only a tax on property sales of approx. 12.5%, this plan is great for tax havens, and seceding, yet allied regions.)
Vlog Link Xlsx Link

Dividend Helper!

This spreadsheet is very basic & easy to use.
It tallies up the dividend income of up to 14 stocks:
1) Income "Monthly" or "Quarterly"
2) Exact #of shares to purchase.
3) Interest Ranking higher to lower.
4) Incl. Capital gains tax % reduction.
5) Final $ Amount Held in Shares
All-in-all it's a spot on assessment of monthly income & I recommend updating the stock values occasionally to keep current with valuations.

For the 14 Companies:

Fill in the gold boxes:
Stock Name
Price per Share
Annual Dividend: Interest Rate %
Annual Dividend: $ Amount

The Invested Amount

Then for each, if $1000 is to be invested,
enter "1" to the right of the $1000 column
or for higher amounts: enter "2" to the left of its associated column.
The amount columns are shared for all 14 stocks,
& the main amount to spend (or spent) per column can be edited.

Modifying The Investment Columns

The current columns:
1000, 2000, 10000, 50000, 100000
can be modified to support investment expenditures higher than $1000. ie.
1000, 5000, 20000, 80000, 220000
Variations of the 14 stocks, are then used:
1000 (STOCK-Q)
..................5000 (STOCK-L)
and so forth. (don't ask, but currency formatting $'s can't be listed, only numbers)

The "All is at Risk" Statement

The companies do not stay at the same % rate, the rates change, and companies raise & lower in share value.

Finding Dividend Stocks

The examples listed are merely examples, but were listed & available at the given prices in 2022-03.
Please don't go with oil and gas companies, try to be "ecologically-minded" also.
& There are stock screeners online with brokerages & research sites,
to help make further company determinations.

Dividend Helper: xlsx Dividend Helper