Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help with the savings account please! bottom is tracking sheet Case Study - part one DJ and Connie Richards wants to compile a Net Worth

help with the savings account please! image text in transcribed
image text in transcribed
bottom is tracking sheet image text in transcribed
image text in transcribed
image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Management Accounting Principles And Applications

Authors: Hugh Coombs, D Ellis Jenkins, David Hobbs

1st Edition

1412908434, 978-1412908436

More Books

Students also viewed these Accounting questions

Question

Identify income and expenses

Answered: 1 week ago

Question

Can knowledge workers and/or professionals be performance-managed?

Answered: 1 week ago

Question

Does a PMS enhance strategic integration within HRM?

Answered: 1 week ago