{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":12,"n_cols":10,"rows_kept":12,"merged":[[7,4,7,6],[7,7,7,9]]}
[]
[null,null,"Inputs"]
[null,"Loan interest rate",{"v":0.05,"d":"5%"}]
[null,"HISA rate",{"v":0.05,"d":"5%"}]
[null,"Investment income",{"v":0.03,"d":"3%"}]
[null,"Investment growth",{"v":0.07,"d":"7%"}]
[]
[{"$nulls":4},"Stocks\n(selling at MTR:)",null,null,"Stocks with debt recycling\n(selling at MTR:)"]
[null,null,"HISA","Offset ",{"v":0.32,"d":"32%"},{"v":0.18,"d":"18%"},{"v":0,"d":"0%"},{"v":0.32,"d":"32%"},{"v":0.18,"d":"18%"},{"v":0,"d":"0%"}]
[{"v":0.32,"d":"32%"},{"$f":"\"After tax at \" & (A10*100) &\"%:\"","v":"After tax at 32%:"},{"$f":"HISAInterestRate*(1-A10)","v":{"v":0.033999999999999996,"d":"3.4%"}},{"$f":"LoanInterestRate","v":{"v":0.05,"d":"5%"}},{"$f":"InvestmentIncome * (1-$A10) + InvestmentGrowth * (1-(E$9 * 50%))","v":{"v":0.0792,"d":"7.9%"}},{"$f":"InvestmentIncome * (1-$A10) + InvestmentGrowth * (1-(F$9 * 50%))","v":{"v":0.08410000000000001,"d":"8.4%"}},{"$f":"InvestmentIncome * (1-$A10) + InvestmentGrowth * (1-(G$9 * 50%))","v":{"v":0.09040000000000001,"d":"9.0%"}},{"$f":"E10 + (LoanInterestRate * $A10)","v":{"v":0.0952,"d":"9.5%"}},{"$f":"F10 + (LoanInterestRate * $A10)","v":{"v":0.10010000000000001,"d":"10.0%"}},{"$f":"G10 + (LoanInterestRate * $A10)","v":{"v":0.10640000000000001,"d":"10.6%"}}]
[{"v":0.39,"d":"39%"},{"$f":"\"After tax at \" & (A11*100) &\"%:\"","v":"After tax at 39%:"},{"$f":"HISAInterestRate*(1-A11)","v":{"v":0.0305,"d":"3.1%"}},{"$f":"LoanInterestRate","v":{"v":0.05,"d":"5%"}},{"$f":"InvestmentIncome * (1-$A11) + InvestmentGrowth * (1-(E$9 * 50%))","v":{"v":0.0771,"d":"7.7%"}},{"$f":"InvestmentIncome * (1-$A11) + InvestmentGrowth * (1-(F$9 * 50%))","v":{"v":0.082,"d":"8.2%"}},{"$f":"InvestmentIncome * (1-$A11) + InvestmentGrowth * (1-(G$9 * 50%))","v":{"v":0.0883,"d":"8.8%"}},{"$f":"E11 + (LoanInterestRate * $A11)","v":{"v":0.0966,"d":"9.7%"}},{"$f":"F11 + (LoanInterestRate * $A11)","v":{"v":0.1015,"d":"10.2%"}},{"$f":"G11 + (LoanInterestRate * $A11)","v":{"v":0.1078,"d":"10.8%"}}]
[{"v":0.47,"d":"47%"},"After tax at 47%:",{"$f":"HISAInterestRate*(1-A12)","v":{"v":0.026500000000000003,"d":"2.7%"}},{"$f":"LoanInterestRate","v":{"v":0.05,"d":"5%"}},{"$f":"InvestmentIncome * (1-$A12) + InvestmentGrowth * (1-(E$9 * 50%))","v":{"v":0.0747,"d":"7.5%"}},{"$f":"InvestmentIncome * (1-$A12) + InvestmentGrowth * (1-(F$9 * 50%))","v":{"v":0.0796,"d":"8.0%"}},{"$f":"InvestmentIncome * (1-$A12) + InvestmentGrowth * (1-(G$9 * 50%))","v":{"v":0.0859,"d":"8.6%"}},{"$f":"E12 + (LoanInterestRate * $A12)","v":{"v":0.09820000000000001,"d":"9.8%"}},{"$f":"F12 + (LoanInterestRate * $A12)","v":{"v":0.1031,"d":"10.3%"}},{"$f":"G12 + (LoanInterestRate * $A12)","v":{"v":0.1094,"d":"10.9%"}}]