PRC 2025 Gold Excel user here. Having a problem understanding how a calculation in the Expense projection is derived:
1) I have one car and a mortgage entered on the Expenses/Property page. The "Personal Property Summary Table" (PPST) at the bottom of the Property page makes sense to me, and I can manually calculate and understand how the data is derived
2) Then, under Tabular Projections/Expense view, I look at the "Expenses for Personal Property" (EPP) column which I assume is related to the "Annual Expenses" (AE) column in the PPST from the Property page. The AE and EPP of the first year in the Expense view match, but from then on they do not, with the figures in the EPP column generally start declining/level out and no longer correlate with what I see on the AE.
I am obviously missing something in where the data/calculation in the EPP column is coming from but there is no explanation of it in the manual. Any help appreciated.
Think I solved this for myself. It appears the PPST table is in FV. Changing the Expense View to FV makes it line up.
