Choose two publicly traded stocks and fill in their tickers to cells B3 and B4 of FrontSheet. For your chosen stocks, work out the following tasks. 1. On sheet Q1, compute the weekly returns of the chosen stocks over the last 150 weeks (prior to 22nd April 2024). 2. For each stock, plot a histogram of its returns. 3. Estimate the means, variances and the correlation of the two stocks. (If the computed correlation is 1 or -1, please choose a different set of stocks for all questions.) 4. Calculate the value at risk of the returns at confidence level 95% of each stock. 5. Plot the efficient frontier of a portfolio consisting of the two chosen stocks. 6. Suppose that the weekly interest rate is 0.1%. Calculate the Sharpe ratio of this port- folio. 7. How does the Sharpe ratio of such portfolio change if the weekly interest rate decreases? Justify your answer by numerical evidences.
Q: A project costs $360,000 initially and will generate project cash flows of $50,000 every year for 8…
A: Step 1:We have to calculate the net present value of the project.The formula for net present…
Q: Explain how the use of secondary source of data (news articles) can be used as supporting infomation…
A: The hospitality industry, a significant driver of the Caribbean's economy, has been heavily impacted…
Q: You want to keep Ensley as your employee because you don’t want another job opening to fill, but now…
A: As a new supervisor of an assembler-shipper department, you're facing a double challenge.…
Q: In detail speak to digital transformation at Starbucks. To what extent was it successful? What else…
A: Approach to solving the question: Detailed explanation:Digital transformation at Starbucks has been…
Q: Explain the embargo trade barrier, with an example. Explain why Develping a Global Vision through…
A: The Trade Barrier of Embargo:In the realm of international affairs, an embargo is a potent…
Q: What should be the criteria of fairness of the message in comparative advertisements?
A: About the comparative advertisements concept -Comparative advertisements sell dispatches that…
Q: 2 Sort Lists Create, edit, and format charts Utilise Financial Functions (PMT) and (FV) Question 1…
A: The objective of the question is to use Excel to analyze the sales data of Cape Produce, a fruit and…
Q: Write five toxic business behavior of producers or consumers in the Philippines. Propose a solution…
A: About Business Behavior -In the context of commerce, business behavior describes the choices,…
Q: Find the approximate z-value to a cumulative probability of 0.99 using interpolation. 4 decimal…
A: Here's how to find the approximate z-value using interpolation: Concepts:Standard Normal…
Q: How might the cost structure of the medical supply chain change? What are the possible implications…
A: The cost structure of the medical supply chain might change due to several factors. These include…
Q: How would the marketing dashboard differ between a business-to-business company marketing computer…
A: About the marketing dashboard concept -A marketing dashboard is a visual tool used to track and…
Q: C. Would you perceive that each consumer identified in Chapter 3 would solicit from you a different…
A: In chapter 3, various consumer groups are highlighted each with a particular set of constraints and…
Q: How would you determine the best product position for the following? a. A brand of tablet computer…
A: Disclaimer: Since you have posted a question with multiple sub-parts, we will solve first three…
Q: Describe and critically evaluate the different types of measures that should be used to review and…
A: When assessing and improving digital marketing efforts, it is essential to take into account a range…
Q: Designing an ad for a (choose one): car, laptop, health clinic Select one product and what…
A: Note: The answer has been framed in a generalized manner.Advertising is an effective combination of…
Q: Describe the type of media that might be most suitable for promoting: (a) tomato soup, (b) greeting…
A: About Promotion Concept -Promotion refers to the conditioning or sweats aimed at raising…
Q: Describe the role of message source, appeal, and structure on attitudes?
A: Communication is the key element which is essential in changing dividing people' attitudes and…
Q: The _______ is an online marketplace that lists smaller, younger companies and often tech companies.
A: About Online Market Place -The online marketplace is a concept that is seen as a relevant kind of…
Q: 11. What large online Retailer has set the bar in online distribution? 12. What are the 2 reasons…
A: About Discounters -Discounters are seen as relevant kinds of retailers who sell various kinds of…
Q: Question: What were the statistical analysis conducted in the Balancing of Country Based…
A: About Statistical analysis concept -Statistical analysis refers to the process of collecting,…
Q: Answer how could Marriott better differentiate its 8 luxury brands? How many brands does Marriott…
A: In the hospitality domain, differentiating brands is a key, and it is especially important for those…
Q: Of the five promotion tools we have covered - Advertising, Personal Selling, Sales Promotion, Public…
A: why Direct/Digital Marketing is the optimal choice for promoting Adobe's Communication Suite 3…
Q: why choose a standardized "core" product positionning rather than a modular product positionning for…
A: This is a paper discussing the advantages of standardized "core" product positioning over modular…
Q: Question 10 Explain the meaning of Segmentation in space market? and why this market is highly…
A: About the space market concept -The" space market" refers to the profitable conditioning and deals…
Q: 0,5 = 9=10K*LK 15 and L 25, whot is CAC ? equal CAC?
A: CAC stands for Customer Acquisition Cost. It is a metric utilized by organizations to decide the…
Q: 400 PART ONE Ten Steps to Advancing College Reading Skills 4. A. Requirements should be ended for…
A: For the given prompt.
Q: . Do you think the changes that Japanese companies are making will help them become more competitive…
A: About Market -The relationship between the relevant kinds of buyers as well as sellers within an…
Q: 1a. In what areas of business are there consumer protection statutes? 1b. Explain the regulation…
A: Since you have posted multiple questions, we will solve the 1st three questions for you as per our…
Q: All of the following are strategies a marketer would use to lead consumers into making the final…
A: The objective of the question is to identify which among the given options is not typically used as…
Q: Please assist in writing an executive summary for Engie SA. A company in South Africa. Clearly state…
A: Executive Summary: Engie SA Marketing PlanEngie SA, a prominent player in South Africa's energy…
Q: In detail discuss, if "the language of international business is English," why is it important to…
A: Even if English has taken the lead as the language of choice for worldwide commerce, learning other…
Q: Product For OREO BISCUITS product in Pakistan discuss it with respect to following? Product type:…
A: A product specifies the goods, a service, or an object that is offered by the company or business in…
Q: 1Outline how the marketing strategy process applies to a new business in relation to developing,…
A: Disclaimer: "As per Bartleby guidelines, experts are not allowed to cite references".About Marketing…
Q: What will be the marketing plan of a soft drink company in in current situation caused by Covid-19?
A: About the marketing plan concept -A marketing plan refers to a detailed report outlining a company's…
Q: There are currently 60 perfectly competitive firms producing output q. Their cost function is C = 10…
A: The correct answer is Variable Profit equals a) $48. The Total cost function of each firm in the…
Q: in litarature review, discuss the role of maketing in business in details.
A: About marketing Concept -Marketing refers to the process of relating, anticipating, and satisfying…
Q: Jenna Baker, CEO of Baker Mfg Inc., wishes to compare her company's inventory turnover to those of…
A: The inventory turnover ratio measures how efficiently a company manages its inventory. It is…
Q: Explain the concept of Lifetime Customer Value. Includes the ideas of profitability and measuring…
A: About Customer -The core of the customer concept is comprehending and satisfying customers' needs…
Q: Which of the sales promotion tools described in the chapter would be best for stimulating sales of…
A: Sales promotion encompasses any purposeful methods and solutions employed for the sake of prompting…
Q: AmtrakAmtrak is taking the gloves off in advertisements and belittling its major competition, which…
A: About the communication process concept -The communication process refers to the way or stages…
Q: It is often difficult to estimate the expected future dividend growth rate for use in estimating the…
A: The objective of the question is to calculate the estimated growth rate of Johnson using the…
Q: List and discuss the three frequently used tools that a Strategist can leverage for an…
A: Media mix modeling (MMM) is a sophisticated approach that strategists use to analyze the…
Q: 4. Using the iPhone as an example, describe the following: - The augmented product -…
A: A product specifies the goods, a service, or an object that is offered by the company or business in…
Q: Explain how the marketing environment impacts on various marketing decisions
A: A company's capacity to produce, communicate, distribute, and exchange offers with its target market…
Q: Develop the points in the following paragraphs below The fourth research question sought to find out…
A: The study's fourth and fifth research questions aimed to investigate various aspects of the…
Q: Cite some examples and provide actual illustrations of companies or brands that use the following…
A: About Consumer Behavior -Consumer behaviour is a concept that plays a vital role in studying how…
Q: Discuss traditional sources of advertising and public relations in comparison to e-based strategies.…
A: Traditional vs. E-based Advertising and Public Relations: A Shifting Landscape The emergence of the…
Q: Use working in Gap clothing in ottawa Canada Think about a workplace in which you currently work…
A: Part 2: Explanation:In the employment standards document for Gap Clothing in Ottawa, Canada, several…
Q: Discuss the importance of consumer behavior in marketing decisions and strategies.
A: Consumer behavior refers to the decisions and actions that individuals or households do while…
Q: 73. The advantages of audience selectivity, no ad competition, and personalization apply to which…
A: "Since you have posted multiple questions, we will provide the solution only to the first question…
Step by step
Solved in 2 steps
- You are considering a 10-year investment project. At present, the expected cash flow each year is 10,000. Suppose, however, that each years cash flow is normally distributed with mean equal to last years actual cash flow and standard deviation 1000. For example, suppose that the actual cash flow in year 1 is 12,000. Then year 2 cash flow is normal with mean 12,000 and standard deviation 1000. Also, at the end of year 1, your best guess is that each later years expected cash flow will be 12,000. a. Estimate the mean and standard deviation of the NPV of this project. Assume that cash flows are discounted at a rate of 10% per year. b. Now assume that the project has an abandonment option. At the end of each year you can abandon the project for the value given in the file P11_60.xlsx. For example, suppose that year 1 cash flow is 4000. Then at the end of year 1, you expect cash flow for each remaining year to be 4000. This has an NPV of less than 62,000, so you should abandon the project and collect 62,000 at the end of year 1. Estimate the mean and standard deviation of the project with the abandonment option. How much would you pay for the abandonment option? (Hint: You can abandon a project at most once. So in year 5, for example, you abandon only if the sum of future expected NPVs is less than the year 5 abandonment value and the project has not yet been abandoned. Also, once you abandon the project, the actual cash flows for future years are zero. So in this case the future cash flows after abandonment should be zero in your model.)When you use a RISKSIMTABLE function for a decision variable, such as the order quantity in the Walton model, explain how this provides a fair comparison across the different values tested.Play Things is developing a new Lady Gaga doll. The company has made the following assumptions: The doll will sell for a random number of years from 1 to 10. Each of these 10 possibilities is equally likely. At the beginning of year 1, the potential market for the doll is two million. The potential market grows by an average of 4% per year. The company is 95% sure that the growth in the potential market during any year will be between 2.5% and 5.5%. It uses a normal distribution to model this. The company believes its share of the potential market during year 1 will be at worst 30%, most likely 50%, and at best 60%. It uses a triangular distribution to model this. The variable cost of producing a doll during year 1 has a triangular distribution with parameters 15, 17, and 20. The current selling price is 45. Each year, the variable cost of producing the doll will increase by an amount that is triangularly distributed with parameters 2.5%, 3%, and 3.5%. You can assume that once this change is generated, it will be the same for each year. You can also assume that the company will change its selling price by the same percentage each year. The fixed cost of developing the doll (which is incurred right away, at time 0) has a triangular distribution with parameters 5 million, 7.5 million, and 12 million. Right now there is one competitor in the market. During each year that begins with four or fewer competitors, there is a 25% chance that a new competitor will enter the market. Year t sales (for t 1) are determined as follows. Suppose that at the end of year t 1, n competitors are present (including Play Things). Then during year t, a fraction 0.9 0.1n of the company's loyal customers (last year's purchasers) will buy a doll from Play Things this year, and a fraction 0.2 0.04n of customers currently in the market ho did not purchase a doll last year will purchase a doll from Play Things this year. Adding these two provides the mean sales for this year. Then the actual sales this year is normally distributed with this mean and standard deviation equal to 7.5% of the mean. a. Use @RISK to estimate the expected NPV of this project. b. Use the percentiles in @ RISKs output to find an interval such that you are 95% certain that the companys actual NPV will be within this interval.
- A company manufacturers a product in the United States and sells it in England. The unit cost of manufacturing is 50. The current exchange rate (dollars per pound) is 1.221. The demand function, which indicates how many units the company can sell in England as a function of price (in pounds) is of the power type, with constant 27556759 and exponent 2.4. a. Develop a model for the companys profit (in dollars) as a function of the price it charges (in pounds). Then use a data table to find the profit-maximizing price to the nearest pound. b. If the exchange rate varies from its current value, does the profit-maximizing price increase or decrease? Does the maximum profit increase or decrease?Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.Referring to Example 11.1, if the average bid for each competitor stays the same, but their bids exhibit less variability, does Millers optimal bid increase or decrease? To study this question, assume that each competitors bid, expressed as a multiple of Millers cost to complete the project, follows each of the following distributions. a. Triangular with parameters 1.0, 1.3, and 2.4 b. Triangular with parameters 1.2, 1.3, and 2.2 c. Use @RISKs Define Distributions window to check that the distributions in parts a and b have the same mean as the original triangular distribution in the example, but smaller standard deviations. What is the common mean? Why is it not the same as the most likely value, 1.3?
- An automobile manufacturer is considering whether to introduce a new model called the Racer. The profitability of the Racer depends on the following factors: The fixed cost of developing the Racer is triangularly distributed with parameters 3, 4, and 5, all in billions. Year 1 sales are normally distributed with mean 200,000 and standard deviation 50,000. Year 2 sales are normally distributed with mean equal to actual year 1 sales and standard deviation 50,000. Year 3 sales are normally distributed with mean equal to actual year 2 sales and standard deviation 50,000. The selling price in year 1 is 25,000. The year 2 selling price will be 1.05[year 1 price + 50 (% diff1)] where % diff1 is the number of percentage points by which actual year 1 sales differ from expected year 1 sales. The 1.05 factor accounts for inflation. For example, if the year 1 sales figure is 180,000, which is 10 percentage points below the expected year 1 sales, then the year 2 price will be 1.05[25,000 + 50( 10)] = 25,725. Similarly, the year 3 price will be 1.05[year 2 price + 50(% diff2)] where % diff2 is the percentage by which actual year 2 sales differ from expected year 2 sales. The variable cost in year 1 is triangularly distributed with parameters 10,000, 12,000, and 15,000, and it is assumed to increase by 5% each year. Your goal is to estimate the NPV of the new car during its first three years. Assume that the company is able to produce exactly as many cars as it can sell. Also, assume that cash flows are discounted at 10%. Simulate 1000 trials to estimate the mean and standard deviation of the NPV for the first three years of sales. Also, determine an interval such that you are 95% certain that the NPV of the Racer during its first three years of operation will be within this interval.In Example 11.1, the possible profits vary from negative to positive for each of the 10 possible bids examined. a. For each of these, use @RISKs RISKTARGET function to find the probability that Millers profit is positive. Do you believe these results should have any bearing on Millers choice of bid? b. Use @RISKs RISKPERCENTILE function to find the 10th percentile for each of these bids. Can you explain why the percentiles have the values you obtain?Sometimes curvature in a scatterplot can be fit adequately (especially to the naked eye) by several trend lines. We discussed the exponential trend line, and the power trend line is discussed in the previous problem. Still another fairly simple trend line is the parabola, a polynomial of order 2 (also called a quadratic). For the demand-price data in the file P13_10.xlsx, fit all three of these types of trend lines to the data, and calculate the MAPE for each. Which provides the best fit? (Hint: Note that a polynomial of order 2 is still another of Excels Trend line options.)
- What-If Analysis As the management accountant for the Tyson Company you have been askedto construct a financial planning model for collection of accounts receivable and then to performa what-if analysis in terms of the assumption regarding estimated uncollectible accounts. You areprovided with the following information:Collection Pattern for Credit Sales: 65% of the company’s credit sales are collected in the monthof sale, 30% in the month following the month of sale, and 5% are uncollectible.Credit Sales: January 2019, $100,000; February 2019, $120,000; March 2019, $110,000.Required1. Generate a spreadsheet model regarding estimated bad debts expense under the following assumptionsregarding the rate of uncollectible accounts: 1%, 3%, 5% (base case), and 8%. Prepare an estimate of baddebts expense for each of three months, January through March, and for the quarter as a whole.2. What is the value to Tyson Company of creating a model and then performing the what-if analysis?Under Fundamental analysis the intrinsic value of the stock is meassured by analysing economic and financial factors. This method analysis the stock's real and fair market value. According to this analysis if the market price of the stock is lower than its fair market value then the stock is deemed to be underpriced, which means the stock price is going to rise in future. On the other hand if the fair market value of the stock is lower than its market price then it is assumed that the future prices of stock are going to decline. BASED ON THE STATEMENT ABOVE PLEASE DRAW THE GRAPH AND EXPLAIN IT ON U.S. SITUATIONCompany C sells semiconductors that are used in handheld consumer electronics. The company has been extremely successful recording an increase in earnings each of the past four quarters. At the end of the current quarter, Larry Gomez, the company’s accountant, calculated the ending inventory for the semiconductors and was surprised to find that the quantity of the Z100 model had not changed during the quarter. Larry confirmed his calculation with the inventory control manager, who indicated that sales of the Z100 had stopped when the Z200 semiconductor was released early in the quarter. Larry found out that the Z200 semiconductor has the same applications as the Z100, but has more computing power and a lower cost than the Z100. Larry notified Sheena Snyder , the chief financial officer, about the semiconductors and recommended that the company apply the lower-of-cost-or-market method to the Z100 semiconductors in inventory. Later that day, Sheena called Larry telling him not to apply…