Financial Modeling with Microsoft Excel for Entrepreneurs

Financial Modeling with Microsoft Excel for Entrepreneurs

 

  • Module 2 Ticket

    Module 2 Ticket

    Sale Date Ended

    INR 1500
    Sold Out

Invite friends

Contact Us

Page Views : 1541

About The Event

"Certificate Program in Financial Modelling Using Excel for Entrepreneurs”

Do you feel worried when investors ask for your venture’s financial model?

Want to prepare and analyse your business's financial projections?

Wish to manage your venture's financials in a DO-IT-YOURSELF mode?

If any of your answers is a YES, then you are welcome to attend our next training workshop on Financial Modelling using Excel for Entrepreneurs.

We believe in GOD, everyone else has to give DATA - and as entrepreneurs we need to learn to manage our own data using Microsoft Excel. Entrepreneurs worldwide use this tool for daily decisions related to finance, projects, investment and valuations.Financial models can be used to represent the performance of a business, and find its valuation based on projections and plans.

In this workshop conducted by IIT-IIM alumnus, you will learn to create your venture's financial statements - Profit and Loss, Balance Sheet, Cash Flow etc. using easy templates and hands-on exercises on your laptops, which will be helpful in your day to day operations.

Agenda – Module 1, 25th Jan, 10 AM – 3 PM (Saturday)

15 min - Introduction and Setting Learning Objectives

30 min - MS Excel Tips – Keyboard Shortcuts, Formula, Filters, Formatting

30 min – MS Excel Tricks – Conditional Formatting, Charts, Tables

30 min - Basics of Finance - Revenue Models, Expense Driver, Key Finance Metrics

15 min – Networking Break

60 min – Building Financial Projections - Profit and Loss, Balance Sheet, Cash Flows

30 min - Case Study – Ecommerce Venture

30 min - Pricing, Break-even Analysis, Profitability, Growth drivers using given Format

60 min - Lunch Break and Networking

Agenda – Module 2, 1st Feb, 10 AM – 3 PM (Saturday)

15 min - Introduction and Setting Learning Objectives

30 min – Advance Excel Tips – Pivot Table, Dashboards,

30 min – Advance Excel Tricks - Import/Export Data, Advanced Formulae

30 min – Valuation Modelling using Discounted Cash Flow Method

15 min – Networking Break

30 min - Investment – Equity/Debt, Raising Finance from Angels, VC Firms

30 min – Case Study – Retail Venture

30 min - Live Exercises by Participants for their own Projects using Templates

30 min – Mock Pitch and presentations, critical feedback and mentoring

60 min - Lunch Break and Networking

Trainer - Amit Grover, CEO, Nurture Talent Academy

Amit is an IIT - IIM alumnus and has worked with Infosys, Asian Paints, Onida and Mumbai Angels in the past. He started Nurture Talent Academy, India's 1st Institute for entrepreneurs in 2010, which has conducted 400+ workshops across 125+ cities attended by 30000+ participants. It covers the basics on subjects like business plan, marketing, finance, and technology during the programs. The objective is to enable 1000 ventures to start in next 3-5 years, which will generate 20000 jobs for the country.

Mentors

Pranay Gupta – Co-founder, 91Springboard

Ishank Joshi – Co-founder, NTA

Tarun Gupta – CEO, Pole Vault Consulting

Points to Note

1. All participants will get "Start Study Kit" having book, videos, presentations, excel templates, documents.

2. Participation Certificate will be awarded to all attendees.

3. Participants will be provided with few pre-workshop exercises, which they have to study and try prior to attending workshop

4. Participants need to bring own laptop with MS Excel 2007 or 2010 installed for hands on exercises

Workshop Fees

Module 1 - Rs 1500 per participant includes lunch, kit and taxes

Module 2 – Rs 1500 per participant includes lunch, kit and taxes

Combo Offer – Rs 2700 per participant

Please feel free to get back to us in case of any queries on +91 - 98334 10822 or email at amit.grover@nurturetalent.com

Powered by 91Springboard

About 91Springboard - It has a fun and lively space that can support 150+ entrepreneurs on a full time basis. We take all the headaches out of real estate leasing, security management, internet connections, power backups… you get the idea! We provide an ecosystem where freelancers, entrepreneurs, and creative professionals meet to accelerate their startups without any distractions.

Sponsors and Partners- Dotco, 91springboard, W2E, DEN, Meraevents