This study wouldn’t be so overly alarming except for the fact that the respondents were just five years away from retirement."
A dismal report, by any standard. Nearly two-thirds that will be out of money after one year and one-third had not even determined their potential living expenses.
It's clear that very few have any idea how much money they should have available when they do retire. Blindfolded and walking in the direction of a known cliff. It may be too late for the 64% group, though they may need to consider working until age 70 and receive a Delayed Retirement Credit from their Social Security Retirement.
This series of posts will focus on those that are more than five years from retirement and still have a chance of achieving a measure of retirement security. Employers should provide these calculations for their employees as part of their ongoing Employee Communications. Every single employee.
Younicycle includes an online database component & is built on PostgreSQL, which includes an SQL procedural language (PL/pgSQL) for creating Functions that can calculate the growth of money and use of money. We have an built-in Editor that allows these Functions to be created online within an account. The first Function will calculate the Future Value of a series of payments (savings). At its simplest level, there are three factors:
- How much you will save per period. In this case, let's assume the period is 'per year'.
- How many periods you will save (how many years).
- How fast will will your money grow? (interest rate per year).
- A Table
- A pgSQL Function
CREATE OR REPLACE FUNCTION fvtestpmt(payment double precision, interestRate double precision, periods double precision)
RETURNS double precision AS
return payment*(pow(1+interestRate, periods)-1)/interestRate;
LANGUAGE plpgsql IMMUTABLE;
The image below shows how to create this simple, but powerful Function from within Younicycle.
But what can a Content Developer or a Human Resources Department do with this Function? It still appears to be useless.
In the next Post, useless will start to become useful as I'll show you how to create a Table to store Employee values and generate a Query that will apply this function to those values.