principals of finance
Do you need academic writing help with your homework? Let us write your papers.
Order a Similar Paper
Order a Different Paper
This is the first of two Excel assignments you will complete in this course. Before you get started, be sure to watch the
Save your time - order a paper!
Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines
Order Paper NowMergent Onlinevideo(written instructions can be found here)
.
For this assignment, consider the stock you own in your TDAU thinkorswim portfolio
. Choose one of the companies from your portfolio and complete the following
steps
:
1.Financial Reports
For the company you have
selected, find the most recent annual balance sheet
, annual income statement, and annual
statement of cash flows
.
Copy each of these three reports to its
own worksheet within a single Excel file. The first worksheet should be titled
20XX Balance Sheet; the second,
20XX
Income Statement; the third, 20XX Cash Flow
. (Replace the XX with the appropriate year.)
The image below illustrates the way the file should be set up.
2.Stock Prices
Create a fourth worksheet within the same Excel file for historical stock prices
.
(You can name the worksheet Stock Prices)
Reference the
To Find Historical Stock Prices
section of the Mergent Online
written instructions
to locate the stock prices for
your company for the
most recent seven days
.
In your Excel file, enter those seven prices.
On the Stock Prices worksheet, use an Excel formula to calculate the stock price’s rate of return over that seven-day period. To do this,
1.
Subtract the stock price of the first day from the stock price of the last day
.
2.Divide this amount by the stock price from the first day
.
3.Multiply by 100 to get the rate of return.
4.References At the bottom of each data tab in the spreadsheet, include a link and a properly formatted citation referencing the location of the data used.
Guidelines for Submission:
Submit an Excel file
that meets the criteria
describedin the prompt. Citations should be formatted according to APA