A personal project connecting economic conditions, client behaviour, and lending decisions through two fictional cases and transparent financial models.
Lower payments can free up cash. They can also extend debt, enable new spending, or hide a budget shortfall. This project tests the difference between improving a ratio and strengthening the borrower.
The same question applies to a household consolidating debt and a business financing equipment: what happens to the cash after the transaction?
Use dated public data to identify pressures on income, spending, and borrowing.
Translate those pressures into explicit cash-flow and debt assumptions.
Compare behaviour, financial outcomes, and an evidence-based lending recommendation.
Start with household credit to see the behavioural layer, then explore the commercial case for deeper repayment and covenant analysis.
A fictional Ontario household faces a mortgage renewal and $25,000 of revolving debt. Does consolidation create financial breathing room—or room to borrow again?
A fictional Ontario manufacturer requests $750,000 for equipment. Assess the financial history, stress debt coverage, and evaluate the lending structure.
Three findings from the stated assumptions, followed by the client questions they raise. These are case results, not claims about all Canadian borrowers.
The consolidation installment is approximately $519 instead of $750. It saves about $2,528 in interest during the first year, yet leaves slightly more principal outstanding because the scheduled payment is smaller.
Discovery implication: Ask whether the goal is immediate budget relief, lower interest cost, or faster repayment. Those goals require different comparisons.
When extra monthly card purchases equal 100% of the payment relief, total consumer debt ends near $23,539 after a year, versus $20,854 with no reborrowing.
Discovery implication: Ask what caused the balance and what will change after consolidation. A recurring spending gap can survive a lower borrowing rate.
A 10% revenue decline, 11.5% EBITDA margin, and 9% loan rate move cash available below scheduled debt service. Several modest pressures can combine into a material shortfall.
Discovery implication: Verify orders, pricing flexibility, collections, and cost exposure together. An isolated rate stress can miss operating risk.
Public observations below are distinct from my analytical interpretations. This is a dated snapshot, not a live data feed.
The Bank held the overnight target at 2.25% on September 2 and identified increased inflation risks and trade uncertainty.
A steady policy rate does not guarantee an unchanged fixed mortgage offer. Test the borrower’s actual renewal rate separately.
August CPI rose 3.0% year over year. Grocery prices were 29.0% above August 2021 levels.
Slower price growth does not restore the old grocery bill. Ask about actual expenses before interpreting a positive budget surplus.
September employment declined by 68,000; unemployment rose to 6.5%. These are national survey estimates.
Income continuity deserves a separate stress scenario. A national unemployment rate is not an individual probability of default.
The Q2 consumer survey reported that high prices and uncertainty continued to constrain spending plans.
Clients may trade down or delay purchases. The project also tests reborrowing as a hypothetical response; the survey does not estimate that response.
Download scenario data inside each case. Review formulas and model limitations before interpreting a recommendation.
Economic observations come from the Bank of Canada and Statistics Canada. Borrower records, loan offers, behavioural paths, and thresholds are invented and labelled.
Models answer “what if” questions. They do not estimate causal effects, default probabilities, approval eligibility, or a forecast for the economy.
Recommendations state the cash-flow rationale, conditions, discovery questions, and evidence that could overturn the conclusion.
Developed with AI assistance.
This independent personal project is for educational and portfolio purposes. Borrowers, financial statements, loan terms, scenarios, and recommendations are fictional or illustrative. Economic observations use the dated public sources listed below.
This content is not individualized financial, investment, legal, or tax advice; professional underwriting; a credit approval; a loan offer; or a solicitation for financial services. Models are simplified and do not determine real-world eligibility or replace a lender’s assessment. Illustrative thresholds do not represent RBC or any other lender’s policies.
The project is not sponsored, approved, or endorsed by Royal Bank of Canada (RBC), and its analysis does not represent RBC’s views. It contains no client records, confidential employer information, or internal lending policies. Public data is dated, may be revised, and is not updated automatically.
Banking Advisor · Honours B.A. Economics
McMaster University, 2024
My current work includes lending applications. I developed this personal learning project to explore the connection between client discovery, responsible lending, financial modeling, and economic conditions.
I set the project’s focus around my lending work and the analytical skills I want to develop: financial-statement interpretation, repayment modeling, scenario analysis, and clear credit communication.
The aim is to build understanding relevant to credit, financial analysis, and banking operations.
Sources reviewed October 12, 2026. Different indicators refer to different periods. The consumer survey is Q2 2026; its findings should not be read as an October measurement. This project uses no internal RBC information or client records.