Question

In: Accounting

calculate percent of total assets. Please show excel calculations. Common Size Balance Sheets 12 Months Ended...

calculate percent of total assets. Please show excel calculations.

Common Size Balance Sheets 12 Months Ended
Consolidated Balance Sheets - USD ($) $ in Thousands Dec. 31, 2018 % of Total assets Dec. 31, 2017 % of Total assets
Current assets
Cash and cash equivalents $                   26,642 $                235,336
Receivables (net of allowance for doubtful accounts of $15,905 and $12,221, respectively) $                138,018 $                125,870
Income taxes receivable $                   10,122 $                                -  
Notes receivable, net of allowances $                   36,759 $                   13,256
Other current assets $                   32,243 $                   25,967
Total current assets $                243,784 $                400,429
Property and equipment, at cost, net $                127,535 $                   83,374
Goodwill $                168,996 $                   80,757
Intangible assets, net $                271,188 $                100,492
Notes receivable, net of allowances $                   83,440 $                   80,136
Investments, employee benefit plans, at fair value $                   19,398 $                   20,838
Investments in unconsolidated entities $                109,016 $                134,226
Deferred income taxes $                   30,613 $                   27,224
Other assets $                   84,400 $                   67,715
Total assets $           1,138,370 $                995,191

Solutions

Expert Solution

Formula you should be using is .. amount for the balance sheet line item/Total asset for that year..

I have given the final answer as well as picture.. If you refer the picture and put your question in same raw and column as i have and apply the formula highlighted in yellow.. you will get the solution..

let me know if you need any clarification.. do provide positive rating..

Common Size Balance Sheets 12 Months Ended
Consolidated Balance Sheets - USD ($) $ in Thousands Dec. 31, 2018 % of Total assets Dec. 31, 2017 % of Total assets
Current assets
Cash and cash equivalents 26,642 2.34% 235,336 23.65%
Receivables (net of allowance for doubtful accounts of $15,905 and $12,221, respectively) 138,018 12.12% 125,870 12.65%
Income taxes receivable 10,122 0.89% 0 0.00%
Notes receivable, net of allowances 36,759 3.23% 13,256 1.33%
Other current assets 32,243 2.83% 25,967 2.61%
Total current assets 243,784 21.42% 400,429 40.24%
Property and equipment, at cost, net 127,535 11.20% 83,374 8.38%
Goodwill 168,996 14.85% 80,757 8.11%
Intangible assets, net 271,188 23.82% 100,492 10.10%
Notes receivable, net of allowances 83,440 7.33% 80,136 8.05%
Investments, employee benefit plans, at fair value 19,398 1.70% 20,838 2.09%
Investments in unconsolidated entities 109,016 9.58% 134,226 13.49%
Deferred income taxes 30,613 2.69% 27,224 2.74%
Other assets 84,400 7.41% 67,715 6.80%
Total assets 1,138,370 100.00% 995,191

100.00%


Related Solutions

Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets...
Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of January 31, 2015 and February 1, 2014. (Round your answers to one decimal place.) ($ millions) January 31, 2015 February 1, 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 2,625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders’ investment Accounts...
PLEASE SHOW CALCULATIONS 2017 2018 BALANCE SHEETS: Assets: Cash 74,181 66,301 Accounts Receivable     35,673 48,995...
PLEASE SHOW CALCULATIONS 2017 2018 BALANCE SHEETS: Assets: Cash 74,181 66,301 Accounts Receivable     35,673 48,995 Inventory 4,855 3,986 Other Current Assets 13,936 12,057 Fixed Assets, net 33,783 41,304 Investments 212,891 233,082 Total Assets    375,319 405,725 Liabilities and Equity: Accounts Payable    44,242 55,888 Other Current Liabilities     50,226 55,416 Long-Term Debt 103,703 102,519 Other Non-current Liabilities   43,251 48,209 Common Stock 35,567 33,293 Retained Earnings   98,330 110,400 Total Liabilities and Equity   375,319 405,725 INCOME STATEMENT: FY 2018 Revenue 265,595 Cost of...
A common size balance sheet expresses the balance sheet items as a percentage of total assets....
A common size balance sheet expresses the balance sheet items as a percentage of total assets. Select one: True False
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
Complete the​ common-size balance sheet for these companies. Review each​ company's percentages of total assets. Are...
Complete the​ common-size balance sheet for these companies. Review each​ company's percentages of total assets. Are these companies operating with similar philosophies or in similar​ industries? What appears to be the major difference in financing for these two​ companies? % of % of % of % of Balance Total Balance Total Balance Total Balance Total ASSETS Co. 1 Assets Co. 2 Assets LIABILITIES Co. 1 Assets Co. 2 Assets Current assets Current liabilities Cash $5,304 % $291 % Accounts payable...
4. common-size _______ computes all account as percent of total asset. a. balance sheet b. income...
4. common-size _______ computes all account as percent of total asset. a. balance sheet b. income statement c. standardized statements d. both A&B 5. Ratios allow for better comparison _____ and ______. a. internally, externally b. through time, between company c. same industry, different industry d. Both a&b 6. whicih of the following is/are the typical categories of finance ratio? a. non liquidity ratio b. finance leverage ratio c. profitbility ratio d. market calue ratio 7. which of the following...
Please calculate 2020,2021,2022 common sized and leave formula. PROJECTED BALANCE SHEETS Common Sized Opening 2020 2021...
Please calculate 2020,2021,2022 common sized and leave formula. PROJECTED BALANCE SHEETS Common Sized Opening 2020 2021 2022 2020 2021 2022 ASSETS Current Assets Cash $       125,000 $       125,000 $       125,000 $       125,000 Accounts Recievable              89,260            115,452            152,877 Inventory              30,736              28,863              38,219 Prepaid and Other Assets                   219                   274                   329      Total Current Assets            245,215            269,589            316,425 Long Lived Assets Property, Plant and Equipment                   500                   550                   750...
AMERICAN APPAREL: DROWNING IN DEBT?1 Prepare the company’s common-size balance sheets and common-size income statements for...
AMERICAN APPAREL: DROWNING IN DEBT?1 Prepare the company’s common-size balance sheets and common-size income statements for the recent three years 2011-2013 (including all subtotals and totals and round to 2 numbers after the decimal). Analyze three major components based on the common-size balance sheets and the trends of those components over the three years. Analyze two major components based on the common-size income statements and the trends of those components over the three years. Use 10.00% as a threshold.
Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of February...
Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of February 3, 2018 and January 28, 2017. ($ millions) February 3, 2018 January 28, 2017 Assets Cash and cash equivalents $2,643 $2,512 Inventory 8,657 8,309 Other current assets 1,264 1,169 Total current assets 12,564 11,990 Property and equipment, net 25,018 24,658 Other noncurrent assets 1,417 783 Total assets $38,999 $37,431 Liabilities and shareholders’ investment Accounts payable $8,677 $7,252 Accrued and other current liabilities 4,254 3,737...
Please show all calculations in MS Excel. No credit will be earned unless you show your...
Please show all calculations in MS Excel. No credit will be earned unless you show your calculations. Problem 1: CAPM: 5-Points: If the risk-free rate is 0.0200, the return of the market is 0.1350, and the beta is 1.18, what is the required rate of return of the stock using the CAPM equation? Please note that the return of the market is not the same as the market risk premium. Problem 2: Growth Rate: (Equation 9.11, page 373): 5-Points: If...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT