Executive Solution Overview
**files (2)** – ## WEEK7CHFD360BUDGETPLANNING.docx – ## interactive_budgeting_sheet6.xlsx_safe.pdf **## WEEK7CHFD360BUDGETPLANNING.docx** | | | | — | — | | Hide Assignment Information | | Instructions | | | **Assignment 3: Budget Planning**<br>This week you read about the importance of a budg…
Instant Solution Download
$6.99Immediate access to the full model answer, formatted citations, and rubric breakdown.
Need a Fresh Custom Paper?
Have this question answered from scratch according to your specific instructions and deadline.
Order on TutorsGallery →Assignment Prompt & Instructions
**files (2)**
– ## WEEK7CHFD360BUDGETPLANNING.docx
– ## interactive_budgeting_sheet6.xlsx_safe.pdf
**## WEEK7CHFD360BUDGETPLANNING.docx**
| | |
| — | — |
| Hide Assignment Information |
| Instructions | |
| **Assignment 3: Budget Planning**<br>This week you read about the importance of a budget when managing family resources. Now it's time to create your own budget!<br>**Related Course Objectives:** [**CO1, CO5**](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1399197&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>**Directions**<br>For this assignment complete the following steps using the interactive Excel worksheet that is attached. It is VERY important for you to look at the bottom of the spread sheet and starting with the Directions tab, click on each tab (1-4): <br>1. Access the <br>**Family Details** sheet of the workbook and fill in the required information. You may use your own family as an example or create one. <br> <br>· Provide the family name, jobs, income, etc. <br>2. Access the <br>**Budget** Sheet of the workbook and enter the requested financial details. <br> <br>· Use the information from your Family Details sheet where requested.<br>· Fill in the remaining blanks on the form based on your own information or you may make up a family.<br>· You may provide your own salary or research the average salary for whatever profession you choose. Here is an example: <br>_According to salary.com: "The average Medical Laboratory Technician salary in Georgia is $48,223 as of September 01, 2018, but the range typically falls between $43,180 and $52,955."_<br>· If I was making up a family, I would use the average salary of $48,223 for my worksheet. <br>· Enter your references for each source (all of your sources – utilities, insurance, etc.) on the <br>**Research links** sheet of the worksheet.<br> <br>3. Access the <br>**Reflection Questions** sheet of the workbook and answer the questions in the space provided. Make sure to support your answers with facts from the textbook.<br> <br>**Submission Guidelines**<br>· Download the attached interactive budgeting sheet and save it to your computer. <br>· Complete the interactive budget sheet and save your entries.<br>· Upload your completed interactive budget sheet as an attachment for this assignment. |
Week 7: Assignment 3 Budget Planning
Top of Form
Bottom of Form
**## interactive_budgeting_sheet6.xlsx_safe.pdf**
Assignment 3: Budget Planning Case Study
Using this Workbook
This Excel workbook has three additional sheets you will work in: Family Details, Budget Sheet, Reflection questions
and Research Links.
To change sheets, locate these sheet names in the lower left corner and click on the desired sheet name.
To enter information, click on the desired cell (box) that you would like to type and then begin typing. You can use the
tab key and the arrow keys on your keyboard to easily move between cells.
Directions
Access the Family Details sheet of the workbook and identify a family scenario to work with. Use your own as an
example or create one. Be prepared with the family name, jobs, income, etc.
Access the Budget Sheet of the workbook and enter the requested financial details. Use the information from your
Family Details sheet where requested. Fill in the remaining blanks on the form based on what you think the information
would be based on your research. Enter your references on the Research links sheet of the workbook.
Access the Reflection Questions sheet of the workbook and answer the questions in the space provided.
Family Details
Where does the family live?
Type of home
How many adults are in the family?
For each adult, enter the following information
Adult 1 Name Adult 2 Name
Adult 1 Role Mother Adult 2 Role
Adult 1 Career Adult 2 Career
Adult 1 Age Adult 2 Age
Adult 3 Name Adult 4 Name
Adult 3 Role Adult 4 Role
Adult 3 Career Adult 4 Career
Adult 3 Age Adult 4 Age
How many childern are in the family?
For each child, enter the following information:
Child 1 Name Child 2 Name
Child 1 Age Child 2 Age
Child 1 Activities Child 2 Activities
Child 3 Name Child 4 Name
Child 3 Age Child 4 Age
Child 3 Activities Child 4 Activities
Child 5 Name Child 6 Name
Child 5 Age Child 6 Age
Child 5 Activities Child 6 Activities
How many, if any, additional forms of
income are there?
Identify the family member and what it's for
Additional Income 1 Additional Income 2
Associated Family Member Associated Family Member
Additional Income 3 Additional Income 4
Associated Family Member Associated Family Member
Items that require fixed monthly payments
List all of the items that have recurring payments
Item 1 Item 6
Item 2 Item 7
Item 3 Item 8
Item 4 Item 9
Item 5 Item 10
How many pets are in the family?
For each pet, enter the following information:
Pet 1 Name Pet 2 Name
Pet 1 Age Pet 2 Age
Pet 1 Kind/Type Pet 2 Kind/Type
Pet 3 Name Pet 4 Name
Pet 3 Age Pet 4 Age
Pet 3 Kind/Type Pet 4 Kind/Type
Pet 5 Name Pet 6 Name
Pet 5 Age Pet 6 Age
Pet 5 Kind/Type Pet 6 Kind/Type
Family Budget Sheet
Current Assets Current Debt
Home value Credit Debt mortgages
Other Real Estate auto loans
Total Real Estate Assets $- credit cards
other
Automobile Values Total Credit Debt $-
Total Auto Assets $-
Savings
Liquid
Pension/Retirement
Total Savings $-
Annual Incomes Before Taxes
Adult 1
Adult 2
Adult 3 or child support
Total Annual Income Before Taxes $-
Monthly Incomes Before Taxes
$- Adult 1
$- Adult 2
$- Adult 3 or child support
Total Monthly Income Before Taxes $-
Monthly Income After Taxes
mortgages
auto loans
credit cards
other
Adult 1
Adult 2
Adult 3
Government assistance
Total Spendable Monthly Income $-
Monthly Expenses
Insurances
Health/Medical
Life
Home/Rental
Automobile
Health insurance deductible
Other:
Other:
Total Insurances $-
Soft Goods
Food
Hygiene
Clothing
Small incidentals
Other
Total Soft Goods $-
Home Expenses
Mortgage/Rent
Up-keep
Taxes
Electricity
Gas
Telephone
Cell phone
Garbage/Water/Sewer
Lawn Care
Cleaning Services
Fees-home owner dues
Cable
Internet
Other:
Other:
Total Home Expenses $-
Entertainment Expenses
Dining Out
Movies/Theater
Club memberships
Travel
Sporting Events
Other:
Other:
Total Entertainment $-
Automobile Expenses
Vehicle 1 payment
Vehicle 2 payment
Vehicle 3 payment
Maintenance & Repairs
Gasoline
Tax/license fees
Total Automobile Expenses $-
Miscellaneous Expenses:
Credit card & Short term loans
Other
Education (books and tuition)
Veterinarian
Beauty expenses
Gifts
Contributions
Pets
Other:
Other:
Total Miscellaneous $-
Total Anticipated Expenses $-
Flex $-
Monthly Savings Contributions
Liquid
Retirement
Other:
Other:
Other:
Total Savings per Month $-
Unallocated Money $-
.
Reflection Questions
Based on what you’ve learned this week, and personal experience if it applies, please answer the following questions:
Question 1: What is your strategy for saving?
Enter Answer Here
Question 2: If you had to make changes, looking at your budget, where could you make them?
Enter Answer Here
Question 3: How would you handle a large, unexpected expense?
Enter Answer Here
Question 4: If a friend or family member was struggling financially and not using a budget, based
on what you've learned in the course, what techniques and/or strategies would you suggest?
Enter Answer Here
References
Item Supported
Adult #1 Salary (example line)
Reference
Med Tech Salary.com
DO NOT USE OR EDIT THIS SHEET
Family Roles Family Members
Type your Own Type your Own
Mother (divorced from Father and remarried) 0
Father 0
Father (divorced from Mother and remarried) 0
Mother (divorced from Father and remarried) 0
Wife's Mother 0
Wife's Father 0
Husband's Mother 0
Husband's Father 0
Husband 0
Wife 0
Partner
Son
Daughter
Note to Developer, see Instructor Only Section for Workbook password if edits are needed.
Additional Incomes Type of Home
Type your own Type your Own
Alimony Apartment
Child Support Condo
Social Security Mobile Home
Stocks/Bonds Travel Travel
Real Estate/Rentals Homeless/Shelter
2nd Job
**## interactive_budgeting_sheet6.xlsx_safe.pdf**
Assignment 3: Budget Planning Case Study
Using this Workbook
This Excel workbook has three additional sheets you will work in: Family Details, Budget Sheet, Reflection questions
and Research Links.
To change sheets, locate these sheet names in the lower left corner and click on the desired sheet name.
To enter information, click on the desired cell (box) that you would like to type and then begin typing. You can use the
tab key and the arrow keys on your keyboard to easily move between cells.
Directions
Access the Family Details sheet of the workbook and identify a family scenario to work with. Use your own as an
example or create one. Be prepared with the family name, jobs, income, etc.
Access the Budget Sheet of the workbook and enter the requested financial details. Use the information from your
Family Details sheet where requested. Fill in the remaining blanks on the form based on what you think the information
would be based on your research. Enter your references on the Research links sheet of the workbook.
Access the Reflection Questions sheet of the workbook and answer the questions in the space provided.
Family Details
Where does the family live?
Type of home
How many adults are in the family?
For each adult, enter the following information
Adult 1 Name Adult 2 Name
Adult 1 Role Mother Adult 2 Role
Adult 1 Career Adult 2 Career
Adult 1 Age Adult 2 Age
Adult 3 Name Adult 4 Name
Adult 3 Role Adult 4 Role
Adult 3 Career Adult 4 Career
Adult 3 Age Adult 4 Age
How many childern are in the family?
For each child, enter the following information:
Child 1 Name Child 2 Name
Child 1 Age Child 2 Age
Child 1 Activities Child 2 Activities
Child 3 Name Child 4 Name
Child 3 Age Child 4 Age
Child 3 Activities Child 4 Activities
Child 5 Name Child 6 Name
Child 5 Age Child 6 Age
Child 5 Activities Child 6 Activities
How many, if any, additional forms of
income are there?
Identify the family member and what it's for
Additional Income 1 Additional Income 2
Associated Family Member Associated Family Member
Additional Income 3 Additional Income 4
Associated Family Member Associated Family Member
Items that require fixed monthly payments
List all of the items that have recurring payments
Item 1 Item 6
Item 2 Item 7
Item 3 Item 8
Item 4 Item 9
Item 5 Item 10
How many pets are in the family?
For each pet, enter the following information:
Pet 1 Name Pet 2 Name
Pet 1 Age Pet 2 Age
Pet 1 Kind/Type Pet 2 Kind/Type
Pet 3 Name Pet 4 Name
Pet 3 Age Pet 4 Age
Pet 3 Kind/Type Pet 4 Kind/Type
Pet 5 Name Pet 6 Name
Pet 5 Age Pet 6 Age
Pet 5 Kind/Type Pet 6 Kind/Type
Family Budget Sheet
Current Assets Current Debt
Home value Credit Debt mortgages
Other Real Estate auto loans
Total Real Estate Assets $- credit cards
other
Automobile Values Total Credit Debt $-
Total Auto Assets $-
Savings
Liquid
Pension/Retirement
Total Savings $-
Annual Incomes Before Taxes
Adult 1
Adult 2
Adult 3 or child support
Total Annual Income Before Taxes $-
Monthly Incomes Before Taxes
$- Adult 1
$- Adult 2
$- Adult 3 or child support
Total Monthly Income Before Taxes $-
Monthly Income After Taxes
mortgages
auto loans
credit cards
other
Adult 1
Adult 2
Adult 3
Government assistance
Total Spendable Monthly Income $-
Monthly Expenses
Insurances
Health/Medical
Life
Home/Rental
Automobile
Health insurance deductible
Other:
Other:
Total Insurances $-
Soft Goods
Food
Hygiene
Clothing
Small incidentals
Other
Total Soft Goods $-
Home Expenses
Mortgage/Rent
Up-keep
Taxes
Electricity
Gas
Telephone
Cell phone
Garbage/Water/Sewer
Lawn Care
Cleaning Services
Fees-home owner dues
Cable
Internet
Other:
Other:
Total Home Expenses $-
Entertainment Expenses
Dining Out
Movies/Theater
Club memberships
Travel
Sporting Events
Other:
Other:
Total Entertainment $-
Automobile Expenses
Vehicle 1 payment
Vehicle 2 payment
Vehicle 3 payment
Maintenance & Repairs
Gasoline
Tax/license fees
Total Automobile Expenses $-
Miscellaneous Expenses:
Credit card & Short term loans
Other
Education (books and tuition)
Veterinarian
Beauty expenses
Gifts
Contributions
Pets
Other:
Other:
Total Miscellaneous $-
Total Anticipated Expenses $-
Flex $-
Monthly Savings Contributions
Liquid
Retirement
Other:
Other:
Other:
Total Savings per Month $-
Unallocated Money $-
.
Reflection Questions
Based on what you’ve learned this week, and personal experience if it applies, please answer the following questions:
Question 1: What is your strategy for saving?
Enter Answer Here
Question 2: If you had to make changes, looking at your budget, where could you make them?
Enter Answer Here
Question 3: How would you handle a large, unexpected expense?
Enter Answer Here
Question 4: If a friend or family member was struggling financially and not using a budget, based
on what you've learned in the course, what techniques and/or strategies would you suggest?
Enter Answer Here
References
Item Supported
Adult #1 Salary (example line)
Reference
Med Tech Salary.com
DO NOT USE OR EDIT THIS SHEET
Family Roles Family Members
Type your Own Type your Own
Mother (divorced from Father and remarried) 0
Father 0
Father (divorced from Mother and remarried) 0
Mother (divorced from Father and remarried) 0
Wife's Mother 0
Wife's Father 0
Husband's Mother 0
Husband's Father 0
Husband 0
Wife 0
Partner
Son
Daughter
Note to Developer, see Instructor Only Section for Workbook password if edits are needed.
Additional Incomes Type of Home
Type your own Type your Own
Alimony Apartment
Child Support Condo
Social Security Mobile Home
Stocks/Bonds Travel Travel
Real Estate/Rentals Homeless/Shelter
2nd Job
**## WEEK7CHFD360BUDGETPLANNING.docx**
| | |
| — | — |
| Hide Assignment Information |
| Instructions | |
| **Assignment 3: Budget Planning**<br>This week you read about the importance of a budget when managing family resources. Now it's time to create your own budget!<br>**Related Course Objectives:** [**CO1, CO5**](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1399197&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>**Directions**<br>For this assignment complete the following steps using the interactive Excel worksheet that is attached. It is VERY important for you to look at the bottom of the spread sheet and starting with the Directions tab, click on each tab (1-4): <br>1. Access the <br>**Family Details** sheet of the workbook and fill in the required information. You may use your own family as an example or create one. <br> <br>· Provide the family name, jobs, income, etc. <br>2. Access the <br>**Budget** Sheet of the workbook and enter the requested financial details. <br> <br>· Use the information from your Family Details sheet where requested.<br>· Fill in the remaining blanks on the form based on your own information or you may make up a family.<br>· You may provide your own salary or research the average salary for whatever profession you choose. Here is an example: <br>_According to salary.com: "The average Medical Laboratory Technician salary in Georgia is $48,223 as of September 01, 2018, but the range typically falls between $43,180 and $52,955."_<br>· If I was making up a family, I would use the average salary of $48,223 for my worksheet. <br>· Enter your references for each source (all of your sources – utilities, insurance, etc.) on the <br>**Research links** sheet of the worksheet.<br> <br>3. Access the <br>**Reflection Questions** sheet of the workbook and answer the questions in the space provided. Make sure to support your answers with facts from the textbook.<br> <br>**Submission Guidelines**<br>· Download the attached interactive budgeting sheet and save it to your computer. <br>· Complete the interactive budget sheet and save your entries.<br>· Upload your completed interactive budget sheet as an attachment for this assignment. |
Week 7: Assignment 3 Budget Planning
Top of Form
Bottom of Form
**## interactive_budgeting_sheet6.xlsx_safe.pdf**
Assignment 3: Budget Planning Case Study
Using this Workbook
This Excel workbook has three additional sheets you will work in: Family Details, Budget Sheet, Reflection questions
and Research Links.
To change sheets, locate these sheet names in the lower left corner and click on the desired sheet name.
To enter information, click on the desired cell (box) that you would like to type and then begin typing. You can use the
tab key and the arrow keys on your keyboard to easily move between cells.
Directions
Access the Family Details sheet of the workbook and identify a family scenario to work with. Use your own as an
example or create one. Be prepared with the family name, jobs, income, etc.
Access the Budget Sheet of the workbook and enter the requested financial details. Use the information from your
Family Details sheet where requested. Fill in the remaining blanks on the form based on what you think the information
would be based on your research. Enter your references on the Research links sheet of the workbook.
Access the Reflection Questions sheet of the workbook and answer the questions in the space provided.
Family Details
Where does the family live?
Type of home
How many adults are in the family?
For each adult, enter the following information
Adult 1 Name Adult 2 Name
Adult 1 Role Mother Adult 2 Role
Adult 1 Career Adult 2 Career
Adult 1 Age Adult 2 Age
Adult 3 Name Adult 4 Name
Adult 3 Role Adult 4 Role
Adult 3 Career Adult 4 Career
Adult 3 Age Adult 4 Age
How many childern are in the family?
For each child, enter the following information:
Child 1 Name Child 2 Name
Child 1 Age Child 2 Age
Child 1 Activities Child 2 Activities
Child 3 Name Child 4 Name
Child 3 Age Child 4 Age
Child 3 Activities Child 4 Activities
Child 5 Name Child 6 Name
Child 5 Age Child 6 Age
Child 5 Activities Child 6 Activities
How many, if any, additional forms of
income are there?
Identify the family member and what it's for
Additional Income 1 Additional Income 2
Associated Family Member Associated Family Member
Additional Income 3 Additional Income 4
Associated Family Member Associated Family Member
Items that require fixed monthly payments
List all of the items that have recurring payments
Item 1 Item 6
Item 2 Item 7
Item 3 Item 8
Item 4 Item 9
Item 5 Item 10
How many pets are in the family?
For each pet, enter the following information:
Pet 1 Name Pet 2 Name
Pet 1 Age Pet 2 Age
Pet 1 Kind/Type Pet 2 Kind/Type
Pet 3 Name Pet 4 Name
Pet 3 Age Pet 4 Age
Pet 3 Kind/Type Pet 4 Kind/Type
Pet 5 Name Pet 6 Name
Pet 5 Age Pet 6 Age
Pet 5 Kind/Type Pet 6 Kind/Type
Family Budget Sheet
Current Assets Current Debt
Home value Credit Debt mortgages
Other Real Estate auto loans
Total Real Estate Assets $- credit cards
other
Automobile Values Total Credit Debt $-
Total Auto Assets $-
Savings
Liquid
Pension/Retirement
Total Savings $-
Annual Incomes Before Taxes
Adult 1
Adult 2
Adult 3 or child support
Total Annual Income Before Taxes $-
Monthly Incomes Before Taxes
$- Adult 1
$- Adult 2
$- Adult 3 or child support
Total Monthly Income Before Taxes $-
Monthly Income After Taxes
mortgages
auto loans
credit cards
other
Adult 1
Adult 2
Adult 3
Government assistance
Total Spendable Monthly Income $-
Monthly Expenses
Insurances
Health/Medical
Life
Home/Rental
Automobile
Health insurance deductible
Other:
Other:
Total Insurances $-
Soft Goods
Food
Hygiene
Clothing
Small incidentals
Other
Total Soft Goods $-
Home Expenses
Mortgage/Rent
Up-keep
Taxes
Electricity
Gas
Telephone
Cell phone
Garbage/Water/Sewer
Lawn Care
Cleaning Services
Fees-home owner dues
Cable
Internet
Other:
Other:
Total Home Expenses $-
Entertainment Expenses
Dining Out
Movies/Theater
Club memberships
Travel
Sporting Events
Other:
Other:
Total Entertainment $-
Automobile Expenses
Vehicle 1 payment
Vehicle 2 payment
Vehicle 3 payment
Maintenance & Repairs
Gasoline
Tax/license fees
Total Automobile Expenses $-
Miscellaneous Expenses:
Credit card & Short term loans
Other
Education (books and tuition)
Veterinarian
Beauty expenses
Gifts
Contributions
Pets
Other:
Other:
Total Miscellaneous $-
Total Anticipated Expenses $-
Flex $-
Monthly Savings Contributions
Liquid
Retirement
Other:
Other:
Other:
Total Savings per Month $-
Unallocated Money $-
.
Reflection Questions
Based on what you’ve learned this week, and personal experience if it applies, please answer the following questions:
Question 1: What is your strategy for saving?
Enter Answer Here
Question 2: If you had to make changes, looking at your budget, where could you make them?
Enter Answer Here
Question 3: How would you handle a large, unexpected expense?
Enter Answer Here
Question 4: If a friend or family member was struggling financially and not using a budget, based
on what you've learned in the course, what techniques and/or strategies would you suggest?
Enter Answer Here
References
Item Supported
Adult #1 Salary (example line)
Reference
Med Tech Salary.com
DO NOT USE OR EDIT THIS SHEET
Family Roles Family Members
Type your Own Type your Own
Mother (divorced from Father and remarried) 0
Father 0
Father (divorced from Mother and remarried) 0
Mother (divorced from Father and remarried) 0
Wife's Mother 0
Wife's Father 0
Husband's Mother 0
Husband's Father 0
Husband 0
Wife 0
Partner
Son
Daughter
Note to Developer, see Instructor Only Section for Workbook password if edits are needed.
Additional Incomes Type of Home
Type your own Type your Own
Alimony Apartment
Child Support Condo
Social Security Mobile Home
Stocks/Bonds Travel Travel
Real Estate/Rentals Homeless/Shelter
2nd Job
**## WEEK7CHFD360BUDGETPLANNING.docx**
| | |
| — | — |
| Hide Assignment Information |
| Instructions | |
| **Assignment 3: Budget Planning**<br>This week you read about the importance of a budget when managing family resources. Now it's time to create your own budget!<br>**Related Course Objectives:** [**CO1, CO5**](https://myclassroom.apus.edu/d2l/common/dialogs/quickLink/quickLink.d2l?ou=1399197&type=content&rcode=00D22884-7DC5-4408-809B-589E36B04C5A-5979)<br>**Directions**<br>For this assignment complete the following steps using the interactive Excel worksheet that is attached. It is VERY important for you to look at the bottom of the spread sheet and starting with the Directions tab, click on each tab (1-4): <br>1. Access the <br>**Family Details** sheet of the workbook and fill in the required information. You may use your own family as an example or create one. <br> <br>· Provide the family name, jobs, income, etc. <br>2. Access the <br>**Budget** Sheet of the workbook and enter the requested financial details. <br> <br>· Use the information from your Family Details sheet where requested.<br>· Fill in the remaining blanks on the form based on your own information or you may make up a family.<br>· You may provide your own salary or research the average salary for whatever profession you choose. Here is an example: <br>_According to salary.com: "The average Medical Laboratory Technician salary in Georgia is $48,223 as of September 01, 2018, but the range typically falls between $43,180 and $52,955."_<br>· If I was making up a family, I would use the average salary of $48,223 for my worksheet. <br>· Enter your references for each source (all of your sources – utilities, insurance, etc.) on the <br>**Research links** sheet of the worksheet.<br> <br>3. Access the <br>**Reflection Questions** sheet of the workbook and answer the questions in the space provided. Make sure to support your answers with facts from the textbook.<br> <br>**Submission Guidelines**<br>· Download the attached interactive budgeting sheet and save it to your computer. <br>· Complete the interactive budget sheet and save your entries.<br>· Upload your completed interactive budget sheet as an attachment for this assignment. |
Week 7: Assignment 3 Budget Planning
Top of Form
Bottom of Form
**## interactive_budgeting_sheet6.xlsx_safe.pdf**
Assignment 3: Budget Planning Case Study
Using this Workbook
This Excel workbook has three additional sheets you will work in: Family Details, Budget Sheet, Reflection questions
and Research Links.
To change sheets, locate these sheet names in the lower left corner and click on the desired sheet name.
To enter information, click on the desired cell (box) that you would like to type and then begin typing. You can use the
tab key and the arrow keys on your keyboard to easily move between cells.
Directions
Access the Family Details sheet of the workbook and identify a family scenario to work with. Use your own as an
example or create one. Be prepared with the family name, jobs, income, etc.
Access the Budget Sheet of the workbook and enter the requested financial details. Use the information from your
Family Details sheet where requested. Fill in the remaining blanks on the form based on what you think the information
would be based on your research. Enter your references on the Research links sheet of the workbook.
Access the Reflection Questions sheet of the workbook and answer the questions in the space provided.
Family Details
Where does the family live?
Type of home
How many adults are in the family?
For each adult, enter the following information
Adult 1 Name Adult 2 Name
Adult 1 Role Mother Adult 2 Role
Adult 1 Career Adult 2 Career
Adult 1 Age Adult 2 Age
Adult 3 Name Adult 4 Name
Adult 3 Role Adult 4 Role
Adult 3 Career Adult 4 Career
Adult 3 Age Adult 4 Age
How many childern are in the family?
For each child, enter the following information:
Child 1 Name Child 2 Name
Child 1 Age Child 2 Age
Child 1 Activities Child 2 Activities
Child 3 Name Child 4 Name
Child 3 Age Child 4 Age
Child 3 Activities Child 4 Activities
Child 5 Name Child 6 Name
Child 5 Age Child 6 Age
Child 5 Activities Child 6 Activities
How many, if any, additional forms of
income are there?
Identify the family member and what it's for
Additional Income 1 Additional Income 2
Associated Family Member Associated Family Member
Additional Income 3 Additional Income 4
Associated Family Member Associated Family Member
Items that require fixed monthly payments
List all of the items that have recurring payments
Item 1 Item 6
Item 2 Item 7
Item 3 Item 8
Item 4 Item 9
Item 5 Item 10
How many pets are in the family?
For each pet, enter the following information:
Pet 1 Name Pet 2 Name
Pet 1 Age Pet 2 Age
Pet 1 Kind/Type Pet 2 Kind/Type
Pet 3 Name Pet 4 Name
Pet 3 Age Pet 4 Age
Pet 3 Kind/Type Pet 4 Kind/Type
Pet 5 Name Pet 6 Name
Pet 5 Age Pet 6 Age
Pet 5 Kind/Type Pet 6 Kind/Type
Family Budget Sheet
Current Assets Current Debt
Home value Credit Debt mortgages
Other Real Estate auto loans
Total Real Estate Assets $- credit cards
other
Automobile Values Total Credit Debt $-
Total Auto Assets $-
Savings
Liquid
Pension/Retirement
Total Savings $-
Annual Incomes Before Taxes
Adult 1
Adult 2
Adult 3 or child support
Total Annual Income Before Taxes $-
Monthly Incomes Before Taxes
$- Adult 1
$- Adult 2
$- Adult 3 or child support
Total Monthly Income Before Taxes $-
Monthly Income After Taxes
mortgages
auto loans
credit cards
other
Adult 1
Adult 2
Adult 3
Government assistance
Total Spendable Monthly Income $-
Monthly Expenses
Insurances
Health/Medical
Life
Home/Rental
Automobile
Health insurance deductible
Other:
Other:
Total Insurances $-
Soft Goods
Food
Hygiene
Clothing
Small incidentals
Other
Total Soft Goods $-
Home Expenses
Mortgage/Rent
Up-keep
Taxes
Electricity
Gas
Telephone
Cell phone
Garbage/Water/Sewer
Lawn Care
Cleaning Services
Fees-home owner dues
Cable
Internet
Other:
Other:
Total Home Expenses $-
Entertainment Expenses
Dining Out
Movies/Theater
Club memberships
Travel
Sporting Events
Other:
Other:
Total Entertainment $-
Automobile Expenses
Vehicle 1 payment
Vehicle 2 payment
Vehicle 3 payment
Maintenance & Repairs
Gasoline
Tax/license fees
Total Automobile Expenses $-
Miscellaneous Expenses:
Credit card & Short term loans
Other
Education (books and tuition)
Veterinarian
Beauty expenses
Gifts
Contributions
Pets
Other:
Other:
Total Miscellaneous $-
Total Anticipated Expenses $-
Flex $-
Monthly Savings Contributions
Liquid
Retirement
Other:
Other:
Other:
Total Savings per Month $-
Unallocated Money $-
.
Reflection Questions
Based on what you’ve learned this week, and personal experience if it applies, please answer the following questions:
Question 1: What is your strategy for saving?
Enter Answer Here
Question 2: If you had to make changes, looking at your budget, where could you make them?
Enter Answer Here
Question 3: How would you handle a large, unexpected expense?
Enter Answer Here
Question 4: If a friend or family member was struggling financially and not using a budget, based
on what you've learned in the course, what techniques and/or strategies would you suggest?
Enter Answer Here
References
Item Supported
Adult #1 Salary (example line)
Reference
Med Tech Salary.com
DO NOT USE OR EDIT THIS SHEET
Family Roles Family Members
Type your Own Type your Own
Mother (divorced from Father and remarried) 0
Father 0
Father (divorced from Mother and remarried) 0
Mother (divorced from Father and remarried) 0
Wife's Mother 0
Wife's Father 0
Husband's Mother 0
Husband's Father 0
Husband 0
Wife 0
Partner
Son
Daughter
Note to Developer, see Instructor Only Section for Workbook password if edits are needed.
Additional Incomes Type of Home
Type your own Type your Own
Alimony Apartment
Child Support Condo
Social Security Mobile Home
Stocks/Bonds Travel Travel
Real Estate/Rentals Homeless/Shelter
2nd Job