Description Prepare the following IN EXCEL! This is due on December 16, 2017. (a
ID: 2589265 • Letter: D
Question
Description
Prepare the following IN EXCEL! This is due on December 16, 2017.
(a) a multiple-step income statement,
(b) a statement of owner's equity,
(c) a balance sheet in report form from the following data for Burt Co., taken from the ledger after adjustments on December 31, the end of the fiscal year.
(d) explain your findings in detail about profitability and liquidity. In a sentence form
Accounts Payable
$97,200
Accounts Receivable
64,300
Accumulated Depreciation—Office Equipment
72,750
Accumulated Depreciation—Store Equipment
162,100
Administrative Expenses
56,500
Cash
53,000
Cost of Merchandise Sold
121,700
Interest Expense
12,000
Maeve Burt, Capital
81,750
Maeve Burt, Drawing
52,000
Merchandise Inventory
93,250
Note Payable (due in two years)
154,000
Office Equipment
149,750
Prepaid Insurance
6,500
Rent Revenue
17,500
Salaries Payable
28,700
Sales
365,500
Selling Expenses
41,500
Store Equipment
325,000
Supplies
4,000
Description
Prepare the following IN EXCEL! This is due on December 16, 2017.
(a) a multiple-step income statement,
(b) a statement of owner's equity,
(c) a balance sheet in report form from the following data for Burt Co., taken from the ledger after adjustments on December 31, the end of the fiscal year.
(d) explain your findings in detail about profitability and liquidity. In a sentence form
Accounts Payable
$97,200
Accounts Receivable
64,300
Accumulated Depreciation—Office Equipment
72,750
Accumulated Depreciation—Store Equipment
162,100
Administrative Expenses
56,500
Cash
53,000
Cost of Merchandise Sold
121,700
Interest Expense
12,000
Maeve Burt, Capital
81,750
Maeve Burt, Drawing
52,000
Merchandise Inventory
93,250
Note Payable (due in two years)
154,000
Office Equipment
149,750
Prepaid Insurance
6,500
Rent Revenue
17,500
Salaries Payable
28,700
Sales
365,500
Selling Expenses
41,500
Store Equipment
325,000
Supplies
4,000
Explanation / Answer
a) Income Statement (Amount in $)
b) Statement of Owner's equity (Amount in $)
c) Balance Sheet (Amount in $)
d) Net profit margin = (Net profit/Sales)*100 = (151,300/365,500)*100 = 41.40%
Current ratio = Current Assets/Current Liabilities = 221,050/125,900 = 1.76 times
Liquid ratio = Liquid Assets/Current liabilities = 121,300/125,900 = 0.96 times
The company's profitability is good but its liquidity position is not so good and need to be improved.
Sales (A) 365,500 Cost of merchandise sold (B) (121,700) Gross Profit (C = A-B) 243,800 Operating Expenses : Selling Expenses 41,500 Administrative Expenses 56,500 Total Operating Expenses (D) (98,000) Operating income (E = C-D) 145,800 Non Operating items: Rent Revenue 17,500 Interest Expense (12,000) Total Non Operating (F) 5,500 Net Income (E+F) 151,300