Microsoft Office Tutorials and References
In Depth Information
ASSIGNMENT 3: GIVING A PRESENTATION WITH SLIDES
scenarios with the eight sets of input values using Excel Scenario Manager. If
necessary, review Tutorial C for tips on using Scenario Manager. In this case, the input values are stored together
in one vertical group of cells (C16 through C18) in the Inputs section, as are the three output cells (E21
through E23) in the Summary of Key Results section, so selecting them will be easy. Run Scenario Manager to
gather your data in a report called the Scenario Summary. Format this summary to make it presentable, and
then print it for your instructor.
If you have not done so already, you should run the spreadsheet model eight times, once for each input
combination. Save each spreadsheet in your Excel workbook with a different sheet name. Keep these names as short
but descriptive as possible; for example, you can use RLE, RHE, BLE, BHE, RLF, RHF, BLF, and BHF. Print the
spreadsheets if your instructor requires it. Make sure to save your completed Excel workbook before closing it.
You will run
what-if
Assignment 2B: Documenting Your Recommendations in a Report
Use Microsoft Word to write a brief report to the CEO of Future Cars Inc., Ellen Coleman. State the results of
your analysis and recommend which investment choice to make (electric hybrid or fuel cell). Your report
must meet the following requirements:
￿
The first paragraph must summarize the technology choices facing Future Cars Inc. and state
the purpose of the analysis.
￿
Next, summarize the results of your analysis and state your recommended action.
￿
Support your recommendation with a table outlining the Scenario Summary results. Figure 6-10
has a recommended Microsoft Word table format.
￿
If it is well formatted, you might choose to embed an Excel object of the Scenario Summary into the
body of your report. Tutorial C includes a brief description of how to copy and paste Excel objects.
￿
Your instructor might also ask you to provide a graph of the internal rates of return for the eight
possible combinations of inputs.
Technology
Economic
Outlook
Gasoline
Prices
2015
Net Income
(\$ millions)
2015 End-of-year
Cash on Hand
(\$ millions)
Internal
Rate of
Return
Hybrid
Electric
Recession
Low
High
Boom
Low
High
Fuel
Cell
Recession
Low
High
Low
High
Boom
FIGURE 6-10
Recommended format of a table to insert in your report
In Figure 6-10, divide each of your Net Income and Cash on Hand results by 1 million to display them in
multiples of millions.
ASSIGNMENT 3: GIVING A PRESENTATION WITH SLIDES
Your instructor may ask you to summarize your analysis in an oral presentation. If so, assume that the
management team at Future Cars Inc. wants you to explain your analysis and recommendations in 10 minutes or
less. A well-designed PowerPoint presentation, with or without handouts, is considered appropriate in a
business setting. Tutorial F provides excellent tips for preparing and delivering a presentation.
DELIVERABLES
Your completed case should include the following deliverables for the instructor:
1. A printed copy of your report to management