# Step 306 - Question 1From Microsoft Excel for Accounting, complete "Extend Your Skills EA2-E2: Create Financial Statements for BeBo Industries" found in Chapter 2 of your Microsoft Excel for...

Step 306 - Question 1

1. From Microsoft Excel for Accounting, complete "Extend Your Skills EA2-E2: Create Financial Statements for BeBo Industries" found in Chapter 2 of your Microsoft Excel for Accounting text.

2. Use formulas and functions to create the following financial statements for the firm on separate tabs in the template, using the same names provided here:

• Prepare the firm's Balance Sheet with 0-2 errors or omissions that include the use of Excel formulas for required calculations.

• Prepare the firm's Income Statement with 0-2 errors or omissions that include the use of Excel formulas for required calculations.

• Prepare the firm's Statement of Owner's Equity with 0-2 errors or omissions that include the use of Excel formulas for required calculations.

Part 2: Computing Financial Ratios

1. Refer to Chapter 9 of Microsoft Excel for Accounting to access formulas for these ratio calculations.

2. Using the data from the financial statements in Part 1, perform the specified ratio analyses with 0-2 errors or omissions that include the use of Excel formulas.

• Current ratio.

• Quick ratio.

• Debt ratio.

• Equity ratio.

• Debt-to-equity ratio.

• Profit margin ratio.

Requirements

Note: You must use Excel formulas to compute the ratios and totals on the financial statements where applicable. Points will be deducted if you do not use formulas for calculations.

• Submit one Excel file with the following tabs:

• Balance Sheet.

• Income Statement.

• Statement of Owner's Equity.

• Financial Ratios.

Step 308 - Question 2

• Select a company, small or large, whose practices you will review. You may alternatively use a company you would like to start.

• In a paper of 4–5 pages:

1. Evaluate the company's practices against COSO's internal control frameworks. If you choose a company that you would like to start, then you are going to establish the COSO internal controls based on your selection of the company's operations.

2. Identify at least one possible risk in the current practice/potential practice that could limit the effectiveness of COSO's internal control framework. How would you discover and fix this issue?

3. Use three sources to support your writing. Choose sources that are credible, relevant, and appropriate. Cite each source listed on your source slide at least one time within your assignment.

Answered 2 days AfterApr 15, 2024

## Answer To: Step 306 - Question 1From Microsoft Excel for Accounting, complete "Extend Your Skills EA2-E2:...

Prince answered on Apr 18 2024
Question 2:
Introduction:
Internal control frameworks play a crucial role in ensuring the reliability of financial reporting, safeguarding assets, and promoting operational efficiency within organizations. The Committee of Sponsoring Organizations (COSO) has established a widely recognized framework that provides guidance on effective internal control systems. In evaluating Apple Inc.'s practices against COSO's internal control framework, it is evident that the company places a strong emphasis on maintaining robust internal controls to mitigate risks and ensur
e the integrity of its financial reporting processes (Louwers et al., 2018).
COSO's internal control framework consists of five interrelated components: control environment, risk assessment, control activities, information and communication, and monitoring activities (COSO, 2013). Apple Inc. demonstrates its commitment to these components through various practices and procedures.
Control Environment:
The control environment sets the tone for an organization and influences the control consciousness of its employees. Apple Inc. has established a strong control environment by promoting ethical values and maintaining oversight responsibilities at the highest levels of management (Arens et al., 2012). The company's senior management, including the Chief Financial Officer (CFO) and the Chief Executive Officer (CEO), are responsible for overseeing the preparation and accuracy of financial statements.
This oversight aligns with COSO's emphasis on the importance of management's commitment to internal controls and the establishment of an organizational structure that fosters accountability and ethical conduct (COSO, 2013). Apple Inc.'s commitment to ethical values is evident in its corporate policies and code of conduct, which outline the expected behavior and standards for employees and management.
Moreover, Apple Inc. employs one of the "Big Four" independent auditing firms, Ernst & Young LLP, to audit its financial statements annually. This external audit provides an independent assessment of the company's internal controls and financial reporting processes, further enhancing the control environment. The auditor's report serves as an additional layer of oversight, providing reasonable assurance regarding the effectiveness of Apple Inc.'s internal control over financial reporting (Apple Inc., 2023).
Risk Assessment:
Risk assessment is a critical component of COSO's internal control framework, as it involves identifying and analyzing risks that could potentially impact the achievement of an organization's objectives, including the reliability of financial reporting (COSO, 2013). Apple Inc. recognizes the importance of risk assessment and has implemented processes to evaluate the risks associated with financial reporting and operations.
The company's management regularly assesses various risks, such as changes in the regulatory environment, technological advancements, market conditions, and potential fraud or misconduct. Based on these assessments, management implements measures to mitigate identified risks and ensure the effectiveness of internal controls (Louwers et al., 2018).
However, it is crucial to note that no internal control system can provide absolute assurance against all risks and errors. As stated in Apple Inc.'s 10-K report, "Management, including the Firm's Chief Executive Officer and Chief Financial Officer, does not expect that the Firm's internal controls will prevent or detect all errors and all fraud" (Apple Inc., 2023). This acknowledgment aligns with COSO's recognition that internal controls are subject to inherent limitations and resource constraints (COSO, 2013).
Control Activities:
Control activities are the policies and procedures implemented by an organization to mitigate risks and ensure the achievement of its objectives. Apple Inc. has implemented various control activities to ensure the reliability of its financial reporting and compliance with applicable laws and regulations (Arens et al., 2012).
These control activities include maintaining accurate records, segregating duties, and employing robust information technology systems to safeguard assets and ensure the proper authorization of transactions. The company's 10-K report highlights its commitment to establishing and maintaining adequate internal control over financial reporting, which encompasses processes designed to provide reasonable assurance regarding the reliability of financial reporting and the preparation of financial statements in accordance with Generally Accepted Accounting Principles (GAAP) (Apple Inc., 2023).
Furthermore, Apple Inc. has established control activities related to the maintenance of records, authorization of transactions, and safeguarding of assets. These controls are designed to ensure that transactions are recorded accurately, that assets are protected from unauthorized use or disposition, and that transactions are executed in accordance with management's authorizations (Louwers et al., 2018).
Information and Communication:
Effective communication and information-sharing are essential for internal control systems to function efficiently. COSO's framework emphasizes the importance of relevant and quality information being communicated throughout the organization, both internally and externally (COSO, 2013).
Apple Inc. likely has established channels for communicating relevant information to support the proper functioning of its internal control processes. This includes the dissemination of policies, procedures, and reporting requirements to employees, as well as the communication of significant internal...
SOLUTION.PDF