Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Post the most recent two-year Balance Sheet and Income Statement in Excel) of your company extracted from the 10-k report on sec.gov. Show the calculations
Post the most recent two-year Balance Sheet and Income Statement in Excel) of your company extracted from the 10-k report on sec.gov. Show the calculations of 6 ratios in your Excel file) of your company in the most recent three years including: o current ratio o total asset turnover ratio o total debt ratio o net profit margin O ROA . ROE PERIOD ENDING: 6/30/2019 6/30/2018 CURRENT ASSETS Cash and Cash Equivalents $392,324 $322,591 Short-Term Investments $0 $0 Net Receivables $82,998 $208,597 Inventory $2,711 $1,869 Other Current Assets $16,583 $14,341 Total Current Assets $494,219 $545,868 LONG-TERM ASSETS LONG-TERM ASSETS Long-Term Investments $44,415 $31,572 Fixed Assets $313,125 $323,992 Goodwill SO SO Intangible Assets $978,526 $1,055,728 Other Assets $0 SO Deferred Asset Charges $74,345 S83,614 Total Assets $1,904,630 $2,040.275 CURRENT LIABILITIES Accounts Payable $296,852 $358.93 CURRENT LIABILITIES Accounts Payable $296,852 $358,938 Short-Term Debt / Current Portion of Long-Term Debt $6,940 $11,980 Other Current Liabilities $241,999 $238,322 Total Current Liabilities $545,791 $609,239 Long-Term Debt $747,407 $780,224 Other Liabilities $0 $0 Deferred Liability Charges $83,005 $87,426 Misc. Stocks $0 $0 Misc. Stocks $0 $0 Minority interest $0 SO Total Liabilities $1,376,202 $1,476,889 STOCK HOLDERS EQUITY Common Stocks S67 $70 Capital Surplus $169,067 $180,554 Retained Earnings $0 $0 Treasury Stock $87,590 $90,863 Other Equity $271,704 $292 399 STOCK HOLDERS EQUITY Common Stocks $67 $70 Capital Surplus $169,067 $180,554 Retained Earnings $0 $0 Treasury Stock $87,590 $90,863 Other Equity $271,704 $292,399 Total Equity $528,428 $563,886 Total Liabilities & Equity $1,904,630 $2,040,775
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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