Principles of Finance with Excel—Module

Finance

ISBN:

978-1-952023-49-1

Principles of Finance with Excel—Module

Jim Brau, PhD, CFA, CFP Andrew Holmes, PhD, CFA Ben Blau, PhD Nick Ball, PhD Gove Allen, PhD

Excel is the everyday tool of finance careers, and this module teaches students to use it for real financial analysis. Each lesson pairs instruction and examples with a hands-on assignment that is scored automatically, with immediate feedback. Students apply Excel to financial statements, ratio analysis, forecasting, and the time value of money, then to bond and stock valuation, risk and return, cost of capital, leverage, capital budgeting, and firm valuation. They finish with practical spreadsheet skills they can use in any finance-related career.

Preview a Chapter

Request Access

Free instructor demo access to full resource

Plug-and-play solution for instant adoption

Lifetime access for students

Introduction: Introduction and Device Setup Topic 1: An Introduction to Finance in Excel Topic 2: Accounting and Financial Statement Review Topic 3: Ratio Analysis: Financial Statement Analysis and Free Cash Flows Topic 4: Financial Forecasting: Pro Forma Statements and Cash Budgets Topic 5: The Time Value of Money: Compounding and Discounting Topic 6: Bond Valuation: Fixed-Income Analysis Topic 7: Stock Valuation: Understanding Equity Topic 8: Risk and Return: The Key Trade-Off Topic 9: The Cost of Capital: WACC Attack Topic 10: Leverage: The Two-Edged Sword Topic 11: Capital Budgeting Evaluation Methods: Payback, NPV, and IRR Topic 12: Capital Budgeting: Cash Flows and Other Topics Topic 13: Firm Valuation: Valuing the Whole Enchilada Appendix: Microsoft Excel

Request Free Access

Interested in using this resource in your course? Request free instructor access. Just tell us who you are and where you teach, and we’ll take care of the rest!

Thank you! Your submission has been received!

Oops! Something went wrong while submitting the form.

Made by proffessors, for professors

Auto-Graded Assessments

Customize assessments or create new ones. Assessments are completed online within the text and instantly graded with detailed feedback.

LMS Integration

Access courseware with single sign-on convenience using our LMS integration tools. Assignments, exams, and grades are automatically synced.

Instructor Materials

Take advantage of study plans, PowerPoint presentations, and test banks so that courses require minimal start-up time.

Micro-Credentials & Certificates

Allow your students to earn achievements in the classroom. Keep them engaged using ready-made badges and certificates, or create your own.

AI Virtual Assistant

Our AI Virtual Assistant transforms how students engage with content, offering features like multilingual translation, question answering, progress assessment, and much more.