Question: Financial Statement Project due in Week 2 The project is assigned in Week 1 but is not due until Week 2. You will work on

Financial Statement Project due in Week 2

The project is assigned in Week 1 but is not due until Week 2. You will work on the first project during Week 1 and 2 that is due in Week 2.A second project will be worked on during Week 3 and 4 and due in Week 4. We will cover various topics during Week 1 and 2 which will help you to complete the project for final submission in Week 2.

South Shore Medical Clinic
Trial Balance
December 31, 20X3
Debit Credit
Cash $50,000
Accounts Receivable 55,000
Supplies 10,000
Inventory 40,000
Equipment 75,000
Building 150,000
Accounts Payable $25,000
Current Portion - Long Term Debt 35,000
Long Term Debt, net of Current Portion 100,000
Owner's Equity 200,000
Service Fee Revenue 125,000
Salaries Expense 78,500
Rent Expense 24,000
Utilities Expense 2,500
Totals $485,000 $485,000

Task #1: Using the Trial Balance, prepare an Income Statement.
South Shore Medical Clinic
Income Statement
For the year ending December 31, 20X3
Revenues:
Service Fee Revenue
Total Revenues
Expenses:
Salaries Expense
Rent Expense
Utilities Expense
Total Expenses
Income:
Net Income

Task #2: Using the Trial Balance, enter the appropriate amounts for each account. Classify each as an Asset, Liability, or Equity account then specify if they are current or non-current.
Account Account Balance Type of Account Current/NonCurrent
Cash
Inventory
Supplies
Building
Equipment
Accounts Receivable
Accounts Payable
Current Portion - Long Term Debt
Long Term Debt, net of Current Portion
Owner's Equity
Task #3: Once complete, prepare a Balance Sheet listing the accounts and account balances in the appropriate order. (Keep in mind that Net Income Increases the Owner's Equity Account).
South Shore Medical Clinic
Balance Sheet
December 31, 20X3
ASSETS LIABILITIES & NET WORTH
Current Assets Current Liabilities
Cash Accounts Payable
Accounts Receivable Current Portion - Long Term Debt
Supplies Total Current Liabilities
Inventory
Total Current Assets Non-current Liabilities
Long Term Debt, net of Current Portion
Non-current Assets Total Non-Current Liabilities
Equipment
Building NET WORTH
Total Non-current Assets Owner's Equity $200,000
TOTAL ASSETS TOTAL LIABILITIES & NET WORTH

Questions:
1. Briefly describe whether or not you think this company is profitable.
2. Is the company collecting enough in revenue to cover their expenses?
3. Comment on any suggestions you might have for the company's owners.

In the template above, you are given a trial balance for year ended December 31, 20X3. Using the trial balance, you are required to complete an Income Statement and a Balance Sheet. In addition, another task will be choosing the appropriate type of account classification as well. Lastly, there are a few questions following the completion of the financial statements. All work will be done on the Student Template. Once complete, please save the Student Template with your name in the file name (for example: John Doe - Project #1 or John Doe - Financial Statement Project) and upload under the appropriate box in Week 2.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!