Excel Online Structured Activity: Black-Scholes Model Assume the following inputs for a call option: (1) current stock price is $26, (2) strike price is $31, (3) time to expiration is 5 months, (4) annualized risk- free rate is 6%, and (5) variance of stock return is 0.15. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Open spreadsheet Use the Black-Scholes model to find the price for the call option. Do not round intermediate calculations. Round your answer to the nearest cent. $
Q: You are considering buying a car (sticker price of $43,000) but need financing. The car dealership…
A: A loan is a financial arrangement in which a lender provides funds to a borrower with the…
Q: You have $14,484.85 in a brokerage account, and you plan to deposit an additional $5,000 at the end…
A: This is a time value Problem, Here we have the present value, future value and interest rate given,…
Q: Beginning three months from now, you want to be able to withdraw $3,400 each quarter from your bank…
A: Amount withdrawn each quarter = $3,400Number of years = 4 yearsInterest rate per quarter = 0.56%
Q: ou decide to invest $10.5k today into a security that will make fixed annual payments to you of…
A: Today's investment amount = $10,500Interest rate = 7.5%Annual payment = $2,152
Q: Allison and Leslle, who are twins, just received $35,000 each for their 22th birthday. They both…
A: The NPER function can be used in the excel sheet so that the number of years each person would take…
Q: 1. Suppose a five-year, $ 1000 bond with annual coupons has a price of $ 898.64 and a yield to…
A: The coupon rate of a bond can be calculated using the below formula:…
Q: Union Pacific is considering the elimination of a railroad grade crossing by constructing a dual…
A: Here,MaintenanceCost if $11,500 per year from Year 1 to Year 3Increase in maintenance Cost from Year…
Q: You plan on retiring in exactly 6 years and you would like to have a retirement fund balance of…
A: The FV of an investment refers to the combined value of the investment's cash flows at a future date…
Q: Which TWO of the following statements would be an advantage of adopting IFRS Standards? i) It would…
A: The problem case focuses on identifying the advantages of IFTS standards. The IFRS is an…
Q: Your firm is contemplating the purchase of a new $530,000 computer - based order entry system. The…
A: IRR is also known as Internal Rate of Return.. It is a capital budgeting technique which helps in…
Q: An investor pays $370,000 for a mine that will produce level annual revenue for 16 years. What…
A: Businesses can utilize sinking funds, a type of financial mechanism, to routinely set aside money…
Q: a. Find the present values of the following cash flow streams at an 8% discount rate. Do not round…
A: The PV of an investment refers to the combined value of the investment's cash flows assuming that…
Q: The Oscar Meyer Corporation earned $33 million in 2019 on sales of $450.5 million. The company's…
A: Sales = $450.5 millionNet Income = $33 millionCurrent Assets = $27 millionFixes Assets = $378…
Q: 105.24-25, and an in
A: The quote USD/JPY at 105.24-25 means that the bank is willing to sell 1 US dollar for 105.25…
Q: You find the following Treasury bond quotes. To calculate the number of years until maturity, assume…
A: Bond investors should pay close attention to yield to maturity as it provides a useful measure of…
Q: C X 6 PVS1 PVA FV$1 FVA 3 9.00% 0.77218 2.53129 1.29503 3.27810 4.50% 0.76790 5.15787 1.30226…
A: Present value refers to the method of time, the value of money used for estimating the current value…
Q: You invest in a project that is expected to generate fixed annual cashflows for 4 years beginning in…
A: The movement of funds into and out of a financial system or firm over a predetermined length of time…
Q: Statement of Cash Flows in 2022, Upper Crust had cash flows from investing activities of -$235,000…
A: Ending balance of cash account = $108,000Beginning balance of cash account = $93,000Total net cash…
Q: After 8 years, when the market interest rate has dropped to 8%, the company would like to refinance…
A: The PMT for the old loan amount will be found then after the PV for the old loan amount at the old…
Q: Chadron Sports is considering adding a miniature golf course to its facility. The course would cost…
A: Net present value(NPV) is the difference between present value of all cash inflows and initial…
Q: As a jewelry store manager, you want to offer credit, with interest on outstanding balances paid…
A: Nominal rate compounded quarterly from your bank(r) =5%Number of compounding(n) =12
Q: assume the direct quote on the euro is 2.14 and the indirect quote on the Swiss franc is 0.76. what…
A: Direct quote on the euro = 2.14Indirect quote on the Swiss franc = 0.76
Q: The engineering staff at the Sun Shipping Company has informed decision-makers that substantial…
A: The current worth of the future savings can be found to determine the amount that company would be…
Q: Heat Inc. sells computer hard drives, and the market is competitive (i.e., sales price will not be…
A: Leverage refers to the instrument which is used for evaluating the maximum returns from the…
Q: Larry also holds 2,000 shares of common stock in a company that only has 20,000 shares outstanding.…
A: This question is related to the effects of the new issuance of shares on the value of investment
Q: An arrangement with a broker to borrow stocks from them and then sell it in the market, with the…
A: The correct answer is b. short sales.Short selling involves borrowing stocks from a broker, selling…
Q: You see the yield curve reports a rate for the 2-month Treasury to be 2.25%. If you held this bond…
A: The objective of this question is to determine the actual rate of return on a 2-month Treasury bond…
Q: future spot rate of of zloty in three months R) d three-month interest lish zloty (%) d three-month…
A: Determine the currency of borrowing Since the interest rate on Polish zloty is higher than the…
Q: Lincoln Company purchased merchandise from Grandville Corp. on September 30, 2021 Payment was made…
A: Present value is the current value of the future cash flow. It can be determined by discounting the…
Q: ASSETS Cash Accounts receivable Inventory Net plant and equipment Total assets LIABILITIES AND…
A: The total asset turnover ratio is a financial measure used to evaluate how well a company generates…
Q: The following prices are available for call and put options on a stock priced at $50. Calls Puts…
A: ostAs per the question, the option prices provided the cost breakdown for a butterfly spread using…
Q: Suppose you observe the following situation: Security Pete Corporation Repete Company Beta 1.65 1.34…
A: CAPM stands for Capital Asset Pricing Model. It is an important financial model. The model shows the…
Q: As part of a community initiative, funding is being sought from potential contributors to sustain a…
A: TVM refers to the concept that considers the effect of the interest-earning capacity of money, which…
Q: Consider r1= 5.2% What are the following forward rates, where fi, k refers to a forward rate for the…
A: Forward Rates:Interest rates that are set today for a loan or investment that will happen later are…
Q: Mort is to pay off a loan of $65,000 with equal payments at the end of every month over 10 years…
A: Monthly payment refers to the amount that is paid every month for the repayment of a loan amount…
Q: A compay expects earnings to be $3.18 next year, after earning $3.00 this year. With PEG ratio of…
A: Expected earnings in next year : $3.18Earnings in the current year : $3.00PEG ratio : 2.00xWe need…
Q: You annually invest $1,500 in an individual retirement account (IRA) starting at the age of 25 and…
A: Your annual investment, PMT = $ 1,500 Starting age = 25Number of Years, n = 15Annual Interest…
Q: ossible wealth outcomes for a person with $10,000 in wealth who faces a 10 percent chance of losing…
A: To analyze the possible wealth outcomes for a person with $10,000 in wealth facing a 10% chance of…
Q: James borrows $280 000 and repays the loan in equal fortnightly repayments of $1250 over 20 years.…
A: The time value of money is a concept used to compute and analyze the present worth of the future…
Q: ing 125,000 new shares at a price of $18.20 per share. If the new shares are sold to outs
A: Calculate Judy's current ownership proportion:Judy owns 15,000 shares out of 1,000,000 total shares…
Q: Calculating Real Rates of Return IfTreasury bills are currently paying 4.7 percent and the inflation…
A: Real rate of return refers to the return after the adjustment of the inflation rate.
Q: What is the future value (at the end of 10 years) of an annuity that pays $700 a quarter over 10…
A: Quarterly payment$700Interest rate6.6%Number of years10 years
Q: Lance Whittingham IV specializes in buying deep discount bonds. These represent bonds that are…
A: Par value$1,000.00Coupon rate4%YTM14%Years to maturity18Coupon payment$40.00
Q: Your firm has an average receipt size of $135. A bank has approached you concerning a lockbox…
A: In this scenario, our objective is to assess whether the lockbox project should be approved,…
Q: What will the borrowers' monthly payment be immediately after the first reset?
A: Monthly payments refer to the specified amount that a borrower is required to repay on a loan each…
Q: Para el año que culmina el 30 de junio de 2018, Northern Air Cooling Corporation tiene: Total…
A: The objective of the question is to calculate the net income, sales, and debt-to-equity ratio for…
Q: Suppose ABC Co. issues $11.75 million of 19 year zero coupon bonds today f investors require a…
A: Zero coupon bonds are not paid any coupon and only par value of bond is paid on maturity of bond…
Q: An individual (with log-utility) wants to maximize her happiness level over her adolescence and…
A: At the age 18 the individual inherits one hundred thousand dollars and must decide how much to…
Q: A 5-year Treasury bond has a 3.4% yield. A 10-year Treasury bond yields 6.1%, and a 10-year…
A: Corporate Bond:It represents a debt instrument issued by a company for the purpose of raising…
Q: Company A may buy a testing equipment costing $80,000. This equipment is expected to reduce labor…
A: The movement of money into or out of a business or financial product is referred to as cash flow,…
Vijay
Step by step
Solved in 3 steps with 2 images
- Video Excel Online Structured Activity: Black-Scholes Model Assume the following inputs for a call option: (1) current stock price is $26, (2) strike price is $30, (3) time to expiration is 6 months, (4) annualized risk-free rate is 6%, and (5) variance of stock return is 0.2. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. X Open spreadsheet Use the Black-Scholes model to find the price for the call option. Do not round intermediate calculations. Round your answer to the nearest cent. $Assume the following inputs for a call option: (1) current stock price is $23, (2) strike price is $28, (3) time to expiration is 5 months, (4) annualized risk-free rate is 5%, and (5) variance of stock return is 0.3. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the question below. Use the Black-Scholes model to find the price for the call option. Do not round intermediate calculations. Round your answer to the nearest cent.The market and Stock J have the following probability distributions: Probability rM rJ 0.3 15.00 % 19.00 % 0.4 10.00 6.00 0.3 18.00 10.00 The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet Calculate the expected rate of return for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the expected rate of return for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank % Calculate the standard deviation for the market. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %Calculate the standard deviation for Stock J. Do not round intermediate calculations. Round your answer to two decimal places.fill in the blank %
- You want to estimate the monthly alpha and beta of AXON stock, using the index model. Suppose AXON has a beta of 0.95 and a monthly alpha of 0.5 (representing half a percent). If you set up the regression model correctly, the index model equation should be (remember in index model formulas, we use R instead of r to denote excess returns): Select an answer and submit. For keyboard navigation, use the up/down arrow keys to select an answer. b с d Rmarket = Rmarket = 0.5 x Rstock +0.95 Raxon 0.95 x Rstock +0.5 = 0.5 x Rmarket +0.95 Raxon = 0.95 x Rmarket +0.5The following table represents the rate of returns of two stocks in different economic conditions along with their probabilities (the data are also uploaded on moodle) RATES OF RETURN ON STOCKS EXPECTED ECONOMIC PROBABILITY STOCK A STOCK B CONDITIONS RECESSION 0.55 -0.04 -0.02 STABLE 0.35 0.25 0.30 EXPANDING 0.10 0.15 0.20 Answer the following by using mathematical calculations: a) Calculate the expected rate of return for each stock respectively. Explain what the expected value implies. b) Calculate the standard deviation for each stock respectively. Explain what the standard deviation implies. c) If you were an investor in which stock you were going to invest? Justify your answer. d) Calculate the covariance between Stock A and stock B. Discuss. e) Calculate the expected return and the standard deviation of the portfolio consisting 40% in stock A and 60% in stock B. f) Discuss the risk and return associated with investing i All of your funds in stock A ii. All of your funds in stock…Type the answers with a screen capture of chart. Produce a daily OHLC bar or Candlestick price chart on PTC us stock. Then, add (1) Two moving averages (it can be simple moving averages or exponential moving averages, with one faster and one slower). You can choose any parameter (number of days, simple or exponential) you prefer. (2) Trend lines over the period covered. It can be up trend line, down trend line or channel that you observe from the chart. (3) Technical indicator(s) such as RSI or MACD. Note: after done the drawing, capture the screen and save as picture and then work with your saved pictures. Can use ANY charting app. On the chart, 1. Identify and mark the current key support and resistance levels. They should include the immediate support/resistance level and the next support/resistance levels. "Current" means you are focusing on the current or latest price level, do not mention the support or resistance levels when the price was, say, several months ago in the earlier…
- Karen Kay, a portfolio manager at Collins Asset Management, is using thecapital asset pricing model (CAPM) for making recommendations to her clients.Her research department has developed the information shown in the followingexhibit.Forecast Returns, Standard Deviations, and BetasForecast Return Standard Deviation BetaLow β stock (X) 14.0% 36% 0.8High β stock (Y) 17.0% 25% 1.5Market index 14.0% 15% 1.0Risk-free rate 5.0%(a) Calculate expected return and alpha for each stock.(b) Identify and justify which stock would be more appropriate for an investorwho wants to add this stock to a well-diversified equity portfolio.(c) Now consider Karen employs the “Betting Against Beta” strategy and let, , and denote the portfolio weights of the investmentin each of the asset classes (e.g. risk-free asset, low beta stock, market index,high beta stock, respectively) such that .According to its investment mandate, Collins Asset Management shouldtarget a gross leverage of 2.3. How much does she have to…(Expected rate of return and risk) Syntex, Inc. is considering an investment in one of two common stocks. Given the information that follows, which investment is better, based on the risk (as measured by the standard deviation) and return? Common Stock A Probability 0.20 0.60 0.20 Probability 0.15 0.35 0.35 0.15 (Click on the icon in order to copy its contents into a spreadsheet.) ew an example Get more help. T 3 a. Given the information in the table, the expected rate of retum for stock A is 15.6 %. (Round to two decimal places.) The standard deviation of stock A is %. (Round to two decimal places.) E D 80 73 Return. 12% 16% 18% U с $ 4 R F 288 F4 V Common Stock B % 5 T FS G 6 Return -7% 7% 13% 21% B MacBook Air 2 F& Y H & 7 N 44 F? U J ** 8 M | MOSISO ( 9 K DD O . Clear all : ; y 4 FIX { option [ + = ? 1 Check answer . FV2 } ◄ 1 delete 1 return shiftStock X has a 9.5% expected return, a beta coetticient ot 0.8, and a 35% standard deviation of expected returns. Stock Y has a 12.0% expected return, a beta coetticient of 1.1, and a 20.0% standard deviation. The risk-free rate is 6%, and the market risk premium is 5%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. XE Open spreadsheet a. Calculate each stock's coefficient of variation. Round your answers to two decimal places. Do not round intermediate calculations. CV CVy b. Which stock is riskier for a diversified investor? I.For diversified investors the relevant risk is measured by standard deviation of expected returns. Therefore, the stock with the lower standard deviation of expected returns is more risky. Stock Y has the lower standard deviation so it is more risky than Stock X, II. For diversified investors the relevant risk is measured by beta. Therefore, the stock…
- Excel Online Structured Activity: Historical Return: Expected and Required Rates of Return You have observed the following returns over time: Year Stock X Stock Y Market 2011 14 % 12 % 10 % 2012 20 7 9 2013 -13 -2 -13 2014 3 1 2 2015 19 9 12 Assume that the risk-free rate is 4% and the market risk premium is 6%. The data has been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below. Open spreadsheet What is the beta of Stock X? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 2 What is the beta of Stock Y? Do not round intermediate calculations. Round your answer to two decimal places. fill in the blank 3 What is the required rate of return on Stock X? Do not round intermediate calculations. Round your answer to one decimal place. fill in the blank 4 % What is the required rate of return on Stock…(Expected rate of return and risk) Syntex, Inc. is considering an investment in one of two common stocks. Given the information that follows, which investment is better, based on the risk (as measured by the standard deviation) and return? Common Stock A Probability 0.20 0.60 0.20 Probability 0.15 0.35 0.35 0.15 (Click on the icon in order to copy its contents into a spreadsheet.) Common Stock B Return 13% 14% 18% Return - 6% 7% 15% 21% a. Given the information in the table, the expected rate of return for stock A is 14.6 %. (Round to two decimal places.) The standard deviation of stock A is %. (Round to two decimal places.)You run a regression for a stock's return on a market index and find the following Excel output: Multiple R 0.35 R-Square 0.12 Adjusted R-Square 0.02 Standard Error 38.45 Observations 12 Coefficients Standard Error t-Stat p-Value Intercept 4.05 15.44 0.26 0.80 Market 1.32 0.97 1.36 0.10 The stock is ________ riskier than the typical stock