آموزش مدل سازی مالی در اکسل: ارزش گذاری مالی با Excel
-
مدل سازی مالی در اکسل برای ارزش گذاری و تحلیل پروژه های اقتصادی!
اگر هیچ آشنایی قبلی با نرم افزارهای مالی ندارید آموزش مدل سازی مالی در اکسل از آکادمی آترو نجات دهنده کسب و کار شما خواهد بود! نظم و انضباط از مهم ترین دلایل موفقیت در آینده مالی و اقتصادی هر بیزینس است که همین امر موجب شده است تا سالیان سال جایگاه نرم افزار Excel، در میان ضروری ترین ابزارهای کسب و کاری حفظ شده باقی بماند.
علاوه بر نیاز به گذراندن دوره آموزشی جهت کار با اکسل، سهولت روند یادگیری و استفاده از این نرم افزار آن را به یک وجه تمایز بین شرکت های کوچک و بزرگ تبدیل می کند. نرم افزار صفحه گستر اکسل با وجود سادگی می تواند حجم بالایی از اطلاعات پیچیده را در کسری از ثانیه تحلیل کرده و برای بررسی بهتر در اختیار شما قرار دهد.
همچنین شما می توانید با کمک ترفندهای ارزش گذاری مالی Excel مانند ایجاد توابع، فرمول نویسی، بررسی های میزان ریسک سرمایه، حساسیت های بازار، احتمالات ورشکستگی و ... پر قدرت وارد بازار کار شوید. پس اگر به دنبال یک مدرک قابل ترجمه و بین المللی در زمینه توسعه مهارت های دقیق مالی خود می گردید، آموزش مدل سازی مالی اکسل آکادمی آترو بهترین انتخاب برای شما خواهد بود.
جزئیات   دورهگواهینداردسطح دورهجامعزبان دورهفارسیتعداد دوره400دستهآموزش های اکسلزیر نویسداردتعداد فایل0نوع دورهآنلایننوع دسترسینامحدود -
جلسه 1 What Does the course cover?3 دقیقهWhat Does the course cover?جلسه 2 Bonus! Welcome giftBonus! Welcome giftجلسه 3 Welcome gift number 2Welcome gift number 2جلسه 4 The best way to take this course?2 دقیقهThe best way to take this course?جلسه 5 Download all course materials and frequ...2 دقیقهDownload all course materials and frequently asked questions (FAQ)جلسه 1 Introduction to Excel1 دقیقهIntroduction to Excelجلسه 2 Overview of Excel3 دقیقهOverview of Excelجلسه 3 Overview of ExcelOverview of Excelجلسه 4 The Excel ribbon2 دقیقهThe Excel ribbonجلسه 5 Basic operations with rows and columns1 دقیقهBasic operations with rows and columnsجلسه 6 Data entry in Excel3 دقیقهData entry in Excelجلسه 7 Introduction to formatting5 دقیقهIntroduction to formattingجلسه 8 Rows and columnsRows and columnsجلسه 9 Introduction to Excel formulas4 دقیقهIntroduction to Excel formulasجلسه 10 Introduction to Excel formulasIntroduction to Excel formulasجلسه 11 Introduction to Excel functions3 دقیقهIntroduction to Excel functionsجلسه 12 Cut, copy, & paste2 دقیقهCut, copy, & pasteجلسه 13 Cut, copy, & pasteCut, copy, & pasteجلسه 14 Paste special1 دقیقهPaste specialجلسه 15 Format cells5 دقیقهFormat cellsجلسه 16 Basic operations in Excel - 38 pagesBasic operations in Excel - 38 pagesجلسه 1 Basic Excel - Practice activityBasic Excel - Practice activityجلسه 1 Excel best practices - Welcome lecture1 دقیقهExcel best practices - Welcome lectureجلسه 2 Initial formatting of Excel sheets for ...2 دقیقهInitial formatting of Excel sheets for a professional layoutجلسه 3 Fast scrolling through Excel sheets1 دقیقهFast scrolling through Excel sheetsجلسه 4 Fast scrolling through Excel sheetsFast scrolling through Excel sheetsجلسه 5 Be even quicker: F5 + Enter2 دقیقهBe even quicker: F5 + Enterجلسه 6 Fixing cell references2 دقیقهFixing cell referencesجلسه 7 Introduction to fixing of cell referenc...Introduction to fixing of cell referencesجلسه 8 Alt + Enter1 دقیقهAlt + Enterجلسه 9 Organize your data with text to columns2 دقیقهOrganize your data with text to columnsجلسه 10 Learn how to organize your data with te...Learn how to organize your data with text to columnsجلسه 11 The wrap text button1 دقیقهThe wrap text buttonجلسه 12 Set print area1 دقیقهSet print areaجلسه 13 Custom sort helps you sort multiple col...1 دقیقهCustom sort helps you sort multiple columns in Excel tablesجلسه 14 Create drop-down lists with data valida...2 دقیقهCreate drop-down lists with data validationجلسه 15 Find and select special types of cells ...1 دقیقهFind and select special types of cells with Select special (F5)جلسه 16 Select SpecialSelect Specialجلسه 17 Assign dynamic names in a financial mod...1 دقیقهAssign dynamic names in a financial modelجلسه 18 Assigning dynamic namesAssigning dynamic namesجلسه 19 Define a named range in Excel1 دقیقهDefine a named range in Excelجلسه 20 Define a named range in Excel1 دقیقهDefine a named range in Excelجلسه 21 Introduction to custom formatting in Ex...6 دقیقهIntroduction to custom formatting in Excelجلسه 22 Apply custom formatting in a financial ...1 دقیقهApply custom formatting in a financial modelجلسه 23 Macros are a great timesaver! Here's wh...3 دقیقهMacros are a great timesaver! Here's why!جلسه 24 How to save macros and use them across ...1 دقیقهHow to save macros and use them across several workbooksجلسه 25 Excel macros - quizExcel macros - quizجلسه 26 Fix the top row of your table with free...1 دقیقهFix the top row of your table with freeze panesجلسه 27 How to search functionalities in Excel1 دقیقهHow to search functionalities in Excelجلسه 28 Filter by color - an excellent tool1 دقیقهFilter by color - an excellent toolجلسه 29 Working with conditional formatting5 دقیقهWorking with conditional formattingجلسه 30 Useful tips and tools for your work in ...Useful tips and tools for your work in Excel - quizجلسه 31 A neat trick - Multiply by 11 دقیقهA neat trick - Multiply by 1جلسه 32 Find and replace - references3 دقیقهFind and replace - referencesجلسه 33 FAQ: Why do we replace external referen...1 دقیقهFAQ: Why do we replace external references and how does this help us?جلسه 34 Find and replace - formatting2 دقیقهFind and replace - formattingجلسه 35 Removing (automatic) green arrows1 دقیقهRemoving (automatic) green arrowsجلسه 36 Beauty saving - The professional way of...2 دقیقهBeauty saving - The professional way of saving filesجلسه 37 Formula auditing with F22 دقیقهFormula auditing with F2جلسه 1 Excel tips & tools - Practice activityExcel tips & tools - Practice activityجلسه 1 Keyboard shortcuts save LOTS of time in...5 دقیقهKeyboard shortcuts save LOTS of time in Excelجلسه 2 Keyboard shortcuts in ExcelKeyboard shortcuts in Excelجلسه 1 Excel's key functions - Welcome lecture1 دقیقهExcel's key functions - Welcome lectureجلسه 2 A helpful consideration1 دقیقهA helpful considerationجلسه 3 Key functions in Excel: IF2 دقیقهKey functions in Excel: IFجلسه 4 Key Excel functions: SUM, SUMIF and SUM...4 دقیقهKey Excel functions: SUM, SUMIF and SUMIFSجلسه 5 = and + are interchangeable when you st...1 دقیقه= and + are interchangeable when you start typing a formulaجلسه 6 Key Excel functions: COUNT, COUNTA, COU...4 دقیقهKey Excel functions: COUNT, COUNTA, COUNTIF, COUNTIFSجلسه 7 Key Excel functions: AVERAGE and AVERAG...2 دقیقهKey Excel functions: AVERAGE and AVERAGEIFجلسه 8 Key Excel functions: AVERAGE and AVERAG...Key Excel functions: AVERAGE and AVERAGEIFجلسه 9 Work with text efficiently: LEFT, RIGHT...4 دقیقهWork with text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATEجلسه 10 Work with text efficiently: LEFT, RIGHT...Work with text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATEجلسه 11 Working with text (continued)2 دقیقهWorking with text (continued)جلسه 12 Find the minimum or maximum value in a ...1 دقیقهFind the minimum or maximum value in a range of cells in Excelجلسه 13 Include ROUND in your financial models1 دقیقهInclude ROUND in your financial modelsجلسه 14 key Excel functions: VLOOKUP and HLOOKU...7 دقیقهkey Excel functions: VLOOKUP and HLOOKUPجلسه 15 How to enlarge the formula bar1 دقیقهHow to enlarge the formula barجلسه 16 INDEX, MATCH and their combination - th...7 دقیقهINDEX, MATCH and their combination - the perfect substitute for VLOOKUPجلسه 17 A great Excel technique: INDEX, MATCH, ...5 دقیقهA great Excel technique: INDEX, MATCH, MATCHجلسه 18 INDEX, MATCH and their combination - th...INDEX, MATCH and their combination - the perfect substitute for VLOOKUPجلسه 19 XLOOKUP: a solid substitute for VLOOKUP...6 دقیقهXLOOKUP: a solid substitute for VLOOKUP and INDEX&MATCHجلسه 20 Using Excel's IFERROR function to trap ...1 دقیقهUsing Excel's IFERROR function to trap spreadsheet errorsجلسه 21 RANK is a valuable tool when using Exce...2 دقیقهRANK is a valuable tool when using Excel for financial and business analysisجلسه 22 CHOOSE - Learn how to render your model...2 دقیقهCHOOSE - Learn how to render your models flexibleجلسه 23 Use Goal Seek to find the result that y...2 دقیقهUse Goal Seek to find the result that you are looking forجلسه 24 Use Goal Seek in order to find the resu...Use Goal Seek in order to find the result that you are looking forجلسه 25 Include sensitivity analysis in your mo...4 دقیقهInclude sensitivity analysis in your models through Data Tablesجلسه 26 Include sensitivity analysis in your mo...Include sensitivity analysis in your models through Data Tablesجلسه 27 Excel's dynamic and interactive tables:...2 دقیقهExcel's dynamic and interactive tables: Pivot tablesجلسه 28 Excel's key functions and functionaliti...Excel's key functions and functionalities made easyجلسه 1 Exercise - Excel's SUMIFS function - un...Exercise - Excel's SUMIFS function - unsolvedجلسه 2 Exercise - Update SUMIFS function - sol...8 دقیقهExercise - Update SUMIFS function - solved and explainedجلسه 1 Excel formulas - Practice activityExcel formulas - Practice activityجلسه 1 Future and present values in Excel7 دقیقهFuture and present values in Excelجلسه 2 Calculating the rate of return of an in...3 دقیقهCalculating the rate of return of an investment with the IRR functionجلسه 3 Calculating a complete loan schedule in...6 دقیقهCalculating a complete loan schedule in Excelجلسه 4 Date functions in Excel5 دقیقهDate functions in Excelجلسه 1 Introduction to Pivot Tables and the wa...1 دقیقهIntroduction to Pivot Tables and the way they are appliedجلسه 2 Creating Pivot Tables easily!3 دقیقهCreating Pivot Tables easily!جلسه 3 Give your Excel Pivot Tables a makeover2 دقیقهGive your Excel Pivot Tables a makeoverجلسه 4 Modifying and pivoting fields to obtain...4 دقیقهModifying and pivoting fields to obtain the Pivot Table you needجلسه 5 Learn more about GETPIVOTDATA - A very ...3 دقیقهLearn more about GETPIVOTDATA - A very important Excel functionجلسه 6 An introduction to slicers - The modern...4 دقیقهAn introduction to slicers - The modern-day Pivot Table filtersجلسه 1 Case study - Build a P&L from scratch -...1 دقیقهCase study - Build a P&L from scratch - Welcome lectureجلسه 2 Introduction to the case study1 دقیقهIntroduction to the case studyجلسه 3 Understand your data source before you ...2 دقیقهUnderstand your data source before you start working on itجلسه 4 Order the source worksheets2 دقیقهOrder the source worksheetsجلسه 5 Create a code: the best way to organize...2 دقیقهCreate a code: the best way to organize your data and work efficiently with itجلسه 6 Learn how to create a database2 دقیقهLearn how to create a databaseجلسه 7 Use VLOOKUP to fill the database sheet5 دقیقهUse VLOOKUP to fill the database sheetجلسه 8 Use SUMIF to complete the database shee...4 دقیقهUse SUMIF to complete the database sheetجلسه 9 FAQ: Sum of FY2018 doens't go down to z...1 دقیقهFAQ: Sum of FY2018 doens't go down to zeroجلسه 10 Use INDEX & MATCH as a substitute for V...3 دقیقهUse INDEX & MATCH as a substitute for VLOOKUPجلسه 11 Substituting VLOOKUP with XLOOKUP (Offi...2 دقیقهSubstituting VLOOKUP with XLOOKUP (Office 365 Only)جلسه 12 Mapping the rows in the database sheet2 دقیقهMapping the rows in the database sheetجلسه 13 In case you have any doubts about the M...6 دقیقهIn case you have any doubts about the Mapping exerciseجلسه 14 Building the structure of the P&L sheet2 دقیقهBuilding the structure of the P&L sheetجلسه 15 Formatting sets You apart from the comp...3 دقیقهFormatting sets You apart from the competition in Excel - A Practical Exampleجلسه 16 Populate the P&L sheet with SUMIF2 دقیقهPopulate the P&L sheet with SUMIFجلسه 17 FAQ: Why the sum of the check should be...1 دقیقهFAQ: Why the sum of the check should be 0?جلسه 18 Learn how to find mistakes with COUNTIF2 دقیقهLearn how to find mistakes with COUNTIFجلسه 19 Calculating year-on-year percentage var...3 دقیقهCalculating year-on-year percentage variations the proper wayجلسه 20 FAQ: Why do we subtract -1 when calcula...1 دقیقهFAQ: Why do we subtract -1 when calculating year-on-year growth?جلسه 1 How to insert a chart in Excel2 دقیقهHow to insert a chart in Excelجلسه 2 Editing Excel charts2 دقیقهEditing Excel chartsجلسه 3 Excel chart formatting3 دقیقهExcel chart formattingجلسه 4 How to create a bridge chart in Excel1 دقیقهHow to create a bridge chart in Excelجلسه 5 New ways to visualize your data - Treem...1 دقیقهNew ways to visualize your data - Treemap chartsجلسه 6 Sparklines3 دقیقهSparklinesجلسه 1 Create professional and good-looking ch...1 دقیقهCreate professional and good-looking charts - Introductionجلسه 2 Build a column stacked chart with a sec...5 دقیقهBuild a column stacked chart with a secondary line axis in Excelجلسه 3 Learn how to build effective doughnut c...5 دقیقهLearn how to build effective doughnut charts in Excelجلسه 4 Learn how to build an area chart in Exc...3 دقیقهLearn how to build an area chart in Excelجلسه 5 Learn how to create bridge charts6 دقیقهLearn how to create bridge chartsجلسه 6 Learn how to create bridge charts in Ex...10 دقیقهLearn how to create bridge charts in Excel 2007, 2010, and 2013جلسه 7 Case Study - Building a Complete P&L fr...Case Study - Building a Complete P&L from scratch in Excelجلسه 8 Course Challenge - Apply your skills in...1 دقیقهCourse Challenge - Apply your skills in practice!جلسه 1 Trend Analysis in Excel8 دقیقهTrend Analysis in Excelجلسه 2 Comparative Analysis in Excel4 دقیقهComparative Analysis in Excelجلسه 3 Value-based analysis in Excel5 دقیقهValue-based analysis in Excelجلسه 4 Correlation analysis in Excel3 دقیقهCorrelation analysis in Excelجلسه 5 Time series analysis in Excel8 دقیقهTime series analysis in Excelجلسه 6 Regression analysis in Excel5 دقیقهRegression analysis in Excelجلسه 1 Introduction to the Case Study2 دقیقهIntroduction to the Case Studyجلسه 2 Preliminary mapping of the data extract...2 دقیقهPreliminary mapping of the data extractionجلسه 3 Working with an SAP data extraction3 دقیقهWorking with an SAP data extractionجلسه 4 Creating an output structure of the FMC...2 دقیقهCreating an output structure of the FMCG modelجلسه 5 Improving the layout and appearance of ...4 دقیقهImproving the layout and appearance of the FMCG reportجلسه 6 Inserting formulas and automating calcu...2 دقیقهInserting formulas and automating calculationsجلسه 7 Creating a Master Pivot Table: The main...2 دقیقهCreating a Master Pivot Table: The main data source for the FMCG reportجلسه 8 GETPIVOTDATA is great! Extracting data ...5 دقیقهGETPIVOTDATA is great! Extracting data from the Master Pivot Tableجلسه 9 A potential error with GETPIVOTDATA you...1 دقیقهA potential error with GETPIVOTDATA you might encounter and its fixجلسه 10 FAQ: My GETPIVOTDATA function doesn't w...1 دقیقهFAQ: My GETPIVOTDATA function doesn't workجلسه 11 Combining Slicers and GETPIVOTDATA: The...3 دقیقهCombining Slicers and GETPIVOTDATA: The key to our successجلسه 12 Getting fancy with Excel slicers - Good...3 دقیقهGetting fancy with Excel slicers - Good-looking Excel slicersجلسه 13 This is how the report can be used in p...3 دقیقهThis is how the report can be used in practice by high - level executivesجلسه 14 Dynamic reporting with GETPIVOTDATA and...Dynamic reporting with GETPIVOTDATA and slicersجلسه 1 Financial modeling basics - Welcome lec...1 دقیقهFinancial modeling basics - Welcome lectureجلسه 2 What is a financial model?2 دقیقهWhat is a financial model?جلسه 3 Why use Financial model?2 دقیقهWhy use Financial model?جلسه 4 Financial modeling - worst practices - ...5 دقیقهFinancial modeling - worst practices - things you should avoidجلسه 5 Financial modeling - best practices4 دقیقهFinancial modeling - best practicesجلسه 6 Financial modeling - The types of model...4 دقیقهFinancial modeling - The types of models that are built in practiceجلسه 7 Financial modeling - QuizFinancial modeling - Quizجلسه 8 Financial modeling: The right level of ...2 دقیقهFinancial modeling: The right level of detail in a modelجلسه 9 Financial modeling: Forecasting guideli...2 دقیقهFinancial modeling: Forecasting guidelinesجلسه 10 Forecasting financials - QuizForecasting financials - Quizجلسه 11 Building a complete model - Important c...2 دقیقهBuilding a complete model - Important considerationsجلسه 12 Modeling the Income statement5 دقیقهModeling the Income statementجلسه 13 Modeling the Balance sheet - Part 12 دقیقهModeling the Balance sheet - Part 1جلسه 14 Modeling the Balance sheet - Part 25 دقیقهModeling the Balance sheet - Part 2جلسه 15 Building a financial model - QuizBuilding a financial model - Quizجلسه 1 Why value a company3 دقیقهWhy value a companyجلسه 2 An investor's perspective3 دقیقهAn investor's perspectiveجلسه 3 The main value drivers when valuing a b...2 دقیقهThe main value drivers when valuing a businessجلسه 4 How to calculate Unlevered Free Cash Fl...5 دقیقهHow to calculate Unlevered Free Cash Flowجلسه 5 How to calculate Weighted Average Cost ...4 دقیقهHow to calculate Weighted Average Cost of Capital (WACC)جلسه 6 How to calculate cost of debt1 دقیقهHow to calculate cost of debtجلسه 7 How to calculate cost of equity5 دقیقهHow to calculate cost of equityجلسه 8 Forecasting a firm's financials4 دقیقهForecasting a firm's financialsجلسه 9 How to obtain Terminal Value3 دقیقهHow to obtain Terminal Valueجلسه 10 Discounting cash flows3 دقیقهDiscounting cash flowsجلسه 11 How to obtain Enterprise and Equity Val...3 دقیقهHow to obtain Enterprise and Equity Valueجلسه 1 Introduction to Mergers & AcquisitionsIntroduction to Mergers & Acquisitionsجلسه 1 Valuation Case study - Welcome lecture1 دقیقهValuation Case study - Welcome lectureجلسه 2 Introduction to the DCF exercise1 دقیقهIntroduction to the DCF exerciseجلسه 3 The stages of a complete DCF Valuation6 دقیقهThe stages of a complete DCF Valuationجلسه 4 Description of the structure of the DCF...2 دقیقهDescription of the structure of the DCF modelجلسه 5 A glimpse at the company we are valuing...1 دقیقهA glimpse at the company we are valuing - Cheesecoجلسه 6 Modeling the top line3 دقیقهModeling the top lineجلسه 7 Introducing scenarios to the model with...2 دقیقهIntroducing scenarios to the model with Chooseجلسه 8 Modeling other items: Other revenues an...3 دقیقهModeling other items: Other revenues and Cogsجلسه 9 Modeling other items: Operating expense...2 دقیقهModeling other items: Operating expenses and D&Aجلسه 10 Modeling other items: Interest expenses...2 دقیقهModeling other items: Interest expenses, Extraordinary items and Taxesجلسه 11 Forecasting Balance sheet items1 دقیقهForecasting Balance sheet itemsجلسه 12 An introduction to the "Days" methodolo...1 دقیقهAn introduction to the "Days" methodologyجلسه 13 Calculation of DSO, DPO and DOI for the...1 دقیقهCalculation of DSO, DPO and DOI for the historical periodجلسه 14 Forecasting DSO, DPO and DOI2 دقیقهForecasting DSO, DPO and DOIجلسه 15 Forecasting Property, Plant & Equipment...2 دقیقهForecasting Property, Plant & Equipment, Other assets and Other liabilitiesجلسه 16 Creating an output P&L sheet2 دقیقهCreating an output P&L sheetجلسه 17 Populating the output P&L sheet2 دقیقهPopulating the output P&L sheetجلسه 18 Populating the output BS sheet1 دقیقهPopulating the output BS sheetجلسه 19 Completing the output BS sheet for the ...3 دقیقهCompleting the output BS sheet for the historical periodجلسه 20 Creating a structure for the calculatio...3 دقیقهCreating a structure for the calculation of Unlevered free cash flowsجلسه 21 Bridging Unlevered free cash flow to Ne...1 دقیقهBridging Unlevered free cash flow to Net cash flowجلسه 22 Calculating Unlevered free cash flow6 دقیقهCalculating Unlevered free cash flowجلسه 23 Calculating Net cash flow3 دقیقهCalculating Net cash flowجلسه 24 Obtaining the rest of the cash flows th...4 دقیقهObtaining the rest of the cash flows through Find and Replaceجلسه 25 Introducing Weighted average cost of ca...1 دقیقهIntroducing Weighted average cost of capital and Perpetuity growthجلسه 26 Discounting Unlevered free cash flows t...2 دقیقهDiscounting Unlevered free cash flows to obtain their Present valueجلسه 27 Calculating Continuing value and Enterp...2 دقیقهCalculating Continuing value and Enterprise value of the businessجلسه 28 Calculating Equity value1 دقیقهCalculating Equity valueجلسه 29 Sensitivity analysis for WACC and perpe...4 دقیقهSensitivity analysis for WACC and perpetuity growthجلسه 30 A possible application of Goal seek1 دقیقهA possible application of Goal seekجلسه 31 Using charts to summarize the results o...4 دقیقهUsing charts to summarize the results of the DCF modelجلسه 1 Organizing external inputs in a 'Driver...3 دقیقهOrganizing external inputs in a 'Drivers' sheetجلسه 2 Forecasting Tesla's expected deliveries13 دقیقهForecasting Tesla's expected deliveriesجلسه 3 Comparing delivery figures with the one...3 دقیقهComparing delivery figures with the ones of industry peersجلسه 4 Estimating an average selling price of ...4 دقیقهEstimating an average selling price of Tesla vehiclesجلسه 5 Calculating automotive revenue4 دقیقهCalculating automotive revenueجلسه 6 Peer comparison: Gross profit %4 دقیقهPeer comparison: Gross profit %جلسه 7 Calculating automotive gross profit2 دقیقهCalculating automotive gross profitجلسه 8 Calculating automotive cost of sales1 دقیقهCalculating automotive cost of salesجلسه 9 Forecasting 'energy' and 'services' rev...2 دقیقهForecasting 'energy' and 'services' revenueجلسه 10 Calculating 'energy' and 'services' gro...2 دقیقهCalculating 'energy' and 'services' gross profit and cost of salesجلسه 11 Forecasting operating expenses4 دقیقهForecasting operating expensesجلسه 12 Building a fixed asset roll forward: PP...4 دقیقهBuilding a fixed asset roll forward: PP&Eجلسه 13 Building a fixed asset roll forward: es...4 دقیقهBuilding a fixed asset roll forward: estimating Capexجلسه 14 Building a fixed asset roll forward: D&...3 دقیقهBuilding a fixed asset roll forward: D&A scheduleجلسه 15 Calculating DSO, DIO, DPO1 دقیقهCalculating DSO, DIO, DPOجلسه 16 Producing a clean P&L output sheet1 دقیقهProducing a clean P&L output sheetجلسه 17 Calculating investments in working capi...1 دقیقهCalculating investments in working capitalجلسه 18 Forecasting Unlevered free cash flow3 دقیقهForecasting Unlevered free cash flowجلسه 19 Forecasting other assets4 دقیقهForecasting other assetsجلسه 20 Forecasting other liabilities2 دقیقهForecasting other liabilitiesجلسه 21 Completing Unlevered free cash flow6 دقیقهCompleting Unlevered free cash flowجلسه 22 Modeling Tesla's financing needs in the...4 دقیقهModeling Tesla's financing needs in the forecast periodجلسه 23 Calculating Net income1 دقیقهCalculating Net incomeجلسه 24 Bridging Unlevered free cash flow to Ne...3 دقیقهBridging Unlevered free cash flow to Net cash flowجلسه 25 Balancing the Balance sheet1 دقیقهBalancing the Balance sheetجلسه 26 Estimating Weighted average cost of cap...5 دقیقهEstimating Weighted average cost of capital (WACC)جلسه 27 Performing discounted cash flow valuati...3 دقیقهPerforming discounted cash flow valuation (DCF)جلسه 28 Calculating enterprise value, equity va...1 دقیقهCalculating enterprise value, equity value, and price per shareجلسه 29 Final comments4 دقیقهFinal commentsجلسه 30 You made it!2 دقیقهYou made it!جلسه 1 What are valuation multiples and why we...4 دقیقهWhat are valuation multiples and why we use them?جلسه 2 What types of valuation multiples are t...3 دقیقهWhat types of valuation multiples are there?جلسه 3 Trading vs transaction valuation multip...3 دقیقهTrading vs transaction valuation multiplesجلسه 4 Main principles of multiples valuation6 دقیقهMain principles of multiples valuationجلسه 5 Comparison of earnings multiples (P/E v...5 دقیقهComparison of earnings multiples (P/E vs EV/EBITDA)جلسه 6 Introduction to the exercise4 دقیقهIntroduction to the exerciseجلسه 7 High-level assessment of peer companies8 دقیقهHigh-level assessment of peer companiesجلسه 8 Assessment of P&L data - comparable com...5 دقیقهAssessment of P&L data - comparable companiesجلسه 9 How to adjust EBIT - theoretical framew...4 دقیقهHow to adjust EBIT - theoretical frameworkجلسه 10 How to adjust EV - theoretical framewor...3 دقیقهHow to adjust EV - theoretical frameworkجلسه 11 How to adjust EBIT - practical example ...7 دقیقهHow to adjust EBIT - practical example - Volkswagenجلسه 12 How to adjust EV - practical example - ...6 دقیقهHow to adjust EV - practical example - Volkswagenجلسه 13 Conclusion of the practical exercise2 دقیقهConclusion of the practical exerciseجلسه 1 Case description1 دقیقهCase descriptionجلسه 2 Introduction to LBO Modeling exercise1 دقیقهIntroduction to LBO Modeling exerciseجلسه 3 Key drivers in the LBO model8 دقیقهKey drivers in the LBO modelجلسه 4 Constructing the Profit and Loss header2 دقیقهConstructing the Profit and Loss headerجلسه 5 Analyzing historical Profit and Loss fi...1 دقیقهAnalyzing historical Profit and Loss figuresجلسه 6 Valuing the Target company3 دقیقهValuing the Target companyجلسه 7 Estimating transaction fees5 دقیقهEstimating transaction feesجلسه 8 Sources and uses of funds4 دقیقهSources and uses of fundsجلسه 9 Shaping the Balance sheet at transactio...5 دقیقهShaping the Balance sheet at transactionجلسه 10 Goodwill calculation1 دقیقهGoodwill calculationجلسه 11 Integrating assumptions into the Driver...5 دقیقهIntegrating assumptions into the Drivers sheetجلسه 12 Building a Fixed asset roll forward sch...4 دقیقهBuilding a Fixed asset roll forward scheduleجلسه 13 Forecasting financials using the Driver...4 دقیقهForecasting financials using the Drivers sheetجلسه 14 Completing the Profit and Loss statemen...5 دقیقهCompleting the Profit and Loss statement (up to EBITDA)جلسه 15 Modeling Working capital4 دقیقهModeling Working capitalجلسه 16 Filling in the Balance sheet at transac...3 دقیقهFilling in the Balance sheet at transaction sheetجلسه 17 Add financials to the Balance sheet3 دقیقهAdd financials to the Balance sheetجلسه 18 Projecting Fixed asset roll forward5 دقیقهProjecting Fixed asset roll forwardجلسه 19 Developing a Debt schedule5 دقیقهDeveloping a Debt scheduleجلسه 20 Creating a Fixed asset amortization sch...4 دقیقهCreating a Fixed asset amortization scheduleجلسه 21 Structuring Cash Flow2 دقیقهStructuring Cash Flowجلسه 22 Designing the Financing sheet4 دقیقهDesigning the Financing sheetجلسه 23 Calculating Cash Flow4 دقیقهCalculating Cash Flowجلسه 24 Building an Equity schedule3 دقیقهBuilding an Equity scheduleجلسه 25 Finalizing the Financing Cash Flow1 دقیقهFinalizing the Financing Cash Flowجلسه 26 Modeling the Revolver facility (first p...8 دقیقهModeling the Revolver facility (first part)جلسه 27 Completing the Profit and Loss statemen...2 دقیقهCompleting the Profit and Loss statementجلسه 28 Modeling the Revolver facility (second ...1 دقیقهModeling the Revolver facility (second part)جلسه 29 Balancing the Balance sheet3 دقیقهBalancing the Balance sheetجلسه 30 Exit valuation and IRR comparison3 دقیقهExit valuation and IRR comparisonجلسه 1 Introduction to Capital budgeting1 دقیقهIntroduction to Capital budgetingجلسه 2 Why we need Capital budgeting?1 دقیقهWhy we need Capital budgeting?جلسه 3 The time value of money2 دقیقهThe time value of moneyجلسه 4 Calculating future and present value5 دقیقهCalculating future and present valueجلسه 5 Calculating cost of equity5 دقیقهCalculating cost of equityجلسه 6 Coming up with project-specific beta2 دقیقهComing up with project-specific betaجلسه 7 Weighted average cost of capital (WACC)1 دقیقهWeighted average cost of capital (WACC)جلسه 8 The type of cash flows we will have in ...2 دقیقهThe type of cash flows we will have in a projectجلسه 9 Estimating the project's cash flows5 دقیقهEstimating the project's cash flowsجلسه 1 Introduction to the Capital budgeting e...2 دقیقهIntroduction to the Capital budgeting exerciseجلسه 2 Organizing an "Inputs" sheet4 دقیقهOrganizing an "Inputs" sheetجلسه 3 Forecasting savings: Building a plant i...3 دقیقهForecasting savings: Building a plant in Vietnam vs. producing cars in Italyجلسه 4 Fixed asset rollforward4 دقیقهFixed asset rollforwardجلسه 5 The impact of working capital2 دقیقهThe impact of working capitalجلسه 6 Modeling debt financing2 دقیقهModeling debt financingجلسه 7 Adding a P&L sheet1 دقیقهAdding a P&L sheetجلسه 8 Calculating project cash flows2 دقیقهCalculating project cash flowsجلسه 9 Estimating the weighted average cost of...2 دقیقهEstimating the weighted average cost of capital (WACC)جلسه 10 Finding cost of equity5 دقیقهFinding cost of equityجلسه 11 Discounting the project's cash flows an...3 دقیقهDiscounting the project's cash flows and residual valueجلسه 12 Performing sensitivity analysis and com...4 دقیقهPerforming sensitivity analysis and completing the exerciseجلسه 13 FAQ: Data does not change in the DCF sh...1 دقیقهFAQ: Data does not change in the DCF sheet, it changes from the Drivers sheetجلسه 14 Build a complete capital budgeting mode...Build a complete capital budgeting model from scratchجلسه 15 Congratulations!!1 دقیقهCongratulations!!جلسه 1 Next steps1 دقیقهNext stepsجلسه 1 How ChatGPT Advanced Data Analysis Will...2 دقیقهHow ChatGPT Advanced Data Analysis Will Boost Your Productivityجلسه 2 The Limitations of ChatGPT Advanced Dat...3 دقیقهThe Limitations of ChatGPT Advanced Data Analysisجلسه 1 Exploratory Data Analysis - Intro3 دقیقهExploratory Data Analysis - Introجلسه 2 Extracting Descriptive Statistics with ...2 دقیقهExtracting Descriptive Statistics with ChatGPTجلسه 3 Identifying Outliers2 دقیقهIdentifying Outliersجلسه 4 Correlation Analysis: Hypothesis Formul...1 دقیقهCorrelation Analysis: Hypothesis Formulation and Feature Ideasجلسه 5 Crafting a Comprehensive EDA Prompt9 دقیقهCrafting a Comprehensive EDA Promptجلسه 1 Identifying and Handling Erroneous Data3 دقیقهIdentifying and Handling Erroneous Dataجلسه 2 Verifying Data for Errors3 دقیقهVerifying Data for Errorsجلسه 3 Eliminating Duplicate Rows1 دقیقهEliminating Duplicate Rowsجلسه 4 Addressing Unit Discrepancies in Data1 دقیقهAddressing Unit Discrepancies in Dataجلسه 5 Dividing Cell Content into Multiple Cel...4 دقیقهDividing Cell Content into Multiple Cellsجلسه 1 Organize Messy Data3 دقیقهOrganize Messy Dataجلسه 2 Data Mapping2 دقیقهData Mappingجلسه 3 Effective Data Classification2 دقیقهEffective Data Classificationجلسه 4 Order Data with ChatGPT2 دقیقهOrder Data with ChatGPTجلسه 1 COUNTIFS, SUMIFS2 دقیقهCOUNTIFS, SUMIFSجلسه 2 Data Lookup2 دقیقهData Lookupجلسه 3 Data Ranking2 دقیقهData Rankingجلسه 4 Fill Until Non-blank Values2 دقیقهFill Until Non-blank Valuesجلسه 5 Translating Logic into Excel Formulas w...2 دقیقهTranslating Logic into Excel Formulas with ChatGPTجلسه 1 Correcting Inverted Names1 دقیقهCorrecting Inverted Namesجلسه 2 Dealing with Trailing and Leading Space...1 دقیقهDealing with Trailing and Leading Spaces in Text Dataجلسه 3 Standardizing Letter Capitalization1 دقیقهStandardizing Letter Capitalizationجلسه 4 Handling Multi-lingual Text Data3 دقیقهHandling Multi-lingual Text Dataجلسه 5 Multiple "Find and Replace" at the Same...2 دقیقهMultiple "Find and Replace" at the Same Time with ChatGPTجلسه 6 Criteria-based Duplicate Removal2 دقیقهCriteria-based Duplicate Removalجلسه 7 Removing Duplicates Across Multiple Col...1 دقیقهRemoving Duplicates Across Multiple Columnsجلسه 1 Obtain Day and Month From Date2 دقیقهObtain Day and Month From Dateجلسه 2 Converting Hours to Decimals1 دقیقهConverting Hours to Decimalsجلسه 3 Obtaining Age in Years, Months, Days1 دقیقهObtaining Age in Years, Months, Daysجلسه 4 Order Dates Chronologically1 دقیقهOrder Dates Chronologicallyجلسه 1 Intro to the Exercise and Preprocessing...4 دقیقهIntro to the Exercise and Preprocessing Ideas from ChatGPTجلسه 2 Preprocessing the 'Free plan users' She...7 دقیقهPreprocessing the 'Free plan users' Sheet (1/2)جلسه 3 Preprocessing the 'Free plan users' She...3 دقیقهPreprocessing the 'Free plan users' Sheet (2/2)جلسه 4 Working on the 'Transactions' Sheet5 دقیقهWorking on the 'Transactions' Sheetجلسه 5 Dealing with the Country Mapping Issue2 دقیقهDealing with the Country Mapping Issueجلسه 1 Overview of Excel3 دقیقهOverview of Excelجلسه 2 Basic manipulations with rows and colum...1 دقیقهBasic manipulations with rows and columnsجلسه 3 The Excel ribbon2 دقیقهThe Excel ribbonجلسه 4 Data entry in Excel3 دقیقهData entry in Excelجلسه 5 Introduction to formatting5 دقیقهIntroduction to formattingجلسه 6 Introduction to Excel formulas3 دقیقهIntroduction to Excel formulasجلسه 7 Introduction to Excel functions3 دقیقهIntroduction to Excel functionsجلسه 8 Cut, copy, & paste2 دقیقهCut, copy, & pasteجلسه 9 Paste special1 دقیقهPaste specialجلسه 1 Initial formatting of an Excel sheet to...2 دقیقهInitial formatting of an Excel sheet to render it professionalجلسه 2 Fast scrolling through Excel sheets1 دقیقهFast scrolling through Excel sheetsجلسه 3 Introduction to fixing of cell referenc...2 دقیقهIntroduction to fixing of cell referencesجلسه 4 Learn how to use the Wrap Text button1 دقیقهLearn how to use the Wrap Text buttonجلسه 5 Create a drop-down list by using Data V...1 دقیقهCreate a drop-down list by using Data Validationجلسه 6 Using Custom-sort in order to sort mult...1 دقیقهUsing Custom-sort in order to sort multiple columns within a tableجلسه 7 Create a great Index page at the beginn...1 دقیقهCreate a great Index page at the beginning of your models - Hyperlinksجلسه 8 Fix the top row of your table with Free...1 دقیقهFix the top row of your table with Freeze Panesجلسه 9 Macros are a great timesaver! Here's wh...3 دقیقهMacros are a great timesaver! Here's why!جلسه 10 Find and select special types of cells ...1 دقیقهFind and select special types of cells with Select Special (F5)جلسه 11 Assign custom formats to specific cells...1 دقیقهAssign custom formats to specific cells within a financial model (e.g Multiples)جلسه 12 Define a named range in Excel1 دقیقهDefine a named range in Excelجلسه 13 Learn how to organize your data with Te...2 دقیقهLearn how to organize your data with Text to Columnsجلسه 14 Learn how to assign dynamic names withi...1 دقیقهLearn how to assign dynamic names within a financial modelجلسه 15 Create easily printable documents in Ex...1 دقیقهCreate easily printable documents in Excel by using Set Print Areaجلسه 16 Using the 'Alt + Enter' combination1 دقیقهUsing the 'Alt + Enter' combinationجلسه 1 Keyboard shortcuts Save LOTS of time in...4 دقیقهKeyboard shortcuts Save LOTS of time in Excel 2010جلسه 1 Key Excel functions: SUM, SUMIF and SUM...4 دقیقهKey Excel functions: SUM, SUMIF and SUMIFSجلسه 2 Key Excel functions: COUNT, COUNTA, COU...4 دقیقهKey Excel functions: COUNT, COUNTA, COUNTIF, COUNTIFSجلسه 3 Key Excel functions: AVERAGE and AVERAG...1 دقیقهKey Excel functions: AVERAGE and AVERAGEIFجلسه 4 Elaborate text efficiently: LEFT, RIGHT...4 دقیقهElaborate text efficiently: LEFT, RIGHT, MID, UPPER, LOWER, PROPER, CONCATENATEجلسه 5 Find the minimum or maximum value in a ...1 دقیقهFind the minimum or maximum value in a range of cells in Excelجلسه 6 Include ROUND in your financial models1 دقیقهInclude ROUND in your financial modelsجلسه 7 Key Excel functions: VLOOKUP and HLOOKU...7 دقیقهKey Excel functions: VLOOKUP and HLOOKUPجلسه 8 INDEX, MATCH and their combination - th...7 دقیقهINDEX, MATCH and their combination - the perfect substitute for VLOOKUPجلسه 9 Using Excel's IFERROR function to trap ...1 دقیقهUsing Excel's IFERROR function to trap spreadsheet errorsجلسه 10 Learn how to render your models flexibl...2 دقیقهLearn how to render your models flexible with CHOOSEجلسه 11 Use Goal Seek to find the result that y...2 دقیقهUse Goal Seek to find the result that you are looking forجلسه 12 Include sensitivity analysis in your mo...2 دقیقهInclude sensitivity analysis in your models through Data Tablesجلسه 13 Excel's dynamic and interactive tables:...2 دقیقهExcel's dynamic and interactive tables: Pivot tablesجلسه 1 Why value a company1 دقیقهWhy value a companyجلسه 2 An investor's perspective when valuing ...3 دقیقهAn investor's perspective when valuing a companyجلسه 3 Which are the drivers of company value?1 دقیقهWhich are the drivers of company value?جلسه 4 How to calculate UFCF4 دقیقهHow to calculate UFCFجلسه 5 What is WACC3 دقیقهWhat is WACCجلسه 6 How to find cost of debt1 دقیقهHow to find cost of debtجلسه 7 How to find cost of equity4 دقیقهHow to find cost of equityجلسه 8 Forecasting financials2 دقیقهForecasting financialsجلسه 9 Calculating terminal value2 دقیقهCalculating terminal valueجلسه 10 Discounting cash flows1 دقیقهDiscounting cash flowsجلسه 11 Calculating enterprise and equity value1 دقیقهCalculating enterprise and equity value
-
استاد
مدیر سیستم
تعداد هنرجویان0تعداد درس9همه ی دوره های استادنتایج بیشتر -
5 از 5از مجموع 0 نظرنتایج بیشتر
افزودن به سبد خرید
قیمت :
در حال آماده سازی
امتیاز دوره
100% (1)
دیدگاه
در مورد آموزش مدل سازی مالی در اکسل: ارزش گذاری مالی با Excel