Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

can you provide the following Please use the Actuals files to prepare a comprehensive analysis of one company and write up a one or two

can you provide the following
image text in transcribed
image text in transcribed
image text in transcribed
Please use the Actuals files to prepare a comprehensive analysis of one company and write up a one or two page discussing analyzing your results. Your analysis should include several parts: Part 1: Information taken from the balance sheet: working capital amount common size balance sheet liquidity metrics leverage metrics Part 2: Information taken from the income statement additional liquidity metrics common size income statement profitability metrics Part 3: Information taken from all financial statements together cash flow identity additional profitability metrics asset utilization metrics Please provide a one or two paragraph commentary on your findings. You might discuss how your Actual firm diverges from the Benchmarks files for your firm's NAICS code category. You might discuss how the firm's choice of industry is affecting the metrics you calculated and whether any of the metrics indicate surprising or important characteristics of your Actual firm. millions current year last year $478,795 42 268 877 8.025 10,173 540.138 $320,139 38,960 5,122 4.947 19,372 388.540 145,481 218,492 412,293 461,742 1.903 1.239.911 114,367 33,288 414,841 433,843 1.825 998 164 $1.780.049 $1.386.704 7139_Planet_Fitness_Gyms_Inc. Consolidated Balance Sheet Assets Current assets Cash and cash equivalents Receivables net of allowances Inventories Prepaid expenses Other current assets Total current assets Long term assets Property, Plant and Equipment (net) Investments Deferred income taxes Intangible assets Other long term assets Total long term assets Total assets Liabilities Current liabilities Current portion of long term debt Notes payable Accounts payable Accrued liabilities Other current liabilities Total current liabilities Long term liabilities Long term notes payable Other long term debt Deferred income taxes Other long term liabilities Total long term liabilities Total liabilities Stockholders' equity Common stock Additional paid-in capital Other equity inc treasury stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 17,500 26,468 21,267 31.623 48,620 145.478 12,000 24,765 30,428 32,384 31,826 131.403 1,887,505 400,748 1.116 (282.808) 2.006.561 $2,152,039 1,160,127 404,468 2,303 237.983 1.804.881 $1,936,284 16.000 167,820 (11,934) (543.876) (371.990) 12,000 117,833 (7,803) (671610) (549.580) $1.780.049 $1.386.704 7139_Planet_Fitness_Gyms_Inc. millions Retained earnings statement Retained earnings, 1/1 Add net income Less dividends paid Retained earnings 12/31 $ (671,610) 135,413 7679 S (543.876) Consolidated income statement Net sales Less cost of goods sold (without depreciation) Gross margin Selling expenses General and administrative expenses Depreciation and amortization Operating income Interest income Other income (loss) Income before interest and taxes (EBIT) Interest expense Income before taxes Income tax expense (refund) Net income $688,803 194.449 494,354 50,153 174,725 44.346 225,130 7,053 1.846 234,029 60.852 173,177 37.764 $135,413 Please use the Actuals files to prepare a comprehensive analysis of one company and write up a one or two page discussing analyzing your results. Your analysis should include several parts: Part 1: Information taken from the balance sheet: working capital amount common size balance sheet liquidity metrics leverage metrics Part 2: Information taken from the income statement additional liquidity metrics common size income statement profitability metrics Part 3: Information taken from all financial statements together cash flow identity additional profitability metrics asset utilization metrics Please provide a one or two paragraph commentary on your findings. You might discuss how your Actual firm diverges from the Benchmarks files for your firm's NAICS code category. You might discuss how the firm's choice of industry is affecting the metrics you calculated and whether any of the metrics indicate surprising or important characteristics of your Actual firm. millions current year last year $478,795 42 268 877 8.025 10,173 540.138 $320,139 38,960 5,122 4.947 19,372 388.540 145,481 218,492 412,293 461,742 1.903 1.239.911 114,367 33,288 414,841 433,843 1.825 998 164 $1.780.049 $1.386.704 7139_Planet_Fitness_Gyms_Inc. Consolidated Balance Sheet Assets Current assets Cash and cash equivalents Receivables net of allowances Inventories Prepaid expenses Other current assets Total current assets Long term assets Property, Plant and Equipment (net) Investments Deferred income taxes Intangible assets Other long term assets Total long term assets Total assets Liabilities Current liabilities Current portion of long term debt Notes payable Accounts payable Accrued liabilities Other current liabilities Total current liabilities Long term liabilities Long term notes payable Other long term debt Deferred income taxes Other long term liabilities Total long term liabilities Total liabilities Stockholders' equity Common stock Additional paid-in capital Other equity inc treasury stock Retained earnings Total stockholders' equity Total liabilities and stockholders' equity 17,500 26,468 21,267 31.623 48,620 145.478 12,000 24,765 30,428 32,384 31,826 131.403 1,887,505 400,748 1.116 (282.808) 2.006.561 $2,152,039 1,160,127 404,468 2,303 237.983 1.804.881 $1,936,284 16.000 167,820 (11,934) (543.876) (371.990) 12,000 117,833 (7,803) (671610) (549.580) $1.780.049 $1.386.704 7139_Planet_Fitness_Gyms_Inc. millions Retained earnings statement Retained earnings, 1/1 Add net income Less dividends paid Retained earnings 12/31 $ (671,610) 135,413 7679 S (543.876) Consolidated income statement Net sales Less cost of goods sold (without depreciation) Gross margin Selling expenses General and administrative expenses Depreciation and amortization Operating income Interest income Other income (loss) Income before interest and taxes (EBIT) Interest expense Income before taxes Income tax expense (refund) Net income $688,803 194.449 494,354 50,153 174,725 44.346 225,130 7,053 1.846 234,029 60.852 173,177 37.764 $135,413

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

The Handbook Of Financial Modeling

Authors: Jack Avon

2nd Edition

1484265394, 978-1484265390

More Books

Students also viewed these Finance questions

Question

What are negative messages? (Objective 1)

Answered: 1 week ago