Expecting my education to continue onto graduate school, lofty goal of earning a Masters Degree to become a C.P.A., I started making custom ‘Excel App’ Workbooks with task specific worksheets. Thinking of it as building my own personnel accounting app, “Stingray’s CPA Excel App“.
Accounting is full of some very complicated advanced algebra formulas, ‘Accounting Time Value of Money‘ CHARTS sparked the idea for the “Stingray’s CPA Excel App“.
C.P.A. level ‘Time Value of Money‘
Present Value PV/ Future Value FV are accounting investment calculations. Very complicated Formulas!
Entering numbers (#’s) in the ‘Yellow Highlighted Unlocked Cells‘.
Embedded formulas autofill in the ‘Orange Highlighted Locked Cells‘ with correct calculations.
I noticed Excel does not always calculate correctly, ‘Calculator Calculation Manually Tool’ for more accurate figures.
Click Link for Free Download: PV FV Time Value of Money $
Actual PV Present Value & FV Future Value Charts
The following are the 6 ‘Charts’ every accountant must use. I made the above ‘Excel App’ to do all these calculations in one place. These are Advanced Algebra equations.
Table 1 FV Future Value
Table 2 PV Present Value
Table 3 FVA Future Value Ordinary Annuity
Table 4 PVA Present Value Ordinary Annuity
Table 5 FVAD Future Value Annuity Due
Table 6 PVAD Present Value Annuity Due
