Debate House Prices


In order to help keep the Forum a useful, safe and friendly place for our users, discussions around non MoneySaving matters are no longer permitted. This includes wider debates about general house prices, the economy and politics. As a result, we have taken the decision to keep this board permanently closed, but it remains viewable for users who may find some useful information in it. 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!

Calculate whether buying financial makes sense for you

Options
I've knocked together a spreadsheet which attempts to calculate whether buying a house makes financial sense. It takes account of: your budget (initial and monthly); mortage, solicitors and other fees (including the cost of remortgaging on a regular basis); insurance and maintenance; rental costs; inflation; extra commuting costs that might result. You specify the timeframe and the spreadsheet tells you how much better/worse off you would be in various house price inflation scenarios. You can find it at: http://www.mediafire.com/?dydemz9nngg If any of you do try it, I'd be grateful for suggestions for improvements. Thanks.

Comments

  • oranger
    oranger Posts: 16 Forumite
    Great effort! Couldn't quite work out what you meant by "initial period" how can you adjust this?

    Might also be good for you to be able to enter the figures as they stand for you personally - ie I know how much mortgage I am going for and the exact figures for deposit - rather than it trying to work it out for you.
  • WilfB
    WilfB Posts: 13 Forumite
    Part of the Furniture Combo Breaker
    Good point about the 'initial period'. It's the value you put in cell B39 to show the number of years you want to do the comparison over. Once I've had a few more comments, I'll put up a new, clearer version.I'm less sure about your second comment. How do you know the value of the house and the deposit? I'm working on the principle that the figures to start with are the cash you have available and the cash you'll have per month from then onwards, and that the value of the house you buy will depend on those. It seems to be the right way around for me. I'll wait for a few more comments on that one before doing anything.Thanks, Oranger
  • oranger
    oranger Posts: 16 Forumite
    Ah thanks - that makes sense. I took that to mean mortgage over 25 years. Numbers seem to make much more sense now!

    I think you're right about it working out how much money is available automatically!

    Many thanks
  • WilfB
    WilfB Posts: 13 Forumite
    Part of the Furniture Combo Breaker
    You're welcome. Keep the suggestions coming.
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.