Financial Statement and overview
fyjames
Statement.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 | $2,000,000.00 | $1,854,431.00 | $1,869,663.88 | $1,838,026.64 | $1,823,367.88 | $1,869,522.36 | $1,719,882.64 | $1,726,556.68 | $1,793,228.36 | $1,768,490.84 | $2,019,017.60 | $2,320,757.60 | $2,630,180.44 | $2,853,987.20 | $2,853,987.20 | $2,869,982.20 | $2,890,911.20 | $2,913,229.20 | ||||
| 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 | $285,771.00 | $395,798.00 | $397,323.00 | $336,757.00 | $1,912,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 | $282,320.00 | $286,553.00 | $267,502.00 | $233,404.00 | $1,528,075.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 | $109,245.00 | $129,821.00 | $103,353.00 | $384,116.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 | $82,875.00 | $73,232.00 | $84,925.00 | $301,424.00 | $58,456.00 | $24,200.00 | $12,004.00 | $19,130.00 | |||||
| Administrative/Workshop | $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 | $82,875.00 | $73,232.00 | $84,925.00 | $301,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 | $276,691.00 | $312,923.00 | $324,091.00 | $251,832.00 | $1,610,767.00 | $1,610,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 | $294.00 | $358.00 | $787.00 | $12,009.00 | $12,009.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 | $170.00 | $234.00 | $222.00 | $6,226.00 | ||||||||
| Accounting consultation | $1,086.00 | $653.00 | $456.00 | $334.00 | $124.00 | $222.00 | $765.00 | $342.00 | $299.00 | $124.00 | $124.00 | $565.00 | $5,094.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,234.00 | $8,335.00 | $8,354.00 | $101,780.00 | $101,780.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 | $65,064.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 | $122.00 | $223.00 | $242.00 | $4,436.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 | $26,808.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 | $5,472.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 | $804.00 | $1,928.00 | $3,027.00 | $27,692.00 | $27,692.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 | $300.00 | $805.00 | $1,278.00 | $8,816.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 | $102.00 | $677.00 | $543.00 | $5,919.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 | $160.00 | $223.00 | $533.00 | $5,196.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 | $5,638.00 | $7,411.16 | $9,219.24 | $110,499.80 | $110,499.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 | $4,325.00 | $5,372.00 | $6,833.00 | $81,760.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,211.00 | $1,504.16 | $1,913.24 | $22,892.80 | |||||||||
| Benefits | $338.00 | $587.00 | $344.00 | $232.00 | $989.00 | $905.00 | $566.00 | $334.00 | $442.00 | $102.00 | $535.00 | $473.00 | $5,847.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 | $666.00 | $1,534.00 | $2,356.00 | $23,951.00 | $23,951.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 | $200.00 | $234.00 | $334.00 | $6,522.00 | ||||||||
| Travel / entertainment | $586.00 | $218.00 | $245.00 | $334.00 | $332.00 | $345.00 | $673.00 | $532.00 | $766.00 | $109.00 | $334.00 | $224.00 | $4,698.00 | |||||||||
| Vehicle expenses | $454.00 | $900.00 | $124.00 | $379.00 | $342.00 | $334.00 | $900.00 | $898.00 | $334.00 | $243.00 | $244.00 | $900.00 | $6,052.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 | $733.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 | $310.00 | $1,683.00 | $1,448.00 | $15,120.00 | $15,120.00 | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Equipment / set up | $501.00 | $132.00 | $211.00 | $911.00 | $721.00 | $234.00 | $755.00 | $902.00 | $783.00 | $334.00 | $212.00 | $783.00 | $766.00 | $7,245.00 | ||||||||
| Furniture and fixtures | $232.00 | $563.00 | $825.00 | $224.00 | $123.00 | $893.00 | $900.00 | $682.00 | $908.00 | $845.00 | $98.00 | $900.00 | $682.00 | $7,875.00 | ||||||||
| Total Expenses | $4,429.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 | $15,946.00 | $21,249.16 | $25,191.24 | $291,051.80 | $291,051.80 | $61,016.00 | $61,016.00 | $61,016.00 | $61,016.00 | |||
| Net Profit (Loss) Before Taxes | -$4,429.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 | $251,673.76 | $296,977.00 | $302,841.84 | $226,640.76 | $1,319,715.20 | $1,319,715.20 | $37,634.00 | -$67,256.00 | -$65,276.00 | -$67,858.00 | |||
| Income taxes | $0.00 | |||||||||||||||||||||
| Net Profit (Loss) After Taxes | -$4,429.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 | $251,673.76 | $296,977.00 | $302,841.84 | $226,640.76 | $1,319,715.20 | $1,319,715.20 | $37,634.00 | -$67,256.00 | -$65,276.00 | -$67,858.00 | |||
| Loan payments - principle | $0.00 | $0.00 | $19,015.00 | $9,242.00 | $3,223.00 | $4,342.00 | ||||||||||||||||
| Capital purchases | $8,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 | $523.00 | $232.00 | $2,332.00 | $164,386.00 | $164,386.00 | $3,432.00 | $172.00 | $223.00 | $2,321.00 | |||
| Cash withdrawals | $133,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 | $356.00 | $2,421.00 | $2,823.00 | $452,226.00 | $452,226.00 | $1,423.00 | $824.00 | $1,216.00 | $543.00 | |||
| Cash injections | $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 | $5,642.00 | $9,234.00 | $2,321.00 | $150,884.00 | $150,884.00 | $2,231.00 | $98,423.00 | $92,256.00 | $93,453.00 | |||
| Net Cash Added (Subtracted) | -$145,569.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 | $250,526.76 | $301,740.00 | $309,422.84 | $223,806.76 | $853,987.20 | $15,995.00 | $20,929.00 | $22,318.00 | $18,389.00 | ||||
| Ending Cash Balance | $1,854,431.00 | $1,869,663.88 | $1,838,026.64 | $1,823,367.88 | $1,869,522.36 | $1,719,882.64 | $1,726,556.68 | $1,793,228.36 | $1,768,490.84 | $2,019,017.60 | $2,320,757.60 | $2,630,180.44 | $2,853,987.20 | $2,853,987.20 | $2,869,982.20 | $2,890,911.20 | $2,913,229.20 | $2,931,618.20 | ||||
REVENUE
COST
EXPENSE
