Welcome to City-Data.com Forum!
U.S. CitiesCity-Data Forum Index
Go Back   City-Data Forum > General Forums > Real Estate > Mortgages
 [Register]
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
View detailed profile (Advanced) or search
site with Google Custom Search

Search Forums  (Advanced)
 
Old 03-10-2016, 07:06 AM
 
5,642 posts, read 15,711,475 times
Reputation: 2758

Advertisements

Hey guys, hoping to get some help here.

I bought a piece of land for $41000 in 2011 from a seller that financed a loan at 2.5% for 5 years. I put $5k down as a downpayment in August 2011 as well as $638.91 for that month's mortgage payment. I have been making $638.91 payments for every month since.

According to my spreadsheet, I have a balance of $854.54 left. However, the seller is claiming I still owe $638.91 per month until July based on the amortization schedule.

Since I am a sloppy accountant, I probably made a mistake somewhere. Does anyone know what could have happened? I had my checks electronically sent per month.

P.S>I'd check my bank statements.. but my bank wants $30 per paper statement for every month prior to 2014....may have to do that.
Reply With Quote Quick reply to this message

 
Old 03-10-2016, 07:44 AM
 
525 posts, read 660,541 times
Reputation: 1616
Accounting in NOT my forte. However, my amortization schedule has me paying more INTEREST at the beginning of the loan, with minimal going toward the PRINCIPLE. It balances out toward the middle, then reverses toward the end. This is why if you have a loan where you can make additional payments toward the principle with no prepayment penalty, you can save thousands of $$$ over the lifetime of the loan. Any extra I pay over the payment each month goes toward the principle. Can't you just ask the seller for an accounting?
Reply With Quote Quick reply to this message
 
Old 03-10-2016, 08:38 AM
 
Location: New Market, MD
2,573 posts, read 3,503,431 times
Reputation: 3259
Quote:
Originally Posted by doss1 View Post
Hey guys, hoping to get some help here.

I bought a piece of land for $41000 in 2011 from a seller that financed a loan at 2.5% for 5 years. I put $5k down as a downpayment in August 2011 as well as $638.91 for that month's mortgage payment. I have been making $638.91 payments for every month since.

According to my spreadsheet, I have a balance of $854.54 left. However, the seller is claiming I still owe $638.91 per month until July based on the amortization schedule.

Since I am a sloppy accountant, I probably made a mistake somewhere. Does anyone know what could have happened? I had my checks electronically sent per month.

P.S>I'd check my bank statements.. but my bank wants $30 per paper statement for every month prior to 2014....may have to do that.

Your payment of $638.91 is calculated based on 36K loan you had. It'll run for full 5 years and that's why that payment. Unless you made extra payments - bank/seller is correct your last payment will be in July this year.

Date Payment Principal Interest Total Interest Balance Sept. 2016 $638.91 $563.91 $75.00 $75.00 $35,436.09 Oct. 2016 $638.91 $565.08 $73.83 $148.83 $34,871.02 Nov. 2016 $638.91 $566.26 $72.65 $221.47 $34,304.76 Dec. 2016 $638.91 $567.44 $71.47 $292.94 $33,737.32 Jan. 2017 $638.91 $568.62 $70.29 $363.23 $33,168.70 Feb. 2017 $638.91 $569.80 $69.10 $432.33 $32,598.90 Mar. 2017 $638.91 $570.99 $67.91 $500.24 $32,027.91 April 2017 $638.91 $572.18 $66.72 $566.97 $31,455.73 May 2017 $638.91 $573.37 $65.53 $632.50 $30,882.36 June 2017 $638.91 $574.57 $64.34 $696.84 $30,307.79 July 2017 $638.91 $575.76 $63.14 $759.98 $29,732.03 Aug. 2017 $638.91 $576.96 $61.94 $821.92 $29,155.06 Sept. 2017 $638.91 $578.17 $60.74 $882.66 $28,576.90 Oct. 2017 $638.91 $579.37 $59.54 $942.20 $27,997.53 Nov. 2017 $638.91 $580.58 $58.33 $1,000.53 $27,416.95 Dec. 2017 $638.91 $581.79 $57.12 $1,057.64 $26,835.16 Jan. 2018 $638.91 $583.00 $55.91 $1,113.55 $26,252.17 Feb. 2018 $638.91 $584.21 $54.69 $1,168.24 $25,667.95 Mar. 2018 $638.91 $585.43 $53.47 $1,221.72 $25,082.52 April 2018 $638.91 $586.65 $52.26 $1,273.97 $24,495.87 May 2018 $638.91 $587.87 $51.03 $1,325.01 $23,908.00 June 2018 $638.91 $589.10 $49.81 $1,374.81 $23,318.90 July 2018 $638.91 $590.32 $48.58 $1,423.40 $22,728.58 Aug. 2018 $638.91 $591.55 $47.35 $1,470.75 $22,137.03 Sept. 2018 $638.91 $592.79 $46.12 $1,516.87 $21,544.24 Oct. 2018 $638.91 $594.02 $44.88 $1,561.75 $20,950.22 Nov. 2018 $638.91 $595.26 $43.65 $1,605.40 $20,354.96 Dec. 2018 $638.91 $596.50 $42.41 $1,647.80 $19,758.46 Jan. 2019 $638.91 $597.74 $41.16 $1,688.96 $19,160.72 Feb. 2019 $638.91 $598.99 $39.92 $1,728.88 $18,561.73 Mar. 2019 $638.91 $600.23 $38.67 $1,767.55 $17,961.50 April 2019 $638.91 $601.49 $37.42 $1,804.97 $17,360.01 May 2019 $638.91 $602.74 $36.17 $1,841.14 $16,757.27 June 2019 $638.91 $603.99 $34.91 $1,876.05 $16,153.28 July 2019 $638.91 $605.25 $33.65 $1,909.70 $15,548.03 Aug. 2019 $638.91 $606.51 $32.39 $1,942.10 $14,941.51 Sept. 2019 $638.91 $607.78 $31.13 $1,973.22 $14,333.74 Oct. 2019 $638.91 $609.04 $29.86 $2,003.09 $13,724.69 Nov. 2019 $638.91 $610.31 $28.59 $2,031.68 $13,114.38 Dec. 2019 $638.91 $611.58 $27.32 $2,059.00 $12,502.80 Jan. 2020 $638.91 $612.86 $26.05 $2,085.05 $11,889.94 Feb. 2020 $638.91 $614.13 $24.77 $2,109.82 $11,275.81 Mar. 2020 $638.91 $615.41 $23.49 $2,133.31 $10,660.39 April 2020 $638.91 $616.70 $22.21 $2,155.52 $10,043.70 May 2020 $638.91 $617.98 $20.92 $2,176.44 $9,425.72 June 2020 $638.91 $619.27 $19.64 $2,196.08 $8,806.45 July 2020 $638.91 $620.56 $18.35 $2,214.43 $8,185.89 Aug. 2020 $638.91 $621.85 $17.05 $2,231.48 $7,564.04 Sept. 2020 $638.91 $623.15 $15.76 $2,247.24 $6,940.89 Oct. 2020 $638.91 $624.44 $14.46 $2,261.70 $6,316.45 Nov. 2020 $638.91 $625.75 $13.16 $2,274.86 $5,690.70 Dec. 2020 $638.91 $627.05 $11.86 $2,286.71 $5,063.65 Jan. 2021 $638.91 $628.36 $10.55 $2,297.26 $4,435.30 Feb. 2021 $638.91 $629.66 $9.24 $2,306.50 $3,805.63 Mar. 2021 $638.91 $630.98 $7.93 $2,314.43 $3,174.66 April 2021 $638.91 $632.29 $6.61 $2,321.05 $2,542.36 May 2021 $638.91 $633.61 $5.30 $2,326.34 $1,908.76 June 2021 $638.91 $634.93 $3.98 $2,330.32 $1,273.83 July 2021 $638.91 $636.25 $2.65 $2,332.97 $637.58 Aug. 2021 $638.91 $637.58 $1.33 $2,334.30 $0.00
Reply With Quote Quick reply to this message
 
Old 03-10-2016, 03:52 PM
 
8,574 posts, read 12,411,457 times
Reputation: 16533
Quote:
Originally Posted by doss1 View Post
Hey guys, hoping to get some help here.

I bought a piece of land for $41000 in 2011 from a seller that financed a loan at 2.5% for 5 years. I put $5k down as a downpayment in August 2011 as well as $638.91 for that month's mortgage payment. I have been making $638.91 payments for every month since.

According to my spreadsheet, I have a balance of $854.54 left. However, the seller is claiming I still owe $638.91 per month until July based on the amortization schedule.

Since I am a sloppy accountant, I probably made a mistake somewhere. Does anyone know what could have happened? I had my checks electronically sent per month.

P.S>I'd check my bank statements.. but my bank wants $30 per paper statement for every month prior to 2014....may have to do that.
Does your bank allow you to look up records online? I would check on that since what you owe depends upon when your payments were made--and for the period for which each covered.

IF you entered into the agreement on August 1, 2011, and you had an initial $36,000 balance, your monthly payment of $638.91 would have been correct. If you made all of your payments on schedule, and for the amount noted, then you would still owe your monthly payment until July of this year.

HOWEVER, if you paid $5,000 down and also made a payment of $638.91 at that time, that would NOT have been according to the amortization schedule since the first payment is due one month into the loan (or for a prorated time if you started, say, mid-month and moved to monthly payments). IF you made a separate, initial payment, that totally screws up the amortization schedule since no interest was owed at the onset--and all of your payment should have been applied against the principal. In that case, you would need to calculate the interest amount paid each month, and subtract the principal payment amount from your balance owed each month. The difference probably isn't that great (i.e. not enough to cut months off of your payments), but it should reduce somewhat the final balance owed at the end of the contract.

Unfortunately, you didn't keep track of a running balance with your Seller. That would have eliminated any confusion. What is your "spreadsheet"? Was that from some other source, or was it your payment schedule as calculated by you each month?

In any case, unless you made other payments not a part of the amortization schedule, you still owe more than you estimate. At least the Seller gave you a very good interest rate.
Reply With Quote Quick reply to this message
 
Old 03-10-2016, 04:17 PM
 
8,574 posts, read 12,411,457 times
Reputation: 16533
FOLLOWUP:

If you, indeed, made an initial payment of $5,638.91 ($5k + $638.91 monthly payment), the initial amount of your loan was effectively $35,361.09--not $36,000.

The 5-year amortization schedule for a loan of $35,361 would have called for monthly payments of $627.56. So...for you to have the amortized payments go the full 5 years (60 months), you should have been paying the lesser amount. Instead (and this is based upon you paying your first payment early--if, in fact, that was the case) you have been paying $11.35 more each month than amortization would call for. Over 60 months that comes to $681 in extra payments. So...your payoff date would be cut short by just over one month.

So, as you can see, when you made your payments is very important.


P.S. If you haven't received the Deed yet, I hope he has good title.
Reply With Quote Quick reply to this message
 
Old 03-10-2016, 07:33 PM
 
Location: Phoenix, AZ area
3,365 posts, read 5,239,267 times
Reputation: 4205
Quote:
Originally Posted by doss1 View Post
Hey guys, hoping to get some help here.

I bought a piece of land for $41000 in 2011 from a seller that financed a loan at 2.5% for 5 years. I put $5k down as a downpayment in August 2011 as well as $638.91 for that month's mortgage payment. I have been making $638.91 payments for every month since.

According to my spreadsheet, I have a balance of $854.54 left. However, the seller is claiming I still owe $638.91 per month until July based on the amortization schedule.

Since I am a sloppy accountant, I probably made a mistake somewhere. Does anyone know what could have happened? I had my checks electronically sent per month.

P.S>I'd check my bank statements.. but my bank wants $30 per paper statement for every month prior to 2014....may have to do that.
Interest is paid in arrears so you put down $5,000 then accrued interest for however many days between close and the first of the month. Need more details to help you out but assuming you closed on Aug 1st and made the first payment at close on Aug 1st then you have been overpaying $11.34 a month because that first month's payment is actually additional down. Assuming all payments were constant your ending balance on 6-1-16 is $552.89 after the payment for that month is made.

If you closed on say Aug 15th with $5,000 down and a payment on Aug 15th of $638.91, again this is now additional toward principal because there has been no interest accrued yet, your interest accrued was only about $36.31 for the Sept payment meaning you over payed Sept by $48.70 but leaves the other months at $11.34 over and your closing balance at $510.82 on 6-1-16 after that month's payment.

If you do this again next time set the first payment a full month out it makes everything easier and is why banks do it. Like right now if you closed on a loan today you would prepay 21 or 22 days interest at close, should be 21 but I've seen a lenders include the day you close. Then your first payment would be on 5-1-16 and include all interest accrued during April, interest is paid in arrears (after it is accrued).
Reply With Quote Quick reply to this message
 
Old 03-10-2016, 07:40 PM
 
Location: Michigan
2,745 posts, read 3,017,461 times
Reputation: 6542
Quote:
Originally Posted by jackmichigan View Post
FOLLOWUP:

P.S. If you haven't received the Deed yet, I hope he has good title.


The seller in this case normally should provide a Warranty Deed, correct? How does a seller on a contract such as this create a Warranty Deed? If it was closed at a closing company, would they create the deed once the seller contacts them after it's paid off at the end of the 5 years?
Reply With Quote Quick reply to this message
 
Old 03-10-2016, 07:48 PM
 
Location: Boise, ID
8,046 posts, read 28,478,357 times
Reputation: 9470
If you have Excel, then download the free spreadsheet at:
Free Home Mortgage Calculator for Excel

Plug in your numbers to see for yourself where your money has gone and whether or not your loan should be all paid off.
Reply With Quote Quick reply to this message
 
Old 03-10-2016, 11:41 PM
 
8,574 posts, read 12,411,457 times
Reputation: 16533
Quote:
Originally Posted by MikeBear View Post
The seller in this case normally should provide a Warranty Deed, correct? How does a seller on a contract such as this create a Warranty Deed? If it was closed at a closing company, would they create the deed once the seller contacts them after it's paid off at the end of the 5 years?
What do you mean--how does a Seller "create" a Deed? It's the same as in any situation. Either the Seller writes one up with the correct information, or an attorney does so, or some other party such as a title company. It gets executed, with the signature(s) notarized, so the Deed can be recorded.

There are two basic ways of providing Seller financing. In one way, the Deed transfers at closing and the Seller literally takes back a mortgage to secure the loan, just like a bank would do. The other way, which is preferable to Sellers, is to enter into a Land Contract (aka Contract for Deed or other name, depending on the state; in Michigan, it's called a Land Contract). With a Land Contract, the Deed isn't conveyed until the contract is paid off in full. And, yes, a Warranty Deed would be best--and it should have been stipulated in the contract.

One of the biggest problems with Seller financing is that Buyers oftentimes don't do their full due diligence when they enter into the contract. They will often neglect to get title insurance or even research the title. Hopefully that isn't the case with the OP.
Reply With Quote Quick reply to this message
 
Old 03-15-2016, 04:20 PM
 
8,574 posts, read 12,411,457 times
Reputation: 16533
Did you figure things out yet?
Reply With Quote Quick reply to this message
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.

Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.


Reply
Please update this thread with any new information or opinions. This open thread is still read by thousands of people, so we encourage all additional points of view.

Quick Reply
Message:


Over $104,000 in prizes was already given out to active posters on our forum and additional giveaways are planned!

Go Back   City-Data Forum > General Forums > Real Estate > Mortgages

All times are GMT -6.

© 2005-2024, Advameg, Inc. · Please obey Forum Rules · Terms of Use and Privacy Policy · Bug Bounty

City-Data.com - Contact Us - Archive 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37 - Top