Page 1
Page 1
Started By
Message

SOLVED Calling Finance Math Nerds - Puzzling Loan Statement

Posted on 3/26/24 at 5:16 pm
Posted by SonicAndBareKnuckles
Member since Jun 2018
1596 posts
Posted on 3/26/24 at 5:16 pm
My friend contacted me and sent me a picture of a loan statement, and we're trying to figure out why there has been a big decrease in the payment amount applied to interest, and an increase in the amount applied to principal.

Here's the info I have:

Outstanding principal $127,655.66
Interest Rate 4.400%

Last month paid principal $181.80
Last month paid interest $477.72
Total $659.52

Current month principal due $228.63
Current month interest due $430.89
Total $659.52

Based on the borrower's description of the loan, I think it's a 5/1 ARM, and the loan originated around April 2022.

My first question was if the rate had changed and the answer was no, 4.4% has always been stated as the interest rate. I also asked if there has been any special payments to paydown the principal and the answer was no.
I then thought about a change in amortization, but decided against that since the total P&I payment is unchanged.

Playing with the numbers anyway, I'm getting a remaining amortization of 336 months which means it would have been 360 months at origination in April 2022. Here's my Excel function =NPER(0.044/12,-659.52,127655.66,0,1)

The possibilities that I'm thinking of now is that the current month due P&I values are simply incorrect, or that the loan is actually accruing interest at a rate less than the stated 4.4%, I'm estimating around 4.05%.

What's the Money Board's thoughts?
This post was edited on 3/26/24 at 6:39 pm
Posted by UpstairsComputer
Prairieville
Member since Jan 2017
1572 posts
Posted on 3/26/24 at 5:52 pm to
One month had 31 days. One month had 28 days. Mystery solved. By the mystery solver guy.
Posted by SonicAndBareKnuckles
Member since Jun 2018
1596 posts
Posted on 3/26/24 at 6:38 pm to
quote:

One month had 31 days. One month had 28 days. Mystery solved. By the mystery solver guy.


Ah, actual accrual never crossed my mind.

I think every loan I've had used 30/360 interest accrual so I'm not used to seeing the principal and interest payments change like that from month to month. Thanks!
Posted by whiskey over ice
Member since Sep 2020
3254 posts
Posted on 3/26/24 at 7:16 pm to
Posted by GrizzlyAlloy
Member since Aug 2020
1637 posts
Posted on 3/28/24 at 2:36 pm to
I thought it was 29 days
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram