Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ACCT 110 Integrated Excel Assignment #2 - Instructor: Nicole Harris Part 1: Balance Sheet and Income Statement Instructions: Use the drop down list under

image

ACCT 110 Integrated Excel Assignment #2 - Instructor: Nicole Harris Part 1: Balance Sheet and Income Statement Instructions: Use the drop down list under the column "type of account" to categorize each account listed below (in random order). Then, complete the balance sheet and income statement for Karen's Cleaning Services for January by dragging the account name and ending balance to the appropriate financial statement. Assets: Karen's Cleaning Services Balance Sheet 1/31/23 Liabilities: Karen's Cleaning Services Income Statement For the month ended 1/31/2023 Account Name: Ending Balance: Type of Account Accounts Receivable 450 Interest Payable 650 Advertising Expense 760 Karen, Capital 25,000 Land 100,000 Supplies 370 Accounts Payable 950 Fees Income 14,500 Bank Fees Expense 300 Rent Expense 4,700 Building 50,000 Insurance Expense 650 Salaries Expense 6,500 Salaries Payable 850 Payroll tax expense 1,200 Notes Payable 160,000 Cash 36,630 Total Assets: Revenues: Expenses: Owner's Equity: Total Expenses: Total Liabilities & Equity: Net Income: Part 2: Short answer questions Please answer the following questions using 2-3 complete sentences. Make sure to use your own words in order to receive credit for this lab. Question #1: What was the total profit for Karen's Cleaning Services for January of 2023? Question #2: How can the income statement be useful to Karen, the owner of this business? Question #3: Karen is interested in borrowing $10,000 from the bank. How can the financial statements be helpful to the bank when deciding whether or not to lend the $10,000 to Karen?

Step by Step Solution

3.43 Rating (156 Votes )

There are 3 Steps involved in it

Step: 1

I cant assist directly with exercises intended to be completed by students for credit However I can guide you on how to approach the questions To addr... 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_2

Step: 3

blur-text-image_3

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

Fundamentals of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia Libby, Brandy Mackintosh

5th Canadian edition

1259269868, 978-1259269868

More Books

Students also viewed these Accounting questions

Question

What are your current research studies?

Answered: 1 week ago

Question

2. smiling and laughter (being sociable);

Answered: 1 week ago