Homework: 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:
i. 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 homework.)
Use the Finance in Business Excel Template 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 homework are not locked. You may create your own templates, however it is recommended that you use the templates provided.
ii. Determine changes in assets, liabilities, and equity.
iii. Determine changes in total revenue and net income.
iv. 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.
Format your homework according to the following formatting requirements:
i) The answer should be typed, using Times New Roman font (size 12), double spaced, with one-inch margins on all sides.
ii) The response also includes a cover page containing the title of the homework, the student's name, the course title, and the date. The cover page is not included in the required page length.
iii) Also include a reference page. The Citations and references must follow APA format. The reference page is not included in the required page length.
Attachment:- Fin-Templete.rar