Question

In: Finance

Analyze the Average Collection Period Based on the table Average Collection Period 2017 2018 2019 Kilroy...

Analyze the Average Collection Period Based on the table

Average Collection Period

2017

2018

2019

Kilroy Realty Corporation

124d

130d

147d

Cushman & Wakefield

4d

2d

4d

Progressive Real Estate

10d

7d

6d

Analyze the Fixed Asset Turnover based on the table

Fixed Asset Turnover

2017

2018

2019

Kilroy Realty Corporation

5.7

4.5

8.1

Cushman & Wakefield

1.2

1.3

1.2

Progressive Real Estate

1.2

1.1

1.1

Analyze Debt to Asset Ratio based on the table

Debt to Asset Ratio

2017

2018

2019

Kilroy Realty Corporation

34.50%

37.76%

39.92%

Cushman & Wakefield

49.04%

51.67%

37.13%

Progressive Real Estate

8.54%

9.46%

8.03%

Solutions

Expert Solution

1) Average Receivables= (Account Receivables/ (Net Sales/365))

The average collection period is the average number of days between the dates that credit sales were made, and the dates that the money was received/collected from the customers.

The average collection period is also referred to as the days' sales in accounts receivable.

Lower the Average Collection period it is good for the company as it will have proper working capital.

Thus looking at the numbers wecan see that Cushman & Wakefield is doing great in terms of average collection period and Kilroy Realty Corporation is doing worst in it the maximum it has is in 2019.

2) Fixed Asset Turn over Ratio

The fixed asset turnover ratio is an efficiency ratio calculated by dividing a company's net sales by its Fixed Assets (property, plant, and equipment - depreciation).

It measures how well a company generates sales from its Fixed Assets.

Higher the fixed asset turnover ratio better is the company

Thus analysing the numbers that are given we have Kilroy Realty Corporation having maximum fixed asset turnover ratio as comoared with the competitors mentioned

Progressive Real Estate having lowest fixed asset turn over ratio among competitors .

3) Debt to asset Ratio

The debt to asset ratio, or total debt to total assets, measures a company's assets that are financed by liabilities, or debts, rather than its equity

This ratio can be used to measure a company's growth through its acquired assets over time.

A lower debt-to-asset ratio suggests a stronger financial structure, just as a higher debt-to-asset ratio suggests higher risk.

Thus from the table given we have Cushman & Wakefield having maximum debt to asset ratio throughout and Progressive Real Estate with lower ratio thus Progressive Real Estate is doing goods as compared to its competitors


Related Solutions

Provide calculations and show steps for each: Average Collection Period Average Accounts Receivables/Net Credit Sales 2018...
Provide calculations and show steps for each: Average Collection Period Average Accounts Receivables/Net Credit Sales 2018 = 11,721/79,040 = 2019 = 12,046/90,621 = Total Asset turnover Net Sales/Average Total Assets 2018 = 90,621/118,007 = 2019 = 79,040/124,193 = Debt Ratio Total Debt/Total Assets 2018 = 53,521/111,820 = 2019 = 51,871/124,193 = Times interest earned EBIT/Total Interest 2018 = -2,926/-2,353 = 2019 = -2,181/-2,170 =
This information is available for Pharoah Company for 2017, 2018, and 2019. 2017 2018 2019 Beginning...
This information is available for Pharoah Company for 2017, 2018, and 2019. 2017 2018 2019 Beginning inventory $ 103,000 $ 319,000 $ 414,500 Ending inventory 319,000 414,500 472,000 Cost of goods sold 892,000 1,120,500 1,306,000 Net sales 1,200,000 1,605,500 1,903,000 Calculate inventory turnover for Pharoah Company for 2017, 2018, and 2019. (Round answers to 2 decimal places, e.g. 1.52.) 2017 2018 2019 Inventory turnover Calculate days in inventory for Pharoah Company for 2017, 2018, and 2019. (Round answers to 1...
an average collection period in excess of the industry average may indicate a. credit terms are...
an average collection period in excess of the industry average may indicate a. credit terms are liberal b. current assets are too small c. bad debt write-offs may occur d. collection policies are lax e. balance sheet value of accounts receivable is overstated
Based on the data below, forecast US hotel revenues for 2017, 2018, and 2019. Provide the...
Based on the data below, forecast US hotel revenues for 2017, 2018, and 2019. Provide the model developed for your calculations. YEAR REVENUE ($USD BILLION) 2001 105.00 2002 111.90 2003 118.80 2004 119.30 2005 135.50 2006 146.20 2007 153.80 2008 154.70 2009 133.30 2010 142.00 2011 153.30 2012 155.50 2013 163.00 2014 176.70 2015 189.50 2016 199.30
Zane Corporation has an inventory conversion period of 89 days, an average collection period of 39...
Zane Corporation has an inventory conversion period of 89 days, an average collection period of 39 days, and a payables deferral period of 31 days. Assume 365 days in year for your calculations. What is the length of the cash conversion cycle? Round your answer to two decimal places.   days If Zane's annual sales are $3,706,915 and all sales are on credit, what is the investment in accounts receivable? Do not round intermediate calculations. Round your answer to the nearest...
A firm has days' sales in an inventory of 105 days, an average collection period of...
A firm has days' sales in an inventory of 105 days, an average collection period of 35 days, and takes 42 days, on average, to pay its accounts payable. Taken together, what do these three figures imply about the firm's operations and its cash flows?
Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2017, 2018, and 2019
1. Calculating inflation using a simple price index Consider a fictional price index, the College Student Price Index (CSPI), based on a typical college student's annual purchases. Suppose the following table shows information on the market basket for the CSPI and the prices of each of the goods in 2017, 2018, and 2019. The cost of each item in the basket and the total cost of the basket are shown for 2017. Perform these same calculations for 2018 and 2019, and enter the...
Company Inventory Conversion Period, days Average Collection Period, days Payables Deferral Period, days Cash Conversion Cycle,...
Company Inventory Conversion Period, days Average Collection Period, days Payables Deferral Period, days Cash Conversion Cycle, days Adidas 112 27 57 82 Puma 107 18 49 Nike 128 20 43 105 Under Armor 89 24 21 1)calculate CCC for Puma and UA. 2)pick any 1 company of the 4: how its operational liquidity stands versus competitors (other 3 firms)? how can this company improve its liquidity? What are possible risks/limitations to your proposed changes?
Based on the data below, with a collection period of 60 days what are cash collections...
Based on the data below, with a collection period of 60 days what are cash collections in Q2? (format $xxx as needed, no cents) Beginning A/R $335 a. Collection Period 45 b. Collection Period 60 c. Collection Period 30 Sales: Q1 $545 Q2 $598 Q3 $575 Q4 $795
KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018...
KORBIN COMPANY Comparative Income Statements For Years Ended December 31, 2019, 2018, and 2017 2019 2018 2017 Sales $ 446,549 $ 342,093 $ 237,400 Cost of goods sold 268,822 213,808 151,936 Gross profit 177,727 128,285 85,464 Selling expenses 63,410 47,209 31,337 Administrative expenses 40,189 30,104 19,704 Total expenses 103,599 77,313 51,041 Income before taxes 74,128 50,972 34,423 Income tax expense 13,788 10,449 6,988 Net income $ 60,340 $ 40,523 $ 27,435 KORBIN COMPANY Comparative Balance Sheets December 31, 2019, 2018,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT