Part III: Create a statement of cash flows table for the four most recent fiscal...

90.2K

Verified Solution

Question

Accounting

Part III: Create a statement of cash flows table for the four most recent fiscal years (that is why you need the two most recent annual reports). For this statement, you only need to list the three net accounts (i.e., Net Cash Flows from Operating Activities, Net Cash Flow from Investing Activities, and Net Cash Flow from Financing Activities). Then, evaluate these statements over this time period. What has been the major source of cash each year and what has been the major use of cash? Has the company generated sufficient internal cash to finance any capital spending? Anything else? "Your Chosen Company's Complete Name" Financial Ratios For the years ending "Month", Ratios Current Ratio Cash Ratio Inventory Turnover in Days A/R Turnover in Days A/P Turnover in Days Cash Conversion Cycle Fixed Assets Turnover Total Assets Turnover Debt Ratio Times Interest Earned Gross Profit Margin Operating Profit Margin Net Profit Margin Return on Assets Return on Equity 2017 2018 2019 2020 "Your Chosen Company's Complete Name" Common Size Income Statements For the years ending "Month", 2017 2018 2019 2020 Net revenues 100.0% 100.0% 100.0% 100.0% Cost of sales (or whatever is on your company's statement) Gross profit The "Years" in your table will depend on your annual reporst (so, they may not be 2017, 2018, 2019 and 2020 as here). On a common size income statement, all accounts are divided by that year's sales and recorded as a percent rounded to one decimal place. For example, would be recorded as 300/2100-0.1429-14.3%. Note that net revenue (or sales) will be divided by itself, so it will always be 100% Include all income statement accounts that are on the financial statements for your chosen company in individual rows (note the first three that I included above, your statement will include these plus all other accounts on your company's income statements). Be sure to list all profit measures (eg, gross profit margin, operating profit margin, earnings before taxes, and net income) - these should be highlighted in bold font across all columns. It is best to create your table in Excel and then copy and paste special as a "Picture (Enhanced Metafile"). % 96 96 96 % % 96 % % % % % % % 96 % % % % 96 % % % % % % % 96 % 96 % 96 % % 36 % % 96 % % % % 96 96 96 % % % % 96 % % 96 96 96 96 % Annual Sales growth rate 96 96

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students