Autosave c Home Insert Draw Page Layout Formulas Data Calibri (Body) 11 ' ' A == Paste B I U a. Av Open recovered workbooks? Your recent changes were saved. Do you w B12 XV fic 1 Instructions: 2 You are preparing the financial statements for the Johnson family. 3 To begin with you just want to identify each line and indicate 4 where it will be going (e.g. Balance Sheet, Income Statement). 5 Just write Balance Sheet and or Income statement next to each line. 6 7 Home Value $549,000 8 Joint Savings balance $5,400 9 Tom's 2014 Salary Before Taxes was $78,000 10 Kate's 2014 Salary Before Taxes was $84,000 11 Fed income taxes, state income taxes and FICA combined totaled $46,120 (paid) 12 2014 property taxes were $14,000 (paid) 13 Mortgage $300,000 14 House Payment plus insurance per month $2400 15 Kate bought Microsoft stock in 2012 and they still own it. It's worth $40,0000 16 Tom's 401k at work has several mutual funds worth a total of $120,000 17 Tom has a 2002 VW GTI worth about $3,000 18 Kate has a 2013 Audi S6 worth about $35,000 19 Car loan on Audi totals is $25,000 20 Car Payment is $1583 21 Car insurance for 2014 was $2000 (paid) 22 Credit Card Balance $4,000 23 Tom's monthly contribution o his 401k is $1,000 24 Joint Checing account balance $1,200 25 26 22