create it in excel The following is the trail Balance...

90.2K

Verified Solution

Question

Accounting

create it in excel
image
image
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

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students