Determine changes in total revenue and net income

Reference no: EM133159856

Finance in Business Activity

Instruction

Note: Watch the Excel tutorial videos linked in this week to learn how to use Excel before attempting the activity. You can use the template provided or you may create your own template based on the one provided.

Complete the following scenario using the templates provided:

Select one U.S. publicly traded company and review its most recent annual report. (You may use one of the three companies you selected for your Stock Journal assignment.)

Use the Week 8 Finance in Business Excel Template [XLSX] provided to report assets, liabilities, equity, revenue, and net income for your selected company.

Note: There are locked cells in the Excel template. The cells have been locked to prevent the formulas from being disturbed. The cells that you will need to use to complete this assignment are not locked. You may create your own templates, however it is recommended that you use the templates provided.

Determine changes in assets, liabilities, and equity.

Determine changes in total revenue and net income.

Describe the changes from the current and prior years in each of these key areas and whether the changes would be positive or negative from an investor/stockholder's view.

Go to the Strayer library search page to locate and incorporate at least two quality sources into this assignment.

For stock price information, you may use the New York Stock Exchange, NASDAQ, Yahoo! Finance, or The Wall Street Journal Online.

Attachment:- Finance in Business_template.rar

Reference no: EM133159856

Questions Cloud

Identify its primary target market : Identify its primary target market. Explain your response - Specify three methods you will use to research customer needs and wants

Cause of violent crimes in Philadelphia is due to poverty : The effects of. this problem is that children are scared to go outside and play. People are just not safe anymore and the city needs help

Evaluate strategies for working with stakeholders : Evaluate strategies for working with stakeholders, employees, and investors to start and grow a business - Determine the organization structure that is needed

Explain how each aspect of your supplier code of conduct : Create a presentation about the key areas, changes, and progress in a company's supplier responsibilities and code of conduct

Determine changes in total revenue and net income : Determine changes in total revenue and net income - Describe the changes from the current and prior years in each of these key areas and whether the changes

How they could begin to think about their own philosophy : How they could begin to think about their own philosophy of change and how they navigate change in different contexts

What type of balance should partner capital accounts have : Each partner is to receive a salary of $7,000 per annum. What type of balance should the partner's capital accounts have

What potential risks may be present in this engagement : What potential risks may be present in this engagement? explain each briefly by relating to the above case

How will you work with ruby throughout her working life : How will you work with Ruby throughout her working life to minimize the impact if this scenario were to occur closer to her retirement

User Account

All Pages