Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can someone please review the above balance sheet that i've created for all of the bullet points? There are also specific items I need help
Can someone please review the above balance sheet that i've created for all of the bullet points? There are also specific items I need help with where to put them or if I should even track them here:
- An insurance policy on Jeff's life with a face value of $100,000 and no cash surrender value. 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.
- A vacation loan of $750 due in 6 months and a home improvement loan of $2,000 due in 2 years (unsecured - not a home equity loan.)
- 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 detail.
Any feedback is appreciated.
They own their home which has an assessed value of $200,000 and a market value of about $300,000 (as determined by a real estate appraiser based on recent sales of comparable homes in similar neighborhoods.) 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 May 1, 2020: 2011 Camry worth about $11,000, with a bank loan balance of $3,000 2012 Volvo S60 worth about $15,000, with a bank loan balance of $10,000 An insurance policy on Jeff's life with a face value of $100,000 and no cash surrender value. Mary is the beneficiary listed on Jeff's policy. 1 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 $3,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 May 1, 2020 price per share. You will need to find that on the Internet. 200 shares of AT&T 50 shares of Microsoft 75 shares of Alphabet Inc. 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. It still has seven years left on it. A vacation loan of $750 due in 6 months and a home improvement loan of $2,000 due in 2 years (unsecured - not a home equity loan.) 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 detail. . Personal Financial Balance Sheet of: Douglas Family as of: 5/1/2020 Amount in Dollars $ 3,000 1,000 11000 157,435 3,000 Assets Cash-checking accounts Cash - savings accounts Certificates of deposit Securities - stocks / bonds / mutual funds Accounts receivable Life insurance (cash surrender value) Personal property (autos, jewelry, etc.) Retirement Funds (eg. IRAs, 401k) Real estate market value) Other assets (specify) - Other assets (specify) - Total Assets Investments Mutual Fund Mutual Fund Apple Shares (100@289.07) MSFT Shares (50@174.57) Alphabet Inc Shares (75@1317.32) Total 10000 28907 33,000 200,000 300,000 8728.5 98799 157434.5 $ 697,435 Amount in Dollars $ 4,250 15,000 Liabilities Current Debt (Credit cards) Notes payable Taxes payable Real estate mortgage Other liabilities - Mary Student Loan Other liabilities - Home Equity Loan Total Liabilities 140,000 15,000 30,000 204,250 $ Net Worth $ 493,185 They own their home which has an assessed value of $200,000 and a market value of about $300,000 (as determined by a real estate appraiser based on recent sales of comparable homes in similar neighborhoods.) 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 May 1, 2020: 2011 Camry worth about $11,000, with a bank loan balance of $3,000 2012 Volvo S60 worth about $15,000, with a bank loan balance of $10,000 An insurance policy on Jeff's life with a face value of $100,000 and no cash surrender value. Mary is the beneficiary listed on Jeff's policy. 1 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 $3,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 May 1, 2020 price per share. You will need to find that on the Internet. 200 shares of AT&T 50 shares of Microsoft 75 shares of Alphabet Inc. 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. It still has seven years left on it. A vacation loan of $750 due in 6 months and a home improvement loan of $2,000 due in 2 years (unsecured - not a home equity loan.) 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 detail. . Personal Financial Balance Sheet of: Douglas Family as of: 5/1/2020 Amount in Dollars $ 3,000 1,000 11000 157,435 3,000 Assets Cash-checking accounts Cash - savings accounts Certificates of deposit Securities - stocks / bonds / mutual funds Accounts receivable Life insurance (cash surrender value) Personal property (autos, jewelry, etc.) Retirement Funds (eg. IRAs, 401k) Real estate market value) Other assets (specify) - Other assets (specify) - Total Assets Investments Mutual Fund Mutual Fund Apple Shares (100@289.07) MSFT Shares (50@174.57) Alphabet Inc Shares (75@1317.32) Total 10000 28907 33,000 200,000 300,000 8728.5 98799 157434.5 $ 697,435 Amount in Dollars $ 4,250 15,000 Liabilities Current Debt (Credit cards) Notes payable Taxes payable Real estate mortgage Other liabilities - Mary Student Loan Other liabilities - Home Equity Loan Total Liabilities 140,000 15,000 30,000 204,250 $ Net Worth $ 493,185Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started