Sample Company Revenue Account Analysis   Select an account: Select an account 400MB, Sales-Books 400MC, Sales-Clothing Items 400MM, Sales, Magazine Singles 400MT, Sales-Audio 400MX, Sales-Other Items 400MZ, Sales, Audio-MP3, download 400SA, Sales-Art 400SB, Sales-Books 400SC, Sales-Clothing Items 400SM, Magazine, Single Issue 400ST, Magazine, Single Issue 400SX, Sales-Other Items 400SZ, Sales-Audio-MP3 402Z1, MHA-Audio-cd 402Z2, MHA-Audio-cassette 402Z3, MHA-Audio-EntireConference 402Z9, MHA-other 406A0, Interest Income 408A0, Other Income 430SS, Rental - Symposium Table 440SS, Registration Fees 441SS, Registration, Banquet 442SS, Workshop Registration 444SS, Underwriting Income 448P0, Royalties 454A0, Finance Charge Income 455A0, Shipping Charges 455M0, Shipping Charges 455SS, Shipping 460CE, Donations, Endowment 460CG, Donations, General 460CS, Donations, Special 462CS, Donations, Angels 464CE, Bequest 465C1, Membership, Level 1 465C2, Membership, Level 2 470P0, Advertising 470SS, Advertising 471P0, Subscription, New 471P2, Subscription, International 472P0, Subscription, Renewal 480PO, Contest - Income 490M0, Sales Discounts   Account selected:     472P0, Subscription, Renewal Desc. Total Mo.1 Mo.2 Mo.3 Mo.4 Mo.5 Mo.6 Mo.7 Mo.8 Mo.9 Mo.10 Mo.11 Mo.12 Budget $23,633 $1,174 $1,697 $1,697 $3,977 $3,977 $1,697 $1,697 $3,977 $2,784 $956     2008 $27,454 $1,354 $1,058 $4,859 $1,338 $256 $4,034 $2,068 $1,213 $1,435 $8,104     2007 $26,514 $1,902 $6,740 $1,573 $2,734 $4,199 $991 $4,788 $2,396 $885 $306     Graph:
N O T E S Renewal dollar amounts are based upon the actual number of subscribers who subscription is expiring on each new magazine mailing cycle. We then apply a rate of renewal (%) and an average of issues (number of issues) as extracted from our database. These numbers are calculated in an MS Excel file to produce a month by month estimate of collections. The budget assumes 6 mag issues to press in 2008 and 2009. There will be a serious decline in renewals in 2009.