YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR T-5 4/1/Y0- 8/1/Y0- 8/1/Y1- 8/1/Y2- 8/1/Y3- 8/1/Y4-...

Transcribed Image Text:

YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR T-5 4/1/Y0- 8/1/Y0- 8/1/Y1- 8/1/Y2- 8/1/Y3- 8/1/Y4- 7/31/YO 7/31/Y1 7/31/Y2 7/31/Y3 7/31/Y4 7/31/Y5 Sales 552,000 1,656,000 2,000,000 2,800,000 2,968,000 3,146,080 (Growth rates) 20.8% 40.0% 6.0% 6.0% Income Statements Sales - COGS Historical Projected Projected Projected 552,000 1,656,000 2,000,000 2,800,000 2,968,000 3,146,080 -386,400 -1,159,200 -1,400,000 -1,960,000 -2,077,600 Projected Projected -2,202,256 -Wages and commissions -105,800 -317,400 -383,333 -536,667 -568,867 -602,999 - Rent, miscellaneous, and insurance -47,840 -111,780 -135,000 -189,000 -200,340 -212,360 - Depreciation -4,600 -5,796 -5,630 -6,800 -9,520 -10,091 Earnings before interest and taxes (EBIT) 7,360 61,824 76,036 107,533 111,673 118,374 - Interest expense -988 0 0 0 0 -22,664 Earnings before taxes 6,372 61,824 76,036 107,533 111,673 95,709 - Taxes 0 -18,547 -22,811 -32,260 -33,502 -28,713 Net income 6,372 43,277 53,225 75,273 78,171 66,997 - Dividends -6,487 -65,403 -20,125 0 -288,649 -63,460 Retained earnings -115 -22,126 33,100 75,273 -210,477 3,537 YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR T-5 4/1/Y0- 8/1/Y0- 8/1/Y1- 8/1/Y2- 8/1/Y3- 8/1/Y4- 7/31/YO 7/31/Y1 7/31/Y2 7/31/Y3 7/31/Y4 7/31/Y5 Sales 552,000 1,656,000 2,000,000 2,800,000 2,968,000 3,146,080 (Growth rates) 20.8% 40.0% 6.0% 6.0% Income Statements Sales - COGS Historical Projected Projected Projected 552,000 1,656,000 2,000,000 2,800,000 2,968,000 3,146,080 -386,400 -1,159,200 -1,400,000 -1,960,000 -2,077,600 Projected Projected -2,202,256 -Wages and commissions -105,800 -317,400 -383,333 -536,667 -568,867 -602,999 - Rent, miscellaneous, and insurance -47,840 -111,780 -135,000 -189,000 -200,340 -212,360 - Depreciation -4,600 -5,796 -5,630 -6,800 -9,520 -10,091 Earnings before interest and taxes (EBIT) 7,360 61,824 76,036 107,533 111,673 118,374 - Interest expense -988 0 0 0 0 -22,664 Earnings before taxes 6,372 61,824 76,036 107,533 111,673 95,709 - Taxes 0 -18,547 -22,811 -32,260 -33,502 -28,713 Net income 6,372 43,277 53,225 75,273 78,171 66,997 - Dividends -6,487 -65,403 -20,125 0 -288,649 -63,460 Retained earnings -115 -22,126 33,100 75,273 -210,477 3,537