Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

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... 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

Database Systems A Practical Approach to Design Implementation and Management

Authors: Thomas Connolly, Carolyn Begg

6th Edition Global

132943263, 978-0132943260

More Books

Students also viewed these General Management questions