Answered step by step
Verified Expert Solution
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started