Greenco has hired you to create the following documents in proper format for them:

1. Trial balance
2. Balance Sheet
3. Income Statement

4. Statement of Retained Earnings

NOTE:

• ? assume beginning retained earnings are zero
• ? assume there is no income tax or accounts receivable
• ? assume the note payable is current, rather than long term
• ? all sheets should contain professional formatting, including company name, statement date, and name of statement

In addition to the above mentioned documents you need to complete:

1. Vertical analysis on the Balance Sheet and the Income statement.
2. Ratio Analysis to include the following ratios:
   1. Current Ratio
   2. Gross Margin
   3. Inventory Turnover Ratio
   4. Quick Ratio
   5. Profit Margin
   6. Working Capital ($$ amount)
3. Greenco is asking you, their CPA, about horizontal analyses. Please write one full paragraph of adequate length to explaining the following:
   1. The purpose of, and uses for, a horizontal analysis of both the income statement and the balance sheet.
   2. How to perform the horizontal analysis.
   3. A comment on why you can?t perform this analysis on the midterm exam.
   Please do not ?answer? the bullets ? but provide a professional written paragrapharrative covering these topic.

You must complete all of this in Excel. To have the opportunity to receive full credit for the above work, you must complete at a minimum the following:

1. Label each worksheet
2. Link all of the worksheets together
3. Use formulas. You will not receive credit for just inputting the numbers, where formulas are needed.
4. For this problem you will NOT print the document as I will print your document myself when I am grading them. Make sure your document will print as required in the problem. To verify this you can click on print preview. Once you are satisfied with your documents save the file on your computer. Submit only one file for grading, with each problem on a separate tab within the file. Submitting more than one file will result in a loss of 10% of the earned point value.

Greenco is an electrical supply company and at the end of 2014 their general ledger accounts were as follows: Greenco General Ledger Accounts 2014 Account Accounts payable Accumulated depreciation Advertising expense Business License expense Cash Common stock Cost of goods sold Depreciation expense Dividends Electrical equipment Electrical supplies Electrical supplies expense Insurance expense Interest expense Interest payable Merchandise inventory Merchandise sales revenue Misc. expense Misc. supplies Note payable Prepaid insurance Prepaid rent Rent expense Salary and wage expense Salary and wage payable Service revenue Telephone expense Debit Credit 12,045.00 458.33 200.00 375.00 87,692.15 20,000.00 435.25 458.33 9,500.00 5,000.00 1,100.00 49,400.00 500.00 300.00 300.00 199.60 612.00 2035.00 50.00 10,000.00 700.00 1,500.00 9,000.00 4,680.00 480.00 129,500.00 270.00 Greenco has hired you to create the following documents in proper format for them: 1. Trial balance 2. Balance Sheet 3. Income Statement 4. Statement of Retained Earnings NOTE: assume beginning retained earnings are zero assume there is no income tax or accounts receivable assume the note payable is current, rather than long term all sheets should contain professional formatting, including company name, statement date, and name of statement In addition to the above mentioned documents you need to complete: 1. Vertical analysis on the Balance Sheet and the Income statement. 2. Ratio Analysis to include the following ratios: a. Current Ratio b. Gross Margin c. Inventory Turnover Ratio d. Quick Ratio e. Profit Margin f. Working Capital ($$ amount) 3. Greenco is asking you, their CPA, about horizontal analyses. Please write one full paragraph of adequate length to explaining the following: a. The purpose of, and uses for, a horizontal analysis of both the income statement and the balance sheet. b. How to perform the horizontal analysis. c. A comment on why you can't perform this analysis on the midterm exam. Please do not \"answer\" the bullets - but provide a professional written paragrapharrative covering these topic. You must complete all of this in Excel. To have the opportunity to receive full credit for the above work, you must complete at a minimum the following: 1. Label each worksheet 2. Link all of the worksheets together 3. Use formulas. You will not receive credit for just inputting the numbers, where formulas are needed. 4. For this problem you will NOT print the document as I will print your document myself when I am grading them. Make sure your document will print as required in the problem. To verify this you can click on print preview. Once you are satisfied with your documents save the file on your computer. Submit only one file for grading, with each problem on a separate tab within the file. Submitting more than one file will result in a loss of 10% of the earned point value. Greenco General Ledger Accounts 2014 Account Accounts payable Accumulated depreciation Advertising expense Business License expense Cash Common stock Cost of goods sold Depreciation expense Dividends Electrical equipment Electrical supplies Electrical supplies expense Insurance expense Interest expense Interest payable Merchandise inventory Merchandise sales revenue Misc. expense Misc. supplies Note payable Prepaid insurance Prepaid rent Rent expense Salary and wage expense Salary and wage payable Service revenue Telephone expense Totals Debit Credit 12,045.00 458.33 200.00 375.00 87,692.15 20,000.00 435.25 458.33 9,500.00 5,000.00 1,100.00 49,400.00 500.00 300.00 300.00 199.60 612.00 2,035.00 50.00 10,000.00 700.00 1,500.00 9,000.00 4,680.00 480.00 129,500.00 270.00 173,395.33 173,395.33