Financial Investment Portfolio Planner

PPOR mortgage · investment property · shares · offset-adjusted model  v2

PPOR —%
INV —%
Tax —%
Starting Balances, Rates & Portfolio
Loan Settings
PPOR Starting Loan PPOR
$
Starting Offset
$
PPOR Remaining Term PPOR
yrs
PPOR Interest Rate PPOR
%
Investment Rate INV
%
Marginal Tax Rate TAX
PPOR Current Value PPOR
$
PPOR Growth Rate PPOR
%
Rate Stress Test +x% on both loans
50% discount on gain — applies to property & shares
%
used to index cost base from purchase to sale date
PPOR Monthly Repayment /month auto-calculated
Offset Account Inputs
Annual Profit / Loss
Income − Life Expenses user-editable · income after tax, minus living costs · excludes mortgage & investments
Income − Life Expenses total
PPOR Mortgage auto · annual repayment from offset · adjusts with loan settings
Net Surplus (after mortgage)
Cash Position starting offset + income − mortgage − to shares + investment + tax + sale proceeds
Wealth Accumulation
Share Portfolio
Disabled
PPOR Loan
End of 2036
Investment Loan
End of projection
Offset Balance
End of 2036
PPOR Value
End of 2036
Inv. Property Value
End of 2036
Total Interest Paid
Both loans combined
Total Tax Refunds
Net tax impact to offset
Total Portfolio Value
PPOR + Investment − All debt
Net Position — End of 2036
PPOR Loan
Inv. Loan
Total Debt
Offset
Balance & Value Trajectory
Loans · Offset · Property Values · Effective Debt
PPOR Loan
Inv. Loan
Offset
PPOR Eff. Debt
Combined Debt
PPOR Value
Inv. Value
Share Portfolio
PPOR Repayments
Principal vs Interest Split
Investment Property Cashflow
Repayment + Running Costs vs Rental Income
Year-by-Year Breakdown