Develop an analysis of investments in excel

Assignment Help Other Subject
Reference no: EM132225653

DESCRIPTIVE STATISTICS, PROBABILITY, AND RISK ASSESSMENT -

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.

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. Let Excel do the work for you. Instead of typing the formula in a separate line, just enter it in the cell.

Written Report - Length requirements: 2-3 pages minimum (not including Cover and Reference pages).  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:- Assignment Files.rar

Reference no: EM132225653

Questions Cloud

What are the fitted regression coefficients : BSTT 401: Biostatistics Assignment - For the linear regression model, what are the fitted regression coefficients and their associated standard errors
Example of consumer behavior : Which of the following is an example of consumer behavior? A consumer’s decision making is influenced by their __________.
How the architecture of the nhin permits the given : Discussion should be around 100 words. Research health data stewardship and in your post show why it is important. Why does it matter in the discussion.
Discuss the impetus for health information exchange : HI300 Discuss the impetus for health information exchange (HIE) in the United States. Describe basic HIE organizational structures, architectures, and services.
Develop an analysis of 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
Create business opportunities for entrepreneurs to pursue : How can the term solving a problem create a business opportunities for entrepreneurs to pursue.
Discuss about the total reward package : Successful compensation programs are the result of well-defined and closely managed systems. It also sets the tone for an overall total reward package.
When is it necessary to provide training : When is it necessary to provide training? What factors need to be present to ensure a successful training?
Why do physicians still recite the hippocratic oath : What factors influence the ethical decision-making process? Give examples. Why do physicians still recite the Hippocratic Oath?

Reviews

len2225653

2/1/2019 1:01:55 AM

Excel Analysis - Using Excel, make an accurate and complete analysis of the three investment alternatives. Let Excel do the work for you. Instead of typing the formula in a separate line, just enter it in the cell. 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.

len2225653

2/1/2019 1:01:49 AM

Write clearly, simply, and logically. Use double-spaced, black Verdana or Times Roman font in 12 pt. type size. Have an introduction at the beginning to introduce the topics and use keywords as headings to organize the report. Avoid redundancy and general statements such as "All organizations exist to make a profit." Make every sentence count. Paraphrase the facts using your own words and ideas, employing quotes sparingly. Quotes, if absolutely necessary, should rarely exceed five words. Upload both your written report and Excel file to the SLP1 Dropbox.

Write a Review

Other Subject Questions & Answers

  Chronological age and the developmental age of child

Make sure you tell us the chronological age and the developmental age of this child (remember, this will be different ages since the child will most likely have special needs)

  Individual tax system

How may this influence how you would design an individual tax system?

  Creates a psychological situation for the consumer

find a retail pricing situation that you believe creates a psychological situation for the consumer, analyze what you found using one or more pricing concepts

  Examine the future of health care in the united states

Examine the future of health care in the United States. Look back to your own definition of the healthcare system. How would you define it

  Gases when the mixture reaches equilibrium

The combustion of SO2(g) has Keq=5.60x10^4 at 350 degrees Celcius. If 0.350bar of SO2(g) and 0.762bar of O2(g) are mixed initially, what are the partial pressures of each of the three gases when the mixture reaches equilibrium? Reaction: SO2(g) + ..

  Private donation to a human service organization

If you were considering making a private donation to a human service organization, what would you want to see to help you determine whether or not to give the donation to a particular organization?

  Develop effective safety management policy statements

Develop effective safety management policy statements, goals, and objectives. Evaluate the impact that the role of accountability has on performance management in in safety management programs.

  Describe an instance of plagiarism in the news media

Discuss the following question in your own 250 words. Explain why plagiarism is wrong and how Scripture condemns this practice.

  Establish the national youth mental health foundation

In 2005 the Australian Government allocated $54 million to establish the National Youth Mental Health Foundation (later to be named headspace).

  Have you thought about urinary incontinence

Have you thought about urinary incontinence? Urinary incontinence is hidden and by some thought to be normal aging. It is very costly.

  Preserved in the two-coupled cars after collision

A railroad freight car, mass 15 000 kg, is allowed to coast along a level track at a speed of 2.0 m/s. It collides and couples with a 50 000-kg loaded second car, initially at rest and with brakes released. What percentage of the initial kinetic ener..

  Assignment how did the professor in the introduction to

read herman melville biography httpxroads.virginia.eduhyperbbhmbio.htmlassignment explain what you learned about

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd