Jump to content

401(k) Loan Calculation


Recommended Posts

Guest Mannix
Posted

How are the loan calculations done when the Participant's account balance is less than $50,000? Please see below, did we calculate the 3rd loan correctly?

$3,622.35 = Current Cash at ING (100% vested)

+ 780.08 = Current Balance on Loan #2 (Loan #1 paid off 07/29/2010)

$4,402.43

x 50%

$2,201.22

- 1,880.53 = Highest Outstanding Balance on any one day (09/01/09 = $1,000 New Loan #2 + $880.53 Loan #1 Balance)

$320.69 = New Loan (But, does not meet $1,000 minimum threshhold, so no new loan)

Thanx.

Posted
How are the loan calculations done when the Participant's account balance is less than $50,000? Please see below, did we calculate the 3rd loan correctly?

$3,622.35 = Current Cash at ING (100% vested)

+ 780.08 = Current Balance on Loan #2 (Loan #1 paid off 07/29/2010)

$4,402.43

x 50%

$2,201.22

- 1,880.53 = Highest Outstanding Balance on any one day (09/01/09 = $1,000 New Loan #2 + $880.53 Loan #1 Balance)

$320.69 = New Loan (But, does not meet $1,000 minimum threshhold, so no new loan)

Thanx.

The highest oustanding loan balance reduces the $50,000 threshold, not the 50% of vested account balance threshold.

The calculation should be:

$3,622.35 = Current Cash at ING (100% vested)

+ 780.08 = Current Balance on Loan #2 (Loan #1 paid off 07/29/2010)

$4,402.43

x 50%

$2,201.22

- 780.08 current outstanding loan balance

$1.421.14 = amount available for 3rd loan

Laura

  • 1 year later...
Posted

Can participant take out another loan while first loan still active? If so, I assume the 2nd loan is separate from the 1st loan. How does one figure the highest loan amount for the 2nd loan?

Posted

When the balance is that low the highest balance in the previous 12 months is a moot point, because the $50,000 limit is no where near an issue. In your examples, maybe the $50,00 limit will drop to $48,000, which is way higher than the 50% limit.

Some plans will allow only one loan. If the Plan allows just one loan, then refinancing is the only option. If the participant is taking the max available, then the entire new loan must be repaid wihtin 5 years of the original loan. But the refinancing rules are more complicated than I care to get into... For example, if the new loan is small enough, then the participant might qualify for a new 5 year term.

Austin Powers, CPA, QPA, ERPA

Posted
Some plans will allow only one loan. If the Plan allows just one loan, then refinancing MIGHT BE the only option.

Fixed.

Not all plans allow for refinancing; some specifically disallow it.

QKA, QPA, CPC, ERPA

Two wrongs don't make a right, but three rights make a left.

  • 5 years later...
Posted

Having trouble understanding and need help. Vanguard states I have highest outstanding balance of $12,714 in past 12 months  (6214.70 outstanding loans in period ending 12/16 + current loan $6500 taken 8/7/2017) and my max for 3rd loan is $4,338

The $6,214 represents 3 previous loans of which 2 were paid off 7/20/17 and 11/24/17

current loans balances are $1,259 and $5,302

Vested Amount = $26,238

outstanding loan balance = $6,561

If the 50% vested is applied wouldn't it be :

26,238 +6,561= $32,799

32,399x.50= 16,399

$16,399 - 6,561 = 9,838

thanks

Posted

The 12-month balance may not apply because your combined loans does not exceed $50k. 

Are you sure that the $26,238 does not include your loan balances?

Are you sure that you're 100% vested? 

Did they give any info on how they got to $4338?

R. Alexander

Posted

Statement breaks  loan and balance into separate categories, then provides a total. and yes 100% vested.  no information on how they derived at that number,  or what formula is being used.

Posted

First of all it is almost impossible to imagine their system wouldn't calculate accurately. Correction, it is impossible.

2nd based on the informaiton you gave, even if the 26K includes the loan balance, I still get a different number than what they have provided.

And taking into account my first statement, it means that in all likelihood you are missing something.  What you need from them is a calculation.  Not a rep over the phone but something on paper that demonstrates the max. 

 

Austin Powers, CPA, QPA, ERPA

Posted
18 hours ago, Ejay2018 said:

Spoke with someone and they stated the outstanding loan balances in a rolling 12 month period is used in determining future loan amounts.

Your loan should not be affected by the rolling 12-month balance; that only comes into play when your loans near $50k (combined). 

R. Alexander

Posted

If 26,238 is the value of the investments excluding the loans, your calculation is correct.  But again we know something must be wrong with your figures because my money is on Vanguard's $100 million software package calculating it correctly.

Austin Powers, CPA, QPA, ERPA

Posted
15 minutes ago, austin3515 said:

If 26,238 is the value of the investments excluding the loans, your calculation is correct.  But again we know something must be wrong with your figures because my money is on Vanguard's $100 million software package calculating it correctly.

Yes but their $100 million software package is only as accurate as the ability of the person who does the input!

Happy New Year to all!!

 

Mike

 

Posted

Untrue.  The $100 million dollar program simply indicates the max loan based on the data that the software already has (account balance, loan balance, and any other limitations).  No data entry required.

For that matter, perhaps the plan only takes into account certain sources for the 50% threshold. That could account for the discrepancy.  It is an extremely rare scenario, but there really must be something.

Austin Powers, CPA, QPA, ERPA

Posted
1 minute ago, 401king said:

Perhaps the Plan has its own limitations. You need to take your questions back to Vanguard for real answers. 

Gee why didn't I think of that :P

Austin Powers, CPA, QPA, ERPA

Posted

While I await Vanguards calculation explanation, secondary question would be "If the available is in fact $4338, why isn't the greater of $10,000 or 50% of vested balance applied?

Posted

To make sure you understand what Austin is saying the law defines the maximum amount a loan can be from a qualified plan.  The plan document can always set a lower limit.  The most common example of plans doing so is they never use the $10k limit for the reasons he stated. 

Posted

Thanks , that clears that question up. Now I await the calculations as each individual I spoke with over the phone consistently references the highest balance in rolling 12 month scenario.

Posted

Finally received a detailed explanation from Vanguard.  There is a portion of my balance (Company stock$10k)that can not be withdrawn for loan purposes. Therein lies the difference in amount available. Thanks for all the repsonse that allowed me to pose the right question to Vanguard!!

Now my next questions is can you do a Hardahip withdrawal immediately after Loan has been processed.?

Posted
11 hours ago, Ejay2018 said:

 

Now my next questions is can you do a Hardahip withdrawal immediately after Loan has been processed.?

As you just found out with the loan question it depends in the end what the plan says.  The law would allow it assuming you have a hardship that qualifies.  So ask Vanguard the question. 

Posted
On 12/27/2017 at 4:09 AM, austin3515 said:

First of all it is almost impossible to imagine their system wouldn't calculate accurately. Correction, it is impossible.

Your confidence wasn't misplaced it turns out. 

Posted

...and don't be surprised if that company stock is unavailable for the hardship as well.

QKA, QPA, CPC, ERPA

Two wrongs don't make a right, but three rights make a left.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Terms of Use