excel for corporate finance

excel for corporate finance

Chapters:

00:00:14 Introduction to Course
00:06:15 Overview of Corporate Finance, WACC and Capital Structure, Cashflows
00:17:22 Capital budgeting in Excel
00:21:40 Capital Budgeting Scenarios
00:28:31 NPV
00:31:27 IRR
00:34:13 PBP and MIRR
00:37:19 Unexpected Events and Capital Budgeting
00:40:32 NPV and Scenario Analysis
00:45:28 Capital Structure in Excel
00:47:26 Using Excel and WACC
00:48:30 Capital Structure Options in Excel
00:52:13 Changes in Capital Structure
00:54:16 Estimating WACC in Excel
00:57:15 Sensitivity of WACC to Capital Structure
00:59:41 Optimal WACC
01:02:11 Operational Budgeting in Excel
01:03:50 Building a Budget in Excel
01:07:12 CAGR and long-term assumptions


40 Under 40 Analytics
Indian Achievers Award for Young Entrepreneur
Consulted Government of India, Fortune 500, Unicorns, Big 3 and Big 4

Faculty at IIM ABCLK + IITs
Author of 20 books

Website:
https://www.havishmconsulting.com/

Courses:
https://www.havishmconsulting.com/shop

Medium:
https://havish-madhvapaty.medium.com/

GitHub:
https://github.com/havishmad

Chapters:00:00:14 Introduction to Course00:06:15 Overview of Corporate Finance, WACC and Capital Structure, Cashflows00:17:22 Capital budgeting in Excel00:21:40 Capital Budgeting Scenarios00:28:31 NPV00:31:27 IRR00:34:13 PBP and MIRR00:37:19 Unexpected Events and Capital Budgeting00:40:32 NPV and Scenario Analysis00:45:28 Capital Structure in Excel00:47:26 Using Excel and WACC00:48:30 Capital Structure Options in Excel00:52:13 Changes in Capital Structure00:54:16 Estimating WACC in Excel00:57:15 Sensitivity of WACC to Capital Structure00:59:41 Optimal WACC01:02:11 Operational Budgeting in Excel01:03:50 Building a Budget in Excel01:07:12 CAGR and long-term assumptions40 Under 40 AnalyticsIndian Achievers Award for Young EntrepreneurConsulted Government of India, Fortune 500, Unicorns, Big 3 and Big 4Faculty at IIM ABCLK + IITsAuthor of 20 booksWebsite:https://www.havishmconsulting.com/Courses:https://www.havishmconsulting.com/shopMedium:https://havish-madhvapaty.medium.com/GitHub:https://github.com/havishmad

program to carry personal finance control excel templatepersonal finance organization with free excel sheet and financial guideextracting dates from wrong date format part 2 course excel for finance accountingdepreciation with straight line method in excel sln course excel for finance accounting fapython for excel use xlwings for data science and finance learn microsoftfinance with excel basic skills14 completing the course introduction to excel for finance and accountingdepreciation with declining balance method in excel db course excel for finance accountingfinancial modeling office hour 76 automating loan amortization in excel michael oladejiexcel for corporate financesplit historical return data yahoo finance excel macfinance basics 6 present value examples in excel how much something is worth todayprinciples of finance excel npv and pifmva 2022 lec 9 excel crash course spreadsheet formulas for finance 4finance with excel splitting your medical bill between you and insurancea synchronous live stock prices in excel alpha vantage vs yahoo finance older versionfinance in excel 12calculate rate nper using excel excel finance functionsfinance with excel exchange rate calculatorexcel finance trick 5 pmt fv function delayed paymentsvlookup range name i m ms excel expert tutorial day 19 finance guy nishantfinance in excel 19welcome to exactpro pro excel tips for accounting and financeconfigure excel templates in dynamics 365 finance operations4 install the magnimetrics add in introduction to excel for finance and accountingexcel for accounting and finance 2014 big e z bookkeeping systemfinance in excel 9 view live news and headlines for publicly traded companies and stocks in excelexcel video tutorial for finance calculation recurring versus fixed depositfinance with excel retirement spending calculatorcrusherrors com new ui for ai automated finance excel data prepbusiness finance management excel spreadsheet templateimport stock data from nasdaq using excel without yahoo finance just use stock ticker and excelexcel pour la finance suivre ses actions grâce à un tableau de bordexcel crash course functions formula part 6how to get real time cryptocurrency prices from yahoo finance to excelinfor ln finance ln financial statements and trial balance export to excelexcel pour la finance et la comptabilité les intérêts composésprinciples of finance excel simple payback periodmanaging personal budget and finance microsoft excelbossa excel business finance managementlutg excel video workshop episode three the finance sheetarya the heroies finance analyst modeling in excel building a complete 3 statement modelall your home loan calculations in excel learn financeexcel finance class 09 balance sheet working capital liquidity debt equity ket vaexcel finance calculate the cost of that interest free loanfinance with excel estimating real stock returnsfilter sort i m ms excel expert tutorial day 6 finance guy nishantexcel crash course for finance professionals basic about excel courselearn finance courses crypto investing economics excel udemy free course udemycourse eduseshow to create a waterfall chart in excelfilter function ex 3 office 365 sharad excel finance codingfinancial function in excel pmt pv fv nper rate ipmt ppmt how to use in hindiexcel yahoo finance stock data importfoundations of finance chapter 10 excel examplesfinance with excel for mac two axis graphexcel finance function pmtint abs functions i m ms excel expert tutorial day 23 finance guy nishantexcel finance trick 10 interest rate for pay day loansdeep finance use of excel linest function cogs revenue regressionfinance function in ms excel ms excel tips tricks

Chapters:

00:00:14 Introduction to Course
00:06:15 Overview of Corporate Finance, WACC and Capital Structure, Cashflows
00:17:22 Capital budgeting in Excel
00:21:40 Capital Budgeting Scenarios
00:28:31 NPV
00:31:27 IRR
00:34:13 PBP and MIRR
00:37:19 Unexpected Events and Capital Budgeting
00:40:32 NPV and Scenario Analysis
00:45:28 Capital Structure in Excel
00:47:26 Using Excel and WACC
00:48:30 Capital Structure Options in Excel
00:52:13 Changes in Capital Structure
00:54:16 Estimating WACC in Excel
00:57:15 Sensitivity of WACC to Capital Structure
00:59:41 Optimal WACC
01:02:11 Operational Budgeting in Excel
01:03:50 Building a Budget in Excel
01:07:12 CAGR and long-term assumptions


40 Under 40 Analytics
Indian Achievers Award for Young Entrepreneur
Consulted Government of India, Fortune 500, Unicorns, Big 3 and Big 4

Faculty at IIM ABCLK + IITs
Author of 20 books

Website:
https://www.havishmconsulting.com/

Courses:
https://www.havishmconsulting.com/shop

Medium:
https://havish-madhvapaty.medium.com/

GitHub:
https://github.com/havishmad