I Tech Solutions
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 |