📨 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!

Statement of intent

134689124

Comments

  • StuartGMC
    StuartGMC Posts: 2,175 Forumite
    As noted before, was considering what to do in view of increasing overpayment vs. present scenario on prices (and the need to think about gas & electric rises in the autumn). I thought I'd look back at typical interest charged recently to get another "incentive" to keep up offset.

    June 2007 - Mortgage Interest £87.76 (we then paid for the annual holiday....)
    September 2007 - £109.47 (less offset and increasing mortgage rates)
    January 2008 £81.78 (increased savings so despite increasing interest rates reduced monthly interest)
    June 2008 £49.83

    So it does make a demonstrable difference.

    I then decided that as of today, we will pay in the same as the interest we are charged each month, in addition to the present 40% overpayment. Not much, but we won't incur interest on this interest...
    £49.83 dropped in tonight.
  • StuartGMC
    StuartGMC Posts: 2,175 Forumite
    Just had the quarterly update on the offset; we've saved £1089.10 just by offsetting since June 2006. This is equivalent to 4.6% of our remaining capital owing :j

    I've updated my signature to record this and the present offsetting (57%) to give an equivalent mortgage rate of 2.75% (based on the increase which will apply from 7 July). This will improve slightly at the end of the month when my pay is received, but, mid July it will not be so good with holiday cost on the credit card. However, whilst this cost was £3000, looking at the current account, I hope only to have to call on £1500 from the monies saved to be able to cover it plus other high spend I've mentioned already. So actually looking at it this way, it is not quite so bad.

    I've also made the commitment in the signature to the overpayment (40%) plus interest charges each month. Hope to keep to this plan which would put our overpayment at about 55% each month.:rolleyes:
  • StuartGMC
    StuartGMC Posts: 2,175 Forumite
    setmefree2 wrote: »
    For what it's worth, IMHO, you should keep hold of redundancy insurance, for peace of mind if nothng else.:cool: Good Luck with analysing the food shopping.:D

    SMF2 and Kassytbag, thanks for the thoughts. I've tended to think this throughout the mortgage term, but have decided not to add up the cost of this peace of mind! :eek:

    Regarding the shopping, I think I'll do the same as the page for petrol; something like
    Date | Spend | Where | Food | Cleaning | Others (utensils etc) |
    then I think we'll record efforts to reduce spend alongside, I have in mind listing the item | original cost | alternative| alternative cost | saving | annual saving | acceptable?

    The last one is important to record too, because if we don't think the product is acceptable, then at least we know we tried and we accept a £0.00 saving value. :rolleyes:

    I can then get some trending and reflect this in the monthly cost allocation in the spreadsheet, rather than the fixed value entered now. So the estimate will be more accurate and we can see where costs are accruing and where savings are being made :j
  • StuartGMC
    StuartGMC Posts: 2,175 Forumite
    Well, the spreadsheet was updated not just for Food, Toiletries, Cleaning etc, but I also added a sheet for our Clothing and Shoes purchases. (I've also done this on the blank spreadsheet so it's there for others who ask for it in future).

    Downloaded credit card statement for the period early Feb to date, then it was a quick autofilter to start sorting the historic spend for clothing and shoes. I was pleasantly surprised to find it £20 less than my monthly estimate so felt quite chuffed about the initial guess. Now, I will have accurate data feeding the sheet. Just need to collate data in future which shouldn't be too much effort.

    The Grocery shopping has been entered from the last couple of weeks, simply splitting out Toiletries & Cleaning items etc from the total leaving the food spend (which includes my beer - not had the guts yet to look at that as a line item alone :o )

    Once we have a couple of months of data this can then feed live to the main sheet, but for now it will distort things somewhat. I think this area will need more effort than petrol and clothing but it represents a significant portion of expenditure so the effort is required. I have popped over to the Supermarket article etc, and some interesting things to adopt there in addition to our present good habits, 15% reduction on the monthly cost would be great! http://www.moneysavingexpert.com/shopping/cheap-supermarket-shopping

    I hope that capturing actual data for petrol, groceries and clothing, in addition to the known spend (direct debits, annual items etc) will give a more confident position. I just need to review the "Ancillary Costs" item to see if I can track back on it, and (guiltily) need to monitor whether £50 per month is my pub spend or a gross underestimate.... :beer: :o
  • StuartGMC
    StuartGMC Posts: 2,175 Forumite
    Forgot to note that we got about £180 from HMRC once OH had advised them of her professional membership costs and new tax code from now on. See details on the MFW what you've done today (or in my case, back in March....)

    http://forums.moneysavingexpert.com/showthread.html?p=11909213&posted=1#post11909213

    Always nice to get something back from the tax man :D
  • elantan
    elantan Posts: 21,022 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    ok spread sheets...now i am sure i have your mortgage one and have to admit i am addicted i even mess about with the numbers putting in what i dream i can afford can i ask what other ones you use? and can i have a copy? i have some isa's and some savings accounts but i think it would be handy to be able to have a place that keeps them all ...also shopping and spends hmmmm do you keep a note of everything?


    anyhoo thanks for the diary am loving reading them on here they seem a relatively new (but very welcome) addition to the mfw board am loving reading your plans and stories
  • StuartGMC
    StuartGMC Posts: 2,175 Forumite
    My spreadsheet is actually more of a budgeting one than one for calculating mortgages (there are plenty of the latter around and I'm not an expert on them). PM your e-mail address and I'll send it over either as OpenOffice or Excel.
    Note: presently lost opportunity cost from loss of interest on savings isn't in there, but it'll require some thought on incorporation.

    In terms of keeping notes on spend, well, petrol is once a week just have to ask for receipt for the fuel volume and to note mileage (note economy reading in the car is consistently 1.5mpg or so better than my calcs on distance driven and fuel put in the tank).

    Clothing again, should not be too difficult as these are infrequent.

    The Groceries will be the challenge especially small bits ad hoc wise. I don't want to split out to individual items for obvious reasons, but breaking down on food (ie things consumed) vs toiletries and cleaning, seems easy enough - a quick glance down the receipt and mark the latter (usually fewer items), add up to give that value and substract from spend to give food.
  • setmefree2
    setmefree2 Posts: 9,072 Forumite
    Mortgage-free Glee!
    StuartGMC wrote: »
    so we bought 72 bottles of wine with free delivery in September. Only problem is last few remain now, so we'll need to actual pay for more!

    Also of concern, 95% of the alcohol is for me (love real ale!) and I can already see where pressure will apply for savings.... :o
    (ponders "fixing" spreadsheet.... :D to overcome this "problem")

    LOL:rotfl::rotfl:There is no hiding from the spreadsheet. The truth is there staring us in the face every month:cool:
  • StuartGMC
    StuartGMC Posts: 2,175 Forumite
    setmefree2 wrote: »
    LOL:rotfl::rotfl:There is no hiding from the spreadsheet. The truth is there staring us in the face every month:cool:

    Not quite, I know how to hide rows and columns :o
  • elantan
    elantan Posts: 21,022 Forumite
    Part of the Furniture 10,000 Posts Photogenic Name Dropper
    i have been using my amex card for the last few months on diesel spending and food shopping as i get the 1% back at the end of the year ...however i havnt been noting how much i am spending and i think i am over budget will deff be adding it to a spread sheet i think ...it will be a good way for me to work stuff out ...thanks very much
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.6K Banking & Borrowing
  • 253K Reduce Debt & Boost Income
  • 453.3K Spending & Discounts
  • 243.6K Work, Benefits & Business
  • 598.3K Mortgages, Homes & Bills
  • 176.7K Life & Family
  • 256.7K 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.