Purchase Solution

Excel format for income statement

Not what you're looking for?

Ask Custom Question

Can some one please review the attached schedule and make any format changes. Also, can someone please tell me if I calculated the percentage of sales correctly.

YTD Income Statement Overall Analytical
ABC COMPANY
Q2: 6/23/2007
(In Thousands) YTD PY Variance
YTD 6/23/2007 2007 % of Sales YTD 6/23/2006 2006 % of Sales Fav / (Unfav) % Fav / (Unfav)
Revenues
Sales 400,000 99.3% 300,000 100.0% 100,000 33%
Provision for Doubtful Accounts (15,000) -3.7% (12,000) -4.0% (3,000) 25%
Sales net of provision 385,000 95.5% 288,000 96.0%
Whole Ownership Sales net of provision 3,000 0.7% - 0.0% 3,000 100%
Provision for Doubtful Accounts 300 0.1% - 0.0% 300 100%
Whole Ownership Sales net of provision 3,300 0.8% - 0.0%
Gain on sale of receivables 800 0.2% 1,000 0.3% (200) (20%)
Interest 22,000 5.5% 16,000 5.3% 6,000 38%
Interest income - Amortization of Retained Interest 5,000 1.2% 5,000 1.7% - 0%
Resort & Other 58,000 14.4% 50,000 16.7% 8,000 16%
Total Revenues 474,100 117.6% 360,000 120.0%

Costs & Expenses
SG&A, other
Cost of Sales 120,000 29.8% 82,000 27.3% (38,000) (46%)
Whole Ownership Cost of Sales 1,000 0.2% - 0.0% (1,000) 100%
Sales & Marketing 156,000 38.7% 129,000 43.0% (27,000) (21%)
Whole Ownership Sales & Marketing 5,000 1.2% - 0.0% (5,000) 100%
Resort & Other 48,000 11.9% 39,000 13.0% (9,000) (23%)
Selling, general & administrative 48,000 11.9% 41,000 13.7% (7,000) (17%)
Total selling, general, administrative & other 378,000 93.8% 291,000 97.0%
Depreciation 9,000 2.2% 7,000 2.3% (2,000) (29%)
Amortization 1,000 0.2% 0.0% (1,000) 100%
Deprreciation & Amortization 10,000 2.5% 7,000 2.3%
Operating Income 86,100 21.4% 62,000 20.7%

Unconsolidated JV's:
EBITDA 9,000 2.2% 8,000 2.7% (1,000) (13%)
Depreciation & Amortization 1,000 0.2% 1,000 0.3% - 0%
Gross Interest Expense 1,000 0.2% 1,000 0.3% - 0%
Equity earnings in unconsolidated JV's 7,000 1.7% 6,000 2.0%

- - #DIV/0!
Starwood intercompany interest 10,000 2.5% 6,000 2.0% (4,000) (67%)
Net interest expense 10,000 2.5% 6,000 2.0%
Gain (loss) on asset dispositions and impairments, net 1,000 0.2% (11,000) -3.7% (12,000) 109%
Pre-Tax Income 104,100 25.8% 63,000 21.0%

Income tax expense 47,000 11.7% 19,000 6.3% (28,000) (147%)

Net Income 57,100 14.2% 44,000 14.7%
0.0% 0.0%
Cumulative Effect of a Change in Accounting Principle, net of tax - 0.0% 72,000 24.0% 72,000 100%

Net Income After Effect of Change in Accounting Principle 57,100 14.2% (28,000) -9.3%

Attachments
Purchase this Solution

Solution Summary

The following posting helps with a problem that incomes an income state format and calculation.

Purchase this Solution


Free BrainMass Quizzes
Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Situational Leadership

This quiz will help you better understand Situational Leadership and its theories.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.