Excel Spreadsheet Assignment

Apr 18th, 2015
SoccerBoss
Category:
Accounting
Price: $60 USD

Question description

Assignment 1: Excel Project
Due Week 5 and worth 200 points

This 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 Assignment
1.  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.

Tutor Answer

(Top Tutor) Daniel C.
(997)
School: UCLA
PREMIUM TUTOR

Studypool has helped 1,244,100 students

8 Reviews


Summary
Quality
Communication
On Time
Value
tinytim47
Dec 5th, 2016
" Wow this is really good.... didn't expect it. Sweet!!!! "
Five Star Tutor
Nov 23rd, 2016
" Outstanding Job!!!! "
mixedballz
Nov 22nd, 2016
" excellent work as always thanks for the help "
lilmoe415
Nov 13th, 2016
" Thank you, Thank you, for top quality work, this is your guy!! "
darnay
Oct 30th, 2016
" The best tutor out there!!!! "
dontuwannaknow
Oct 21st, 2016
" Excellent work as always thanks so much "
SjSurvivor143
Oct 8th, 2016
" Thanks for the help. "
Joemoe
Sep 24th, 2016
" <3 it, thanks for saving me time. "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1827 tutors are online

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors