Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Accounting Basics Expert

The ledger of AISExperts Inc. showed the given balances after adjustment, although before closing, on December 31, 2012, the end of the current year:

2007_articulation of statements.jpg

The president of AISExperts Inc., has asked you to make a flexible financial statement package (call the file yourlastnameyourfirstnameFinState12), by using Excel that comprises:

• A data entry sheet (must include the information above)
• A trial balance (link to the data entry sheet),
• 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 (a trial balance with only accounts not ‘closed’)

Each statement should be on one sheet in the file and this file must permit the financial statements to be prepared quickly by entering account balances in the suitable cells on the first sheet of the file (book) – data entry sheet.

Include percentages in the Income Statement (vertical analysis) that is, gross profit percentage, % of selling expenses to sales, and so on (common sizing and vertical analysis are fundamentally the same analysis methods – every number in the multi-step income statement is divided by sales).

Your file should contain documentation with comments (Excel commands: REVIEW, NEW COMMENT). The comments must be comprised where you think explanation is required that is, earnings per share on the bottom of the income statement must probably be describeed or retained earnings (starting and ending balances) might need some additional comments.

Accounting Basics, Accounting

  • Category:- Accounting Basics
  • Reference No.:- M91810
  • Price:- $40

Guranteed 36 Hours Delivery, In Price:- $40

Have any Question? 


Related Questions in Accounting Basics

The balance of the 060 par common stock account for company

The balance of the $0.60 par Common Stock account for Company was $60,000 before its recent 3-for-1 stock split. The market price of the stock was $30 per share. What occurred as a result of the split? a. The par value p ...

Wayne and maria file a joint tax return on which they

Wayne and Maria file a joint tax return on which they itemize their deductions and report AGI of $50,000. During the year they incurred $1,500 of medical expenses when Maria broke her leg. Furthermore, their dentist info ...

Practice questionsdistinguish betweennormal lossesabnormal

Practice questions: Distinguish between normal losses abnormal losses and explain their costing treatments.

1 what are the three classifications of restrictions of

1. What are the three classifications of restrictions of retained earnings, and how are such restrictions normally reported on the financial statements? 2. Indicate how prior period adjustments would be reported on the f ...

Changes in accounting principles and changes in accounting

"Changes in Accounting Principles and Changes in Accounting Estimates" Please respond to the following: • From the e-Activity, discuss the accounting principles that the identified company changed, and explain the major ...

Accounting for business decisions melbourne assignment-the

Accounting for Business Decisions Melbourne Assignment- The assignment will undertake research using the website of the Australian Stock Exchange (ASX) and/or the Company whose industry is Food, Beverage & Tobacco that y ...

Assignment ifrs and us gaap reportingon january 1 year 1

Assignment: IFRS and U.S. GAAP Reporting On January 1, Year 1, the Hoverman Corporation made amendments to its defined benefit pension plan, resulting in $150,000 of past service costs. The plan has 100 active employees ...

Accounting theory assignment read the articles on study

Accounting Theory Assignment Read the articles on study desk: Volkswagen The scandal explained Instructions This assignment is a research based essay where you are required to relate a practical example to accounting the ...

1 under gasb rules for the financial reporting entitya

1. Under GASB rules for the financial reporting entity a. component units are included if the primary government is financially accountable for their operations B. counties are component units of the state government C. ...

Questionsummative discussion boardreview and reflect on the

Question: Summative Discussion Board Review and reflect on the knowledge you have gained from this course. Based on your review and reflection, write at least 3 paragraphs on the following: What were the most compelling ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate