Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

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

Modern Internal Auditing Appraising Operations And Controls

Authors: Victor Z. Brink, Herbert N. Witt

4th Edition

0471080977, 978-0471080978

More Books

Students also viewed these Accounting questions

Question

What does project failure mean? What are some good examples?

Answered: 1 week ago

Question

3. Is there action in verbs rather than in nouns or infinitives?

Answered: 1 week ago

Question

Design a health and safety policy.

Answered: 1 week ago