Mortgage principal calculation
graywings123
4 years ago
Featured Answer
Sort by:Oldest
Comments (36)
maifleur01
4 years agoElmer J Fudd
4 years agoRelated Discussions
Principal residence
Comments (19)So you've got everybody going around in circles because you have an idea fixed in your head and you only want to hear what you think the answer should be. But what the heck, if you want to take the risk who are we to gainsay you? The IRS requires a primary residence be defined as living and owning 2 years out of the last 5 yrs, to the exact day, at that address. Proof is defined as a clear paper trail, involving drivers licenses, utility bills, and any other "formal" documents. A link I found gives this answer in more detail, and I excerpted part of it, below: Articles by Ilyce: What Makes Your Home A Primary Residence REM #F663 By Ilyce R. Glink Summary: A reader has purchased a home for their future retirement. They would like to designate their new home as their primary residence. Ilyce explains what the IRS will look at to determine what home is the primary residence. Q: We just purchased a house for future retirement use and declared it not a primary residence during the transaction. We would like to know how we can change it to the primary residence while still keeping our current residence. Thanks. A: You can only have one primary residence at a time. Simply declaring to the world that your new home is actually your primary residence isnÂt quite enough. You actually have to live there for a majority of each year. If you're ever audited, the IRS will look up your phone records, bills paid, whether you voted in that district, and other things that would indicate how much time you spent in the new home. You would also have to file your income taxes listing the new home as your primary residence. When you're ready to retire to this property, that's the time you should make it your primary residence. That way, you protect your ability to take the IRS capital gains exclusion for your current property, which amounts to taking the first $250,000 in profits tax-free (up to $500,000 if you're married). But you only get this as long as you've lived in the house for 2 of the last 5 years, and haven't used the exclusion in the past 24 months. Here is a link that might be useful: Determining a Primary Residence...See MoreHow long will it take me to pay off this mortgage
Comments (9)Using those figures, Quicken sez the loan originally would have ended 4/1/18 with a payment of $1235 (seems a month too soon, but whatever). Paying $100 extra on payments 1-24, then $200 extra on paments 25-36 (you say that $200 was "for the last year", so I'm thinking that is June 06 to May 07, Quicken sez the balance now should be 149,425 (pretty close to your 150,000). So the numbers aren't lining up exactly - depends partly on the gap between the closing and the first payment... but close enough. If you went back to the $1549 starting with the June payment, Quicken sez you'd end September 2017 with a last payment of $976, 7 1/2 months ahead of the original loan schedule. (=11,600 less in payments in exchange for that 6,000 prepaid to date. If you keep prepaying $200 as is your plan, Quicken sez your last payment will be in March 2016 for $1439, just over two years ahead of schedule. (= 39,000 in payments saved in exchange for the 25,000 you are prepaying over the life of the now roughly 13 year loan). Folks will argue you should keep the mortgage and invest that $200. There are ways to have it drafted and making it hard to get to. Most certainly you should consider investing instead if you have not maxed out your tax deferred retirement options. Unlike a "rainy day" fund, tht money would be pretty hard to get to. (And I say this as someone who did choose to prepay a 4.75% mortgage! Every situation is different.)...See MorePaying back mortgage confusion
Comments (21)Any bank that says that an extra payment is just paying next month's payment now is scamming you. They get all of that money free for a month ... cause you don't owe that money to them until a month from now! If you have $100,000. mortgage at 5%, you owe them $100,000. for only the first month. The interest owed for that month will be 5% of that, or $5,000., divided by 12 if you pay monthly, or by 26 if you pay bi-weekly (which will pay it off more quickly, there being a couple of extra payments per year). On monthly pay, your debt would be 5,000. divided by 12, or $466.67. I don't know the amortization figure that would mean that, on a 25 year mortgage, you'd have all of the debt paid in full by paying the same amount, month by month, throughout that 25 years. Suppose it might be $500.00 ... which would mean that, having paid the interest of that $416.67 on the $100,000. mortgage, there's $83.33 left from that payment to pay down the principal ... which becomes the new amount of $100,000. - $83.33, or $99,916.67. The interest owing on that amount for the second month will $416.31945, or $416.32, leaving $83.68 to pay down the principal. In the third month, with $99,832.99 still owing, the interest cost will be ... Sorry - my calculator just quit, and can`t make the one on the computer do what I want it to ... and the library is closing in 10 minutes. Another reason, apart from the price of gas and time ... to get my home computer hitched to the public! You can see how, as the interest to be paid on the remaining principal drops month by month, the amount of principal that gets repaid monthly grows. If you can make one extra payment per year, to reduce the principal owing by all of that amount, it could well be as much or close to it as your monthly payments had reduced that principal through the whole year. Good wishes for making a good mortgage. ole joyful...See MoreSomewhat Mortgage Related-Amortization Schedule?
Comments (7)Hi Cathrugg, I have searched high and low on the internet without being able to find a spreadsheet that allows for manipulation of the principal payment dates (they all make it payable with the regular due date only). This is because any such calculator would be futile. American mortgage loan payments are booked once a month regardless when the payments are sent in (as long as they arrive prior to the late-cutoff deadline.) Only revolving credit (including HELOCs) have their payments applied toward interest-accruing balances daily (again, in the U.S.) Does anyone have or know where I can find an amortization schedule for a mortgage loan that allows me to input random principal payments on dates different from the payment due date? If you'd like to see the effect of differing additional principal payments month-to-month (as opposed to a daily basis,) I can help you with THAT... just email me directly and I'll bounce one right back to you. For example, if the loan payment is due on the 1st of every month and is paid by automatic payment, then I decide to pay an extra $250 on the 7th of this month and then another $750 on the 25th of next month, is there a way to calculate the interest I am saving? SO... if you are *REALLY* committed to doing this... the way to do it is to "pay the extra" into an interest-bearing depository account (checking, savings, or other,) and figure the compounding POSITIVE growth of your money... and then subtract it against the negative interest burden you are carrying on your mortgage. Make sense? Hope that's helpful (and you are completely welcome for any way I could have helped before... your appreciation is appreciated!) Cheers, Dave Donhoff Leverage Planner...See MoreAnnie Deighnaugh
4 years agolast modified: 4 years agograywings123
4 years agokillerv
4 years agoAnnie Deighnaugh
4 years agograywings123
4 years agolast modified: 4 years agosushipup1
4 years agokillerv
4 years agoAnnie Deighnaugh
4 years agograywings123
4 years agomaifleur01
4 years agosushipup1
4 years agoElmer J Fudd
4 years agolast modified: 4 years agoElmer J Fudd
4 years agoElmer J Fudd
4 years agoUser
4 years agograywings123
4 years agomaifleur01
4 years agoElmer J Fudd
4 years agolast modified: 4 years agograywings123
4 years agolast modified: 4 years agomaifleur01
4 years agonicole___
4 years agosushipup1
4 years agolast modified: 4 years agomaifleur01
4 years agoElmer J Fudd
4 years agomaifleur01
4 years agosushipup1
4 years agoElmer J Fudd
4 years agomaifleur01
4 years agolast modified: 4 years agoUser
4 years agoWalnutCreek Zone 7b/8a
4 years agoElmer J Fudd
4 years agomaifleur01
4 years agolast modified: 4 years agoElmer J Fudd
4 years ago
Related Stories
MOVING9 Things New Homeowners Know to Be True
Just moved into a new home? Congratulations! The fun is about to begin
Full StoryDESIGNING A BUSINESSHow to Make Sure You Cover All Your Costs
Interior design coach Beth Whitlinger discusses how to create a realistic estimate when scoping a new project
Full StoryDECORATING GUIDESHouzz Tour: A Historic House Gets a Feng Shui Adjustment
In a Massachusetts seaside town, a traditional home is redecorated in a playful style and with attention to flow and balance
Full StoryCONTEMPORARY HOMESHouzz Tour: Strong, Modern Lines Stand Up to the Trees
Modernism takes kindly to the New York woods, with double-height ceilings for openness and a burbling creek for music
Full StoryCOLORFUL HOMESMondrian Inspires a Modern Addition
Primary colors and special glass are just the start of what makes this San Francisco home a case study in artistry
Full StoryHOUZZ TOURSMy Houzz: Sleek Lines and Innovations in Portland
Behind these airy, contemporary interiors lie high-tech systems that lower utility costs while keeping the family comfortable
Full StoryHOUZZ TOURSHouzz Tour: Modern, Ecofriendly Prefab in Seattle
Green materials and a connection with nature help this prefab house, and the family who lives there, tread lightly on the earth
Full StoryHOUZZ TOURSHouzz Tour: Schoolhouse-Turned-Home in Chicago
A family of seven settles into a dream modern-industrial home that reflects both their green philosophy and their fun, casual lifestyle
Full StoryINSIDE HOUZZData Watch: Confidence in the Renovation Industry High but Softening
The Q2 2016 Houzz Renovation Barometer indicates builders and remodelers are feeling good about the industry, designers slightly less so
Full StoryWOODKnotty and Nice: Highly Textured Wood Has a Modern Revival
Whether it's cedar, fir or pine, if a wood has a knot, it's hot
Full Story
sushipup1