- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
SOLVED Calling Finance Math Nerds - Puzzling Loan Statement
Posted on 3/26/24 at 5:16 pm
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?
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 on 3/26/24 at 5:52 pm to SonicAndBareKnuckles
One month had 31 days. One month had 28 days. Mystery solved. By the mystery solver guy.
Posted on 3/26/24 at 6:38 pm to UpstairsComputer
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 on 3/28/24 at 2:36 pm to UpstairsComputer
I thought it was 29 days
Popular
Back to top
Follow TigerDroppings for LSU Football News