60.1K

Verified Solution

Link Copied!

Hello I was wondering where I can find this information on a companies k10 reports

EXCEL (8 points) Every student INDIVIDUALLY is required to prepare an Excel spreadsheet including all of the numerical data used in this part of the project. All dollar amounts should be well labeled and should be included together with all the values needed to calculate the ratios. The ratio calculations must use formulas and may only include cell references; there should be no dollar amounts typed into the formulas. Students must complete this INDEPENDENTLY. Any indication of excessive sharing will result in a zero for the entire project for all students on the team.

• In the most recent year, how much cash does Company A have?

• In the most recent year, how much does Company A have in net accounts receivable?

• In the most recent year, how much does Company A have for allowance for doubtful

  accounts?

• In the most recent year, how much does Company A have in inventory?

• Compute Company As and Company Bs accounts receivable turnover for the last two

  years.

• Compute Company As and Company Bs inventory turnover for the last two years.

• Compute Company As and Company Bs current ratio for the last two years.

• Compute Company As and Company Bs debt to equity ratio for the last two years.

• Compute Company As and Company Bs asset turnover for the last two years.

• Compute Company As and Company Bs profit margin on sales for the last two years.

• Compute Company As and Company Bs rate of return on assets for the last two years.

Answer & Explanation Solved by verified expert

See Answer