Cash flow

Cash Flow Data Sheet

Clients Name(s)

E-mail

Important Notes/Unique Circumstances

Mortgage Information

Please complete the fields only as they apply to you. If you do not have a second mortgage or a HELOC, leave those areas blank. Any additional information that you feel is pertinent please list in the additional Notes/Information area.

Ist Mortgage

Bank/Institution Name

Term (Years)

Total Payment (Principle, Interest, Taxes, Insurance)

Original Mortgage Principle

Current Balance

Interest Rate

Original Start Date

Date of Month Due

Additional Notes/Information

*If you pay property taxes and homeowner’s insurance separately rather than as part of your mortgage payment, list them below in the Expenses section.

2nd Mortgage

Bank/Institution Name

Term (Years)

Total Payment

Original Mortgage Principle

Current Balance

Interest Rate

Original Start Date

Date of Month Due

Additional Notes/Information

HELOC (if applicable)

Bank/Institution Name

Current Balance Owed

HELOC Limit

Interest Rate

Monthly Payment

Date of Month Due

Additional Notes/Information

Income Information

Please note that income should reflect net checks after taxes, 401(k) contributions, and stock purchases. Complete only as it applies to your circumstances.

Your Primary Income

Your Name

Interval (Weekly, Every two weeks, Monthly)

Net Bonus Paid (if applicable)

Date of Bonus Payment (if applicable)

Net Amount of Check

Date of Month Paid

Bonus Interval (if applicable)

Additional Notes/Information

Spouse Primary Income

Your Spouse’s Name

Interval (Weekly, Every two weeks, Monthly)

Net Bonus Paid (if applicable)

Date of Bonus Payment (if applicable)

Net Amount of Check

Date of Month Paid

Bonus Interval (if applicable)

Additional Notes/Information

Additional/Ancillary Income 1

Income Source

Interval (Weekly, Every two weeks, Monthly)

Net Amount of Income

Date of Month Paid

Additional Notes/Information

Additional/Ancillary Income 2

Income Source

Interval (Weekly, Every two weeks, Monthly)

Net Amount of Income

Date of Month Paid

Additional Notes/Information

Expense Information

Please do not hesitate to edit our template so that it accurately reflects your circumstances (example: many clients have cable and internet as one bill). We’ve also included blank fields so that you can add ones we may have missed.

However, please be sure to always indicate the interval of the expense (weekly, monthly, quarterly, annually, etc) and the date paid/due as this will help us accurately understand your cash flow.

Expense Name

Household Expenses Amount

Interval

Date Paid/Due

Property Taxes *

Household Expenses Amount

Interval

Date paid /Due

Homeowner’s Insurance *

Household Expenses Amount

Interval

Date Paid/Due

Car Insurance

Household Expenses Amount

Interval

Date paid/Due

Life Insurance

Household Expenses Amount

Interval

Date Paid/Due

Electricity

Household Expenses Amount

Interval

Date Paid/Due

Water

Household Expenses Amount

Interval

Date Paid/Due

Garbage

Household Expenses Amount

Interval

Date Paid/Due

Sewerage

Household Expenses Amount

Interval

Date Paid/Due

Cell Phones

Household Expenses Amount

Interval

Date paid /Due

Cable

Household Expenses Amount

Interval

Date Paid /Due

Internet

Household Expenses Amount

Interval

Date paid / Due

Home Phone

Household Expenses Amount

Interval

Date Paid /Due

Cleaning

Household Expenses Amount

Interval

Date Paid /Due

Property Maintenance

Household Expenses Amount

Interval

Date Paid /Due

Groceries

Household Expenses Amount

Interval

Date Paid/Due

Entertainment

Household Expenses Amount

Interval

Date Paid/Due

Gas

Household Expenses Amount

Interval

Date Paid/Due

Gifts

Household Expenses Amount

Interval

Date Paid/Due

Clothing

Household Expenses Amount

Interval

Date Paid/Due

School Expenses

Household Expenses Amount

Interval

Date Paid/Due

Vacation Budget

Household Expenses Amount

Interval

Date Paid/Due

Christmas Budget

Household Expenses Amount

Interval

Date Paid/Due

Savings Accounts

Household Expenses Amount

Interval

Date Paid/Due

Time Shares

Household Expenses Amount

Interval

Date Paid/Due

Religious Contributions

Household Expenses Amount

Interval

Date Paid/Due

Type other Expense Name here

Household Expenses Amount

Interval

Date Paid/Due

Type other Expense name here

Household Expenses Amount

Interval

Date Paid/Due

Type other Expense name here

Household Expenses Amount

Interval

Date Paid/Due

Type other Expense name here

Household Expenses Amount

Interval

Date Paid/Due

Additional Information

*If you pay property taxes and homeowner’s insurance as part of your mortgage payment, DO NOT list them here. Instead, include them in your monthly mortgage payment.

Debt Information

Please include all debts, balances, minimum payments, monthly payment you make (if above the minimum),interest rates, dates paid, and anticipated pay-off dates. Car payments/loans, credit cards, and other loans should all be included.

Name

Balance

Minimum Payment

Monthly Payment

Interest

Date Paid/Due

Payoff Date

Name

Balance

Minimum Payment

Monthly Payment

Interest

Date Paid/Due

Payoff Date

Name

Balance

Minimum Payment

Monthly Payment

Interest

Date Paid/Due

Payoff Date

Name

Balance

Minimum Payment

Monthly Payment

Interest

Date Paid/Due

Payoff Date

Name

Balance

Minimum Payment

Monthly Payment

Interest

Date Paid/Due

Payoff Date

Name

Balance

Minimum Payment

Monthly Payment

Interest

Date Paid/Due

Payoff Date

College Information

When formulating a long-term plan, we want to be sure that we take into account expected college bills and debt. If we do not plan for it now, college can become a significant roadblock in our financial future. Please provide us with both the names of your students and year you expect them to enter college for the first Fall semester.

Upcoming College-bound Students

Name

Enters college Fall of......

Name

Enters college Fall of......

Name

Enters college Fall of......

Name

Enters college Fall of......

Name

Enters college Fall of......

Final Notes (Expense, Debt, College or Other)