help with the savings account please!

bottom is tracking sheet

Case Study - part one DJ and Connie Richards wants to compile a Net Worth Statement, an Income and Expense Statement, the Ratios Worksheet, and the Revolving Savings Worksheet They decided to start with the Net Worth Statement and began by looking at the worksheet to see what items they needed to include. They own a home and decided to use the property tax valued amount for the home value, which was $205,000. The mortgage on the home had a balance of $167,000. Next they looked at their cars They looked at the Kelly Blue Book website, www.ibb.com to figure out the value. They found one car was worth $17,000 and the other was worth $8,400. They have a loan on the first car with a balance of $8,300. Next, they walked through their house and added up what they thought the fair market value was for some of the larger items such as appliances, computers, electronic equipment, newer furniture, etc. They came up with $16,900. For retirement, they found quarterly statement for both DJ and Connie DJ has 401(k) with a current value of $55,700 and Connie has an IRA with a current value of $37,000 For liquid assets, they didn't really have any cash on hand at the time, but they looked online for their bank balances. They had $700 in checking $3,300 in savings, and $2,600 in a money market fund. The only other items they could think of were two more liabilities. They have a credit card with a balance of $1,100 and a student loan with a balance of $4,600. Next it was time to do the income and Expense Statement. They had been tracking their income and expenses for one month. This made the income and Expense Statement rather easy. All they had to do was look at each category and add up all the times they spent money in each category and then do the same for income and enter those figures on the statement, (see tracking sheet) with the Net Worth and income and Expense Statements done, they could now complete the Ratio Worksheet. For the Basic Liquidity Ratio, they made sure they only counted their Liquid Assets from the Net Worth Statement. For the annual debt payments, they had to look at their debt payments on the income and Expense Statement (not total expenses), add them together, and then multiply by 12. For their annual income they added together both of their incomes from the income and Expense Sheet and then multiplied by 12. Finally, DJ and Connie were ready to complete the Revolving Savings Account Worksheet. They started by looking at the suggested items at the top of the worksheet. They have car insurance due in February and August for $700 each time. They have five birthdays in the year that they have decided to spend $150 for each birthday. They come in March April, two in September, and November. They would like to spend about $1,000 for Christmas in December. It seems to cost about $350 to get the children inte school each August DJ has a life insurance premium due in October of $250. With this information, they were able to a out the Revolving Savings Account Worksheet and find out how much they should include in their monthly budget for these irregular expenses. REVOLVING SAVINGS ACCOUNT - (for irregular expenses) List all expenses that come irregularly throughout the year. List items such as auto registration, auto insurance, life insurance, school expenses, birthdays, anniversaries, holidays, celebrations and vacations MONTH AMOUNT MONTH AMOUNT January July February August March September April October May November June December TOTAL $ 12 Monthly budget DJ and Connie Richards wanted to complete a Net Worth Statement, an Income and Expense Statement, the Ratios Worksheet, and the Revolving Savings Worksheet. They decided to start with the Net Worth Statement and began by looking at the worksheet to see what items they needed to include. They own a home and decided to use the property tax valued amount for the home value, which was $205,000. The mortgage on the home had a balance of $167,000. Next they looked at their cars. They looked at the Kelly Blue Book website, www.kbb.com (Links to an external site.) to figure out the value. They found one car was worth $17,000 and the other was worth $8,400. They have a loan on the first car with a balance of $8,300. Next, they walked through their house and added up what they thought the fair market value was for some of the larger items such as appliances, computers, electronic equipment, newer furniture, etc. They came up with $16,900. For retirement, they found a quarterly statement for both DJ and Connie. DJ has a 401(k) with a current value of $55,700 and Connie has an IRA with a current value of $37,000. For liquid assets, they didn't really have any cash on hand at the time, but they looked online for their bank balances. They had $700 in checking, $3,300 in savings, and $2,600 in a money market fund. The only other items they could think of were two more liabilities. They have a credit card with a balance of $1,100 and a student loan with a balance of $4,600 Next it was time to do the income and Expense Statement. They had been tracking their income and expenses for one month. This made the Income and Expense Statement rather easy. All they had to do was look at each category and add up all the times they spent money in each category and then do the same for income and enter those figures on the statement. (see tracking sheet) With the Net Worth and Income and Expense Statements done, they could now complete the Ratio Worksheet. For the Basic Liquidity Ratio, they made sure they only counted their Liquid Assets from the Net Worth Statement. For the annual debt payments, they had to look at their debt payments on the Income and Expense Statement (not total expenses), add them together, and then multiply by 12. For their annual income they added together both of their incomes from the Income and Expense Sheet and then multiplied by 12. Finally, DJ and Connie were ready to complete the Revolving Savings Account Worksheet. They started by looking at the suggested items at the top of the worksheet. They have car insurance due in February and August for $700 each time. They have five birthdays in the year that they have decided to spend $150 for each birthday. They come in March, April, two in September, and November. They would like to spend about $1,000 for Christmas in December. It seems to cost about $350 to get the children into school each August. DJ has a life insurance premium due in October of $250. With this information, they were able to fill out the Revolving Savings Account Worksheet and find out how much they should include in their monthly budget for these irregular expenses. ate Expense Income Category Description 1 S1598.00 2 2 2 $99300 $348.00 $200.00 $60.00 $75.00 3 3 $800.00 5 6 $59.00 $106.00 $261.00 $27.00 $112.00 $10.00 $33.00 9 9 15 $1602.00 Salary DJ's Check Mortgage Loan Car Payment Retirement Connie's TRA Dance Lessons School Lunch Salary Connie's Check Utilities City Utilities Electric Groceries Gasoline Groceries Entertainment Movie Gasoline Salary DJ's Check Contributions Boy Scouts of America Savings Loan Credit Card Loan Student Eating Out Arby's Utilities Natural Gas Clothing Children/DJ Groceries Gasoline Entertainment Bowling Utilities Cell Phone/Cable Groceries Eating Out Chipotles Household Expet Prescriptions 15 15 15 15 15 15 16 19 $25.00 $225.00 $30.00 $133.00 $17.00 $88.00 $100.00 $106.00 $70.00 $40.00 $165 00 $51.00 $43 00 $70.00 $35.00 19 21 26 29 29 29 29 Case Study - part one DJ and Connie Richards wants to compile a Net Worth Statement, an Income and Expense Statement, the Ratios Worksheet, and the Revolving Savings Worksheet They decided to start with the Net Worth Statement and began by looking at the worksheet to see what items they needed to include. They own a home and decided to use the property tax valued amount for the home value, which was $205,000. The mortgage on the home had a balance of $167,000. Next they looked at their cars They looked at the Kelly Blue Book website, www.ibb.com to figure out the value. They found one car was worth $17,000 and the other was worth $8,400. They have a loan on the first car with a balance of $8,300. Next, they walked through their house and added up what they thought the fair market value was for some of the larger items such as appliances, computers, electronic equipment, newer furniture, etc. They came up with $16,900. For retirement, they found quarterly statement for both DJ and Connie DJ has 401(k) with a current value of $55,700 and Connie has an IRA with a current value of $37,000 For liquid assets, they didn't really have any cash on hand at the time, but they looked online for their bank balances. They had $700 in checking $3,300 in savings, and $2,600 in a money market fund. The only other items they could think of were two more liabilities. They have a credit card with a balance of $1,100 and a student loan with a balance of $4,600. Next it was time to do the income and Expense Statement. They had been tracking their income and expenses for one month. This made the income and Expense Statement rather easy. All they had to do was look at each category and add up all the times they spent money in each category and then do the same for income and enter those figures on the statement, (see tracking sheet) with the Net Worth and income and Expense Statements done, they could now complete the Ratio Worksheet. For the Basic Liquidity Ratio, they made sure they only counted their Liquid Assets from the Net Worth Statement. For the annual debt payments, they had to look at their debt payments on the income and Expense Statement (not total expenses), add them together, and then multiply by 12. For their annual income they added together both of their incomes from the income and Expense Sheet and then multiplied by 12. Finally, DJ and Connie were ready to complete the Revolving Savings Account Worksheet. They started by looking at the suggested items at the top of the worksheet. They have car insurance due in February and August for $700 each time. They have five birthdays in the year that they have decided to spend $150 for each birthday. They come in March April, two in September, and November. They would like to spend about $1,000 for Christmas in December. It seems to cost about $350 to get the children inte school each August DJ has a life insurance premium due in October of $250. With this information, they were able to a out the Revolving Savings Account Worksheet and find out how much they should include in their monthly budget for these irregular expenses. REVOLVING SAVINGS ACCOUNT - (for irregular expenses) List all expenses that come irregularly throughout the year. List items such as auto registration, auto insurance, life insurance, school expenses, birthdays, anniversaries, holidays, celebrations and vacations MONTH AMOUNT MONTH AMOUNT January July February August March September April October May November June December TOTAL $ 12 Monthly budget DJ and Connie Richards wanted to complete a Net Worth Statement, an Income and Expense Statement, the Ratios Worksheet, and the Revolving Savings Worksheet. They decided to start with the Net Worth Statement and began by looking at the worksheet to see what items they needed to include. They own a home and decided to use the property tax valued amount for the home value, which was $205,000. The mortgage on the home had a balance of $167,000. Next they looked at their cars. They looked at the Kelly Blue Book website, www.kbb.com (Links to an external site.) to figure out the value. They found one car was worth $17,000 and the other was worth $8,400. They have a loan on the first car with a balance of $8,300. Next, they walked through their house and added up what they thought the fair market value was for some of the larger items such as appliances, computers, electronic equipment, newer furniture, etc. They came up with $16,900. For retirement, they found a quarterly statement for both DJ and Connie. DJ has a 401(k) with a current value of $55,700 and Connie has an IRA with a current value of $37,000. For liquid assets, they didn't really have any cash on hand at the time, but they looked online for their bank balances. They had $700 in checking, $3,300 in savings, and $2,600 in a money market fund. The only other items they could think of were two more liabilities. They have a credit card with a balance of $1,100 and a student loan with a balance of $4,600 Next it was time to do the income and Expense Statement. They had been tracking their income and expenses for one month. This made the Income and Expense Statement rather easy. All they had to do was look at each category and add up all the times they spent money in each category and then do the same for income and enter those figures on the statement. (see tracking sheet) With the Net Worth and Income and Expense Statements done, they could now complete the Ratio Worksheet. For the Basic Liquidity Ratio, they made sure they only counted their Liquid Assets from the Net Worth Statement. For the annual debt payments, they had to look at their debt payments on the Income and Expense Statement (not total expenses), add them together, and then multiply by 12. For their annual income they added together both of their incomes from the Income and Expense Sheet and then multiplied by 12. Finally, DJ and Connie were ready to complete the Revolving Savings Account Worksheet. They started by looking at the suggested items at the top of the worksheet. They have car insurance due in February and August for $700 each time. They have five birthdays in the year that they have decided to spend $150 for each birthday. They come in March, April, two in September, and November. They would like to spend about $1,000 for Christmas in December. It seems to cost about $350 to get the children into school each August. DJ has a life insurance premium due in October of $250. With this information, they were able to fill out the Revolving Savings Account Worksheet and find out how much they should include in their monthly budget for these irregular expenses. ate Expense Income Category Description 1 S1598.00 2 2 2 $99300 $348.00 $200.00 $60.00 $75.00 3 3 $800.00 5 6 $59.00 $106.00 $261.00 $27.00 $112.00 $10.00 $33.00 9 9 15 $1602.00 Salary DJ's Check Mortgage Loan Car Payment Retirement Connie's TRA Dance Lessons School Lunch Salary Connie's Check Utilities City Utilities Electric Groceries Gasoline Groceries Entertainment Movie Gasoline Salary DJ's Check Contributions Boy Scouts of America Savings Loan Credit Card Loan Student Eating Out Arby's Utilities Natural Gas Clothing Children/DJ Groceries Gasoline Entertainment Bowling Utilities Cell Phone/Cable Groceries Eating Out Chipotles Household Expet Prescriptions 15 15 15 15 15 15 16 19 $25.00 $225.00 $30.00 $133.00 $17.00 $88.00 $100.00 $106.00 $70.00 $40.00 $165 00 $51.00 $43 00 $70.00 $35.00 19 21 26 29 29 29 29