- Jeff And Mary Douglas A Couple In Their Mid 30s Have Two Children Paul Age 6 And Marcy Age 7 The Douglas Do Not Ha 1 (440.8 KiB) Viewed 79 times
- Jeff And Mary Douglas A Couple In Their Mid 30s Have Two Children Paul Age 6 And Marcy Age 7 The Douglas Do Not Ha 2 (384.14 KiB) Viewed 79 times
- Jeff And Mary Douglas A Couple In Their Mid 30s Have Two Children Paul Age 6 And Marcy Age 7 The Douglas Do Not Ha 3 (357.8 KiB) Viewed 79 times
- Jeff And Mary Douglas A Couple In Their Mid 30s Have Two Children Paul Age 6 And Marcy Age 7 The Douglas Do Not Ha 4 (320.5 KiB) Viewed 79 times
- Jeff And Mary Douglas A Couple In Their Mid 30s Have Two Children Paul Age 6 And Marcy Age 7 The Douglas Do Not Ha 5 (272.94 KiB) Viewed 79 times
- Jeff And Mary Douglas A Couple In Their Mid 30s Have Two Children Paul Age 6 And Marcy Age 7 The Douglas Do Not Ha 6 (455.57 KiB) Viewed 79 times
Jeff and Mary Douglas, a couple in their mid-30s, have two children - Paul age 6 and Marcy age 7. The Douglas' do not have substantial assets and have not yet reached their peak earning years. Jeff is a general manager of a jewelry manufacturer in Providence, RI while Mary teaches at the local elementary school in the town of Tiverton, Ri. The family needs both incomes to meet their normal living expenses and to meet unforeseen emergency purchases. Their cash flow situation is tight, and they have had difficulty growing a "nest egg through savings and investing. Jeff and Mary have discussed the needs of their two children who are typical, healthy, and active kids, They have discussed trying to have Mary stay at home, be with the kids more and run the household but her income is very much needed, and she also wants a career and doesn't want to put her teaching job on hold to be a stay-at-home mother. Jeff also wants (and needs) to work and his job often requires long days - beyond the 9-5 grind. Now that both children are in school there is no day care need and Mary's job schedule matches nicely with the children's schedule, so she not only wants to continue to work but is thinking about completing a graduate degree. Currently, Mary can take most of the summer off from teaching (when the children are home on vacation) and so she enjoys a great deal of flexibility in the summer and spends quite a bit of time with the children in the summer. Jeff is the breadwinner of the family, but Mary's contribution is also very significant. Jeff earns about 65% of the total household income with Mary earning the remainder. By completing a graduate degree, Mary could increase her salary by at least 20% but she would need to commit to a continuing education program at either Providence College or University of Rhode Island. Although their net worth is not substantial, they have big dreams and aspirations. Their personal financial objectives relate to goals for a high standard of living. They want to help their children go to good colleges, a goal that they share with their own parents (the grandparents who want to help fund that dream). Jeff and Mary want to accumulate significant assets that allow for a comfortable retirement. Both are in excellent health and have family histories of long-life expectancies. Their retirements (at age 65 or so) could be a period of 20 or more years. ta Current Financial Information They own their home which they purchased two years ago for $285 000. Their town (Rumford. Rhode Island) tax office has assessed the home value at $200,000. Recently. Mary hired a certified real estate appraiser to prepare a home appraisal and his appraised value was $300.000 (the real estate appraiser based her opinion of value on recent sales of comparable homes in similar neighborhoods and considered current construction costs and land value.) While surting the weby Mary noticed that their home is listed on Zillow.com with a Zestimate of $350.000. Zestimates are powered by an algorithm. Mary knows that the variables of the valuation system, including analysis of home exterior and interior and traditional real estate facts and figures images can be inaccurate and may need updating however Mary logs into Zillow often to see how the system is valuing one of the families largest and most important asset.
The mortgage on the home has a balance of $140.000. A review of the Douglas financial information, bank statements, and other documents shows the following as of Dec. 31, 2021: 2015 Camry worth about $11,000 (Kelly Blue Book), with a bank loan balance of $3.000 2014 Volvo S60 purchased six months ago for $14,500 is worth about $15.000 (Kelly Blue Book), with a bank loan balance of $10,000 An insurance policy on Jeff's life with a face value of $100,000 with a cash surrender value of $2,500 and no policy loan balance. Mary is the beneficiary listed on Jeff's policy. An insurance policy on Mary's life with a face value of $10,000 and no cash surrender value. Jeff is the beneficiary listed on Mary's policy. Credit card balances that total $6,500. A savings account with a $1,000 balance. Two mutual funds earmarked for the children's college education. The account for Paul has a balance of $10,000 and Marcy's has $11,000 as a current balance. The fund has averaged an 8% annual rate of return over its life. 100 shares of Apple Inc. (NASDAQ: stock symbol = AAPL), formerly Apple Computer. Inc. You need to value this stock and all the stocks they own based on the Dec. 31, 2021 price per share. You will need to find that on the Internet. The cost basis is $120 per share. 200 shares of AT&T. The cost basis is $41 a share. 50 shares of Microsoft. The cost basis is $158 per share. 75 shares of Alphabet Inc. The cost basis is $1.600 per share. A checking account with a balance of $3,000. Jeff estimates that their furniture fixtures etc, in the home are worth about $7.000. Jeff and Mary have retirement accounts that have a current market value of approximately $200.000 Mary still has an education loan with an outstanding balance of $15.000 lt sell has seven years left on it. A vacation loan of $750 due in 6 months and a home improvement loan o000 due in years (unsecured - not a home equity loan.) Jeff wants to finish the basement and he has discussed this at length with My He is getting estimates from contractors based on ideas that both he and Mary have create a play area for the children and a lyden for the family Jett and Mary love to play plne pones and poor and NOS
Jeff wants to finish the basement and he has discussed this at length with Mary. He is getting estimates from contractors based on ideas that both he and Mary have to create a play area for the children and a TV/den for the family. Jeff and Mary love to play ping pong and pool and would love to introduce the children to both "sports." He believes that the project will cost about $30,000 and he is interested in tapping into the home equity, Jeff is also an avid baseball fan and is looking at buying a membership to a local baseball softball facility for both Paul and Marcy. He figures that since he doesn't have any expensive hobbies it would be fun to get Paul started as a baseball player and Marcy as a softball player. The membership costs and related costs are as follows: $1,500 per year (covers both kids) equipment $500 per year, and team registration and travel costs will be about another $1,000 to $2,000 a year depending on how serious the kids become. Mary is not sure that this is a priority at this point and wants to explore this possibility in more detailGeneral instructions Please read through the questions below and solve each requirement using the MS Excel workbook. The workbook includes a worksheet for each requirement (Question 1 Personal Balance Sheet. questions 2,3,4 Ratios, Question 5 Common Stock Portfolio, etc.). Question 1. Mary understands that although the family doesn't maintain a formal accounting system to be able to produce a personal balance sheet, they do have records from which such a statement can be prepared. Mary knows that periodically, it would be wise to have a balance sheet that is up to date as the family may need it for a loan application, possibly for some investment opportunities, and for a developing plans such as a personal financial plan, an estate plan or a formal retirement plan. According to AICPA's Statement of Position 82-1 Accounting and Financial Reporting for Personal Financial Statements, personal financial statements should present assets at their estimated current values and liabilities at their estimated current amounts. The estimated current value of an asset in personal financial statements is the amount at which the item could be exchanged between a buyer and seller, each of whom is well informed and willing, and neither of whom is compelled to buy or sell What is the family's net worth? Please prepare a personal balance sheet. The balance sheet as of date" should be Dec. 31, 2021. PLEASE NOTE: Because the family owns several common stock investments, it might be helpful to review question 5 (below) and complete the question 5 worksheet in the Excel workbook and then enter the appropriate balance sheet value from that portfolio report. Question 2. The current ratio is a measure of short-term debt burden. A current ratio of 2 indicates that for every $2 of liquid assets there is $1 of current liabilities (a current ratio - 2). A high current ratio indicates the ability to meet short-term obligations. What is the current ratio on December 31 for the Douglas family? Question 3. Debt burden is something that every family should monitor. One ratio is a debt ratio (liabilities/assets). In recent years, the Douglas family's debt ratio was running around 408. What is their current debt ratio? Question 4. The liquidity ratio indicates the number of months that living expenses can be paid mom
Jeff wants to finish the basement and he has discussed this at length with Mary. He is getting estimates from contractors based on ideas that both he and Mary have to create a play area for the children and a TV/den for the family. Jeff and Mary love to play ping pong and pool and would love to introduce the children to both "sports." He believes that the project will cost about $30,000 and he is interested in tapping into the home equity. Jeff is also an avid baseball fan and is looking at buying a membership to a local baseball/softball facility for both Paul and Marcy. He figures that since he doesn't have any expensive hobbies, it would be fun to get Paul started as a baseball player and Marcy as a softball player. The membership costs and related costs are as follows: $1,500 per year (covers both kids), equipment $500 per year, and team registration and travel costs will be about another $1,000 to $2,000 a year depending on how serious the kids become. Mary is not sure that this is a priority at this point and wants to explore this possibility in more detailGeneral instructions Please read through the questions below and solve each requirement using the MS Excel workbook. The workbook includes a worksheet for each requirement (Question 1 Personal Balance Sheet, questions 2,3,4 Ratios, Question 5 Common Stock Portfolio, etc.). Question 1. Mary understands that although the family doesn't maintain a formal accounting system to be able to produce a personal balance sheet, they do have records from which such a statement can be prepared. Mary knows that periodically, it would be wise to have a balance sheet that is up to date as the family may need it for a loan application possibly for some investment opportunities, and for developing plans such as a personal financial plan, an estate plan or a formal retirement plan. According to AICPA's Statement of Position 82.1 Accounting and Financial Reporting for personal Financial Statements, personal financial statements should present assets at their estimated current values and liabilities at their estimated current amounts. The estimated current value of an asset in personal financial statements is the amount at which the item could be exchanged between a buyer and seller, each of whom is well informed and willing, and neither of whom is compelled to buy or sell, What is the family's net worth? Please prepare a personal balance sheet. The balance sheet vas or date should be Dec. 31, 2021. PLEASE NOTE: Because the family owns several common stock investments, it might be helpful to review question 5 (below) and complete the questions worksheet in the Excel workbook and then enter the appropriate balance sheet value from that poruolo report
A B $0.00 Personal Balance Sheet 2 Enter Name of Family Here B As of date: 4 Assets s Liquid assets 6 Checking account balance 7 Savings/money market accounts, funds 8 Cash value of life insurance 9 Other 10 Total liquid assets 11 Household assets and possessions 12 Current market value of home 13 Market value of automobiles 14 Furniture 15 Computer, electronics, Camera 16 Jewelry 17 Other 18 Other 19 Total household assets 20 Investment assets 21 Savings certificates 22 Stocks and bonds 23. Retirement accounts 24 Mutual funds 25. Other 26 Total investment assets 27 Total assets 28 29 Liabilities $0.00 $0.00 $0.00 = Q1 Personal Balance Sheet Questions 2, 3, 84
B C 27 Total assets $0.00 Qardan 29. Liabilities 30 Current liabilities 31 Charge account and credit card balances 32 Loan balance (Cars) 33 Vacation Loan 34. Other 35 Total current liabilities 36 Long-term liabilities 37 Mortgage 38 Home Improvement Loan 39 Total long-term liabilities 40 Total liabilities 41 Net Worth S0.00 + $0.00 $0.00 $0.00 45 46