This exercise can improve your understanding of various strategies by giving you experience classifying strategies. This skill will help you use the strategy-formulation tools presente later. Consider the following 12 (actual or possible) year - 2005 strategies by various firms.

The wholesale retailer, Big Lots, expands into Mexico

The food manufacturer, Campbell Soup, begins massive tomato farming operations.

Delta Air Lines acquires an ocean cruise lines company

The specialty retailer, Gap, enters the radio broadcasting business.

The online auction company, eBay, acquires an online auction firm in Russia

The food giant, McDonald's, closes 100 restaurants and lays off 2,000 employees.

General Electric sells its NBC Broadcasting division

Hilton Hotels acquires a large furniture manufacturer

Ford Motor Company acquires its automobile manufacturer

The appliance maker, Maytag, introduces a wireless refrigerator

The drug firm, Eli Lilly , doubles its number of salespersons

The sports firm, Nike, enters the boat manufacturing business.

The records at the end of January of the current year for Young Company showed the following for a particular kind of merchandise:

Beginning Inventory at FIFO: 18 Units @ $18 = $324

Beginning Inventory at LIFO: 18 Units @ $14 = $252

Required:

1. Compute the inventory turnover ratio for the month of January under the FIFO and LIFO inventory costing methods.

This is t a relational database please write SQL queries to solve the listed questions.

The database is a variation of the “Movie Database” . There are several differences in it, so look it over carefully before writing your SQL queries

Notes:

• TheaterNum, MovieNum, and ActorNum are numeric primary key fields in their respective tables. Movie and actor names are not assumed to be unique unless specified otherwise in a question.
• In the THEATER table, Capacity is the number of seats in a theater.
• In the MOVIE table, Year is the year a movie was filmed.
• The ACTED IN table lists all of the actors who acted in a movie. The Star field can have the values Y (yes) or N (no). Assume there is only one star in each movie.

CITY

THEATER

MOVIE

SHOWINGS

DIRECTOR

PRODUCER

ACTOR

PREVIOUSJOB

ACTEDIN

NEWSPAPER

REVIEWER

REVIEW

Questions

Remember to follow all of the instructions listed on the first page.

1. Which theater(s) in Tennessee have the largest capacity?

2. How many reviews were written for each movie directed by John Carter that were filmed in the period 2014 to 2019

3. List the phone number of every theater in Tennessee. Order the results by theater number.

4. What was the total revenue generated by movies made in 2015 that were both directed by James Smith and produced by Mary Jones?

5. Assume there is only one movie titled, “The Matrix.” Who reviewed it?

6. List the cities in Tennessee that have theaters with capacities of at least 200 seats. List the cities in alphabetic order.

7. Which movies have generated more revenue than the movie directed by John Carter in 2010 that generated the most revenue of the movies he directed that year?

8. Which theaters in Tennessee, Arkansas, or Mississippi (you may use 2-letter abbreviations) showed movies whose titles began with any of the letters R, S, or T? List the theaters in numeric order.

9. Who is the oldest actor who starred in a movie made between 1995 and 2005 that was both directed by James Smith and produced by Mary Jones?

10. What was the total revenue generated by movies produced by each producer from 2010 to 2018 that starred an actor who is currently under 40 years of age? Only include producers whose movies generated more than a total of $75,000,000.

Part a.

1. While arranging capital for their business some managers follow the pecking order theory, can you explain what pecking order theory is and why managers choose such a theory to raise capital?
2. Calculate the rate of return available to shareholders for a company financing $1 million of assets with the following three arrangements:

1. All equity
2. 50% equity, and 50% debt at an interest rate of 12% per annum.
3. 25% equity, and 74% debt at an interest rate of 12% per annum.

The assets are expected to generate earnings before interest of $150,000 per annum in perpetuity.

                                                                                                            (5+3=8 marks)

Part b.

What are the potential advantages and disadvantages to a company’s shareholders if the company increases the proportion of debt in its capital structure?

Part c.

1. From the below figures of Collingwood Public Limited, calculate Weighted Average Cost of Capital (WACC) and annual cashflows required by its capital providers.

2. What are the main difficulties in calculating cost of capital for diversified companies?

Financial markets can be classified by which of the following?

Owner of the financial asset

All of the above can be classifications of financial markets.

Type of asset traded

Maturity of the financial asset

With the aid of supply and demand diagrams demonstrate that any and all effective price controls in a competitive market will reduce the actual quantity that can be traded (i.e. bought and sold) in that market.

Why was the U.S. trying to spread our influence to other nations? Could we have still traded with nations if they were communist or under the influence of the Soviet Union? Explain.

Multiple-Step Income Statement

Instructions

Amount Descriptions

Income Statement

Instructions

Use the following information:

Required:

Amount Descriptions

Income Statement

Prepare a multiple-step income statement, including the revenue section and the cost of goods sold section, for Aeito’s Plumbing Supplies for the year ended December 31, 20--.

Income Statement Instructions

A company’s auditor believes the per diem cost in Darwin rose significantly between 2005 and 2012. To test this belief, the auditor sampled 51 business trips from the company’s records for 2005; the sample average was $190 per day, with a population standard devi- ation of $18.50. The auditor selected a second random sample of 47 business trips from the company’s records for 2012; the sample average was $198 per day, with a population standard deviation of $15.60. If he uses a risk of committing a Type I error of 0.01, does the auditor find that the per diem average expense in Darwin has gone up significantly?

1. H_o: mu2005 - mu2012 (= ; <= ; >=)  0

H_a: mu2005 - mu2012 (< > ; > ; <) 0

2. Statistical test: (z / t)  test for 2 populations

3. Level of significance (be careful as to one-tailed or two-tailed)

4. Set up critical values (Write the value in the box, include "-" sign if negative, if two values, just write the positive one)

5. Gather sample data: xbar2005 =  ; n2005 = 51 ; sigma2005 = 18.5; xbar2012 = 198; n2012 = 47; sigma2012 =

6. Calculate test statistic (write your answer correct to 2 decimal places)

7. Make statistical conclusion: (Reject / Do not reject)  the null hypothesis. There is (sufficient/insufficient)   evidence that the per diem expense has rose significantly from 2002 to 2009 at 1% level of significance.