4. Personal balance sheet Dan and Selena Newly have been married for over 10 years. They...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
4. Personal balance sheet Dan and Selena Newly have been married for over 10 years. They both have good jobs with consistent incomes, and they are good savers. They believe that their financial picture is good, but they have never prepared a balance sheet. Dan and Selena pulled together the following items from bank statements, pay stubs, and bills. 1. Auto: 2010 Suburban (cost) 26,450 2. Auto: 2007 Honda Pilot (cost) 23,000 3. Dan's salary 45,000 4. Balance due on American Express credit card 1,856 5. Balance due on Master Card 894 6. Balance due on Visa credit card 206 7. Primary home 290,000 8. Selena's diamond earrings 5,750 9. The total balance remaining on their mortgage is 241,667 10. Amount paid last month for a telephone is 500 In addition, the Newly's provided the following information: • Based on comparable homes listed for sale in their neighborhood, the Newly's believe that their home value is about 8% more than what they paid for it. • The principal portion of their mortgage payments is approximately $806 per month. • A reliable jeweler said that Selena's diamond earrings could be sold at the value provided. • After looking at Kelley Blue Book, they believe their cars can be sold for about 55% of original cost. Use this information to fill in the missing amounts on Dan and Selena's balance sheet. You can use what you checked above to make sure you accounted for everything. Note: Some amounts are given to check your work. Round your percent to the one decimal place. Name: Dan and Selena Newly Date: December 31, 2017 ASSETS Monetary Assets Cash on hand Savings account Checking account Total monetary assets Tangible Assets Total tangible assets Balance Sheet $ Dollars IN LA 300 45,000 36,000 $81,300 Investment Assets Mutual funds Bonds Life insurance cash value IRAS Total investment assets (1) Total Assets LIABILITIES Short-Term Liabilities Current portion of mortgage Credit card debt Property taxes Auto loan Total short-term liabilities Long-Term Liabilities Long-term portion of mortgage Total long-term liabilities (2) Total Liabilities Net Worth (1)-(2) Total Liabilities and Net Worth $ $ $ $ $ $ 5,775 13,750 11,000 5,500 6,875 2,175 1,031 Tangible Assets Savings account Home IRAS Bonds ets S Bonds Life insurance cash value 1100 $ 5,775 13,750 11,000 5.500 Life insurance cash value Automobiles Savings account Mutual funds Life insurance cash value IRAS Total investment assets $ A 5,775 13,750 11,000 5,500 6,875 Tangible Assets Cash on hand Personal property Mutual funds IRAS ts alue IRAS Total investment assets (1) Total Assets LIABILITIES LA 5,775 13,750 11,000 5,500 6,875 Investment Assets Mutual funds Home Cash on hand Personal property Stocks Jalue ssets Short-Term Liabilities Current portion of mortgage Credit card debt Property taxes Auto loan Total short-term liabilities $ LA $ $ LA 5,775 13,750 11,000 5,500 6,875 10 2,175 1,031 4. Personal balance sheet Dan and Selena Newly have been married for over 10 years. They both have good jobs with consistent incomes, and they are good savers. They believe that their financial picture is good, but they have never prepared a balance sheet. Dan and Selena pulled together the following items from bank statements, pay stubs, and bills. 1. Auto: 2010 Suburban (cost) 26,450 2. Auto: 2007 Honda Pilot (cost) 23,000 3. Dan's salary 45,000 4. Balance due on American Express credit card 1,856 5. Balance due on Master Card 894 6. Balance due on Visa credit card 206 7. Primary home 290,000 8. Selena's diamond earrings 5,750 9. The total balance remaining on their mortgage is 241,667 10. Amount paid last month for a telephone is 500 In addition, the Newly's provided the following information: • Based on comparable homes listed for sale in their neighborhood, the Newly's believe that their home value is about 8% more than what they paid for it. • The principal portion of their mortgage payments is approximately $806 per month. • A reliable jeweler said that Selena's diamond earrings could be sold at the value provided. • After looking at Kelley Blue Book, they believe their cars can be sold for about 55% of original cost. Use this information to fill in the missing amounts on Dan and Selena's balance sheet. You can use what you checked above to make sure you accounted for everything. Note: Some amounts are given to check your work. Round your percent to the one decimal place. Name: Dan and Selena Newly Date: December 31, 2017 ASSETS Monetary Assets Cash on hand Savings account Checking account Total monetary assets Tangible Assets Total tangible assets Balance Sheet $ Dollars IN LA 300 45,000 36,000 $81,300 Investment Assets Mutual funds Bonds Life insurance cash value IRAS Total investment assets (1) Total Assets LIABILITIES Short-Term Liabilities Current portion of mortgage Credit card debt Property taxes Auto loan Total short-term liabilities Long-Term Liabilities Long-term portion of mortgage Total long-term liabilities (2) Total Liabilities Net Worth (1)-(2) Total Liabilities and Net Worth $ $ $ $ $ $ 5,775 13,750 11,000 5,500 6,875 2,175 1,031 Tangible Assets Savings account Home IRAS Bonds ets S Bonds Life insurance cash value 1100 $ 5,775 13,750 11,000 5.500 Life insurance cash value Automobiles Savings account Mutual funds Life insurance cash value IRAS Total investment assets $ A 5,775 13,750 11,000 5,500 6,875 Tangible Assets Cash on hand Personal property Mutual funds IRAS ts alue IRAS Total investment assets (1) Total Assets LIABILITIES LA 5,775 13,750 11,000 5,500 6,875 Investment Assets Mutual funds Home Cash on hand Personal property Stocks Jalue ssets Short-Term Liabilities Current portion of mortgage Credit card debt Property taxes Auto loan Total short-term liabilities $ LA $ $ LA 5,775 13,750 11,000 5,500 6,875 10 2,175 1,031
Expert Answer:
Related Book For
Taxation Of Individuals And Business Entities 2021
ISBN: 9781260247138
12th Edition
Authors: Brian Spilker, Benjamin Ayers, John Barrick, Troy Lewis, John Robinson, Connie Weaver, Ronald Worsham
Posted Date:
Students also viewed these accounting questions
-
The Saharas have been married for as long as anyone can remember and have 5 children Bill (18), Charlie (13), Fred (12), Teddy (10) and Elizabeth (9). Bill (18) graduated from high school and is in...
-
Cobargo Go Karts have been trading for over 10 years and operates in a small regional town in NSW. There are very few attractions and activities for the local community, but one thing is certainly...
-
Bev and Ken Hair have been married for 3 years. They live at 3567 River Street, Springfield, MO 63126. Ken is a full-time student at Southwest Missouri State University (SMSU) and Bev works as an...
-
Which of the following industries would most likely have the highest ratio of sales revenue to property, plant and equipment? Question 9 options: 1) Airline 2) Consumer product manufacturing company...
-
What is the drill-down approach?
-
Find the website of a law firm that seems to specialize in fiduciary entities, preferably a firm located in your state. Ask the firm to quote you a fee for (1) establishing a simple trust and (2)...
-
Continuation of Problem 8.7 . Show how indicator variables can be used to develop a piecewise linear regression model with a discontinuity at the join point $t$. Problem 8.7 Piecewise Linear...
-
Kansas Furniture Mart had sales of $1,150,000 during 20X1, including $600,000 of sales on credit. Balances on December 31, 20X0, were Accounts Receivable, $120,000, and Allowance for Bad Debts,...
-
You have invested $100,000 in a badly built house. For $20,000 invested today, you can fix up the house and sell it 1 year from today for $90,000. As an alterna- tive, you can sell the house today...
-
Mariah Enterprises makes a variety of consumer electronic products. Its camera manufacturing plant is considering choosing between two different processes, named Alpha and Beta, which can be used to...
-
You are given the principal $3000 in a bank account, a yearly interest rate 4 percent, and the time the money is in the account. Assuming that no withdrawals are made and that the interest is...
-
Which committees of Congress are responsible for revenue legislation?
-
Explain the difference between a tax credit and a tax deduction. Which would help a 28 percent tax bracket taxpayer most, a $2,000 deduction or a $400 credit? A 15 percent tax bracket taxpayer?
-
Why is the gross estate different from the probate estate?
-
If a taxpayer is on the fiscal year, what is the requirement regarding the taxpayer's books?
-
Is it possible to defer gain through the purchase of a new residence?
-
Use Newton's method to approximate all the intersection points of the following pair of curves. Some preliminary graphing or analysis may help in choosing good initial approximations. y=- and y=49-4x...
-
Consider a closed, rigid tank with a volume of 0.8L, filled with cold water initially at 27C. The tank is filled such that there are no voids (air pockets) within. The initial pressure within the...
-
How does a casualty loss on a business asset differ when the asset is stolen as opposed to destroyed in a fire?
-
Alice is single and self-employed in 2020. Her net business profit on her Schedule C for the year is $150,000. What is her self-employment tax liability and additional Medicare tax liability for 2020?
-
Aishwaryas husband passed away in 2019. She needs to determine whether Jasmine, her 17-year-old stepdaughter who is single, qualifies as her dependent in 2020. Jasmine is a resident but not a citizen...
-
A laptop battery has an emf of 10.8 V. The laptop uses 0.70 A while running. a. How much charge moves through the battery each second? b. By how much does the electric potential energy of this charge...
-
When a current passes through the body, it is mainly carried by positively charged sodium ions (Na + ) with charge +e and negatively charged chloride ions (Cl - ) with charge -e. In a given electric...
-
Will the bulb in Figure Q22.2 light? Explain. + FIGURE Q22.2
A Practical Text Book On Plane And Spherical Trigonometry 1st Edition - ISBN: 0554489511 - Free Book
Study smarter with the SolutionInn App