Enter the following data starting cell B$7$ with $340$ for cash:

Assets: Cash $-340,$ Clothes $-1259,$ CD Collection $-250,$ CD Player $-350,$ Books $-300,$ Computer $-1400,$ Jewellery $-375,$ Miscellanecus $-200.$ After placing the amounts above into the spreadsheet, place your cursor in cell B$16$ and use the formula $=$sum$($B$7$:B$14).$

Liabilities: Type in the words "Owed to Sister" in cell D$7,$ and $100$ in E$7,$ Owed to Mom $50$ in the cells below. Put "Total Liabilities" in D$9$ and then total the liabilities in cell E$9.$

Capital. Calculate A$.$ Beck's Capital in cell E$13.$ This would be $=816-E9.$

Total Liabilities & Owner's Equity: This should be $=E9+E13$