1. Select two companies from the same industry that are BOTH publicly traded. They need to both be traded on the New York Stock Exchange or the NASDAC stock exchange. (DO NOT SELECT CLEARWATER PAPER I USE IT IN MY EXAMPLES)

2.  Upload a screenshot of the Edgar Database files at SEC.GOV that includes the 10-K files that you need to download for EACH Company. (see attached example)

3. Upload a recent article or press release for each company discussing company operations.

4. Upload a recent 8-K from the Edgar Database at SEC.GOV. The best way to download the 8-K is to print the file to a PDF. See attached example.

see example : https://www.sec.gov/Archives/edgar/data/1441236/000156459017024717/clw-8k_20171201.htm

Design a database for an automobile company to provide to its dealers to assist them in maintaining customer records and dealer inventory and to assist sales staff in ordering cars. Each vehicle is identified by a vehicle identification number (VIN). Each individual vehicle is a particular model of a particular brand offered by the company (e.g., the XF is a model of the car brand Jaguar of Tata Motors). Each model can be offered with a variety of options, but an individual car may have only some (or none) of the available options. The database needs to store information about models, brands, and options, as well as information about individual dealers, customers, and cars. Your design should include an E-R diagram, a set of relational schemas, and a list of constraints, including primary-key and foreign-key constraints.

android studio

-Starting with a basic activity, create a new Java class (use File->New->Java class) called DataBaseManager as in Lecture 5 and create a database table in SQLite, called StudentInfo. The fields for the StudentInfo table include StudentID, FirstName, LastName, YearOfBirth and Gender. Include functions for adding a row to the table and for retrieving all rows, similar to that shown in lecture 5. No user interface is required for this question, t

-Continuing from , follow the example in the lecture notes 5, create a menu (or action bar items) for “Add A Record” and “View Records”. When the menu item “Add A Record” is selected, the program shows a form for entering student information. The data will be added into the database table StudentInfo. When the menu item “View Records” is selected, the program shows all records of all students.

SIS is a management information system for education departments used to manage student data. SIS provide capabilities for registering students in courses; documenting results of student tests and other assessment scores; building student schedules; tracking student attendance; and managing many other student-related data needs in a school or universities.

In this regard, you are asked to do some research about SIS, select one of the aspects that managed by SIS and then design two database tables about this aspect [14 marks] and another database table that represents a relation between the previous two tables [6 marks]. For each table you need to:

1. Define the objective(s) of the table.
2. Design at least five fields for the table; data type and size.

3.Determine the primary key of the table.

Using MySQL Workbench to write and run the following steps, and take a screenshot for me!

Create a species table and a specimen table.

In the species table, include attributes that reflect the name of the species, a general description of the species, and any other attributes you feel relevant.

In the specimens table, include an ID for the specimen, a reference to the species which it is, the date which it was observed, and any relevant details like height, weight, location, or whatever else you think appropriate.

Select appropriate data types and constraints.

Save the SQL commands for creating the tables as text to include in your lab report. Also, run these commands to create the tables in your database.

Additionally, include an ALTER TABLE ADD and an ALTER TABLE MODIFY command. Make sure these are reasonable for your database and run them as well.

Tod Brooker, a registered company auditor, has completed the audit of the financial report of Mayfair Ltd for the year ended 30 June 2018. Mike also audited the financial report for Mayfair for the previous financial year. He drafted the following report for 30 June 2015:

We have audited the statement of financial position, income statement, statement of cash flows and statement of changes in equity for Mayfair Ltd as of 30 June 2018. Our audit was made in accordance with an applicable financial reporting framework. In our opinion, the above-mentioned financial statements are accurately and fairly presented in accordance with generally accepted accounting principles in effect at 30 June 2018.

Tod Brooker, CA

20 August 2018

Other information:

During the year, Mayfair changed its method of accounting for long-term construction contracts. It properly reflected the effects of the change in the current year's financial statements and restated the previous year's statements. Tod is satisfied with Mayfair's justification for making the change. The change is discussed in Note 20 to the financial statements.

Tod was unable to perform normal accounts receivable confirmation procedures, but he used alternative procedures to satisfy himself as to the validity of the receivables.

Mayfair is the defendant in a litigation case, of which the outcome is highly uncertain. If the case is settled in favour of the plaintiff, Mayfair will be required to pay a substantial amount of cash that may require the sale of certain non-current assets. The litigation and possible effects have been properly disclosed in Note 22 to the financial statements.

Required

(a) Consider all the above facts and the pertinent requirements of ASA 700 (ISA 700), and then rewrite the auditor's report in an acceptable and complete format, incorporating any necessary departures from an unmodified report.

(b) Identify any items included in the 'Other information' section that would not affect the auditor's report. Explain why this is the case.

Mr Lee, an Information Technology senior executive from mainland China, was under an employment contract in Malaysia with MSC Sdn Bhd since 1 November 2014. Since then,his pattern of stay until he left Malaysia permanently on 31 December 2019 was as follows:

Period of stay                                                             Place of stay

01 November 2014 to 31 December 2015                  In Malaysia

01 January 2016 to 31 August 2016                           In New Zealand, staying with his uncle

01 September 2016 to 19 September 2016                 In HK visiting mother who was seriously ill

20 September 2016 to 03 February 2017                   In Malaysia

04 February 2017 to 31 August 2017                         In France to undertake a company project

01 September 2017 to 17 November 2018                 In Malaysia

18 November 2018 to 30 November 2018                 In China (13 days) for a vacation

01 December 2018 to 31 December 2019                  In Malaysia

Required:

(a)     Determine the residence status of Mr Lee for Years of Assessments 2014 to 2019 under the Income Tax Act (ITA) 1967.

(Your answer should state the relevant legislation under the ITA 1967)

P/S: EXAMPLE ANSWER (a) WILL BE LIKE THIS .

(b)     Distinguish the requirements between Sections 7(1)(b) and 7(1B) of the ITA 1967.

Laporte Engineering Company leased a machine on January 1, 2017, under a contract calling for four annual payments of $20,000 on December 31, 2017 through 2020. The machine becomes the property of the lessee after the fourth payment. The machine was predicted to have a service life of six years and no residual value, and the interest rate available to Laporte Engineering was 12% on the day the lease was signed. The machine was delivered on January 10, 2017, and was immediately placed in service.

Required:
1. Determine the initial net liability created by the lease and the cost of the leased asset.
2. Prepare a table showing the calculation of the amount of interest expense allocated to each year the lease is in effect and the carrying amount of the liability at the end of each of those years. (Enter all the amounts as positive values. Do not round intermediate calculations. Round your answers to nearest whole dollar.)

3. Prepare the entry to record the leasing of the machine.
- Record signing of lease agreement.

4. Prepare entries that would be made on December 31, 2018, to record the annual depreciation on a straight-line basis, and the recording of the lease payment. Also show how the machine and the lease liability should appear on the December 31, 2018, balance sheet. (Do not round intermediate calculations. Round the final answers to nearest whole dollar. Enter all amounts as positive values.)

1.Record the depreciation on leased machinery.

2.Record the annual lease payment.

The September 30, 2018 balance sheet of ABC Corporation disclosed the following information relating to its receivables:

ABC prepares quarterly financial statements. The following occurred during the fourth quarter of 2018:

1. During the 4th quarter, ABC had credit sales of $2,600,000 and collections on accounts receivable (general) of $2,300,000. Uncollectible accounts totaling $19,000 were written off, and a $2,600 accounts receivable previously written off was collected (not included in the $2,300,000 of cash collections reported above.)

2. On November 1, ABC assigned $300,000 of accounts receivable to Quicken Finance on a non-notification basis. Quicken advanced ABC cash proceeds for 85% of the accounts assigned, less a finance fee of $5,000, in exchange for an interest-bearing note. The note incurs interest at 1% per month on the outstanding loan balance. Cash collections from these assigned accounts are to be remitted monthly to Quicken Finance and include accrued interest (i.e. the cash collected each month must be used to repay both principal and interest on the note.)

3. On December 31, 2018, ABC estimates 5% of total accounts receivable and accounts receivable assigned to be uncollectible.  

a) Determine how much Interest Expense ABC would report on their quarterly income statement for the period 10/1 - 12/31/18 from the assigning transaction:

The following is the ending balances of accounts at June 30, 2018 for Excell Company.

Additional information:

1. The short-term investments account includes $37,000 in U.S. treasury bills purchased in May. The bills mature in July.
2. The accounts receivable account consists of the following:

3. The notes payable account consists of two notes of $69,000 each. One note is due on September 30, 2018, and the other is due on November 30, 2019.
4. The mortgage payable is payable in semiannual installments of $6,400 each plus interest. The next payment is due on October 31, 2018. Interest has been properly accrued and is included in accrued expenses.
5. Nine hundred thousand shares of no par common stock are authorized, of which 580,000 shares have been issued and are outstanding.
6. The land account includes $69,000 representing the cost of the land on which the company's office building resides. The remaining $44,000 is the cost of land that the company is holding for investment purposes.

Required:
Prepare a classified balance sheet for the Excell Company at June 30, 2018. (Amounts to be deducted should be indicated by a minus sign.)