Develop a flexible financial statement package

Assignment Help Financial Accounting

Reference no: EM133434271

Question: The ledger of AISExperts Inc. contained the following balances after adjustment, but before closing, on December 31, 2023, the end of the current year. This means the below account balances are normal balances:

Accounts payable	80000
Accounts receivable	115580
Sales returns and allowances	20000
Accumulated depreciation - equipment	27540
Depreciation expense	800
Interest revenue	1100
Unearned sales revenue	2000
Cash	75670
Common stock (10,000 shares outstanding)	100000
Sales discounts	12000
Cost of goods sold	632100
Dividends declared	18100
Equipment	140600
Insurance expense	4500
Dividends payable	2000
Allowance for doubtful accounts	9500
General expenses	114250
Interest expense	4600
Merchandise inventory	154250
Prepaid insurance	12325
Retained earnings	?
Marketable securities	10100
Dividend revenue	10000
Treasury stock	1000
Salaries payable	18660
Sales	1018200
Selling expenses	140210

The president of AISExperts Inc., has asked you to develop a flexible financial statement package (call the file yournameFinState23), using Excel that includes:

a multi-step income statement,
a statement of retained earnings,
a classified balance sheet, and
a post-close trial balance
data visual of total assets

Reference no: EM133434271

Questions Cloud

What if the municipality is going to build a new sewage : what if the municipality is going to build a new sewage treatment plant and the most economical piece of land is in a mostly minority owned neighborhood?

Nonverbal expectations have been violated : Discuss a time when your nonverbal expectations have been violated. Describe the situation, how you felt, how you reacted, how did you communicate about it?

How much money will you have in the account in 23 years : If you deposit $7,742 at the end of each of the next 23 years into an account paying 9.9 percent interest, how much money will you have in the account in 23

Nonverbal expectancy violation theory : You are going to enact the nonverbal expectancy violation theory. How did they react, nonverbally/verbally?

Develop a flexible financial statement package : Develop a flexible financial statement package (call the file yournameFinState23), using Excel that includes

How does a child sense of humour indicate developing : How does a child's sense of humour indicate developing semantic knowledge? Provide 3 examples

How much in $ is your budget for the coming year : How much in $ is your budget for the coming year and What extra sales need to be generated to pay for this service

Concepts reciprocal dependance and reciprocal familiarity : Explain your understanding of Goffman's concepts "reciprocal dependance" and "reciprocal familiarity." How do these apply to team performances?

Compare and contrast opening scenes from 5 adaptations : Compare and Contrast - Opening Scenes from 5 Adaptations." After watching this compilation, discuss which one you think was the most effective.

User Account

All Pages