From my point of view, the finance part of the project is one of the most vital from all. The reason is because the business should pay off. To be honest, it was quite hard for me to manage how to use properly the Excel, but I figured it out and it worked.
I want to start from the very beginning to show the process how did I manage it. First of all, we started to explore financials on a face to face business session. Our teacher Sara gave us an example of how to make simple charts, after that, we had an individual task, where we had to experiment with a dress comparison and fill in the chart which contained five parts: Place of Goods, Description, Costs Per Metre, Meterage Required and the Cost. I haven’t finished my work, but still want to share.
That was my first attempt at doing financials. I shared this experience because I think that the process is crucial, so after that attempt, I did the Cash Flow for my own beauty brand “Opal”.
This is the Cash Flow chart for the “Opal”. This chart contains ten parts:
- Brought Forward
- Income
- Funds Available
- Expenses
- Set up business
- Purchase of goods
- Sales and Marketing
- Delivery to store
- Total expanses
- Closing Statement
So, I’ve counted the summary according to my budget and put the evidence.
The conclusion is : Overall, according to this cash flow table all of the investments would be paid off. Moreover, outflow will increase on 81% per year.