강의

멘토링

커뮤니티

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.

(5.0) 1 reviews

7 learners

  • dymanagementlab
사업계획서
재무
스타트업
Business Plan
Financial Management

What you will gain after the course

  • Business plan

  • Fundraising


DY Management Research Institute

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

I am Ryu Dae-young, who operates 'DY Management Research Institute' on YouTube and Naver Blog.

Based on my company experience and business administration studies, I want to help those working in related practical fields. I provide a very practical approach that can immediately help with cost accounting, management, accounting, finance, business planning, investment attraction, and overall management. If you want to collaborate on the courses I've uploaded or in my areas of expertise, please contact me via email!


※ Area of Expertise:

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

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

  • I welcome lecture requests, work requests, and Q&A related to specialized fields and YouTube videos.




Companies typically establish medium to long-term plans. Particularly for new startups or startup companies, establishing medium to long-term financial plans is essential for setting up a vision for future growth.


If you're a new startup company, these tasks must be completed before starting your business to accurately determine whether to proceed with the business or not.


If you are an existing company or business division, you can establish such mid to long-term plans and use them to set future growth targets.



※ Medium to long-term financial plans are established in the following manner.

(Explains from sales plan to operating profit.)


- Medium to long-term annual volume plans are established by product. (For startups, revenue typically increases) If there are multiple products, it's better to group them by product line and establish plans for each product group.


- Unit price plans are established by year, and revenue plans are established accordingly.


- Establish a cost plan. Costs must be categorized both as manufacturing costs (cost of goods sold) and selling & administrative expenses, as well as being divided into fixed costs and variable costs.


- When you establish a mid-to-long-term plan, it will be structured to increase revenue. Variable costs should be increased accordingly. For fixed costs, if revenue grows rapidly, it must be accompanied by an increase in personnel. Additionally, investment in tangible and intangible assets is also necessary.


- Before planning fixed costs, establish annual personnel/labor cost plans. When establishing personnel plans, you must consider the annual revenue per employee indicator. While it's natural for personnel to increase as revenue grows, the revenue per employee indicator should decline. This is how economies of scale are realized.


- Calculate tangible and intangible investments by year. Reflect this to calculate depreciation expenses. Since depreciation years differ by asset type, it's better to establish them separately.


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


- By reflecting the previously established variable costs and fixed costs as manufacturing costs and selling & administrative expenses and deducting them from sales revenue, we get the operating profit.


  • Please refer to the figure below for detailed information.
















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

150

Learners

17

Reviews

5

Answers

4.7

Rating

16

Courses

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

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

 

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

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

 

※ 전문분야 :

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

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

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

 

Curriculum

All

4 lectures ∙ (52min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • mars7님의 프로필 이미지
    mars7

    Reviews 4

    Average Rating 5.0

    Edited

    5

    75% enrolled

    실무에서 어떻게 엑셀로 정량 사업계획서를 작성하는지 알수있고 방향을 제시해 주는 내용이었습니다. 저같이 관리회계 실무를 별로 해보지 않은 사람의 길잡이 역활을 해주는 강의였습니다. 막막했었는데 정말 많은 도움이 되었습니다

    • DY경영연구소
      Instructor

      좋은 평가와 리뷰 대단히 감사합니다. 정량사업계획은 기업의 미래를 가이드해 주는 중요한 경영나침반입니다. 제 강의와 자료가 경영목표를 세우는데 도움이 되었으면 좋겠습니다. 감사합니다.

$26.40

dymanagementlab's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!