Financial for Managers need in 15 hours.
Use the following information to answer items 1-3: SHOW YOUR WORK (6.0 points)
At December 31 a company's records show the following information:
Cash $10,000
Accounts Receivable 15,000
Inventory 50,000
.Prepaid Insurance 6, 000
Long-term Assets 120,000
Accounts Payable 30,000
Notes Payable due in 10 months 25,000
Wages Payable 5,000
Long-term Liabilities 80,000
Stockholders' (Owner's) Equity 106,000
Net Income 30,000
Calculate the current ratio
Calculate the Debt to Equity ratio
Calculate the Return on Assets
Use the following information to answer items 4-5: SHOW YOUR WORK (3 points)
For its most recent year a company had Sales (all on credit) of $600,000 and Cost of Goods Sold of $400, 000. At the end of the year its Accounts Receivable amounted to $90,000 and its Inventory was $ 60,000. Accounts Payable was $5,000 and Net Income was $42,000.
Calculate the Accounts Receivable Turn Days
Calculate the Inventory Turn Days
Financial Analysis Pfizer (PFE) – (55 points)
Using Yahoo Finance, access Pfizer (PFE) financial statements. Complete the financial analysis of Pfizer for the years 2019,2018,2017 using the financial analysis spreadsheet (include industry averages on your spreadsheet).
Using Word, analyze the data over the three year period and reference the industry averages in the following areas:
Staying Power
Earning Power
Overall efficiency ratios
Working capital cycle ratios
Use CSI Market.com to look up industry averages (Go, enter stock symbol, select Fundamentals. Use
Industry column to retrieve data for all ratios except Earnings Quality and Accounts Payable turnover).
Submit via Canvas:
Financial analysis spreadsheet (include industry averages)
Financial analysis Word document