Apple Analyst Project

You are going to perform a financial ratio analysis on Apple Corporation, using the skills you learn in Chapters 1-4 of the textbook.

Attached are the analysis Insturctions and an Excel spreadsheet for your analysis. Also attached is a scan of the Apple home page in Yahoo Finance.

APPLE CORPORATION (APPL) Analyst Project Instructions Data Source Start at the Yahoo Finance home page (see attachment for screen view) Select / search Apple stock symbol AAPL Select Financials Annual results In turn, select the income statement, balance sheet, and statement of cash flows Then, select Historical Data Find the stock price for 9/30/20 and 9/30/19 If there is no price for that day, select the nearest date prior Select Adjusted Close price This data will be the inputs to the Excel spreadsheet (inputs are in GRAY shaded cells)

Your Task Complete the Excel worksheet inputs and calculate ALL the required financial ratios You may complete the calculations in one of two ways: Embed Excel formulas/ functions in the YELLOW calculation cells Perform the calculations by hand and attach your worksheet to the Excel spreadsheet You must submit the Excel worksheet on Blackboard by Monday 2/8. The submission may be in the form of the Excel worksheet (with embedded formulas), the Excel worksheet plus attached calculation worksheet, or a PDF file with the required information. The submission cannot be any type of photograph or picture image. Such a submission will be rejected and the grade on the assignment will be 0/10 points Teams? You may complete the assignment individually or with one other student (maximum two student teams) If you work as a team, submit ONE spreadsheet with both student names Hints Make sure all of your numbers are properly calibrated. Do not, for example, mix thousands with millions or you will get incorrect ratios and calculations. Note that Yahoo Finance financial statements are scaled / calibrated in thousands ($000) I have input the number of shares into the Excel spreadsheet. Note the calibration is in billions. Where a value (such as total assets) appears in multiple input cells the spreadsheet will automatically populate all cells with the initial input EBIT is earnings before interest and taxes which you will find on the income statement. interest payments and interest expense on the income statement are the same. dividends and earnings are in cash flow statement. note: earnings is net income. sales is your revenue figure from your income statement. Watch your calculation for daily sales cost of revenue (which is in the income statement) is the same as cost of goods sold. for ratios using an "average" use the value of the current year and the previous year Yahoo Finance puts the depreciation amount on the cash flow statement. The debt ratio on the template refers to the long-term debt-equity ratio. Net working capital=current assets-current liabilities book value of equity is on the company's balance sheet.

1/14/2021 AAPL 129.90 -0.99-0.76% : Apple Inc. - Yahoo Finance HISTORICH . STOCK PRICE BALANCE SHEET INCOME STATEMENT CASH FLOWS Add to watchlist 2. Visitors trend zw+10W 9M Apple Inc. (AAPL) Nasdaqs. Nasdaqs Real Time Price. Currency in USD 129.90 -0.99 (-0.76%) As of 10:24AM EST. Market open quote Lookup Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options 1D 5D IM 6M YTD 1Y SY Max Full screen 131.20 130.99 130.60 120.00 129.87 129.40 VIEW NOW VIEW NOW 10 AM 12 PM 02 PM Trade prices are not sourced from all markets Chart Events Bullish pattern detected doli, Price Crosses Moving Average View all chart patterns Previous Close Performance Outlook Short Mid Term Term 2W-6W GWSM Long Term SM yahoo/finance Trade like it's not your first rodeo Tirgitte 130.89 Market Cap 2.185T Open 130.80 1.28 Bid 129.93 x 900 Beta (SY Monthly) PE Ratio (TTM) EPS (TTM) 39.59 People Also Watch Symbol Last Price AMZN 3,171.96 Amazon.com, Inc Change % Change Ask 129.93 x 800 3.28 +6.07 +0.19% Day's Range 129.60 - 131.00 Earnings Date 250.73 -0.91 -0.36% Jan 27, 2021 0.82 (0.63%) FB Facebook, Inc. 53.15 - 138.79 Forward Dividend & Yield 1,762.45 +8.05 -0.46% 20,168,620 Ex-Dividend Date Nov 06, 2020 860.00 +5.59 +0.65% 109,852,893 1y Target Est 130.50 52 Week Range Volume Avg. Volume Fair Value XX.XX Overvalued -15% Est. Return GOOG Alphabet Inc TSLA Tesla, Inc NFLX Netflix, Inc. 504.67 -3.12 -0.61% Related Research Analyst Report: Apple Inc. Analyst Report: Apple Inc. View more View details Total ESG Risk score > 23.6 Medium 33rd percentile Earnings > Consensus EPS Related Video INFLUENCERS Ad: 305 Influencers with Andy Serwer: Haim Saban 32 Apple Sets Up Cup Arial 11 ...EE Il- a APPL_excel_student_SPR_21 (1) File Edit View Insert Format Data Tools Add-ons Help Last edit was 6 minutes ago 100% - $ % .0 .00 123- BISA fx Analyst Name Analyst Name + 1. - - A1 B D E F G H 1 J K 1 Date 2 3 Company Name Apple Ticker Symbol AAPL 4 5 6 7 8 Financial Ratio Analysis YE 9/30/20 YE 9/30/19 Actual Change in Value % Change in Value 9 10 11 12 13 Performance Measure Parameters: Price per Share on Quarter's Last Trading Day Shares Outstanding (billions) Book Value of Equity 17.52 18.596 $0.00 (1.1) 0 #DIV/0! 0 -6% #DIV/0! 14 15 Performance Measures (2 Calculations): Market Value Added Market-to-Book ratio $0 $0 #DIV/0! #DIV/0! 16 17 18 19 20 21 22 23 24 I. Leverage Ratio Parameters: Long-Term Debt Equity Total Liabilities Total Assets EBIT Interest Payments $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Leverage Ratios (2 ratios): Long-Term Debt Total Debt 0 0 #DIV/0! #DIV/0! 25 26 27 28 29 30 31 32 33 34 II. Liquidity Ratio Parameters Total Assets Current Assets Cash Receivables Current Liabilities Liquidity Ratios (2 ratios): Current Ratio Cash Ratio $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 35 36 37 38 39 40 41 42 0 0 #DIV/0! #DIV/0! 43 III. Efficiency Ratio Parameters: Sales (a.k.a. Revenue) Total Assets Receivables Daily Sales $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIVINI 44 45 APPL_excel_student_SPR_21 (1) File Edit View Insert Format Data Tools Add-ons Help Last edit was 6 minutes ago 100% - $ % .0 .00 123- Arial 11 BI.A li - - A1 fx Analyst Name B D E F G H 1 J K L M 37 38 . Liquidity Ratios (2 ratios): Current Ratio Cash Ratio 0 0 #DIV/0! #DIV/0! 39 40 III. Efficiency Ratio Parameters: Sales (a.k.a. Revenue) Total Assets Receivables Daily Sales Cost of Goods Sold Inventory $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Efficiency Ratios (4 ratios): Asset Turnover Average Collection Period (days) Inventory Turnover Receivables Turnover N/A N/A N/A N/A IV. Profitability Ratio & Growth Parameters: Net Income (a.k.a. Earnings) Sales (a.k.a. Revenue) Interest Payments Total Assets Equity Dividends $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 59 60 61 62 63 64 65 66 67 Profitability Ratios (3 ratios): Return on Equity (ROE) Return on Assets (ROA) Profit Margin 0 0 0 #DIV/0! #DIV/0! #DIV/0! Growth Measures (2 ratios): 68 69 70 71 72 73 Payout Plowback 0 0 #DIV/0! #DIV/0! 74 Complete all calcualtions. Attach worksheet if manually calculated ratios 75 76 77 You input You calculate 78 79 so 1/14/2021 AAPL 129.90 -0.99-0.76% : Apple Inc. - Yahoo Finance HISTORICH . STOCK PRICE BALANCE SHEET INCOME STATEMENT CASH FLOWS Add to watchlist 2. Visitors trend zw+10W 9M Apple Inc. (AAPL) Nasdaqs. Nasdaqs Real Time Price. Currency in USD 129.90 -0.99 (-0.76%) As of 10:24AM EST. Market open quote Lookup Summary Company Outlook Chart Conversations Statistics Historical Data Profile Financials Analysis Options 1D 5D IM 6M YTD 1Y SY Max Full screen 131.20 130.99 130.60 120.00 129.87 129.40 VIEW NOW VIEW NOW 10 AM 12 PM 02 PM Trade prices are not sourced from all markets Chart Events Bullish pattern detected doli, Price Crosses Moving Average View all chart patterns Previous Close Performance Outlook Short Mid Term Term 2W-6W GWSM Long Term SM yahoo/finance Trade like it's not your first rodeo Tirgitte 130.89 Market Cap 2.185T Open 130.80 1.28 Bid 129.93 x 900 Beta (SY Monthly) PE Ratio (TTM) EPS (TTM) 39.59 People Also Watch Symbol Last Price AMZN 3,171.96 Amazon.com, Inc Change % Change Ask 129.93 x 800 3.28 +6.07 +0.19% Day's Range 129.60 - 131.00 Earnings Date 250.73 -0.91 -0.36% Jan 27, 2021 0.82 (0.63%) FB Facebook, Inc. 53.15 - 138.79 Forward Dividend & Yield 1,762.45 +8.05 -0.46% 20,168,620 Ex-Dividend Date Nov 06, 2020 860.00 +5.59 +0.65% 109,852,893 1y Target Est 130.50 52 Week Range Volume Avg. Volume Fair Value XX.XX Overvalued -15% Est. Return GOOG Alphabet Inc TSLA Tesla, Inc NFLX Netflix, Inc. 504.67 -3.12 -0.61% Related Research Analyst Report: Apple Inc. Analyst Report: Apple Inc. View more View details Total ESG Risk score > 23.6 Medium 33rd percentile Earnings > Consensus EPS Related Video INFLUENCERS Ad: 305 Influencers with Andy Serwer: Haim Saban 32 Apple Sets Up Cup Arial 11 ...EE Il- a APPL_excel_student_SPR_21 (1) File Edit View Insert Format Data Tools Add-ons Help Last edit was 6 minutes ago 100% - $ % .0 .00 123- BISA fx Analyst Name Analyst Name + 1. - - A1 B D E F G H 1 J K 1 Date 2 3 Company Name Apple Ticker Symbol AAPL 4 5 6 7 8 Financial Ratio Analysis YE 9/30/20 YE 9/30/19 Actual Change in Value % Change in Value 9 10 11 12 13 Performance Measure Parameters: Price per Share on Quarter's Last Trading Day Shares Outstanding (billions) Book Value of Equity 17.52 18.596 $0.00 (1.1) 0 #DIV/0! 0 -6% #DIV/0! 14 15 Performance Measures (2 Calculations): Market Value Added Market-to-Book ratio $0 $0 #DIV/0! #DIV/0! 16 17 18 19 20 21 22 23 24 I. Leverage Ratio Parameters: Long-Term Debt Equity Total Liabilities Total Assets EBIT Interest Payments $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! Leverage Ratios (2 ratios): Long-Term Debt Total Debt 0 0 #DIV/0! #DIV/0! 25 26 27 28 29 30 31 32 33 34 II. Liquidity Ratio Parameters Total Assets Current Assets Cash Receivables Current Liabilities Liquidity Ratios (2 ratios): Current Ratio Cash Ratio $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 35 36 37 38 39 40 41 42 0 0 #DIV/0! #DIV/0! 43 III. Efficiency Ratio Parameters: Sales (a.k.a. Revenue) Total Assets Receivables Daily Sales $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIVINI 44 45 APPL_excel_student_SPR_21 (1) File Edit View Insert Format Data Tools Add-ons Help Last edit was 6 minutes ago 100% - $ % .0 .00 123- Arial 11 BI.A li - - A1 fx Analyst Name B D E F G H 1 J K L M 37 38 . Liquidity Ratios (2 ratios): Current Ratio Cash Ratio 0 0 #DIV/0! #DIV/0! 39 40 III. Efficiency Ratio Parameters: Sales (a.k.a. Revenue) Total Assets Receivables Daily Sales Cost of Goods Sold Inventory $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 0 0 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 Efficiency Ratios (4 ratios): Asset Turnover Average Collection Period (days) Inventory Turnover Receivables Turnover N/A N/A N/A N/A IV. Profitability Ratio & Growth Parameters: Net Income (a.k.a. Earnings) Sales (a.k.a. Revenue) Interest Payments Total Assets Equity Dividends $0 $0 $0 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 59 60 61 62 63 64 65 66 67 Profitability Ratios (3 ratios): Return on Equity (ROE) Return on Assets (ROA) Profit Margin 0 0 0 #DIV/0! #DIV/0! #DIV/0! Growth Measures (2 ratios): 68 69 70 71 72 73 Payout Plowback 0 0 #DIV/0! #DIV/0! 74 Complete all calcualtions. Attach worksheet if manually calculated ratios 75 76 77 You input You calculate 78 79 so