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$

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

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

$6.$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.