I only need part 2 and 3 done.
Week
Three
–
Online
Excel Data Reporting: Assignment 3 Data Analysis (Feasibility Study Data
Reporting)
The objectives of this assignment are to help you:
1. Analyze and interpret financial data
2. Chart data in Excel using the MCCD Model
3. Create a persuasive argument to influence the audience
Assignment Requirements:
4. Your assignment must include the following:
o Excel Data Analysis:
Historic performance (calculate percent change)
Calculated projections
Four or more charts
o Presentation:
Persuasive paper OR podcast
Part 1 – Identify and submit publicly traded company choice, proposal idea
and financial statements.
Due by Wednesday of Week 3 on the Assignment 3 Part 1 discussion board
Use LexisNexis in the library research tools to choose a public company of
your choice that you will develop a new strategy for. Submit your choice
of a public company, proposal idea as well as the reference for the raw
financial data from the LexisNexis database to the Assignment 3 Part 1
discussion board.
Your proposal idea should be a new strategy for the company to improve
overall financial performance. This may include proposing a new product,
halting production of an existing product, improving distribution, targeting
new markets, etc.
While this information will be posted on a discussion board, only one post
is required. If you would like to provide feedback to a fellow classmate,
you are more than welcome to, but it is not a requirement.
If you have any difficulties choosing a company, developing a strategy or
finding financial statements, be sure to attend our live GoToTraining
session or contact your instructor.
Part 2 – Excel Data Analysis
Excel Data Analysis Requirements:
5. Your analysis must include all of the following:
o Historic performance (calculate percent change)
o Calculated projections
o Four or more charts
Examples of company figures to calculate percent change and projections may
include (but are not limited to):
6. Revenue
7. COGS (Might be Cost of Sales if no product)
8. Gross Profit
9. Operating Expenses
10. Net Profit
Remember: Use the data to tell your story: Whichever information will
support and defend your proposal is what should be presented. At least
one chart should display your projections but feel free to encompass other
impacts of your proposal such as:
11. Demographic Data (current or potential customers, new markets, etc.)
12. Competitive Analysis (market share, competitor’s financial performance, etc.)
13. Market Trends (product usage or popularity, prices, etc.)
Using this calculated data, create Excel charts to display the need for your
proposed strategy. Design the charts according to the lessons learned from Say
It With Charts.
Part 3 – Delivery
Due by Sunday of Week Four
In addition to the Excel document being submitted, select one of the following
two options to deliver your pitch:
14. Write a paper. Must be two-to-three pages and follow APA format. Be sure to
write in a professional business style and be persuasive. Sell your idea to the
company on why they should change or add this product/service. Use the Excel
data/charts to support the paper. Cite sources for all of your research.
a. Deliverables:
i. Word file
ii. Excel file
15. Create a podcast. Create a narrated presentation selling your idea to the
company. An Excel file with all of your calculations and original charts will
Week
Three
–
Online
accompany and support the audio presentation. Cite sources for all of your
research. Make sure the script you read from follows the Academic Integrity
standards.
a. Deliverables:
i. Excel file
ii. Podcast File
If you have any questions or concerns, be sure to attend our live Week Four
GoToTraining session or contact your instructor.
Plan for the worksheets to be printed and review the bundled worksheet design
guidelines as well as the Assignment Three checklist.
Academic Integrity
Please review the Academic Integrity section of the course Syllabus and ensure
that your assignment does not plagiarize or violate any academic integrity
principles of Full Sail University before submitting it. Violation of this policy can
have severe consequences.
Students are required to use their own language when writing papers or
submitting other media assignments. The purpose of assignments is for each
student to demonstrate his or her own analysis, ideas, and synthesized
information – not to just copy and paste what has been published on a particular
topic. While research is encouraged for some assignments, research entails
reading and synthesizing information with one’s own ideas, and citing sources
used during research, to give credit to those whose ideas or language are
utilized. Quoted materials should be clearly identified and woven into a longer
paper that consists primarily of the student’s ideas. Quotations must be
punctuated as quotations per APA format, must be cited, and must not represent
the majority of the assignment.
Plagiarism is using another author’s ideas, words, or language without putting
those words in quotation marks and citing the reference, giving proper credit to
the author. Plagiarism also includes changing the words from a third party source
while maintaining the same sentence structure and not providing proper citation
and reference. It is not permissible to copy a passage and then just change a few
words. These actions are considered plagiarism, regardless of whether or
not the intention was to plagiarize. To avoid plagiarism, students should
adhere to the following guidelines:
a. If you are using words that were written or spoken by someone else, you
must put quotation marks around the words and insert the citation in
parentheses at the end of the quote. Any quote over 40 words must be in
indented block paragraph style, per APA guidelines.
b. Even brief phrases of four words or more must be included in quotation
marks if those words are not your own and were taken from another
source.
c. If the information or ideas you are using come from another source—even
if it is paraphrased and contains your own words—you must cite the
source at the end of the passage (in parentheses) and in the “References”
section at the end of the paper. Please refer to the APA style guide for
examples on how to cite various types of references (www.apastyle.org).
d. No more than 10% of your paper should be directly quoted material,
unless the course director indicates otherwise within the assignment
instructions.