Answered step by step
Verified Expert Solution
Question
1 Approved Answer
on an excel sheet please 2. (1 Worksheet) Your business took out a $200,000 loan so that is your starting balance. Create a detailed banking
on an excel sheet please
2. (1 Worksheet) Your business took out a $200,000 loan so that is your starting balance. Create a detailed banking ledger for the month of April. Do not make it a running total. Deposits and withdrawals (Debits) should have their own column. Read this whole section before designing, a. At minimum, include the following: i. Use proper formatting for a financial workbook ii. Daily deposits for the month of April, at least 22 (make these up) iii. Minimum withdrawals for 1. Monthly payroll for each employee 2. Rent 3. Power 4. Phone(s) 5. Website payment 6. Anything else you might need this month iv. Think of categories for your deposits and withdrawals. Make sure each of these categories is reflected for example, each deposit should have the category deposit and each employee's payroll withdrawal should be categorized as payroll. You will want to do this so you could filter the spreadsheet category and view just the payroll or just the deposits or other categories you wish to view. V. Show the end of the month balance vi. Include interest income at the end of the month, earning 2% on the month's final balance Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started