Overview
What you need to do:
-
Open the Excel file:
It’s calledHussein_Miller-Nobles_8e-14e-Using_Excel_ChF15-ChF17_Start_Tutorial.xlsx. There are 4 tabs in the file, but you will only work on the last 3:- Horizontal Analysis (2nd tab)
- Vertical Analysis (3rd tab)
-
Ratios (4th tab)
Fill in the answers in the blue boxes only. To see the blue boxes, open the Excel file in:- Microsoft Excel
- Use formulas and cell references (not just typing numbers) to get full credit.
-
Do these tasks inside the Excel file:
- Horizontal analysis using data from 2023 and 2024 balance sheets.
- Vertical analysis using the 2024 income statement.
- Calculate 20+ financial ratios, including EPS, price/earnings ratio, working capital, dividend yield, etc.
-
Video that we need to follow links:
Use these videos (copy into browser):
https://mediaplayer.pearsoncmg.com/assets/mn8e_14e_F15_F17_part1
https://mediaplayer.pearsoncmg.com/assets/mn8e_14e_F15_F17_part2
https://mediaplayer.pearsoncmg.com/assets/mn8e_14e_F15_F17_part3a
https://mediaplayer.pearsoncmg.com/assets/mn8e_14e_F15_F17_part3b
https://mediaplayer.pearsoncmg.com/assets/mn8e_14e_F15_F17_part3c
https://mediaplayer.pearsoncmg.com/assets/mn8e_14e_F15_F17_part3d - Save the file (no spaces in the name) and send it back to me.
- mportant rules :
- Use formulas and cell references, not just typing numbers.
- Enter answers only in the blue-shaded cells.
- Do not copy/paste from the instructions tab or you’ll lose points.
- Final file name should not have spaces.