Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The ledger of Systems Inc. showed the following balances after adjustment, but before closing, on December 31, 2025, the end of the current year (all

The ledger of Systems Inc. showed the following balances after adjustment, but before closing, on December 31, 2025, the end of the current year (all accounts have normal balances):

Insurance expense 12200
Sales returns and allowances 22400
Bad debt expense 7100
Accounts payable 81000
Accounts receivable 108590
Allowance for doubtful accounts 8500
Accumulated depreciation - equipment 27740
Depreciation expense 1200
Interest revenue 2200
Cash 80970
Common stock (10,000 shares outstanding) 100000
Cost of goods sold 598550
Dividends declared 18000
Equipment 139450
General expenses 113250
Dividends payable 2000
Sales discounts 23000
Interest expense 5600
Paid-in capital in excess of par 110000
Marketable Securities 12000
Merchandise inventory 154250
Prepaid insurance 11325
Salaries expense 40100
Retained earnings ?
Dividend Revenue 10000
Salaries Payable 12350
Sales 984000
Selling expenses 139210

The president of Systems Inc., has asked you to develop a flexible financial statement package ;using Excel that includes:

  • a data entry sheet (the information above can be on your data entry sheet)
  • an adjusted trial balance (accounts in proper order),
  • a single-step income statement,
  • a multi-step income statement,
  • a statement of retained earnings,
  • a classified balance sheet, and
  • a post-close trial balance

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

International Financial Management

Authors: Cheol S. Eun, Bruce G.Resnick

6th Edition

71316973, 978-0071316972, 78034655, 978-0078034657

More Books

Students also viewed these Finance questions

Question

What is an intangible asset? Provide some examples.

Answered: 1 week ago