Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please find the Ratios and Annual Data for Pandora Internet Radio as January 31, 2012, and 2013. Provide Formula or Excell work Pandora Ratio and

Please find the Ratios and Annual Data for Pandora Internet Radio as January 31, 2012, and 2013. Provide Formula or Excell work

image text in transcribed

image text in transcribed

Pandora Ratio and Annual data

January 31, 2013

January 31, 2012

Debt-to-Asset Ratio

Long-term Debt to Capital Structure

ROE- Return on Equity

ROA- Return on Assets

ROI- Return on Investment

Current Liabilities to Equity

Net Profit Margin

Return on Common Equity

EXHIBIT 1 Pandora Internet Radio Consolidated Statement of Operations (All figures in thousands except per share data) Eleven Months Ended December 31 2013 (b) 2012 (b) 489,340 110,893 600,233 343,318 46,166 389,484 314,866 230,731 41,844 356,710 243,523 28,740 259,471 130,013 29.986 169,774 70,212 16,191 94,566 43,320 154,077 (24,064) Twelve Months Ended January 31 2013 (6) 2012 (b) 2011 (a) 2010 (a) Revenue Advertising 375,218 239,957 119,333 5 0,147 Subscription and other 51,927 3 4,383 18,431 5,042 Total revenue 427,145 274,340 137,764 55,189 Cost of revenue Cost of revenue- 258,748 148,708 69,357 32,946 Content acquisition costs Cost fo revenue - Other 32,019 2 2,759 11,559 7,892 Total cost of revenue 290,767 171,467 80,916 40.838 Gross profit 136,378 102,873 56.848 14,351 Operating expenses Product development 18,118 13,425 6,736 6,026 Sales and marketing 107,715 65,010 36,250 17,426 General and 48,247 35,428 14.183 6.358 administrative Total operating expenses 174,080 113,863 57,169 29.810 Loss from operations (37,702) (10,990) (321) (15,459) Other expense (441) (5,042) (1,309) (1,294) Loss before income taxes (38,143) (16,032) (1,630) (16,753) Income tax benefit (75) (134) (expense) Net loss (38,148) Deemed dividend on Series D and Series E Accretion of redeemable convertible preferred stock Increase in cumulative dividends payable on conversion of liquidation of redeemable convert- ible preferred stock (38,148) (19,865) (11,042) (24875) common stockholders Net loss per share, basic (0.23) (0.19) (1.03) (3.84) and diluted Notes: (a) Pandora Internet Radio 2012 10-K, p. 60. (b) Pandora Internet Radio 2014 10-K, p. 74. 269,972 (26,449) (474) (26,923) (94) (401) (27,017) (16,107) (1,764) (16,753) (1,443) (110) (300) (218) (8.978) (6,461) - (27,017) (0.15) (24,462) (0.15) EXHIBIT 2 Pandora Internet Radio Consolidated Balance sheets (All figures in thousands except share data) As of January 31, As of January 31, As of January 31, As of December 2013 (b) 2012 (a) 2011(a) 31, 2013 (b) Assets Current Assets Cash and cash equivalents 65,725 44.126 43,048 2,45,755 Short-term investments 23,247 46,455 98,662 Accounts receivable, nct of 103,410 66,738 42,212 1,64,023 allowance Prepaid expenses and other 6,232 2,806 3,516 10,343 current assets Total current assets 198,614 160,125 88,776 5.18,783 Long-term investments 105,686 Property and equipment, net 17,758 15.576 8,683 35,151 Other long-term assets 2,460 2.314 1,750 13,715 Total assets 218,832 178,015 99,209 673335 Liabilities and stockholders' cquity Current liabilities: Accounts payable 4,471 2,053 1,965 14,413 Accrued liabilities 7,590 3.838 5,532 14,885 Accrued royalties 53,083 33.822 18,080 66.110 Deferred revenue 29,266 19.232 15,910 42.650 Accrued compensation 21,560 11,962 3,815 17.948 Current portion of long-term 6,759 debt Total current liabilities 115,970 70,907 52,061 156,006 Long-term debt 837 Preferred stock warrant liability 1,027 Other long-term liabilities 3,873 2568 1,632 9,098 Total liabilities 119,843 73,475 55,557 165,104 Redeemable convertible pre- 126,662 ferred stock Stockholders' equity: Preferred Stock, $0.0001 par value Common stock, $0.0001 16 par value Additional paid-in capital 238,552 205.955 2.308 675,103 Accumulated deficit (139,574) (101,426) (85,319) (166,591) Accumulated other compre- (301) hensive loss Total stockholders' cquity 98.989 104540 (83,010) 508,231 Total liabilities and stockholders 218,832 178,015 99,209 673,335 equity Notes: (a) Pandora Internet Radio 2012 10-K, p. 59. (b) Pandora Internet Radio 2014 10-K, p. 73. EXHIBIT 1 Pandora Internet Radio Consolidated Statement of Operations (All figures in thousands except per share data) Eleven Months Ended December 31 2013 (b) 2012 (b) 489,340 110,893 600,233 343,318 46,166 389,484 314,866 230,731 41,844 356,710 243,523 28,740 259,471 130,013 29.986 169,774 70,212 16,191 94,566 43,320 154,077 (24,064) Twelve Months Ended January 31 2013 (6) 2012 (b) 2011 (a) 2010 (a) Revenue Advertising 375,218 239,957 119,333 5 0,147 Subscription and other 51,927 3 4,383 18,431 5,042 Total revenue 427,145 274,340 137,764 55,189 Cost of revenue Cost of revenue- 258,748 148,708 69,357 32,946 Content acquisition costs Cost fo revenue - Other 32,019 2 2,759 11,559 7,892 Total cost of revenue 290,767 171,467 80,916 40.838 Gross profit 136,378 102,873 56.848 14,351 Operating expenses Product development 18,118 13,425 6,736 6,026 Sales and marketing 107,715 65,010 36,250 17,426 General and 48,247 35,428 14.183 6.358 administrative Total operating expenses 174,080 113,863 57,169 29.810 Loss from operations (37,702) (10,990) (321) (15,459) Other expense (441) (5,042) (1,309) (1,294) Loss before income taxes (38,143) (16,032) (1,630) (16,753) Income tax benefit (75) (134) (expense) Net loss (38,148) Deemed dividend on Series D and Series E Accretion of redeemable convertible preferred stock Increase in cumulative dividends payable on conversion of liquidation of redeemable convert- ible preferred stock (38,148) (19,865) (11,042) (24875) common stockholders Net loss per share, basic (0.23) (0.19) (1.03) (3.84) and diluted Notes: (a) Pandora Internet Radio 2012 10-K, p. 60. (b) Pandora Internet Radio 2014 10-K, p. 74. 269,972 (26,449) (474) (26,923) (94) (401) (27,017) (16,107) (1,764) (16,753) (1,443) (110) (300) (218) (8.978) (6,461) - (27,017) (0.15) (24,462) (0.15) EXHIBIT 2 Pandora Internet Radio Consolidated Balance sheets (All figures in thousands except share data) As of January 31, As of January 31, As of January 31, As of December 2013 (b) 2012 (a) 2011(a) 31, 2013 (b) Assets Current Assets Cash and cash equivalents 65,725 44.126 43,048 2,45,755 Short-term investments 23,247 46,455 98,662 Accounts receivable, nct of 103,410 66,738 42,212 1,64,023 allowance Prepaid expenses and other 6,232 2,806 3,516 10,343 current assets Total current assets 198,614 160,125 88,776 5.18,783 Long-term investments 105,686 Property and equipment, net 17,758 15.576 8,683 35,151 Other long-term assets 2,460 2.314 1,750 13,715 Total assets 218,832 178,015 99,209 673335 Liabilities and stockholders' cquity Current liabilities: Accounts payable 4,471 2,053 1,965 14,413 Accrued liabilities 7,590 3.838 5,532 14,885 Accrued royalties 53,083 33.822 18,080 66.110 Deferred revenue 29,266 19.232 15,910 42.650 Accrued compensation 21,560 11,962 3,815 17.948 Current portion of long-term 6,759 debt Total current liabilities 115,970 70,907 52,061 156,006 Long-term debt 837 Preferred stock warrant liability 1,027 Other long-term liabilities 3,873 2568 1,632 9,098 Total liabilities 119,843 73,475 55,557 165,104 Redeemable convertible pre- 126,662 ferred stock Stockholders' equity: Preferred Stock, $0.0001 par value Common stock, $0.0001 16 par value Additional paid-in capital 238,552 205.955 2.308 675,103 Accumulated deficit (139,574) (101,426) (85,319) (166,591) Accumulated other compre- (301) hensive loss Total stockholders' cquity 98.989 104540 (83,010) 508,231 Total liabilities and stockholders 218,832 178,015 99,209 673,335 equity Notes: (a) Pandora Internet Radio 2012 10-K, p. 59. (b) Pandora Internet Radio 2014 10-K, p. 73

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_2

Step: 3

blur-text-image_3

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

Financial Accounting Reporting Analysis And Decision Making

Authors: Shirley Carlon, Rosina Mcalpine, Chrisann Lee, Lorena Mitrione, Ngaire Kirk, Lily Wong

7th Edition

0730395294, 978-0730395294

More Books

Students also viewed these Accounting questions