Fundamentals of Corporate Finance (4th Edition) (Berk DeMarzo & Harford The Corporate Finance Series)
4th Edition
ISBN: 9780134476124
Author: Berk
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Textbook Question
Chapter 11, Problem 2DC
Convert these prices to monthly returns as the percentage change in the monthly prices. (Hint: Create a separate worksheet within the Excel file.) Note that to compute a return for each month, you need a beginning and ending price, so you will not be able to compute the return for the first month.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
I am having trouble computing the revenue for the income statement.Use the following revenue and cost information for the income statement. Note that the revenue you use will depend on the pricing level options you chose in Milestone Two. Also, assume that after accounting for weekends and other holidays, there were 20 business days in the first month of operation. For example, if you chose a sales price of $20 per collar, the actual number of collars sold in the month was 33 per day or 33 x 20 = 660 per month.
Using the following Quarterly Sales Demand Data; read and answer the questions listed below.
Quarter #
Actual Sales (dollars)
1
1416
2
1398
3
1274
4
1167
Calculate the average quarterly Seasonal Index value? (rounded to 2 decimal places).
Calculate the total sales if there is a 35% total annual sales decrease next year? (rounded to the nearest whole number)
Calculate the Seasonal Index value for Quarter 3? (rounded to 2 decimal places)
please help me provide the ( forecasted sales, in units, selling price per unit, and total sales for the 2nd QUARTER
Chapter 11 Solutions
Fundamentals of Corporate Finance (4th Edition) (Berk DeMarzo & Harford The Corporate Finance Series)
Ch. 11 - Prob. 1CCCh. 11 - Why do investors demand a higher return when...Ch. 11 - For what purpose do we use the average and...Ch. 11 - How does the standard deviation of historical...Ch. 11 - What is the relation between risk and return for...Ch. 11 - Prob. 6CCCh. 11 - Prob. 7CCCh. 11 - Prob. 8CCCh. 11 - Prob. 9CCCh. 11 - Does systematic or unsystematic risk require a...
Ch. 11 - What does the historical relation between...Ch. 11 - What are the components of a stock's realized...Ch. 11 - What is the intuition behind using the average...Ch. 11 - Prob. 4CTCh. 11 - How does the relationship between the average...Ch. 11 - Consider two local banks. Bank A has 100 loans...Ch. 11 - What is meant by diversification and how does it...Ch. 11 - Which of the following risks of a stock are likely...Ch. 11 - Prob. 9CTCh. 11 - Prob. 10CTCh. 11 - If you randomly select 10 stocks for a portfolio...Ch. 11 - Why doesn't the risk premium of a stock depend on...Ch. 11 - Prob. 13CTCh. 11 - DATA CASE Today is April 30, 2016, and you have...Ch. 11 - Convert these prices to monthly returns as the...Ch. 11 - Prob. 3DCCh. 11 - Prob. 4DCCh. 11 - Prob. 5DCCh. 11 - What do you notice about the average of the...Ch. 11 - Prob. 1PCh. 11 - Prob. 2PCh. 11 - Prob. 3PCh. 11 - Your portfolio consists of 100 shares of CSH and...Ch. 11 - You have just purchased a share of stock for $20....Ch. 11 - You expect KStreet Co's trade at $100 per share...Ch. 11 - The following table contains prices and dividends...Ch. 11 - Prob. 8PCh. 11 - Prob. 9PCh. 11 - Use the data in SBUX_GOOG.xlsx on MFL to answer...Ch. 11 - Download the spreadsheet from the book's Web the...Ch. 11 - Prob. 12PCh. 11 - Prob. 13PCh. 11 - Prob. 14PCh. 11 - Prob. 15PCh. 11 - Consider the following five monthly returns: a....Ch. 11 - Explain the difference between the arithmetic...Ch. 11 - Prob. 18PCh. 11 - Prob. 19PCh. 11 - Prob. 20PCh. 11 - Prob. 21PCh. 11 - Prob. 22PCh. 11 - Prob. 23PCh. 11 - You are a risk-averse investor who is considering...Ch. 11 - Consider the following 6 months of returns for 2...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- For the Hawkins Company, the monthly percentages of all shipments received on time over the past 12 months are 80, 82, 84, 83, 83, 84, 85, 84, 82, 83, 84, and 83. Construct a time series plot. What type of pattern exists in the data? Compare a three-month moving average forecast with an exponential smoothing forecast for α = 0.2. Which provides the better forecasts using MSE as the measure of model accuracy? What is the forecast for next month?arrow_forwardThe quarterly sales data (number of copies sold) for a college textbook over the past three years are as follows: a. Construct a time series plot. What type of pattern exists in the data? b. Use a regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = l if quarter l, 0 otherwise; Qtr2 = l if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Based on the model you developed in part (b), compute the quarterly forecasts for next year. d. Let t = 1 to refer to the observation in quarter 1 of year 1; t = 2 to refer to the observation in quarter 2 of year 1; ; and t = 12 to refer to the observation in quarter 4 of year 3. Using the dummy variables defined in part (b) and t, develop an equation to account for seasonal effects and any linear trend in the time series. e. Based upon the seasonal effects in the data and linear trend, compute the quarterly forecasts for next year. f. Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.arrow_forwardConsider the following time series data: Construct a time series plot. What type of pattern exists in the data? Use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2. 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Compute the quarterly forecasts for next year based on the model you developed in part (b). Use a multiple regression model to develop an equation to account for trend and seasonal effects in the data. Use the dummy variables you developed in part (b) to capture seasonal effects and create a variable t such that t = 1 for quarter 1 in year 1, t = 2 for quarter 2 in year 1, … t = 12 for quarter 4 in year 3. Compute the quarterly forecasts for next year based on the model you developed in part (d). Is the model you developed in part (b) or the model you developed in part (d) more effective? Justify your answer.arrow_forward
- Consider the following time series: a. Construct a time series plot. What type of pattern exists in the data? Is there an indication of a seasonal pattern? b. Use a multiple linear regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. c. Compute the quarterly forecasts for next year.arrow_forwardSuppose a company finds that shipping cost is 3,560 each month plus 6.70 per package shipped. What is the cost formula for monthly shipping cost? Identify the independent variable, the dependent variable, the fixed cost per month, and the variable rate.arrow_forwardQWE Inn has recorded the following number of rooms sold for the first quarter of the year: January 2100 February 2500 March 2550 Assume that you found an average monthly geometric rate of change in rooms sales from the month of January to March be equal to 5%. What would be your forecast of rooms sales for the month of April if sales are expected to continue increasing at the same rate?arrow_forward
- please help me provide the ( forecasted sales in units, selling proce per unit, and total sales) FOR THE 3rd quarterarrow_forwarda. Assume that the cost of goods sold is 60% and that the monthly discount rate is 1%. Looking at the values in the exhibit above, you note that the average monthly revenue for a subscribed customer rises as the company sends more emails. In addition, the average monthly revenue for an unsubscribed customer also rises as the company sends more emails. What could explain both of these patterns? b. Calculate the 6-month LTV for each of the four tested email frequencies. Please show the spreadsheet with your calculations and be clear about any assumptions you are making. c. Based on this test, how many emails-per-week should the company be sending to its customers? This email frequency should apply to all customers; the company doesn't want to implement a different email frequency for different kinds of peoplearrow_forwardusing the projected monthly income figure calculated above, how many unitswould the company need to sell to meet the initial monthly income figure?arrow_forward
- When prices are rising, would you choose a FIFO or weighted average cost flow assumption? Explain, using an example to support your answer. Would your choice be the same if prices were falling? If employees get a year-end bonus accourding to amount of net income earned during the end of year. Could you please give me an example?arrow_forwardThe following time series shows the sales of a particular product over the past 12 months. Month Sales 1 105 2 135 3 120 4 105 5 90 6 120 7 145 8 140 9 100 10 80 11 100 12 110 Use a=0.3 to compute the exponential smoothing values for the time series.arrow_forwardThe Black is trying to plan for the next year. Their sales forecast for the next year is $3,500,000. Using the following current income statement, prepare the proforma income statement for the next year. Pay attention to the separation of expenses into fixed and variable components. can you explain in more detailedarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningEssentials Of Business AnalyticsStatisticsISBN:9781285187273Author:Camm, Jeff.Publisher:Cengage Learning,Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningPrinciples of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
Essentials Of Business Analytics
Statistics
ISBN:9781285187273
Author:Camm, Jeff.
Publisher:Cengage Learning,
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781305635937
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Fundamentals of Financial Management, Concise Edi...
Finance
ISBN:9781285065137
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Responsibility Accounting| Responsibility Centers and Segments| US CMA Part 1| US CMA course; Master Budget and Responsibility Accounting-Intro to Managerial Accounting- Su. 2013-Prof. Gershberg; Author: Mera Skill; Rutgers Accounting Web;https://www.youtube.com/watch?v=SYQ4u1BP24g;License: Standard YouTube License, CC-BY