Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. Check the items that would appear on a balance sheet. Do not be concerned about whether the amounts are correct. Check all that apply. OIRA investments $ 6,375 O AAA Bank mutual fund 5,355 Auto: 2010 Suburban (cost) 28,750 O Auto: 2007 Honda Pilot (cost) 25,000 Auto loan balance (last payment) 844 O Bonds 10,200 O City Bank-checking 24,000 O City Bank-savings 30,000 O Cash 200 O Dan's salary 45,000 O Balance due on American Express credit card 1,519 O Unpaid electric bill $ 394 O Life Insurance (cash value) 5,100 Balance due on Master Card 731 O Balance due on Visa credit card 169 O Primary home 300,000 Primary home mortgage 250,000 0 Unpaid property taxes 2,250 O Selena's diamond earrings 6,250 O Stocks 12.750 Unpaid telephone bill 169 Amount paid last month for telephone 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 $833 per month. A reliable jeweler sad 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 . 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. Balance Sheet Name: Dan and Selena Newly Date: December 31, 2017 Dollars Percent ASSETS Monetary Assets % % $ % Total monetary assets Tangible Assets % % yo $ % Total tangible assets Investment Assets % % % % % Total investment assets $ yo $ 100.0% (1) Total Assets 1 LIABILITIES Short-Term Liabilities Current portion of mortgage Credit card debt % % Property taxes % Auto loan % % % % $ % Electric bill Telephone bill 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 yo % $ % $ S $ % $ 100.0% 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. Check the items that would appear on a balance sheet. Do not be concerned about whether the amounts are correct. Check all that apply. OIRA investments $ 6,375 O AAA Bank mutual fund 5,355 Auto: 2010 Suburban (cost) 28,750 O Auto: 2007 Honda Pilot (cost) 25,000 Auto loan balance (last payment) 844 O Bonds 10,200 O City Bank-checking 24,000 O City Bank-savings 30,000 O Cash 200 O Dan's salary 45,000 O Balance due on American Express credit card 1,519 O Unpaid electric bill $ 394 O Life Insurance (cash value) 5,100 Balance due on Master Card 731 O Balance due on Visa credit card 169 O Primary home 300,000 Primary home mortgage 250,000 0 Unpaid property taxes 2,250 O Selena's diamond earrings 6,250 O Stocks 12.750 Unpaid telephone bill 169 Amount paid last month for telephone 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 $833 per month. A reliable jeweler sad 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 . 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. Balance Sheet Name: Dan and Selena Newly Date: December 31, 2017 Dollars Percent ASSETS Monetary Assets % % $ % Total monetary assets Tangible Assets % % yo $ % Total tangible assets Investment Assets % % % % % Total investment assets $ yo $ 100.0% (1) Total Assets 1 LIABILITIES Short-Term Liabilities Current portion of mortgage Credit card debt % % Property taxes % Auto loan % % % % $ % Electric bill Telephone bill 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 yo % $ % $ S $ % $ 100.0%
Step 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