In preparation of your next meeting with the them, you now need to review the financial information. You are responsible for creating a report based off of this information. Analyze the assets & liabilities, to evaluate their financial health and provide cash management counseling. 

In the Case Study: Resources folder, please review the Client's Financial Data to create (show your work) the following items IN EXCELwith the information given by the Clients:

Cash Flow Statement

Balance Sheet

Financial Ratios(5 ratios; review Unit 4)

After completing the financial statements and ratios (IN EXCEL), write a one page summary to your clients explaining the outcome of their Cash Flow Statement and Balance Sheet and how their ratio results compare to the benchmarks.

Financial Counseling & Consumer Credit Case Study: Part 2 Client's Financial Data Assets & Liabilities Annual Income & Expenses Joint Money Market Account $8,000 Mary's Gross - Part Time Wages $17,500 Boat $15,000 Gifts to Family $3,000 Credit Card B (For Clothes) $3,250 Homeowners insurance $1,200 Mortgage Balance $100,000 Auto insurance/registration $2,000 Cash on hand $1,000 Income Taxes $30,000 House $175,000 Bill's Gross Salary $110,000 Personal Property $25,000 Food (For Groceries/Restaurants) $12,000 Credit Card D (For Misc. Items) $4,000 Utilities $6,250 Mary's - Car Loan Balance $12,000 Maintenance (auto and home) $3,500 Joint Savings Account $400 Charitable Contributions $9,600 Mary's Car $23,000 Mortgage (including taxes) $21,000 Credit Card A (For Groceries/Restaurants) $2,500 Combined Auto Loan Payment $13,250 Joint Checking Account $1,250 Boat Loan $7,500 Bill's - Truck Loan Balance $30,000 Phone $1,550 Bill's Truck $42,000 Gas/Plane Tickets for Transportation $4,200 Mary's 401(k) $18,000 Medical Expenses $8,500 Bill's 401(k) $65,000 Medical Bill Payments $4,000 Medical Bills $7,500 Clothing $4,300 Credit Card C (For Travel) $11,000 Miscellaneous $8,500 Internet $750 Medical Insurance Premiums $6,300 Life Insurance premium $1,600 Credit Cards (sum of ALL credit card payments) $4,200 Mary's 401(k) - Contributions $4,000 Bill's 401(k) - Contributions $4,000