When you give your monthly mortgage payment to a lender they do not put it under a mattress. Your lender lends it out again each month. This is called deemed reinvestment. The M2PRO software has a feature that allows the SPREADSHEET to calculate the total of what regular deposits will accumulate to over a given amount of time, when the payments are set to zero in the speadsheet. You are actually performing a Present Value Future Value calculation in an expanded grid format. A monthly example is shown; however a weekly or biweekly scenario can also be calculated. Any of the following payment or deposit frequencies are available. 1,2,4,12,24,26 & 52. The type of compounding and the deposit frequency dramatically influence the accumulation amount for your retirement.

Assume you want to invest $367 per month for the next 25 years and you want a 15% annual compounded growth. What would monthly deposits of $367 accumulate to in 25 years? Answer: $999,943.42 almost one million dollars.

The solution is as follows. Think of it as a loan, then change your mind! First calculate the Principal that could be borrowed by making monthly payments of $367 for the next 25 years utilizing annual compounding. The calculator will automatically calculate a Principal of $30,375.92 under those conditions.

In essence what you are using is the 3 out of 4 feature or the calculation of the missing value feature of the M2PRO CALCULATOR.

You then click on the spreadsheet and change all the payments in the payment column to zero up to the 300th payment and the accumulation of $999,943.42 is immediately shown on the 300th payment line (highlighted in yellow).