Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

on an excel sheet please. (1 Worksheet) Your business took out a $200,000 loan so that is your starting balance. Create a detailed banking ledger

on an excel sheet please. image text in transcribed
(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Audit Quality And Financial Statements Fraud Detection

Authors: Asma Al-znaimat, Mohammad Al- Dahiyat

1st Edition

3659537888, 978-3659537882

More Books

Students also viewed these Accounting questions

Question

7. Understand the challenges of multilingualism.

Answered: 1 week ago