Question: please help me with this personal balance sheet and statement of cash flows for my finance class. it needs to be done like the example

please help me with this personal balance sheet and statement of cash flows for my finance class. it needs to be done like the example but in excel and represent the bank accounts of an average college student. thank you!!!
please help me with this personal balance sheet and statement of cash
flows for my finance class. it needs to be done like the
example but in excel and represent the bank accounts of an average
college student. thank you!!! Assignment I: Your Assignment I should include the
following: 1. Personal Balance sheet 2. Personal Statement of Cash Flow 3.
Identify two strengths and weaknesses based on your current year financial statements.
Note: All of your work should be in a single excel file.

Assignment I: Your Assignment I should include the following: 1. Personal Balance sheet 2. Personal Statement of Cash Flow 3. Identify two strengths and weaknesses based on your current year financial statements. Note: All of your work should be in a single excel file. Please submit Balance Sheet 9/11/2020 Asset Current Assets Cash/Cash Equivalents Annual Current Assets/Current Liat \begin{tabular}{l|rr} Cash & $ & 753.00 \\ Checking Account & $ & 2,523.00 \\ Savings Account & $ & 2,146.00 \\ & & \\ Total Cash/Cash Equivalents & $ & 5,422.00 \end{tabular} Invested Assets \begin{tabular}{l|l|l|l|} 401(k) & $ & 149.00 \\ Total invested Assets & $ & 149.00 \\ \hline \end{tabular} Personal Use Asset \begin{tabular}{l|lr} House & $ & $0,000.00 \\ Iphone & $ & 700.00 \\ Furniture & $ & 500.00 \\ Car & $ & 17,000.00 \end{tabular} Net Worth $ 12,555.00 Statement of Cash Flows Infiows End of 2020 Salary \begin{tabular}{lllll} & $ & 2,976.00 & $ & 35,712.00 \\ \hline Total inflows & $ & 2,976.00 & $ & 35,712.00 \end{tabular} Outfiows Outfiows Savings Weakness 1.Credit Card debt 2. Only paying $352 on my house payment instead of $5001m used to paying in rent to pay off house faster in long run Assignment I: Your Assignment I should include the following: 1. Personal Balance sheet 2. Personal Statement of Cash Flow 3. Identify two strengths and weaknesses based on your current year financial statements. Note: All of your work should be in a single excel file. Please submit Balance Sheet 9/11/2020 Asset Current Assets Cash/Cash Equivalents Annual Current Assets/Current Liat \begin{tabular}{l|rr} Cash & $ & 753.00 \\ Checking Account & $ & 2,523.00 \\ Savings Account & $ & 2,146.00 \\ & & \\ Total Cash/Cash Equivalents & $ & 5,422.00 \end{tabular} Invested Assets \begin{tabular}{l|l|l|l|} 401(k) & $ & 149.00 \\ Total invested Assets & $ & 149.00 \\ \hline \end{tabular} Personal Use Asset \begin{tabular}{l|lr} House & $ & $0,000.00 \\ Iphone & $ & 700.00 \\ Furniture & $ & 500.00 \\ Car & $ & 17,000.00 \end{tabular} Net Worth $ 12,555.00 Statement of Cash Flows Infiows End of 2020 Salary \begin{tabular}{lllll} & $ & 2,976.00 & $ & 35,712.00 \\ \hline Total inflows & $ & 2,976.00 & $ & 35,712.00 \end{tabular} Outfiows Outfiows Savings Weakness 1.Credit Card debt 2. Only paying $352 on my house payment instead of $5001m used to paying in rent to pay off house faster in long run

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!