Make a financial plan for a small EPC solar installation company

Make a financial plan for 2022 and 2023 .
Negative hypothesis = 50 % of the turnover
Positive hypotheses = 100 % of the turnover

In monthly figures simulation
Figure analysis simulation
Rentability analysis simulation
Graphic analysis
Monthly thesaurie in graphics
Calculate the need for financing at 3 % intrest rate in the different months

Incoming payments from customers:

50 % of them pay like this:

week 1 = 30 % downpayment at week 1
week 8 = 60 % balance payment
week 10 = final payment

50 % of them will pay like this;

week 1 = 70 % downpayment at week 1
week 8 = 20 % balance payment
week 10 = final payment



payments to suppliers:
50 % = payment 1 week before delivery (EU import)
50 % = payment 30 %, 70 % at delivery 12 weeks later (China import to EU)
Credit line from local small suppliers 50 000 € - 30 days payment term


Monthly commission purchase manager 5 % (on purchase price)
Monthly commission sales team 7 % (on sales price)
Monthly Commission on sales manager team (50 % of the total from the 7,5 %, so 3,5 %)
Monthly expenses labor cost 10 % of sales price
Monthly expenses admin 6000 €

not fast rotating stock value which is mostly in warehouse = 10 000 €

May 2022

100 000 € purchase materials
220 000 € sales

June 2022

150 000 € purchase materials
360 000 € sales materials

July 2022

150 000 € purchase materials
360 000 € sales materials

August 2022

200 000 € purchase materials
440 000 € sales materials

September 2022

200 000 € purchase materials
440 000 € sales materials

October 2022

200 000 € purchase materials
440 000 € sales materials

November 2022

200 000 € purchase materials
440 000 € sales materials

December 2022

200 000 € purchase materials
440 000 € sales materials