Purpose
Normalize the facts before lender policy
Not a tax return
Does not alter accounting records
Not an approval
Outputs are review figures only
Core control
Prevent obvious double counting
On this page
The worksheet is a bridge, not a qualifying engine
The Corporate Income Mortgage Worksheet organizes the numbers a mortgage professional commonly needs before applying a lender-specific self-employed income policy. It is deliberately not branded as a universal qualifying-income calculator because no such universal formula exists.
The accountant can use it to identify the historical accounting figures and ownership. The mortgage professional can then adjust the scenario only where the chosen lender expressly permits it.
The five fields that matter most
For each completed fiscal year, the worksheet records financial-statement NIAT, borrower ownership percentage, dividends already counted in the personal mortgage income, any lender-permitted adjustment amount confirmed for the scenario, and owner salary shown separately as context. It does not automatically merge salary into the corporate NIAT calculation.
That structure makes the anti-double-counting control visible. If personal dividends are already used in the mortgage application, the worksheet shows a residual corporate earnings review base rather than simply adding the two numbers together.
What the worksheet calculates—and what it intentionally does not
The worksheet calculates ownership-adjusted NIAT, adds only the adjustment amount the user explicitly enters, and subtracts dividends the user says are already counted personally. It then averages the two review bases and shows the year-over-year trend. These are analytical figures for discussion, not lender-approved income.
It does not decide whether an expense is an eligible add-back, whether the lender will use the average or lower year, whether a dividend came from current or prior retained earnings, whether corporate income is distributable, or whether business liquidity is adequate. Those remain lender/accountant judgment questions.
Use it before sending a complex file to the lender
The best time to complete the worksheet is after the accounting package has been assembled but before the broker submits a corporate-income calculation. If the residual number looks implausible, if the trend is sharply declining, or if dividends exceed current NIAT, the broker knows to obtain an explanation before presenting the file.
The worksheet also creates a consistent language for discussion with the accountant. Instead of asking 'what income can we use?', the broker can ask whether the historical inputs and distribution figures have been captured correctly.
Keep the lender calculation separate from the accounting source record
The final lender worksheet should identify which policy adjustments were applied and why. It should never be presented as if it came from the accountant unless the accountant actually prepared or approved it within an appropriate engagement.
This separation preserves a clean audit trail: financial statements and tax filings remain the source evidence; HopeWell's worksheet is the normalization layer; the lender's decision remains the credit outcome.
Use the related tools
Accountant + mortgage coordination
Have a self-employed client planning a mortgage?
Use the accountant referral pathway for a consented introduction. The initial form accepts contact information only; financial statements, tax returns and other confidential records can be requested separately with the client's authorization.
Introduce a clientFrequently asked questions
Does the worksheet calculate mortgage-qualifying income?
No. It creates a review base from user-entered accounting facts. The selected lender's policy determines the actual qualifying income.
Why does it subtract dividends already counted personally?
To flag obvious double-counting risk when the same corporate economic earnings may already be represented in personal dividend income. The exact lender adjustment remains policy-specific.
Can I enter add-backs?
Yes, but the field is explicitly labeled for lender-permitted adjustments only. The tool does not determine which adjustments are eligible.
Does the worksheet store client information?
The interactive worksheet is designed as an on-page calculation tool and does not require names or identifying client information.
Primary sources
Mortgage, tax and lender policies can change. These resources explain the mortgage-underwriting interface and do not replace accounting, tax or legal advice, the accountant's professional judgment, or a lender decision.