Illustrate the effects on the accounts and financial statements of the following transactions in the accounts of MedTech Co., a local hospital supply company that uses the direct write-off method of accounting for uncollectible receivables:

Feb. 14. Received $9,000 on an account and wrote off the remainder owed of $45,000 as uncollectible.

Dec. 23. Reinstated the account that had been written off on February 14 and received $45,000 cash in full payment.

If I could see this in excel I would appreciate it.