인프런 영문 브랜드 로고
인프런 영문 브랜드 로고
Business & Marketing

/

Management

Creating a 5-year financial plan for a startup (essential for attracting investment)

Here's how to create a 5-year financial business plan in Excel for startup fundraising and company presentations. We provide a free Excel template.

1 students are taking this course

Business Plan
Financial Management

This course is prepared for Intermediate Learners.

What you will learn!

  • Business plan

  • Fundraising


DY Management Research Institute

(Director Ryu Dae-young, Ph.D. in Business Administration/Business Consultant (Finance))

This is Daeyoung Ryu, who runs the 'DY Management Research Institute' on YouTube and N Blog.

I would like to help those who are working in related fields based on my experience in the company and what I have studied in management. I will provide you with an approach that can help you in a very practical way, from cost, management, accounting, financial business plan, investment attraction, and overall management. If you would like to collaborate on a lecture I have posted or my area of expertise, please contact me by email!


※ Areas of expertise:

  • Management/cost consulting, business review, financial business plan establishment, management simulation, financial projection for investment attraction.

  • Excel practical training, data visualization using Excel, work efficiency using Excel. We will cut your work time in half.

  • We welcome lectures/work requests/Q&As related to specialized fields and YouTube videos.




Companies usually establish mid- to long-term plans. Especially for new startups or startups, establishing mid- to long-term financial plans is essential to establish a vision for future growth.


If you are a new startup, you should do this before starting your business so that you can make an accurate decision on whether or not to go ahead with the business.


If you are an existing company or business unit, you can create these mid- to long-term plans and use them to establish future growth goals.



※ The mid- to long-term financial plan is established in the following manner.

(Explains from sales plan to operating profit.)


- A product-specific quantity plan is established for each mid- to long-term year. (In the case of startups, it is common for sales to increase.) If there are various products, it is better to group them into product groups and establish them by product group.


- A unit price plan is established by year, and a sales plan is established accordingly.


- Establish a cost plan. Costs should be divided into manufacturing costs (cost of sales) and selling and general administrative expenses, and also divided into fixed and variable costs.


- If you establish a mid- to long-term plan, sales will increase. Variable costs will increase accordingly. Fixed costs will have to be accompanied by an increase in personnel when sales increase rapidly. Investment in tangible and intangible assets is also necessary.


- Before the fixed cost plan, establish the annual personnel/personnel cost plan. When establishing the personnel plan, you must establish it while looking at the annual sales per person indicator. It is natural that the number of personnel increases when sales increase, but the sales per person indicator should decrease. Only then can economies of scale be realized.


- Calculate the tangible and intangible investments by year. Calculate the depreciation expense by reflecting this. Since the depreciation period is different for each asset, it is better to establish the depreciation expense separately.


- Establish a fixed cost plan excluding labor and investment costs. If there are no special circumstances, you can establish it by reflecting the personnel increase rate.


- If you reflect the variable and fixed costs established above as manufacturing costs and selling, general and administrative expenses and exclude them from sales, you will get operating profit.


  • Please see the figure below for more details.
















Recommended for
these people!

Who is this course right for?

  • Business Manager

  • Startup

  • aspiring entrepreneur

Need to know before starting?

  • Accounting

  • Business plan

Hello
This is

  • 유튜브 DY경영연구소 : www.youtube.com/@dy-4714

  • 네이버블로그 DY경영연구소 : https://blog.naver.com/udae025

유튜브와 N블로그에서 'DY경영연구소'를 운영하고 있는 류대영입니다.

제가 회사에서 경험한 것과 공부한 것을 바탕으로 관련 실무하시는 분들께 도움을 드리고자 합니다. 원가, 관리, 회계, 재무 사업계획, 투자유치, 경영 전반에 걸쳐 굉장히 실무적으로 바로 도움드릴 수 있는 접근을 해드립니다.

※ 전문분야 :

  • 경영/원가컨설팅, 사업성검토, 재무 사업계획 수립, 경영 시뮬레이션, 투자유치 위한 재무프로젝션 수립.

  • 엑셀 실무교육, 엑셀 활용 데이터 시각화, 엑셀을 활용한 업무효율화. 작업시간을 반으로 줄여드립니다.

  • 전문분야 및 유튜브 영상 관련하여 강의/.작업요청/Q&A환영합니다.

Curriculum

All

4 lectures ∙ (52min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Become the author of a review that helps everyone!