It is the end of 2019, and you have been asked to create financial statements for...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
It is the end of 2019, and you have been asked to create financial statements for the year. Your manager has given you the trial balance on the left. Accounts Cash Accounts Receivable Supplies Equipment 31-Dec-19 Land Accounts Payable Notes Payable Owner's Capital Owner's Withdrawal Consulting Revenue Rent Expense Wage Expense Insurance Expense Advertising Expense Tax Expense Totals DR 22000 13000 2600 5000 20000 4600 15000 30000 3000 6250 7350 CR 9500 15600 28000 75700 128800 128800 Using Excel, create the following: • Income Statement • Balance Sheet • Statement of Owner's Equity It is the end of 2019, and you have been asked to create financial statements for the year. Your manager has given you the trial balance on the left. Accounts Cash Accounts Receivable Supplies Equipment 31-Dec-19 Land Accounts Payable Notes Payable Owner's Capital Owner's Withdrawal Consulting Revenue Rent Expense Wage Expense Insurance Expense Advertising Expense Tax Expense Totals DR 22000 13000 2600 5000 20000 4600 15000 30000 3000 6250 7350 CR 9500 15600 28000 75700 128800 128800 Using Excel, create the following: • Income Statement • Balance Sheet • Statement of Owner's Equity
Expert Answer:
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
Case Swimmers Headphones1 Finally! Its the end of 2019 and you are sitting at your new desk in a plush office in north Bogota, with a delicious cup of Colombian coffee. You think about all it took to...
-
BACKGROUND You are an information analyst working for NEE. The company president has asked you to prepare a Quantitative analysis of financial, sales, and operations data to help determine which...
-
You are the audit manager in the audit firm of M&G Partners Chartered Accountants. One of your audit clients is Fair Leather Zambia Ltd (FLZ Ltd) which specializes in the manufacture and supply...
-
Write a data type Interval that implements the following API: An interval is defined to be the set of all points on the line greater than or equal to min and less than or equal to max. In particular,...
-
The range of a small set of measurements has traditionally been used as a measure of variability for x and R charts. Why isn't standard deviation used instead? And why are two charts necessary, an x...
-
Determine the variance and standard deviation of the following sample. 12 6 22 31 23 13 15 1721
-
Which of the following statements about basic assumptions is incorrect? a. Basic assumptions are the same as accounting principles. b. The economic entity assumption states that there should be a...
-
Accountants have advocated two types of income statements based on differing views of the concept of income: the current operating performance and all- inclusive concepts of income. Required: a....
-
Cash, goods, or assets invested by the proprietor in the business for earning profit is called _ _ _ _ _ _ . ( a ) Profit ( b ) Capital ( c ) Fixed assets ( d ) None of these
-
In addition to a Gantt chart, youve drawn Brian a PERT diagram so that you can communicate the necessity to keep an eye on the critical path. Consult Figure which was derived from the data from...
-
help The graph of the function \( h(x) \) is shown below. Use the graph to answer the following questions. 2 answers
-
noin 2. Assume the following current information: (i) The deposit rate on Euro-yen 6-month deposits = 3% per annum (ii) The deposit rate on Eruo-Cdn $ 6-month deposits = 4% per annum (iii) The...
-
The following information pertains to ABC Company's Direct Labor for March: Standard DL Hours - 21,000 Actual DL Hours - 20,000 Labor Rate Variance - 8,400 Favorable Standard Labor Rate per hour is...
-
On July 1, 20x1, Sanchez Corporation acquired 3,000 shares (20% ownership) of Beal Corporation common stock at $40 per share plus brokerage fees of $600. The investment of $120,000 was $6,000 greater...
-
Transaction Deposits or checking account; transaction account; Savings Deposits or savings account; Time deposits;Money Market Deposit Accounts For each service, describe whether it reflects an asset...
-
Question 1: Case study on Lydo Cinema Chain Lydo Cinema Chain based in Melbourne, owns three cinemas in the suburbs of Camberwell, South Yarra and Ringwood. It has prepared budgets for the coming...
-
Examine the graph of the function belo derivative positive? T -1 1 The second derivative is never positive The second derivative is always positive 2 2 3
-
Use nodal analysis to determine voltages v1, v2, and v3 in the circuit Fig. 3.76. Figure 3.76 4 S 3i, 2 A 4A
-
Floral Delivery, Inc. (FD) acquired a fleet of vans on January 1, 2013, by issuing a $500,000, 4-year, 4% fixed rate note, with interest payable annually on December 3. FD has the option to repay the...
-
SunTrust Banks owns a large block of Coca-Cola Company (Coke) common stock that it has held for many years. SunTrust indicates in a note to its financial statements that all equity securities held by...
-
Explain the implications of a value-to-book ratio that is exactly equal to 1. Compare the implications of a value-to-book ratio that is greater than 1 to those of a value-to-book ratio that is less...
-
On September 1, 20x6, A Company purchased 100 percent of the voting stock of B Company for $480,000 in cash. The separate condensed balance sheets immediately after the purchase were as follows:...
-
Dale Company experiences heavy sales in the summer and early fall, after which time it has excess cash to invest until the next spring. On November 1, 20x6, the company invested $194,000 in U.S....
-
Scattergraph method Using the data in E4-2 and a piece of graph paper: 1. Plot the data points on the graph and draw a line by visual inspection, indicating the trend shown by the data points. 2....
Study smarter with the SolutionInn App