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?

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

Information on the following Database:

create database Sales_Co

use Sales_Co

create table Vendor

(v_code integer,

v_name varchar(35) not null,

v_contact varchar(15) not null,

v_areacode char(3) not null,

v_phone char(8) not null,

v_state char(2) not null,

v_order char(1) not null,

primary key (v_code));

create table product

(p_code varchar(10) constraint product_p_code_pk primary key,

p_descript varchar(35) not null,

p_indate datetime not null,

p_qoh integer not null,

p_min integer not null,

p_price numeric (8,2) not null,

p_discount numeric (4,2) not null,

v_code integer,

constraint product_v_code_fk foreign key (v_code) references vendor);

create table Customer

(cus_code integer primary key,

cus_lname varchar(15) not null,

cus_fname varchar(15) not null,

cus_initial char(1),

cus_areacode char(3),

cus_phone char(8) not null,

cus_balance numeric (9,2) default 0.00,

constraint cus_ui1 unique(cus_lname,cus_fname,cus_phone));

create table Invoice

(inv_number integer primary key,

cus_code integer not null references customer(cus_code),

inv_date datetime default current_timestamp not null,

constraint inv_ck1 check (inv_date > '2010-01-01'));

create table Line

(inv_number integer not null,

line_number numeric(2,0) not null,

p_code varchar(10) not null,

line_units numeric(9,2) default 0.00 not null,

line_price numeric(9,2) default 0.00 not null,

primary key (inv_number,line_number),

foreign key (inv_number) references invoice on delete cascade,

foreign key (p_code) references product(p_code),

constraint line_ui1 unique(inv_number,p_code));

create table Employee

(emp_num integer primary key,

emp_title char(10),

emp_lname varchar(15) not null,

emp_fname varchar(15) not null,

emp_initial char(1),

emp_dob datetime,

emp_hire_date datetime,

emp_years integer,

emp_areacode char(3),

emp_phone char(8));

create table EMP

(emp_num integer primary key,

emp_title char(10),

emp_lname varchar(15) not null,

emp_fname varchar(15) not null,

emp_initial char(1),

emp_dob datetime,

emp_hire_date datetime,

emp_areacode char(3),

emp_phone char(8),

emp_mgr integer);

2. Formulate SQL queries to run against Sales_Co database.

   1. Use the Employee table in the SaleCo database to prepare a list of all employees whose last names start or begin with ‘Smith’. The list should display employee number, first name, last name, and middle initial. The list should be alphabetized by last name. (5 points)

   2. Prepare a list of all employees who have been with the company for at least 15 years or less than 5 years. Display employee number, first name, last name, employee initial based on first and last names (call this column “Initial”), and number of years the employee has been with the company. Initial column values should have the following format: firstnameinitial.lastnameinitial. For example, the initial for George Kolmycz will be G.K. The list should be arranged from the least number of years to the most. (8 points)

   3. Prepare a list of all customers where customer owe a balance. The list should display customer code, first name, last name, and balance they owe (cus_balance). Arrange the list in ascending order by last name and then descending order by first name. (7 points)

   4. Now, modify the above query to show only the 3rd and 4th rows of your results. (4 points)

   5. Prepare a list of items purchased on each invoice. The list should include invoice number, product code of purchased item, quantity purchased, unit price and total amount (units*price) paid for that item. The list should include items from all invoice numbers except 1003, 1006, 1008. (hint: use Line table) (7 points)

   6. Now, modify above query and show top 5 rows of results only. (2 points)

   7. Prepare a list similar to the one in (5) above but include all invoice numbers here. Now, display only those items with total amount paid between $25.00 and $35.00, inclusive. (6 points)

   8. Which invoices were issued to customer # 10014 before January 17, 2018. List invoice number, and date issued. (6 points)

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.

You are required to create a sales and marketing management system with a small number of common sense attributes. The system should contain the following information  Sales details  Marketing details  Customer details  Production details  Delivery details  Management details

So consider what sales and marketing system is required to deliver a consistent and customer oriented service to all customers over the world. You need to identify the tables you require and the information that they are to contain. This is only a small system, do not over-complicate it.

Create an entity-relationship (ER) model drawn with MS WORD or POWER POINT if you prefer. You are required to submit a print out of your database schema:  Set of normalised tables – with your sample data.  Indicate the table relationships using multiple keys; PK, FK, and SK using UML notation.

2 2. Use MYSQL to create the set of database tables of the relational database model and complete the associated queries given. Procedure:

1) Write all the SQL statements, necessary to create all tables and relationships, with Primary & Foreign keys.

2) Execute each statement in the correct order to create the relational database in MYSQL.

3) Insert some data into each table.

4) Use all your SQL create and Insert statements (from MS Word) to execute in the MYSQL WorkBench

5) Write in MS Word and execute in MYSQL WorkBench the statements necessary to; i. display all tables, ii. identify sales total for each item iii. identify delivery confirmation of sold items iv. identify marketing level for sold items

3. Using MS-ACCESS, link to the MYSQL database and create forms to enter sales and purchase orders. 

No buttons are necessary, just what ACCESS generates to scroll forward, add a record etc.

 Make it clear what the forms do in the Form by adding text or headers.