Final Project: Comprehensive Accounting Analysis

Introduction

This final project is designed to reinforce the skills and knowledge you have gained throughout the course. You will apply various accounting principles and techniques to analyze a hypothetical company’s financial data. This project will encompass multiple aspects of accounting, including financial statement preparation, data analysis, internal controls, and ethical considerations. Completing this project will demonstrate your ability to integrate and apply what you have learned in a practical, real-world scenario.

Project Overview

You are the newly appointed accountant for XYZ Corporation, a mid-sized company that manufactures and sells electronic gadgets. The company’s financial year has just ended, and you are tasked with preparing the financial statements, analyzing the company’s performance, implementing internal controls, and addressing some ethical issues. The project is divided into several parts, each focusing on different aspects of accounting.

Part 1: Financial Statement Preparation

Prepare the following financial statements for XYZ Corporation based on the provided trial balance and additional information:

Trial Balance as of December 31, 2023

Account	Debit ($)	Credit ($)
Cash	50,000
Accounts Receivable	75,000
Inventory	100,000
Prepaid Insurance	10,000
Equipment	200,000
Accumulated Depreciation		40,000
Accounts Payable		60,000
Notes Payable		150,000
Common Stock		100,000
Retained Earnings		85,000
Sales Revenue		400,000
Cost of Goods Sold	250,000
Salaries Expense	60,000
Rent Expense	30,000
Insurance Expense	10,000
Utilities Expense	15,000

Additional Information

Depreciation expense for the year is $20,000.
Prepaid insurance of $5,000 expired during the year.
Accrued salaries of $10,000 need to be recognized.

Required Financial Statements

Income Statement
Statement of Retained Earnings
Balance Sheet
Statement of Cash Flows

Part 2: Data Analysis

Using the financial statements prepared in Part 1, perform the following analyses:

1. Ratio Analysis

Calculate the following ratios:
- Current Ratio
- Quick Ratio
- Gross Profit Margin
- Net Profit Margin
- Return on Assets (ROA)
- Return on Equity (ROE)

2. Trend Analysis

Analyze the trends in sales revenue, cost of goods sold, and net income over the past three years (assuming the provided data represents the current year, and you have data for the previous two years).

Part 3: Internal Controls

Evaluate the current internal control system of XYZ Corporation and recommend improvements. Focus on the following areas:

Segregation of Duties
Access Controls
Physical Controls
Reconciliations
Documentation and Record Keeping

Part 4: Ethical Considerations

XYZ Corporation’s CFO has asked you to overlook some unrecorded liabilities to improve the company’s financial position on the balance sheet. Prepare a report addressing the following points:

Identify the ethical issues involved.
Discuss the potential consequences of complying with the CFO’s request.
Provide recommendations for how to handle the situation while adhering to ethical standards.

Submission Instructions

Compile your financial statements, data analysis, internal control evaluation, and ethical considerations report into a single document. Submit your document in PDF format via the course submission portal.

Additional Activities

Presentation: Prepare a short presentation summarizing your project findings and recommendations. Share your presentation with the class during the final review session.
Peer Review: Review at least two of your classmates’ projects and provide constructive feedback. Focus on the accuracy of the financial statements, the thoroughness of the data analysis, and the quality of the internal control recommendations and ethical considerations.

Due Date: Two weeks after the final lesson.

Final Project