Solar Farms Business Plan Template [Updated 2024]

/ 34799 0

IX. Financial Plan


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

Revenue and Cost Drivers

[Company Name]’s revenues will come primarily from energy contracts.

The lease, research, maintenance and staff expenses are the key cost drivers of [Company Name]. Moreover, ongoing marketing expenditures are also notable cost drivers for the company.

Capital Requirements and Use of Funds

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

Specifically, these funds will be used as follows:

  • Research, product sourcing/purchase, and equipment: $170,000
  • Headquarters design/build: $90,000
  • Working capital: $210,000 to pay for marketing, salaries, and lease costs until [Company Name] reaches break-even

Key Assumptions

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

Clients per QuarterAverage
FY 128
FY 256
FY 380
FY 4100
FY 5124
Annual Lease/rent ( per location)$50,000
Yearly Lease Increase %2.50%

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

 

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

 

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