All students must create a Balance Sheet using the information provided below for Dr$.$ Smith's Clinic. Students must utilize the Balance sheet format provided during the lecture and create a balance sheet using the information below.

Dr$.$ Smith's clinic has been running from long time. The information below summarizes how things looked at the end of Dec $31,2023.$

$1.$During the year Dr$.$ Smith purchased computer tables and chairs for the clinic. For this purchase Dr$.$ Smith paid $$30,000$ in cash.

$2.$Dr$.$ Smith has $$10000$ dollars cash currently in the business account

$3.$Dr$.$ Smith provided $15000$ worth of clinical care to team of athletes and is yet to receive payments

$4.$There are number of items in stocks that the clinic can sale for example medicines, injections, compression stockings worth $$5000$

$5.$Net income for the year was $$50000$

$6.$Last year clinic's profit was $$30,000$

$7.$Total amount of equipment that the clinic owns is estimated at $$100,000$

Please create a Balance sheet using the information provided using Excel or word for this assignment.