Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I cretated a balance sheet from the below sheet items. I keep getting the wrong net worth value and no able to balance the number.

I cretated a balance sheet from the below sheet items. I keep getting the wrong net worth value and no able to balance the number.

Financial data of the household I created a balance sheet

Balance Sheet Items (as of 12/31/2014) Investment Assets $105,800 Total Assets $375,800 Net Worth $130,200 Balance Sheet Items (as of 12/31/2015) Checking Account Balance $3,000 Savings Account Balance $3,750 401 (k) Balance - Wilma $52,500 401 (k) Balance - Fred $57,250 529 Plan Balance $2,500 House Value $215,000 Automobile Value - Wilma $19,500 Automobile Value - Fred $17,500 Jewelry Value $2,500 Furniture Value $7,250 Credit Cards Balance $10,900 Next Year's Mortgage Payment due - Principal $23,500 Next Year's Auto Loan Payments - Principal $4,950 Mortgage Balance on House $209,500 Auto Loan Balance $27,500

Balance sheet items as of 12/31/2017

investment assets $105,800

total assets $375,800

net worth $130,200

Checking Account $3,000 Credit Card Balance $10,900
Money Market Account $3,750 Next Year's Auto Loan Payment Principal $4,950
Total Current Assets $6,750 2% Next Year's Mortage Payment due Principal 23500
Total Current Liabilities $39,350 10%
401(k) Plan $109,750
529 Plan Balance $2,500 Mortgage Balance on House $209,500
Auto Loans $27,500
Total Investment Assets $112,250 29% Total Long Term Liabilities $237,000 62%
House Value $215,000 Net Worth $657,100 173%
Furniture, Jewerly $9,750
Auto Wilma $19,500
Auto Fred $17,500
Total Personal Use Assets $261,750 69%
Total Liabilities + Net Worth
Total Assets $380,750

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions