Spreadsheet: 94601d1294365712-charting-time-series-based-on-different-scenarios-_keith-charting-sample
Sheet: House Buyout Options

 | House Price |  | Comments |  |  | Costs (possibly shared)
 | Initial Property Price | 317000 |  |  |  | Stamp Duty | 12922 | (may be proportioned depending on options)
 | Outstanding | 224876.03 | Confirmed @ 1/03/2009 |  |  | Costs - Owe Parents
 | Est mk value | 480000 |  |  |  | Remaining portion of car | 14896
 |  |  |  |  |  | Couch | 850
 | Contribution Patricia & Keith |  |  |  |  | Dining Table + extra $50 | 600
 | Borrowed | 250000 |  |  |  | Car Rego | 209
 | First Home Grant | 7000 |  |  |  | Paint | 1000
 | Total Contribution |  |  |  |  | Microwave | 220
 |  |  |  |  |  | Washing machine | 730
 | Contribution Cindy & Lawrence |  |  |  |  | Delivery for the 3 pieces furniture | 130
 | Cheque at settlement | 51641.88 |  |  |  | [NAME] @ approx 50 each | 350
 | Deposit paid during offer./accepttence time | 10000 |  |  |  | Fridge | 790
 |  |  |  |  |  | Mics | 400
 |  |  |  |  |  | Settlement costs | 450
 | Check
 | Parents Contribution |  |  |  |  | Total
 | Patricia & Keith Contribution
A) | With each party having a Share in the property, [NAME] and [NAME] 50/50
 | Person | % share in property | $ share of estimated mk value | Net/Equity share | Equity % of [NAME] value
 | [NAME]
 | [NAME]
 | Parents Share
 |  |  | Total equity share
 |  |  | Total Debt
 |  |  | Estimated Value Check
 |  |  | Pay Patricia
 |  |  | Parents
 |  |  | Half of debt to Parents
 |  |  | Share in stamp duty
 |  |  | Share in house
 |  |  | Pay Parents
 |  |  | Total Buyout
 |  |  | Keith New Loan Total
 |  |  | Keith Equity Share Check
B) | With [NAME] and lawrence being paid back interest for debt, [NAME] and [NAME] 50/50
 | Person | % share in property | $ share of estimated mk value | Net/Equity share | Equity % of [NAME] value
 | [NAME] | 0.5
 | [NAME] | 0.5
 |  |  | Total equity share |  |  |  | Rate | 0.03
 |  |  | Total Debt
 |  |  | Estimated Value Check |  |  | Year | Interest | Balance
 |  |  | Pay Patricia |  |  | 2005
 |  |  |  |  |  | 2006
 |  |  | Parents |  |  | 2007
 |  |  | Pay parents |  |  | 2008
 |  |  | Total Buyout |  |  | Total
 |  |  | Keith New Loan Total
 |  |  | Keith Equity Share Check
C) | Proportioned based on financial contribution of each party
 |  |  | % share in property based on contribution
 |  | Year | [NAME] | [NAME]
 |  | 2005
 |  | 2006
 |  | 2007
 |  | Average (perhaps not entirely accurate for this, but an idea)
 | Person | % share in property | $ share of estimated mk value | Net/Equity share | Equity % of [NAME] value
 | [NAME]
 | [NAME]
 | Parents Share
 |  |  | Total equity share
 |  |  | Total Debt
 |  |  | Estimated Value Check
 |  |  | Pay Patricia
 |  |  | Parents
 |  |  | Half of debt to Parents (inc int)
 |  |  | Share in stamp duty
 |  |  | Share in house
 |  |  | Total Owe Parents
 |  |  | Total Buyout
 |  |  | Keith New Loan Total
 |  |  | Keith Equity Share Check
D) | With [NAME] and lawrence being paid back interest for debt, [NAME] and [NAME] proportioned based on financial contribution
 |  |  | % share in property based on contribution
 |  | Year | [NAME] | [NAME]
 |  | 2005
 |  | 2006
 |  | 2007
 |  | Average (perhaps not entirely accurate for this, but an idea)
 | Person | % share in property | $ share of estimated mk value | Net/Equity share | Equity % of [NAME] value
 | [NAME]
 | [NAME]
 |  |  | Total equity share |  |  |  | Rate | 0.03
 |  |  | Total Debt
 |  |  | Estimated Value Check |  |  | Year | Interest | Balance
 |  |  | Pay Patricia |  |  | 2005
 |  |  |  |  |  | 2006
 |  |  | Parents |  |  | 2007
 |  |  | Total Owe Parents |  |  | 2008
 |  |  | Total Buyout |  |  | Total
 |  |  | Keith New Loan Total
 |  |  | Keith Equity Share Check