4.75 out of 5
4.75
11 reviews on Udemy

Corporate and business finance optimization (Excel Solver)

Master even complex optimization problems to maximize business profit and corporate return
Instructor:
Rolf Moes
58 students enrolled
English [Auto]
Understand optimization problems and how they relate to financial planning and decision making
Use Excel Solver to define optimization and solve optimization problems
Learn how to maximize profit or minimize costs under constrained conditions
Solve hands-on problems in working capital management, capital budgeting, inventory management and product manufacturing mix optimization
Frameworks and financial model templates for business problem optimization

This course brings together the worlds of computational math and finance to develop next-level proficiency in financial business planning and decision making optimization – all within Excel.

Mathematical optimization (rather than process or engineering optimization) allows us to maximize profit under nearly any type of constraint such as budget, capital availability, production capacity, materials availability, and scheduling times.

In this course, you will not only learn how optimization is applied in finance and how to use and master optimization solvers, but also how to lay out a well-structured financial model in any scenario.

In each of the hands-on practice sessions, we spend time covering all the financial concepts used as well as laying out the right quantitative model fit. These practice examples cover capital allocation across investments, working cash management, manufacturing input scheduling, and inventory order management.

The course comes with 7 great downloadable resources, including 6 Excel financial models as well as a helpful Solver debugging PDF. You’ll use these resources while working through the examples in the course but can also re-use and modify them for your own optimization needs.

Once you have completed this course, you will be able to manage and model any of these domains with skill and insight, and maximize profit or minimize cost accordingly.

Introduction to business finance optimization

1
Course introduction

An introduction to the course, what you'll learn and walk away with at the end of it

2
What are optimization problems?

A simple overview of the trade-offs in the allocation of scare resources as the basis of optimization

3
Types of optimization problems

Dig into the fundamentals of general optimization problems through the application of a general linear programming example, and setting the stage for nonlinear programming

4
Optimization in corporate & business finance

The application of linear and nonlinear optimization to business finance problems, including the three paradigms we cover in the course: long term capital budgeting, short-term working capital management and operations optimization.

5
Optimization and finance

Getting familiar running optimizations in Excel with Solver

1
Optimization apps and setting up Solver in MS Excel

A brief on what an optimization engine is, and then a step-by-step guide to set up Solver in Excel (prepackaged free tool we use throughout the course)

2
A structured template for modeling financial optimization problems

How to lay out financial models in Excel using options, characteristics, decision variables, constraints and the objective function.

3
Solving your first optimization problem in Solver

Hands-on, basic word problem (Excel workbook included) in linear programming to determine the optimal number of storage racks used in a warehouse, based on storage constraints and budget.

4
Ready to optimize!

Now that you've covered all you need to get cracking on financial decision problems, let's do a quick Q&A recap of optimization and Solver!

Hands-on finance optimization

1
A word on Solver methods and debugging issues

Understanding Solver's use of Simplex LP, GRG Nonlinear, and Evolutionary optimization methods, as well as common errors encountered and tips to get by them. (Includes a Debug Checklist PDF)

2
Practice #1: Capital Budgeting: Investment Debt/Equity Allocation

Hands-on optimization of a debt/equity allocation across multiple investments, each with their own characteristic cashflow, and hence, return. Uses the included Practice 1 Excel workbook.

3
Practice #2: Product Manufacturing Mix

Hands-on optimization of resources in a manufacturing facility to maximize profit. Uses the included Practice 2 Excel workbook.

4
Practice #3: Inventory Order Management

Hands-on optimization of inventory ordering in order to minimize ordering and holding costs. Uses the Practice 3 Excel workbook included.

5
Practice #4: Working Capital Management - Investment

Hands-on optimization of cash surplus working capital situation, in order to maximize short-term return on investment. Uses the included Practice 4 Excel workbook.

6
Practice #5: Working Capital Management - Financing

Hands-on optimization of cash deficit working capital situation, in order to minimize short-term debt interest and fees. Uses the included Practice 5 Excel workbook.

Exploring further

1
Summary of financial planning optimization

Brings together the content covered of what optimization is, how it applies to corporate and business finance, and the paradigms to keep in mind when solving your own business optimization problems.

2
Resources and further avenues of exploration

Recap of resources available to you and a brief exploration of the many business fields you can apply the skills learnt in the course, from airline ticket pricing through supply-chain scheduling, investment diversification and others.

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.8
4.8 out of 5
11 Ratings

Detailed Rating

Stars 5
7
Stars 4
4
Stars 3
0
Stars 2
0
Stars 1
0
30-Day Money-Back Guarantee

Includes

2 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion
Corporate and business finance optimization (Excel Solver)
Price:
$78.98 $64

Community

For Professionals

For Businesses

We support Sales, Marketing, Account Management and CX professionals. Learn new skills. Share your expertise. Connect with experts. Get inspired.

Community

Partnership Opportunities

Layer 1
samcx.com
Logo
Register New Account
Compare items
  • Total (0)
Compare
0