Question: you are required to create the 4 basic financial statements for ZZZ Widget Company. Go through details described below, and create an Excel spreadsheet that

you are required to create the 4 basic financial statements for ZZZ Widget Company. Go through details described below, and create an Excel spreadsheet that shows an income statement, balance sheet, statement of owners equity, and statement of retained earnings. Grading is based on accuracy as well as the style of the Excel sheet. I expect for you to use formulas and references as needed. ZZZ Widget Company was formed Dec 1, 2020 with a $200,000 owner investment. Took a 50,000 loan on 6/31 (12% annual interest rate) Distributed $10,000 in dividends in December. Purchased $100,000 of inventory in August (cash). In September, sold half of inventory for $200,000 cash. Purchased $50,000 building in January, 2020. Lifetime of 10 years. Paid $50,000 R&D in May The company pays 21% in corporate taxes

Step by Step Solution

★★★★★

3.50 Rating (157 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Income statement for the Financial year ended Dec 2020 Expenditure Amount Income Amount To Gross Loss 20000 WNo4 To Depreciation 5000 To Interst on Lo... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Create the 4 basic financial statements for ABC Dream Company. And break those down to determine the worth of the company, would you invest? ABC Dream Company was formed Dec 1, 2020 with a $200,000...

A company manufactures and retails clothing. You are required to group the costs which are listed below and numbered (1)-(20) into the following classifications (each cost is intended to belong to...

You are required to create a chart, diagram, or task list to accompany your Milestones Schedule. A Gantt chart, network diagram, or task list are all appropriate formats. Select the format you think...

As a team , you are required to create the 4 basic financial statements for ZZZ Widget Company. Go through details described below, and create an Excel spreadsheet that shows an income statement,...

Q1-Explain how the EBIT Chart works (inputs determining the outputs-the two lines on the chart Case Leahy Bread Company (LBC) in Cohen Finance Workbook, page 111( a 'caselette') SEE THE IS/BS MODEL &...

get an anwer and solution of problem in both paper 1 full disclousure second revenue recognition IV. Test Questions and Solutions Chapter 1 Multiple Choice 1. What basic financial statements can be...

The Financial statements for Nike, Inc. are presented in Appendix C at the end of the text. The following additional information (in thousands) is available. I NEED HELP WITH LETTERS E - M 17...

Hi I know you opted out of an earlier question. I have several open questions. I really need to get them in. Would you be willing to take any of these questions? I have been waiting for 3 days. I...

Could you finish this for me? I made it to page 5, but I am running short on time and my conceptualization is lacking. If not, maybe help me figure it out? Annual Report Project Lowe's Companies,...

Required: Using the AREA framework, answer the following question: the following media coverage of Slater and Gordon?s financial performance and position is published and available on Blackboard...

The contribution margin ratio is Select one: a. the same as the variable cost ratio b. the same as profit c. the portion of equity contributed by the stockholders d. the same as the profit-volume...

A politician develops legislation to increase economic equity. Their opponent refutes the legislation, saying, "He is a billionaire, so how can his policy be legitimate?" What kind of misdirection...

Please read the article in the link below and answer the questions. https://kdvr.com/news/macys-typo-leads-to-1500-necklace-being-sold-for-47/ Macy's typo leads to $1,500 necklace being sold for $47...

The Covid-19 pandemic has forced many countries to partially shutdown their economies to prevent the spread of the virus. In response, many governments including Barbados have embarked on...

Total cash available $64.000 Less cash disbursements For inventory $47,850 For expenses 13,300 For equipment 1,500 Total cash disbursements 62,650 Excess (deficiency) of cash $1,350 Financing: Etc....

Review the annual reports of PepsiCo and Amazon, two of the largest publicly traded firms in America. Compute and compare the accounts receivable turnover ratios and the average collection period in...

The selection of an appropriate inventory cost formula for an individual company is made by O the external auditors. O the accounting standards for private companies. the International Financial...

Pearson Education, a publisher of college textbooks, would like to know if students prefer traditional textbooks or digital textbooks. A random sample of students was asked their preference and the...

Implement the above schema in one of the RDBMSs you currently use. Implement, where possible, the primary, alternate, and foreign keys, and appropriate relational integrity constraints.

What is a timestamp? How do timestamp-based protocols for concurrency control differ from locking based protocols?

Create local conceptual data models for each of the user views. State any assumptions necessary to support your design.

Recently, several long-time customers at the Sweet Haven Chocolate Company have complained about the quality of the chocolates. It seems there are several partially covered chocolates being found in...

Tamarack Resorts and Properties is considering opening a skiing area near McCall, Idaho. It is trying to decide whether to open an area catering to family skiers or to some other group. To help make...

Ponderosa Paint and Glass makes paint at three plants. It then ships the unmarked paint cans to a central warehouse. Plant A supplies 50% of the paint, and past records indicate that the paint is...