Non-investing private finance points together with insurance coverage, credit score, actual property, taxes, employment and authorized points equivalent to trusts and wills.
Re: Retiree Portfolio Model
I entered 0.04.Bigfoot48, I’ll reset and retry, I’m a small fish within the BH pond so it’s fairly simple to begin over. Killer mannequin, btw, I ought to have led my first submit on this thread with my gratitude and thanks!
Thanks! Hope you discover it helpful. Enter 4.0 within the Return Charges part, though .04 shall be transformed to 4.0.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
- Posts: 35
- Joined: Wed Mar 19, 2014 9:48 pm
Re: Retiree Portfolio Model
Post
by CaringInvestor »
I am 61 and already receiving social safety (SSDI) since I’m disabled. Can I take advantage of the Social Safety revenue part or ought to I enter present SSDI advantages underneath “Different Earnings” utilizing my present age in the beginning age?
I even have a inherited IRA (acquired in 2020) that I’ve chosen the choice to make use of the IRS single life desk for RMDs. There’s an IRS exception for disabled individuals from the ten yr distribution rule, however I used to be required to start RMDs in 2020. How ought to I enter this inherited IRA?
Rob
Re: Retiree Portfolio Model
CaringInvestor wrote: ↑Wed Could 22, 2024 12:07 am
Thanks for creating this software and on your dedication to updating the spreadsheet and answering questions.
I am 61 and already receiving social safety (SSDI) since I’m disabled. Can I take advantage of the Social Safety revenue part or ought to I enter present SSDI advantages underneath “Different Earnings” utilizing my present age in the beginning age?I even have a inherited IRA (acquired in 2020) that I’ve chosen the choice to make use of the IRS single life desk for RMDs. There’s an IRS exception for disabled individuals from the ten yr distribution rule, however I used to be required to start RMDs in 2020. How ought to I enter this inherited IRA?
Rob
Glad you might be discovering RPM helpful. RPM customers could have some strategies on your state of affairs however I feel it’s best to attempt to use the SS part, though it might not present your present yr as beginning yr is 62. You could have to enter the prevailing steadiness of the IRA and settle for the ten yr time period as being a bit inaccurate. Use the guide yearly enter strains on the Particulars web page if obligatory to regulate the calculated quantities.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
- Posts: 48
- Joined: Mon Could 20, 2019 7:03 pm
Re: Retiree Portfolio Model
Post
by RangeleyLake »
BigFoot48 wrote: ↑Wed Could 22, 2024 8:12 amCaringInvestor wrote: ↑Wed Could 22, 2024 12:07 am
Thanks for creating this software and on your dedication to updating the spreadsheet and answering questions.
I am 61 and already receiving social safety (SSDI) since I’m disabled. Can I take advantage of the Social Safety revenue part or ought to I enter present SSDI advantages underneath “Different Earnings” utilizing my present age in the beginning age?I even have a inherited IRA (acquired in 2020) that I’ve chosen the choice to make use of the IRS single life desk for RMDs. There’s an IRS exception for disabled individuals from the ten yr distribution rule, however I used to be required to start RMDs in 2020. How ought to I enter this inherited IRA?
Rob
Glad you might be discovering RPM helpful. RPM customers could have some strategies on your state of affairs however I feel it’s best to attempt to use the SS part, though it might not present your present yr as beginning yr is 62. You could have to enter the prevailing steadiness of the IRA and settle for the ten yr time period as being a bit inaccurate. Use the guide yearly enter strains on the Particulars web page if obligatory to regulate the calculated quantities.
Hello Rob
My partner was accumulating SSDI once we first began utilizing RPM in 2018. Our expertise with SSDI, was to make use of the Earnings Sources part and used the opposite revenue bullet till you can begin accumulating SS advantages (which is age 62). Once we tried so as to add it to the SS part, RPM gave us an error message as a result of my partner age at the moment (she was 61) was not of age to begin SS Profit.
The one concern there was with this technique, it thought of all the SSDI profit as taxable when in actuality it wasn’t. It did give us an excellent thought of the place we had been financially. We did needless to say the taxes on this Earnings was exaggerated. Due to the way in which we had been utilizing RPM, it did assist us tremendously in figuring out if I’d retire early which I in the end did in 2018.
Rangeley Lake
RangeleyLake
- Posts: 35
- Joined: Wed Mar 19, 2014 9:48 pm
Re: Retiree Portfolio Model
Post
by CaringInvestor »
I am discovering that setting the present age to 62 (precise age 61) is eradicating warnings and permitting entry of knowledge. I do not assume one yr older is just not going to make an enormous distinction in forecasting an estimate. I will keep watch over the tax of social safety advantages.
Thanks
- Posts: 48
- Joined: Mon Could 20, 2019 7:03 pm
Re: Retiree Portfolio Model
Post
by RangeleyLake »
CaringInvestor wrote: ↑Wed Could 22, 2024 1:06 pm
I am discovering that setting the present age to 62 (precise age 61) is eradicating warnings and permitting entry of knowledge. I do not assume one yr older is just not going to make an enormous distinction in forecasting an estimate. I will keep watch over the tax of social safety advantages.
Thanks
That was a greater possibility than what we did. In case you are setting your age to 62 and utilizing the SS part for the SSDI advantages, the quantity of taxes on the advantages needs to be all set
RangeleyLake
Re: Retiree Portfolio Model
RangeleyLake wrote: ↑Wed Could 22, 2024 4:46 pmCaringInvestor wrote: ↑Wed Could 22, 2024 1:06 pm
I am discovering that setting the present age to 62 (precise age 61) is eradicating warnings and permitting entry of knowledge. I do not assume one yr older is just not going to make an enormous distinction in forecasting an estimate. I will keep watch over the tax of social safety advantages.
ThanksThat was a greater possibility than what we did. In case you are setting your age to 62 and utilizing the SS part for the SSDI advantages, the quantity of taxes on the advantages needs to be all set
A method I’ve used to mannequin revenue that is not taxable is to make the most of part 7 (future occasions): enter the quantity in line “money” line, ‘y’ within the “embody in portfolio?” line, and age within the “age when occasion happens” line.
John C. Bogle: “By no means confuse genius with luck and a bull market”.
Re: Retiree Portfolio Model
I bought a message right now from DropBox that the RPM mannequin had been up to date right now. I didn’t do that so I’ve deleted the present model and put in the present backup as 24.1. Nobody as greatest I do know has entry to the RPM account and positively didn’t contact me. I’ve modified my safety information on Dropbox.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
Re: Retiree Portfolio Model
Obtain if downloaded earlier right now (hyperlink replace 5/29 5:00): https://dl.dropbox.com/scl/fi/eyab9fojk … 3rtwl&dl=1
How this individual bought entry to the recordsdata I have no idea however he has been eliminated and I’ll often examine to insure he would not come again. Password to Dropbox was modified.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
- Posts: 16
- Joined: Wed Jun 05, 2024 1:47 pm
Re: Retiree Portfolio Model
Post
by boglebogle2020 »
Let me know the best way to overcome this.
Regards,
Gerry
Re: Retiree Portfolio Model
boglebogle2020 wrote: ↑Wed Jun 05, 2024 2:49 pm
After I run the RPM file, Excel offers following message “A probably harmful macro has been blocked” and doesn’t permit me to run.Let me know the best way to overcome this.
On the backside of the primary submit in Case Study Spreadsheet updates there’s a dialogue about this – in all probability relevant to the RPM spreadsheet additionally.
Re: Retiree Portfolio Model
boglebogle2020 wrote: ↑Wed Jun 05, 2024 2:49 pm
After I run the RPM file, Excel offers following message “A probably harmful macro has been blocked” and doesn’t permit me to run.Let me know the best way to overcome this.
Regards,
Gerry
Did you obtain the newest model 24.1 utilizing the hyperlink in submit 1 (or above)? Have been you coming into a quantity when this message appeared?
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
- Posts: 16
- Joined: Wed Jun 05, 2024 1:47 pm
Re: Retiree Portfolio Model
Post
by boglebogle2020 »
After obtain, when I attempt to activate, Within the prime part of Excel I get this message on a Pink banner. (Unsure the best way to connect a JPG file to this message different clever I’d have uploaded the picture)
The Excel banner says: “SECURITY RISK: Microsoft has blocked macros from operating as a result of supply of the file is untrusted”. There’s a “Be taught Extra” field adjoining to the above message and after I click on on it, I get message per hyperlink under
https://support.microsoft.com/en-us/top … 5ed6024216
Let me know
Re: Retiree Portfolio Model
All macros manipulate information inside the open excel file. One macro that hundreds Setup entries from one other (earlier) RPM mannequin accesses the information inside that mannequin. No macro accesses the web or customers laptop system. Macros will be considered utilizing the Edit perform to substantiate this.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
Re: Retiree Portfolio Model
boglebogle2020 wrote: ↑Wed Jun 05, 2024 2:49 pm
After I run the RPM file, Excel offers following message “A probably harmful macro has been blocked” and doesn’t permit me to run.Let me know the best way to overcome this.
Regards,
Gerry
That is a Microsoft boilerplate message for finish customers {that a} macro is trying to run. There are a number of methods so that you can deal with this:
- Do not run the macro. Do issues manually.
- If you load the spreadsheet it should acknowledge that there are macros and ask you if you wish to allow macros in a message bar on the prime. If you wish to use the macros THIS ONE TIME, then click on to “Allow Content material”.
- In the event you belief the spreadsheet and the macros, you’ll be able to click on “Allow Content material” from the pop-up field after finishing step 2 after which click on “Sure” when requested if you wish to make this a Trusted Doc.
- When you’ve got loads of trusted Excel spreadsheets, you’ll be able to mark a folder as a Trusted Location within the Belief Heart from the File->Choices menu. Any spreadsheets which are on this folder shall be trusted and you’ll not obtain macro warnings.
-B
- Posts: 283
- Joined: Tue Dec 23, 2014 10:30 am
Re: Retiree Portfolio Model
Post
by MrDrinkingWater »
I did not see anybody remark but on how effectively setting the variety of months labored on the Partner information row on the Setup worksheet of Model 24.1.
I examined out altering Cell J128 on the Setup Worksheet to numbers aside from 12, and I do not see a ensuing change within the Particulars Worksheet, and I do not see a change in Cell K128 on the Setup worksheet, as I believed I’d.
Within the “You” information row in “Part 4. Earnings” of the Setup worksheet, altering Cell J127 does have an impact within the Particulars Worksheet, and the worth that will get displayed in Cell K127 adjustments, as anticipated.
Re: Retiree Portfolio Model
MrDrinkingWater wrote: ↑Fri Jun 07, 2024 9:19 am
I did not see anybody remark but on how effectively setting the variety of months labored on the Partner information row on the Setup worksheet of Model 24.1.I examined out altering Cell J128 on the Setup Worksheet to numbers aside from 12, and I do not see a ensuing change within the Particulars Worksheet, and I do not see a change in Cell K128 on the Setup worksheet, as I believed I’d.
Within the “You” information row in “Part 4. Earnings” of the Setup worksheet, altering Cell J127 does have an impact within the Particulars Worksheet, and the worth that will get displayed in Cell K127 adjustments, as anticipated.
Thanks for reporting this. First partial yr SS advantages for the partner was not programmed. This has been mounted and the model quantity left at 24.1. Most customers won’t have to obtain once more.
https://dl.dropbox.com/scl/fi/eyab9fojk … 3rtwl&dl=1
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
Re: Retiree Portfolio Model
I’ve massive (quick and long run) capital losses harvested from 2022 for ten years or extra. Is there a strategy to incorporate the $3000 annual deduction in revenue in RPM for a set time interval? I’m utilizing v24.0
Re: Retiree Portfolio Model
On the Particulars web page use the yearly guide enter strains: Adjusted Gross Earnings Changes for short-term losses and Person Enter LTCG for the long run losses.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
Re: Retiree Portfolio Model
Query: I adopted DrinkingWater’s suggestion and didn’t run the macro to wipe out the Examples within the blue on the Setup tab. So, after I bought to the QCD’s (Part 7), I simply zeroed out the blue, which resulted in an Error messages (‘a number of months are underfunded’) because the Pattern numbers nonetheless seem on the Particulars web page (row 137). Ought to I simply zero them out on the Particulars web page as effectively, or do I have to run the macro??
Re: Retiree Portfolio Model
Big Dog wrote: ↑Thu Jul 11, 2024 12:28 pm
wow, superior product. Thanks a lot. I attempted it a couple of years in the past, and bought misplaced, however now that I am retired, it makes a complete lot extra sense.Query: I adopted DrinkingWater’s suggestion and didn’t run the macro to wipe out the Examples within the blue on the Setup tab. So, after I bought to the QCD’s (Part 7), I simply zeroed out the blue, which resulted in an Error messages (‘a number of months are underfunded’) because the Pattern numbers nonetheless seem on the Particulars web page (row 137). Ought to I simply zero them out on the Particulars web page as effectively, or do I have to run the macro??
I like to recommend utilizing the Clear macro because it clears and units for a brand new person all of the relevant preliminary settings. You may strive setting the QCD Embrace setting to “n” till the opposite settings will be re-entered. The Particulars web page comprises the calculated quantities and can’t be cleared. You’ll want to clear all blue strains on the Element web page which is perhaps chargeable for triggering that message. Take pleasure in your retirement!
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
- Posts: 7
- Joined: Sat Jul 13, 2024 1:19 pm
Re: Retiree Portfolio Model
Post
by AnothERetire »
I’ve a query concerning the Person enter for yearly changes to the mannequin’s AGI calculation for components not included in mannequin..
If I enter an adjustment to this yr’s AGI revenue, will that added revenue to added to subsequent yr’s taxable account steadiness? I perceive that applicable addition taxes shall be calculated, and that further tax shall be deducted from taxable account, however the place does that further person inputted revenue go?
What I’m making an attempt to do is modify the speed of return on the taxable account initially larger, then ‘glide down’, over the following 5-6 years to accommodate the present / close to time period Fed fee, slightly than utilizing a static return fee all through the simulation.
Or,… Wouldn’t it be higher to make use of Part 4 so as to add Earnings to ‘different revenue 1’, with a unfavourable change for the following 5-6 years? How would that be totally different from adjusting AGI?
Re: Retiree Portfolio Model
AnothERetire wrote: ↑Sat Jul 13, 2024 1:45 pm
Nice Mannequin!…I’ve a query concerning the Person enter for yearly changes to the mannequin’s AGI calculation for components not included in mannequin..
If I enter an adjustment to this yr’s AGI revenue, will that added revenue to added to subsequent yr’s taxable account steadiness? I perceive that applicable addition taxes shall be calculated, and that further tax shall be deducted from taxable account, however the place does that further person inputted revenue go?
What I’m making an attempt to do is modify the speed of return on the taxable account initially larger, then ‘glide down’, over the following 5-6 years to accommodate the present / close to time period Fed fee, slightly than utilizing a static return fee all through the simulation.
Or,… Wouldn’t it be higher to make use of Part 4 so as to add Earnings to ‘different revenue 1’, with a unfavourable change for the following 5-6 years? How would that be totally different from adjusting AGI?
Glad you want RPM. The AGI adjustment is strictly to regulate revenue taxes and doesn’t influence the taxable account steadiness. You may strive utilizing Part 4 and Part 5 – Bills to regulate the yearly Taxable account balances to strive get the return fee adjustment you need.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
Re: Retiree Portfolio Model
I’ve been drawing from an inherited IRA (from my mom) for 14 Yrs now utilizing stretch distribution and famous that if I put in inheriting this IRA in 2024 with identical yr first distribution the quantity calculated RMDs is off by about $466
. The beginning worth of this IRA inserted was the worth on 12/31/23. Other than including the distinction again into the AGI is there anything that may be accomplished? I perceive it’s a very small and sure insignificant within the massive scheme of issues. The life expectancy issue utilized by Vanguard was 16.8. ( i’ve automated RMDs enabled on this account) I assume that the withdrawal issue is the reason for this discrepancy.
.
I get a zero steadiness error for a number of accounts if I don’t embody the inherited IRA within the portfolio. After I embody it within the portfolio the steadiness for inherited IRA is clean in part 2.
How does RPM deal with the inherited IRA when included within the portfolio? There isn’t a strategy to point out the asset allocation of this inherited IRA in RPM and so how is the expansion of this account handled in future years? The inherited IRA is 100% bonds and my private TIRA is 60/40.
Re: Retiree Portfolio Model
jocdoc wrote: ↑Thu Jul 18, 2024 7:32 am
Simply downloaded and performed with V24.1 RPM (single)
I’ve been drawing from an inherited IRA (from my mom) for 14 Yrs now utilizing stretch distribution and famous that if I put in inheriting this IRA in 2024 with identical yr first distribution the quantity calculated RMDs is off by about $466
. The beginning worth of this IRA inserted was the worth on 12/31/23. Other than including the distinction again into the AGI is there anything that may be accomplished? I perceive it’s a very small and sure insignificant within the massive scheme of issues. The life expectancy issue utilized by Vanguard was 16.8. ( i’ve automated RMDs enabled on this account) I assume that the withdrawal issue is the reason for this discrepancy.I get a zero steadiness error for a number of accounts if I don’t embody the inherited IRA within the portfolio. After I embody it within the portfolio the steadiness for inherited IRA is clean in part 2.
How does RPM deal with the inherited IRA when included within the portfolio? There isn’t a strategy to point out the asset allocation of this inherited IRA in RPM and so how is the expansion of this account handled in future years? The inherited IRA is 100% bonds and my private TIRA is 60/40.
Thanks for this report. Since all values are rounded to $100 I am undecided the way you noticed a $466 distinction. The Part 2 balances must be up to date to point out current inherited quantities, which had been earlier to an replace this yr, not a function. Asset allocation and earnings charges for inherited IRAs are utilizing IRA1 and IRA2 quantities for simplicity, however may very well be included in a future model.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
Re: Retiree Portfolio Model
Is there a cell the place I can modify the age issue used for inherited IRA RMDs to replicate a decrease age issue than used for my very own TIRA?
The $466 distinction is the distinction between what RPM calculated and the precise quantity calculated by Vanguard.
Re: Retiree Portfolio Model
Coming into your present age in Particular Occasions – Inheritances will set off the inherited IRA withdrawals to begin within the present yr which can be before your individual IRAs.
Do not know why there could be a $466 distinction however will overview the calculations.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
Re: Retiree Portfolio Model
To begin with, thanks for creating this template/mannequin its precisely what I have been on the lookout for. I’ve a query about monitoring contributions for taxable accounts particularly a brokerage, I didn’t see a entry just like ‘6. IRA Contributions & Withdraws’ for taxable accounts. I put the beginning steadiness in Setup ‘Taxable_Begin’.
Re: Retiree Portfolio Model
dholmblad wrote: ↑Mon Jul 22, 2024 3:02 pm
To begin with, thanks for creating this template/mannequin its precisely what I have been on the lookout for. I’ve a query about monitoring contributions for taxable accounts particularly a brokerage, I didn’t see a entry just like ‘6. IRA Contributions & Withdraws’ for taxable accounts. I put the beginning steadiness in Setup ‘Taxable_Begin’.
Hope you discover it helpful. Will increase within the Taxable account will be entered in Part 4 – Earnings and seven – Particular Occasions. Additionally Social Safety revenue goes into it together with IRA withdrawals, and so on.
Retired |
Two-time in top-10 in Bogleheads S&P500 contest; 18-time loser
- Posts: 230
- Joined: Sat Aug 06, 2022 2:46 pm
Re: Retiree Portfolio Model
Post
by wingman4uz »
Is there a submit that somebody can level me to that describes what it’s doing ? (I did strive the search perform however no pleasure)
Thx
Wingman
Re: Retiree Portfolio Model
I’m utilizing V24.1, set to single instance. No zero account balances for 26 yrs reported in setup. I take advantage of class technique to calculate returns and authentic technique. The mannequin ends at 95. I’m operating Win 10 and workplace 365 model of Excel. Macros are enabled.
The RMD within the element sheet is in crimson kind at age 89. The quantity seems correct/ All different RMDs values earlier than and years after are in black kind. The bottom case sheet reveals all black kind for RMDs in any respect ages. I had three Roth conversions entered; at ages 70, 71, 72. If I clear the Roth conversions setting these again to zero worth the RMD at age 89 stays crimson the opposite RMDs are black. Together with or excluding inherited IRA doesn’t change any of the above
The outcomes web page reveals an error messages (sections in the course of the workbook, not the highest of the sheet) within the portfolio exercise by account comparability and Portfolio exercise by account revealing in crimson kind of 95187 under the whole column and 17 in crimson under the taxable column No error numbers under the TIRA however the inherited IRA column reveals an a crimson quantity equal to the quantity inherited within the portfolio exercise by account part of outcomes however not in portfolio by account part.
I downloaded a recent copy of RPM v 24.1 however proceed to have identical drawback. Options for the excel error listed on the internet didn’t appear to unravel this.
- Posts: 31
- Joined: Sat Nov 26, 2016 4:06 pm
Re: Retiree Portfolio Model
Post
by mostly_patient »
That is my first submit within the RPM discussion board.
Firstly, large due to all who designed and perfected the mannequin.
I’m going by way of the Setup web page.
First main query:
Re 4. Earnings, ‘revenue sources’ desk
It’s my understanding that ‘Pension1’ ought to discuss with MY pension, and ‘Pension2’ ought to discuss with my spouse’s pension.
Why does the instruction to the ‘Begin Age’ column states: “Enter Your age to begin revenue. Do NOT use Partner age”.
This isn’t clear. The place ought to Partner’s pension and different revenue be entered?
Thanks!
Re: Retiree Portfolio Model
LadyGeek wrote: ↑Wed Oct 27, 2021 10:11 am
Really, it has been mentioned as a subject for a future Bogleheads digital chapter sequence assembly (what you see on YouTube). I’ve given a fast demo earlier than (not on YouTube), however the principle sticking level is that it is also difficult for many who are savvy customers.The very best method is to observe the tutorial within the Readme tab. That is not saying a video will not be useful – I am positive will probably be. It is simply that there are numerous transferring elements. Every person will work with the elements which are applicable for their very own state of affairs.
Simply studying in regards to the RPM sheet for the primary time. Did a video tutorial ever get any traction?
Re: Retiree Portfolio Model
In Settings, am puzzled the best way to enter ages and finish age. I’m a bit youthful than spouse however household historical past suggests loads longer life for me. How ought to that be mirrored within the ages setting space? Ought to she be the primary slot and a guesstimate of her finish age, me second, and mannequin age past my guess at finish age?
John Alvord
- Website Admin
- Posts: 98525
- Joined: Sat Dec 20, 2008 4:34 pm
- Location: Philadelphia
- Contact:
Re: Retiree Portfolio Model
bltkmt wrote: ↑Mon Aug 12, 2024 10:52 amLadyGeek wrote: ↑Wed Oct 27, 2021 10:11 am
Really, it has been mentioned as a subject for a future Bogleheads digital chapter sequence assembly (what you see on YouTube). I’ve given a fast demo earlier than (not on YouTube), however the principle sticking level is that it is also difficult for many who are savvy customers.The very best method is to observe the tutorial within the Readme tab. That is not saying a video will not be useful – I am positive will probably be. It is simply that there are numerous transferring elements. Every person will work with the elements which are applicable for their very own state of affairs.
Simply studying in regards to the RPM sheet for the primary time. Did a video tutorial ever get any traction?
Sorry, no. I bear in mind giving a short overview for a couple of minutes as a part of one other video. I do not see something listed within the YouTube channel that may counsel the place that was accomplished. In any case, the very best method is to work by way of the spreadsheet and ask questions on this thread.
Re: Retiree Portfolio Model
I’m utilizing v24.1 (single model). I’ve no extra error messages anyplace however within the particulars tab the TIRA RMD at age 89 is in crimson kind. The RMDs on the remainder of the sheet are in black kind and all of the RMDs within the base case are black. The quantity seems correct. I’ve greater than sufficient in taxable and TIRA. I’ve three Roth conversions beginning at 70 by way of 72 years. What does the crimson typed RMD signify? Is that this a bug?
Re: Retiree Portfolio Model
jocdoc wrote: ↑Wed Aug 14, 2024 3:43 pm
I’m utilizing v24.1 (single model). I’ve no extra error messages anyplace however within the particulars tab the TIRA RMD at age 89 is in crimson kind. The RMDs on the remainder of the sheet are in black kind and all of the RMDs within the base case are black. The quantity seems correct. I’ve greater than sufficient in taxable and TIRA. I’ve three Roth conversions beginning at 70 by way of 72 years. What does the crimson typed RMD signify? Is that this a bug?
I seen on my particulars tab cell Y94 the font colour was set at crimson. Pretty positive I did not do this myself. Possibly that’s what you might be seeing?
- Posts: 2
- Joined: Sat Aug 17, 2024 9:17 pm
Re: Retiree Portfolio Model
Post
by RiskManager »
I’ve a query in regards to the IRMAA surcharges portion of Part 5 Bills. I’m not but retired and don’t plan to until the age of 67 slightly than 65 and my spouse who’s 2 years my senior won’t enroll until the identical time when she shall be 69. How do I set the IRMAA surcharges and lookback to begin after I attain that age since that may be a few years away? I see it references the hidden Medicare portion of the Tax Tables. Is there a setting there I would like to alter? I see a row labeled “Quantity enrolled in Medicare, i.e. 65 and older”. Is that this the row I would like to alter to 0 for the years earlier than I’m 67?
Thanks, a lot appreciated.
Re: Retiree Portfolio Model
Is there a strategy to change the age issue for the RMD calculations with out altering the TIRA age components. I inherited this IRA from my mom in 2010 and the age issue for the calculations are larger.
- Posts: 1
- Joined: Thu Aug 29, 2024 7:37 pm
Retiree Portfolio Model v24.1
Post
by la_sonnambula »
[Merged into existing thread by Moderator Misenplace]
On the Setup tab, Part 6, subsection IRA contributions, why is there a line for Roth 1 however not Roth 2?
I’m a brand new person!
Thanks on your help.
- Posts: 2
- Joined: Sat Aug 17, 2024 9:17 pm
Re: Retiree Portfolio Model
Post
by RiskManager »
One factor I bumped into on the mannequin was unusual. I didn’t get any unfavourable balances anyplace however within the Particulars tab the State revenue taxes proportion (Row 242) ended up being >100% for a few years (166.7% and 125%). For State revenue changes on the setup tab, I had modeled transferring at retirement from a state the place common revenue, pensions and IRAs and 401Ks was taxed and the flat fee tax is 4.8% to a state the place pensions, IRAs and 401Ks weren’t taxed however capital features and federal tax-exempt revenue is taxed at 5%. Social Safety advantages weren’t taxed in both state.
The mannequin stored 4.8% for the years I used to be within the first state after which jumped to eight%, 166.7% and 125% the years I moved to the state that doesn’t tax retirement revenue (after retirement) earlier than dropping to 0% after that. I used to be modeling a Roth conversion the primary two years after transferring in addition to a number of extra beginning with yr 4 after transferring.