given the background information, please create a trial balance, journal entry and t accounts in excel.

Activities for Starburst Meadows Business Unit in Period ending January 31st, 20XX 1/1/20XX - Took out a 0% interest loan from Cheyenne Crimson N+X Tech Foundation in the form of a Note for $50,000, to be paid back in one year 1/1/20XX - Prepaid for 12 months of Advertising for $2,400 total 1/1/20XX - Prepaid for 6 months of Rent for an office used to sell complex engineering materials and provide consulting services. Amount paid was $9,000 total 1/3/20XX - Purchased Supplies from Papyrus-R-Us in the form of 4,000 notebooks at $2 each, all paid for in Cash. These notebooks are used by Hardware Engineers for a variety of things, such as writing down observations during testing or consultations 1/5/20XX - Purchased Merchandise Inventory in the form of 100 Quantum Discs from Radiant Velocity for $50 each, all on account, no discount given. These are highly sought-after engineering materials used for a variety of Quantum applications 1/6/20XX-Sold 80 Quantum Discs to Infinite Microns for $75 each, all on Account, terms a 20/10, n/30 1/7/20XX - Purchased 100 Quantum Discs from Radiant Velocity for $80 each, all on Account, terms are 10/10, n/30. The price of discs increased due to increased manufacturing costs. 1/10/20XX-Paid Radiant velocity for 1/5/20XX purchase 1/15/20XX - Elegant Vectors prepays for 10 consulting sessions, each one valued at $1,250 per session 1/16/20XX - Paid Radiant Velocity for 1/7/20XX purchase 1/17/20XX-Sold 110 Quantum Discs to Serial Systems for $140 each, paid in Cash. 1/24/20XX-Hired Erica Song, Software Engineering Intern, for a weekly wage of $800. Employees are paid on the 15th of every month. 1/25/20XX - Purchased 50 Quantum Discs from Radiant Velocity for $60 each, all on account, no discount given. Radiant Velocity has notified us that the manufacturing issues were resolved 1/27/20XX - Infinite Microns returns all Quantum Discs purchased on 1/6/20XX due to product defects. Hardware Engineers are determining the cause of the defects, as they render the Quantum Discs completely unusable 1/28/20XX - Sold 30 Quantum Discs to Serial Systems for $170 each paid in Cash 1/29/20XX-Provided a consulting session to Serial Systems for $1,000, paid in Cash 1/31/20XX-Upon a month-end Supplies review, a physical count of notebook Supplies left in the supply room and available at the end of the month was 1,200 notebooks. Hardware Engineers have also noted that 4 consulting sessions were provided on Elegant Vector's 1/15/20XX account. These adjustments, in addition to others, must be accounted for Voicemail from Agatha Hathaway, Sr. Analyst, Internal Audit, Violet Arrays "Hi there, and welcome to Violet Arrays! Sorry I wasn't able to catch up with you this morning, as I was called in to another meeting that took much longer than expected. Given that we're completing a full company audit, our department is going to be quite busy for the next few weeks. As a recap of our team's mission, we are here to monitor Violet Arrays for any business operation or Accounting anomalies to ensure we are properly following GAAP rules. Given that this is your first day at work, management wanted to start you off light. They asked me to put you in touch with some of the other Analysts and give you a few exercises to get yourself acquainted with the 'Violet Array way' of doing business. Expect an email from me shortly with some instructions." Voicemail from Christopher Farris, Analyst, Internal Audit, Violet Arrays "Hey, it's Chris from orientation! I just talked to Agatha, who has given me direction regarding what we're assigned to do on our first day. It looks like we're going to have to replicate a set of journal entry postings related to activities during the month for a business unit within the company. I guess the only way for us to learn about Violet Arrays is to dig into these business transactions! I'll meet up with you later today at the conference room to get this done." Email from Agatha Hathaway, Sr. Analyst, Internal Audit, Violet Arrays Hello again, sorry for the delay. I've been held back by a few things, but I managed to gather the business activities that you'll need to complete the task. You'll first have to transform business activities into journal entries and post them to the General Ledger. After all of that is done, make sure you create a Trial Balance to show the Adjusted Trial Balance. You'll be able to work with Chris and a few other analysts, so this shouldn't be too difficult to complete as a team. In the next page is the information in the form of business activities by date of occurrence. One thing to note: Violet Arrays' Inventory Costing method (much like its employee retention as of recent) is LIFO. Also, assume there's no beginning balance for any Accounts in the Starburst Meadows Business Unit. Activities for Starburst Meadows Business Unit in Period ending January 31st, 20XX 1/1/20XX - Took out a 0% interest loan from Cheyenne Crimson N+X Tech Foundation in the form of a Note for $50,000, to be paid back in one year 1/1/20XX - Prepaid for 12 months of Advertising for $2,400 total 1/1/20XX - Prepaid for 6 months of Rent for an office used to sell complex engineering materials and provide consulting services. Amount paid was $9,000 total 1/3/20XX - Purchased Supplies from Papyrus-R-Us in the form of 4,000 notebooks at $2 each, all paid for in Cash. These notebooks are used by Hardware Engineers for a variety of things, such as writing down observations during testing or consultations 1/5/20XX - Purchased Merchandise Inventory in the form of 100 Quantum Discs from Radiant Velocity for $50 each, all on account, no discount given. These are highly sought-after engineering materials used for a variety of Quantum applications 1/6/20XX-Sold 80 Quantum Discs to Infinite Microns for $75 each, all on Account, terms a 20/10, n/30 1/7/20XX - Purchased 100 Quantum Discs from Radiant Velocity for $80 each, all on Account, terms are 10/10, n/30. The price of discs increased due to increased manufacturing costs. 1/10/20XX-Paid Radiant velocity for 1/5/20XX purchase 1/15/20XX - Elegant Vectors prepays for 10 consulting sessions, each one valued at $1,250 per session 1/16/20XX - Paid Radiant Velocity for 1/7/20XX purchase 1/17/20XX-Sold 110 Quantum Discs to Serial Systems for $140 each, paid in Cash. 1/24/20XX-Hired Erica Song, Software Engineering Intern, for a weekly wage of $800. Employees are paid on the 15th of every month. 1/25/20XX - Purchased 50 Quantum Discs from Radiant Velocity for $60 each, all on account, no discount given. Radiant Velocity has notified us that the manufacturing issues were resolved 1/27/20XX - Infinite Microns returns all Quantum Discs purchased on 1/6/20XX due to product defects. Hardware Engineers are determining the cause of the defects, as they render the Quantum Discs completely unusable 1/28/20XX - Sold 30 Quantum Discs to Serial Systems for $170 each paid in Cash 1/29/20XX-Provided a consulting session to Serial Systems for $1,000, paid in Cash 1/31/20XX-Upon a month-end Supplies review, a physical count of notebook Supplies left in the supply room and available at the end of the month was 1,200 notebooks. Hardware Engineers have also noted that 4 consulting sessions were provided on Elegant Vector's 1/15/20XX account. These adjustments, in addition to others, must be accounted for Voicemail from Agatha Hathaway, Sr. Analyst, Internal Audit, Violet Arrays "Hi there, and welcome to Violet Arrays! Sorry I wasn't able to catch up with you this morning, as I was called in to another meeting that took much longer than expected. Given that we're completing a full company audit, our department is going to be quite busy for the next few weeks. As a recap of our team's mission, we are here to monitor Violet Arrays for any business operation or Accounting anomalies to ensure we are properly following GAAP rules. Given that this is your first day at work, management wanted to start you off light. They asked me to put you in touch with some of the other Analysts and give you a few exercises to get yourself acquainted with the 'Violet Array way' of doing business. Expect an email from me shortly with some instructions." Voicemail from Christopher Farris, Analyst, Internal Audit, Violet Arrays "Hey, it's Chris from orientation! I just talked to Agatha, who has given me direction regarding what we're assigned to do on our first day. It looks like we're going to have to replicate a set of journal entry postings related to activities during the month for a business unit within the company. I guess the only way for us to learn about Violet Arrays is to dig into these business transactions! I'll meet up with you later today at the conference room to get this done." Email from Agatha Hathaway, Sr. Analyst, Internal Audit, Violet Arrays Hello again, sorry for the delay. I've been held back by a few things, but I managed to gather the business activities that you'll need to complete the task. You'll first have to transform business activities into journal entries and post them to the General Ledger. After all of that is done, make sure you create a Trial Balance to show the Adjusted Trial Balance. You'll be able to work with Chris and a few other analysts, so this shouldn't be too difficult to complete as a team. In the next page is the information in the form of business activities by date of occurrence. One thing to note: Violet Arrays' Inventory Costing method (much like its employee retention as of recent) is LIFO. Also, assume there's no beginning balance for any Accounts in the Starburst Meadows Business Unit