Home / English content / Correctly create budget for spectacle wearers

Correctly create budget for spectacle wearers

The subject of glasses can be found in almost no financial planning, which I think is a bit of a shame, because glasses and the costs for them can be saved very well. And even without a lot of effort.

Glasses are definitely not that common, but that’s why it’s important to keep an eye on these costs. I create budgets for pretty much everything and every situation in life.

Be it for the veterinarian, vacation or school trips for children. So now for the glasses wearers among us.

My situation

Our family is split in half here. Two of us have glasses and two don’t. It is a necessary utensil. The expenses for this therefore belong to the “must” costs.

Every now and then my daughter has to drip. Here, the ophthalmologist determines the prescription. Logically, it can happen that eyesight changes over time.

If this is the case, an optician must be consulted. This is where my budget comes into play.

How do I calculate the budget?

I need all the bills. All bills related to glasses. If they are no longer at home because the organization system has practically messed it up (?), there is the possibility to ask.

As a rule, the opticians should be manageable, which one has been visiting in recent years. Here I just ask about the bills. Most of the time this is absolutely not a problem. Unless the employee didn’t have coffee or anything like that.

Collect data and numbers

A nice list of dates and amounts is created. With us it looks something like this:


March 19, 2018 - € 49.76
April 1, 2019 - € 30.00


04/25/2013 - € 349.00
04/25/2013 - € 75.00
April 18, 2017 - € 129.00
10/27/2018 - € 41.70
04.08.2018 - € 55.00
April 9, 2019 - € 40.00

The evaluation of the numbers

As a striking example, I am now calculating the budget for women, since some figures have to be considered here. Here I use the day function in Excel to display the elapsed days. From the beginning to the end.

= DAYS (date of delivery; date of departure) is the Excel formula. In the first case, the target date is April 9th, 2019 and the starting date is April 25th, 2013. So the past is 2175 days.

After the days are known, I calculate the average of all payments. You can do this with the formula -> = mean (number1, number2, ..). Monsenior Excel throws me the value of € 114.95 at this point.

Ultimately, this means that an average of € 114.95 will be charged if something has to be spent. After these 2 values ​​are known, the days and the mean, the rest is a matter of form.

There were a total of 6 invoices in the 2175 days. Now I convert the 2175 days to months, which gives 72.5.

Things are coming to an end. The months divided by the number of bills gives round about 12.08.

Short interim balance: Every 12 months there is an invoice for an average of € 114.95. Logically, now the last invoice comes …

Finally, I only have to divide the amount of € 114.95 by the 12.08 months and that equates to € 9.52. So I have to spend € 9.52 a month to pay for the glasses.


The calculation itself is not really difficult and, in the end, logically understandable. It is pretty obvious that it makes sense to put money back for glasses.

Generally you are never 100% safe, but you can prepare yourself. And that counts. It makes a significant difference whether I need new glasses after 2 years and pay just under € 240 or only € 10 a month.

I pay the € 240 in one go anyway, but the monthly savings definitely hurt me less than a one-off payment. It shouldn’t just be me.


Dieser Blog ist mein persönlicher Beitrag zur finanzieller Bildung in Deutschland. Ich versuche mit meinen Texten und Beiträgen in erster Linie meine eigene Situation aufzuzeigen. Mit Witz und Charme gepaart bringe ich außerdem das Thema Geld und dessen Verwaltung auf dein Smartphone und deinen PC. Was mache ich? Wie mache ich es? Wozu mache ich es? Das sind die Kernthemen dieses Blogs.

Check Also

Minimalism on the bookshelf

Until recently, the bookshelf looked like a disaster with us. Completed until it stops. In …

Was ist eine Sondertilgung?

Was ist eine Sondertilgung wirst du dich vermutlich schon einmal gefragt haben. Jeder Kredit wird …

Betriebliche Altersvorsorge - Das Fazit

Wohin geht mein Geld bei einer BAV?

Betriebliche Altersvorsorge ist ein Baustein, welcher grundsätzlich Sinn macht. Viele Unternehmen bieten diese Möglichkeit mittlerweile …

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert.