Construct a Balance Sheet that lists assets, liabilities, and equity.

Module 2 Assignments Assignment Objective To develop and demonstrate mastery in assembling and analyzing key financial statements using provided transaction data. This project will reflect your understanding of the relationships among financial documents and their components through practical application. Assignment Instructions You will be provided with a dataset containing a month’s worth of business transactions for a hypothetical company, Download Bperson Accounting Agency. Your task is to use this data to create a complete set of financial statements, demonstrating your ability to interpret and apply accounting data effectively. Tasks and Step-by-Step Guide: Income Statement Preparation: Task: Assemble an Income Statement using the provided transactions. Instructions: Calculate Net Income or Loss by deducting total expenses from total revenues. Excel Tip: Use Excel formulas to automatically calculate totals and subtotals to ensure accuracy and efficiency. Statement of Owner’s Equity: Task: Create the Statement of Owner’s Equity. Instructions: Start with the beginning owner’s equity (assume zero unless stated otherwise), add net income from the Income Statement, include any owner’s investments and withdrawals, and compute the ending owner’s equity. Excel Tip: Link your calculations directly to the Income Statement’s net income to reflect updates dynamically. Balance Sheet Construction: Task: Construct a Balance Sheet that lists assets, liabilities, and equity. Instructions: Ensure the Balance Sheet balances (Total Assets = Total Liabilities + Owner’s Equity). Excel Tip: Utilize cell references to ensure that totals are automatically updated when changes are made to underlying data. Statement of Cash Flows: Task: Prepare the Statement of Cash Flows using the indirect method. Instructions: Adjust Net Income for non-cash transactions and changes in working capital. List cash flows from operating, investing, and financing activities. Excel Tip: Use Excel’s features to categorize and sum different types of cash flows, and ensure that the final cash position matches the cash shown on the Balance Sheet. Submission Requirements Excel Workbook: Submit a complete Excel workbook with each statement on a separate sheet. Use formulas for all calculations to enable automatic updates. Documentation: Include a separate sheet in your workbook titled “Explanations.” Here, provide explanations for each statement, detailing the accounting principles applied, the treatment of specific transactions, and the distinctions between GAAP and IFRS (if applicable

Last Completed Projects