strayer acc306 Assignment 1: Excel Project

I need the following essay completed within 24 hours.  Will you be able to do it?Assignment 1: Excel ProjectDue Week 5 and worth 200
pointsThis assignment is based on your ability to use Excel 2013 to
track and manage stock prices for companies who sell accounting software
products and then analyze each company. This assignment consists of two (2)
parts – an Excel-based assignment and a paper. The firms are as follows:

Oracle Software (Oracle Corp: NASDAQ)
Microsoft Great Plains (Microsoft: NASDAQ)
QuickBooks (Intuit: NASDAQ)
Part I: Excel Spreadsheet Assignment1. Create one (1)
Excel workbook that contains each of the four (4) scenarios (detailed below).
Use the appropriate Excel formulas and functions to justify your derived
results. Note: Follow the completion and submission instructions provided in the
table below.

Scenario
1

You
have been given $5,000,000 to invest in the three (3) stocks. You must invest
the $5,000,000 evenly across the stocks. The purchase date of the stock will be
three (3) months ago. Track your stocks’ daily performance for the 45 trading
days following the purchase date. During this time, you will note the gains and
losses each day. At the end of the 45 days’ tracking period, calculate your net
gain (or loss) for each stock and your total investment at the end of the 45
days. Develop the appropriate charts that highlight your performance. You will
create a minimum of two (2) charts.

Note:
Your
purchase must be in whole shares. For example, you cannot purchase 100.5 shares.
You must purchase either 100 or 101 shares. For this reason, you may not total
to exactly $5,000,000, but you will come close.

Scenario
2

You
are a believer in Oracle and Microsoft. With that, you will now invest your
$5,000,000 evenly between the two (2) stocks. The purchase date of the stock
will be three (3) months ago. Track your stocks’ daily performance for the 45
trading days following the purchase date. During this time, you will note the
gains and losses each day. At the end of the 45 days’ tracking period, calculate
your net gain (or loss) for each stock and your total investment at the end of
the 45 days. Develop the appropriate charts that highlight your performance. You
will create a minimum of two (2) charts.

Note:
Your
purchase must be in whole shares. For example, you cannot purchase 100.5 shares.
You must purchase either 100 or 101 shares. For this reason, you may not total
to exactly $5,000,000, but you will come close.

Scenario
3

You
are a believer in Intuit and Microsoft. With that, you will now invest your
$5,000,000 evenly between the two (2) stocks. The purchase date of the stock
will be three (3) months ago. Track your stocks’ daily performance for the 45
trading days following the purchase date. During this time, you will note the
gains and losses each day. At the end of the 45 days’ tracking period, calculate
your net gain (or loss) for each stock and your total investment at the end of
the 45 days. Develop the appropriate charts that highlight your performance. You
will create a minimum of two (2) charts.

Note:
Your
purchase must be in whole shares. For example, you cannot purchase 100.5 shares.
You must purchase either 100 or 101 shares. For this reason, you may not total
to exactly $5,000,000, but you will come close.

Scenario
4

You
are a believer in Oracle and Intuit. With that, you will now invest your
$5,000,000 evenly between the two (2) stocks. The purchase date of the stock
will be three (3) months ago. Track your stocks’ daily performance for the 45
trading days following the purchase date. During this time, you will note the
gains and losses each day. At the end of the 45 days’ tracking period, calculate
your net gain (or loss) for each stock and your total investment at the end of
the 45 days. Develop the appropriate charts that highlight your performance. You
will create a minimum of two (2) charts.

Note:
Your
purchase must be in whole shares. For example, you cannot purchase 100.5 shares.
You must purchase either 100 or 101 shares. For this reason, you may not total
to exactly $5,000,000, but you will come close.

Note

Do
not worry about any commission fees or miscellaneous
charges.

Assignment

Determine
how much money you earned or lost with each stock on a daily
basis.

Instructions
on how to complete

There
is no sample Excel workbook to use as part of the project; therefore, you will
create your own workbook. In creating your workbook, be sure to include the
following data (however, other data will be stored in your scenario) in a
columnar format.

Stock
name
Stock
symbol
Number of shares
purchased / acquired
Stock
price
Date of stock
transaction

Start
your scenario using the opening-day price for each stock as your purchase price
and use the closing stock price to calculate how much money you earned or lost
each day.

At
the end of your scenario, calculate the following for each stock in
question.

The highest stock
price for the period for the stock(s) selected
The lowest stock
price for the period for the stock(s) selected
The average stock
price for the period for the stock(s) selected
The largest amount
of profit (loss) earned for the period for the stock(s) selected
The lowest amount of
profit (loss) earned for the period for the stock(s) selected

Track
the stock for 45 consecutive days that the market is open.

Submit

One
(1) Excel workbook that contains each of the four (4) scenarios. You will need
to use the appropriate Excel formulas and functions which will show the
instructor how you derived your results.
Part II: Paper
2. Write a three to four (3-4) page paper in
which you:

2a. Summarize your findings from each scenario, emphasizing your decisions
on which stocks were used and the criteria for determining the number of stocks
used. Suggest a strategy to improve your selection of courses.
2b. Describe an ideal scenario that would have exceeded the results from
your best scenario in Part 1 of the assignment.
2c. Determine at least two (2) ways accountants use Excel to support
management decisions.
2d. Use at least two (2) quality academic resources in this assignment.
Note: Wikipedia and other Websites do not qualify as academic
resources.
Your assignment must follow these formatting requirements:

Be typed, double spaced, using Times New Roman font (size 12), with one-inch
margins on all sides; citations and references must follow APA or
school-specific format. Check with your professor for any additional
instructions.
Include a cover page containing the title of the assignment, the student’s
name, the professor’s name, the course title, and the date. The cover page and
the reference page are not included in the required assignment page
length.
The specific course learning outcomes associated with this assignment
are:

Create and update spreadsheets with Microsoft Excel.
Discuss how automated accounting software can help management make better
informed business decisions.
Use advanced features of Microsoft Excel to solve business problems.
Use technology and information resources to research issues in microcomputer
applications for accountants.
Write clearly and concisely about microcomputer applications for accountants
using proper writing mechanics.