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

Review the financial statments. what questions, issues, or concernes do you have?
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 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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!