24 May Finance in Business Activity Instructions Note: Watch the Excel tutorial videos linked in this week to learn how to use Excel before attempting th
- Finance in Business Activity
Instructions
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.
- Use the Week 8 Finance in Business Excel Template [XLSX] provided to report assets, liabilities, equity, revenue, and net income for your selected company.
- 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.
- Submit two documents for your Annual Report activity submission by uploading both documents at the same time in the submission area:
- Completed Week 8 Finance in Business Excel Template [XLSX].
- Completed Week 8 Finance in Business Template [DOC].
- 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.)
Week 8 Homework
| Finance 100 Week 8 – Finance in Business Activity | ||||||
| Please complete ONLY the light blue fields. | ||||||
| Your Name: | ||||||
| Name of the U.S. Publicly Traded Company you chose: | ||||||
| Balance Sheet: | 2020 | 2019 | $ Change | % Change | ||
| Assets | ||||||
| Liabilities | ||||||
| Equity | ||||||
| Income Statement: | ||||||
| Total Revenue | ||||||
| Net Income | ||||||
| NOTE: Explain the changes year-over-year. Would the changes be positive or negative from an investor/stockholder's view? | ||||||
| Use the Word document template to type your summary. | ||||||
| . | ||||||
| Legend: | ONLY Light blue fields can be edited. |
,
***This is a template. Please type over/delete all items in red prior to submitting your assignment.
Week 8 Homework: The Annual Report
By Type Your Name Here
FIN100: Principles of Finance
Enter the Name of Your Instructor Here
Type the Date Here (ex. February 10, 2020)
Week 8 Homework
Instructions: Use the Excel template provided to report assets, liabilities, equity, revenue, and income for your selected company.
Use this template to briefly describe changes year-to-year (current and prior years) for assets, liabilities, equity, revenue, and income. Determine if the changes would be positive or negative from an investor/stockholder’s view.
*Use black, size 12, Times New Roman, Arial, Courier, or Calibri fonts. Double-space your paragraph. Use paragraph headers as necessary to express your results. See the formatting instructions and samples under the Strayer Writing Standards link in the Course Shell.
*AFTER COMPLETING YOUR WORK, DELETE ALL ITEMS IN RED. Your font must be black.
Sources
Sample formatting for an online source:
1. Anya Kamenetz. July 10, 2015. The Writing Assignment That Changes Lives. https://www.npr.org/sections/ed/2015/07/10/419202925/the-writing-assignment-that-changes-lives
Please provide your source list below:
1. Website 1
2. Website 2
3. Website 3
PAGE
2
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteEdu. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
Do you need help with this question?
Get assignment help from WriteEdu.com Paper Writing Website and forget about your problems.
WriteEdu provides custom & cheap essay writing 100% original, plagiarism free essays, assignments & dissertations.
With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Chat with us today! We are always waiting to answer all your questions.