PLEASE READ BEFORE POSTING: Hello Forumites! In order to help keep the Forum a useful, safe and friendly place for our users, discussions around non-MoneySaving matters are not permitted per the Forum rules. While we understand that mentioning house prices may sometimes be relevant to a user's specific MoneySaving situation, we ask that you please avoid veering into broad, general debates about the market, the economy and politics, as these can unfortunately lead to abusive or hateful behaviour. Threads that are found to have derailed into wider discussions may be removed. Users who repeatedly disregard this may have their Forum account banned. Please also avoid posting personally identifiable information, including links to your own online property listing which may reveal your address. Thank you for your understanding.
We're aware that some users are experiencing technical issues which the team are working to resolve. See the Community Noticeboard for more info. Thank you for your patience.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!

how to calculate interest and principal on part and part mortgage

Options
Hiya,

I know you can get loan amortiation spreadsheets in excel but these only allow you to work out if you were doing full repayment.

If I were paying interet only on a portion of my mortgage and repayment on the rest, how do I work out how much of my monthly payment is interest and how much is repayment?

Thanks

Comments

  • jjlandlord
    jjlandlord Posts: 5,099 Forumite
    You use the spreadsheet on the part that is repayment, this gives you how much is interest and how much is capital on that part.
    The other part is obviously interests only.
  • mysti77
    mysti77 Posts: 80 Forumite
    but I don't repay on the full amount. e.g. my total loan amt is 160,000 but I only do repayment on 15,000 and the rest is interest only.
  • jjlandlord
    jjlandlord Posts: 5,099 Forumite
    Yes, that's why I suggested that you can use the standard Excel sheet you mentioned on the £15k, which will give you the monthly capital repayments and interest on this amount.
    Considering that the rest is interest only you have your answer so as to how much of the total monthly payments are capital repayments.
  • DVardysShadow
    DVardysShadow Posts: 18,949 Forumite
    mysti77 wrote: »
    but I don't repay on the full amount. e.g. my total loan amt is 160,000 but I only do repayment on 15,000 and the rest is interest only.

    Then do what he said:
    jjlandlord wrote: »
    You use the spreadsheet on the part that is repayment [£15000], this gives you how much is interest and how much is capital on that part.
    The other part is obviously interests only [£145000].
    You didn't really need me to do that did you?
    Hi, we’ve had to remove your signature. If you’re not sure why please read the forum rules or email the forum team if you’re still unsure - MSE ForumTeam
This discussion has been closed.
Meet your Ambassadors

🚀 Getting Started

Hi new member!

Our Getting Started Guide will help you get the most out of the Forum

Categories

  • All Categories
  • 350.8K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.5K Spending & Discounts
  • 243.8K Work, Benefits & Business
  • 598.6K Mortgages, Homes & Bills
  • 176.8K Life & Family
  • 257K Travel & Transport
  • 1.5M Hobbies & Leisure
  • 16.1K Discuss & Feedback
  • 37.6K Read-Only Boards

Is this how you want to be seen?

We see you are using a default avatar. It takes only a few seconds to pick a picture.