Loan Calculator: 75% principal-only + 25% interest-only (with House Appreciation + Market Alternative)

Phase-1: repay equal principal monthly (interest is calculated on reducing balance and accumulated).
Phase-2: repay the total accumulated interest in equal monthly installments.
Extra: estimate final house value (appreciation) and market investment alternative (CAGR).

Inputs
House appreciation
Keep Initial House Value = Loan Amount
If you choose % per month, values will explode quickly (12%/month is extremely high). Calculator will still compute it.
Market alternative
Converted internally to monthly compounding: (1+CAGR)^(1/12)-1
Model note: Phase-1 monthly deduction is principal only (as per your scheme). Interest is only calculated & accumulated, then paid in Phase-2.
Results
Phase-1 (Principal period)
Phase-2 (Interest period)
Monthly Principal in Phase-1
Constant each month in Phase-1.
Monthly EMI in Phase-2 (Interest only)
Constant each month in Phase-2.
Total Interest Accumulated in Phase-1
Paid during Phase-2.
Total Paid Over Entire Tenure
Final House Value (after total duration)
Market Alternative: Final Portfolio Value
Difference: House Value − Market Portfolio
Positive means house final value is higher than market portfolio (based on your inputs).
Total Contributions into Market Alternative
This equals total outflow you would have paid under this loan model.
Show first 12 months + last 6 months (snapshots)