Reference no: EM131184278
Using the accompanying Stone Arbor Landscaping trial balance, prepare an Income Statement, Statement of Retained Earnings, and Balance Sheet with the following requirements:
1. The one adjusting entry that has not yet been recorded is income tax expense. Determine this entry and add it to the trial balance. Assume the company has an effective tax rate of 25%.
2. Prepare each financial statement, in good form, using a different sheet in Excel. Good form means you should have an appropriate three-part heading, no abbreviations, and dollar signs and underscores in appropriate places. You should be proud to hand these financial statements to your banker. Use the financial statements in the Accounting Cycle Review PowerPoint file from the first day of class as a guide with the following modifications:
a. Balance Sheet: Be aware that the T-Shirts "R" Us Balance Sheet does not have any long-term assets or liabilities. You should prepare a classified balance sheet with appropriate subtotals for current assets and current liabilities. You can group like assets and liabilities (i.e. all cash accounts can be totaled in one line item called "Cash and equivalents" and all payroll tax liabilities including FUTA and SUTA can be totaled in one line item called "Payroll tax liabilities". Note that the retained earnings balance on the trial balance is the beginning of the year retained earnings.
b. Income Statement: Because Stone Arbor is primarily a service business, you will not have a subtotal for cost of goods sold or gross margin. You should break out all sales but combine accounts into one subtotal called "Net Sales". You should also list out all expenses. The income statement is for the quarter ended March 31, 2012.
3. Articulate the financial statements by using cell references (i.e. The Statement of Retained Earnings should cell reference net income from the Income Statement and the Balance Sheet should cell reference retained earnings from the Statement of Retained Earnings). You should print your financial statements in both standard view and formula view. (Ctrl ~ will change the statements to formula view). All subtotals on your statements should be calculated using Excel formulas.
4. You should hand in six statements: the three financial statements and the three statements in formula view. If you wish, you can print more than one statement per page.
ATTACHED THE GENERAL LEDGER TRIAL BALANCE.
Attachment:- THE GENERAL LEDGER TRIAL BALANCE.rar
|
Write a personal descriptive essay about a person
: Write a personal descriptive essay about a person, place, or thing. Be sure to establish a clear dominant impression that conveys the point you want to make about your subject
|
|
How your example fully illustrates your understanding of zpd
: Explain how your example fully illustrates your understanding of ZPD. Also, describe at least two educational implications of this concept. Use the concept of scaffolding in your answer.
|
|
Calculate the total stored electric energy in the sphere
: Energy stored in a capacitor. Assume a solid conducting sphere of radius a is connected to a potential V with respect to infinity. Calculate the total stored electric energy in the sphere. Assume the charge on the surface of the sphere is uniforml..
|
|
What is your next step to try to develop a parent relation
: Frank Smith, a student in your seventh grade English class, has been creating quite a stir in your class lately. As Frank's teacher, what is your next step to try to develop a parent/teacher relationship?
|
|
Prepare a classified balance sheet
: Prepare each financial statement, in good form, using a different sheet in Excel.- prepare a classified balance sheet with appropriate subtotals for current assets and current liabilities.
|
|
Which organizational model best describes your organization
: Which organizational model best describes your organization or an organization with which you are familiar? How does your organization currently share knowledge or involve employees in formulating solutions to problems?
|
|
Examine the one behavior you would target for change
: Examine the one behavior you would target for change, explaining your decision with supporting evidence. Create a data collection procedure for determining if the behavior plan is successful.
|
|
Calculate the potential energy in the system
: Potential energy of a system of point charges. Three charges are arranged as shown in Figure 4.75. Calculate the potential energy in the system.
|
|
Critically asses the literature in a business
: You are required to undertakc, analyse. and critically asses the literature in a given business -rebated area and formulate research questions or objectives.
|