All dollar amounts are monthly unless noted. Auto-calculated (type over it to override; clear it to go back to auto)
Client Information
Mortgage Information Payment auto-calculates principal & interest
| Lender | Interest % | Yrs Left | Loan Balance | Home Value | Payment | Accelerated (extra / mo) | Est. Equity |
|---|---|---|---|---|---|---|---|
| Totals | |||||||
Payment includes extra if the client is already accelerating. Add escrow (taxes/insurance) by typing over the payment.
Insurance Information
| Type | Face Amount | Purpose | Premium / mo | Cash Value | Carrier | Expiration |
|---|---|---|---|---|---|---|
| Totals | ||||||
Assets
| Type | Current Value | Currently Contributing? | Contribution / mo | Purpose |
|---|---|---|---|---|
| Total Assets |
Total assets exceed $100,000 — complete the QRS survey.
Liabilities / Debt Not including mortgage
| Liability Name | Total Amount | Making Overpayments? |
|---|---|---|
| Total Liabilities |
Monthly Expenses
Mortgage autofrom mortgage section
Other Insurances autofrom insurance premiums
Car
UtilitiesElectric, water, gas
Phone
Food
Entertainment
Gasfuel for vehicles
Credit Card DebtTotal monthly minimum# of cards:
Student Loans
Personal Loans
Other
Total Expenses
Income
Combined Income
Amount
Survivor
keeps?
keeps?
Client Wages
Client Social Security
Higher
SS
SS
Client Pension / Retirement
Spouse Wages
Spouse Social Security
Higher
SS
SS
Spouse Pension / Retirement
Total Combined Income
Check Survivor keeps? if the surviving spouse continues to receive that income (e.g., a pension with a survivor benefit). Social Security is automatic: the survivor keeps the higher of the two benefits and loses the lower one.
Individual Survivors Income
Client's Income autowithout spouse
Spouse Income autowithout client
Auto = survivor's own wages + own pension + the higher Social Security benefit + any of the deceased's income checked "Survivor keeps?". Type over it to override.
Client's shortfall/surplusif spouse passes
Spouse's shortfall/surplusif client passes
Summary
Monthly Net Cash Flow
$0
Total Net Worth
$0
Total Liabilities (excl. mortgage)
$0
Total Mortgage Balance
$0