For the life of me, I can't figure out some apparent anomalies in some of the reports in the Tabular Projections.
1. My cash floor and ceiling have been set and they appear properly in the Cash Flow statement. However the ceiling is overstated on the Account Statement for several years, even after funds were moved out to the taxable account per the manual instructions.
2. The Preliminary Ending Cash Balance does not appear to be correctly calculated on the Cash Flow statement per the formula provided.
3. The Transfers In and Out amounts of taxable and tax deferred accounts shown on the Cash Flow statement are not the same amounts shown on Withdrawal report or the Account Statement for the applicable periods
I must be looking at this incorrectly so any education from anyone is appreciated.
@patton525 Sounds like it may be inflated by future dollars? Try setting today's dollars when looking at it and the numbers may be consistent.
@hines202 The headings all say today's dollars. Could it be that some of the cells within the worksheet labeled as Today's dollars are future dollars? The formula for item 2 I mentioned says "This is the starting Cash Account balance plus Net Cash Flow (Total Cash Inflows minus Total Expenses)" These sources come directly off the worksheet but will not tie. This does not seem to be related to future vs today's dollars.
I can share each of these points with you offline if you are interested. Thanks for the pointers.
@patton525 RE: at least your Item 2 -- The Preliminary Ending Cash Balance does not appear to be correctly calculated on the Cash Flow statement per the formula provided...
When I look at my Cash Flow Statement set to Future $, and select a Preliminary Ending Cash Balance underlined value (for Metric MRI) for a given year, the MRI bottom line shows: "Preliminary ending balance (Future $)".
When I look at my Cash Flow Statement set to Today's $, and select the same year Prelim Ending Cash Balance Metric MRI, the MRI bottom line shows: "Preliminary ending balance (Today's $)". That is followed with a note reading: " 1 Interim balance is discounted to Today's $ from start of 2025 until plan start. An extra year of discounting is needed to get the 2025 preliminary ending balance (as of year end 2025) in Today's $ "
The difference between the two Cash Balances (shown in Future $ or Today's $) is exactly the amount defined by my set General Inflation Rate (e.g., 3%), which is the "...extra year of discounting...". This holds true for the duration of the retirement model, year by year.
Do you see something different?
@chrisb Wonderful. That solves my question for item 2. I will re-evaluate the other items. Thank you for sharing the metric MRI details. I was reviewing the excel spreadsheet downloads for calculation purposes and that does not show the metric MRI details!
