Results 1 to 8 of 8

Thread: Nifty Excel spread sheets

  1. #1
    Moderator IanF's Avatar
    Join Date
    Dec 2007
    Location
    Jhb
    Posts
    2,615
    Thanks
    191
    Thanked 520 Times in 398 Posts

    Nifty Excel spread sheets

    I was pointed to this site and they have some nifty spreadsheets. I downloaded the balloon finance one for vehicles and was impressed.
    Only stress when you can change the outcome!

  2. Thank given for this post:

    Dave A (03-Dec-08), Morticia (04-Dec-08), Vincent (03-Dec-08), Yvonne (02-Feb-09)

  3. #2
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,979
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    That led me on a merry dance. What I would really love to find is a loan calculator spreadsheet that could handle changes in interest rates during the term of the loan.
    The trouble with opportunity is it normally comes dressed up as work.

  4. #3
    Silver Member Vincent's Avatar
    Join Date
    Oct 2007
    Location
    Edenvale
    Posts
    337
    Thanks
    1
    Thanked 34 Times in 24 Posts
    Great site Ian, thanks.
    I came arcoss this site, Finance 3.0, a short while back. Forgot that I had registered until they send me a newsletter yesterday.

    Dave, you may find your calculator at this site.
    Vincent Marino
    Maximising the sales value of your business!

    Business 24-Seven |MyBlog Twitter |facebook |Phat feesh & chips






  5. Thanks given for this post:

    Dave A (04-Dec-08)

  6. #4
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,979
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    Thanks Vincent. I had a good look around but no luck. Found one that looked interesting but at R1450.00 or thereabouts, a bit steep for something I'm probably just going to pick through a bit. Mind you, thinking about it, I think I've got one of those fancy total analysis spreadsheets lying around on my laptop somewhere already.

    I think I'm going to take one of the standard amortization tables and hack it.

    The other way round is to start a new table with every rate change, but having all the data in one sheet is so much neater.
    The trouble with opportunity is it normally comes dressed up as work.

  7. #5
    Silver Member Vincent's Avatar
    Join Date
    Oct 2007
    Location
    Edenvale
    Posts
    337
    Thanks
    1
    Thanked 34 Times in 24 Posts
    Dave, let me look around, I may have a variable loan calculator.
    Vincent Marino
    Maximising the sales value of your business!

    Business 24-Seven |MyBlog Twitter |facebook |Phat feesh & chips






  8. #6
    Silver Member Vincent's Avatar
    Join Date
    Oct 2007
    Location
    Edenvale
    Posts
    337
    Thanks
    1
    Thanked 34 Times in 24 Posts
    Here another site that offers some amazing Financial excel spreadsheets,
    Vincent Marino
    Maximising the sales value of your business!

    Business 24-Seven |MyBlog Twitter |facebook |Phat feesh & chips






  9. #7
    Silver Member Vincent's Avatar
    Join Date
    Oct 2007
    Location
    Edenvale
    Posts
    337
    Thanks
    1
    Thanked 34 Times in 24 Posts
    I found this flexible mortgage calculator, don't know if it will help, may need a bit of manipulation.
    Attached Files Attached Files
    Vincent Marino
    Maximising the sales value of your business!

    Business 24-Seven |MyBlog Twitter |facebook |Phat feesh & chips






  10. Thank given for this post:

    Dave A (05-Dec-08), IanF (05-Dec-08)

  11. #8
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    20,979
    Thanks
    3,055
    Thanked 2,462 Times in 2,067 Posts
    Blog Entries
    12
    That's a great spreadsheet for anyone with a mortgage/bond!
    The trouble with opportunity is it normally comes dressed up as work.

Tags for this Thread

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •