Signature Assignment

Scenario: Upon successful completion of the MBA program, imagine you work in the analytics department for a consulting company. Your assignment is to analyze one of the following databases:

· Manufacturing

· Hospital

· Consumer Food

· Financial

Select one of the databases based on the information in the Signature Assignment Options.

Provide a 1,600-word detailed, four part, statistical report with the following sections:

· Part 1 – Preliminary Analysis

· Part 2 – Examination of Descriptive Statistics

· Part 3 – Examination of Inferential Statistics

· Part 4 – Conclusion/Recommendations

Part 1 – Preliminary Analysis

Generally, as a statistics consultant, you will be given a problem and data. At times, you may have to gather additional data. For this assignment, assume all the data is already gathered for you.

State the objective:

· What are the questions you are trying to address?

Describe the population in the study clearly and in sufficient detail:

· What is the sample?

Discuss the types of data and variables:

· Are the data quantitative or qualitative?

· What are levels of measurement for the data?

Part 2 – Descriptive Statistics

Examine the given data.

Present the descriptive statistics (mean, median, mode, range, standard deviation, variance, CV, and five-number summary).

Identify any outliers in the data.

Present any graphs or charts you think are appropriate for the data.

Note: Ideally, we want to assess the conditions of normality too. However, for the purpose of this exercise, assume data is drawn from normal populations.

Part 3 – Inferential Statistics

Use the Part 3: Inferential Statistics document.

· Create (formulate) hypotheses

· Run formal hypothesis tests

· Make decisions. Your decisions should be stated in non-technical terms.

Hint: A final conclusion saying “reject the null hypothesis” by itself without explanation is basically worthless to those who hired you. Similarly, stating the conclusion is false or rejected is not sufficient.

Part 4 – Conclusion and Recommendations

Include the following:

· What are your conclusions?

· What do you infer from the statistical analysis?

· State the interpretations in non-technical terms. What information might lead to a different conclusion?

· Are there any variables missing?

· What additional information would be valuable to help draw a more certain conclusion?

Format your assignment consistent with APA format.

Title

ABC/123 Version X

1
  Week 6 Options

QNT/561 Version 9

1

University of Phoenix Material

Option 1: Manufacturing Database

This database contains six variables taken from 20 industries and 140 subindustries in the United States. Some of the industries are food products, textile mill products, furniture, chemicals, rubber products, primary metals, industrial machinery, and transportation equipment. The six variables are Number of Employees, Number of Production Workers, Value Added by Manufacture, Cost of Materials, End-of-Year Inventories, and Industry Group. Two variables, Number of Employees and Number of Production Workers, are in units of 1000. Three variables, Value Added by Manufacture, Cost of Materials, and End-of-Year Inventories, are in million-dollar units. The Industry Group variable consists of numbers from 1 to 20 to denote the industry group to which the particular subindustry belongs.

Option 2: Hospital Database

This database contains observations for six variables on U.S. hospitals. These variables include Geographic Region, Control, Service, Census, Number of Births, and Personnel.

The region variable is coded from 1 to 7, and the numbers represent the following regions:

1 = South

2 = Northeast

3 = Midwest

4 = Southwest

5 = Rocky Mountain

6 = California

7 = Northwest

Control is a type of ownership. Four categories of control are included in the database:

1 = government, nonfederal

2 = nongovernment, not-for-profit

3 = for-profit

4 = federal government

Service is the type of hospital. The two types of hospitals used in this database are:

1 = general medical

2 = psychiatric

Option 3: Consumer Food

The consumer food database contains five variables: Annual Food Spending per Household, Annual Household Income, Non-Mortgage Household Debt, Geographic Region of the U.S. of the Household, and Household Location. There are 200 entries for each variable in this database representing 200 different households from various regions and locations in the United States. Annual Food Spending per Household, Annual Household Income, and Non-Mortgage Household Debt are all given in dollars. The variable Region tells in which one of four regions the household resides. In this variable, the Northeast is coded as 1, the Midwest is coded 2, the South is coded as 3, and the West is coded as 4. The variable Location is coded as 1 if the household is in a metropolitan area and 2 if the household is outside a metro area. The data in this database were randomly derived and developed based on actual national norms.

Option 4: Financial Database

The financial database contains observations on seven variables for 100 companies. The variables are Type of Industry, Total Revenues ($ millions), Total Assets ($ millions), Return on Equity (%), Earnings per Share ($), Dividends per Share ($), and Average Price per Earnings (P/E) ratio. The companies represent seven different types of industries. The variable Type displays a company’s industry type as:

1 = apparel

2 = chemical

3 = electric power

4 = grocery

5 = healthcare products

6 = insurance

7 = petroleum

Copyright © XXXX by University of Phoenix. All rights reserved.

Copyright © 2017 by University of Phoenix. All rights reserved.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

$40 Financial Markets

Assignments # 5, week 5

Chapter 8 Question # 1, 2, 7, 8, and 9.

1. Bond Investment Decision Based on your forecast of interest rates, would you recommend that investors purchase bonds today? Explain.

2. How Interest Rates Affect Bond Prices Explain the impact of a decline in interest rates on:

a. An investor’s required rate of return.

b. The present value of existing bonds.

c. The prices of existing bonds.

7. Coupon Rates If a bond’s coupon rate were above its required rate of return, would its price be above or

below its par value? Explain.

8. Bond Price Sensitivity Is the price of a longterm bond more or less sensitive to a change in interest

rates than to the price of a short-term security? Why?

9. Required Return on Bonds Why does the required rate of return for a particular bond change

over time?

Assignment 6

Chapter 9 Question #s 2, 3, 4, 10, 11, 12, 16, 22.

2. Mortgage Rates and Risk What is the general relationship between mortgage rates and long-term

government security rates? Explain how mortgage lenders can be affected by interest rate movements.

Also explain how they can insulate against interest rate movements.

3. ARMs How does the initial rate on adjustable-rate mortgages (ARMs) differ from the rate on fixed-rate

mortgages? Why? Explain how caps on ARMs can affect a financial institution’s exposure to interest

rate risk.

4. Mortgage Maturities Why is the 15-year mortgage attractive to homeowners? Is the interest rate

risk to the financial institution higher for a 15-year or a 30-year mortgage? Why?

10. Exposure to Interest Rate Movements Mortgage lenders with fixed-rate mortgages should

benefit when interest rates decline, yet research has shown that this favorable impact is dampened.

By what?

11. Mortgage Valuation Describe the factors that affect mortgage prices.

12. Selling Mortgages Explain why some financial institutions prefer to sell the mortgages they originate.

16. Mortgage-Backed Securities Describe how mortgage-backed securities (MBS) are used.

22. Subprime versus Prime Mortgage Problems How did the repayment of subprime mortgages

compare to that of prime mortgages during the credit crisis?

 

dq board is not up

week 9 assingments

Chapter 13 #1, 2, 3, 4, 7, 12, 14,16,17, and 19

1. Futures Contracts Describe the general characteristics of a futures contract. How does a clearinghouse

facilitate the trading of financial futures contracts?

2. Futures Pricing How does the price of a financial futures contract change as the market price

of the security it represents changes? Why?

3. Hedging with Futures Explain why some futures contracts may be more suitable than others

for hedging exposure to interest rate risk.

4. Treasury Bond Futures Will speculators buy or sell Treasury bond futures contracts if they expect

interest rates to increase? Explain.

7. Hedging with Futures Assume a financial institution has more rate-sensitive assets than

rate-sensitive liabilities. Would it be more likely to be adversely affected by an increase or a decrease in

interest rates? Should it purchase or sell interest rate futures contracts in order to hedge its exposure?

12. Cross-Hedging Describe the act of cross-hedging.

What determines the effectiveness of a cross-hedge?

14. Stock Index Futures Describe stock index futures. How could they be used by a financial institution that is anticipating a jump in stock prices but does not yet have sufficient funds to purchase large amounts of stock? Explain why stock index futures may reflect investor expectations about the market more quickly than stock prices.

16. Systemic Risk Explain systemic risk as it relates to the futures market. Explain how the Financial Reform Act of 2010 attempts to monitor systemic risk in the futures market and other markets.

17. Circuit Breakers Explain the use of circuit breakers.

19. Hedging Decision Blue Devil Savings and Loan Association has a large number of 10-year fixed-rate

mortgages and obtains most of its funds from shortterm deposits. It uses the yield curve to assess the market’s anticipation of future interest rates. It believes that expectations of future interest rates are the major force affecting the yield curve. Assume that an upward-sloping yield curve with a steep slope exists. Based on this information, should Blue Devil consider using financial futures as a hedging technique? Explain.

Chapter 14 #1, 2, 4, 5, 7, 8, 10, 11, 13, and 16

1. Options versus Futures Describe the general differences between a call option and a futures contract.

2. Speculating with Call Options How are call options used by speculators? Describe the conditions under which their strategy would backfire. What is the maximum loss that could occur for a purchaser of a call option?

3. Speculating with Put Options How are put options used by speculators? Describe the conditions under which their strategy would backfire. What is the maximum loss that could occur for a purchaser of a

put option?

4. Selling Options Under what conditions would speculators sell a call option? What is the risk to speculators who sell put options?

5. Factors Affecting Call Option Premiums Identify the factors affecting the premium paid on a

call option. Describe how each factor affects the size of the premium.

7. Leverage of Options How can financial institutions with stock portfolios use stock options when they expect stock prices to rise substantially but do not yet have

8. Hedging with Put Options Why would a financial institution holding the stock of Hinton Co. consider buying a put option on that stock rather than simply selling it?

10. Put Options on Futures Describe a put option on interest rate futures. How does it differ from selling

a futures contract?

11. Hedging Interest Rate Risk Assume a savings institution has a large amount of fixed-rate mortgages

and obtains most of its funds from short-term deposits. How could it use options on financial futures to hedge its exposure to interest rate movements?

Would futures or options on futures be more appropriate if the institution is concerned that interest rates will decline, causing a large number of mortgage prepayments?

13. Change in Stock Option Premiums Explain how and why the option premiums may change inresponse to a surprise announcement that the Fed will increase interest rates, even if stock prices are not affected.

16. Backdating Stock Options Explain what backdating stock options entails. Is backdating consistent with rewarding executives who help to maximize shareholder wealth?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Capital Markets-Assignment 2: Case Study Discussion: Tenex Greenhouse Investors

Assignment 2: Case Study Discussion: Tenex Greenhouse Investors

 

To reinforce and expand your understanding of concepts encountered in the case study for this module, please join this group discussion.

 

Refer to the case study:

  • Glynn, J. W., Jr., & Feldstein, J. (2002, July 31). Tenex Greenhouse Investors.

Enter the discussion by posting your answers to the following questions:

 

  • From the entrepreneur’s perspective, what is most important?
  • What additional benefits will the institutional partners get with the new venture?

Conduct additional research necessary to support your discussion statements. Cite all sources of information you use. All written assignments and responses should follow APA rules for attributing sources.

Assignment 2 Grading Criteria
Maximum Points
Explained answers to initial discussion questions.
8
Demonstrated comprehension of financial concepts presented in the case study through use of terminology and concepts derived from assigned readings.
8
Actively contributed to discussion by posting responses to peers’ comments and addressing new questions introduced into discussion.
12
Wrote in a clear, concise, and organized manner; demonstrated ethical scholarship in accurate representation and attribution of sources, displayed accurate spelling, grammar, and punctuation.
4
Total:
32
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

03 Financial Statement Analysis

Financial Statement Analysis

Module 03 Written Assignment – Financial Statement Analysis
Based on the balance sheet and income statement provided for ABC Bank below, calculate the requested analysis values.
Balance Sheet (in millions) Income Statement (in millions)
Assets Liabilities and Equity Interest on fees and loans $ 6,000
Cash and due from banks $ 5,000 Demand deposits $ 18,000 Interest on investment securities 3,000
Investment securities 25,000 NOW accounts 46,000 Interest on repurchase agreements 4,000
Repurchase agreements 32,000 Retail CDs 12,000 Interest on deposits in banks 2,000
Loans (adjusted for losses) 36,000 Debentures 9,000 Total interest income $ 15,000
Fixed assets 12,000 Total liabilities $ 85,000 Interest on deposits in banks 5,000
Other assets 5,000 Common stock 15,000 Interest on debentures 3,000
Total assets $ 115,000 Paid-in capital 10,000 Total interest expense $ 8,000
Retained earnings 5,000 Net interest income 7,000
Total liabilities and equity $ 115,000 Provision for loan losses 2,000
Noninterest income 3,000
Noninterest expenses 1,000
Income before taxes $ 7,000
Taxes 5,000
Net income $ 2,000
Analysis of ABC Bank’s Performance
Return on equity
Return on assets
Asset utilization
Equity multiplier
Profit margin
Interest expense ratio
Provision for loan loss ratio
Noninterest expense ratio
Tax ratio
Net interest margin
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"