Question 1: Preparation and Presentation of the Balance Sheet/Statement of Financial Position
Upside-Down Trading Limited, a company listed on the Music Stock Exchange, is a trading and investment
entity. The company trades exclusively in steel and aluminium component, and also has an investing arm.
Upside-Down Trading Limited have just engaged you as their finance director to assist in the preparation
of the entity’s 2021 financial statements. The financial period of the company is from September 1 to
August 31.
The company has provided you the following list of accounts, and the trial balance totals per each account,
as at end of their current final year:
Account Name Trial Balance Figure
11% Debentures $50,000,000
7% Bonds (Due in Less than 12 Months) $5,000,000
Accounts Payable $15,890,000
Accounts Receivables $14,500,000
Cash and Cash Equivalents $11,950,000
Copyright and R&D $4,100,000
Cost of Goods Sold $56,100,390
Current Tax Liabilities $6,900,000
Employee Benefit Obligations $8,100,000
Finance Expenses $4,502,000
Goodwill $18,540,000
Inventory $75,650,000
Loans Due in Less than 12 Months $16,850,000
Long-Term Investments $196,000,000
Long-Term Loans $215,580,000
Loss on Sale of Equipment $5,100,450
Other Payables $1,830,000
Other Receivables (Due in more than 12 Months) $1,520,000
Paid-Up Capital $218,702,000
Plant and Equipment $168,221,000
Prepaid Expenses $5,020,000
Property $312,512,000
Reserves $150,072,000
Retained Earnings $122,589,000
Sales Revenue $158,900,000
Short-Term Investments $6,500,000
Additional Information:
1. During the year, Upside-Down Trading Limited purchased $7,000,000 worth of machine
equipment that has yet to be added to the relevant non-current asset account.
2. For the period ended August 31, 2021, Upside-Down Global Trading Limited recorded a loss of
$7,500,000. This amount has already been closed to the Retained Earnings balance as per the trial
balance.

Page | 2
3. The internal auditor found from a recent review that $4,000,000 of loans listed as being payable in
next 12 months are not due till 2026.
4. All prepaid expenses are expected to be consumed by the end of December 31, 2021.
5. Upside Down Trading Limited has been offered $15,000,000 to sell its properties. The transaction
would – if accepted – be accepted in June 2028.
6. In 2019 the company sold property valued at $19,000,000 for $26,000,000. The company is of the
opinion that in 2024 it will purchase property to the value of $11,000,000.
7. The value of the Inventory as shown in the trial balance is the net realizable value. The value of
inventory at cost is $65,650,000.
Required:
Using the information supplied, prepare a balance sheet/statement of financial position for Upside-Down
Trading Limited for the end of 2025 that conforms with IFRS IAS 1 recommendations and requirements of
the course.

justify your answer with all steps clearly please (NOT HAND WRITING ) thanks

Question 1: Preparation and Presentation of the Balance Sheet/Statement of Financial Position

Upside-Down Trading Limited, a company listed on the Music Stock Exchange, is a trading and investment entity. The company trades exclusively in steel and aluminium component, and also has an investing arm.

Upside-Down Trading Limited have just engaged you as their finance director to assist in the preparation of the entity’s 2021 financial statements. The financial period of the company is from September 1 to August 31.

The company has provided you the following list of accounts, and the trial balance totals per each account, as at end of their current final year:

Additional Information:

1. During the year, Upside-Down Trading Limited purchased $7,000,000 worth of machine equipment that has yet to be added to the relevant non-current asset account.
2. For the period ended August 31, 2021, Upside-Down Global Trading Limited recorded a loss of $7,500,000. This amount has already been closed to the Retained Earnings balance as per the trial balance.
3. The internal auditor found from a recent review that $4,000,000 of loans listed as being payable in next 12 months are not due till 2026.
4. All prepaid expenses are expected to be consumed by the end of December 31, 2021.
5. Upside Down Trading Limited has been offered $15,000,000 to sell its properties. The transaction would – if accepted – be accepted in June 2028.
6. In 2019 the company sold property valued at $19,000,000 for $26,000,000. The company is of the opinion that in 2024 it will purchase property to the value of $11,000,000.
7. The value of the Inventory as shown in the trial balance is the net realizable value. The value of inventory at cost is $65,650,000.

Required:

Using the information supplied, prepare a balance sheet/statement of financial position for Upside-Down Trading Limited for the end of 2025 that conforms with IFRS IAS 1 recommendations and requirements of the course.

4. Sky Metals, Inc. is a metal fabrication firm that manufactures prefabricated metal parts for customers in a variety of industries. The firm’s motto is “If you need it, we can make it.” The CEO of Sky Metals recently held a board meeting during which he extolled the virtues of the corporation. The company, he stated confidently, had the capability to build any product and could do so using a lean manufacturing model. The firm would soon be profitable, claimed the CEO, because the company used state-of-the-art technology to build a variety of products while keeping inventory levels low. As a business press reporter, you have calculated some ratios to analyze the financial health of the firm. Sky Metals' current ratios and quick ratios for the past 6 years are shown in the following table:

What do you think of the CEO’s claim that the firm is lean and soon to be profitable?

5. If we know that a firm has a net profit margin of 4.5%, total asset turnover of 0.72, and a financial leverage multiplier of 1.43, what is its ROE? What is the advantage to using the DuPont system to calculate ROE over the direct calculation of earnings available for common stockholders divided by common stock equity?

Graphs with Matplotlib Using the library Matplotlib and the provided data files create the following graphs:

I) Pie chart

Create a pie chart that shows the percentage of employees in each department within a company. The provided file: employee_count_by_department.txt contains the data required in order to generate this pie chart.

II) Line Graph

Create a line graph that shows a company's profit over the past ten years. The provided file: last_ten_year_net_profit.txt contains the data required in order to generate this line graph.

III) Bar Graph

Create a bar graph that shows a company's profit over the past ten years. The provided file: last_ten_year_net_profit.txt contains the data required in order to generate this bar graph. Info: Be sure to label all the axes of each graph with meaningful labels and provide an appropriate title to each of the graphs (mentioned above) being generated. Hint, the names of the files and the headers provided in each of the data files should help

-----------------------

last_ten_year_net_profit.txt

Year ; Profit in $USD

2009 ; $175,000

2010 ; $250,000

2011 ; $525,000

2012 ; $239,000

2013 ; $1,000,000

2014 ; $1,000,500

2015 ; $500,000

2016 ; $740,000

2017 ; $5,625,000

2018 ; $100,000,000

--------------------------

employee_count_by_department.txt

Department Name    , Total number of employees

Marketing       , 50

Information Technology, 275

Management      , 230

Human Resources    , 250

Finance        , 92

Supply Chain     , 73

Manufacturing     , 30

The following information is available for the McCain Manufacturing Company for 2020.
Accounts receivable, January 1, 2020 $120,000
Accounts payable, January 1, 2020 ?
Raw materials, January 1, 2020 10,000
Work in process, January 1, 2020 25,000
Finished goods, January 1, 2020 75,000
Accounts receivable, December 31, 2020 80,000
Accounts payable, December 31, 2020 200,000
Raw materials, December 31, 2020 ?
Work in process, December 31, 2020   60,000
Finished goods, December 31, 2020 50,000
Raw materials used in production   100,000
Raw materials purchased 130,000
Accounts receivable collections ?
Accounts payable payments 80,000
Sales ?
Total manufacturing costs ?
Cost of goods manufactured ?
Cost of goods sold 60% of Sales
Gross margin 400,000

Assume that all raw materials are purchased on credit and all sales are credit sales. Compute the missing amounts above.

Explain the rise of the monocentric city with following 1. innovations in intracity transportation 2.technology of building construction 3.primitive technology of freight.

What is the function of Bluetooth, Wi-fi, Satellite methods of technology and which is appropriate for what function?

Course: Information Technology for the Health Professions

Discuss how technology has impacted and accelerated the growth of several industries in our economy. How does technology stimulate economic growth?

1-Do you view 3D printing as sustaining or disruptive technology?
2- Do you view drones as sustaining or disruptive technology?