Share
Explore BrainMass

Excel format for income statement

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

Solution Summary

Formatting completed for you.

$2.19