Spreadsheet for Vendor Finance

Viewing 7 posts - 1 through 7 (of 7 total)

bjcampb
Participant
@bjcampb
Join Date: 2012
Post Count: 24
October 7, 2012 - 11:17 pm
Hi There
i was wondering if anyone had a spreadsheet they could send me which works out the repayment schedule eg how much they have paid per month , how much they owe, etc
I tried to do one up on excel but i am not good at working out the formulas.
Cheers
Belinda
Terryw
Participant
@terryw
Join Date: 2001
Post Count: 16,213
October 8, 2012 - 12:02 am
There is a template in excel. Search on "amortization"
Terryw | Structuring Lawyers Pty Ltd / Loan Structuring Pty Ltd
http://www.Structuring.com.au
Email Me
Lawyer, Mortgage Broker and Tax Advisor (Sydney based but advising Aust wide) http://www.Structuring.com.au
Paul Dobson
Participant
@pauldobson
Join Date: 2003
Post Count: 1,196
October 26, 2012 - 12:17 am
This is a pretty good one: http://virginmoney.com.au/home-loans/calculators/amortisation-calculator/
Cheers, Paul
Paul Dobson | Vendor Finance Institute
http://www.vendorfinanceinstitute.com.au
Email Me | Phone Me
An alternative way to finance your home.
Coota
Participant
@coota
Join Date: 2012
Post Count: 49
October 26, 2012 - 10:48 am
Anyone else like to share their spreadsheets in general?.
Regards
Michael
Paul Dobson
Participant
@pauldobson
Join Date: 2003
Post Count: 1,196
October 28, 2012 - 2:52 am
It's not free but we do sell a vendor finance calculator that originally came from an excel spreadsheet. A video on how it works is at: http://www.negative2positivecalculator.zreply.com/
Cheers, Paul
Paul Dobson | Vendor Finance Institute
http://www.vendorfinanceinstitute.com.au
Email Me | Phone Me
An alternative way to finance your home.
Freckle
Blocked
@freckle
Join Date: 2012
Post Count: 1,680
October 28, 2012 - 10:11 am
The 6 links below are PI spreadsheets I've picked up over the years and one I've recompiled myself. They range from simple to complex. Use at your own risk.
Click the link, go to ….FILE / DOWNLOAD
Note: tax formula and stamp duty are out of date
https://docs.google.com/open?id=0Bw10nVvomrvSTTF1TWlKa0cwLWs
https://docs.google.com/open?id=0Bw10nVvomrvSUVROSU11Z19lMFE
https://docs.google.com/open?id=0Bw10nVvomrvSVWxEVC1heU5SUEE
https://docs.google.com/open?id=0Bw10nVvomrvSazFNbmUwSmd3bEk
https://docs.google.com/open?id=0Bw10nVvomrvSclJtTXU5ay1LcWM
https://docs.google.com/open?id=0Bw10nVvomrvSdHIwckNQN2xhWE0
if you have problems with these email me and I'll forward them direct
Coota
Participant
@coota
Join Date: 2012
Post Count: 49
October 28, 2012 - 11:36 am
Freckle,
Thanks for your sharing of your spreadsheets as I am hopeless with Excel formula's
Cheers
Coota