INSTRUCTIONS FOR PRELIMINARY WORK
Please fill out the 7 colored tabs in this worksheet:
1. CLIENT INFORMATION
2. PRIORITY ANALYSIS
3. QUESTIONNAIRE
4. INCOME
List all regular net income sources
List all irregular net income sources (i.e. commissions, bonuses, rents, etc.)
Include Tax refunds
5. EQUITY
List all assets
List their estimated market values, as well as their payoffs
6. BUDGET
List all monthly expenses
List all expenses that occur once a quarter or once a year
Use the "Other" lines to fill in other miscellaneous expenses in each category
7. DEBT SNOWBALL
List remaining unsecured debts, smallest balance to largest
List the total payoff amounts and minimum payments
(If necessary, the other tabs will be used during counseling sessions.)
PLEASE ONLY INPUT DATA. DO NOT MANIPULATE EXCEL
FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS!
Please bring these to your session:
-- Most recent pay stub and two years of tax returns
-- A list of all insurances (including, but not limited to, health, life
disability, car, homeowner, etc.). For each item in this list, include
current deductible and all possible deductibles.
-- A thorough list of all financial assets (including, but not limited
to, savings, 401k’s, IRA’s, CD’s, etc.).
-- If you own your own business (as a sole proprietorship), include
all relevant company documents (including company P & L
statements).
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
CLIENT INFORMATION
Name:
Age:
Place of Work:
Type of Work:
Hobbies:
Spouse's Name:
Age:
Place of Work:
Type of Work:
Hobbies:
Children- Name and Age:
Child 1:
Child 2:
Child 3
Child 4:
Child 5:
Child 6:
Are you or have you attended Financial Peace University?
Additional Information:
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
How to complete the forms
Please answer the questions and fill out the cells highlighted in green. You may save the completed form and email
ben.calhoun@faithfirstfinancial.net. There are a total of 7 tabs below that need to be filled out. If you have any quest
please feel free to call us at 706-925-0468 or email us at info@faithfirstfinancial.net.
ompleted form and email it to
out. If you have any questions,
QUESTIONNAIRE
Please answer each question in a few sentences:
1. What prompted you to call in?
2. What is going well with your finances? What is not going well?
3. What are your goals for your time with your coach? At the end of your coaching package, what do
you hope to have accomplished?
4. Where do you see yourself in the next year? 5 years? 10 years?
5. Do you currently use a working budget?
6. What are you willing to sacrifice to see the results you want?
7. Are you committed to not borrowing? Is your spouse commited to not borrowing?
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
COUNSELING PRIORITY ANALYSIS
Identify the top 3 priorities (1 being the highest priority)
you would like to focus on:
Developing a Money Spending Plan (Budget)
Personal Debt Elimination
Establishing An Emergency/Opportunity Savings Fund
Estate Planning - Wills & Trusts
Retirement Planning/Financial Independence Planning
Investment Planning
Business Cash Flow - Debt Elimination
Other Goal: ___________________________________
List questions you would like to discuss:
1-
2-
3-
4-
5-
6-
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
MONTHLY INCOME SOURCES
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS OR CELLS AS YOU COMP
Point to red comment triangles for help.
Regular Income Irregular Income
Types of Income
(Monthly Take Home) (Quarterly/Annually)
Income 1
Income 2
Income 3
Interest/Rents/Misc.
Tax Refund
Other
Bonuses
Self-Employment
Do not enter data below this point.
TOTAL INCOME $0.00 $0.00
- TOTAL NECESSITIES $0.00 BUDGET
= DISPOSABLE INCOME $0.00
- DEBT PAYMENT $0.00 DEBT SNOWBALL
= EXTRA FOR
EMERGENCY FUND/ DEBT $0.00
REDUCTION
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
EMERGENCY FUND GOAL
3x Monthly Necessities $0.00
6x Monthly Necessities $0.00
LIFE INSURANCE RANGE
8x Annual Income $0.00
10x Annual Income $0.00
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
NTHLY INCOME SOURCES
PULATE EXCEL FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS.
to red comment triangles for help.
Coach's Comments
not enter data below this point.
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
CONSUMER EQUITY
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS OR CELLS AS YOU COMP
Assets Value - Debt = Equity
Real Estate 1 - First Mortgage
Real Estate 1 - Second Mortgage
Real Estate 2 - Rental, Investments
Car 1
Car 2
Car 3
Other vehicles - Motorcycle, ATV, Boat
Cash on Hand
Checking Account 1
Checking Account 2
Savings Account 1
Savings Account 2
Money Market Account
Mutual Funds
Retirement Plan 1
Retirement Plan 2
Retirement Plan 3
Retirement Plan 4
Stocks or Bonds
Insurance (Cash Value)
Household Items
Jewelry
Antiques
Other:
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
Other:
Other:
Other:
Other:
Other:
Do not enter data below this point.
Unsecured Debts (from Debt tab)
TOTAL
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
S YOU COMPLETE THESE FORMS.
Coach's Comments
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
BASIC BUDGET
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS
Nonmonthly
Expenses Monthly (Paid quarterly or
yearly)**
Church Giving
GIVING
Monetary Donations/Offerings
Other:
Emergency Savings
Retirement Savings- not payroll deducted
College Savings
SAVINGS
Estimated Tax Savings
Short-term Savings for Goals
Other:
First Mortgage
Second Mortgage
Third Mortgage
Home Owners Association
HOUSING
Repairs/Upkeep/Lawn
Property Tax
Insurance (Home Owner's/Renter's)
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
BASIC BUDGET
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS
HOUSING
Nonmonthly
Expenses Monthly (Paid quarterly or
yearly)**
RENT
GIVING
Storage
Electricity
Water
Gas
Home Phone
Cell Phone
UTILITIES
Trash
Cable
Internet
Services (Security System/Pest Control)
Other:
Groceries
Eating Out
FOOD
Paper goods/Dishes/Cleaning supplies
Household items bought at grocery store
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
BASIC BUDGET
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS
FOOD Nonmonthly
Expenses Monthly (Paid quarterly or
yearly)**
Other:
GIVING
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
BASIC BUDGET
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS
Nonmonthly
Expenses Monthly (Paid quarterly or
yearly)**
First Car Payment/Replacement
GIVING
Second Car Payment/Replacement
Gas
CARS
Repairs, Oil changes, Tires, etc.
Car Tags/Registration, etc.
Car Insurance
Other:
Disability Insurance
Health Insurance
Life Insurance
MEDICAL
Med Co-Pay/RX
Optometrist/Dentist/Chiropractor/Others
Other:
Vacation
Entertainment
Hobbies
RECREATION
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
BASIC BUDGET
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS
Nonmonthly
Expenses Monthly (Paid quarterly or
yearly)**
RECREATION
Blow Money
GIVING
Sports/Gym Membership/Staying healthy
Other:
Tuition/School Supplies/Activities/Lunches
Childcare/Babysitting
KIDS
Children's Commissions
Other:
Pet Care
Gifts- All
Clothes
Dry Cleaning
MISC.
Bank fees
Postage/Subscriptions
Personal Hygiene/Hair Care
Other:
Future Financial Coaching
Dave Ramsey's Financial Coaching
OTHER
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
BASIC BUDGET
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS
Nonmonthly
Expenses Monthly (Paid quarterly or
yearly)**
Other:
OTHER
GIVING
Other:
Other:
TOTAL
* Envelope System
** In this column, include the monthly amount that will need to be saved if
amounts that aren't necessarily paid on a monthly basis. For example, oil c
for monthly even though they aren't done monthly. The same is true for re
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
UDGET
FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS.
Leave blank for Coaching session
Envelope* Actual
Coach's Comments
Total Total
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
UDGET
FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS.
Leave blank for Coaching session
Envelope* Actual
Coach's Comments
Total Total
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
UDGET
FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS.
Leave blank for Coaching session
Envelope* Actual
Coach's Comments
Total Total
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
UDGET
FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS.
Leave blank for Coaching session
Envelope* Actual
Coach's Comments
Total Total
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
UDGET
FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS.
Leave blank for Coaching session
Envelope* Actual
Coach's Comments
Total Total
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
UDGET
FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS.
Leave blank for Coaching session
Envelope* Actual
Coach's Comments
Total Total
saved if the monthly total includes
mple, oil changes need to be budgeted
ue for repairs, registration, etc..
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
DEBT SNOWBALL
List unsecured debts, from the smallest balance to the largest balance, regardless of in
(Unsecured debts are not secured by an asset. Include student loans, credit cards, medic
Money for debt reduction:
Disposable Income:
Extra for debt reduction:
Leave blank for Coaching s
Minimum Annual Monthly Payments
Unsecured Debts Total Balance Monthly Interest Left (min.
Payment Rate payment)
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
TOTAL
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
SNOWBALL
argest balance, regardless of interest rate or minimum payment.
tudent loans, credit cards, medical bills, family loans, IRS, etc.)
Leave blank for Coaching session
Monthly
Payments Left Coach's Comments
(extra payment)
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
Dave Ramsey's Financial Coaching
10/27/2011 63c46072-c32f-47e2-9495-40240db66928.xls
DISTRIBUTED BUDGET
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS.
PAYCHECKS
Check 1 Check 2 Check 3 Check 4 Check 5 Check 6
Date: Date: Date: Date: Date: Date:
Paycheck Amount:
Remaining money to distribute (or shortfall) for each paycheck: #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Remaining to
Monthly
Expenses E/S/C Due Date Allocate (for Budget for each Paycheck
Total
the month)
Total Monthly Income:
Church Giving
GIVING
Monetary Donations/Offerings
Other:
Emergency Savings
Retirement Savings- not payroll deducted
College Savings
SAVINGS
Estimated Tax Savings
Short-term Savings for Goals
Other:
First Mortgage
Second Mortgage
Third Mortgage
Home Owners Association
HOUSING
Repairs/Upkeep/Lawn
Property Tax
Insurance (Home Owner's/Renter's)
RENT
Storage
Electricity
Water
Gas
Home Phone
UTILITIES Cell Phone
Trash
Cable
Internet
Services (Security System/Pest Control)
Other:
Groceries
Eating Out
FOOD
Paper goods/Dishes/Cleaning supplies
Household items bought at grocery store
Other:
First Car Payment/Replacement
Second Car Payment/Replacement
Gas
CARS
Repairs, Oil changes, Tires, etc.
Car Tags/Registration, etc.
Car Insurance
Other:
Disability Insurance
Health Insurance
Life Insurance
MEDICAL
Dave Ramsey's Financial Coaching
10/27/2011 Part 7 63c46072-c32f-47e2-9495-40240db66928.xls
DISTRIBUTED BUDGET
PLEASE ONLY INPUT DATA - DO NOT MANIPULATE EXCEL FORMULAS OR CELLS AS YOU COMPLETE THESE FORMS.
PAYCHECKS
Check 1 Check 2 Check 3 Check 4 Check 5 Check 6
Date: Date: Date: Date: Date: Date:
Paycheck Amount:
Remaining money to distribute (or shortfall) for each paycheck: #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
Remaining to
Monthly
Expenses E/S/C Due Date Allocate (for Budget for each Paycheck
Total
the month)
MEDICAL
Total Monthly Income:
Med Co-Pay/RX
Optometrist/Dentist/Chiropractor/Others
Other:
Vacation
Entertainment
Hobbies
RECREATION
Blow Money
Sports/Gym Membership/Staying healthy
Other:
Tuition/School Supplies/Activities/Lunches
KIDS
Childcare/Babysitting
Children's Commissions
Other:
Pet Care
Gifts- All
Clothes
Dry Cleaning
MISC.
Bank fees
Postage/Subscriptions
Personal Hygiene/Hair Care
Other:
Future Financial Coaching
OTHER Other:
Other:
Other:
DEBT (From Debt Snowball Tab)
Remaining money to distribute (or shortfall) for each paycheck: #VALUE! #VALUE! #VALUE! #VALUE! #VALUE! #VALUE!
E To Envelopes
Distribution: S To Savings
C To Checking
Dave Ramsey's Financial Coaching
10/27/2011 Part 7 63c46072-c32f-47e2-9495-40240db66928.xls