Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the below account balances for Baylee Inc., and in this order: A-Prepare an Income Statement for the Year Ended Dec. 31, 2022 in proper

Using the below account balances for Baylee Inc., and in this order: A-Prepare an Income Statement for the Year Ended Dec. 31, 2022 in proper format using Excel. B-Calculate the ending retained earnings balance as of 12/31/22 (beginning retained earnings is given). C - Prepare the Balance Sheet as of December 31, 2022 AND 2021 in good format using Excel. 2022 2021 Accounts Payable 81,000 78,000 Accounts Receivable, net of uncollectible accounts 87,000 92,000 Additional Paid-in Capital 15,000 15,000 Automobiles 29,000 22,000 Building Improvements 62,000 48,000 Buildings 405,000 275,000 Cash 126,000 110,000 COGS 482,000 Common Stock $1 par, 400,000 shs authorized, 30,000 shs issued, 25,000 shs 30,000 30,000 outstanding Computer Equipment 18,000 17,000 Conferences & Travel Expense 9,000 Depreciation & Amortization Expense 12,000 Dividends Paid 10,000 General & Administrative Expense 150,000 Goodwill Income Tax Expense Insurance Expense Interest Expense Interest Income 115,000 115,000 32,000 15,000 12,000 14,000 Interest Payable Land 18,000 14,000 120,000 120,000 Accumulated Amortization Accumulated Depreciation Long-Term Bonds Payable Long-Term Note Payable Merchandise Inventory Net Sales Patents Preferred Stock Prepaid Insurance Production Equipment -30,000 -28,000 -118,000 -108,000 190,000 119,000 210,000 178,000 20,000 18,000 957,000 45,000 45,000 22,000 22,000 15,000 12,000 43,000 39,000 Research & Development Expense 13,000 Retained Earnings ? (need to calculate) 190,000 Selling Expense Short-Term Marketable Securities Short-term Note Payable 21,000 18,000 15,000 142,000 156,000 Trademarks Treasury Stock 5,000 shs Utilities Expense 16,000 16,000 -5,000 -5,000 18,000 Wages Expense Wages Payable 131,000 12,000 11,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Vba Advanced Advanced Techniques For Finance Pros

Authors: Hayden Van Der Post

1st Edition

979-8864994818

Students also viewed these Accounting questions

Question

Identify a number of current business strategies.

Answered: 1 week ago

Question

Define Management by exception

Answered: 1 week ago

Question

Explain the importance of staffing in business organisations

Answered: 1 week ago

Question

What are the types of forms of communication ?

Answered: 1 week ago

Question

Explain the process of MBO

Answered: 1 week ago

Question

4. Describe the factors that influence self-disclosure

Answered: 1 week ago

Question

1. Explain key aspects of interpersonal relationships

Answered: 1 week ago