Annual Report Project - Select one of the ratios that you calculated...

profileBestResearchWriters
answer_template.xls

Sheet1

Company Name
1. (1.5 points) Examine the financial statements. The amounts are stated in what increment of dollars?
1. (1.5 points) What is the amount of sales and net income did the company have during the most recent year and the prior year (not quarter)? Label each answer. 0 0 0 0 0 0
Sales CY
Sales PY
NI CY
NI PY
3. (1.5 points) What is the closing date of the company’s most recent annual reporting period?
1. (1.5 points) What amount was reported as total assets at the end of the most recent annual reporting period, prior year, and the year before that? Label each answer. 0 0 0 0 0 0
TA CY
TA PY
TA PPY
5. (1.5 points) The corporation is incorporated in what state?
6. (1.5 points) How is the corporation listed on the stock exchange (their abbreviation)?
7. (1.5 points) Who was the company’s independent auditing firm?
8. (1.5 points) What amount of current liabilities and total liabilities did the company have during the most recent year and the prior year (not quarter)? Label each answer.
CL CY
CL PY
TL CY
TL PY
9. (1.5 points) Who is the Chairman of the Board?
10. (1.5 points) What is the company’s current, prior, and the year before that year ending balance for accounts receivable (also called trade receivables)? Label each answer.
AR CY
AR PY
AR PPY
11. (1.5 points) What is the company’s current, prior, and the year before that year ending balance for inventory? Label each answer.
Inv CY
Inv PY
Inv PPY
12. (1.5 points) What is the company’s current and prior year balances for current assets? Label each answer.
CA CY
CA PY
13. (1.5 points) What is the company’s current and prior year balances for interest expense and income tax expense (also called provision for income taxes)? If interest expense is listed in a net amount with interest income, you must look at the footnotes to get only the amount of interest expense. Label each answer.
IE CY
IE PY
TE CY
TE PY
14. (1.5 points) What is the company’s current year’s basic and diluted earnings per share (EPS)?
15. (1.5 points) What is the company’s current, prior, and the year before that year ending balance for cost of goods sold? Label each answer.
COGS CY
COGS PY
16. (1.5 points) What is the corporate address?
17. (1.5 points) What is the per share par/stated value for common stock?
18. (1.5 points) What was the amount of the cash provided by operations? (This is not the same as cash on the balance sheet.)
19. (1.5 points) What is the major cash inflow in the Financing section?
20. (1.5 points) What is the major cash outflow in the Investing section?
21b. (2 points) Calculate the Current Ratio for the current year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
21c. (2 points) Calculate the Current Ratio for the prior year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
22b. (2 points) Calculate the Return on Assets Ratio for the current year. You must include calculations to receive credit for your answer.(NI) 0 0 0 0 0 0 0
22c. (2 points) Calculate the Return on Assets Ratio for the prior year. You must include calculations to receive credit for your answer. (NI) 0 0 0 0 0 0 0
23b. (2 points) Calculate the Receivables Turnover Ratio for the current year. You must include calculations to receive credit for your answer.(sales) 0 0 0 0 0 0 0
23c. (2 points) Calculate the Receivables Turnover Ratio for the prior year. You must include calculations to receive credit for your answer.(sales) 0 0 0 0 0 0 0
24b. (2 points) Calculate the Inventory Turnover for the current year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
24c. (2 points) Calculate the Inventory Turnover for the prior year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
25b. (2 points) Calculate the Debt to Total Assets Ratio for the current year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
25c. (2 points) Calculate the Debt to Total Assets Ratio for the prior year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
26b. (2 points) Compute Profit Margin for the current year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
26c. (2 points) Compute Profit Margin for the prior year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
27b. (2 points) Compute Total Asset Turnover for the current year. You must include calculations to receive credit for your answer (sales). 0 0 0 0 0 0 0
27c. (2 points) Compute Total Asset Turnover for the prior year. You must include calculations to receive credit for your answer.(sales) 0 0 0 0 0 0 0
28b. (2 points) Calculate the Average Collection Period for the current year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
28c. (2 points) Calculate the Average Collection Period for the prior year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
29b. (2 points) Calculate the Days in Inventory Ratio for the current year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
29c. (2 points) Calculate the Days in Inventory Ratio for the prior year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
30b. (2 points) Compute the Times Interest Earned Ratio for the current year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0
30c. (2 points) Compute the Times Interest Earned Ratio for the prior year. You must include calculations to receive credit for your answer. 0 0 0 0 0 0 0

Sheet2

Sheet3