Module 1 Assignment: Advanced Financial Statements

For this assignment, you will apply the concepts learned in Module 1 to prepare and analyze advanced financial statements. You can continue using the accounting simulator from our website, which is used in the beginner’s course, MS Excel, or an inexpensive accounting software if you have access to it.

Assignment Tasks

1. Prepare Consolidated Financial Statements:
   • Create a consolidated balance sheet, income statement, and statement of cash flows for a parent company and its two subsidiaries. Use the following hypothetical data:
     • Parent Company:
       • Total Assets: $1,000,000
       • Total Liabilities: $400,000
       • Equity: $600,000
       • Revenue: $800,000
       • Expenses: $500,000
     • Subsidiary A:
       • Total Assets: $300,000
       • Total Liabilities: $100,000
       • Equity: $200,000
       • Revenue: $200,000
       • Expenses: $120,000
     • Subsidiary B:
       • Total Assets: $200,000
       • Total Liabilities: $80,000
       • Equity: $120,000
       • Revenue: $150,000
       • Expenses: $90,000
   • Ensure you eliminate intercompany transactions and calculate any non-controlling interest.
   • Provide a brief explanation of your consolidation process and any adjustments made.
2. Segment Reporting:
   • Identify at least three segments for a hypothetical company. These segments can be based on product lines, geographical areas, or other criteria.
   • Prepare a segment report showing each segment’s revenue, profit or loss, and total assets. Use the following hypothetical data:
     • Segment 1:
       • Revenue: $400,000
       • Profit: $100,000
       • Total Assets: $500,000
     • Segment 2:
       • Revenue: $300,000
       • Profit: $80,000
       • Total Assets: $400,000
     • Segment 3:
       • Revenue: $250,000
       • Profit: $70,000
       • Total Assets: $300,000
   • Provide a reconciliation of the segment totals to the overall company totals.
3. Statement of Changes in Equity:
   • Prepare a statement of changes in equity for a hypothetical company. Use the following hypothetical data:
     • Opening Balances:
       • Share Capital: $500,000
       • Retained Earnings: $200,000
       • Revaluation Reserve: $50,000
     • Transactions:
       • Issue of new shares: $100,000
       • Net Income: $150,000
       • Dividends Paid: $50,000
       • Revaluation Surplus: $20,000
   • Calculate and show the closing balances for each component of equity.
   • Provide a brief explanation of the changes in equity during the period.

Submission Instructions

Compile your consolidated financial statements, segment report, and statement of changes in equity into a single document. Submit your document 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 financial statements and the clarity of the explanations.

Due Date: One week after completing this module.

© 2024 Coy Academy. All rights reserved.