 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / March 2008How to calculate my mortgage payments interest part?
Hi there, I'd like to know how much of my mortgage payment is interest and how much is principle. I know my interest rate and how much I borrowed (ofcourse!) and how much I pay each month but am wondering how to figure out what part goes on the interest. Is this possible to do in Excel.? Tx Suzannne For the interest in a specific payment: Use the IPMT function For the interest paid during a specific range of payments: Use the CUMIPMT function Both are fairly well documented in Excel Help. Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) > Hi there, > [quoted text clipped - 10 lines] > > Suzannne yes it's possible as Ron explained. however, if this is other than a learning experience (gee wiz), I recommend ensuring you get the annual tax statement from your mortgager as required by law for your tax break purposes. > Hi there, > [quoted text clipped - 10 lines] > > Suzannne A> learning experience (gee wiz), I recommend ensuring you get the annual tax > statement from your mortgager as required by law for your tax break > purposes. As required by law in which country? > yes it's possible as Ron explained. however, if this is other than a > learning experience (gee wiz), I recommend ensuring you get the annual tax [quoted text clipped - 15 lines] > > > > Suzannne > Hi there, > [quoted text clipped - 8 lines] > > Suzannne Ask your lender for a loan amortization. It should give you a break out of interest and principal by payment for the term of the loan. My bank actually shows those two amounts on each payment I make. If your bank has online banking you might check there for the info. gls858 Download the Loan Amortization Template from the Template Gallery. http://office.microsoft.com/en-us/templates/TC010197771033.aspx?pid=CT101172751033 >> Hi there, >> [quoted text clipped - 15 lines] > >gls858
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.