Eukaryotic and prokaryotic cells are two important kinds of cells encountered in our world. Do the following:

Explain how eukaryotic and prokaryotic cells differ.

Explain how the evolution of cells made cellular respiration possible, and

What environmental pressures necessitated cellular respiration?

Provide citations

*Industrial economics* Select a firm or industry (AMAZON) and use the theory of collusion to carry out an analysis of the strategic behaviour of that firm. As part of the answer, consider the strengths and weaknesses of the theory used. ALSO, Discuss how the firms in the industry collude, or not. *Word count 650* *Include references and citations.*

Why is trust important in a project? How can lack of trust affect the project, team, and stakeholders? How can a project manager establish trust among the project team and stakeholders? Illustrate with an example (either hypothetical or real). Please if citations can be provided I will greatly appreciate it.

1. "Consider the cash flow of the three projects depicted in Table 4. The cost of capital is 7.5%. If an investor decided to take projects with a payback period of 2 years or less, which of these projects would he take?"

   		A) Investment A
   		B) Investment B
   		C) Investment C
   		D) none of these investments

1. Over the past month, TSLA made 14% and GOOG made −12%. The risk free rate was 1% (EMR). How much would you have today if you had invested the following amounts one month ago? Start by working out the portfolio return.

(a) $2000 in GOOG, $2000 in TSLA

(b) Invest $2000 of your own money in this way: short $2000 in TSLA, $1000 invested in a bank account, the rest in GOOG.

(c) Borrow $5000, and buy $10000 worth of TSLA

(d) Borrow $5000, and buy $10000 worth of GOOG

(e) What are your thoughts about “using leverage”, i.e., borrowing to make an investment, based on the last two scenarios?

Assume that you are Tracy Roberts and you are preparing two reports to Morgan Mickelson or Household Goods, Inc.   You should answer the following questions. In one report, you assume that Morgan Mickelson is a CPA and will understand citations to the Accounting Standards Codification (ASC). In this first report, you should use appropriate citations to ASC. The second report covers similar information but the assumption is that Morgan Mickelson is not a CPA and will not understand citations to ASC. You must convey the same information but in language that any businessperson would understand.

1. What is the procedure for testing goodwill for impairment according to ASC standards?
2. Using ASC guidelines determine the goodwill valuation for ZD Corporation. Provide numbers to support your revaluation if necessary and explain your process.
3. Using ASC guidelines determine the goodwill valuation for Hope Industries. Provide numbers to support your revaluation if necessary and explain your process
4. How do the above answers effect Household Goods segment information and overall financial statements?
5. What disclosures need to be provided in Household Goods financial reports concerning goodwill according to ASC?

Assume that Household Goods will be an early adopter of the ASU 2017-04, scheduled to be adopted by publicly traded firms for fiscal years starting after Dec. 15, 2019. Also, assume that ZD and Hope are considered separate reporting units and Household Goods has not elected the Accounting alternative.

Hint: The carrying value of other asset and liability accounts must be determined before goodwill impairment is considered. You should decide what the carrying value of inventory, Property, plant and equipment, and bonds should be. After that, then you consider the valuation of goodwill.

The answers should be conveyed in a report, not just answering the questions, 1, 2, 3 etc.

You should be thorough in your answers, but as concise as possible. Each report should be around 2-3 pages. In the first report, you should use appropriate citations to ASC, but not to any other documents as other documents are not authoritative accounting guidance.

Discuss how you would expect the financing choices of the following firms to differ and explain the reasons for the differences. (Include international and Caribbean examples where possible) ( for example internal or external, traditional non traditional, bank loan angel investors, personal saving etc)
i. A venture that is considered a family firm, compared to a non-family firm.
ii. A venture that belongs to the food industry that is a sole trading firm, compared to a partnership firm.
iii. An early-stage research and development venture, compared to an established venture that is generating revenue.
iv. A venture with revenues that are growing very rapidly and must expand its working capital base to match, compared to a venture with revenues that are growing at the inflation rate.
v. A venture that is highly profitable and growing, compared to a venture that is growing at a similar rate but has not yet achieved profitability.
vi. A venture that is being undertaken by an entrepreneur who has a significant track record of new venture successes, compared to a venture that is being undertaken by an entrepreneur with no previous new venture experience.
Source: Smith, J., Smith, R. L., Smith, R., & Bliss, R. (2011). Entrepreneurial finance: strategy, valuation, and deal structure. Stanford University Press.
This essay must be between 1500 to 2000 words. The paper should consist of an introduction, body, and conclusion, be doubled-spaced and follow APA 6th edition referencing style.

RSQLite (using R studio)

1. Make you have imported the database tables into your database (I've copied and pasted these at the bottom). Write and submit the following RSQLite queries.

2. Retrieve the names of all employees.

3. Retrieve the names of all distinct employee names.

4. Retrieve the names of all employees whose name begins with the letter ‘B’.

5. Retrieve the names and NI numbers (NI_NO) of all employees.

6. Retrieve details of employees who are over 31 years of age.

7. Retrieve details of employees who are between 31 years of age and 65 years of age.

8. Retrieve the average employee age, the age of the youngest employee and the age of the oldest employee.

9. Retrieve the names of all employees and the names of the departments in which they work.

10. Retrieve details of employees who share the phone extension 123.

EMPLOYEE.txt
EMP_N0,NI_NO,NAME,AGE,DEPT_NO
E1,123,SMITH,21,D1
E2,159,SMITH,31,D1
E3,5432,BROWN,65,D2
E5,7654,GREEN,52,D3

PRODUCT.txt
PROD_NO,NAME,COLOR
p1,PANTS,BLUE
p2,PANTS,KHAKI
p3,SOCKS,GREEN
p4,SOCKS,WHITE
p5,SHIRTS,WHITE

SALES ORDER LINE.txt
ORDER_NO,PROD_NO,QUANTITY
01,p1,10
02,p1,10
02,p4,20
09,p1,05
010,p1,05

INVOICES.txt
ORDER_NO,PROD_NO,QUANTITY,PRICE
01,p1,100,2.99
01,p2,20000,2.99
01,p6,20,14.98
02,p2,1000,14.98
02,p6,10000,14.98

SALES ORDER.txt
ORDER_NO,DATE,CUST_NO
01,11/11/17,C1
02,7/9/17,C3
09,8/16/17,C6
010,10/12/17/,C6

CUSTOMER.txt
CUST_NO,NAME,ADDRESS
C1,ALEX,State
C2,BOB,Hollister
C3,CAROL,Ocean
C6,JUAN,Phelps

DEPARTMENT.txt
DEPT_NO,NAME,MANAGER
D1,Accounts,E1
D2,Stores,E2
D3,Sales,null