Tuyệt đỉnh Excel - Chinh phục nghiệp vụ văn phòng!
dymanagementlab
Chúng tôi sẽ tiến hành giảng dạy về Excel thực tế, ứng dụng trong công việc tại công ty. Đây là khóa học Excel hoàn toàn thực tế, dành cho công việc văn phòng.
초급
Excel
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.
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))
YouTube : www.youtube.com/@dy-4714
N Blog : https://blog.naver.com/udae025
Email: daeyoung.lyu@gmail.com
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
151
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
cosmos7Reviews 4
∙
Average Rating 5.0
Edited
5
75% enrolledĐây là nội dung giúp tôi hiểu được cách lập kế hoạch kinh doanh định lượng bằng Excel trong thực tế và đưa ra hướng dẫn cụ thể. Đối với những người như tôi chưa có nhiều kinh nghiệm thực tế về kế toán quản trị, khóa học này đã đóng vai trò như người dẫn đường. Trước đây tôi cảm thấy bối rối nhưng giờ đã được giúp đỡ rất nhiều.
- dymanagementlabInstructor
Cảm ơn rất nhiều vì những đánh giá và nhận xét tích cực. Kế hoạch kinh doanh định lượng là la bàn quản lý quan trọng giúp định hướng tương lai của doanh nghiệp. Tôi hy vọng bài giảng và tài liệu của tôi đã giúp ích cho việc thiết lập các mục tiêu kinh doanh của bạn. Cảm ơn bạn.
$26.40
dymanagementlab's other courses
Check out other courses by the instructor!
Similar courses
Explore other courses in the same field!
