Question

In: Finance

Bill and Debra Jones In this case you will be preparing – calculating financial reports and...

Bill and Debra Jones

In this case you will be preparing – calculating financial reports and information in order to assess the Jones’s financial situation and needs.

First you need to see where they are right now.

Bill Jones 45, and Debra Jones 42 are married with two children ages 6 and 3.

Bill earns $64,000 a year as a school teacher. Debra currently works part time earning $16,000 a year. She is also going to college part time to earn a nursing degree. The college tuition is $3,200 per year she anticipates earning $60,000 when she graduates in 2 years.

Their residence is appraised for tax purposes at $300,000 and has a $197,000 mortgage, and is pretty good condition. The monthly mortgage payment is $1,475, which includes $170 for property taxes and $75 for homeowners insurance and $25 for community association dues. Mortgage interest for this year is estimated to be $9800.

The Jones’s have a checking account that averages $2,500., a $6,500. savings account, 500 shares of Apple Inc. common stock which was left to Debra by her uncle, Bill has an IRA with a current balance of $97,000, he also is a participant in his employers 401 K plan with a $50,000 balance. His pretax monthly contribution to the 401 K $100. They have two automobiles that currently have a fair market value of $22,000; one has a 9,000, loan balance with monthly payments of $260 for another 2 years. Their personal property (furniture, clothing appliances etc.) is valued at $33,000.

Bill has a private term life insurance policy of $100,000, premium is $220 per year, and is covered by group term life insurance with his employer of $100,000. These policies provide only a death benefit.

The family is covered by employer group health plan (PPO) that covers the family and costs $260 per month, which is deducted from Bill’s pay.   Annual homeowner’s insurance premium is $900, automobile insurance premium $2,200. The liability limits on the automobile insurance is state’s minimum at 50/50/100. Neither have any disability insurance.

Average monthly expenditures are; groceries $330, Visa credit card of $100. (Outstanding balance is $2,500) Utilities, electric and Gas $160, water and sewer $40, Telephone internet and cable $80, Cell phones $100. Auto maintenance including fuel $110, Clothing, entertainment, eating out, etc. and other miscellaneous expenditures $130 per month, co pays on medical and dental are $600 annually. Maintenance on the residence is $50 per month. Annual charitable donations are $600.

Bill and Debra’s estimated annual Federal and State income taxes are $3,220 and $900, while Debra’s is $700 and $300 respectively.   

Bill and Debra Jones   Case 1   Prepare and evaluate the Jones’s Statement of Financial Condition (Balance Sheet) and Statement of Cash Flows (Budget) in good presentation form.

Comment on their Financial Condition and their Budget

Solutions

Expert Solution

Cash Flow statement
Income (Bill & Debra) $          80,000 Income
Total Income $          80,000
Debra Tution fees $          (3,200) Expenses
Mortgage Payment $        (17,700) Expenses
Pre tax Monthly Contribution $          (1,200) Expenses
Insurance Premium $              (220) Per Year Expenses
PPO $          (3,120) Expenses
Annual Homeowner Insurance $              (900) Expenses
Automobile insurance $          (2,200) Expenses
Average Monthly Expenditure $        (49,200) Expenses
Medical and dental $          (7,200) Expenses
Charitable donation $          (7,200) Expenses
Bill Annual Federal & State Income taxes $          (2,320) Expenses
Debra Annual Federal & State Income taxes $              (400) Expenses
Total Expenses $        (94,860)
Net cashflow $        (14,860)
Balance Sheet
Personal Property $          33,000 Asset
Residence Value $        300,000 Asset
Savings Account $            2,500 Asset
Apple Shares $            6,500 Asset
IRA $          97,000 Asset
401K Balance $          50,000 Asset
Automobiles $          31,000 Asset
Total Asset $        520,000
Mortgage - Home $     (197,000) Liability
Credit card Balance $          (2,500) Liability
Loan Balance $          (6,240) Liability
Total Liability $     (205,740)
Net worth $        314,260

Cash Flow looks Negative Since Debra is anticipating additional income in two years,It will help them to turn their Negative into Positive in another two years.Since Balance sheet has Positive Net worth- they can use their savings for another two years to offset the negative cashflow


Related Solutions

You are employed in a large accounting firm which specialises in preparing general purpose financial reports...
You are employed in a large accounting firm which specialises in preparing general purpose financial reports for large companies that are listed on the Australian Securities Exchange (ASX). As the training manager, one of your key tasks is to prepare a regular newsletter for staff involved in the preparation of the above financial reports. The purpose of the newsletter is to keep staff updated on the latest financial reporting news, alerting staff of changes and developments that may impact their...
Case Scenario: Mr Jones is in the doctors office for hus yearly physical. He reports feeling...
Case Scenario: Mr Jones is in the doctors office for hus yearly physical. He reports feeling tired, losing weight, and shortness of breath at tines. Since hus last visit he lost 25 pounds. He works for public power company and has for 10 years. What tests would the doctor use to confirm his suspicions? Support your answer with data, facts, key terminology, specific examples, and other information drawn from the textbook and at least one supplemental source. Please include apprioriate...
The purposes of preparing a set of financial reports are often subject to different interpretations.  The Hong...
The purposes of preparing a set of financial reports are often subject to different interpretations.  The Hong Kong Companies Ordinance requires directors of a company to present a set of accounts to show the true and fair view of the financial situation of the company, while the HKICPA states that the financial accounts should provide information that is useful to a wide spectrum of readers.  But other purposes of presenting a set of accounts are also observed in real life practices. You...
Ratih, a financial analyst found that PT Mentari changed its accounting policy in preparing financial reports...
Ratih, a financial analyst found that PT Mentari changed its accounting policy in preparing financial reports every year even though it was not due to new standard provisions. PT Mentari voluntarily changed its acquisition policy. For these changes, PT Mentari has followed the provisions in IAS 8 regarding changes in accounting policies. Ratih is one of the users who uses financial statements to determine the value of a company. Give advice to Ratih what things to consider in analyzing the...
Jones Limited has a year-end of 31 December. When preparing its financial statements for 2012, the...
Jones Limited has a year-end of 31 December. When preparing its financial statements for 2012, the accountants estimated that the income tax payable would be £62,000. The liability was settled in 2013 at £65,000. Assume this company pays its tax liabilities on time. Jones bought a piece of machinery for £50,000 on 1 January 2013 which has a useful life of two years and will be scrapped at the end of its life. A first year allowance of 100% is...
Assume that you are Tracy Roberts and you are preparing two reports to Morgan Mickelson or...
Assume that you are Tracy Roberts and you are preparing two reports to Morgan Mickelson or Household Goods, Inc.   You should answer the following questions. In one report, you assume that Morgan Mickelson is a CPA and will understand citations to the Accounting Standards Codification (ASC). In this first report, you should use appropriate citations to ASC. The second report covers similar information but the assumption is that Morgan Mickelson is not a CPA and will not understand citations to...
You are the CEO of Broadway Medical Center.  Mrs. Sarah Jones is admitted to your hospital preparing...
You are the CEO of Broadway Medical Center.  Mrs. Sarah Jones is admitted to your hospital preparing to give birth and in a great deal of pain. According to her medical records, her unborn child is suffering from a heart defect and must be operated on quickly to save the life of the child. The surgery that must be done is expensive and can only be performed by a pediatric cardiologist, fetal surgeon, and their medical teams. Mrs. Jones insurance will...
In preparing financial budgets:
 In preparing financial budgets: Multiple Choice The budgeted balance sheet is usually prepared last. The cash budget is usually not prepared. The budgeted income statement is usually not prepared. The capital expenditures budget is usually prepared last. The budgeted income statement is usually prepared last.
You are the financial accountant for Superstore Ltd, and are in the process of preparing its...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its financial statements for the year ended 30 June 2018. Whilst preparing the financial statements, you become aware of the following situations: On 1 July 2017, the directors made a decision, using information obtained over the last couple of years, to revise the useful life of an item of manufacturing equipment. The equipment was acquired on 1 July 2015 for $800,000, and has been depreciated...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its...
You are the financial accountant for Superstore Ltd, and are in the process of preparing its financial statements for the year ended 30 June 2018.  Whilst preparing the financial statements, you become aware of the following situations: On 1 July 2017, the directors made a decision, using information obtained over the last couple of years, to revise the useful life of an item of manufacturing equipment.  The equipment was acquired on 1 July 2015 for $800,000, and has been depreciated...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT