CLIENT SESSION PREP: FINANCIAL COUNSELING (LG 9) Q4:

Create (show your work) the following items IN EXCEL with the information given by the Clients:

Cash Flow Statement

Balance Sheet

Financial Ratios (5 ratios)

\begin{tabular}{|l|rr|} \hline \multicolumn{2}{|c|}{ Assets \& Liabilities } & \\ \hline Certificate of Deposit & $ & 1,500 \\ \hline Credit Card B (For Clothes) & $ & 2,300 \\ \hline Mary's Student Loan Balance (Federal) & $40,000 \\ \hline Bill's Student Loan Balance (Private) & $30,000 \\ \hline Cash on Hand & $ & 2,000 \\ \hline Personal Property & $ & 3,000 \\ \hline Credit Card D (For Misc. Items) & $ & 2,000 \\ \hline Mary's - Car Loan Balance & $r & 15,000 \\ \hline Joint Savings Account & $ & 3,500 \\ \hline Mary's Car & $ & 15,000 \\ \hline Credit Card A (For Groceries/Restaurants) & $ & 3,000 \\ \hline Joint Checking Account & $ & 1,000 \\ \hline Bill's - Truck Loan Balance & $ & 3,500 \\ \hline Bill's Truck & $r & 18,000 \\ \hline Mary's Roth IRA & $ & 5,500 \\ \hline Bill's Retirement (through TTU) & $38,000 \\ \hline Medical/Dental Bills & $ & 3,200 \\ \hline Credit Card C (For Travel) & $ & 1,100 \\ \hline \end{tabular} \begin{tabular}{|l|rr|} \hline \multicolumn{2}{|c|}{ Assets \& Liabilities } & \\ \hline Certificate of Deposit & $ & 1,500 \\ \hline Credit Card B (For Clothes) & $ & 2,300 \\ \hline Mary's Student Loan Balance (Federal) & $40,000 \\ \hline Bill's Student Loan Balance (Private) & $30,000 \\ \hline Cash on Hand & $ & 2,000 \\ \hline Personal Property & $ & 3,000 \\ \hline Credit Card D (For Misc. Items) & $ & 2,000 \\ \hline Mary's - Car Loan Balance & $r & 15,000 \\ \hline Joint Savings Account & $ & 3,500 \\ \hline Mary's Car & $ & 15,000 \\ \hline Credit Card A (For Groceries/Restaurants) & $ & 3,000 \\ \hline Joint Checking Account & $ & 1,000 \\ \hline Bill's - Truck Loan Balance & $ & 3,500 \\ \hline Bill's Truck & $r & 18,000 \\ \hline Mary's Roth IRA & $ & 5,500 \\ \hline Bill's Retirement (through TTU) & $38,000 \\ \hline Medical/Dental Bills & $ & 3,200 \\ \hline Credit Card C (For Travel) & $ & 1,100 \\ \hline \end{tabular}