This is the first of two Excel assignments you will complete in this course. Before you get started, be sure to watch the Mergent Online video (written instructions can be found here). Company: Johnson & Johnson (JNJ).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.) 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. Multiply by 100 to get the rate of return. 3. Professionalism Format the data on all worksheets so that the file has a neat and professional appearance. 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 described in the prompt. Citations should be formatted according to APA style.
Essay Writing Service Features
Our Experience
No matter how complex your assignment is, we can find the right professional for your specific task. Contact Essay is an essay writing company that hires only the smartest minds to help you with your projects. Our expertise allows us to provide students with high-quality academic writing, editing & proofreading services.
Free Features
Free revision policy
$10Free bibliography & reference
$8Free title page
$8Free formatting
$8How Our Essay Writing Service Works
First, you will need to complete an order form. It's not difficult but, in case there is anything you find not to be clear, you may always call us so that we can guide you through it. On the order form, you will need to include some basic information concerning your order: subject, topic, number of pages, etc. We also encourage our clients to upload any relevant information or sources that will help.
Complete the order form
Once we have all the information and instructions that we need, we select the most suitable writer for your assignment. While everything seems to be clear, the writer, who has complete knowledge of the subject, may need clarification from you. It is at that point that you would receive a call or email from us.
Writer’s assignment
As soon as the writer has finished, it will be delivered both to the website and to your email address so that you will not miss it. If your deadline is close at hand, we will place a call to you to make sure that you receive the paper on time.
Completing the order and download