Question: Review the financial statments. what questions, issues, or concernes do you have? Estimate or Actual Table 4.11 Eco Excellence Express Cleaners LLC Projected Start-Up Costs







Estimate or Actual Table 4.11 Eco Excellence Express Cleaners LLC Projected Start-Up Costs Cost Item Start-Up Expenses $500 Expensed Equipment estimate Financial Institution Fees $1,500 estimate Fuel $400 estimate Identity Set/Stationary $500 estimate Insurance $1,000 estimate Licenses $150 estimate Marketing Materials $1,200 estimate Payroll (with taxes) $- Professional Fees - Accounting $- Professional Fees - Legal $- Rent $630 actual Supplies - Office $200 estimate Supplies - Cleaning $400 estimate Utilities $500 estimate Web Fees $250 estimate Total Start-Up Expenses $7,230 Start-Up Assets Cash on Hand Equipment (including installation) Furniture and Fixtures Leasehold Improvements Rent Deposit $200 $60,500 $4,500 $1,000 $630 actual actual estimate estimate actual Table 4.11 Eco Excellence Express Cleaners LLC Projected Start-Up Costs (Continued) Cost Item Estimate or Actual Signage Utility Deposits Vehicle(s) Total Start-Up Assets $750 $1,800 $35,000 $104,380 estimate estimate actual Total Start-Up Requirements $111,610 Contingency Funds (10%) $11,161 Start-Up with Contingency $122,771 Equipment = washer 35# (89000), washer So# ($11000), 4 dryers (S18000), press ($3200), hot water heater ($1200), 25 storage units ($3300), miscellaneous (84000) Equipment Washer, 35lbs Washer, 50lbs 4 Dryers (S4500 ea.) Press Hot water heater 25 Rubbermaid storage sheds Miscellaneous $9,000 $11,000 $18,000 $3,200 $12,000 $3,300 $4,000 $60,500 Furniture and Fixtures Office Furniture & Furnishings Fixtures Work Tables $1,000 $2,000 $1,500 $4,500 Table 4.12 Eco Excellence Express Cleaners LLC Sales Projections Month / Month 2 Month 3 Month 4 Month 3 Month 6 Month 75 3225 80 S S- Laundry 35 # of customers 45 60 65 70 Loads 150.5 193.5 258 279.5 301 (4.3 wks) S24.00 $24.00 $24.00 $30.00 $30.00 $30.00 $3009 Price per 20lbs Gross Sales $3,612 $4,644 $6,192 58,385 $9,030 59,675 $10.325 Returns & S- S- S- S S allowances Net Laundry $3,612 S4,644 56,192 $8,385 $9,030 89,675 510328 Sales Quarterly Net $14.448 $27,090 Laundry Sales Dry Cleaning Customers 30 40 52 65 78 90 108 Units (4.3) 64.5 86 111.8 139.75 167.7 193.5 232.2 Price per order $35.00 $35.00 $35.00 $35.00 $35.00 $35.00 $35,00 Gross Sales S2.258 $3,010 $3,913 $4,891 $5,870 S6,773 $8,127 Returns & allowances $2,258 $3,010 $3,913 $4,891 $5,870 $6,773 $8,127 Cleaning Sales Quarterly $9,181 $17,533 Cleaning Sales Repairs & Alterations Net Repairs and S100 $100 S100 S500 Alterations Sales Quarterly Net 300 Repairs and Alterations Net Dry Net Dry Y $- Sales Quarterly Total Sales $5,870 $7,654 $10,105 S13,376 $15,000 $16,548 518,947 $23,629 $44.923 Manth & Month 9 Month 10 Month 11 Month 12 Year! Year 2 Year 3 90 387 95 408.5 100 430 85 1655 105 451.5 1000 4300 Xxxxxxxx xxxxxxxx XXXXXXXX $30.00 $30.00 1200 5160 $30.00 $30.00 $30.00 $30.00 $30.00 $10,965 S11,610 S12,255 $12,900 $13,545 $1,13,133 $- S- S- S $ S- $1,29,000 $1,54,800 S- $- $10,965 S11,610 S12,255 $12,900 $13,545 S1,13,133 $1.29,000 $1,54,800 $32,895 $38,700 $1,13,133 228 490.2 250 537.5 130 156 190 279.5 335.4 408.5 $35.00 $35.00 $35.00 $35.00 $35.00 1417 3300 3500 XXXXXX 7095 7525 xxxxxx XXXXXXXX $35.00 $35.00 XXXX $2,48,325 $2,63,375 59,783 $11,739 $14,298 $17,157 $18,813 $1,06,629 S- 99,783 $11.739 $14,298 $17,157 $18,813 $1,06,629 $2,48,325 $2,63,375 S29,649 $50,267 $500 $500 $500 S500 $500 $3,300 $6,000 $7,500 1500 1500 S3,83,325 $4,25,675 $21,248 $23,849 $27,053 $30,557 $32,858 $2,23,062 $64,044 $90,467 Year / Year 2 Year 3 Table 4.13 Eco Excellence Express Cleaners LLC Income Statement For the Period Ending 19 20 30 40 Total Net Sales $23,629 $44,923 S64,044 590,467 $2,23,063 $3,87,325 $4,25,675 Cost of Goods Sold Laundry Dry Cleaning Repairs & Alterations Total COGS $11,068 $5,509 $ S16,577 $14,211 $10,520 S210 S24,940 $16,184 $17,789 S1.050 $35,024 S18,158 $30,160 $1.050 $49,368 $59,621 $63,860 $72.632 $63,978 $1.48,995 S1,58,025 $2,310 $4,200 $5,250 $1.25 909 52,17 055 52.35,907 $7,052 $19.983 $29,020 S41,099 597,154 $1,66,270 S1,89.768 GROSS PROFIT Operating Expenses Advertising & Promotion Depreciation - Equipment Depreciation - Vehicle Insurance expense Office supplies expense Rent expense Repairs & Maintenance Salaries, Wayes Comprehensive Travel Liliues expense Total Operating Expenses $2,400 $2,358 $1.750 $3,000 S100 S1,890 5125 5 52.000 S10.800 524,423 $2,400 52,358 $1,750 53,000 S100 51.890 $125 S $2,000 $10,800 524,421 $2,400 $2,358 $1.750 $3,000 S100 S1,890 $125 5 $2.000 $10.000 524423 52,400 $2.358 S1,750 $3,000 S100 $1,890 S12 5 $2,000 S10,800 524421 59,600 59.431 $7.000 $12.000 $400 $7,560 $500 5 SR 2000 $43.200 597,601 S10,000 $11,000 S16,163 S11,543 S11.200 56,720 S12,000 $12.000 S500 $550 57.560 $7.560 S500 5500 $24,000 $24,000 S8.000 S8.000 $43.200 543.100 51,11,133 5125,071 564,95 $13,147 5(537) 516,676 54,597 5(17371) ${4.440) Earnings Before Interest and Taxes (EBIT) S517 $894 $1,411 S(18,782) 5472 5861 $1,333 $3.264 $495 5878 $1,373 $(5.813) 5448 $844 $1,292 S15,384 Other Expenses: Interest expense-vehicle Interest expense -equip Total Other Expenses Net Income before Taxes (Loss Carry Forward) Taxes (25%)* $1.932 53.477 $5.409 $15.946) 51.550 53.199 $4,749 $28.398 $(5.946) 55613 SL. 145 $2.103 $4,048 560,647 0 $15,162 S- S $ S $ $22,785 S45,485 S(5,946) $3.264 $15,384 S(18,782) S(5,813) Net Income Year / Year 2 Year 3 $36,770 536,551 $75,334 $2,23,063 $3,83,325 $4,25,675 S2.07.169 $3,28,428 $3,57,879 $- $ $- Table 4.14 Eco Excellence Express Cleaners LLC Cash Flow Statement For the Period Ending Start-up 10 20 30 40 Starting Cash S $36,770 $19,420 $15,039 $19,735 Cash in from Operations (Sales) $23,629 $44,923 $64,044 S90,467 Cash out from Operations $7,230 $36,892 S45.255 $55,339 $69,683 (COGS, Expenses, Taxes) Cash in from Investing (equity $50,000 $ $ infusions, earnings on investments) Cash out from Investing (equipment $1,01,000 $1,411 $1,373 $1,333 S1,292 purchases, repaying investors) Cash in from Financing (loans) $95.000 S- S- $ Cash out for Financing $2,676 $2,676 S2,676 $2,676 (repayment of debt) Ending Cash Balance $36,770 $19,420 $15.039 $19,735 $36,551 (-starting balance for next period) $5,409 $4,749 $4,048 S $11,365 $10,704 $12,065 $ $36,551 $75,334 $1,27,017 TUSE Excellence Express Cleaner LLC Balance Sheet As of Starting 10 20 Balances 30 40 Year Year 2 Year $1.27.017 $19,420 $36,551 $19,735 ASSETS Current Assets Cash Marketable Securities Accounts Receivable Inventory Pre-paid Expenses Total Current Assets $ $36,770 S $- $ $7.230 $44,000 $75,334 $ $ S- SI5,039 $ $ $ $7.230 $22,269 S- S- $ S- S- $7,230 $26,650 S36,551 $ $ S $7,230 $43,781 $ S- $7.230 S43,781 $7,230 $26.965 $7,230 $82,564 $7,230 $1,34,247 Long-Term Assets Capital Equipment (net of depr) Vehicle Total L-T Assets TOTAL ASSETS $66,000 $35.000 $1.01.000 $1.45.000 $63,642 $33,250 $96,892 S1 23.542 $61,284 $31,500 92,784 S1.15,053 S58,926 S29,750 588,676 $1.15.641 $56,568 $28,000 $84,568 $1,28,349 $56,568 $28,000 $84.568 S1,28,349 S40,405 S16,800 $57,205 $1,39,769 $28.862 $10,080 $38.942 S1.73,189 s $ $ S- S $ $ wohn LIABILITIES Current Liabilities Accounts Payable-Trade Compensation Payable Taxes Payable Current Portion of L-T Liabilities Total Current Liabilities $- $ S11,365 S11,365 $10,704 S10,704 $12,065 $12,065 $8,028 58,028 $5.352 $5,352 $2,676 5 $2,676 S $12,809 $12,809 (Continued 40 Year / Year 2 Year 3 Table 4.15 Eco Excellence Express Cleaners LLC Balance Sheet As of (Continued) Starting 10 20 30 Balances Long-Term Liabilities (net of current portion) Vehicle Loan Payable $28,812 $28,812 $28,812 $28.812 Notes Payable-Bank $46,236 $46,236 $46,236 546,236 Note Payable - Private S9,248 $9,248 $9,248 S9,248 Total Long-Term Liabilities $84.296 $84,296 $84,296 584,296 Total Liabilities $95.000 S92,324 $89.648 $86,972 $28,812 $46,236 S9,248 $84.296 $22,242 $42,241 58,448 $72,931 SI5,267 $37,999 $7,600 S60,866 $7.862 $33,495 56,700 $48,057 $84,296 $84,296 $72,931 $60,866 Equity Paid-in-Capital Retained Earnings Total Equity $50,000 $ $50,000 $50,000 S(18,782) $31,218 S50,000 $50,000 S(24,595) S(21,331) $25,405 $28,669 S50,000 S(5.947 $44.053 $50,000 S(5.947) $44,053 $50,000 S16,838 566,838 $50,000 62,323 S1.12,323 S1,28,349 $1,39.769 S1,73,189 $1.28 349 S1,15.641 S1,23,542 S1.15,053 SI 45,000 TOTAL LIABILITIES & E.QUITY Estimate or Actual Table 4.11 Eco Excellence Express Cleaners LLC Projected Start-Up Costs Cost Item Start-Up Expenses $500 Expensed Equipment estimate Financial Institution Fees $1,500 estimate Fuel $400 estimate Identity Set/Stationary $500 estimate Insurance $1,000 estimate Licenses $150 estimate Marketing Materials $1,200 estimate Payroll (with taxes) $- Professional Fees - Accounting $- Professional Fees - Legal $- Rent $630 actual Supplies - Office $200 estimate Supplies - Cleaning $400 estimate Utilities $500 estimate Web Fees $250 estimate Total Start-Up Expenses $7,230 Start-Up Assets Cash on Hand Equipment (including installation) Furniture and Fixtures Leasehold Improvements Rent Deposit $200 $60,500 $4,500 $1,000 $630 actual actual estimate estimate actual Table 4.11 Eco Excellence Express Cleaners LLC Projected Start-Up Costs (Continued) Cost Item Estimate or Actual Signage Utility Deposits Vehicle(s) Total Start-Up Assets $750 $1,800 $35,000 $104,380 estimate estimate actual Total Start-Up Requirements $111,610 Contingency Funds (10%) $11,161 Start-Up with Contingency $122,771 Equipment = washer 35# (89000), washer So# ($11000), 4 dryers (S18000), press ($3200), hot water heater ($1200), 25 storage units ($3300), miscellaneous (84000) Equipment Washer, 35lbs Washer, 50lbs 4 Dryers (S4500 ea.) Press Hot water heater 25 Rubbermaid storage sheds Miscellaneous $9,000 $11,000 $18,000 $3,200 $12,000 $3,300 $4,000 $60,500 Furniture and Fixtures Office Furniture & Furnishings Fixtures Work Tables $1,000 $2,000 $1,500 $4,500 Table 4.12 Eco Excellence Express Cleaners LLC Sales Projections Month / Month 2 Month 3 Month 4 Month 3 Month 6 Month 75 3225 80 S S- Laundry 35 # of customers 45 60 65 70 Loads 150.5 193.5 258 279.5 301 (4.3 wks) S24.00 $24.00 $24.00 $30.00 $30.00 $30.00 $3009 Price per 20lbs Gross Sales $3,612 $4,644 $6,192 58,385 $9,030 59,675 $10.325 Returns & S- S- S- S S allowances Net Laundry $3,612 S4,644 56,192 $8,385 $9,030 89,675 510328 Sales Quarterly Net $14.448 $27,090 Laundry Sales Dry Cleaning Customers 30 40 52 65 78 90 108 Units (4.3) 64.5 86 111.8 139.75 167.7 193.5 232.2 Price per order $35.00 $35.00 $35.00 $35.00 $35.00 $35.00 $35,00 Gross Sales S2.258 $3,010 $3,913 $4,891 $5,870 S6,773 $8,127 Returns & allowances $2,258 $3,010 $3,913 $4,891 $5,870 $6,773 $8,127 Cleaning Sales Quarterly $9,181 $17,533 Cleaning Sales Repairs & Alterations Net Repairs and S100 $100 S100 S500 Alterations Sales Quarterly Net 300 Repairs and Alterations Net Dry Net Dry Y $- Sales Quarterly Total Sales $5,870 $7,654 $10,105 S13,376 $15,000 $16,548 518,947 $23,629 $44.923 Manth & Month 9 Month 10 Month 11 Month 12 Year! Year 2 Year 3 90 387 95 408.5 100 430 85 1655 105 451.5 1000 4300 Xxxxxxxx xxxxxxxx XXXXXXXX $30.00 $30.00 1200 5160 $30.00 $30.00 $30.00 $30.00 $30.00 $10,965 S11,610 S12,255 $12,900 $13,545 $1,13,133 $- S- S- S $ S- $1,29,000 $1,54,800 S- $- $10,965 S11,610 S12,255 $12,900 $13,545 S1,13,133 $1.29,000 $1,54,800 $32,895 $38,700 $1,13,133 228 490.2 250 537.5 130 156 190 279.5 335.4 408.5 $35.00 $35.00 $35.00 $35.00 $35.00 1417 3300 3500 XXXXXX 7095 7525 xxxxxx XXXXXXXX $35.00 $35.00 XXXX $2,48,325 $2,63,375 59,783 $11,739 $14,298 $17,157 $18,813 $1,06,629 S- 99,783 $11.739 $14,298 $17,157 $18,813 $1,06,629 $2,48,325 $2,63,375 S29,649 $50,267 $500 $500 $500 S500 $500 $3,300 $6,000 $7,500 1500 1500 S3,83,325 $4,25,675 $21,248 $23,849 $27,053 $30,557 $32,858 $2,23,062 $64,044 $90,467 Year / Year 2 Year 3 Table 4.13 Eco Excellence Express Cleaners LLC Income Statement For the Period Ending 19 20 30 40 Total Net Sales $23,629 $44,923 S64,044 590,467 $2,23,063 $3,87,325 $4,25,675 Cost of Goods Sold Laundry Dry Cleaning Repairs & Alterations Total COGS $11,068 $5,509 $ S16,577 $14,211 $10,520 S210 S24,940 $16,184 $17,789 S1.050 $35,024 S18,158 $30,160 $1.050 $49,368 $59,621 $63,860 $72.632 $63,978 $1.48,995 S1,58,025 $2,310 $4,200 $5,250 $1.25 909 52,17 055 52.35,907 $7,052 $19.983 $29,020 S41,099 597,154 $1,66,270 S1,89.768 GROSS PROFIT Operating Expenses Advertising & Promotion Depreciation - Equipment Depreciation - Vehicle Insurance expense Office supplies expense Rent expense Repairs & Maintenance Salaries, Wayes Comprehensive Travel Liliues expense Total Operating Expenses $2,400 $2,358 $1.750 $3,000 S100 S1,890 5125 5 52.000 S10.800 524,423 $2,400 52,358 $1,750 53,000 S100 51.890 $125 S $2,000 $10,800 524,421 $2,400 $2,358 $1.750 $3,000 S100 S1,890 $125 5 $2.000 $10.000 524423 52,400 $2.358 S1,750 $3,000 S100 $1,890 S12 5 $2,000 S10,800 524421 59,600 59.431 $7.000 $12.000 $400 $7,560 $500 5 SR 2000 $43.200 597,601 S10,000 $11,000 S16,163 S11,543 S11.200 56,720 S12,000 $12.000 S500 $550 57.560 $7.560 S500 5500 $24,000 $24,000 S8.000 S8.000 $43.200 543.100 51,11,133 5125,071 564,95 $13,147 5(537) 516,676 54,597 5(17371) ${4.440) Earnings Before Interest and Taxes (EBIT) S517 $894 $1,411 S(18,782) 5472 5861 $1,333 $3.264 $495 5878 $1,373 $(5.813) 5448 $844 $1,292 S15,384 Other Expenses: Interest expense-vehicle Interest expense -equip Total Other Expenses Net Income before Taxes (Loss Carry Forward) Taxes (25%)* $1.932 53.477 $5.409 $15.946) 51.550 53.199 $4,749 $28.398 $(5.946) 55613 SL. 145 $2.103 $4,048 560,647 0 $15,162 S- S $ S $ $22,785 S45,485 S(5,946) $3.264 $15,384 S(18,782) S(5,813) Net Income Year / Year 2 Year 3 $36,770 536,551 $75,334 $2,23,063 $3,83,325 $4,25,675 S2.07.169 $3,28,428 $3,57,879 $- $ $- Table 4.14 Eco Excellence Express Cleaners LLC Cash Flow Statement For the Period Ending Start-up 10 20 30 40 Starting Cash S $36,770 $19,420 $15,039 $19,735 Cash in from Operations (Sales) $23,629 $44,923 $64,044 S90,467 Cash out from Operations $7,230 $36,892 S45.255 $55,339 $69,683 (COGS, Expenses, Taxes) Cash in from Investing (equity $50,000 $ $ infusions, earnings on investments) Cash out from Investing (equipment $1,01,000 $1,411 $1,373 $1,333 S1,292 purchases, repaying investors) Cash in from Financing (loans) $95.000 S- S- $ Cash out for Financing $2,676 $2,676 S2,676 $2,676 (repayment of debt) Ending Cash Balance $36,770 $19,420 $15.039 $19,735 $36,551 (-starting balance for next period) $5,409 $4,749 $4,048 S $11,365 $10,704 $12,065 $ $36,551 $75,334 $1,27,017 TUSE Excellence Express Cleaner LLC Balance Sheet As of Starting 10 20 Balances 30 40 Year Year 2 Year $1.27.017 $19,420 $36,551 $19,735 ASSETS Current Assets Cash Marketable Securities Accounts Receivable Inventory Pre-paid Expenses Total Current Assets $ $36,770 S $- $ $7.230 $44,000 $75,334 $ $ S- SI5,039 $ $ $ $7.230 $22,269 S- S- $ S- S- $7,230 $26,650 S36,551 $ $ S $7,230 $43,781 $ S- $7.230 S43,781 $7,230 $26.965 $7,230 $82,564 $7,230 $1,34,247 Long-Term Assets Capital Equipment (net of depr) Vehicle Total L-T Assets TOTAL ASSETS $66,000 $35.000 $1.01.000 $1.45.000 $63,642 $33,250 $96,892 S1 23.542 $61,284 $31,500 92,784 S1.15,053 S58,926 S29,750 588,676 $1.15.641 $56,568 $28,000 $84,568 $1,28,349 $56,568 $28,000 $84.568 S1,28,349 S40,405 S16,800 $57,205 $1,39,769 $28.862 $10,080 $38.942 S1.73,189 s $ $ S- S $ $ wohn LIABILITIES Current Liabilities Accounts Payable-Trade Compensation Payable Taxes Payable Current Portion of L-T Liabilities Total Current Liabilities $- $ S11,365 S11,365 $10,704 S10,704 $12,065 $12,065 $8,028 58,028 $5.352 $5,352 $2,676 5 $2,676 S $12,809 $12,809 (Continued 40 Year / Year 2 Year 3 Table 4.15 Eco Excellence Express Cleaners LLC Balance Sheet As of (Continued) Starting 10 20 30 Balances Long-Term Liabilities (net of current portion) Vehicle Loan Payable $28,812 $28,812 $28,812 $28.812 Notes Payable-Bank $46,236 $46,236 $46,236 546,236 Note Payable - Private S9,248 $9,248 $9,248 S9,248 Total Long-Term Liabilities $84.296 $84,296 $84,296 584,296 Total Liabilities $95.000 S92,324 $89.648 $86,972 $28,812 $46,236 S9,248 $84.296 $22,242 $42,241 58,448 $72,931 SI5,267 $37,999 $7,600 S60,866 $7.862 $33,495 56,700 $48,057 $84,296 $84,296 $72,931 $60,866 Equity Paid-in-Capital Retained Earnings Total Equity $50,000 $ $50,000 $50,000 S(18,782) $31,218 S50,000 $50,000 S(24,595) S(21,331) $25,405 $28,669 S50,000 S(5.947 $44.053 $50,000 S(5.947) $44,053 $50,000 S16,838 566,838 $50,000 62,323 S1.12,323 S1,28,349 $1,39.769 S1,73,189 $1.28 349 S1,15.641 S1,23,542 S1.15,053 SI 45,000 TOTAL LIABILITIES & E.QUITY
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
