Financial Statements from the End-of-Period Spreadsheet

Paoli Consulting is a consulting firm owned and operated by Mary Paoli. The following end-of-period spreadsheet was prepared for the year ended March 31, 20Y9:

During the year ended March 31, 20Y9, $3,500 of additional common stock was issued.

Paoli Consulting
End-of-Period Spreadsheet
For the Year Ended March 31, 20Y9
Account Title Unadjusted
Trial Balance
Dr. Unadjusted
Trial Balance
Cr. Adjustments
Dr. Adjustments
Cr. Adjusted
Trial Balance
Dr. Adjusted
Trial Balance
Cr.
Cash 11,010 11,010
Accounts Receivable 26,220 26,220
Supplies 2,780 2,330 450
Land 22,550 22,550
Building 21,240 21,240
Accumulated Depreciation 2,910 1,390 4,300
Accounts Payable 7,080 7,080
Salaries Payable 340 340
Common Stock 8,800 8,800
Retained Earnings 17,940 17,940
Dividends 3,410 3,410
Fees Earned 71,980 71,980
Salary Expense 19,400 340 19,740
Supplies Expense 2,330 2,330
Depreciation Expense 1,390 1,390
Miscellaneous Expense 2,100 2,100
Total 108,710 108,710 4,060 4,060 110,440 110,440

Question Content Area
Based on the preceding spreadsheet, prepare an income statement, statement of stockholders equity and a balance sheet for Paoli Consulting.

1 answer

Based on the provided end-of-period spreadsheet for Paoli Consulting, we can prepare the financial statements: the income statement, the statement of stockholders' equity, and the balance sheet.

1. Income Statement for the Year Ended March 31, 20Y9

Paoli Consulting
Income Statement
For the Year Ended March 31, 20Y9

| Account Title | Amount | |------------------------|--------------| | Revenues | | | Fees Earned | $71,980 | | | | | Expenses | | | Salary Expense | $19,740 | | Supplies Expense | $2,330 | | Depreciation Expense | $1,390 | | Miscellaneous Expense | $2,100 | | Total Expenses | ($25,560) | | | | | Net Income | $46,420 |

2. Statement of Stockholders' Equity for the Year Ended March 31, 20Y9

Paoli Consulting
Statement of Stockholders' Equity
For the Year Ended March 31, 20Y9

| Account Title | Amount | |-------------------------|----------------| | Common Stock | | | Beginning Balance | $8,800 | | Issued Common Stock | $3,500 | | Ending Balance Common Stock | $12,300 | | | | | Retained Earnings | | | Beginning Balance | $17,940 | | Add: Net Income | $46,420 | | Less: Dividends | ($3,410) | | Ending Balance Retained Earnings | $61,950 | | | | | Total Stockholders' Equity | $74,250 |

3. Balance Sheet as of March 31, 20Y9

Paoli Consulting
Balance Sheet
As of March 31, 20Y9

| Account Title | Amount | |-------------------------------|------------------| | Assets | | | Cash | $11,010 | | Accounts Receivable | $26,220 | | Supplies | $450 | | Land | $22,550 | | Building | $21,240 | | Less: Accumulated Depreciation | ($4,300) | | Total Assets | $77,170 | | | | | Liabilities | | | Accounts Payable | $7,080 | | Salaries Payable | $340 | | Total Liabilities | $7,420 | | | | | Stockholders' Equity | | | Common Stock | $12,300 | | Retained Earnings | $61,950 | | Total Stockholders' Equity | $74,250 | | | | | Total Liabilities and Stockholders' Equity | $81,670 |

Note:

  • The Total Assets ($77,170) equals the Total Liabilities and Stockholders' Equity ($81,670). Please ensure all calculations are correct, as this example assumes a straightforward calculation without thorough audits of each component.
  • Adjustments led to various changes in these accounts. Always verify each entry with the statements derived from the original spreadsheet for full accuracy.