please review the Smiths Financial Data to create (show your work) the following items IN EXCEL with the information given by the Smiths:

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.

Client Data: Client Data

Joint Money Market Account $ 5,500

Jane's Gross - Part Time Wages $ 15,000

Boat $ 25,000

Gifts to Family $ 2,500

Credit Card B (For Clothes) $ 4,000

Homeowners insurance $ 1,250

Mortgage Balance $ 80,000

Auto insurance/registration $ 1,100

Cash on hand $ 1,500

Income Taxes $ 25,000

House $ 120,000

John's Gross Salary $ 100,000

Personal Property $ 15,000

Food (For Groceries/Resturants) $ 10,000

Credit Card D (For Misc. Items) $ 4,500

Utilities $ 5,700

Jane's - Car Loan Balance $ 10,000

Maintenance (auto and home) $ 3,500

Joint Savings Account $ 400

Charitable Contributions $ 10,000

Jane's Car $ 22,000

Mortgage (including taxes) $ 17,000

Credit Card A (For Groceries/Resturants) $ 3,000

Combined Auto Loan Payment $ 12,000

Joint Checking Account $ 1,000

Boat Loan $ 5,000

John's - Truck Loan Balance $ 28,000

Phone $ 1,550

John's Truck $ 40,000

Gas/Plane Tickets for Transportation $ 4,200

Jane's 403(b) $ 20,000

Medical Expenses $ 8,500

John's 403(b) $ 70,000

Medical Bill Payments $ 4,000

Medical Bills $ 8,000

Clothing $ 5,500

Credit Card C (For Travel) $ 12,000

Miscellaneous $ 8,500

Smith's Boat Loan Balance $ 5,000

Internet $ 650

Medical Insurance Premiums $ 6,200

Life Insurance premium $ 1,600

Credit Cards (sum of ALL credit card payments) $ 3,500

Jane's 403(b) - Contributions $ 4,000

John's 403(b) - Contributions $ 4,000