Please help me to check the cash flow, income statementand balance sheet that I made are correct or wrong base on the given case study. The net cash flow for year 1 that I came up with is positive; however, one of the question in this assignment ask me "How much financing is required in

year 1 to sustain cash flows?So I am assuming the correct net cash flow for this case study should be negative. I am thinking there should be something missing or incorrect for the charts that I made. I want someone to help me to check everything I did and correct them if they are not correct or there are something missing.

The Miswak Company Projected Cash Budget - Y1 Wholesale Price/Unit Wholesale Price/Box Wholesale Cost/Box Description Number of Boxes New Store Orders Repeat Store Orders Total Store Orders Cash Inflow Wholesale Sales Tradeshow Sales Capital Infusion Total Inflows (a) Cash Outflow Product Cost - Wholesale Product Cost - Tradeshow Tradeshow Exhibiting Costs Other Tradeshow Costs Selling Kits Internet Advertising Blog Promotion Cell Phones Insurance Internet & Web Hosting Office Supplies Rental Unit Travel Mold Tradeshow Booth Website Design Computer & Printer Inventory Drawings Total Outflows (b) Net Cash Flow (c=a-b) Beginning Cash Ending Cash $2.50 $125.00 $66.50 September October November December January 10 0 0 Retail Price/Unit $3.99 Retail Price/Box $199.50 Retail Cost/Box $51.50 February March April May June July August Totals 10 5 15 10 10 20 10 15 25 10 20 30 10 25 35 10 30 40 10 35 45 10 40 50 10 45 55 100 225 325 $1,250 $5,985 $1,875 $2,500 $3,125 $3,750 $4,375 $4,788 $5,000 $5,625 $6,250 $6,875 $40,625 $10,773 $50,000 $101,398 10 $50,000 $50,000 $0 $7,235 $1,875 $2,500 $3,125 $3,750 $9,163 $5,000 $5,625 $6,250 $6,875 $0 $0 $665 $1,288 $1,800 $1,200 $998 $1,330 $1,663 $1,995 $2,328 $1,288 $1,200 $1,200 $2,660 $2,993 $3,325 $3,658 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $1,545 -$1,545 $17,168 $15,623 $6,498 $738 $15,623 $16,360 $2,543 -$668 $16,360 $15,693 $2,875 -$375 $15,693 $15,318 $3,208 -$83 $15,318 $15,235 $3,540 $210 $15,235 $15,445 $7,560 $1,603 $15,445 $17,048 $4,205 $795 $17,048 $17,843 $4,538 $1,088 $17,843 $18,931 $10,000 $14,870 -$8,620 $18,931 $10,311 $10,000 $15,203 -$8,328 $10,311 $1,983 $1,000 $833 $167 $120 $75 $100 $100 $50 $100 $22,500 $2,000 $2,500 $2,000 $1,288 $32,833 $17,168 $0 $17,168 1 $21,613 $2,575 $3,000 $2,400 $1,000 $10,000 $2,000 $1,440 $900 $1,200 $1,200 $600 $1,200 $22,500 $2,000 $2,500 $2,000 $1,288 $20,000 $99,415 $1,983 $174,972 $176,955 The Miswak Company Projected Cash Budget - Y2 Wholesale Price/Unit Wholesale Price/Box Wholesale Cost/Box $2.50 $125.00 $66.50 September Number of Boxes Total Store Orders Cash Inflows Wholesale Sales Tradeshow Sales Total Cash Inflows (a) Cash Outflows Product Cost - Wholesale Product Cost - Tradeshow Tradeshow Exhibiting Costs Other Tradeshow Costs Selling Kits Internet Advertising Blog Promotion Cell Phones Insurance Internet & Web Hosting Office Supplies Rental Unit Travel Drawings Total Cash Outflows (b) Net Cash Flow (c=a-b) Beginning Cash Ending Cash Retail Price/Unit $3.99 Retail Price/Box $199.50 Retail Cost/Box $51.50 October November December January February March April May June July August Totals 61 61 61 61 61 61 61 61 61 61 61 61 726 $7,563 $7,563 $7,563 $7,563 $7,563 $7,563 $7,563 $7,563 $7,563 $7,563 $10,773 $18,336 $7,563 $7,563 $7,563 $4,788 $12,351 $7,563 $7,563 $7,563 $1,596 $9,159 $7,563 $7,563 $7,563 $7,563 $90,750 $17,157 $107,907 $4,023 $4,023 $4,023 $1,288 $1,800 $1,200 $4,023 $4,023 $4,023 $4,023 $4,023 $1,288 $2,600 $1,200 $4,023 $4,023 $4,023 $4,023 $833 $167 $120 $75 $100 $100 $50 $100 $10,000 $15,568 -$8,006 $27,207 $19,201 $833 $167 $120 $75 $100 $100 $50 $100 $10,000 $15,568 -$8,006 $19,201 $11,196 $7,563 $1,500 $1,000 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $6,568 $994 $1,983 $2,977 $5,568 $1,994 $2,977 $4,972 $9,856 -$698 $4,972 $4,274 $5,568 $1,994 $4,274 $6,268 $5,568 $1,994 $6,268 $8,262 $7,068 $5,282 $8,262 $13,545 $5,568 $1,994 $13,545 $15,539 $10,656 $7,680 $15,539 $23,219 $5,568 $1,994 $23,219 $25,213 $5,568 $1,994 $25,213 $27,207 2 $48,279 $2,576 $5,900 $2,400 $1,000 $10,000 $2,000 $1,440 $900 $1,200 $1,200 $600 $1,200 $20,000 $98,695 $9,213 $152,659 $161,871 The Miswak Company Projected Cash Budget - Y3 Wholesale Price/Unit Wholesale Price/Box Wholesale Cost/Box # Boxes Total Store Orders Inflows Wholesale Sales Tradeshow Sales Total Cash Inflows (a) Outflows Product Cost - Wholesale Product Cost - Tradeshow Tradeshow Exhibiting Costs Other Tradeshow Costs Selling Kits Internet Advertising Blog Promotion Cell Phones Insurance Internet & Web Hosting Office Supplies Rental Unit Travel Drawings Total Cash Outflows (b) Net Cash Flow (c=a-b) Beginning Cash Ending Cash $2.50 $125.00 $66.50 Retail Price/Unit $3.99 Retail Price/Box $199.50 Retail Cost/Box $51.50 September October November December January February March April May June July August Totals 67 67 67 67 67 67 67 67 67 67 67 67 799 $8,319 $8,319 $8,319 $8,319 $8,319 $8,319 $8,319 $8,319 $8,319 $8,319 $10,773 $19,092 $8,319 $8,319 $8,319 $4,788 $13,107 $8,319 $8,319 $8,319 $1,596 $9,915 $8,319 $8,319 $8,319 $8,319 99,825 17,157 $116,982 $4,426 $4,426 $4,426 $1,288 $1,800 $1,200 $4,426 $4,426 $4,426 $4,426 $4,426 $1,288 $2,600 $1,200 $4,426 $4,426 $4,426 $4,426 $833 $167 $120 $75 $100 $100 $50 $100 $10,000 $15,971 -$7,652 $39,959 $32,307 $833 $167 $120 $75 $100 $100 $50 $100 $10,000 $15,971 -$7,652 $32,307 $24,656 $8,319 $1,500 $1,000 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $833 $167 $120 $75 $100 $100 $50 $100 $6,971 $1,348 $11,196 $12,544 $5,971 $2,348 $12,544 $14,892 $10,258 -$343 $14,892 $14,549 $5,971 $2,348 $14,549 $16,897 $5,971 $2,348 $16,897 $19,245 $7,471 $5,636 $19,245 $24,881 $5,971 $2,348 $24,881 $27,229 $11,058 $8,034 $27,229 $35,263 $5,971 $2,348 $35,263 $37,611 $5,971 $2,348 $37,611 $39,959 3 $53,107 $2,575 $5,900 $2,400 $1,000 $10,000 $2,000 $1,440 $900 $1,200 $1,200 $600 $1,200 $20,000 $103,522 $13,460 $286,572 $300,032 Projected Income Statement The Miswak Company For Year Ending Aug 31 2xxx Description SALES EXPENSES : Product Cost Tradeshow Costs Selling Kits Internet Advertising Blog Promotion Cell Phones Insurance Internet & Web Hosting Office Supplies Rental Unit Travel Website Design Depreciation - Mold Depreciation - Booth Depreciation - Computer & Printer Total Expenses Net Income Year 1 Year 2 $51,398 $107,907 $24,188 $5,400 $1,000 $10,000 $2,000 $1,440 $900 $1,200 $1,200 $600 $1,200 $2,500 $4,500 $667 $667 $57,461 -$6,063 Year 3 $116,982 $50,855 $8,300 $1,000 $10,000 $2,000 $1,440 $900 $1,200 $1,200 $600 $1,200 $55,682 $8,300 $1,000 $10,000 $2,000 $1,440 $900 $1,200 $1,200 $600 $1,200 $4,500 $667 $667 $84,528 $23,379 $4,500 $667 $667 $89,355 $27,627 4 5 Projected Balance Sheet The Miswak Company As on Aug 31 2xxx ASSETS Current Assets Cash Inventory Total Current Assets Fixed Assets Mold Less: Accumulated Depreciation Booth Less: Accumulated Depreciation Computer & Printer Less: Accumulated Depreciation Total Fixed Assets Total Assets LIABILITIES & OWNERS' EQUITY Owners' Equity Opening Balance Add: Net Income Less: Drawings Total Liabilities & Owners' Equity Year 1 Year 2 $1,983 $1,288 Year 3 $11,196 $1,288 $3,271 $24,656 $1,288 $12,483 $25,943 $22,500 $22,500 $22,500 $4,500 $18,000 $9,000 $13,500 $13,500 $9,000 $2,000 $2,000 $2,000 $667 $1,333 $1,333 $667 $2,000 $0 $2,000 $2,000 $2,000 $667 $1,333 $1,333 $667 $2,000 $0 $20,667 $14,833 $9,000 $23,937 $27,316 $34,943 $50,000 -$7,011 $20,000 $22,989 $18,948 $20,000 $22,989 6 $21,937 $23,195 $20,000 $21,937 $25,132 7