Question

Home Insert Draw Page Layout Formulas Data Review View percentage 29 ES 2 Calibri (Body) 12 A A * BLUE OA 13 Conditional Formatting Format as Table Cell Styles 2 Insert Delete Format 5 % + Recover Unsaved Workbooks. We were able to save changes to one or more files. Do you want to recover them? X f x -'BS V&H'ID47 E4 Effective management of assets is critical for most companies. Investment in assets is needed to drive revenue growth. Identify the makeup of your company's nexurrent asset accounts Y non current asset accounts 1 and analyze the changes that occurred during the most recent accounting period Current Year Prior Year Schance X Change 3 Property and equipment, net 5 4,454 S 3,989 $ 465 11.66%... all these rows, each column, should be linked to BS or IS VEH 4 intangibles, net 285 283 (261) 8.13% analysis. The rows/columns that are prefilled with amounts should 5 Goodwill 154 139 15 10.79% be used as subtraction in formula for 64 & 04 (because on the 6 Other assets 2509 277 278) 9.97XIV worksheets, this one row contains these amounts and we 7 Total noncurrent assets $ 2,948 $ 3,209 S 542) 13.14% want to separate them, not double count). CHECK YOUR "total 8 Total assets S 15.134 $ 16,061 $ 5 1927 .7xnoncurrent assets" balance, does it agree VAH? 9 Sales revenue Be smart least amount of formulas, maximum amount of 10 Net Income 1,933 4,240 2.107 541 linking for efficiency and accuracy. Think before you execute. What is the composition of the company's "property & equipment, et in terms of types of assets can include but not required)? What is Accumulated Depreciation balance, current 11 year? Where did you find this information? answer all questions type narrative here) 13 WNch depreciation method(s) does your company use? Where did you find this polley? type narrative here] Not required F18 Did the company sell any Property or Equipment during current year? #yes, did they reporta 15 gain or loss? (one. Es displays all this info, which one? type arrative here! 17 Calculate the ratios identified below for current year and compare to Industry average 18 Complete the analysis below (fill in blanks or select correct item) Checklist 1. Asset Mngmt 2. Deprin Schedule IS V& H Ready B S V&H Reuters Industry 16mar2019 Slide 8-16 gait

Answer 1

1. Total Asset Turnover Ratio= Net Sales / Average total assets

= 36397/15134

= 2.4049

2. Return on assets= Net Income/ Total assets

= 1933/15134 * 100

= 12.77%

3. Depreciation method is straight line basis.