Edit This Plan
 

Get real P&L data for your plan!

We have complete profit and loss financial data from companies like New Look, Inc..

SIC 2329 Apparel, Finished Prdcts from Fabrics & Similar Materials - Men's and boy's clothing, nec

Get Finanicals

*Reports start as low as $89

 

Clothing Manufacturer Business Plan

New Look, Inc.

This sample business plan can be edited directly in Business Plan Pro software.

previous
next
Page 1   2   3   4   5   6   7   8   9  

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
All product lines 0% $450,000 $380,000 $390,000 $390,000 $390,000 $390,000 $400,000 $440,000 $440,000 $440,000 $440,000 $450,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $450,000 $380,000 $390,000 $390,000 $390,000 $390,000 $400,000 $440,000 $440,000 $440,000 $440,000 $450,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
All product lines $126,000 $106,400 $109,200 $109,200 $109,200 $109,200 $112,000 $123,200 $123,200 $123,200 $123,200 $126,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $126,000 $106,400 $109,200 $109,200 $109,200 $109,200 $112,000 $123,200 $123,200 $123,200 $123,200 $126,000
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
All departments 0% $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,106
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 15 15 15 15 15 15 15 15 15 15 15 15
Total Payroll $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,106
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $450,000 $380,000 $390,000 $390,000 $390,000 $390,000 $400,000 $440,000 $440,000 $440,000 $440,000 $450,000
Direct Cost of Sales $126,000 $106,400 $109,200 $109,200 $109,200 $109,200 $112,000 $123,200 $123,200 $123,200 $123,200 $126,000
Other $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167
Total Cost of Sales $130,167 $110,567 $113,367 $113,367 $113,367 $113,367 $116,167 $127,367 $127,367 $127,367 $127,367 $130,167
Gross Margin $319,833 $269,433 $276,633 $276,633 $276,633 $276,633 $283,833 $312,633 $312,633 $312,633 $312,633 $319,833
Gross Margin % 71.07% 70.90% 70.93% 70.93% 70.93% 70.93% 70.96% 71.05% 71.05% 71.05% 71.05% 71.07%
Expenses
Payroll $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,106
Sales and Marketing and Other Expenses $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005
Depreciation $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Communications $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Client Relations $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Rent $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Payroll Taxes 15% $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,066
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,377
Profit Before Interest and Taxes $159,462 $109,062 $116,262 $116,262 $116,262 $116,262 $123,462 $152,262 $152,262 $152,262 $152,262 $159,457
EBITDA $161,662 $111,262 $118,462 $118,462 $118,462 $118,462 $125,662 $154,462 $154,462 $154,462 $154,462 $161,657
Interest Expense $20,375 $20,266 $20,157 $20,047 $36,602 $36,266 $35,926 $35,584 $35,239 $34,891 $34,541 $34,541
Taxes Incurred $41,726 $22,199 $24,026 $24,054 $19,915 $19,999 $21,884 $29,170 $29,256 $29,343 $29,430 $31,229
Net Profit $97,361 $66,597 $72,079 $72,162 $59,745 $59,998 $65,652 $87,509 $87,767 $88,028 $88,291 $93,687
Net Profit/Sales 21.64% 17.53% 18.48% 18.50% 15.32% 15.38% 16.41% 19.89% 19.95% 20.01% 20.07% 20.82%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $22,500 $19,000 $19,500 $19,500 $19,500 $19,500 $20,000 $22,000 $22,000 $22,000 $22,000 $22,500
Cash from Receivables $210,000 $224,250 $425,283 $361,317 $370,500 $370,500 $370,500 $370,817 $381,267 $418,000 $418,000 $418,000
Subtotal Cash from Operations $232,500 $243,250 $444,783 $380,817 $390,000 $390,000 $390,500 $392,817 $403,267 $440,000 $440,000 $440,500
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $1,000,000 $0 $0 $0 $2,000,000 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $1,232,500 $243,250 $444,783 $380,817 $2,390,000 $390,000 $390,500 $392,817 $403,267 $440,000 $440,000 $440,500
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,106
Bill Payments $1,005,911 $176,683 $157,759 $159,417 $159,751 $171,745 $171,553 $173,278 $179,982 $179,723 $179,462 $179,268
Subtotal Spent on Operations $1,053,012 $223,784 $204,860 $206,518 $206,852 $218,846 $218,654 $220,379 $227,083 $226,824 $226,563 $226,374
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $13,021 $13,130 $13,239 $13,350 $40,382 $40,719 $41,058 $41,400 $41,745 $42,093 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $1,053,012 $236,805 $217,990 $219,757 $220,202 $259,228 $259,373 $261,437 $268,483 $268,569 $268,656 $226,374
Net Cash Flow $179,488 $6,445 $226,793 $161,059 $2,169,798 $130,772 $131,127 $131,379 $134,784 $171,431 $171,344 $214,126
Cash Balance $624,488 $630,932 $857,725 $1,018,785 $3,188,583 $3,319,354 $3,450,481 $3,581,860 $3,716,644 $3,888,075 $4,059,419 $4,273,546
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $445,000 $624,488 $630,932 $857,725 $1,018,785 $3,188,583 $3,319,354 $3,450,481 $3,581,860 $3,716,644 $3,888,075 $4,059,419 $4,273,546
Accounts Receivable $420,000 $637,500 $774,250 $719,467 $728,650 $728,650 $728,650 $738,150 $785,333 $822,067 $822,067 $822,067 $831,567
Inventory $1,545,000 $1,419,000 $1,312,600 $1,203,400 $1,094,200 $985,000 $875,800 $763,800 $640,600 $517,400 $394,200 $271,000 $145,000
Other Current Assets $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000
Total Current Assets $2,515,000 $2,785,988 $2,822,782 $2,885,592 $2,946,635 $5,007,233 $5,028,804 $5,057,431 $5,112,794 $5,161,111 $5,209,342 $5,257,486 $5,355,112
Long-term Assets
Long-term Assets $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000
Accumulated Depreciation $80,000 $82,200 $84,400 $86,600 $88,800 $91,000 $93,200 $95,400 $97,600 $99,800 $102,000 $104,200 $106,400
Total Long-term Assets $445,000 $442,800 $440,600 $438,400 $436,200 $434,000 $431,800 $429,600 $427,400 $425,200 $423,000 $420,800 $418,600
Total Assets $2,960,000 $3,228,788 $3,263,382 $3,323,992 $3,382,835 $5,441,233 $5,460,604 $5,487,031 $5,540,194 $5,586,311 $5,632,342 $5,678,286 $5,773,712
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $1,000,000 $171,427 $152,445 $154,106 $154,026 $166,029 $165,785 $167,279 $173,991 $173,741 $173,488 $173,234 $174,973
Current Borrowing $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000
Other Current Liabilities $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000
Subtotal Current Liabilities $2,500,000 $1,671,427 $1,652,445 $1,654,106 $1,654,026 $1,666,029 $1,665,785 $1,667,279 $1,673,991 $1,673,741 $1,673,488 $1,673,234 $1,674,973
Long-term Liabilities $355,000 $1,355,000 $1,341,979 $1,328,849 $1,315,610 $3,302,260 $3,261,878 $3,221,159 $3,180,101 $3,138,701 $3,096,956 $3,054,863 $3,054,863
Total Liabilities $2,855,000 $3,026,427 $2,994,424 $2,982,955 $2,969,636 $4,968,289 $4,927,663 $4,888,438 $4,854,092 $4,812,442 $4,770,444 $4,728,097 $4,729,836
Paid-in Capital $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000
Retained Earnings $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000
Earnings $0 $97,361 $163,958 $236,037 $308,199 $367,944 $427,941 $493,593 $581,102 $668,869 $756,898 $845,189 $938,876
Total Capital $105,000 $202,361 $268,958 $341,037 $413,199 $472,944 $532,941 $598,593 $686,102 $773,869 $861,898 $950,189 $1,043,876
Total Liabilities and Capital $2,960,000 $3,228,788 $3,263,382 $3,323,992 $3,382,835 $5,441,233 $5,460,604 $5,487,031 $5,540,194 $5,586,311 $5,632,342 $5,678,286 $5,773,712
Net Worth $105,000 $202,361 $268,958 $341,037 $413,199 $472,944 $532,941 $598,593 $686,102 $773,869 $861,898 $950,189 $1,043,876
Past Performance
1997 1998 1999
Sales $0 $0 $3,000,000
Gross Margin $0 $0 $750,000
Gross Margin % 0.00% 0.00% 25.00%
Operating Expenses $0 $0 $1,200,000
Collection Period (days) 0 0 34
Inventory Turnover 0.00 0.00 6.00
Balance Sheet
1997 1998 1999
Current Assets
Cash $0 $0 $445,000
Accounts Receivable $0 $0 $420,000
Inventory $0 $0 $1,545,000
Other Current Assets $0 $0 $105,000
Total Current Assets $0 $0 $2,515,000
Long-term Assets
Long-term Assets $0 $0 $525,000
Accumulated Depreciation $0 $0 $80,000
Total Long-term Assets $0 $0 $445,000
Total Assets $0 $0 $2,960,000
Current Liabilities
Accounts Payable $0 $0 $1,000,000
Current Borrowing $0 $0 $1,090,000
Other Current Liabilities (interest free) $0 $0 $410,000
Total Current Liabilities $0 $0 $2,500,000
Long-term Liabilities $0 $0 $355,000
Total Liabilities $0 $0 $2,855,000
Paid-in Capital $0 $0 $70,000
Retained Earnings $0 $0 $35,000
Earnings $0 $0 $0
Total Capital $0 $0 $105,000
Total Capital and Liabilities $0 $0 $2,960,000
Other Inputs
Payment Days 0 0 30
Sales on Credit $0 $0 $2,250,000
Receivables Turnover 0.00 0.00 5.36
previous
next
Edit This Plan
Share this page:
Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
All product lines 0% $450,000 $380,000 $390,000 $390,000 $390,000 $390,000 $400,000 $440,000 $440,000 $440,000 $440,000 $450,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $450,000 $380,000 $390,000 $390,000 $390,000 $390,000 $400,000 $440,000 $440,000 $440,000 $440,000 $450,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
All product lines $126,000 $106,400 $109,200 $109,200 $109,200 $109,200 $112,000 $123,200 $123,200 $123,200 $123,200 $126,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $126,000 $106,400 $109,200 $109,200 $109,200 $109,200 $112,000 $123,200 $123,200 $123,200 $123,200 $126,000
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
All departments 0% $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,106
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 15 15 15 15 15 15 15 15 15 15 15 15
Total Payroll $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,106
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Long-term Interest Rate 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00% 10.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $450,000 $380,000 $390,000 $390,000 $390,000 $390,000 $400,000 $440,000 $440,000 $440,000 $440,000 $450,000
Direct Cost of Sales $126,000 $106,400 $109,200 $109,200 $109,200 $109,200 $112,000 $123,200 $123,200 $123,200 $123,200 $126,000
Other $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167 $4,167
Total Cost of Sales $130,167 $110,567 $113,367 $113,367 $113,367 $113,367 $116,167 $127,367 $127,367 $127,367 $127,367 $130,167
Gross Margin $319,833 $269,433 $276,633 $276,633 $276,633 $276,633 $283,833 $312,633 $312,633 $312,633 $312,633 $319,833
Gross Margin % 71.07% 70.90% 70.93% 70.93% 70.93% 70.93% 70.96% 71.05% 71.05% 71.05% 71.05% 71.07%
Expenses
Payroll $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,106
Sales and Marketing and Other Expenses $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005 $99,005
Depreciation $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Communications $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200 $2,200
Client Relations $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Rent $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Payroll Taxes 15% $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,065 $7,066
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,371 $160,377
Profit Before Interest and Taxes $159,462 $109,062 $116,262 $116,262 $116,262 $116,262 $123,462 $152,262 $152,262 $152,262 $152,262 $159,457
EBITDA $161,662 $111,262 $118,462 $118,462 $118,462 $118,462 $125,662 $154,462 $154,462 $154,462 $154,462 $161,657
Interest Expense $20,375 $20,266 $20,157 $20,047 $36,602 $36,266 $35,926 $35,584 $35,239 $34,891 $34,541 $34,541
Taxes Incurred $41,726 $22,199 $24,026 $24,054 $19,915 $19,999 $21,884 $29,170 $29,256 $29,343 $29,430 $31,229
Net Profit $97,361 $66,597 $72,079 $72,162 $59,745 $59,998 $65,652 $87,509 $87,767 $88,028 $88,291 $93,687
Net Profit/Sales 21.64% 17.53% 18.48% 18.50% 15.32% 15.38% 16.41% 19.89% 19.95% 20.01% 20.07% 20.82%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $22,500 $19,000 $19,500 $19,500 $19,500 $19,500 $20,000 $22,000 $22,000 $22,000 $22,000 $22,500
Cash from Receivables $210,000 $224,250 $425,283 $361,317 $370,500 $370,500 $370,500 $370,817 $381,267 $418,000 $418,000 $418,000
Subtotal Cash from Operations $232,500 $243,250 $444,783 $380,817 $390,000 $390,000 $390,500 $392,817 $403,267 $440,000 $440,000 $440,500
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Other Liabilities (interest-free) $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Long-term Liabilities $1,000,000 $0 $0 $0 $2,000,000 $0 $0 $0 $0 $0 $0 $0
Sales of Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales of Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
New Investment Received $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $1,232,500 $243,250 $444,783 $380,817 $2,390,000 $390,000 $390,500 $392,817 $403,267 $440,000 $440,000 $440,500
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,101 $47,106
Bill Payments $1,005,911 $176,683 $157,759 $159,417 $159,751 $171,745 $171,553 $173,278 $179,982 $179,723 $179,462 $179,268
Subtotal Spent on Operations $1,053,012 $223,784 $204,860 $206,518 $206,852 $218,846 $218,654 $220,379 $227,083 $226,824 $226,563 $226,374
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Principal Repayment of Current Borrowing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Liabilities Principal Repayment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Long-term Liabilities Principal Repayment $0 $13,021 $13,130 $13,239 $13,350 $40,382 $40,719 $41,058 $41,400 $41,745 $42,093 $0
Purchase Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Purchase Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $1,053,012 $236,805 $217,990 $219,757 $220,202 $259,228 $259,373 $261,437 $268,483 $268,569 $268,656 $226,374
Net Cash Flow $179,488 $6,445 $226,793 $161,059 $2,169,798 $130,772 $131,127 $131,379 $134,784 $171,431 $171,344 $214,126
Cash Balance $624,488 $630,932 $857,725 $1,018,785 $3,188,583 $3,319,354 $3,450,481 $3,581,860 $3,716,644 $3,888,075 $4,059,419 $4,273,546
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $445,000 $624,488 $630,932 $857,725 $1,018,785 $3,188,583 $3,319,354 $3,450,481 $3,581,860 $3,716,644 $3,888,075 $4,059,419 $4,273,546
Accounts Receivable $420,000 $637,500 $774,250 $719,467 $728,650 $728,650 $728,650 $738,150 $785,333 $822,067 $822,067 $822,067 $831,567
Inventory $1,545,000 $1,419,000 $1,312,600 $1,203,400 $1,094,200 $985,000 $875,800 $763,800 $640,600 $517,400 $394,200 $271,000 $145,000
Other Current Assets $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000 $105,000
Total Current Assets $2,515,000 $2,785,988 $2,822,782 $2,885,592 $2,946,635 $5,007,233 $5,028,804 $5,057,431 $5,112,794 $5,161,111 $5,209,342 $5,257,486 $5,355,112
Long-term Assets
Long-term Assets $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000 $525,000
Accumulated Depreciation $80,000 $82,200 $84,400 $86,600 $88,800 $91,000 $93,200 $95,400 $97,600 $99,800 $102,000 $104,200 $106,400
Total Long-term Assets $445,000 $442,800 $440,600 $438,400 $436,200 $434,000 $431,800 $429,600 $427,400 $425,200 $423,000 $420,800 $418,600
Total Assets $2,960,000 $3,228,788 $3,263,382 $3,323,992 $3,382,835 $5,441,233 $5,460,604 $5,487,031 $5,540,194 $5,586,311 $5,632,342 $5,678,286 $5,773,712
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $1,000,000 $171,427 $152,445 $154,106 $154,026 $166,029 $165,785 $167,279 $173,991 $173,741 $173,488 $173,234 $174,973
Current Borrowing $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000 $1,090,000
Other Current Liabilities $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000 $410,000
Subtotal Current Liabilities $2,500,000 $1,671,427 $1,652,445 $1,654,106 $1,654,026 $1,666,029 $1,665,785 $1,667,279 $1,673,991 $1,673,741 $1,673,488 $1,673,234 $1,674,973
Long-term Liabilities $355,000 $1,355,000 $1,341,979 $1,328,849 $1,315,610 $3,302,260 $3,261,878 $3,221,159 $3,180,101 $3,138,701 $3,096,956 $3,054,863 $3,054,863
Total Liabilities $2,855,000 $3,026,427 $2,994,424 $2,982,955 $2,969,636 $4,968,289 $4,927,663 $4,888,438 $4,854,092 $4,812,442 $4,770,444 $4,728,097 $4,729,836
Paid-in Capital $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000
Retained Earnings $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000 $35,000
Earnings $0 $97,361 $163,958 $236,037 $308,199 $367,944 $427,941 $493,593 $581,102 $668,869 $756,898 $845,189 $938,876
Total Capital $105,000 $202,361 $268,958 $341,037 $413,199 $472,944 $532,941 $598,593 $686,102 $773,869 $861,898 $950,189 $1,043,876
Total Liabilities and Capital $2,960,000 $3,228,788 $3,263,382 $3,323,992 $3,382,835 $5,441,233 $5,460,604 $5,487,031 $5,540,194 $5,586,311 $5,632,342 $5,678,286 $5,773,712
Net Worth $105,000 $202,361 $268,958 $341,037 $413,199 $472,944 $532,941 $598,593 $686,102 $773,869 $861,898 $950,189 $1,043,876
Past Performance
1997 1998 1999
Sales $0 $0 $3,000,000
Gross Margin $0 $0 $750,000
Gross Margin % 0.00% 0.00% 25.00%
Operating Expenses $0 $0 $1,200,000
Collection Period (days) 0 0 34
Inventory Turnover 0.00 0.00 6.00
Balance Sheet
1997 1998 1999
Current Assets
Cash $0 $0 $445,000
Accounts Receivable $0 $0 $420,000
Inventory $0 $0 $1,545,000
Other Current Assets $0 $0 $105,000
Total Current Assets $0 $0 $2,515,000
Long-term Assets
Long-term Assets $0 $0 $525,000
Accumulated Depreciation $0 $0 $80,000
Total Long-term Assets $0 $0 $445,000
Total Assets $0 $0 $2,960,000
Current Liabilities
Accounts Payable $0 $0 $1,000,000
Current Borrowing $0 $0 $1,090,000
Other Current Liabilities (interest free) $0 $0 $410,000
Total Current Liabilities $0 $0 $2,500,000
Long-term Liabilities $0 $0 $355,000
Total Liabilities $0 $0 $2,855,000
Paid-in Capital $0 $0 $70,000
Retained Earnings $0 $0 $35,000
Earnings $0 $0 $0
Total Capital $0 $0 $105,000
Total Capital and Liabilities $0 $0 $2,960,000
Other Inputs
Payment Days 0 0 30
Sales on Credit $0 $0 $2,250,000
Receivables Turnover 0.00 0.00 5.36