Assignment 2 (assessment worth 15%)
Due Date 24 May at 5pm GMT+8

[Submission will be strictly observed. Make submission via Turnitin]

Question 1

Assume Alpha Ltd is currently trading on the NYSE with a stock price of $65. The American one-year call option on the stock is trading at $20 with strike price of $65. If the one-year rate of interest is 10% p.a. (continuously compounding), is the call price free from arbitrage or is it too cheap/expensive, assuming that the stock pays no dividends? What if the stock pays a dividend of $5 in one year?

Question 2

The current price of a non-dividend paying stock is $35. Use a two-step tree to value an American put option on the stock with a strike price of $33 that expires in 12 months. Each step is 6 months, the risk free rate is 6% per annum (continuously compounding), and the volatility is 15%. What is the option price? Show work in detail and use a tree diagram (Use 4 decimal places).

Question 3

Two firms X and Y are able to borrow funds as follows:

Firm A: Fixed-rate funding at 3.5% and floating rate at Libor-1%.

Firm B: Fixed-rate funding at 4.5% and floating rate at Libor+2%.

Assume A prefers fixed rate and B prefers floating rate. Show how these two firms can both obtain cheaper financing using a swap. What swap strategy would you suggest to the two firms if you were an unbiased advisor? What is the net cost to each party in the swap? Show your work in detail.

The Questions are not related to each other all of them are separate questions

Airline Company Case Study This document describes the data requirements for a fictional airline company, Anchor Air. In this case study, the company's key information requirements are identified. This information primarily deals with the assets the airline must use and manage to operate: airports, maintenance flight routes, and scheduled flights onto which customers book seats along with information about the passengers themselves. Employees The company needs to keep the following information regarding its employee. In the US, all employees have a unique social security number. Other information on employees that the airline might need include facts such as the employee's name; the employee's home street address and the employees city, statement and zipcode; the employee's hone phone number; the employee's salary; and the employee's brithdate. Additionally, some employees are pilot crew, while others are attendant crew. For pilots, the company need to keep the following information:the pilot's rank (probationary, junior, regular, senior); a list of the aircraft the pilot is rated to fly; should reference only aircraft the company owns; the number of flight hours the pilots has flown; the pilots home airport (this should be an airport that the airline is allowed to use); and an additional contact number for the pilot. For attendants, the company needs to keep the following information: the attendant's rank (probationary, crew, chief); the attendant's home airport (again it should be one the airline is allowed to use); and an additional contact number for the attendant Airports An airline is only allowed to fly to specific airports. This airline is a US company and is allowed to fly between US domestic airports only. The company needs to maintain information about the airports it is allowed to use. Airports are identified in the US with a three letter code (upper case)m which are unique. Other facts about airports include which city and state they are in, and how many gates are available for boarding and debarking the aircraft customers. The number of gates must be a positive integer. All of this information is required. Airline Flight Routes The airline has many aircraft flying every day to provide transport for its customers. By regulation, the airline is assigned certain routes between a origin airport and a destination airport. Each route (which is identified by a unique code), is schedule for the same time on the same day every week. While the origin and destination airports are the same every time the route is flown, the gates at the origin and destination airports may change from week to week. The origin and destination airports must each refer to one of the airports to which the airline flies. All of this information is required. Scheduled Flights The airline needs to keep track of the flight routes as they are schedule each day. The schedule simply needs to track which route is being flown (see the previous section on Airline Flight Routes) on which date and what are the departure and arrival gates at the origin and destiation airport, respectively. Flight Prices The seats available on each flight can have varying prices, depending on the class of the seat and these prices can vary from day to day. The database must track the ticket price for the following seat categories: first-class; business class; coach class; and economy class. The ticket price is for a specific seat category for a specific flight route id of the airline on a specific date. Ticket prices must be positive monetary amounts (two decimal places). All of this information is required. Passengers The airline is required to keep certain information about passengers who have booked flights with the airline. The database includes the last name, first name, middle initial, the street address, the city, the state, the zip code, and the phone numbers of the of the passenger and the passengers' email. The required information for the database is the first name, the last name, the street address, the city, the state, the zip code. The the other passenger information is optional. A passenger may give a number of phone numbers or none at all. Flight Bookings The airline must keep information that represents a passenger's booking for one of the airline's flights. The information must show which passenger is booked on a which route on which date and for what price. All of this information is required. Flight Crews The company has to assign crew members (pilots and flight attendants) for each date that one of its routes is flown. For each occurrence of a route being flown on a particular date, the company needs to know which pilots and flight attendants are assigned for that flight on that date. There can be different numbers of crew members assigned, but assume that all flights have cetween two and four pilot crew and four and eight attendant crew.

Relational Database Implementation

In this step, you will implement the table schema developed in step 2, using the Postgres SQL DDL language. Your

deliverable will be a Postgres SQL DDL script which when run in Postgres creates the tables for your case study.

Table Population

In this step, you'll create a data set for your database. Your deliverable will be a Postgres SQL DML script which

when run, inserts your data set into the database tables and also a text document with the data presented in a tabular

format.

Database Operational testing

In this final step, you'll create a Postgres SQL DML script which performs a set of queries on your populated database.

Each case study has a set of sample queries. Choose any ten of these queries and implement them. Your deliverable

will be a Postgres SQL DML script, which when run, performs the queries on your database as well as a text

document with the query results presented in a tabular form. Note, you can capture the query results from the result

window of pgAdminIII.

China is increasingly replacing the West as the new face of globalization in Africa. state four (4) things of what China knows about Africa that the West Doesn’t?

A. After studying nutrition science, you should be knowledgeable about nutrition guidelines and how nutrition can affect health. Please demonstrate what you have learned by explaining the following:

• Using terms and concepts that you have learned in this course, examine 8 aspects of your own diet, and explain any changes you may or may not make. For full credit, support each of your 8 choices with facts from the readings. (For example, currently, I rarely eat any nuts. So, I will start eating one ounce of nuts a day because it will improve my cholesterol level, which will reduce my risk for heart disease. Note: you may not use this example.) [32 points]

B. Explain how nutrients affect disease prevention and management. Make your answer specific with examples. Link the nutrient or nutrients you discuss to a condition. (For example, vitamin C deficiency is linked to scurvy. Note: you may not use this example). For full credit, you must provide at least three examples of how nutrient levels can be related to disease prevention and management. [18 points]

Scenario

Congratulations! Your App Development Proposal has received approval after being shared with both your client and the mobile application development team at Mobile2App. It is now time to construct a UI based on your original proposal. You must supply the client with a complete UI design that is easy to understand and demonstrates a creative theme and layout for the finished application.

Directions

Open the Android Studio Layout Editor to begin creating the UI for your app. Be sure to use the Install Android Studio resource and the Build a Simple User Interface resource, both linked in the Supporting Materials section, to get started with this software. Throughout this project, continue to reference the App Development Proposal you completed in Project One while paying particular attention to the section on UI Design. Also be sure to let the Android Design and Quality Guidelines document, which is linked in the Supporting Materials section, guide your decisions.

Your completed UI should include all of the screens needed for your app to operate but the UI will not yet be functional. You will only be creating the UI components for this project as the supporting code will be completed in Project Three.

1. Create UI with appropriate design elements to support a user logging in (1 screen). Your UI must include a login screen, that contains the following:
   • Fields for the user to provide a username and password
     • Note that the password element should be configured in a way that obscures any text that is typed into the field. This means the text will need to be visually converted into dots.
   • A button for the user to submit their username and password
   • A button for the user to create a new login if it is their first time using the application
     • Note that to simplify the account creation process, you can use the same login screen for this purpose. Create a button that will add the username and password into the database if it does not already exist.
   • Any other fields or elements that are necessary to make your application visually appealing, intuitive, and usable

This problem demonstrates a possible (though rare) situation that can occur with group comparisons. The groups are sections and the dependent variable is an exam score. Section 1 77.6 69.1 53.5 68.2 73.9 63.3 61.3 71.9 60.2 Section 2 58.5 61.3 57.5 34.5 73.2 37.1 50.3 51.2 76.8 Section 3 67.6 63.7 60.5 71.7 65 66.8 58.5 74.2 68.2 Run a one-factor ANOVA (fixed effect) with α = 0.05 α = 0.05 . Report the F-ratio to 3 decimal places and the P-value to 4 decimal places. F = F = p = p = What is the conclusion from the ANOVA? reject the null hypothesis: at least one of the group means is different fail to reject the null hypothesis: not enough evidence to suggest the group means are different Calculate the group means for each section: Section 1: M 1 = M 1 = Section 2: M 2 = M 2 = Section 3: M 3 = M 3 = Report means accurate to 2 decimal places. Conduct 3 independent sample t-tests for each possible pair of sections. (Though we will see later that it might not be appropriate, retain the significance level α = 0.05 α = 0.05 .) Report the P-value (accurate to 4 decimal places) for each pairwise comparison. Compare sections 1 & 2: p = p = Compare sections 1 & 3: p = p = Compare sections 2 & 3: p = p = Based on these comparisons, which pair of groups have statistically significantly different means? group 1 mean is statistically different from group 2 mean group 1 mean is statistically different from group 3 mean group 2 mean is statistically different from group 3 mean none of the group means are statistically significantly different from each other Thought for reflection: What do the results of the pairwise comparisons suggest about the original conclusion from the ANOVA?

Contact the state representative for HIE(Health information exchange)), what can you do as a MSN to be part of improving the HIE and look for successful examples of HIE in your state. If you cannot find anything in your state look to another state for examples. Compare and contrast your findings and post a summary of your experience.

Essay: Susie was hospitalized because she cut herself in an accident. Susie cut her nerve that supplies a muscle in her arm. Please explain to Susie because she is having a difficult time understanding why her muscle doesn’t work if she cut her nerve. You can do so by writing an essay on skeletal muscle excitation and contraction. You should be very detail and descriptive when explaining. Your essay should include and not be limited to the following events:

- describe excitation of the muscle fiber and the events at the neuromuscular junction starting with the release of the neurotransmitter to all the possible things that can occur to or from it

- generation of an action potential

- propagation along the sarcolemma

- the events that lead to the release of “certain” ions

- the events that take place inside the cell which lead to excitation contraction coupling and cross-bridge cycling in detail.

Respond to the following in a minimum of 175 words: In any given day, you may use several different communication models without realizing it. Think about your week. Pick a day in which you communicated with several people. What model did you use in each interaction? Could you have used a different model in that situation? Why or why not? Consider other conversations you’ve had this week. As you think about your day, which model do you find you use most often? Why do you think that is?

Describe how a policy to expand medicare drugs/medicine coverage could be implemented to improve the United States' health care system, using the policy cycle. How would this policy go through the 5 steps of the cycle and explain in detail how it becomes a law? What happens in the legislative branch ( house and senate) through the executive branch including implementation, and what are the potential legal implications up to the Supreme Court?