Module 8 Assignment: Financial Statement Analysis

For this assignment, you will apply the concepts learned in Module 8 to perform various types of financial statement analysis, including ratio, trend, horizontal, and vertical analysis. You will use real or hypothetical financial data to demonstrate your understanding of these techniques. You can continue using the accounting simulator from our website, MS Excel, or an inexpensive accounting software if you have access to it.

Assignment Tasks

1. Ratio Analysis:
   • Calculate the following ratios using the provided financial data:
     • Current Ratio
     • Quick Ratio
     • Debt-to-Equity Ratio
     • Interest Coverage Ratio
     • Gross Profit Margin
     • Return on Assets (ROA)
     • Return on Equity (ROE)
   • Analyze the calculated ratios and provide a brief interpretation of the company’s liquidity, solvency, and profitability.
2. Trend Analysis:
   • Using the provided financial data for the past three years, perform a trend analysis for the following items:
     • Revenue
     • Net Income
     • Total Assets
   • Calculate the trend percentages and analyze the trends over the three-year period.
3. Horizontal Analysis:
   • Using the provided financial data for two consecutive years, perform a horizontal analysis for the following items:
     • Revenue
     • Cost of Goods Sold (COGS)
     • Operating Expenses
     • Net Income
   • Calculate the dollar and percentage changes for each item and analyze the results.
4. Vertical Analysis:
   • Using the provided income statement and balance sheet data, perform a vertical analysis for the current year:
     • Income Statement: Express each item as a percentage of total revenue.
     • Balance Sheet: Express each item as a percentage of total assets.
   • Analyze the common-size statements and provide insights into the company’s financial structure and performance.

Submission Instructions

Compile your calculations, analysis, and interpretations into a single document and submit it in PDF format via the course submission portal.

Additional Activities

• Discussion Post: Share your experience in the course forum, detailing any challenges you faced during the assignment and how you overcame them. Provide feedback on your classmates’ posts.
• Peer Review: Review at least two of your classmates’ submissions and provide constructive feedback. Focus on the accuracy of the calculations and the clarity of the analysis.

Due Date: One week after completing this module.

© 2024 Coy Academy. All rights reserved.