The World's Leading Business Plan Template Directory

, / 12429 0

IT Business Plan Template [2020 Updated]

SHARE

IX. Financial Plan


You can download our Business Plan Template (including a full, customizable financial model) to your computer here.

Revenue & Cost Drivers

[Company Name]’s revenues will come primarily from the fees earned from client IT Consulting engagements (54% of revenue in first year) and advisory sessions (44%).

As with most services, labor expenses are the key cost drivers. [Founder’s Name] and future consultants will earn a competitive base salary. The lease on the office location will be the next largest cost. Moreover, ongoing marketing expenditures are also notable cost drivers for [Company Name].

Capital Requirements and Use of Funds

[Company Name] is seeking a total funding of $82,000 of debt capital to open its office. The capital will be used for funding capital expenditures and location build-out, hiring initial employees, marketing expenses and working capital.

Specifically, these funds will be used as follows:

  • Office design/build: $49,000
  • Working capital: $33,000 to pay for marketing, salaries, and lease costs until [Company Name] reaches break-even

Key Assumptions & Forecasts

The following table reflects the key revenue and cost assumptions made in the financial model.

Number of clients 
Year 142
Year 263
Year 396
Year 4162
Year 5243
Advisory sessions$100
Project-Fee Services$4,000
Webinars$500
Annual rent$36,000

5 Year Annual Income Statement

  Year 1Year 2Year 3Year 4Year 5
Revenues
Product/Service A$151,200 $333,396 $367,569 $405,245 $446,783
Product/Service B$100,800 $222,264 $245,046 $270,163 $297,855
Total Revenues$252,000 $555,660 $612,615 $675,408 $744,638
Expenses & Costs
Cost of goods sold$57,960 $122,245 $122,523 $128,328 $134,035
Lease$60,000 $61,500 $63,038 $64,613 $66,229
Marketing$20,000 $25,000 $25,000 $25,000 $25,000
Salaries$133,890 $204,030 $224,943 $236,190 $248,000
Other Expenses$3,500 $4,000 $4,500 $5,000 $5,500
Total Expenses & Costs$271,850 $412,775 $435,504 $454,131 $473,263
EBITDA($19,850)$142,885 $177,112 $221,277 $271,374
Depreciation$36,960 $36,960 $36,960 $36,960 $36,960
EBIT($56,810)$105,925 $140,152 $184,317 $234,414
Interest$23,621 $20,668 $17,716 $14,763 $11,810
PRETAX INCOME($80,431)$85,257 $122,436 $169,554 $222,604
Net Operating Loss($80,431)($80,431)$0$0$0
Income Tax Expense$0$1,689 $42,853 $59,344 $77,911
NET INCOME($80,431)$83,568 $79,583 $110,210 $144,693
Net Profit Margin (%)-15.00%13.00%16.30%19.40%

5 Year Annual Balance Sheet

  Year 1Year 2Year 3Year 4Year 5
ASSETS
Cash$16,710 $90,188 $158,957 $258,570 $392,389
Accounts receivable$0$0$0$0$0
Inventory$21,000 $23,153 $25,526 $28,142 $31,027
Total Current Assets$37,710 $113,340 $184,482 $286,712 $423,416
Fixed assets$246,450 $246,450 $246,450 $246,450 $246,450
Depreciation$36,960 $73,920 $110,880 $147,840 $184,800
Net fixed assets$209,490 $172,530 $135,570 $98,610 $61,650
TOTAL ASSETS$247,200 $285,870 $320,052 $385,322 $485,066
LIABILITIES & EQUITY
Debt$317,971 $272,546 $227,122 $181,698 $136,273
Accounts payable$9,660 $10,187 $10,210 $10,694 $11,170
Total Liabilities$327,631 $282,733 $237,332 $192,391 $147,443
Share Capital$0$0$0$0$0
Retained earnings($80,431)$3,137 $82,720 $192,930 $337,623
Total Equity($80,431)$3,137 $82,720 $192,930 $337,623
TOTAL LIABILITIES & EQUITY$247,200 $285,870 $320,052 $385,322 $485,066

5 Year Annual Cash Flow Statement

 Year 1Year 2Year 3Year 4Year 5
CASH FLOW FROM OPERATIONS
Net Income (Loss)($80,431)$83,568 $79,583 $110,210 $144,693
Change in working capital($11,340)($1,625)($2,350)($2,133)($2,409)
Depreciation$36,960 $36,960 $36,960 $36,960 $36,960
Net Cash Flow from Operations($54,811)$118,902 $114,193 $145,037 $179,244
CASH FLOW FROM INVESTMENTS
Investment($246,450)$0$0$0$0
Net Cash Flow from Investments($246,450)$0$0$0$0
CASH FLOW FROM FINANCING
Cash from equity$0$0$0$0$0
Cash from debt$317,971 ($45,424)($45,424)($45,424)($45,424)
Net Cash Flow from Financing$317,971 ($45,424)($45,424)($45,424)($45,424)
SUMMARY
Net Cash Flow$16,710 $73,478 $68,769 $99,613 $133,819
Cash at Beginning of Period$0$16,710 $90,188 $158,957 $258,570
Cash at End of Period$16,710 $90,188 $158,957 $258,570 $392,389

 

 

Pages : 1 2 3 4 5 6 7 8 9 10