Texts:
1. On July 1, 2020, you contributed $1,000,000 in exchange for 10,000 shares of common stock. The full amount is deposited in cash.
2. On July 1, 2020, MEGA-Unicorn rented an office building for $10,000 a month. The landlord requires the rent to be paid up front for each month and also requires a last month deposit. Therefore, a total of $130,000 was paid in cash as of June 30, 2021.
3. On July 1, 2020, MEGA-Unicorn bought inventories on account from ABC for $400,000 for a total of 1,000 units.
4. On July 1, 2020, MEGA-Unicorn purchased computers and office equipment for $12,000, fully paid in cash. Straight-line depreciation method is applied and the computers have a useful life of 3 years.
5. On August 1, 2020, MEGA-Unicorn sold 250 units of its inventories to Customer A for a total of $250,000 (fully delivered, revenue can be recognized). Customer A paid $200,000 via cheque which is deposited in the cash account and the remaining to be paid within 30 days.
6. On August 1, 2020, MEGA-Unicorn paid ABC $400,000 in cash.
7. On October 31, 2020, MEGA-Unicorn did not receive the remaining payment from Customer A after 90 days and had to write off the receivable amount.
8. On June 1, 2021, MEGA-Unicorn sold another 500 units of its inventories to Customer B for a total of 2021. Only 300 units were delivered to Customer B by the end of June 30, 2021 (i.e. only revenue associated with the 300 units can be recognized, remaining 200 units cannot be recognized as revenue until they are delivered).
9. On June 30, 2021, MEGA-Unicorn purchased XYZ Solution Inc for $300,000 in cash settlement. XYZ's net asset value was $200,000.
10. On June 30, 2021, MEGA-Unicorn paid your annual salary of $50,000 in cash.
11. On June 30, 2021, MEGA-Unicorn declared and paid out a dividend of $0.1 per share in cash.
12. On June 30, 2021, MEGA-Unicorn owes the government income taxes. As a CCPC (Canadian- income before taxes (operating income gains/losses + other income), the income tax owed is to be paid in the future.
Requirements:
Please create the following financial statements for MEGA-Unicorn for the July 1, 2020 - June 30, 2021 year in Excel.
1. Income Statement
2. Balance Sheet
3. Direct Cash Flow Statement
4. Indirect Cash Flow Statement