Step 03: Modify the template spreadsheet by replacing Your Name in cell A1 with your name. Change cell (:2 to the current date a balance sheet is a "snap shot\" of your finances at a specrfrc date. Step 04: Modify the template spreadsheet to create a balance sheet for yourself. Be creative. Again, I imagine if you are a young college student, you may or may not have many assets and/or liabilities. You could imagine five years from now when you, perhaps, own a car, maybe started a 401K at your job, &etc. Alternatively, you c0uld imagine y0ur parent's household assets and liabilities - a house, but also a home mortgage! Do three things: (1) change/delete the descriptions in column A. If you delete, delete the entire row. But try to have three or four items under each subtotal. See the below balance sheets in this document for some ideas, or refer again to Evaluating Your Personal Financial Statement. (2) fill in column B for the current year 2020, with dollar amountsl. If you use actual values, be sure to change them before submitting. Fill in amounts for what you think, or hope, you will have five years from now in the year 2025 for column C. Lastly, (3) double check your Net Worth value for both years is equal to Total Assets minus Total Liabilities for that year. Fix any formulas, if needed. Formatting v Table ~ Styles Paste GEESE Merge & Center $ 90 9 00 0 Cells Alignment Number Styles Clipboard Font Sign In i SIGN IN TO OFFICE It looks like your stored credentials are out of date. Please sign in as sk** *@oat**** edu so we can verify your subscription. A1 X V fx Your Name: B C D A Balance Sheet 2 Your Name: October 23, 2020 3 Assets + 4 Cash and Cash Equivalents 2020 2021 5 Cash 10.00 100.00 6 this could be your checking or savings accounts 20.00 7 this could be another of your checking or savings accounts 8 this could be another of your checking or savings accounts 9 Other 10 Total Cash and Cash Equivalents 10.00 120.00 11 12 Property 2020 13 this could be your car 1 2021 20.00 14 this could be your car 2 or some other vehicle 400.00 15 this could be your home furnishings, electronics, jewelry 16 this could be your home, if you own one 17 Other 18 Total Property 19 20.00 Balance sheet 400.00 Edit Type here to search