I Tech Solutions

Start your own business plan »

Computer Support Business Plan

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Products/Services 0% P31,605 P31,605 P31,605 P105,350 P105,350 P105,350 P168,560 P168,560 P168,560 P168,560 P168,560 P168,560
Other 0% P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Total Sales P31,605 P31,605 P31,605 P105,350 P105,350 P105,350 P168,560 P168,560 P168,560 P168,560 P168,560 P168,560
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Products/Services P15,803 P15,803 P15,803 P52,675 P52,675 P52,675 P84,280 P84,280 P84,280 P84,280 P84,280 P84,280
Other P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Subtotal Direct Cost of Sales P15,803 P15,803 P15,803 P52,675 P52,675 P52,675 P84,280 P84,280 P84,280 P84,280 P84,280 P84,280
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Directors 0% P7,500 P7,500 P7,500 P7,500 P7,500 P7,500 P15,000 P15,000 P15,000 P15,000 P15,000 P15,000
Personal Assistant 0% P900 P900 P900 P900 P900 P900 P900 P900 P900 P900 P900 P900
Cleaner 0% P300 P300 P300 P300 P300 P300 P300 P300 P300 P300 P300 P300
Total People 5 5 5 5 5 5 5 5 5 5 5 5
Total Payroll P8,700 P8,700 P8,700 P8,700 P8,700 P8,700 P16,200 P16,200 P16,200 P16,200 P16,200 P16,200
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current Interest Rate 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00%
Long-term Interest Rate 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00% 17.00%
Tax Rate 30.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Profit and Loss
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales P31,605 P31,605 P31,605 P105,350 P105,350 P105,350 P168,560 P168,560 P168,560 P168,560 P168,560 P168,560
Direct Cost of Sales P15,803 P15,803 P15,803 P52,675 P52,675 P52,675 P84,280 P84,280 P84,280 P84,280 P84,280 P84,280
Other P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Total Cost of Sales P15,803 P15,803 P15,803 P52,675 P52,675 P52,675 P84,280 P84,280 P84,280 P84,280 P84,280 P84,280
Gross Margin P15,802 P15,802 P15,802 P52,675 P52,675 P52,675 P84,280 P84,280 P84,280 P84,280 P84,280 P84,280
Gross Margin % 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Expenses
Payroll P8,700 P8,700 P8,700 P8,700 P8,700 P8,700 P16,200 P16,200 P16,200 P16,200 P16,200 P16,200
Sales and Marketing and Other Expenses P6,300 P2,100 P2,100 P7,368 P7,368 P7,368 P10,528 P10,528 P10,528 P10,528 P10,528 P10,528
Depreciation P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Utilities P300 P300 P300 P300 P300 P300 P300 P300 P300 P300 P300 P300
Telephone P500 P500 P500 P500 P500 P500 P500 P500 P500 P500 P500 P500
Insurance P1,200 P1,200 P1,200 P1,200 P1,200 P1,200 P1,200 P1,200 P1,200 P1,200 P1,200 P1,200
Rent P1,400 P1,400 P1,400 P1,400 P1,400 P1,400 P1,400 P1,400 P1,400 P1,400 P1,400 P1,400
Insurance P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Payroll Taxes 0% P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Other P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Total Operating Expenses P18,400 P14,200 P14,200 P19,468 P19,468 P19,468 P30,128 P30,128 P30,128 P30,128 P30,128 P30,128
Profit Before Interest and Taxes (P2,598) P1,602 P1,602 P33,207 P33,207 P33,207 P54,152 P54,152 P54,152 P54,152 P54,152 P54,152
EBITDA (P2,598) P1,602 P1,602 P33,207 P33,207 P33,207 P54,152 P54,152 P54,152 P54,152 P54,152 P54,152
Interest Expense P8,378 P8,256 P8,135 P8,013 P7,891 P7,769 P7,647 P7,525 P7,404 P7,282 P7,160 P7,038
Taxes Incurred (P3,293) (P1,664) (P1,633) P6,299 P6,329 P6,360 P11,626 P11,657 P11,687 P11,718 P11,748 P11,779
Net Profit (P7,683) (P4,991) (P4,899) P18,896 P18,987 P19,079 P34,879 P34,970 P35,061 P35,153 P35,244 P35,336
Net Profit/Sales -24.31% -15.79% -15.50% 17.94% 18.02% 18.11% 20.69% 20.75% 20.80% 20.85% 20.91% 20.96%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales P9,482 P9,482 P9,482 P31,605 P31,605 P31,605 P50,568 P50,568 P50,568 P50,568 P50,568 P50,568
Cash from Receivables P0 P737 P22,124 P22,124 P23,844 P73,745 P73,745 P75,220 P117,992 P117,992 P117,992 P117,992
Subtotal Cash from Operations P9,482 P10,219 P31,605 P53,729 P55,449 P105,350 P124,313 P125,788 P168,560 P168,560 P168,560 P168,560
Additional Cash Received
Sales Tax, VAT, HST/GST Received 0.00% P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
New Current Borrowing P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
New Other Liabilities (interest-free) P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
New Long-term Liabilities P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Sales of Other Current Assets P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Sales of Long-term Assets P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
New Investment Received P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Subtotal Cash Received P9,482 P10,219 P31,605 P53,729 P55,449 P105,350 P124,313 P125,788 P168,560 P168,560 P168,560 P168,560
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending P8,700 P8,700 P8,700 P8,700 P8,700 P8,700 P16,200 P16,200 P16,200 P16,200 P16,200 P16,200
Bill Payments P1,599 P47,302 P27,893 P30,821 P116,958 P77,660 P80,061 P151,085 P117,387 P117,296 P117,204 P117,113
Subtotal Spent on Operations P10,299 P56,002 P36,593 P39,521 P125,658 P86,360 P96,261 P167,285 P133,587 P133,496 P133,404 P133,313
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Principal Repayment of Current Borrowing P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Other Liabilities Principal Repayment P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Long-term Liabilities Principal Repayment P8,600 P8,600 P8,600 P8,600 P8,600 P8,600 P8,600 P8,600 P8,600 P8,600 P8,600 P8,600
Purchase Other Current Assets P0 P0 P141,200 P0 P0 P0 P0 P0 P0 P0 P0 P0
Purchase Long-term Assets P20,000 P20,000 P20,000 P20,000 P20,000 P20,000 P20,000 P20,000 P20,000 P20,000 P20,000 P20,000
Dividends P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Subtotal Cash Spent P38,899 P84,602 P206,393 P68,121 P154,258 P114,960 P124,861 P195,885 P162,187 P162,096 P162,004 P161,913
Net Cash Flow (P29,418) (P74,383) (P174,788) (P14,393) (P98,809) (P9,610) (P548) (P70,097) P6,373 P6,464 P6,556 P6,647
Cash Balance P462,833 P388,450 P213,662 P199,269 P100,460 P90,850 P90,303 P20,206 P26,579 P33,043 P39,599 P46,246
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash P492,251 P462,833 P388,450 P213,662 P199,269 P100,460 P90,850 P90,303 P20,206 P26,579 P33,043 P39,599 P46,246
Accounts Receivable P0 P22,124 P43,510 P43,510 P95,131 P145,032 P145,032 P189,279 P232,051 P232,051 P232,051 P232,051 P232,051
Inventory P0 P17,383 P17,383 P17,383 P57,943 P57,943 P57,943 P92,708 P92,708 P92,708 P92,708 P92,708 P92,708
Other Current Assets P0 P0 P0 P141,200 P141,200 P141,200 P141,200 P141,200 P141,200 P141,200 P141,200 P141,200 P141,200
Total Current Assets P492,251 P502,340 P449,343 P415,755 P493,543 P444,635 P435,025 P513,490 P486,165 P492,538 P499,002 P505,558 P512,205
Long-term Assets
Long-term Assets P0 P20,000 P40,000 P60,000 P80,000 P100,000 P120,000 P140,000 P160,000 P180,000 P200,000 P220,000 P240,000
Accumulated Depreciation P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Total Long-term Assets P0 P20,000 P40,000 P60,000 P80,000 P100,000 P120,000 P140,000 P160,000 P180,000 P200,000 P220,000 P240,000
Total Assets P492,251 P522,340 P489,343 P475,755 P573,543 P544,635 P555,025 P653,490 P646,165 P672,538 P699,002 P725,558 P752,205
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable P0 P46,373 P26,966 P26,878 P114,370 P75,074 P74,986 P147,172 P113,477 P113,389 P113,300 P113,212 P113,124
Current Borrowing P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Other Current Liabilities P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0 P0
Subtotal Current Liabilities P0 P46,373 P26,966 P26,878 P114,370 P75,074 P74,986 P147,172 P113,477 P113,389 P113,300 P113,212 P113,124
Long-term Liabilities P600,000 P591,400 P582,800 P574,200 P565,600 P557,000 P548,400 P539,800 P531,200 P522,600 P514,000 P505,400 P496,800
Total Liabilities P600,000 P637,773 P609,766 P601,078 P679,970 P632,074 P623,386 P686,972 P644,677 P635,989 P627,300 P618,612 P609,924
Paid-in Capital P100,000 P100,000 P100,000 P100,000 P100,000 P100,000 P100,000 P100,000 P100,000 P100,000 P100,000 P100,000 P100,000
Retained Earnings (P207,749) (P207,749) (P207,749) (P207,749) (P207,749) (P207,749) (P207,749) (P207,749) (P207,749) (P207,749) (P207,749) (P207,749) (P207,749)
Earnings P0 (P7,683) (P12,674) (P17,573) P1,322 P20,309 P39,388 P74,267 P109,237 P144,298 P179,451 P214,695 P250,030
Total Capital (P107,749) (P115,432) (P120,423) (P125,322) (P106,427) (P87,440) (P68,361) (P33,482) P1,488 P36,549 P71,702 P106,946 P142,281
Total Liabilities and Capital P492,251 P522,340 P489,343 P475,755 P573,543 P544,635 P555,025 P653,490 P646,165 P672,538 P699,002 P725,558 P752,205
Net Worth (P107,749) (P115,432) (P120,423) (P125,322) (P106,427) (P87,440) (P68,361) (P33,482) P1,488 P36,549 P71,702 P106,946 P142,281