Question
Using the below account balances for Charlotte Corp., and in this order: A - Prepare an Income Statement for the Year Ended Dec. 31, 2021
Using the below account balances for Charlotte Corp., and in this order: | ||
A - Prepare an Income Statement for the Year Ended Dec. 31, 2021 in proper format using Excel. | ||
B - Calculate the ending retained earnings balance as of 12/31/21 (beginning retained earnings is given). | ||
C - Prepare the Balance Sheet as of December 31, 2021 AND 2020 in good format using Excel. | ||
2021 | 2020 | |
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 outstanding | 30,000 | 30,000 |
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 | 115,000 | 115,000 |
Income Tax Expense | 32,000 | |
Insurance Expense | 15,000 | |
Interest Expense | 12,000 | |
Interest Income | 14,000 | |
Interest Payable | 18,000 | 14,000 |
Land | 120,000 | 120,000 |
Accumulated Amortization | -30,000 | -28,000 |
Accumulated Depreciation | -118,000 | -108,000 |
Long-Term Bonds Payable | 190,000 | 119,000 |
Long-Term Note Payable | 210,000 | 178,000 |
Merchandise Inventory | 20,000 | 18,000 |
Net Sales | 957,000 | |
Patents | 45,000 | 45,000 |
Preferred Stock | 22,000 | 22,000 |
Prepaid Insurance | 15,000 | 12,000 |
Production Equipment | 43,000 | 39,000 |
Research & Development Expense | 13,000 | |
Retained Earnings | ? (need to calculate) | 190,000 |
Selling Expense | 21,000 | |
Short-Term Marketable Securities | 18,000 | 15,000 |
Short-term Note Payable | 142,000 | 156,000 |
Trademarks | 16,000 | 16,000 |
Treasury Stock 5,000 shs | -5,000 | -5,000 |
Utilities Expense | 18,000 | |
Wages Expense | 131,000 | |
Wages Payable | 12,000 | 11,000 |
Once the financial statements are prepared, calculate the following ratios for 12/31/21 (show your work): | ||
D - Gross Margin Ratio | ||
E - Current Ratio | ||
F - Working Capital Ratio | ||
G - Acid-Test Ratio | ||
H - Asset Turnover | ||
I - Inventory Turnover | ||
J - # Days' Sales in Accounts Receivable | ||
K - # of Days' Sales in Inventory | ||
L - ROI | ||
M - ROE | ||
N - Earnings per Share | ||
O - Debt Ratio | ||
P - Debt/Equity Ratio |
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