Description
Unformatted Attachment Preview
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Review
Review
Anonymous
Great! Studypool always delivers quality work.
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
MATH 302 APU Cost of Living Multiple Linear Regression Model Executive Summary
A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of O ...
MATH 302 APU Cost of Living Multiple Linear Regression Model Executive Summary
A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends.You work for Mercer Human Resources. The Mercer Human Resource Consulting websitelists prices of certain items in selected cities around the world. They also report an overall cost-of-living index for each city compared to the costs of hundreds of items in New York City (NYC). For example, London at 88.33 is 11.67% less expensive than NYC.More specifically, if you choose to explore the website further you will find a lot of fun and interesting data. You can explore the website more on your own after the course concludes.https://mobilityexchange.mercer.com/Insights/ cost-of-living-rankings#rankingsASSIGNMENT GUIDANCE:In the Excel document, you will find the 2018 data for 17 cities in the data set Cost of Living. Included are the 2018 cost of living index, cost of a 3-bedroom apartment (per month), price of monthly transportation pass, price of a mid-range bottle of wine, price of a loaf of bread (1 lb.), the price of a gallon of milk and price for a 12 oz. cup of black coffee. All prices are in U.S. dollars.You use this information to run a Multiple Linear Regression to predict Cost of living, along with calculating various descriptive statistics. This is given in the Excel output (that is, the MLR has already been calculated. Your task is to interpret the data).Based on this information, in which city should you open a second office in? You must justify your answer. If you want to recommend 2 or 3 different cities and rank them based on the data and your findings, this is fine as well.DELIVERABLE REQUIREMENTS:This should be ¾ to 1 page, no more than 1 single-spaced page in length, using 12-point Times New Roman font. You do not need to do any calculations, but you do need to pick a city to open a second location at and justify your answer based upon the provided results of the Multiple Linear Regression.The format of this assignment will be an Executive Summary. Think of this assignment as the first page of a much longer report, known as an Executive Summary, that essentially summarizes your findings briefly and at a high level. This needs to be written up neatly and professionally. This would be something you would present at a board meeting in a corporate environment. If you are unsure of an Executive Summary, this resource can help with an overview. What is an Executive Summary?THINGS TO CONSIDER:To help you make this decision here are some things to consider:Based on the MLR output, what variable(s) is/are significant?From the significant predictors, review the mean, median, min, max, Q1 and Q3 values?It might be a good idea to compare these values to what the New York value is for that variable. Remember New York is the baseline as that is where headquarters are located.Based on the descriptive statistics, for the significant predictors, what city has the best potential?What city or cities fall are below the median?What city or cities are in the upper 3rd quartile?
9 pages
Week 6 Balance Sheets And Income Statement
Complete parts A and B of this exercise. Examples can be found in Chapter 21 of your textbook. Be sure to
Week 6 Balance Sheets And Income Statement
Complete parts A and B of this exercise. Examples can be found in Chapter 21 of your textbook. Be sure to
FIN405 Strayer University Week 5 Expected Return of Equity Answers
Chapter 10
1.
This year, FCF, Inc., has earnings before interest and taxes of $10 million, depreciation expenses of $1 mi ...
FIN405 Strayer University Week 5 Expected Return of Equity Answers
Chapter 10
1.
This year, FCF, Inc., has earnings before interest and taxes of $10 million, depreciation expenses of $1 million, capital expenditures of $1.5 million, and has increased its net working capital by $500,000. If its tax rate is 35%, what is its free cash flow?
2.chas $500 million in debt and 20 million shares of equity outstanding. Its excess cash reserves are $15 million. They are expected to generate $200 million in free cash flows next year with a growth rate of 2% per year in perpetuity. River Enterprises’ cost of equity capital is 12%. After analyzing the company, you believe that the growth rate should be 3% instead of 2%. How much higher (in dollars) would the price per share of stock be if you are right?
Chapter 15
1.You are finalizing a bank loan for $200,000 for your small business and the closing fees payable to the bank are 2% of the loan. After paying the fees, what will be the net amount of funds from the loan available to your business?
9.Your firm successfully issued new debt last year, but the debt carries covenants. Specifically, you can only pay dividends out of earnings made after the debt issue and you must maintain a minimum quick (acid-test) ratio
((current assets?inventory)/current liabilities)
of 1:1. Your net income this year was $70 million. Your cash is $10 million, your receivables are $8 million, and your inventory is $5 million. You have current liabilities of $19 million. What is the maximum dividend you could pay this year and still comply with your covenants?
13. You own a bond with a face value of $10,000 and a conversion ratio of 450. What is the conversion price?
Chapter 16
5.
Hardmon Enterprises is currently an all-equity firm with an expected return of 12%. It is considering borrowing money to buy back some of its existing shares, thus increasing its leverage.
a. Suppose Hardmon borrows to the point that its debt-equity ratio is 0.50. With this amount of debt, the debt cost of capital is 6%. What will be the expected return of equity after this transaction?
b. Suppose instead Hardmon borrows to the point that its debt-equity ratio is 1.50. With this amount of debt, Hardmon’s debt will be much riskier. As a result, the debt cost of capital will be 8%. What will be the expected return of equity in this case?
c. A senior manager argues that it is in the best interest of the shareholders to choose the capital structure that leads to the highest expected return for the stock. How would you respond to this argument?
6 Suppose Microsoft has no debt and a WACC of 9.2%. The average debt-to-value ratio for the software industry is 5%. What would be its cost of equity if it took on the average amount of debt for its industry at a cost of debt of 6%?
7 Your firm is financed 100% with equity and has a cost of equity capital of 12%. You are considering your first debt issue, which would change your capital structure to 30% debt and 70% equity. If your cost of debt is 7%, what will be your new cost of equity?
examine statistical significance and meaningfulness based on sample statements
I have attached a copy of four different scenarios you have to pick two and follow the prompts below I have also attached ...
examine statistical significance and meaningfulness based on sample statements
I have attached a copy of four different scenarios you have to pick two and follow the prompts below I have also attached sources and references that need to be in the textCritically evaluate the two scenarios you selected based upon the following points:
Critically evaluate the sample size.
Critically evaluate the statements for meaningfulness.
Critically evaluate the statements for statistical significance.
Based on your evaluation, provide an explanation of the implications for social change.
Use proper APA format and citations, and referencing.http://rpsychologist.com/index.htmlhttp://www.amstat.org/asa/files/pdfs/P-ValueStatem...
7 pages
Project Management Plan
As the project management consultant retained by the company, to come up with a project management plan for this project. ...
Project Management Plan
As the project management consultant retained by the company, to come up with a project management plan for this project. The company intends to ...
4 pages
A Description Of What The Each Of The Variables Measure
The data set selected for further analysis is Afrobarometer. The two variables of interest are EDUC_COND (education catego ...
A Description Of What The Each Of The Variables Measure
The data set selected for further analysis is Afrobarometer. The two variables of interest are EDUC_COND (education category) and AGE_COND (age ...
Similar Content
Determining the probability
...
Purdue University Rate of Employment Among People Above 25 Years Paper
Do some research, from a reliable source, such as the U.S. Department of Labor (not a scholastic or school site or Wikiped...
reflect for math solution, writing about video, and responce to math solution
1.Watch the Project MATHEMATICS! video, Episode 9: Early History and at least one of the following Project MATHEMATICS! vi...
Find the inverse function of f.
Find the inverse function of f.f(x) = 12 − 9x3f −1(x) = ...
Week 4 Discussion 1
Answer the question in 100 word countPractice: Week 5 Discussion QuestionObjectives:5.1What are you doing to save for reti...
math106 Difference between denominator and numerator
What is the difference between denominator and numerator? Why do you need to know the difference between the two?...
Solution 277
No, as the distribution is skewed, we cannot apply the concepts of normal distribution Yes, a random sample of 100 lightbu...
Kroger Diversification Part 1
Kroger Company is one oldest the United States' retailing firms. The company was started by Bernard Kroger in Cincinnati, ...
Ks Nk 04 018 En.pdf
While the number of newly diagnosed AIDS cases continues to decrease in the EU, an upwards trend can be observed in the nu...
Related Tags
Book Guides
The Call of the Wild
by Jack London
50 Shades of Grey
by E. L. James
The Handmaids Tale
by Margaret Atwood
Pachinko
by Min Jin Lee
The Awakening
by Kate Chopin
A Farewell To Arms
by Ernest Hemingway
Becoming
by Michelle Obama
Heart of Darkness
by Joseph Conrad
All Quiet on the Western Front
by Erich Maria Remarque
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
MATH 302 APU Cost of Living Multiple Linear Regression Model Executive Summary
A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of O ...
MATH 302 APU Cost of Living Multiple Linear Regression Model Executive Summary
A marketing company based out of New York City is doing well and is looking to expand internationally. The CEO and VP of Operations decide to enlist the help of a consulting firm that you work for, to help collect data and analyze market trends.You work for Mercer Human Resources. The Mercer Human Resource Consulting websitelists prices of certain items in selected cities around the world. They also report an overall cost-of-living index for each city compared to the costs of hundreds of items in New York City (NYC). For example, London at 88.33 is 11.67% less expensive than NYC.More specifically, if you choose to explore the website further you will find a lot of fun and interesting data. You can explore the website more on your own after the course concludes.https://mobilityexchange.mercer.com/Insights/ cost-of-living-rankings#rankingsASSIGNMENT GUIDANCE:In the Excel document, you will find the 2018 data for 17 cities in the data set Cost of Living. Included are the 2018 cost of living index, cost of a 3-bedroom apartment (per month), price of monthly transportation pass, price of a mid-range bottle of wine, price of a loaf of bread (1 lb.), the price of a gallon of milk and price for a 12 oz. cup of black coffee. All prices are in U.S. dollars.You use this information to run a Multiple Linear Regression to predict Cost of living, along with calculating various descriptive statistics. This is given in the Excel output (that is, the MLR has already been calculated. Your task is to interpret the data).Based on this information, in which city should you open a second office in? You must justify your answer. If you want to recommend 2 or 3 different cities and rank them based on the data and your findings, this is fine as well.DELIVERABLE REQUIREMENTS:This should be ¾ to 1 page, no more than 1 single-spaced page in length, using 12-point Times New Roman font. You do not need to do any calculations, but you do need to pick a city to open a second location at and justify your answer based upon the provided results of the Multiple Linear Regression.The format of this assignment will be an Executive Summary. Think of this assignment as the first page of a much longer report, known as an Executive Summary, that essentially summarizes your findings briefly and at a high level. This needs to be written up neatly and professionally. This would be something you would present at a board meeting in a corporate environment. If you are unsure of an Executive Summary, this resource can help with an overview. What is an Executive Summary?THINGS TO CONSIDER:To help you make this decision here are some things to consider:Based on the MLR output, what variable(s) is/are significant?From the significant predictors, review the mean, median, min, max, Q1 and Q3 values?It might be a good idea to compare these values to what the New York value is for that variable. Remember New York is the baseline as that is where headquarters are located.Based on the descriptive statistics, for the significant predictors, what city has the best potential?What city or cities fall are below the median?What city or cities are in the upper 3rd quartile?
9 pages
Week 6 Balance Sheets And Income Statement
Complete parts A and B of this exercise. Examples can be found in Chapter 21 of your textbook. Be sure to
Week 6 Balance Sheets And Income Statement
Complete parts A and B of this exercise. Examples can be found in Chapter 21 of your textbook. Be sure to
FIN405 Strayer University Week 5 Expected Return of Equity Answers
Chapter 10
1.
This year, FCF, Inc., has earnings before interest and taxes of $10 million, depreciation expenses of $1 mi ...
FIN405 Strayer University Week 5 Expected Return of Equity Answers
Chapter 10
1.
This year, FCF, Inc., has earnings before interest and taxes of $10 million, depreciation expenses of $1 million, capital expenditures of $1.5 million, and has increased its net working capital by $500,000. If its tax rate is 35%, what is its free cash flow?
2.chas $500 million in debt and 20 million shares of equity outstanding. Its excess cash reserves are $15 million. They are expected to generate $200 million in free cash flows next year with a growth rate of 2% per year in perpetuity. River Enterprises’ cost of equity capital is 12%. After analyzing the company, you believe that the growth rate should be 3% instead of 2%. How much higher (in dollars) would the price per share of stock be if you are right?
Chapter 15
1.You are finalizing a bank loan for $200,000 for your small business and the closing fees payable to the bank are 2% of the loan. After paying the fees, what will be the net amount of funds from the loan available to your business?
9.Your firm successfully issued new debt last year, but the debt carries covenants. Specifically, you can only pay dividends out of earnings made after the debt issue and you must maintain a minimum quick (acid-test) ratio
((current assets?inventory)/current liabilities)
of 1:1. Your net income this year was $70 million. Your cash is $10 million, your receivables are $8 million, and your inventory is $5 million. You have current liabilities of $19 million. What is the maximum dividend you could pay this year and still comply with your covenants?
13. You own a bond with a face value of $10,000 and a conversion ratio of 450. What is the conversion price?
Chapter 16
5.
Hardmon Enterprises is currently an all-equity firm with an expected return of 12%. It is considering borrowing money to buy back some of its existing shares, thus increasing its leverage.
a. Suppose Hardmon borrows to the point that its debt-equity ratio is 0.50. With this amount of debt, the debt cost of capital is 6%. What will be the expected return of equity after this transaction?
b. Suppose instead Hardmon borrows to the point that its debt-equity ratio is 1.50. With this amount of debt, Hardmon’s debt will be much riskier. As a result, the debt cost of capital will be 8%. What will be the expected return of equity in this case?
c. A senior manager argues that it is in the best interest of the shareholders to choose the capital structure that leads to the highest expected return for the stock. How would you respond to this argument?
6 Suppose Microsoft has no debt and a WACC of 9.2%. The average debt-to-value ratio for the software industry is 5%. What would be its cost of equity if it took on the average amount of debt for its industry at a cost of debt of 6%?
7 Your firm is financed 100% with equity and has a cost of equity capital of 12%. You are considering your first debt issue, which would change your capital structure to 30% debt and 70% equity. If your cost of debt is 7%, what will be your new cost of equity?
examine statistical significance and meaningfulness based on sample statements
I have attached a copy of four different scenarios you have to pick two and follow the prompts below I have also attached ...
examine statistical significance and meaningfulness based on sample statements
I have attached a copy of four different scenarios you have to pick two and follow the prompts below I have also attached sources and references that need to be in the textCritically evaluate the two scenarios you selected based upon the following points:
Critically evaluate the sample size.
Critically evaluate the statements for meaningfulness.
Critically evaluate the statements for statistical significance.
Based on your evaluation, provide an explanation of the implications for social change.
Use proper APA format and citations, and referencing.http://rpsychologist.com/index.htmlhttp://www.amstat.org/asa/files/pdfs/P-ValueStatem...
7 pages
Project Management Plan
As the project management consultant retained by the company, to come up with a project management plan for this project. ...
Project Management Plan
As the project management consultant retained by the company, to come up with a project management plan for this project. The company intends to ...
4 pages
A Description Of What The Each Of The Variables Measure
The data set selected for further analysis is Afrobarometer. The two variables of interest are EDUC_COND (education catego ...
A Description Of What The Each Of The Variables Measure
The data set selected for further analysis is Afrobarometer. The two variables of interest are EDUC_COND (education category) and AGE_COND (age ...
Earn money selling
your Study Documents