ACCT 110 Integrated Excel Assignment #2 - Instructor: Nicole Harris Part 1: Balance Sheet and Income...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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? 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?
Expert Answer:
Answer rating: 100% (QA)
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... View the full answer
Related Book For
Fundamentals of Financial Accounting
ISBN: 978-1259269868
5th Canadian edition
Authors: Fred Phillips, Robert Libby, Patricia Libby, Brandy Mackintosh
Posted Date:
Students also viewed these accounting questions
-
Truck dealership advertises that it has 20 trucks for sale. Quality inspector finds that 7 of the trucks have mechanical defects in the engine. If a truck company purchases 2 trucks at random from...
-
7) The second financial statement to prepare is the statement of retained eamings. To determine the ending balance of retained earnings you need to start with the opening balance as reported in the...
-
The ability to perform conceptual skills O interpersonal skills human skills technical skills increases in its importance to success as managers rise through the managerial ranks.
-
Assuming @Weather is a valid repeatable annotation that takes a String, with its associated containing type annotation @Forecast, which of the following can be applied to a type declaration? (Choose...
-
During the month of October 2015, Weller Company had the following transactions: 1. Revenues of $12,000 were earned and received in cash. 2. Bank loans of $3,000 were paid off. 3. Equipment of $2,500...
-
Suppose output Q is given by the Cobb-Douglas production function Q(K, L) = AK L 1 , where A and are positive constants and 0 < < 1. Show that if K and L are both multiplied by the same positive...
-
How do you calculate your net worth when preparing a balance sheet?
-
Equity Securities Entries Capriati Corporation made the following cash purchases of securities during 2010, which is the first year in which Capriati invested in securities. 1. On January 15,...
-
2022 Formula One World Championship pre-season testing session just started and due to the porpoising safety issues of the Formula One cars of Bugatti Racing Limited, the price of its shares...
-
The COVID-19 pandemic affected companies in the food industry in unique ways, particularly during 2020. Ruth's Hospitality Group (Ticker: RUTH) develops and operates fine dining restaurants under the...
-
Assume you invest $1,500 today in an investment that will earn 4% per year. How much money will you have at the end of 6 years under each of the following situations? 1. Interest is paid annually 2....
-
Write a memorandum predicting the strength of the claim being brought against them. As you know, litigating in federal court can be expensive, especially for a small family-run restaurant. I want you...
-
What is Direct Response Marketing? Outline and explain its various components. (Based on Marketing)
-
Security researchers often use conference platforms such as DefCon and RSA to announce newly discovered security tools or bugs/vulnerabilities. Often these conferences are controversial. They invite...
-
1. What is the objective of the product? 2. Who is the target customer of the product? 3. What is the underlying Islamic contract of the product? 4. How to calculate the hibah or profit sharing of...
-
Apply the LA Duty Risk Analysis for negligence on this fact pattern. Suggested Format for a Duty/Risk* Outline of Format Introductory Statement - Frame the issue regarding potential negligence...
-
A Treasury Bond with $1,000 par value and 6 years to maturity pays a 6% semi-annual coupon. The YTM is 8%, APR semi-annual compounding. A coupon has just been paid. A futures contract expiring in 15...
-
Use Stokes' Theorem to evaluate f(y+sin x) dx+(z+cos y) dy+rdz, where C is the rve r(t) = (sint, cost, sin 2t), t = [0, 2].
-
Assume that a recent annual report for FedEx Corporation contained the following data (in millions): Required: 1. Determine the receivables turnover ratio and days to collect for 2017. Round your...
-
On December 31, 2017, Dyer Inc. completed its first year of operations. Because this is the end of the annual accounting period, the company bookkeeper prepared the following preliminary income...
-
During 2017, Bhumika Company disposed of two different assets. On January 1, 2017, prior to the assets disposal, the accounts reflected the following: The machines were disposed of in the following...
-
Calculate \(\frac{38}{73}+\frac{7}{73}\).
-
Calculate \(\frac{4}{9}+\frac{7}{12}\).
-
Convert 17.03347 to fraction form.
Study smarter with the SolutionInn App