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






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
Get step-by-step solutions from verified subject matter experts
