Financial Overview
fyjames
FinancialStatement1.xlsxStart-Up and Monthly Cash Flow
| Unconventional Education & Counseling | Start-Up | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year 1 Total | Year 2 | Year 3 | Year 4 | Year 5 | ||||
| Beginning Cash Balance | $200,000.00 | $182,731.00 | $197,963.88 | $166,326.64 | $151,667.88 | $197,822.36 | $48,182.64 | $54,856.68 | $121,528.36 | $96,790.84 | $147,317.60 | -$214,823.40 | -$180,400.56 | -$190,593.80 | -$190,593.80 | -$164,598.80 | -$225,169.80 | -$298,851.80 | ||||
| Sources of Funding | $53,202.00 | $32,435.00 | $42,841.00 | $75,658.00 | $87,510.00 | $92,845.00 | $96,836.00 | $15,215.00 | $85,771.00 | $95,798.00 | $77,323.00 | $26,757.00 | $782,191.00 | $157,106.00 | $17,960.00 | $7,744.00 | $12,288.00 | |||||
| Sales | $48,002.00 | $27,035.00 | $35,391.00 | $72,203.00 | $82,950.00 | $89,324.00 | $92,501.00 | $10,890.00 | $82,320.00 | $86,553.00 | $67,502.00 | $23,404.00 | $90,313.00 | $64,212.00 | $8,215.00 | $3,422.00 | $8,923.00 | |||||
| Grants | $5,200.00 | $5,400.00 | $7,450.00 | $3,455.00 | $4,560.00 | $3,521.00 | $4,335.00 | $4,325.00 | $3,451.00 | $9,245.00 | $9,821.00 | $3,353.00 | $8,425.00 | $92,894.00 | $9,745.00 | $4,322.00 | $3,365.00 | |||||
| Direct Costs | $9,700.00 | $3,425.00 | $8,250.00 | $8,320.00 | $5,320.00 | $3,450.00 | $4,955.00 | $7,892.00 | $9,080.00 | $7,875.00 | $7,232.00 | $4,925.00 | $80,424.00 | $58,456.00 | $24,200.00 | $12,004.00 | $19,130.00 | |||||
| Activity Fees | $9,700.00 | $3,425.00 | $8,250.00 | $8,320.00 | $5,320.00 | $3,450.00 | $4,955.00 | $7,892.00 | $9,080.00 | $7,875.00 | $7,232.00 | $4,925.00 | $80,424.00 | $45,601.00 | $14,325.00 | $6,673.00 | $8,911.00 | |||||
| Labor | $0.00 | check: | $12,855.00 | $9,875.00 | $5,331.00 | $10,219.00 | ||||||||||||||||
| Gross Margin | $0.00 | $43,502.00 | $29,010.00 | $34,591.00 | $67,338.00 | $82,190.00 | $89,395.00 | $91,881.00 | $7,323.00 | $76,691.00 | $87,923.00 | $70,091.00 | $21,832.00 | $701,767.00 | $701,767.00 | $98,650.00 | -$6,240.00 | -$4,260.00 | -$6,842.00 | |||
| Legal / Professional Service Expenses | $1,732.00 | $2,031.00 | $1,435.00 | $1,409.00 | $577.00 | $358.00 | $445.00 | $1,610.00 | $450.00 | $523.00 | $877.00 | $358.00 | $787.00 | $12,592.00 | $12,592.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Name registration fee | $234.00 | $234.00 | ||||||||||||||||||||
| Incorporation fees | $455.00 | $455.00 | ||||||||||||||||||||
| Legal consultation | $1,043.00 | $945.00 | $782.00 | $953.00 | $243.00 | $234.00 | $223.00 | $845.00 | $108.00 | $224.00 | $654.00 | $234.00 | $222.00 | $6,710.00 | ||||||||
| Accounting consultation | $1,086.00 | $653.00 | $456.00 | $334.00 | $124.00 | $222.00 | $765.00 | $342.00 | $299.00 | $223.00 | $124.00 | $565.00 | $5,193.00 | |||||||||
| Office Expenses | $0.00 | $8,668.00 | $8,464.00 | $8,446.00 | $8,654.00 | $8,234.00 | $8,354.00 | $8,677.00 | $8,346.00 | $9,014.00 | $8,456.00 | $8,335.00 | $8,354.00 | $61,569.00 | $102,002.00 | $61,016.00 | $61,016.00 | $61,016.00 | $61,016.00 | |||
| Rent | $5,422.00 | $5,422.00 | $5,422.00 | $5,422.00 | $5,422.00 | $5,422.00 | $5,422.00 | $5,422.00 | $5,422.00 | $5,422.00 | $5,422.00 | $5,422.00 | $54,221.00 | $54,221.00 | $54,221.00 | $54,221.00 | $54,221.00 | |||||
| Utilities | $556.00 | $352.00 | $334.00 | $542.00 | $122.00 | $242.00 | $565.00 | $234.00 | $902.00 | $344.00 | $223.00 | $242.00 | $4,658.00 | |||||||||
| Insurance | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | $2,234.00 | ||||
| Telecommunication, e,g., Mobile Phone | $456.00 | $456.00 | $456.00 | $456.00 | $456.00 | $456.00 | $456.00 | $456.00 | $456.00 | $456.00 | $456.00 | $456.00 | $456.00 | $4,561.00 | $4,561.00 | $4,561.00 | $4,561.00 | $4,561.00 | ||||
| Marketing / Advertising / Promotion Expenses | $1,310.00 | $2,347.00 | $3,000.00 | $2,632.00 | $920.00 | $2,025.00 | $2,588.00 | $1,803.00 | $2,385.00 | $2,923.00 | $1,563.00 | $1,928.00 | $3,027.00 | $28,451.00 | $28,451.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Marketing / Advertising | $334.00 | $532.00 | $762.00 | $905.00 | $342.00 | $822.00 | $744.00 | $355.00 | $832.00 | $805.00 | $733.00 | $805.00 | $1,278.00 | $9,249.00 | ||||||||
| Internet | $498.00 | $821.00 | $907.00 | $234.00 | $535.00 | $646.00 | $1,002.00 | $673.00 | $764.00 | $242.00 | $223.00 | $673.00 | $7,218.00 | |||||||||
| Website development & maintenance | $875.00 | $672.00 | $254.00 | $122.00 | $334.00 | $753.00 | $223.00 | $543.00 | $821.00 | $345.00 | $677.00 | $543.00 | $6,162.00 | |||||||||
| Logo / letterhead / stationary / business cards | $543.00 | $543.00 | ||||||||||||||||||||
| Marketing consultation / service | $433.00 | $442.00 | $745.00 | $566.00 | $222.00 | $334.00 | $445.00 | $223.00 | $337.00 | $533.00 | $243.00 | $223.00 | $533.00 | $5,279.00 | ||||||||
| Salary & Wages / Human Resources Expenses | $0.00 | $11,543.12 | $6,133.24 | $11,277.76 | $5,779.52 | $8,955.72 | $12,337.96 | $11,246.32 | $11,769.52 | $9,188.24 | $475,372.00 | $7,411.16 | $9,219.24 | $113,433.72 | $580,233.80 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Salaries | $8,754.00 | $4,333.00 | $8,542.00 | $4,334.00 | $6,224.00 | $8,932.00 | $8,344.00 | $8,934.00 | $6,833.00 | $6,539.00 | $5,372.00 | $6,833.00 | $83,974.00 | |||||||||
| Payroll taxes | $2,451.12 | $1,213.24 | $2,391.76 | $1,213.52 | $1,742.72 | $2,500.96 | $2,336.32 | $2,501.52 | $1,913.24 | $1,830.92 | $1,504.16 | $1,913.24 | $23,512.72 | |||||||||
| Benefits | $338.00 | $587.00 | $344.00 | $232.00 | $989.00 | $905.00 | $566.00 | $334.00 | $442.00 | $202.00 | $535.00 | $473.00 | $5,947.00 | |||||||||
| Other General Administration Expenses | $654.00 | $2,129.00 | $2,367.00 | $1,415.00 | $1,886.00 | $1,668.00 | $1,667.00 | $2,133.00 | $3,286.00 | $2,190.00 | $1,525.00 | $1,534.00 | $2,356.00 | $24,810.00 | $24,810.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Supplies | $654.00 | $655.00 | $904.00 | $812.00 | $270.00 | $122.00 | $455.00 | $224.00 | $902.00 | $756.00 | $334.00 | $234.00 | $334.00 | $6,656.00 | ||||||||
| Travel / entertainment | $586.00 | $218.00 | $245.00 | $334.00 | $332.00 | $345.00 | $673.00 | $532.00 | $766.00 | $224.00 | $334.00 | $224.00 | $4,813.00 | |||||||||
| Vehicle expenses | $454.00 | $900.00 | $124.00 | $379.00 | $342.00 | $334.00 | $900.00 | $898.00 | $334.00 | $853.00 | $244.00 | $900.00 | $6,662.00 | |||||||||
| Maintenance fees | $434.00 | $345.00 | $234.00 | $903.00 | $872.00 | $533.00 | $336.00 | $954.00 | $334.00 | $114.00 | $722.00 | $898.00 | $6,679.00 | |||||||||
| Financing Expenses | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Bank charges / credit fees | $0.00 | |||||||||||||||||||||
| Loan payments - interest | ||||||||||||||||||||||
| Equipment / Property / Plant Expenses | $1,433.00 | $695.00 | $1,036.00 | $1,135.00 | $844.00 | $1,127.00 | $1,655.00 | $1,584.00 | $1,691.00 | $1,179.00 | $1,034.00 | $1,683.00 | $1,448.00 | $16,544.00 | $16,544.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Equipment / set up | $901.00 | $132.00 | $211.00 | $911.00 | $721.00 | $234.00 | $755.00 | $902.00 | $783.00 | $334.00 | $921.00 | $783.00 | $766.00 | $8,354.00 | ||||||||
| Furniture and fixtures | $532.00 | $563.00 | $825.00 | $224.00 | $123.00 | $893.00 | $900.00 | $682.00 | $908.00 | $845.00 | $113.00 | $900.00 | $682.00 | $8,190.00 | ||||||||
| Total Expenses | $5,129.00 | $27,413.12 | $22,435.24 | $26,314.76 | $18,660.52 | $22,367.72 | $27,046.96 | $27,053.32 | $27,927.52 | $25,017.24 | $488,827.00 | $21,249.16 | $25,191.24 | $257,399.72 | $764,632.80 | $61,016.00 | $61,016.00 | $61,016.00 | $61,016.00 | |||
| Net Profit (Loss) Before Taxes | -$5,129.00 | $16,088.88 | $6,574.76 | $8,276.24 | $48,677.48 | $59,822.28 | $62,348.04 | $64,827.68 | -$20,604.52 | $51,673.76 | -$400,904.00 | $48,841.84 | -$3,359.24 | $444,367.28 | -$62,865.80 | $37,634.00 | -$67,256.00 | -$65,276.00 | -$67,858.00 | |||
| Income taxes | $0.00 | |||||||||||||||||||||
| Net Profit (Loss) After Taxes | -$5,129.00 | $16,088.88 | $6,574.76 | $8,276.24 | $48,677.48 | $59,822.28 | $62,348.04 | $64,827.68 | -$20,604.52 | $51,673.76 | -$400,904.00 | $48,841.84 | -$3,359.24 | $444,367.28 | -$62,865.80 | $37,634.00 | -$67,256.00 | -$65,276.00 | -$67,858.00 | |||
| Loan payments - principle | $0.00 | $0.00 | $9,015.00 | $8,242.00 | $6,223.00 | $10,342.00 | ||||||||||||||||
| Capital purchases | $1,231.00 | $1,432.00 | $33,222.00 | $33,232.00 | $3,322.00 | $2,492.00 | $53,466.00 | $234.00 | $23,345.00 | $2,323.00 | $3,523.00 | $232.00 | $2,332.00 | $160,386.00 | $160,386.00 | $3,432.00 | $172.00 | $1,223.00 | $22,321.00 | |||
| Cash withdrawals | $13,122.00 | $2,315.00 | $32,221.00 | $23,314.00 | $8,112.00 | $234,201.00 | $5,730.00 | $2,244.00 | $3,122.00 | $2,245.00 | $3,356.00 | $23,421.00 | $6,823.00 | $360,226.00 | $360,226.00 | $1,423.00 | $7,324.00 | $3,216.00 | $543.00 | |||
| Cash injections | $2,213.00 | $2,891.00 | $27,231.00 | $33,611.00 | $8,911.00 | $27,231.00 | $3,522.00 | $4,322.00 | $22,334.00 | $3,421.00 | $45,642.00 | $9,234.00 | $2,321.00 | $192,884.00 | $192,884.00 | $2,231.00 | $22,423.00 | $2,256.00 | $3,453.00 | |||
| Net Cash Added (Subtracted) | -$17,269.00 | $15,232.88 | -$31,637.24 | -$14,658.76 | $46,154.48 | -$149,639.72 | $6,674.04 | $66,671.68 | -$24,737.52 | $50,526.76 | -$362,141.00 | $34,422.84 | -$10,193.24 | $116,639.28 | $25,995.00 | -$60,571.00 | -$73,682.00 | -$97,611.00 | ||||
| Ending Cash Balance | $182,731.00 | $197,963.88 | $166,326.64 | $151,667.88 | $197,822.36 | $48,182.64 | $54,856.68 | $121,528.36 | $96,790.84 | $147,317.60 | -$214,823.40 | -$180,400.56 | -$190,593.80 | -$190,593.80 | -$164,598.80 | -$225,169.80 | -$298,851.80 | -$396,462.80 | ||||
REVENUE
COST
EXPENSE
