Notifications
Clear all

Entry of Annual Deferred Salary Payments

14 Posts
6 Users
2 Reactions
1,116 Views
 NC
(@nc-cpl)
Reputable Member Customer
Joined: 4 years ago
Posts: 283
Topic starter  

Not certain how to enter annual deferred salary payments that will span the next 9 years (2023-2031 inclusive). This is paid out once a year until the balance is depleted in 2031. Money is invested similar to any brokerage account, and taxed as regular income when paid. Payments can and will change over time based on investment performance.

I currently have it set up as "Other Income Stream #1" and "Other Income Stream #2" since the payments drop by 50% starting in 2027 due to differing amounts of deferment each year while working. My questions are 1) is this the right place to enter this type of income and 2) if annual payments change over time, isn't putting them in as an income stream treating them as static over the years specified? Is there a better way to account for their potential to rise/fall over time? Also, 3) how can I account for any ROR since this money is invested same as our brokerage accounts? The "Annual % Increase" of a income stream seems to be referring more to an annual salary increase which would not be the same.



   
ReplyQuote
(@jj_ejm009_jj0)
Eminent Member Customer
Joined: 4 years ago
Posts: 21
 

I would enter the balance as a tax deferred account. Then create 9 years of scheduled withdrawals that deplete the balance. You can manipulate the withdrawals into pieces to mimic what the actual expected amounts are. This then will pretty much be accurate from a tax perspective as you have most likely already paid employment taxes (FICA) but will have to pay income taxes on the withdrawals. You can then also model the growth in this account based on how you have it invested.



   
ReplyQuote
 NC
(@nc-cpl)
Reputable Member Customer
Joined: 4 years ago
Posts: 283
Topic starter  

@jj_ejm009_jj0 Thanks James, however, there's really no way of anticipating what the expected amounts will be given market volatility (esp. these days). You are correct that FICA was deducted when I was working/deferring. Income tax (fed and state) was not. I assume I'd enter the current balance on the Assets page, but where do you break out the 9 yrs of withdrawals and estimate growth? How is this different (better) than just setting up as an additional income stream?



   
ReplyQuote
(@jj_ejm009_jj0)
Eminent Member Customer
Joined: 4 years ago
Posts: 21
 

NC

My objection to treating this as income is that you already have the money as part of your net worth. To me, income is something that you receive that is outside of any account you have current ownership and visibility to. Similar to an IRA, you may not be able to easily spend this money right now, but it is part of your net worth. If you were to pass away, it would not disappear as an arbitrary income stream may.

You could look at treating it as an Inherited IRA, or if you have a spouse that does not have a traditional IRA use that as a place holder. If this is possible, it could allow some flexibility in setting the account asset allocation and thus the expected return and volatility. This may also allow you to control how the account empties through scheduled withdrawals or substantially equal periodic payments.



   
ReplyQuote
 NC
(@nc-cpl)
Reputable Member Customer
Joined: 4 years ago
Posts: 283
Topic starter  

I agree it's "already earned income" that would not disappear if either of us were to pass away. That said, if it's considered tax-deferred, wouldn't taxation be differently than regular income? I don't see "Regular Income" as an option on the Asset Class taxation page. What about any negative impact by having a much larger tax-deferred balance (larger RMD's) ? I also don't see the page to set up the scheduled withdrawals.

By contrast, if it's an income stream I can designate regular income taxation, and that 100% goes to a survivor, and the "estimated" payouts for the remaining years.



   
ReplyQuote
(@jj_ejm009_jj0)
Eminent Member Customer
Joined: 4 years ago
Posts: 21
 

When you realize income from a tax deferred account, it is taxed similar to income from wages in that year. If you lump your deferred salary (409a non-qualified plan ?) amounts with any other deferred accounts (401k/IRA), then yes the calculated RMD values will likely be inflated. If you are > 9 years from RMD age, you could combine the amounts and then schedule appropriate withdrawals that would deplete the deferred salary amount before the RMDs take effect. If you use a proxy inherited IRA account to represent the deferred salary, I believe you could avoid any RMD co-mingling.

Scheduled withdrawals are under FINANCIAL ASSESTS->Management. Note: I have not yet upgraded to PRC 2023, I assume it has not moved.

PRC is flexible enough that you can really do this several ways, whatever suits you best.



   
ReplyQuote
 NC
(@nc-cpl)
Reputable Member Customer
Joined: 4 years ago
Posts: 283
Topic starter  

@jj_ejm009_jj0 Given your explanation I feel I'd be creating a few new issues that don't exist presently. First, if it inflates RMD's, that will throw off QCD's I'm calculating to specifically offest RMD's, so now my QCD's would be over-inflated to compensate. Also, I'm less than 9 yrs from RMD's starting, and , I cannot accelerate the payouts, they are on an schedule that cannot be changed.



   
ReplyQuote
(@jj_ejm009_jj0)
Eminent Member Customer
Joined: 4 years ago
Posts: 21
 

In that case, if either you or your spouse do not already have an inherited IRA, I would use this as a proxy. This has the advantage that you can specify its own asset allocation and withdrawal schedule independent of your other deferred accounts. You can then also separately track it in the tabular results. If not then as you have indicated a fixed income stream with the modeling downside of no statistical variation could work.



   
ReplyQuote
(@deniseandkarelgmail-com)
New Member
Joined: 1 year ago
Posts: 2
 

I just jointed the Pralana online family and discovered that it does not have a built-in way to deal with deferred salary. It took me only minutes to create a spreadsheet that did the calculations for me, but I'd like Pralana to do the heavy lifting instead.

SO here's a feature request: please support calculations of deferred salary income using a "R" wildcard (so that I actually can run scenarios involving my retirement date). For my scenario, my deferred income will be paid out in yearly payments over 15 years. Assuming a 5% growth (the deferred salary can be invested), I would predict the following payouts for $100,000 deferred income:

Start Year Years to go Payout Year-end
$100,000.00 1 15 $6,666.67 $98,000.00
$98,000.00 2 14 $7,000.00 $95,550.00
$95,550.00 3 13 $7,350.00 $92,610.00
$92,610.00 4 12 $7,717.50 $89,137.13
$89,137.13 5 11 $8,103.38 $85,085.44
$85,085.44 6 10 $8,508.54 $80,405.74
$80,405.74 7 9 $8,933.97 $75,045.36
$75,045.36 8 8 $9,380.67 $68,947.92
$68,947.92 9 7 $9,849.70 $62,053.13
$62,053.13 10 6 $10,342.19 $54,296.49
$54,296.49 11 5 $10,859.30 $45,609.05
$45,609.05 12 4 $11,402.26 $35,917.13
$35,917.13 13 3 $11,972.38 $25,141.99
$25,141.99 14 2 $12,570.99 $13,199.54
$13,199.54 15 1 $13,199.54 $0.00

Short of actually implementing support in Pralana, what's the best way to mimic this income (short of typing in the numbers myself for every year)?



   
ReplyQuote
(@smatthews51)
Member Admin
Joined: 5 years ago
Posts: 1140
 

@deniseandkarelgmail-com Hi Karel, thanks for your input, and we'll add this to our list of candidate enhancements. The only portion of this that cannot be supported currently is to limit the duration of the payments to a specific number of years, such as 15 in your case. As a result, that greatly limits the power of starting this stream of payments with an "R" for the start date. That said, you can use either an employment, pension, or other income stream to specify that you have an income stream that starts at $6666 annually and grows at 5%, but you will need to specify the exact start and stop years. Ideally, I suppose, the start year could be R and the stop year R+15, but that capability isn't currently available.

Stuart



   
ReplyQuote
(@chrisb)
Eminent Member
Joined: 5 years ago
Posts: 18
 

@deniseandkarelgmail-com I just changed a deferred income account (Savings Excess Plan or SEP) in my Pralana Online model from Taxable with withdrawals to the "proxy" Inherited IRA (spouse) method Mr. Mittel suggested and it corrected a tracking delta I'd been seeing ever since I created my original model. With the added benefits of seeing the withdrawals broken out, the tax treatment, and the allocation and RoR control, the proxy approach seems like a winner in my case, for now, at least.



   
ReplyQuote
(@deniseandkarelgmail-com)
New Member
Joined: 1 year ago
Posts: 2
 

Thanks all for the follow-up. For now, I modelled this as a 15-year pension with 5% increase every year starting at my tentative retirement date. That seemed to do the trick.



   
ReplyQuote
(@hines202)
Honorable Member Customer
Joined: 5 years ago
Posts: 509
 

@smatthews51 The ability to indicate some thing like "R +15" would be useful. For example, frequently clients want to indicate LTC expenses for their last three years of life. So if they put 90 in their longevity field, they put 87 or so in the LTC start age. But if they change their longevity to test longevity risk, I often see them forgetting to adjust the field in the LTC start date. This would prevent that error.



   
ReplyQuote
(@smatthews51)
Member Admin
Joined: 5 years ago
Posts: 1140
 

@hines202 I agree, it would be a nice enhancement and am adding it to our candidate list of enhancements.

Stuart



   
ReplyQuote
Share: