Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a balance sheet with the information provided Analyze the projected budget, actual budgets, and balance sheets to identify concerns Develop recommendations for the person

  • Develop a balance sheet with the information provided
  • Analyze the projected budget, actual budgets, and balance sheets to identify concerns
  • Develop recommendations for the person

Terri is beginning to get a little concerned about her financial circumstances. At the start of the year she bought a house and made an effort to get her finances in order. She even set up a budget that balanced every month! However, she never looked at the budget again but instead tried to keep the amounts in mind each month. Over the year she realized that she rarely had enough money left over to put into her savings. In fact, in several months she had been forced to use her credit card to finance some purchases.

At the end of the year Terri has decided it is time she got her finances in order. Looking back over the past two months she has been able to collect the following information about how her income and expenses differ from her budget established at the beginning of the year. Her wages and 401k contributions havent changed but in the past two months she hasnt been able to drive for Stuber as much and November and December fares have only been $50 and $75 respectively. She has been going out to eat more and has spent $300 in November and $320 in December. She loves to exercise and collect sports memorabilia and in the past months she spent $275 and $300 on them. She knows the memorabilia loses value sometimes but she is sure the value will increase in time and likes to think of her collection as an investment. In each month she wasnt able to save her planned $75 and her utilities have been higher than usual coming in at $135 in both November and December.

She also tried to figure out the value of the things she owns and what she owes to others. She has $350 and $ 1,100 in her checking and savings accounts. She has accumulated $9,000 in her 401k. Her home is currently valued at $130,000 and her car is worth $1,750. She has furniture worth $1,200, clothes worth $2,100, and $900 in other household items. She spent $2,500 on exercise and sports equipment in the past few years but sees similar equipment on an on-line marketplace for $1,500. She also saw her memorabilia selling for $750, which is ridiculous! Some people just dont know what its worth! She spent over $1,900 on her collection in the past couple years. She figures the prices have to return to that value eventually. As noted above, she has been accumulating some debt, too. She still owes $110,000 on her mortgage. She has paid her student loan down to $25,900 and her car loan down to $3,000. She is making payments on the standing balance of her credit card but the total balance still stands at $1,500.

Terri is hoping you will be able to provide her some insights into her financial situation. She wants to make changes that will make her and her family more stable in the future.

Budget

Sources of Income

Wages

$3,950

Employer 401k contribution

$ 150.00

Stuber Fares

$100

Interest

$90

TOTAL INCOME

$4,290

Sources of Expenses

Taxes

$1,483

Mortgage

$850

Vehicle Insurance

$100

Food & Eating Out

$200

Car Payment

$395

Student Loans

$272

Sports & Hobbies

$240

Utilities

$100

Personal savings

$75

Total 401k contribution

$300

Credit Cards (on existing balances)

$275

TOTAL EXPENSES

$4,290

SURPLUS/DEFICIT

$0

Projected Budget Established in the Start of the Year

Sources of Income

Wages

$3,950

Employer 401k contribution

$150.00

Stuber Fares

$100

Interest

$90

TOTAL INCOME

$4,290

Sources of Expenses

Taxes

$1,483

Mortgage

$850

Vehicle Insurance

$100

Food & Eating Out

$200

Car Payment

$395

Student Loans

$272

Sports & Collectibles

$240

Utilities

$100

Personal savings

$75

Total 401k contribution

$300

Credit Cards (on existing balances)

$275

TOTAL EXPENSES

$4,290

SURPLUS/DEFICIT

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Accounting questions