وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

How to Create Strategic 5-Year Financial Models in Excel

سرفصل های دوره

Learn how to build a dynamic assumptions-driven financial model in Excel from scratch!


1. Getting Started
  • 1. Welcome to the Course
  • 2. Enable the Developer Tab
  • 3. Install Minty Tools (Student Edition)
  • 4.1 Debt Summary.docx
  • 4.2 Enterprise Value (EV) of the Business.pdf
  • 4.3 Financial Model_Final Version.xlsx
  • 4.4 Group Financials - CY2020-CY2022.xlsx
  • 4.5 Model Assumptions Guidebook.docx
  • 4.6 Model Assumptions Guidebook.pdf
  • 4.7 RockCode Acquistion.docx
  • 4.8 setup.zip
  • 4.9 What is the Cash Conversion Cycle.pdf
  • 4. Download the Course Resources.html
  • 5. Important Excel Formulas
  • 6. Essential Excel Shortcuts
  • 7.1 Financial Model Working_Lecture 07.xlsx
  • 7. Review the Source Data
  • 8. Quiz 1.html

  • 2. Start Working on the Financial Model
  • 1. Outline the Overall Model Structure
  • 2.1 Financial Model Working_Lecture 09.xlsx
  • 2. Build the 3-Statement Reporting Framework
  • 3.1 Financial Model Working_Lecture 10.xlsx
  • 3. Income Statement Drivers 1
  • 4.1 Financial Model Working_Lecture 11.xlsx
  • 4. Income Statement Drivers 2
  • 5.1 Debt Summary.docx
  • 5.2 Financial Model Working_Lecture 12.xlsx
  • 5. Add a Debt Schedule
  • 6.1 Financial Model Working_Lecture 13.xlsx
  • 6. Start a Changelog
  • 7.1 Financial Model Working_Lecture 14.xlsx
  • 7.2 What is the Cash Conversion Cycle.pdf
  • 7. Cash Conversion Cycle and Working Capital
  • 8.1 Financial Model Working_Lecture 15.xlsx
  • 8. Add a Property, Plant & Equipment Schedule
  • 9.1 Financial Model Working_Lecture 16.xlsx
  • 9. Add the Goodwill and Equity Schedules
  • 10.1 Financial Model Working_Lecture 17.xlsx
  • 10. Link the Cash Flow Statement
  • 11. Quiz 2.html

  • 3. Modeling the Core Business Entities
  • 1. Congrats and Welcome to the New Section
  • 2.1 Financial Model Working_Lecture 19.xlsx
  • 2. Dev Entity Replicate the Model and Copy Historicals
  • 3.1 Financial Model Working_Lecture 20.xlsx
  • 3. Dev Entity Adjust Assumptions and Finalize the Model
  • 4.1 Financial Model Working_Lecture 21.xlsx
  • 4. Pipeline Entity Replicate the Model and Copy Historicals
  • 5.1 Financial Model Working_Lecture 22.xlsx
  • 5. Pipeline Entity Adjust Assumptions and Finalize the Model
  • 6.1 Financial Model Working_Lecture 23.xlsx
  • 6. Solids Entity Replicate the Model and Copy Historicals
  • 7.1 Financial Model Working_Lecture 24.xlsx
  • 7. Solids Entity Adjust Assumptions and Finalize the Model
  • 8. Quiz 3.html

  • 4. Build the RockCode Entity Acquisition Model
  • 1. Congrats and Welcome to the New Section
  • 2.1 Financial Model Working_Lecture 26.xlsx
  • 2. Replicate the Model and Copy the Historicals
  • 3.1 Financial Model Working_Lecture 27.xlsx
  • 3.2 RockCode Acquistion.docx
  • 3. Add the Acquisition Section
  • 4.1 Financial Model Working_Lecture 28.xlsx
  • 4. Adjust the Assumptions for Debt, PPE & Goodwill
  • 5.1 Financial Model Working_Lecture 29.xlsx
  • 5. Add Other Liabilities Section and Link Debt, PPE & Goodwill
  • 6.1 Financial Model Working_Lecture 30.xlsx
  • 6. Add Proforma & Date of Acquisition Drop-Down
  • 7.1 Financial Model Working_Lecture 31.xlsx
  • 7. Fix the Date of Acquisition View and Finalize the Model
  • 8. Quiz 4.html

  • 5. Build the Acquisitions Pipeline Model
  • 1. Congrats and Welcome to the New Section
  • 2.1 Financial Model Working_Lecture 33.xlsx
  • 2. Add the Config Tab and the Core Business Summary View
  • 3.1 Financial Model Working_Lecture 34.xlsx
  • 3. Add Ownership, Number of Acquisitions & Revenue Assumptions
  • 4.1 Financial Model Working_Lecture 35.xlsx
  • 4. Model Cost of Sales and EBITDA
  • 5.1 Financial Model Working_Lecture 36.xlsx
  • 5. Model the Operating Expenses
  • 6.1 Financial Model Working_Lecture 37.xlsx
  • 6. Add the Acquisition Valuation Assumptions
  • 7.1 Financial Model Working_Lecture 38.xlsx
  • 7. Add the Acquisition Debt Schedule
  • 8.1 Financial Model Working_Lecture 39.xlsx
  • 8. Add the Cash Conversion Cycle and Working Capital
  • 9.1 Financial Model Working_Lecture 40.xlsx
  • 9. Add the Acquisition Price Split, CAPEX & PPE Assumptions
  • 10.1 Financial Model Working_Lecture 41.xlsx
  • 10. Work on Goodwill, Other Liabilities and the Equity Schedule
  • 11. Quiz 5.html

  • 6. Model the New Product Launch
  • 1. Congrats and Welcome to the New Section
  • 2.1 Financial Model Working_Lecture 43.xlsx
  • 2. Work on the Income Statement Assumptions
  • 3.1 Financial Model Working_Lecture 44.xlsx
  • 3. Fix the Acquisitions Pipeline Taxes Calculation
  • 4.1 Financial Model Working_Lecture 45.xlsx
  • 4. Add the Cash Conversion Cycle, PPE & Equity Schedules
  • 5.1 Financial Model Working_Lecture 46.xlsx
  • 5. Add Scenarios to the Model
  • 6. Quiz 6.html

  • 7. Finalizing the Financial Model
  • 1. Congrats and Welcome to the New Section
  • 2.1 Financial Model Working_Lecture 48.xlsx
  • 2. Create the Revenue & Margins Summary
  • 3.1 Financial Model Working_Lecture 49.xlsx
  • 3. Create the Consolidated View and Eliminations Schedule
  • 4.1 Enterprise Value (EV) of the Business.pdf
  • 4.2 Financial Model Working_Lecture 50.xlsx
  • 4. Create the Company Valuation Tab
  • 5.1 Financial Model Working_Lecture 51.xlsx
  • 5. Add a Revenue Step Up Chart
  • 6.1 Financial Model Working_Lecture 52.xlsx
  • 6. Add a Table Of Contents and Finalize the Model
  • 7.1 Assumptions Guidebook_Lecture 53.docx
  • 7.2 Financial Model Working_Lecture 53.xlsx
  • 7. Create the Assumptions Guidebook for the Model
  • 8.1 Financial Model Working_Lecture 54.xlsx
  • 8. Make the Model Open as Read-Only by Default
  • 9. Quiz 7.html
  • 10. Congratulations on Completing the Course!

  • 8. Bonus Section
  • 1. Bonus Lecture.html
  • 45,900 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 565
    حجم: 3094 مگابایت
    مدت زمان: 346 دقیقه
    تاریخ انتشار: 22 دی 1401
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    45,900 تومان
    افزودن به سبد خرید