For this assessment, complete Problems 1, 2, and 3. You may use Word or Excel to complete the assessments throughout this course, but you will find Excel to be most helpful for creating spreadsheets. Tutorials for using Excel are provided in the Supplemental Resources in the left navigation menu. If you use Excel, submit the assessment in one Excel document, using separate tabs for each spreadsheet.
Problem 1: Preparing an Income Statement, Statement of Retained Earnings, and Balance Sheet
You may wish to use the Preparing Financial Statements Template, which is linked in the Resources under the Capella Resources heading, to complete this problem.
At the end of its first year of operations (December 31, 2012), the Acme Company released the financial data shown in the chart below:
Acme Company Financial Data
|
Accounts
|
Amount
|
|
Cash.
|
$25,000
|
|
Receivables from customers (no allowance for doubtful accounts is needed).
|
$20,300
|
|
Inventory of merchandise.
|
$81,000
|
|
Equipment owned, at cost of $60,700 net of A/depreciation of $20,000.
|
$40,700
|
|
Accounts payable owed to supplies.
|
$66,140
|
|
Salary payable for 2012 (to be paid on January 4, 2013).
|
$1,800
|
|
Total sales revenue.
|
$126,000
|
|
Operating expenses, including the cost of the merchandise sold.
|
$80,200
|
|
Income taxes expense at 30% of pretax income; all paid during 2012.
|
?
|
|
Contributed capital 10,000 shares outstanding.
|
$87,000
|
|
Dividends declared and paid during 2012.
|
$20,000
|
Using knowledge from prior courses, work experience, textbooks, or Internet sources, as well as the financial data provided in the chart above, prepare the following financial statements for the Acme Company:
Summarized Income statement for the year 2012.
Statement of retained earnings for the year 2012.
Balance sheet at December 31, 2012.
Prepare Liquidity Ratios and explain what those ratios tell us.