"""Independent Decimal reference for the public Australian loan comparisons. Usage: python scripts/check_au_comparison_reference.py [cases.json] Uses only Python's standard library. No production code, lender connection, borrower data or account access. Cases are fictional checks of the published monthly model, not professional review or reconciliation to a bank statement. """ from decimal import Decimal as D, ROUND_HALF_UP, getcontext import json from pathlib import Path import sys getcontext().prec = 50 ROOT = Path(__file__).resolve().parents[1] def rounded(value): return int(D(value).to_integral_value(rounding=ROUND_HALF_UP)) def cents(value): return rounded(D(value) * 100) def payment(principal, rate_percent, months): rate = D(rate_percent) / 1200 return rounded(D(principal) / months if not rate else D(principal) * rate / (1 - (1 + rate) ** -months)) def offer(fields, prefix, months=None): return { 'base': cents(fields['loan']), 'months': months or (12 * int(fields['years']) + int(fields.get('months', '0'))), 'rate': D(fields[prefix + '_rate']), 'cash': cents(fields[prefix + '_cash_fee']), 'financed': cents(fields[prefix + '_financed_fee']), 'monthly': cents(fields[prefix + '_monthly_fee']), 'annual': cents(fields[prefix + '_annual_fee']), 'offset': cents(fields[prefix + '_offset']), 'change': int(fields[prefix + '_change_after']), 'revert': D(fields[prefix + '_revert_rate']), } def schedule(terms): """Amortise separately from the production implementation, using Decimal.""" balance = terms['base'] + terms['financed'] annual = terms['annual'] + 12 * terms['monthly'] rate = terms['rate'] regular = payment(balance, rate, terms['months']) first_payment = regular after_payment = None rows = [] for number in range(1, terms['months'] + 1): if terms['change'] and number == terms['change'] + 1: rate = terms['revert'] regular = payment(balance, rate, terms['months'] - number + 1) after_payment = regular opening = balance interest = rounded(D(max(0, opening - terms['offset'])) * rate / 1200) due = opening + interest paid = due if number == terms['months'] else min(due, regular) assert paid > interest, 'The model excludes non-amortising cent-edge schedules' balance = due - paid fees = rounded(D(annual) * number / 12) - rounded(D(annual) * (number - 1) / 12) rows.append({'month': number, 'rate': str(rate), 'opening_balance_cents': opening, 'interest_cents': interest, 'principal_cents': paid - interest, 'payment_cents': paid, 'fee_cents': fees, 'closing_balance_cents': balance}) if balance == 0: break assert balance == 0 assert sum(row['principal_cents'] for row in rows) == terms['base'] + terms['financed'] return {'terms': terms, 'rows': rows, 'payment_cents': first_payment, 'after_rate_payment_cents': after_payment, 'payoff_months': len(rows)} def snapshot(s, horizon): terms = s['terms'] rows = s['rows'][:horizon] interest = sum(row['interest_cents'] for row in rows) recurring = sum(row['fee_cents'] for row in rows) repaid = sum(row['payment_cents'] for row in rows) principal = sum(row['principal_cents'] for row in rows) balance = rows[-1]['closing_balance_cents'] if rows else terms['base'] + terms['financed'] fees = terms['cash'] + terms['financed'] + recurring cost = interest + fees outlay = terms['cash'] + repaid + recurring assert outlay + balance - terms['base'] == cost return {'interest_cents': interest, 'fees_cents': fees, 'cost_cents': cost, 'outlay_cents': outlay, 'balance_cents': balance, 'principal_cents': principal, 'ongoing_fees_cents': recurring, 'repayments_cents': repaid} def crossings(a, b, horizon): margins = [snapshot(a, month)['cost_cents'] - snapshot(b, month)['cost_cents'] for month in range(horizon + 1)] first = next((i for i, margin in enumerate(margins) if margin >= 0), None) sustained = None if margins[-1] >= 0: sustained = next((i + 1 for i in range(horizon, -1, -1) if margins[i] < 0), 0) return first, sustained def threshold(basic, offset_terms, horizon): """Smallest integer-cent constant offset meeting the stated horizon cost.""" target = snapshot(basic, horizon)['cost_cents'] def cost(amount): return snapshot(schedule(dict(offset_terms, offset=amount)), horizon)['cost_cents'] upper = offset_terms['base'] + offset_terms['financed'] if cost(0) <= target: return 0 if cost(upper) > target: return None low = 0 while low < upper: middle = (low + upper) // 2 if cost(middle) <= target: upper = middle else: low = middle + 1 assert cost(low) <= target assert low == 0 or cost(low - 1) > target return low def calculate(kind, fields, include_schedules=False): horizon = int(fields['horizon']) a = schedule(offer(fields, 'a')) b = schedule(offer(fields, 'b')) result = {} for prefix, s in [('a', a), ('b', b)]: result.update({prefix + '_' + key: value for key, value in snapshot(s, horizon).items()}) for key in ('payment_cents', 'after_rate_payment_cents', 'payoff_months'): result[prefix + '_' + key] = s[key] result[prefix + '_lifetime_cost_cents'] = snapshot(s, len(s['rows']))['cost_cents'] result[prefix + '_first_interest_cents'] = s['rows'][0]['interest_cents'] result[prefix + '_first_balance_cents'] = s['rows'][0]['closing_balance_cents'] result[prefix + '_last_payment_cents'] = s['rows'][-1]['payment_cents'] result[prefix + '_starting_balance_cents'] = s['terms']['base'] + s['terms']['financed'] result['cost_saving_cents'] = result['a_cost_cents'] - result['b_cost_cents'] result['first_break_even_month'], result['sustained_break_even_month'] = crossings(a, b, horizon) result['offset_threshold_cents'] = threshold(a, b['terms'], horizon) if kind == 'offset' else None schedules = {'a': a, 'b': b} if kind == 'refinance' and fields.get('extend') == 'yes': months = 12 * int(fields['extended_years']) + int(fields['extended_months']) extended = schedule(offer(fields, 'b', months)) schedules['extended'] = extended result.update({'extended_' + key: value for key, value in snapshot(extended, horizon).items()}) result['extended_payment_cents'] = extended['payment_cents'] result['extended_payoff_months'] = extended['payoff_months'] result['extended_lifetime_cost_cents'] = snapshot(extended, len(extended['rows']))['cost_cents'] result['extended_cost_saving_cents'] = result['a_cost_cents'] - result['extended_cost_cents'] result['extended_first_break_even_month'], result['extended_sustained_break_even_month'] = crossings(a, extended, horizon) return (result, schedules) if include_schedules else result def main(): path = Path(sys.argv[1]) if len(sys.argv) > 1 else ROOT / 'assets/au-comparison-cases.json' data = json.loads(path.read_text(encoding='utf-8')) checks = 0 assert len({case['id'] for case in data['cases']}) == len(data['cases']) for case in data['cases']: actual = calculate(case['kind'], case['inputs']) for key, expected in case['expected'].items(): assert actual[key] == expected, (case['id'], key, actual[key], expected) checks += 1 # Anchors independent of the fixture values and production implementation. assert payment(60000000, D(6), 360) == 359730 assert payment(12000000, D(0), 120) == 100000 assert rounded(D(100300) * D(6) / 1200) == 502 # Published guide examples: first-month arithmetic, not full-horizon claims. basic_interest = rounded(D(60000000) * D(6) / 1200) offset_interest = rounded(D(60000000 - 2000000) * D('6.1') / 1200) package_month = rounded(D(39500) / 12) assert (basic_interest, offset_interest, package_month) == (300000, 294833, 3292) assert basic_interest - offset_interest - package_month == 1875 assert rounded(D(50000000) * D('5.5') / 1200) == 229167 assert rounded(D(50000000 + 120000) * D('5.5') / 1200) == 229717 print(json.dumps({'status': 'passed', 'cases': len(data['cases']), 'expected_outputs': checks, 'precision': getcontext().prec})) if __name__ == '__main__': main()