Title: Financial Ratio Analysis of Apple and Microsoft for 2023

Go to finance.yahoo.com to pull data
Usethetemplateyouhavealreadydownloaded
Complete Excel Spreadsheet Tab “Builder Step 4”
Complete Excel Spreadsheet Tab “Builder Step 5”
_______________________________________________________________________
Prepare the Excel template by filling in the appropriate numbers from the Apple and Microsoft financial statements to the correct columns within the Builder Step 4 and step 5 tab.
_______________________________________________________________________
Once you have completed the Excel template on step 4, review the Excel data results and prepare a (~1) page written analysis of the following ratios for 2023:
Free Cash Flow
Cash Conversion Cycle
Once you have completed the Excel template on step 5, review the Excel data results and prepare a (~1.5) page written analysis of the following ratios for 2023:
Working Capital
Current Ratio
Quick Ratio
I will upload an example for the analyze, just follow the format. 
Your analysis should explain/define what the ratio means and/or is about for these two companies. You are also welcome to compare the companies based on the ratios, but this is not required.  
Your written analysis (Word document) should contain at least 1 page of single-spaced explanatory text.  If you are double spacing, then you must include 2 full pages of explanatory text.
You may choose a format of your choice (technical report style or memo format) but your paper must have the following:
An Introduction
Clear Headings, and
A Conclusion. 

Comments

Leave a Reply