Udemy, Coursera, 2U/edX Face Lawsuits Over Meta Pixel Use

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Financial Analysis: Analyzing the Bottom Line with Excel

via LinkedIn Learning

Go to class Write review

Overview

Learn how to analyze the bottom line (or profitability) of your company, by analyzing your gross margin and operating expenses with Excel.

Syllabus

Introduction
  • Welcome
  • What you need to know
  • Using the exercise files
1. Analyzing Gross Margin
  • The basics of gross margin analysis
  • Finding the data points
  • Preparing the data
  • Categorizing expenditures
  • Allocating costs by category
  • Calculating standard costs
  • Using standard costs to calculate gross margin
  • Adding standard costs to your revenue database
  • Calculating gross margin
  • Performing a price/mix analysis
  • Analyzing overall gross margin performance
  • The gross margin percentage levers
2. Analyzing Operating Expenses
  • The basics of operating expenses analysis
  • Finding the data points
  • Analyzing overall operating expenses performance
  • Analyzing sales and marketing
  • Analyzing nonsales staff expenditures
  • Analyzing productivity
  • Analyzing general expenses
Conclusion
  • Next steps

Taught by

Rudolph Rosenberg

Reviews

Start your review of Financial Analysis: Analyzing the Bottom Line with Excel

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.