Consider an employee who receives a call option with forward start three months from today. The options start 10% out-of-the-money, time to maturity is one year from today, the stock price is 60, the risk-free interest rate is 8%, the continuous dividend yield is 4%, and the expected volatility of the stock is 30%. In other words, S = 60,  = 1.1, t = 0.25, T = 1, r = 0.08, b = 0.08-0.04 = 0.04, and  = 0.30.

Build a spreadsheet model to calculate the call price with panels for inputs and panels for the model, similar to the Black-Scholes type analytical models. spreadsheet model. Use interim calculation steps, such as d1, d2, N(d1) and N(d2), before you reach your final valuation of the option. Round up your final result to $0.01.

Please I need step by step in Excel.

Thank you!

5. There are 100 patients who could benefit from a new drug, Tipilor, manufactured by Zifer. Patient i has willingness to pay i, i=1,…,100. Ignore fixed costs and assume marginal cost, c, is constant.

a) What is the profit maximising price and resulting profit?

b) Now assume all patients have insurance which means they only pay 10% of the price as a co-payment. What is the profit maximising price and resulting profit?

c) Zifer sets up a charity to cover the co-payment for poor people. Patients 1, 2, …, 50 are considered poor. What is the profit maximising price and resulting profit?

d) For c = 10, calculate optimal profit in a), b) and c) and conclude whether setting up the charity is profitable.

Briefly describe one of the following kinds of mortgage and 1) identify who might benefit from this kind of mortgage and 2) explain why widespread use of this kind of mortgage might create risks for banks (do not repeat or reproduce information and commentary already presented in the thread; move on to TOPIC TWO if what you want to say about TOPIC ONE has already been adequately explained):

2/28 ARM (or other forms of subprime mortgages that reduce monthly payments e.g. “interest only loans”)

Low doc or no doc loans

NINJA loans

There are 100 patients who could benefit from a new drug, Tipilor, manufactured by Zifer. Patient i has willingness to pay i, i=1,…,100. Ignore fixed costs and assume marginal cost, c, is constant.

a) What is the profit maximising price and resulting profit?

b) Now assume all patients have insurance which means they only pay 10% of the price as a co-payment. What is the profit maximising price and resulting profit?

c) Zifer sets up a charity to cover the co-payment for poor people. Patients 1, 2, …, 50 are considered poor. What is the profit maximising price and resulting profit?

d) For c = 10, calculate optimal profit in a), b) and c) and conclude whether setting up the charity is profitable.

You are caring for a client who suffers from chronic constipation. He reports drinking an entire bottle of Milk of Magnesia each day to deal with this condition. Which of the following physical manifestations would you anticipate seeing in this patient?

MrT is a 30year old carpenter who has recently recovered from a right shoulder injury. As part of his job, he has to lift heavy building materials overhead and work with his arm held at shoulder height for prolonged periods of time. He now reports difficulty with both of those tasks. He is otherwise healthy and has no other injuries that limit participation in an exercise program. He has come to see you for an exercise program that will permit him to get back to his previous level of function.

1)What parameters of physical capacity do you think need to be improved as part of his program? Name them and justify your response.(3marks)

2)You would like to get an initial outcome measure forMr T’s upper limb muscle endurance. Describe (1) test you would perform and briefly justify your selection.

3)Based on a possible result of your assessment from Question 2, list one (1) short term goal that you could set with Mr T. (1 mark)

4)You decide to give Mr T two (2) exercises that aim to improve his ability to lift heavy building materials overhead. Briefly describe the exercises that you have chosen, list all exercise variables(sets, repetitions, frequency, and amount of resistance) and justify your selections.

Who produces capital, wages and profits from a political economy perspective and how does the control of the surplus ( capital flight and strike, campaign contributions, media and philanthropy) significantly determine the political economy of society ?

(at least 150 words)

A job training program was delivered to 4,000 unemployed youth who were
randomly selected from a pool of 5,000 eligible applicants. The remaining 1,000
individuals did not receive the program. In the treatment group (of 4,000 trainees),
2,500 had a job at the end of the year. In the control group (of 1,000 individuals),
only 500 had a job. The job training program cost $100,000 total. What is the cost
effectiveness of the program?
a. $25 per job obtained
b. $40 per job obtained
c. $50 per job obtained
d. $100 per job obtained
e. $200 per job obtained
f. $500 per job obtained

A household survey in 2017 recorded information on 152 people who were retired from the Australian labour force. Of these, 105 reported government pension or allowance as their main source of income. Calculate a 95% confidence interval to estimate the proportion of all Australian retirees who have government pension or allowance as the main source of income. Give your answers to 3dp:

The lower limit is

The upper limit is