I need someone to valuate these 3 parts of the firm and determine which parts she should sell. I need a completed excel sheet and 4 page paper. please read case instructions and excel exhibits.?
Due 4/8/2016 at 10am
Cases are complex, challenging, and realistic. They are the closest you will get to being in an
actual business decision-making role until you are employed in one. They are an excuse for
exploring problems and asking questions. The most important aspects of a case may be hidden.
Assume nothing, verify everything, question the answers and answer the questions.
Effective decision-making and communication are the cornerstones of a successful career in
business. In finance, effective decision making and communication are demonstrated by: the
accurate assessment of a business scenario; the identification of the relevant information and
necessary decision points; the selection of the appropriate tools with which to guide decisionmaking; the utilization of those tools effectively; the evaluation of alternative courses of action;
and the recommendation of an actionable decision that is clearly and concisely supported by the
data and analytics.
Your write-up should be composed and submitted in Excel and should include:
1. A concise 1-paragraph executive summary that identifies the problem, its importance,
alternative solutions and recommendations while avoiding unnecessary summarization of
material from the business scenario. It should not be a summary of what you have read about
2. An organize analysis that is presented clearly and concisely
3. It should effectively present the data necessary to perform the analysis
4. It should evaluate alternative courses of action
5. Finally, we are a field that aids in decision-making. You should recommend an actionable
decision that has strong factual support within the context of the case and does not reflect
solely or primarily an opinion.
The write-up in all case submissions should be written as if you are employed in the role of
consultant to, or subordinate of, a senior financial manager. The case write-ups are to be no more
than four (4) written pages including the executive summary and no more than 6 pages of
accompanying exhibits (appendices). The document submitted for grading should be a single
file in MS Word with any and all necessary exhibits, appendices, etc incorporated into the Word
document at the end of the write-up not provided as additional individual files. Supporting
calculations should be provided in a separate MS Excel spreadsheet file with clear labeling and
documentation in that file including the separation of differing calculations into different labeled
worksheets within the file. Any and all materials submitted should be of professional quality
which means, among other things, you should not insert picture format files (jpg, bmp, etc) of
items that are more appropriately created in a spreadsheet or word-processing program.
Professional, written documents will contain correct American English grammar, word choice
and spelling, and make coherent and persuasive arguments. Learning to write clearly, concisely
and informatively is an exceptionally valuable skill that you should undertake to master as soon
as possible. I will not be mandating margins, typesize, indentation, etc. You should turn in a
professional product. You wouldn?t turn in a report to your boss with ? inch margins, ? line
spacing and 8 pt type, don?t turn one in to me. Generally, professional written reports will have at
least 1 inch margins, use 12 or 10 pt type and use 1.5 line spacing or double spacing. They will
be capable of being printed clearly on standard size 8 ? x 11 inch paper.
It is a central goal of this class that the individual case write-ups should be well-developed
writing samples that you can then provide to prospective employers upon request. It has become
extremely commonplace for finance employers to request a writing sample and this is your
opportunity to generate several such samples.