University of California Irvine AEMD Supply Chain Management Questions

User Generated

XevfYYY

Business Finance

University of California Irvine

Description

supply chain management- Excel calculation questions and 1-2 pages report

supply chain management- Excel calculation questions and 1-2 pages report

Unformatted Attachment Preview

UNIVERSITY OF LA VERNE BUS 530 STOCK PRICE TRACKING - EXPECTED SUMMER 2020 COMPANY SELECTED: TICKER SYMBOL: WEEK WEEK CUMULATIVE CUMULATIVE ANNUALIZED $$ %% $$ %% %% INITIAL # OF STOCK VALUE OF INC / INC / INC / INC / INC / DATE INVESTMENT SHARES PRICE INVESTMENT (DEC) (DEC) (DEC) (DEC) (DEC) 6/12/20 $ #DIV/0! 10,000 #DIV/0! 6/19/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 6/26/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/10/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/17/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/24/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/31/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 8/7/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/3/20 * * Use the opening price on 7/6/20 if the stock market is closed on 7/3/20. C:\Users\cloudconvert\server\files\120\182\5\aa8ba48f-1a10-4d70-bde1-6ad716dba494\| File| ]Stk Price Track Temp - Expected 6/30/2020 UNIVERSITY OF LA VERNE BUS 530 STOCK PRICE TRACKING - ACTUAL SUMMER 2020 COMPANY SELECTED: 0 TICKER SYMBOL: 0 WEEK WEEK CUMULATIVE CUMULATIVE ANNUALIZED $$ %% $$ %% %% INITIAL # OF STOCK VALUE OF INC / INC / INC / INC / INC / DATE INVESTMENT SHARES PRICE INVESTMENT (DEC) (DEC) (DEC) (DEC) (DEC) 6/12/20 $ #DIV/0! 10,000 #DIV/0! 6/19/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 6/26/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/10/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/17/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/24/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/31/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 8/7/20 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 7/3/20 * * Use the opening price on 7/6/20 if the stock market is closed on 7/3/20. C:\Users\cloudconvert\server\files\120\182\5\aa8ba48f-1a10-4d70-bde1-6ad716dba494\| File| ]Stk Price Track Temp. - Actual 6/30/2020 UNIVERSITY OF LA VERNE BUS 530 STOCK PRICE TRACKING - COMPARATIVE ANALYSIS SUMMER 2020 COMPANY SELECTED: 0 TICKER SYMBOL: 0 Annualized 6/12/20 8/7/20 $ Change % Change % Change Expected $ - $ - $ - #DIV/0! #DIV/0! Actual $ - $ - $ - #DIV/0! #DIV/0! Difference $ - $ - $ - #DIV/0! #DIV/0! C:\Users\cloudconvert\server\files\120\182\5\aa8ba48f-1a10-4d70-bde1-6ad716dba494\| 20200630030009dd112cd6198fd65e| Expect vs. Actual 6/30/2020 Stock tracking 1-2 pages OBJECTIVE The objective of this project is to reinforce to the student the concepts and principles related to tracking and monitoring stock/investment activity in order to make appropriate financial investment and budgetary decisions. During these extraordinary times in history, stock market activity is more volatile than ever, making it particularly relevant for students to understand and follow the machinations of the stock market. OVERVIEW One of the fundamental aspects of finance is the ability to track stock price changes of specific stocks, quantify the changes, and make appropriate investment decisions based on the analysis. In this project the student will select a stock, monitor/track its weekly performance, calculate the annualized return generated over the time period, and comment on its results. The students will be able to compare their expected/forecasted results to actual performance, a simulation, so to speak, of monitoring a budget. STOCK TRACKING The student will fictitiously invest $10,000 in the Company’s stock (the Company must be related to/ member of the Healthcare market sector) at the current stock price on the Friday of the 1st week of class. They will record the closing stock price on that Friday. They will also forecast what they expect the closing stock price to be on the last Friday of the assignment (August 7th in this semester). This information will be recorded in the Stock Price Tracking – Template excel file, in the tab titled “Stk Price Track Temp – Expected” (cell inputs are highlighted in yellow). In the same excel file using the tab “Stk Price Track Temp. – Actual” the student will record the actual closing price on the Friday indicated, and track the weekly change in the stock price and calculate (1) the weekly gain/(loss) in dollars and percent, and (2) the cumulative gain/(loss) in dollars and percent. Finally, on the last week of the semester the student will show the total gain/(loss), and the annualized percent return “earned” on the investment. In the “Expect vs. Actual” tab, the student will be able to see how the stock is performing compared to their expectation. The results shown in this tab will help the student prepare their report (see Deliverables section below). A.The student will submit to the instructor via email the completed tab “Stk Price Track Temp – Expected”, including (1) the name of the Company, (2) its stock Ticker Symbol, (3) the closing stock price on 6/12/20, and (4) the expected stock price on 8/7/20. B.The student will submit the following on the last meeting day of class: 1. performance, including gain/(loss) calculations. 2.A one-two page report describing and summarizing the results, including by not limited to some or all of the following: •Company Name & Ticker Symbol •Why selected •Expectations of performance at the beginning of the assignment. •Compare/contrast expected performance vs. actual performance •Comment on results of actual performance (include dollar amount gain/(loss) and annualized % rate gain/(loss). •Comment on long-term vs. short-term performance results and corresponding investment strategy (long-term vs. short-term). •Lessons learned about stock selection and tracking of performance, including expectations compared to real performance. •Application(s) of this assignment to tracking a forecast to actual (variance analysis). •A weekly diary of things learned, emotions felt, etc. as the stock price changes (the diary is not part of the report – it is separate). •Overall recommendation on buy/hold/sell stock.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello, I'm done, I have submitted both files, all parts are correctly answered as per the instructions.

Running head: STOCK TRACKING

1

Stock Tracking
Student Name
Professor’s Name
Due Date

STOCK TRACKING

2

The company picked is Aethlon Medical, Inc. (AEMD). The reason I selected the
company is that Aethlon is a pharmaceutical firm specializing in forming devices for cancer,
infectious illnesses, and other life-threatening issues. The company carries out its operation in
two sections, Aethlon and ESI (Yahoo, 2020). Aethlon is therapeutic, which ESI is in charge of
diagnosing business activities.
At the beginning of the assignment, I expected the company to perform well because it is
a cancer healthcare company; it would do better with increases in cancer globally. The opposite
happened, whereby the company stocks dropped in prices drastically, making me run into losses.
A comparison of expected vs. actual results is as follows.
Aethlon
Medical,
Inc.
COMPANY SELECTED:

(AEMD)

TICKER SYMBOL:

AEMD

6/12/20

8/7/20

$ Change

%

Annualized

Change

% Change

Expected

$ 2.13

$ 2.40

$

0.27

12.7%

82.4%

Actual

$ 2.13

$

$

(0.17)

-8.0%

-51.9%

Difference

$ -

$(0.44)

-163.0%

-163...


Anonymous
Just what I needed. Studypool is a lifesaver!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags