Reference no: EM131406051
Assignment
Scenario: You work for a private investment company that currently has numerous business investments in real estate development, restaurant franchises, and retail chains. Following an exhaustive search for new investment opportunities, you have found three possible alternatives, each of which will pay off in exactly 10 years from the date of initial investment. Because you only have enough money to invest in one of the three options, you recognize that you will need to complete a quantitative comparison of the three alternatives:
Option A: Real estate development.
Option B: Investment in the retail franchise "Just Hats," a boutique that sells hats for men and women.
Option C: Investment in "Cupcakes and so forth," a franchise that sells a wide variety of cupcakes and a variety other desserts.
Download the raw data for the three investments in this Excel document: Raw data
Assignment
Develop an analysis of these three investments in Excel. Use expected value to determine which of the three alternatives you should choose.
Write a report to your private investment company, explaining your Excel analysis, giving your recommendation, and justifying your decision.
Excel Analysis
• Using Excel, make an accurate and complete analysis of the three investment alternatives.
Written Report
• Length requirements: 2-3 pages minimum (not including Cover and Reference pages). NOTE: You must submit 2-3 pages of written discussion and analysis. This means that you should avoid use of tables and charts as "space fillers."
• Provide a brief introduction to/background of the problem.
• Discuss the steps you used in completion of your Excel analysis.
• Based on your Excel analysis, give your recommendation as to which of the three investment alternatives should be pursued.
Attachment:- Module SLP Assignment.xlsx
|
Determining the organizational resources
: Think of your organization and it's resources. Do the managers utilize organizational resources effectively? Which resources contribute most to the organization's performance? Cite sources and references.
|
|
Find the cycle thermal efficiency
: A power plant operates on a regenerative vapor power cycle with one open feedwater heater. Steam enters the first turbine stage at 12 MPa, 560C and expands to 1 MPa, where some of the steam is extracted and diverted to the open feedwater heater op..
|
|
Normalized databases and denormalized databases
: What are the key issues in deciding between using perfectly normalized databases and denormalized databases? Describe three situations that can be good candidates for denormalization.
|
|
Determining the type of data storage
: What are the two most important factors in determining the type of data storage format that should be adopted for a system? Why are these factors so important?
|
|
Develop an analysis of these three investments in excel
: Develop an analysis of these three investments in Excel. Use expected value to determine which of the three alternatives you should choose.
|
|
Navigating an uncertain environment
: Based on the case study number 27 delta airlines 2012 12. Navigating an uncertain environment. You have been hired as a strategic management consultant by Delta Airlines. What specific recommendations would you make to the senior management team..
|
|
Find the rate of change of height with respect to the radius
: Continuing on. say the radius increases at a rate of 3 cm/sec at the moment that r = 5 and h = 4. What is the rate of change of height with respect to time then
|
|
Which phrase most clearly describes the beliefs of neoplaton
: Clotilda, the Queen of the Franks, was typical of many aristocratic women for which of the following reasons?Which of the following statements is not true of Theodoric's rule?Why did Bishop Gregory of Tours support the Frankish king Clovis?
|
|
Terms of software development-education
: What does the future look like for HCIT in terms of software development, education, research, and practices? What challenges could arise?
|