Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

Need answers on Excel please. Thanks Part 1. Financial Ratios Please compute the 6 ratios requested below for the Jones Company as of and for

image text in transcribed

Need answers on Excel please. Thanks

Part 1. Financial Ratios Please compute the 6 ratios requested below for the Jones Company as of and for the year ended December 31, 2019. Please refer to Illustration 5A.1 on pages 5-31 and 5-32 of our textbook for a summary of financial ratios and formulas. Compute each ratio to 2 decimal places using excel rounding. The 6 ratios you should compute are: Current ratio Accounts receivable turnover Inventory turnover Profit margin on sales Earnings per share Debt to assets ratio Compute the 6 ratios using the following data: Current assets $20,000,000 Current liabilities $ 9,250,000 Net sales $75,000,000 Accounts receivable beginning of year $ 4,000,000 Accounts receivable end of year $ 5,600,000 Cost of goods sold $52,000,000 Inventory beginning of year $ 5,400,000 Inventory end of year $ 6,900,000 Net income $ 3,650,000 Preferred dividends $ 225,000 Weighted average common shares outstding $ 500,000 Total liabilities $14,300,000 Total assets $45,000,000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions