Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Calculate the Days Sales Outstanding, Inventory Holding Period, and Payables Deferral Period for the Sunset Company based on the following financial statements using the 2

image text in transcribed

Calculate the Days Sales Outstanding, Inventory Holding Period, and Payables Deferral Period for the Sunset Company based on the following financial statements using the 2 step methodology (i.e calculate the turnover ratios first, then the periods). Then check your answer by using the Direct Method. Assume a 365 day year for your calculations. The problem should be solved using Excel with cell references used to calculate your answers-no unnecessary hard coding! Sunset Company 2017 Income Statement Sunset Company Balance Sheet Revenue COGS Gross Profit 14,750 11,375 3,375 Cash A/R Inventory Total Current Assets 12/31/2017 12/31/2016 250 3,782 1,273 5,305 200 3,368 1,401 4,969 SG&A Expense Depreciation Operating Income 2,625 392 358 Net Fixed Assets Total Assets 12,672 17,641 11,575 16,880 Non-Operating Expenses 80 Liabilities & Equi A/P Other Current Liab Total Current Liabilities Income Before Taxes ncome Tax 278 56 2,025 1,985 4,010 1,795 1,676 3,471 Net Income Long Term Debt 5,450 450 Equity Total Liab. & Equit 8,181 17,641 16,880

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Financial Management Theory And Practice

Authors: Prasanna Chandra

9th Edition

9339222571, 978-9339222574

More Books

Students also viewed these Finance questions

Question

Identify the different methods employed in the selection process.

Answered: 1 week ago

Question

Demonstrate the difference between ability and personality tests.

Answered: 1 week ago