Question 2                                                                                     

On January 1, 2015, Portia Ltd. issued shares worth $1,120,000 to Storm Ltd. to acquire 80% of Storm’s outstanding shares. On the acquisition date, Storm’s statement of financial position shows share capital of $420,000 and retained earnings of $777,000. At the acquisition date, all of Storm’s identifiable assets and liabilities equaled their fair values with the exception of the following:

          Inventories (fair value exceeded book value by $14,000)

          Investments (fair value exceeded book value by $14,000)

          Equipment (fair value exceed net book value by $105,000)

At the acquisition date, Storm’s accumulated amortization account for the equipment had a balance of $805,000. As of the acquisition date, Storm’s equipment had a remaining useful life of 10 years.

Additional information:

Portia records its investments using the cost method.

Portia uses the entity theory method of consolidation.

In 2017, Portia sold all its investments for a gain of $63,000.

In 2018, Portia purchased equipment from Storm for $127,400. At the sale date, Storm’s net book value of the equipment was $98,000. Storm had originally purchased the equipment for $140,000. After the purchase, Portia amortized the equipment at a rate of $18,200 per year for the remaining 7 years of its useful life, taking a full year of amortization in 2018.

During 2019, Storm purchased goods from Portia. At the end of 2019, Storm still had $28,000 of these goods in inventory. Portia had earned a gross margin of 40% on the sale. The goods were sold to external customers in 2020.

During 2019, Portia purchased goods from Storm. At the end of 2019, Portia still had $140,000 of these goods in inventory. Storm had earned a gross margin of 40% on the sale. The goods were sold to external customers in 2020.

During 2020, Portia sold goods of $140,000 to Storm. Portia earned a gross profit of $56,000 on this sale. At the end of 2020, Storm still had $56,000 worth of goods in inventory.

During 2020, Storm sold goods of $980,000 to Portia at a gross margin of 40%. At the end of 2020, Portia still had 10% of the goods in inventory.

During 2020, Portia received $126,000 in royalties from Storm. Between January 1, 2015 and December 31, 2019, Portia received $700,000 in royalties from Storm.

The financial statements for Portia and Storm for the year ended December 31, 2020 are presented on the following pages.

Statement of Financial Position

As of December 31, 2020

                                                                                                      Portia Ltd.      Storm Ltd.

Assets:

Current assets:

Cash                                                                                      $        70,000    $       28,000

Accounts receivable                                                                   210,000             224,000

Inventory                                                                                       252,000             140,000

                                                                                                      532,000             392,000

Noncurrent assets:

Land                                                                                             140,000                   -

Equipment                                                                                 7,000,000        3,780,000

Accumulated amortization, equipment                      (2,478,000)       (1,736,000)

Investment in Storm                                                                  1,120,000           ____-___

                                                                                                    5,782,000        2,044,000

Total assets                                                                           $ 6,314,000     $ 2,436,000

Liabilities and shareholders’ equity:

Current liabilities:

Accounts payable                                                                 $     630,000     $    280,000

Noncurrent liabilities:

Loan payable                                                                               420,000             700,000

                                                                                                    1,050,000             980,000

Shareholders’ equity:

Share capital                                                                             1,680,000             420,000

Retained earnings                                                                    3,584,000        1,036,000

                                                                                                    5,264,000        1,456,000

                                                                                                 $ 6,314,000     $ 2,436,000

Condensed Statement of Comprehensive Income

For the year ended December 31, 2020

                                                                                          Portia Ltd.      Storm Ltd.

Revenue:

            Sales                                             $ 2,804,200   $ 2,100,000

            Royalties                                            210,000                -

            Dividends                                           100,800      ____-___

                                                                      3,115,000      2,100,000

                  Expenses:

                              Cost of sales                                   1,680,000      1,260,000

                              Other                                                   784,000        575,400

                                                                                        2,464,000      1,835,400

                  Net and comprehensive income          $    651,000   $    264,600

Statement of Changes in Equity – Retained Earnings Section

For the year ended December 31, 2020

                                                                                                      Portia Ltd.      Storm Ltd.

Retained earnings, beginning of the year                           $ 3,353,000 $    897,400

Net income                                                                                   651,000         264,600

Dividends declared                                                                    (420,000)      (126,000)

Retained earnings, end of year                                $ 3,584,000 $ 1,036,000

Required:

Prepare Portia’s consolidated financial statements for the year ended December 31, 2020. Be sure to show all your supporting calculations.

6. List the players that have either won more than 2 matches or lost more than 2 matches. List the player number, name, initials, won, and lost. Insert your snip here.

7. Which players are captains of a team and have ever served as a committee members? Display the player number, player name, initials, team number, and committee member position. This will require 3 tables. Insert your snip here.

8. Using a subquery, have any other players been penalized the same amount as player 8? Let MySQL do the work for you. Do not explicitly query for $25. Display the player number, player name, initials, and amount. Insert your snip here.

9. Who has played more than 2 matches? Display the player number as ‘Number’, concatenate the player name (initials, space, name) as ‘Name’, and the number of matches played as ‘Number of Matches’. Insert your snip here.

10. Sum the number of match wins and losses by player number. Display the player number as ‘Number’, concatenate the player name (initials, space, name) as ‘Name’, wins as ‘Total Wins’, and losses and ‘Total Losses’. Insert your snip here.

***********************************************************************************************************************************************

***********************************************************************************************************************************************

***********************************************************************************************************************************************

Create database tennis;

USE tennis;

#--Create table players and fill it--------------------------

Create table players
(
playerno   int       not null    primary key,
name       varchar(15)   not null,
initials   varchar(3),
birth_date   date,
gender       char(1),
joined       int   not null,
street       varchar(15)   not null,
houseno       varchar(4),
zip       char(6),
town       varchar(10)   not null,
phoneno       char(10),
leagueno   char(4)
);

Insert into players values
(2,'Everett','R','1988-01-09','M',2000,'Stoney Road','43','3575NH','Stratford','070-237893','2411'),
(6,'Paramenter','R','1984-06-25','M',2002,'Haseltine Lane','80','1234KK','Stratford','070-476547','8467'),
(7,'Wise','GWS','1983-05-11','M',2006,'Edgecombe Way','39','9758VB','Stratford','070-347689',Null),
(8,'Newcastle','B','1982-07-08','F',2005,'Station Road','4','6584RO','Inglewood','070-458458','2983'),
(27,'Collins','DD','1990-05-10','F',2008,'Long Drive','804','8457DK','Eltham','079-234857','2513'),
(28,'Collins','C','1983-06-22','F',2008,'Old Main 28','10','1294QK','Midhurst','071-659599',Null),
(39,'Bishop','D','1986-10-29','M',2005,'Eaton Square','78','9629CD','Stratford','070-393435',Null),
(44,'Baker','E','1983-09-01','M',2010,'Lewis Street','23','4444LJ','Inglewood','070-368753','1124'),
(57,'Brown','M','1981-08-17','M',2007,'Edgecombe Way','16','4377CB','Stratford','070-473458','6409'),
(83,'Hope','PK','1976-11-11','M',2009,'Magdalene Road','16A','1812UP','Stratford','070-353548','1608'),
(94,'Miller','P','1993-05-14','M',2013,'High Street','33A','5746OP','Douglas','070-867564',Null),
(100,'Parmenter','P','1983-02-28','M',2012,'Haseltine Lane','80','1234KK','Stratford','070-494593','6524'),
(104,'Moorman','D','1990-05-10','F',2014,'Stout Street','65','9437AO','Eltham','079-987571','7060'),
(112,'Bailey','IP','1983-10-01','F',2014,'Vixen Road','8','6392LK','Plymouth','010-548745','1319');

#--Create the table committee_members and fill it--------------------

Create table committee_members
(
playerno   int   not null,
begin_date   date   not null,
end_date   date,
position   varchar(20),
primary key(playerno, begin_date)
);

Insert into committee_members values
(2,'2010-01-01','2012-12-31','Chairman'),
(2,'2014-01-01',Null,'General Member'),
(6,'2010-01-01','2010-12-31','Secretary'),
(6,'2011-01-01','2012-12-31','General Member'),
(6,'2012-01-01','2013-12-31','Treasurer'),
(6,'2013-01-01',Null,'Chairman'),
(8,'2010-01-01','2010-12-31','Treasurer'),
(8,'2011-01-01','2011-12-31','Secretary'),
(8,'2013-01-01','2013-12-31','General Member'),
(8,'2014-01-01',Null,'General Member'),
(27,'2010-01-01','2010-12-31','General Member'),
(27,'2011-01-01','2011-12-31','Treasurer'),
(27,'2013-01-01','2013-12-31','Treasurer'),
(57,'2012-01-01','2012-12-31','Secretary'),
(94,'2014-01-01',Null,'Treasurer'),
(112,'2012-01-01','2012-12-31','General Member'),
(112,'2014-01-01',Null,'Secretary');

#--Create the table matches and Fill it-------------------

Create table matches
(
matchno       int   not null   Primary Key,
teamno       int   not null   references teams(teamno),
playerno   int   not null   references players(playerno),
won       int,
lost       int
);

Insert into matches values
(1,1,6,3,1),
(2,1,6,2,3),
(3,1,6,3,0),
(4,1,44,3,2),
(5,1,83,0,3),
(6,1,2,1,3),
(7,1,57,3,0),
(8,1,8,0,3),
(9,2,27,3,2),
(10,2,104,3,2),
(11,2,112,2,3),
(12,2,112,1,3),
(13,2,8,0,3);

#--Create Table Penalties and Fill it-------------------------------------

create table Penalties
(
paymentno   int   not null   Primary Key,
playerno   int   not null   references players(playerno),
payment_Date   date   not null,
amount   decimal(10,2)   not null
);

Insert into Penalties values
(1,6,'2010-12-08',100.00),
(2,44,'2011-05-05',75.00),
(3,27,'2013-09-10',100.00),
(4,104,'2014-07-08',50.00),
(5,44,'2010-12-08',25.00),
(6,8,'2010-12-08' ,25.00),
(7,44,'2012-12-30',30.00),
(8,27,'2014-08-12',75.00);

#--Create Table Teams and Fill it----------------------------------------------

Create table teams
(
teamno   int   Primary Key   Not Null,
playerno   int   Not Null   references players(playerno),
division   varchar(6)
);

Insert into teams values
(1,6,'first'),
(2,27,'second');

/* ********************************************************************************************
End of loading the database
******************************************************************************************** */

1.Which players have lost more matches than the average number of losses?   No duplicates should be listed.   Order by player number.   Insert your screen shot here.

2.How many players from each town served on the committee in any capacity? Display the town as ‘Town’ and the number served as ‘Committee Service’.   Insert your screenshot here.

3.How many members come from each town? Display the town as ‘Town’ and the number of members as ‘Number’. Insert your screenshot here.

4.Who has served on the committee more than once? Display the player number as ‘Number’, concatenate the player initial and name as ‘Name’, town as ‘Town’, and number served as ‘Terms’. Insert your screenshot here.

Below I will include the tennis database

* *******************************************************************

CREATE and OPEN the TENNIS Base

******************************************************************* */

Create database tennis;

USE tennis;

#--Create table players and fill it--------------------------

Create table players

(

playerno              int                         not null                primary key,

name                    varchar(15)         not null,

initials   varchar(3),

birth_date           date,

gender                 char(1),

joined                   int          not null,

street                   varchar(15)         not null,

houseno                             varchar(4),

zip                         char(6),

town                     varchar(10)         not null,

phoneno                             char(10),

leagueno             char(4)

);

Insert into players values

(2,'Everett','R','1988-01-09','M',2000,'Stoney Road','43','3575NH','Stratford','070-237893','2411'),

(6,'Paramenter','R','1984-06-25','M',2002,'Haseltine Lane','80','1234KK','Stratford','070-476547','8467'),

(7,'Wise','GWS','1983-05-11','M',2006,'Edgecombe Way','39','9758VB','Stratford','070-347689',Null),

(8,'Newcastle','B','1982-07-08','F',2005,'Station Road','4','6584RO','Inglewood','070-458458','2983'),

(27,'Collins','DD','1990-05-10','F',2008,'Long Drive','804','8457DK','Eltham','079-234857','2513'),

(28,'Collins','C','1983-06-22','F',2008,'Old Main 28','10','1294QK','Midhurst','071-659599',Null),

(39,'Bishop','D','1986-10-29','M',2005,'Eaton Square','78','9629CD','Stratford','070-393435',Null),

(44,'Baker','E','1983-09-01','M',2010,'Lewis Street','23','4444LJ','Inglewood','070-368753','1124'),

(57,'Brown','M','1981-08-17','M',2007,'Edgecombe Way','16','4377CB','Stratford','070-473458','6409'),

(83,'Hope','PK','1976-11-11','M',2009,'Magdalene Road','16A','1812UP','Stratford','070-353548','1608'),

(94,'Miller','P','1993-05-14','M',2013,'High Street','33A','5746OP','Douglas','070-867564',Null),

(100,'Parmenter','P','1983-02-28','M',2012,'Haseltine Lane','80','1234KK','Stratford','070-494593','6524'),

(104,'Moorman','D','1990-05-10','F',2014,'Stout Street','65','9437AO','Eltham','079-987571','7060'),

(112,'Bailey','IP','1983-10-01','F',2014,'Vixen Road','8','6392LK','Plymouth','010-548745','1319');

#--Create the table committee_members and fill it--------------------

Create table committee_members

(

playerno              int          not null,

begin_date          date       not null,

end_date             date,

position               varchar(20),

primary key(playerno, begin_date)

);

Insert into committee_members values

(2,'2010-01-01','2012-12-31','Chairman'),

(2,'2014-01-01',Null,'General Member'),

(6,'2010-01-01','2010-12-31','Secretary'),

(6,'2011-01-01','2012-12-31','General Member'),

(6,'2012-01-01','2013-12-31','Treasurer'),

(6,'2013-01-01',Null,'Chairman'),

(8,'2010-01-01','2010-12-31','Treasurer'),

(8,'2011-01-01','2011-12-31','Secretary'),

(8,'2013-01-01','2013-12-31','General Member'),

(8,'2014-01-01',Null,'General Member'),

(27,'2010-01-01','2010-12-31','General Member'),

(27,'2011-01-01','2011-12-31','Treasurer'),

(27,'2013-01-01','2013-12-31','Treasurer'),

(57,'2012-01-01','2012-12-31','Secretary'),

(94,'2014-01-01',Null,'Treasurer'),

(112,'2012-01-01','2012-12-31','General Member'),

(112,'2014-01-01',Null,'Secretary');

#--Create the table matches and Fill it-------------------

Create table matches

(

matchno                             int          not null Primary Key,

teamno                int          not null references teams(teamno),

playerno              int          not null references players(playerno),

won                      int,

lost                       int

);

Insert into matches values

(1,1,6,3,1),

(2,1,6,2,3),

(3,1,6,3,0),

(4,1,44,3,2),

(5,1,83,0,3),

(6,1,2,1,3),

(7,1,57,3,0),

(8,1,8,0,3),

(9,2,27,3,2),

(10,2,104,3,2),

(11,2,112,2,3),

(12,2,112,1,3),

(13,2,8,0,3);

#--Create Table Penalties and Fill it-------------------------------------

create table Penalties

(

paymentno         int          not null Primary Key,

playerno              int          not null references players(playerno),

payment_Date   date       not null,

amount decimal(10,2)     not null

);

Insert into Penalties values

(1,6,'2010-12-08',100.00),

(2,44,'2011-05-05',75.00),

(3,27,'2013-09-10',100.00),

(4,104,'2014-07-08',50.00),

(5,44,'2010-12-08',25.00),

(6,8,'2010-12-08' ,25.00),

(7,44,'2012-12-30',30.00),

(8,27,'2014-08-12',75.00);

#--Create Table Teams and Fill it----------------------------------------------

Create table teams

(

teamno int          Primary Key        Not Null,

playerno              int          Not Null               references players(playerno),

division varchar(6)

);

Insert into teams values

(1,6,'first'),

(2,27,'second');

/* ********************************************************************************************

End of loading the database

******************************************************************************************** */

As a recently hired accountant for a small business, SMC, Inc., you are provided with last year’s balance sheet, income statement, and post-closing trial balance to familiarize yourself with the business.

You are also given the following information that summarizes the business activity for the current year,2020

Assignment Summary

On the excel spreadsheet attached, perform the following tasks using the information from SMC, Inc. provided above:

1. Journalize the transactions for the current year, 2020, using the chart of accounts on the excel spreadsheet provided

Q1. Which of the following is directly included in the U.S. GDP for 2020?

i. 2020 Cadillac Escalade produced and sold as a new car in the United States in 2020

ii. tires produced in the United States, purchased by General Motors, and installed on a new Cadillac Escalade sold in 2020

iii. General Motors cars produced in Canada because General Motors is an American corporation.

Q2. As more women decide to work outside the home and therefore hire others to work around their home, GDP will increase by

a. only the value of the output produced by the newly working women.

b. only the value of the household work they are now hiring someone to perform.

c. the value of the output produced by the newly working women plus the value of any household work they are now hiring someone to perform.

d. the value of the output produced by the newly working women minus the value of the household work they were previously performing.

Q3. The base year is 2018. A country only produces Blu-ray players. The price of a Blu-ray player in 2018 was $100. The price of a Blu-ray player was $90 in 2019. The quantity of Blu-ray players produced in 2018 was 10,000 units and in 2019 was 10,500 units. Nominal GDP in 2018 was____, real GDP in 2018 was, nominal GDP in 2019 was _____and real GDP in 2019 equals_____.

Group of answer choices

a. $1,000,000; $1,000,000; $945,000; $1,050,000

b. $1,050,000; $1,000,000; $900,000; $945,000

c. $945,000; $900,000; $1,000,000; $1,050,000

d. $900,000; $945,000; $1,050,000; $1,000,000

Open Air_Traffic data. SETUP: It is believed that in July, as years go by we see higher and higher traffic. Given the data your job is to confirm or disprove this assertion.

4. What test/procedure did you perform? (4 points)

• a. Regression
• b. Two sided t-test
• c. One sided t-test
• d. Confidence Interval

5. What is the statistical interpretation? (4 points)

• a. Average of data is inconsistent with the claim
• b. P-value is too large to have a conclusive answer
• c. P-value is smaller than 5% thus we are confident to say that the slope is not zero.
• d. P-value is smaller than 5% thus we are confident that the averages are different.
• e. None of these

6. What is the conclusion? (4 points)

• a. We cannot claim that in July, as years go by we see higher and higher traffic.
• b. We can claim that in July, as years go by we see higher and higher traffic.
• c. None of these

During 2020, Vaughn Manufacturing incurred weighted-average accumulated expenditures of $1730000 during construction of assets that qualified for capitalization of interest. The only debt outstanding during 2020 was a $2000000, 12%, 5-year note payable dated January 1, 2020.

What is the amount of interest that should be capitalized by Vaughn during 2020? Question 10 options: a) $240,000 b) $207,600 c) $0 d) $32,400

VAT Deductible and VAT Received for Company C in a given tax period are as follows.

Required: a) Fill VAT tax return number on the table for each month.

b) Close the VAT Accounts and make the journal entries at the end of April, May, June 2020.

c) If it is necessary make journal entries for VAT payment to the tax offices on 26 May, 26 June, 26 July 2020.