Question
For this assignment, assume that you are part of a team that is preparing to Launch Sunflower Solar LLC , a solar panel installation company
For this assignment, assume that you are part of a team that is preparing to Launch Sunflower Solar LLC, a solar panel installation company that will be located in Wichita, KS. You will need to construct/estimate a pro forma (future projections) income statement for this company using the information provided below.
Sunflower Solar is targeting residential and commercial customers in south central Kansas. Installing solar panel on the roof of an individual residence or business is growing in popularity as more people and businesses are interested in cutting long term energy costs that continue to increase each year. While installations costs are expensive - $20,000 on average for a residence and more expensive for a business installation prices are decreasing as solar panel costs decrease. The federal government in the U.S. allows homeowners to deduct 30% of the cost of the solar installation from their taxes. For now, this tax credit is available through 2021.
According to Solar Energy Industries Association, the solar installation industry has experienced an average annual growth rate of 54%. Another industry report from IBIS World projects that annual growth in the solar panel installation industry over the next five years will be 14 %. Please recognize that these two estimates (54 % and 14%) reflect average growth projections for all companies in the industry. A startup will likely experience much higher growth because they are going from $0 sales to some level of sales, which will result in a higher amount of sales growth.
Below I list the sales and sales growth of several solar panel installation companies on the Inc. 5000 list for 2016, 2017, and 2018. Notice that their sales growth is much higher than the industry averages. These sales growth figures are likely in part because these firms are relatively new (e.g., startups) and in a growth industry (an industry where everyone grows). You will likely want to project your sales growth for this assignment somewhere between the industry estimates and these high growth firms in the industry.
EnviroSolar Power (Fort Worth, TX) 2016 sales $37.4 M; 3-year growth = 36,065.
Missouri Sun Solar (Springfield, MO) 2015 sales = $9.8 M; 3-year growth = 2,327%; 2013 sales = $421.143. Founded in 2012
Auric Solar (West Valley, UT) 2017 sales = $49.7 M, 2016 sales = $44.1 M, 2015 sales = $28.9 M; 2014 sales = $13.6 M, and 2012 sales = $755,000. 3 year growth = 309% (2014-2017). Founded in 2010. Employees 200
Wells Solar (Austin, TX) 2017 sales = $9.6 M; 2015 sales = $ 435,375; 3 year growth = 2,205%; Founded in 2014. Employees 41
3D Solar (Odessa, FL) 2017 sales = $3.7 M; 2015 sales = $547,337; 3-year growth = 676%; Founded in 2013. Employees 43
Cromwell Solar located in Lawrence Kansas installs 100 solar projects each year in the Kansas and Missouri region.
Industry Estimated Costs from IBIS World
Net Sales 100%
Costs of Goods sold is 46% (This means that operating profit is 54% of sales)
Operating Expenses is 48% of sales.
Using the data above, calculate the income statement for Sunflower Solar for the next three years.
| Year 1 | Year 2 | Year 3 |
# of solar installations (units) |
|
|
|
Price |
|
|
|
Total Sales |
|
|
|
|
|
|
|
Costs of Goods Sold |
|
|
|
Gross Margin |
|
|
|
|
|
|
|
Operating Expenses |
|
|
|
Gross Profit |
|
|
|
Calculations in Spreadsheet:
Total Sales = # of units x price
Gross Margin = Total Sales Gross Margin
Gross Profit = Gross Margin Operating Expenses
Assumption Sheet: How did you calculate your price, total sales, sales growth, and expense (e.g., cost of goods sold and operating expenses) projections? Please describe your logic.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started