Because social security is cola adjusted over the years, is the NPV effectively the sum of all years collected? I'm using this to calculate total assets for portfolio asset allocation.
Ask a Question
Use this Question Forum to ask questions about how the software works, how to model different "what if" cases, or other user-related question. If you have a support issue (something seems to be wrong with the software) then please create a support ticket. How to browse this forum: SCROLL and click titles to read complete question/answer, use the FILTERS below, pick from TOPICS on the list at right (think of them as folders), use the SEARCH BOX (see also "advanced search" when you use it), choose from RECENT COMMENTS at the right below.
Registered users may create a question here.
On page 34 of the User Manual is says "Thus, we have a spreadsheet you can use [linked here] to get the data based on readily available numbers from Morningstar, Yahoo, or your fund prospectus." The link doesn't work (kicks me out to page that denies access whether I'm logged on or not.
In the year 1, 2015, on the Retirement Account report the displayed retirement income is calculated using the real rate of return but the displayed retirement assets include retirement income that has been calculated using the nominal rate of return.
When I enter $450000 for value of home and $420,000 for value of home it show my equity as $450,000. I enter the mortgage information but it goes away when I go to another section of the program my Loan Balance is $290,000 so my equity should be $160,000.00
I'm wondering what the correct way to enter muni bonds. I have them as a bond and cd under regular assets and have also indicated the percent of regular assets in municipal bonds. Is the interest I receive based on the rate and inflation percents i enter in regular assets?
In my model, asset income savings (in the 'current saving' section of the report) is greater than asset income (in the 'total income' section of the report) by about 10%. Seems counter-intuitive, why is that?
I posted a comment in the original thread, and then realized it might be missed because someone would have to search for that thread in order to see the new comment. So I thought I'd repeat my post here...
I must be missing something obvious, but how do model out the scenario where we do a home addition/remodel in 2016 and finance it using an existing home equity line?
Not that you asked but in my first few days, here's a few things I've thought of...
I have created a simple Jack and Sally Sprat planner file to experiment with the impacts of changes on net worth, spending, returns, etc.
I set inflation to zero for the base case and kept returns at 6%; not real world but a clean starting point;
If I have a lump sum business payout that will allow me to pay off my mortgage five years from now, how can I accurately reflect that in the software?
Two more questions:
1. We receive an annual payout from a business; it's not income in the traditional sense that one of us is employed and earns it but it is an income stream. What's the best way to represent this in ESP? I've put this in as an annuity under "Special Receipts"
We have two policiies. My wife's policy is a fully funded whole life policy worth $200K; she contributes nothing to it and it will pay to the estate when she dies. If I show this as life insurance, do I show it as a cash value of $200k?
How do you express/input after tax funds invested in a time locked investment which is sheltered from all taxes until it's withdrawn? I currently have it "other assets" but I fear that those funds are assumed to be subject to taxation during their tenure.
When we check for updates to the software we get an error message. The screen capture of the message we get is attached.
Can you help me understand what nominal rates of return control in the assumptions tab? It doesn't seem to be the total rate of return, but the 6% default value makes me think it isn't income generation.
While I understand the purpose/suggestion of life insurance, can I remove it from my annual cost? Perhaps the SW should just suggest the amount and the user can add the specific cost. Having the amount in the reporting is just confusing.
Let’s assume a primary, vacation and a weekend house. I would like to setup ESPlanner Plus to model selling any of them in a specific year. I’ve set these properties in the Real Estate screen however where does the cost show up? Does it lower Discretionary Spending?
I've recently received a cash inheritance which I entered in special Receipts as non-taxable. It is invested at a low interest rate but the amount is large enough that having it earn zero interest as a special receipt entry has an affect, albeit small, on my SOL and taxes.