Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

provide trend analysis and red flag analysis Gross Profit Margin= Gross Profit/Net Sales Gross Profit Margin: (3 years) Year Gross Profit Net Sales 2013 1

provide trend analysis and red flag analysis
image text in transcribed
image text in transcribed
Gross Profit Margin= Gross Profit/Net Sales Gross Profit Margin: (3 years) Year Gross Profit Net Sales 2013 1 $306,383 $310,807 $280,490 Gross Profit Margin 66.98% 67.99% 56.12% 2012 2011 1 $457433 $457,164 $424,200 1 Gross Profit Margin: 2013-2012 2013 1/tumover 2012 [/turnover Gross Profit $306, 383 $310,807 0.67 0.68 Net Sales $457,433 $457,164 Changes in GPM & NS -$4,424 -1.42% decrease $269 0.06% increase *-4,424/310,807 -1.42% ** 269/457,164 -0.06% AND percent decrease in the Gross Profit Margin = (0.67-0.68)/0.68 =-1.48%|| Account Receivable Turnover Ratio: 2012-2011 2012 1/turnover 2011 I/turnover Gross Profit $310,807 $280,490 0.68 0.66 Net Sales $457164 $424,200 Changes in GPM & NS $30,317 10.81% increase $32,964 7.77% increase *30,317/280,490 = 10.81% ** 32,964/424,200 - 7.77% AND percent increase in the Gross Profit Margin = (0.68-0.66)/0.66 = 2.82% AND percent increase in the Gross Profit Margin = (0.67-0.66)/0.06 = 1.30% Trend Analysis missing Number of Days' Sales in Inventory and Inventory Turnover ratio were not able to be calculated because Bankrate does not have inventory as accustomed. EBITDA-Net Income + Interest + Taxes + (Depreciation + Amortization ("D &A")) Year Net Income .. Taxes .. | D&A EBITDA 2013 . .. 60127 Interest $24,981 $25,771 $31,786 -$10,002 $29,331 $13,422 -5439 7497 2012 .. 52854 - 69,667 115,453 67,488 2011 5588 43536 Adjusted EBITDA 2011 2013 $69,667 2012 $115,453 EBITDA $67 AB8 16,065 -2,645 292 Change in fair value of contingent liabilities Loss on extinguishment of debt 17,175 0 16,629 0 874 0 50 335 44,248 Legal settlements Acquisition, offering and related expenses and related party fees CEO Transition Restructuring charges Stock-based compensation Adjusted EBITDA 6,802 0 0 0 0 1,272 12,148 9,120 5,509 $121,907 $123,137 $135,438 2013 2012 Adjusted EBITDA Changes in Adjusted EBITDA -1,230 -1.00% decrease 121,907 123,137 2012 2011 Adjusted EBITDA Changes in Adjusted EBITDA - 12,301 -9.08% decrease 123,137 135,438 -1,230/123,137= -1.00% **-12,301/135,438 = -9.08% AND percent decrease in the Adjusted EBITDA=(-0.01--0.09))-0.09 --89.00%

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

Operational Auditing Principles And Techniques For A Changing World

Authors: Hernan Murdock

2nd Edition

1000388247, 9781000388244

More Books

Students also viewed these Accounting questions