Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Produce, in Microsoft Excel, the balance sheet, income statement, statement of cash flows and statement of stockholders equity for Block Inc, a publicly traded company
Produce, in Microsoft Excel, the balance sheet, income statement, statement of cash flows and statement of stockholders equity for Block Inc, a publicly traded company for the past 5 years. What are the key revenue drivers of the company? What are the main cost drivers? Analyze over the 5 years (including graphs and discussions) the following: 1. Profit Margins (Gross Profit Margin, EBIT Margin, Net Profit Margin, EBIDTA Margin, EBITDA Growth, Return on Assets, Return on Invested Capital, Return on Equity [conduct a Dupont analysis to decompose Blocks ROE]). DuPont should show Tax Burden, Interest Burden, Operating Margin, Asset Turnover, Financial Leverage. 2. Liquidity Ratios (Current Ratio, Quick Ratio/Acid Test Ratio, Cash Ratio, Defense Interval) 3. Solvency Ratios (Interest Coverage Ratio, Debt-to-Equity Ratio, Debt-to- Capital, Financial Leverage, Debt-to-EBITDA) 4. Activity Ratios (Days of Sales Outstanding, Receivables Turnover, Fixed Assets Turnover, Total Assets Turnover, Working Capital Turnover) 5. Market Value Added and Economic Value Added 6. FCF Part 2 Beta, CAPM, WACC Analysis, Terminal Growth Rate Part 3 Valuation (DCF, Multiples, DDM) Part 4 Risk Analysis, Sensitivity Analysis, Scenario Analysis, Monte Carlo Simulation)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started