Can you help me create a balance sheet?

Project 1 Accounting Entry for Virtual Clinic_Blank.xbox - Excel ? 6 - 5X FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Kevin Rodriguez X Cut Calibri - 11 - A" A Wrap Text General EX AutoSum . AH BE Copy Fill - Paste Format Painter BIU - - A. Merge & Center $ ~ % " 08 08 Conditional Format as Cell Insert Delete Format Sort & Find & Formatting Table Styles Clear Filter Select - Clipboard Font Alignment Number Styles Cells Editing $20 X Vfx B C D G H M P Q S 1 Transaction Time Transaction amour Description Item Credit Debit 2 Dec 31st, 2010 $100,000 |class Paid in capital (owner's equity 100000 lan. 1s We collected $100,000 in total from the whole class (some rich students!) 3 Cash [asset 10000 We borrowed $200,000 from a local bank (the term is 30 years) 4 Dec 31st, 2011 $200,000 bank loan bank loan (long term liability 200000 Jan. 15 We bought an office space for $150,000 5 Cash [asset) 200000 We bought office equipment for $10,000 office space 6 Jan 15th, 2011 $ 150,000 purchase office building (asset) 50000 We bought supplies for $6,000 but only paid half of them ($3,000) in cash the other half is on credit. 7 Cash (asset) 150000 Feb. 1s We have hired a staff at an annual wage of $30,000 8 Jan 15th, 2011 10,000 Office equipment office equipment (asset) 10000 a manager is paid at an annual wage of $50,000 9 Cash [asset) 10000 By the : We've had 150 patient visits so far and each patient brings in $50 revenue per visit (no cash receive 10 Jan 15th, 2011 $6,000 supplies inventory (asset) 6000 We paid on call nurses at a rate of $20 per patient visit (paid cash) 11 Dash (asset) 3000 Each patient visit consumes $10 worth of supply 12 accounts payable (liability) 3000 Someone in our class is getting paid as a manager at an annual wage of $50,000 (any volunteer?) 5 months wage for 13 June, 2011 $ 12,500 staff w age expense 12500 14 Cash (asset 12500 5 months wage for 15 June, 2011 $20,833.33 manager wage expense 20833 16 Cash (asset] 20833 17 $7,500 Patient revenue Accounts receivable (assets) 7500 18 revenue 7500 19 $3,000 pay to oncall Expense 3000 20 Cash [asset 3000 21 $1,500 supplies expenses 1500 22 inventory (asset) 1500 23 24 25 Total 511333 511333 Balance Shoot Sheet1 Sheet2 2 Sheet3 + 68% READY 80F GERNSZOO 9:14 PM 8/31/2021