Question: Balance sheet analysis Complete the balance sheet and sales information that follows using the following financial data: Debt Ratio: 50% Current ratio:1.8x Total assets turnover:1.5x

Balance sheet analysis Complete the balance sheet and sales information that follows using the following financial data:

Debt Ratio: 50%

Current ratio:1.8x

Total assets turnover:1.5x

Days sales outstanding: 36.5 days

Gross profit margin on sales: (Sales-Cost of goods sold)/Sales=25%

Inventory turnover ratio:5x

Calculation is bases on a 365-dayyear.

Balance sheet analysis Complete the balance sheet and sales info

Balance Sheet Cash Accounts receivable Inventories Fixed assets Total assets Sales Accounts payable Long-term debt 60,000 Common stock Retained earnings Total liabilities and equity Cost of goods sold 97,500 $300,000

Step by Step Solution

★★★★★

3.45 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

tr msoheightsourceauto col msowidthsourceauto br msodataplacementsamecell style45 msonumberformat00220022 00000220022 00000220022 00220022 msostylenameCurrency msostyleid4 style0 msonumberformatGenera... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

68-B-A-F-S (2956).xlsx

300 KBs Excel File

Students Have Also Explored These Related Accounting Questions!

Inventory turnover is calculated as cost of goods sold divided by ending inventory . 1. True 2. False

Hi below is a problem I am having. Can you please help me answer: CASH, Total liabilities and equity, and Common stock. Please show your work. Problem 2: Balance Sheet Analysis Complete the balance...

Cost of goods sold for Harlem Tool & Die during 20X1 was $400,000. Beginning inventory was $64,000 and ending inventory was $89,000. Beginning trade accounts payable were $13,000, and ending trade...

Times-Interest- Ea rned Ratio The Forris Corporation has $450,000 of debt outstanding, and it pays an interest rate of 8% annually. Morris's annual sales are $1.8 million, its average tax rate is...

Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J . White Industries using the following financial data: Total assets turnover: 1 . 6 Gross...

1. Current and Quick Ratios The Nelson Company has $1,225,000 in current assets and $490,000 in current liabilities. Its initial inventory level is $345,000, and it will raise funds as additional...

Answer question #2. Show your work. answer question #1 naicar Problems: 1. Complete problem: Total Net Operating Capital XYZ, Inc. reported $20 million in operating current assets, $25 million in net...

A corporate finance question, please provide a detailed explanation and example. "BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...

Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for J. White Industries using the following financial data: Total assets turnover: 1.7 Gross profit...

Use the information in Exercise to prepare an October statement of owners equity for Ernst Consulting. In Exercise, On October 1, Ebony Ernst organized Ernst Consulting; on October 3, the owner...

Determine your own height in meters, and your mass in kg.

The Governor of the Bank of England is obliged to write a letter to the Chancellor of the Exchequer (the Finance Minister of the UK) to explain when it misses the inflation target. Read the Governors...

Explain three stages of human reaction to stress.

Why are High Techs returns expected to move with the economy, whereas Collections are expected to move counter to the economy?

Calculate the expected rate of return on each alternative and fill in the blanks on the row for in the previous table.

You should recognize that basing a decision solely on expected returns is appropriate only for risk-neutral individuals. Because your client, like most people, is risk-averse, the riskiness of each...

answer in a easy to read\ excel format Problem 7-21 (Algo) Segment Reporting and Decision-Making [LO7-4] Vulcan Company's contribution format income statement for June is as follows: Management is...

7. (TCO C) Leslie has been offered the choice of either a $1,000 rebate or a 5.5%, 48-month loan for the new car she is purchasing. If Leslie will be financing $15,000 and she can get a 7.5%,...

Rocky Mountain Chocolate Factory (RMCF) founder and president Frank Crail employs 220 people in 361 outlets in the United States, Canada, United Arab Emirates, Japan, and South Korea. If RMCF...