Page 159 - Business Plans that Work A Guide for Small Business

Downloaded by [ Singapore Polytechnic Library 85.244.23.165] at [06/24/18]. Copyright © McGraw-Hill Global Education Holdings, LLC. Not to be redistributed or modified in any way without permission.
debt providers to dissect and analyze the financials in great detail.
academic semester as new kids sign up for the service and then
another spike in May for summer storage. Expect investors and
the income sheet for five years, breaking out the first two years
by month. As you look at the monthly projections you can see
the seasonality in this business. Spikes at the beginning of each
They may also perform scenario analysis on these financials.
After laying out all the revenue and cost drivers, show
Five-Year Income Statement (detailed for first 18 months)
Dec Year 1 Semester Jun May Apr Mar Feb Jan Semester 8 8 0 0 $653,121 $392,333 $10,962 $179,548 $26,079 $23,886 $108,470 $43,388 $260,788 $43,618 $606,641 $386,040 $13,787 $215,072 $22,060 $19,303 $33,091 $82,782 $220,601 $44,119 $204,392 $122,588 $10,397 $10,861 $4,623
Nov $21,694 $16,546 $7,631 $7,631 $24,225 $77,726 $77,726 $38,785 $38,785 $38,941 50% $17,710 $18,117 $12,122 $12,122 $45,722 $105,844 $27,359 $3,541 $2,403 $139,148 ($100,207) -129%
Oct $21,694 $16,546 $11,446 $11,446 $31,977 $93,109 $93,109 $46,461 $46,461 $46,648 50% $17,710 $18,117 $12,122 $12,122 $45,722 $105,844 $27,359 $3,541 $2,428 $139,172 ($92,524) -99%
Sept $108,470 $82,728 $38,141 $38,141 $24,225 $291,731 $291,731 $145,574 $145,574 $146,157 50% $17,710 $18,117 $12,122 $12,122 $52,722 $112,844 $27,359 $3,541 $2,452 $146,196 ($39) 0%

Aug July 8 0 $54,350 $10,962 $46,878 $13,787 $15,262 $15,262 $11,628 $143,379 $24,749 $143,379 $24,749 $65,903 $6,707 $65,903 $6,707 $77,476 $18,042 54% 73% $17,710 $17,710 $18,117 $18,117 $12,122 $12,122 $12,122 $12,122 $59,722 $59,722 $119,844 $119,844 $27,359
10.3 Income Statement Exhibit 10.7 Part A: Year 1 T otal number of owned stores T otal number of franchises Syracuse total Wisconsin total Additional owned stores Owned store contribution Franchise fees Franchise contribution Gross profit % Additional owned stores Owned store taxes Owned store interest Corporate interest N

Revenue Boston Colorado Franchise Franchise % T otal revenue Owned stores COGS T otal COGS Gross profit Expenses Owned store SG&A Syracuse Wisconsin Boston Colorado Owned store S
150