create it in excel

The following is the trail Balance of Mr. Mathew as of March 31st 2022, you are required to prepare the trading, Profit and loss Account for the ending March 31st 2023. Balance as on date after 1. Stock on March 31st, 2023, was valued at $775,000. 2. Provision for Bad and Doubtful Debts @ 5% is to be created. 3. Depreciate Furniture and fittings by 10% and Motor Car by 20% 4. Proprietor had withdrawn good worth $25000 during the years. 5. Salesmen are entitled to a commission of 5% on total sales. 6. Debtors included $25,000 bad debts. 7. Purchases include $50,000 worth of furniture. 8. Prepared Insurance $5,000