Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Accounting

Authors: Joe Hoyle, Thomas Schaefer, Timothy Doupnik

10th edition

0-07-794127-6, 978-0-07-79412, 978-0077431808

Students also viewed these Finance questions

Question

c. What are the job responsibilities?

Answered: 1 week ago