Corporate and business finance optimization (Excel Solver)

Corporate and business finance optimization (Excel Solver), available at $59.99, has an average rating of 4.3, with 15 lectures, 2 quizzes, based on 87 reviews, and has 561 subscribers.

You will learn about 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 is ideal for individuals who are Financial managers and accountants or Entrepreneurs getting to grips with financial planning or Operational leadership or Quantitative analysts or Business school students It is particularly useful for Financial managers and accountants or Entrepreneurs getting to grips with financial planning or Operational leadership or Quantitative analysts or Business school students.

Enroll now: Corporate and business finance optimization (Excel Solver)

Summary

Title: Corporate and business finance optimization (Excel Solver)

Price: $59.99

Average Rating: 4.3

Number of Lectures: 15

Number of Quizzes: 2

Number of Published Lectures: 15

Number of Published Quizzes: 2

Number of Curriculum Items: 17

Number of Published Curriculum Objects: 17

Original Price: $29.99

Quality Status: approved

Status: Live

What You Will Learn

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

Who Should Attend

Financial managers and accountants
Entrepreneurs getting to grips with financial planning
Operational leadership
Quantitative analysts
Business school students

Target Audiences

Financial managers and accountants
Entrepreneurs getting to grips with financial planning
Operational leadership
Quantitative analysts
Business school students

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.

Course Curriculum

Chapter 1: Introduction to business finance optimization

Lecture 1: Course introduction

Lecture 2: What are optimization problems?

Lecture 3: Types of optimization problems

Lecture 4: Optimization in corporate & business finance

Chapter 2: Getting familiar running optimizations in Excel with Solver

Lecture 1: Optimization apps and setting up Solver in MS Excel

Lecture 2: A structured template for modeling financial optimization problems

Lecture 3: Solving your first optimization problem in Solver

Chapter 3: Hands-on finance optimization

Lecture 1: A word on Solver methods and debugging issues

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

Lecture 3: Practice #2: Product Manufacturing Mix

Lecture 4: Practice #3: Inventory Order Management

Lecture 5: Practice #4: Working Capital Management – Investment

Lecture 6: Practice #5: Working Capital Management – Financing

Chapter 4: Exploring further

Lecture 1: Summary of financial planning optimization

Lecture 2: Resources and further avenues of exploration

Instructors

Rolf Moes
Business strategy and finance

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 5 votes
4 stars: 32 votes
5 stars: 49 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

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!

Menu