Overview

Building business plans is crucial to the success of entrepreneurs and executives who are raising funding, launching, or growing businesses. Business plans are also necessary to monitor whether business outcomes are tracking expectations. You will learn how to integrate forecasts of key business drivers into financially viable plans using Excel. This course focuses on building business plans, not financial statement modeling for valuation or statistical forecasting.

This course will be offered only for undergrads; it will not be cross listed.

Takeaways

You will learn to do the following:

Prerequisites

Materials

I will not require a textbook. I will distribute handouts in class and have online assignments.

Exams and Grading

There are no in-class quizzes, midterms, or final exams.

System Requirements

Help and Office

Assignments

Topics

Session 1: An overview of the business planning process

Inputs

Outputs

Session 2: Revenue metrics

We will discuss revenue metrics across a wide range of industries. Some of the examples are provided below.

Software service and product based

Advertising based

Consulting based

Product or location based

Session 3: Revenue growth

Growth metrics

Product life cycles

Session 4: Integrating forecasts of revenue drivers

Market share and pricing

Incorpating revenue drivers into the business plan

Session 5: Relationship between revenues and operating expenses

Cost behavior

Long-run versus short-run

Session 6: Operating expense metrics and drivers

Operating expense ratios and margins

Expense drivers

Forecasting expenses

Session 7: Prepayments and payables

How prepayments require financing: Operating assets

How payables mitigate the need for financing: Operating liabilities

Session 9: Receivables and deferred revenues

How receivables increase the need for financing: Operating assets

How deferred revenues provide financing: Operating liabilities

Session 10: Meeting financing needs partially with debt

Ensuring liquidity: Financial assets

Understanding corporate loans using personal finance examples

Assessing borrowing capacity: Financial liabilities

Session 11: Meeting residual needs with equity

Raising equity

Sweat equity and incentive structures

Backup sources

Session 12: Sensitivity analysis

Building scenarios