Chapter 30: Financial Planning & Forecasting
Welcome to Last Minute Lecture.
This free chapter overview is designed to help students review and understand key concepts.
These summaries supplement not replaced the original textbook and may not be redistributed or resold.
For complete coverage, always consult the official text.
Welcome back to the Deep Dive.
Our mission here is, you know, pretty simple.
We take these complex strategic finance sources, we tear them apart, and we try to put the most critical insights right into your hands.
And today we're really getting into the the core function of corporate strategy,
financial planning.
It really is.
It's this framework that connects the, I guess, existential worries of today.
Right.
Like, can we actually pay our bills?
Exactly.
With the massive, huge ambitions for tomorrow, you know, can we become a global market leader?
Yeah, that's the fundamental tension, isn't it?
It is.
When you look at corporate finance, there's this this central and I think persistent tension.
On one side, you have the immediate sort of stomach -dropping fear of the daily cash crunch.
I mean, you have managers literally losing sleep over whether they can cover up payroll next week or pay that big supplier invoice that's due in 30 days.
And then on the complete other side of the spectrum, you've got the grand multi -year strategic goal.
Maybe it's launching a new, you know, multi -billion dollar product line.
Or maybe building a state -of -the -art manufacturing plant that won't even be operational for three years.
Exactly.
And financial planning is the discipline that's designed to make sure those two forces, the short -term operational need and the long -term strategic vision, don't, you know, contradict each other.
But actually support each other, cohesively.
Right.
They have to work together.
So we tend to split this planning process into two major but very interconnected buckets.
The first is short -term planning.
The sources we're looking at call this cash budgeting.
And cash budgeting is.
It's forensic.
It's really operational.
It's focused on the next few quarters, just ensuring the firm maintains enough liquidity and, well, avoids running out of cash.
It's all about immediate working capital management.
Then the second bucket is that long -term planning, which is much more focused on strategic coherence.
It's about developing a strategy that supports that multi -year growth ambition while, you know, maintaining a healthy capital structure.
So why the distinction?
Why separate them?
Well, I think you have to, right?
It seems to come down to how easily you can undo a decision.
That's it.
Exactly.
It comes down to decision reversibility.
Think about the scale of the commitment.
You take out a 6D bank loan.
Super easy to reverse.
You just pay it off.
You're done.
The decision is, you know, very low cost to undo.
Right.
But now let's say you decide to issue a, I don't know, a $500 million 20 -year bond to fund that new factory we talked about.
That is a completely different animal.
That decision is extremely costly and really difficult to reverse quickly.
You can't just walk away from a bond issue.
Or sell a half -built plant without just massive losses and, frankly, shareholder anger.
Of course.
So sound financial planning forces managers to recognize that fundamental difference.
They have to ensure that the irreversible high -cost long -term decisions, like those major investments or issuing long -dated debt, are fully compatible with the day -to -day that's captured by their short -term cash flow needs.
So our mission today is to go deep into the mechanics of this.
We're going to walk step by step through the process of both budgeting the cash and forecasting that strategic future.
And we'll be using our case study company, the Dynamic Mantras Company, as our guide.
It's a fantastic illustration of how all these financial gears really mesh together.
Okay.
Let's unpack this.
Okay.
So to begin trotting a financing course, we first have to, I guess, define the scope of the problem.
We start with a concept the source material calls the cumulative capital requirement.
That phrase sounds a bit dense, I know.
Yeah.
But the concept is actually very straightforward.
Right.
It's just the total cumulative money that's invested in all the assets needed to run the business at any given moment in time.
So that includes the big stuff like the plant, the machinery, the trucks.
But it also includes the daily operational components like the inventory sitting on the factory floor and crucially the accounts receivable.
That's the money your customers still owe you.
And if you were to plot this requirement over time, you'd see it's not a straight smooth line at all.
It's actually a wavy oscillating line.
And that's the key visualization.
It gives you two simultaneous truths about the business right away.
Okay.
What's the
And that reflects the overall growth of the firm over many years.
That's your strategic ambition made visible.
And the second truth is in the waves themselves.
Exactly.
It features sharp seasonal variations, the peaks and the troughs that happen within each year.
Dynamic mattress, for example, might see its need for a capital peak, say in the third quarter when they're building up inventory for the holiday sales rush.
And then it would drop sharply once those sales convert
into actual cash in the bank.
Precisely.
So the central decision management has to make is this.
How much of that wavy line, that total cumulative requirement do we choose to finance with long -term capital?
That decision is everything.
Whether you use long -term debt or equity, that choice is what ultimately determines if the firm consistently operates as a net short -term borrower or as a net short -term lender.
And the sources lay out three basic financing strategies here, which really illustrate the risk and return trade -off that's inherent in this choice.
Yeah, let's walk through them.
Okay.
Let's start with what they call Strategy C.
This one seems to be the most aggressive approach when it comes to long -term financing.
It is.
In Strategy C, the level of long -term funding is always intentionally set below the cumulative capital requirement line.
And that's a deliberate choice, right?
They're trying to minimize the cost of that long -term capital, which often carries fees and complexity.
Right.
But it means the firm always has a permanent need for short -term borrowing, just to cover the difference between its assets and its long -term funding base.
So the big implication of Strategy C is what?
High refinancing risk.
Huge refinancing risk.
You are constantly juggling short -term loans, rolling them over, and you're always facing the risk that if credit markets suddenly freeze up.
You might find yourself unable to secure that necessary borrowing and you're in real trouble.
Exactly.
Now, Strategy A is the complete mirror image.
It's the most conservative strategy you can imagine.
Okay.
So here, the firm maintains long -term financing that is always set above even the peak cumulative capital requirement.
Right.
And this results in a permanent cash surplus.
So when the company is in a seasonal trough, it has all this excess cash that it then invests in short -term marketable securities.
So it's extremely safe.
You're not worried about liquidity or short -term credit at all, but I'm guessing it's potentially inefficient.
Very inefficient because that surplus cash may not be earning returns above the firm's cost of capital.
You might be missing out on better investments.
And that brings us to Strategy B, which the sources note is the most common and I suppose the most balanced approach.
With Strategy B, your long -term financing covers that permanent growing portion of the capital requirement, including the baseline level of your working capital.
So under this strategy, the firm has to engage in seasonal short -term borrowing during its peak times, the crests of that wave.
And seasonal short -term lending or investing surplus cash during the troughs.
It's an attempt to balance the reduced risk of Strategy A with the potentially higher returns of Strategy C.
It gives the firm flexibility.
These strategies really highlight a practical observation that seems to underpin a lot of corporate behavior,
the matching principle.
Yes.
Managers don't strictly adhere to some theoretical model, but they generally try to match the maturity of their assets with the maturity of their liabilities.
So long -lived assets like the factory and all the heavy machinery, you'd finance those with long -term debt and equity.
It just makes intuitive sense, doesn't it?
You don't want to use a one -year loan to buy an asset that's going to last for 20 years.
You want the financing to be paid off over the period the asset is actually generating cash flow for you.
And they also usually finance the permanent core of their networking capital.
So the minimum level of inventory and receivables they must hold, even in a trough from long -term sources as well.
It avoids the risk of financing permanent asset needs with volatile short -term loans.
Okay.
Let's focus on the asset side of that equation for a minute.
Liquidity and cash holdings.
We know that current assets are supposed to be easily convertible cash within a year, but there's a spectrum here, isn't there?
Oh, absolutely.
Think of it as a liquidity hierarchy.
At the very bottom you have inventory.
Because it has the longest cash conversion cycle.
You have to finish manufacturing it, then sell it to a customer, and then you still have to wait for that customer to pay you.
Exactly.
So next up the ladder is accounts receivable.
This is more liquid because the sale has already happened.
You just need the customer to fulfill their payment obligation.
And at the very top, the most liquid would be short -term securities.
Right.
If the firm needs cash immediately, they can usually sell government bonds or high -quality commercial paper very, very quickly.
Often within a day and the cash is realized.
Now here's a piece of data that really surprised me in the sources.
It says U .S.
non -financial firms dramatically increase their median cash holdings, particularly in the period leading up to the 2007 -2009 financial crisis.
That's a huge point.
It suggests that post -2000 firms fundamentally reassess the value of liquidity.
And for good reason, I imagine.
Oh, for very good reason.
The advantages of holding surplus cash are compelling, especially for smaller, high -risk, high -growth firms.
First, there's the simple advantage, reduced operational anxiety.
Management isn't stressed about making daily payments.
It's a buffer.
It's basically the corporate version of an emergency fund, right?
Protecting against a rainy day.
Absolutely.
And this buffer is critical in industries like, say, biotech R &D.
They might need five years of continuous funding just to bring one drug to market.
If they run out of cash halfway through and suddenly external funding is expensive or just unavailable.
The entire project fails.
The whole thing goes up in smoke.
So holding substantial cash reserves is a necessary cost of doing high -risk, long -term business for them.
But like any strategy, there has to be a drawback.
What's the penalty for holding too much cash?
The penalty is opportunity cost and potentially managerial laziness.
Holding large reserves of marketable securities, which typically yield very low returns,
is at best a zero NPV investment for a taxpaying firm.
Because they have to pay corporate taxes on the interest they earn.
Right.
And if they could have deployed that cash into a positive NPV project instead, they are effectively failing their shareholders.
And then there's the more dangerous psychological impact.
You mentioned management might run a less tight ship.
Yes.
Cash can seep away.
It can mask operational inefficiencies.
The General Motors example the source provides is a perfect, if painful, illustration of how the market reacts to this.
This one is just incredible.
At the end of 2007, GM held $27 billion in cash.
But the market valued the entire company's stock at less than $14 billion.
It's a colossal discrepancy.
Just think about that.
The value of their stock was less than the cash they were literally sitting on.
So wait,
the market was actively saying they preferred GM not to have that money.
How does management even fight that perception?
It's a total crisis of trust.
Shareholders feared that management wasn't going to reinvest that $27 billion profitably.
They suspected it would just be used to support ongoing operational losses and service GM's massive existing debts.
So basically, they thought the cash would be used to subsidize a failing business model.
Exactly.
In that scenario, that dollar of cash inside the firm was discounted heavily by the market because it was viewed as trapped or, you know, destined to be myth allocated.
So the expert insight here is crystal clear.
The value a shareholder places on a dollar of cash is entirely context dependent.
If you're a high growth tech firm with fantastic investment opportunities, that dollar of cash is highly valued.
Because it enables growth.
But if you're facing financial distress, or if management is perceived as wasteful or strategically poor,
that dollar of cash is worth significantly less than a dollar to the shareholder.
They would prefer the cash to be distributed immediately, assuming get covenants allow for it.
Financial planning has to account for this shareholder perception.
Okay, now that we've established the strategic context, we need the tools to manage the short term reality.
And we have to start by looking backward to understand the past.
That involves tracing changes using the cash flow statement.
Right.
The fundamental purpose of the cash flow statement is really just to tell the story of what caused the change in your cash balance between two specific balance sheet dates.
For dynamic mattress, we're looking at that $10 .4 million increase in cash between 2020 and 2021.
They went from $20 million to $30 .4 million.
And the genius of the cash flow statement is its structure.
It forces you to classify all cash flows into those three activity buckets, operating, investing, and financing.
This makes managers diagnose where the money is actually coming from or where it's going.
Let's walk through the trickiest part first.
Operating activities for dynamic mattress in 2021.
We start with the net income figure of $73 .3 million.
That's the accounting profit, but we need to convert it to actual cash flow.
The first and most famous adjustment is adding back depreciation, which is $23 .5 million.
We have to restore it.
Why?
Because depreciation is an accounting allocation.
It's for the use of fixed assets over time.
It's booked as an expense to reduce your reported income, but no cash actually leaves the firm for that expense in 2021.
It's just an internal entry.
Exactly.
So to find the true operational cash flow, you have to add that $23 .5 million back in.
Okay.
Next, we hit the really crucial intuition of working capital adjustments.
The income statement records revenue when the sale is made, not necessarily when the cash hits the bank account.
Take accounts receivable or AR.
Dynamics AR increased by $26 million in 2021.
This means they made sales, they recorded the revenue, and they earned that $73 .3 million in profit, but they haven't been paid for all of it yet.
So an increase in AR is a use of cash.
That's the key takeaway.
Dynamic effectively lent an additional $26 million to its customers by extending them credit.
And that's a negative adjustment to your operational cash flow.
Now, look at inventory.
Dynamics inventory decreased by $11 .4 million.
So that means they sold $11 .4 million more product than they purchased to restock their inventory shelves.
Right.
And that decrease releases cash back into the company, making it a positive source of cash.
And finally, accounts payable or AP.
This is what Dynamic owes its suppliers.
And their AP increased by $25 million.
This is critical.
An increase in AP means Dynamic delayed payment to its suppliers.
They receive the goods, they sold them, they bank the revenue, but they haven't paid the bill yet.
So they've effectively borrowed $25 million from their suppliers.
Yes.
Making this a positive source of cash flow from operations.
Okay.
So after making all those adjustments, starting with net income, adding back depreciation, adjusting for the changes in AR, inventory, and AP Dynamic generated a pretty robust $107 .2 million from its operating activities in 2021.
That looks like a strong operational performance.
It is, but the cash balance story isn't over yet.
We have to look at investing and financing activities.
Investing was simple, a negative $30 .0 million, which reflects their investment in fixed assets.
This is cash used to grow the business for the long term.
And the financing bucket contains all the interactions with creditors and shareholders.
So Dynamic paid dividends.
That was a $46 .8 million outflow.
They purchased marketable securities, a $25 .0 million outflow, which is basically just moving cash from the bank to short -term investments.
And they issued long -term debt, which is a $30 million inflow, and repaid some short -term bank debt, a $25 million outflow.
And when you total all of that up, the operating flow of $107 .2, the investing flow of negative $30, and the financing flow of negative $66 .08, the net result is an increase of $10 .4 million.
Which precisely matches the change on the balance sheet.
So this process of tracing the historical change is the absolute first step toward managing your future cash flow.
Okay.
So if tracing helps us understand why we ended up where we are, forecasting helps us prepare for where we need to be.
And the cash budget is the heart of short -term financial management.
The core goal here is predicting future cash needs, specifically for the coming year, 2022, to make sure you can pay your bills and maintain that essential minimum cash balance.
And this budget requires three sequential steps.
First, you forecast your sources of cash.
Second, you forecast your uses of cash.
And third, you calculate the resulting cash balance.
And from that, your financing requirement.
So step one starts with the sales forecast.
Dynamic is projecting sales of $560 million in Q1 of 2022.
But we know sales don't equal cash.
We have to forecast collections.
Right.
So we rely on the average payment time we've observed historically.
For Dynamic, they collect 70 % of sales in the current quarter and the other 30 % the following quarter.
Okay.
So for Q1 2022, their collections will be made up of 70 % of those Q1 sales, which is $392 million plus 30 % of the sales from the previous quarter, Q4 2021.
Which were $396 .7 million.
So 30 % of that is $119 million in collections.
So their total Q1 collections are $511 million.
This is a crucial number because it drives the change in accounts receivable.
And we use that fundamental AR formula, which managers have to track religiously.
Ending accounts receivable, beginning accounts receivable plus sales collections.
So let's just run the numbers for Q1 2022.
Dynamic starts Q1 with $150 million in AR.
They add $560 million in new sales and they subtract the $511 million in collections.
Which leaves them with $199 million in accounts receivable at the end of Q1.
And that forecast is so critical because it tells you two things.
How much cash you actually received and how much credit you just extended.
And that $199 million then becomes the starting AR for Q2 and it just feeds the next quarter's forecast.
Okay.
Step two.
Forecast uses of cash.
Dynamic projects expenses across five big categories.
Payments on accounts payable, inventory investment, labor and admin costs, capital expenditures, and then fixed payments like taxes, interest, and dividends.
The planned capital expenditure is the immediate item we need to focus on here.
Dynamic is planning a single massive $70 million capital outlay in Q1.
That's a huge planned cash drain and it really sets the stage for their short term crisis.
It does.
Which brings us to step three.
Calculate the cash balance and financing requirement, which is in table 30 .5.
We compare total sources, our collections, minus total uses to find the net inflow or outflow.
For Dynamic and Q1, the total sources are $511 million and total uses are a
$652 million.
Which results in a net cash outflow of negative $141 million in Q1.
That is a colossal deficit in just the first three months of the year driven in large part by that $70 million capex.
And this brings us to the concept of the minimum operating cash balance.
Managers don't want their cash balance to ever hit zero, even temporarily.
Right.
So Dynamic sets a $25 million buffer.
This buffer is there to absorb unexpected delays in collections or sudden unexpected costs.
It's a safety net.
So let's track the money.
Dynamic starts the year with $30 .4 million in cash.
They have a $141 million operational outflow.
That means their cash balance is already deep in the red at negative $110 .6 million.
But they still need that $25 million buffer on top of that.
So the total shortfall is what we call the cumulative financing required.
In Q1, Dynamic has to raise $135 .6 million externally just to cover the operational deficit and maintain the minimum buffer.
And it only gets worse in Q2.
They need another $72 .6 million for operations, bringing the peak cumulative financing requirement by the end of Q2 to $208 .2 million.
Over $200 million dollars required just temporarily.
That really feels like the make or break moment for Dynamic.
It is.
But here's the crucial context you have to add.
This large outflow isn't necessarily a sign of trouble.
It reflects a planned, profitable capital investment and predictable seasonality.
The problem is purely one of liquidity and timing.
That $208 .2 million is a temporary peak that disappears really rapidly in Q3 and Q4 as all those sales collections finally come in.
So the problem is very clearly defined.
Dynamic needs to cover a $208 .2 million peak financing requirement.
But this need is seasonal and it's going to reverse within a few months.
Right.
So the financial manager's job now is to figure out how to cover that peak in the most economical way possible.
So let's review the firm's financing options and what they cost.
This is really a risk management exercise, isn't it?
Balancing cost against availability.
Absolutely.
Option one is the bank loan.
This is the cheaper preferred option.
Dynamic has a pre -arranged line of credit up to $100 million dollars.
The cost is 2 .5 % per quarter, which is 10 % annualized.
It's flexible.
It's easy to manage.
Then you have option two, stretching payables.
This is the expensive and I would say painful option.
Definitely painful.
Dynamic can defer up to $100 million dollars in payments to its suppliers each quarter, but it comes at a very steep price.
A 5 % penalty.
That's the lost discount for early payment on the amount they defer, and that has to be paid in the next quarter.
Let's be really clear about that cost for you, the listener.
A 5 % penalty per quarter works out to an annualized interest rate of over 20%,
specifically 21 .6%.
That's basically a subprime credit card rate for a corporation.
Stretching payables is financially brutal.
You should only use it if absolutely no other capital is available.
So the logical, obvious financing strategy is pretty clear then.
Max out the cheaper bank loan first since it's limited to $100 million dollars.
Then and only then do you use the expensive stretching of payables to cover whatever deficit is left.
Okay, let's track Dynamic mattresses resulting plans step by step using the numbers from table 30 .6.
So in Q1, the total cash required is that $135 .6 million figure.
Dynamic maximizes the cheaper bank loan at $100 million dollars.
They also liquidate the $25 million dollars in marketable securities they were holding at the start of the year.
That leaves a residual gap of $10 .6 million dollars.
That's the $135 .6 they needed minus the $125 they've raised so far.
So that $10 .6 million dollars has to be covered by the most expensive option, stretching payables.
They're paying a very high price to cover just that final little bit of the deficit.
Okay, now Q2 is the crisis peak.
Dynamic needs $72 .6 million dollars just for operations.
But now they also have to cover all the financing costs they accrued from Q1.
Right.
That's $2 .5 million dollars in interest on the bank loan, the half a million in lost interest on the securities they sold.
And crucially, they have to pay off the $10 .6 million dollars in stretched payables from Q1 plus that 5 % penalty of another half a million.
So the total required in Q2 is $86 .7 million dollars.
And since the hundred million dollar bank loan is already maxed out, Dynamic has to use the expensive option to cover the entire Q2 need.
So they stretch another $86 .7 million dollars in payables.
This plan is really heavily leveraged toward that costly option in the short term.
But the turnaround happens in the second half of the year.
It does.
Q3 and Q4 generate enormous cash surpluses from operations.
So the immediate strategic priority becomes crystal clear.
Pay off the most expensive debt first.
So in Q3, they use that operational surplus to pay off the $86 .7 million dollars in stretched payables from Q2, including the 5 % penalty.
After servicing the bank loan interest, the remaining surplus lets them pay down about a quarter of the bank loan principal, so $25 .9 million dollars.
And then by Q4, Dynamic has a massive surplus, $170 .3 million dollars.
They repay the remaining $74 .1 million dollars of the bank loan principal and all the remaining interest.
And they end the year completely out of short -term debt.
And critically, they're able to add back $93 .9 million dollars into their cash and marketable securities account.
The crisis is officially over.
The plan is feasible, but it relies so heavily on extremely expensive financing during that peak.
And this forces the financial manager into a critical thinking step, evaluating the plan.
We have to look at the vulnerabilities.
And the reliance on that 21 .6 % annualized rate for payable stretching is the glaring weakness, which leads to the first critical question.
Is the cash reserve large enough for unexpected delays?
What if Q2 sales collections are slower than you forecast?
That $25 million dollar minimum balance buffer suddenly looks very, very thin.
Second big question, does this plan satisfy the bankers?
The plan involves really high short -term borrowing.
Bankers will be looking at Dynamic's current ratio.
That's current assets divided by current liabilities and their quick ratio.
Which is cash plus receivables divided by current liabilities.
Right.
And if those ratios dip too low during Q1 and Q2 because of all that short -term debt, the bank might threaten to cut off that $100 million dollar line of credit.
Third,
are there intangible costs to stretching payables?
That 21 .6 % cost is not the only price you pay.
Your suppliers might grow concerned about Dynamic's ability to pay, and that leads to damaged relationships, reduced credit terms.
Or even demands for cash on delivery.
Which would be a disaster.
This ill will can slow down your future operations and increase your costs permanently.
Okay, fourth question.
And this touches the matching principle we talked about earlier.
Should that major $70 million dollar capital expenditure have been financed long -term instead?
That's a classic trade -off.
If they had issued long -term debt or equity in Q1, they would have covered that massive initial outflow, completely avoided the short -term crisis, and saved millions in payables penalties.
So why not do that?
Well, if they financed the $70 million capex long -term, they solved the Q1 crisis, yes.
But then they're carrying that expensive 20 -year debt burden for decades.
The counter argument is that since the operational surplus in Q3 and Q4 was strong enough to pay off all the short -term debt anyway, the short -term borrowing was just a profitable temporary bridge to self -financing the asset.
It's a complex decision that the model forces them to confront.
Exactly.
And fifth and finally, can operating plans be adjusted?
Can you reduce your inventory requirements?
Can you negotiate stretcher payment terms with customers to speed up receivable collections?
Or could you even just negotiate a delay on that $70 million capex to push it into Q2 or Q3?
Any operational adjustment that reduces the Q1 -Q2 cash outflow would immediately reduce the need for that costly payable stretching.
So developing these plans is really an iterative trial and error process.
It has to be.
The financial manager has to understand the problem intimately.
And while computer models, you know, spreadsheets or customized software, can automate the arithmetic, the manager's real job is in the sensitivity analysis.
What happens if sales drop 10 %?
What if collections slow by 15 days?
And while optimization models, things like linear programming, can even search for the mathematically best plan given a defined set of constraints, they're only as good as the assumptions you feed into them.
Right.
In the end, it's trial and error, informed by those critical questions, that truly builds a manager's intuition about their short -term financial vulnerability.
Okay, we are shifting gears entirely now.
We're moving from the high stakes day -to -day crisis management of cash flow to sketching out the strategic map for the next five years.
This is where we ensure Dynamic Mattress doesn't end up with what the sources call a financial camel, a poorly coordinated collection of decisions that just doesn't fit together coherently.
That's a great image.
This transition is so crucial because we move away from all the operational minutiae and we start to focus on the large -scale investment and financing decisions.
A strong long -term plan requires management to look ahead, to understand their competitive advantages, and determine how the firm is going to generate superior returns over the long haul.
So why do firms commit so many resources to building these complex models?
The first reason seems to be contingency planning.
That's right.
Planning isn't just about forecasting the most likely future.
It's about scenario analysis.
It's about worrying about the unlikely adverse events.
If managers have already modeled a major recession or a supply chain collapse, they can respond much faster and more intelligently when those dangers actually appear on the horizon.
Exactly.
The second reason,
considering options,
long -term planning forces management to look beyond just the immediate projects on the table.
Sometimes a firm pursues an investment for strategic reasons, even if the immediate MPV is, you know, marginal.
Why would they do that?
Because that investment creates options.
It opens the door to potentially high value follow -on investments later that weren't feasible before.
Third, and this is maybe the most important one in big organizations, is forcing consistency.
Absolutely.
If the CEO announces a highly ambitious 25 % annual growth target, the model will instantly reveal if that goal is consistent with the firm's current operational limits and financing constraints.
Like, does 25 % growth require a level of borrowing that would violate your debt covenants?
Or does it mandate a massive immediate stock issue that management really wants to avoid?
The model highlights these
And it also ensures internal goals are consistent.
A high sales growth goal might require aggressive discounting, which could then erode your target profit margin.
The plan reveals that conflicting pressure point.
And I love the fascinating insight the source provides about accounting ratios being used as a kind of code.
Tell us about that.
It's a deep behavioral insight.
Often, accounting ratio goals like, say, targeting a 10 % profit margin are initially used as a simple code to signal underlying operational concerns.
For example, the desire to prevent costs from getting out of control.
Exactly.
But the danger is that the code gets forgotten and the accounting target becomes the goal itself, regardless of whether it aligns with creating shareholder wealth.
The Volkswagen example is perfect.
Right.
They had a goal of a 6 .5 % profit margin.
Which drove some regional managers to focus heavily on expensive high margin cars, sometimes neglecting the cheaper high volume models, all because they were just focused on meeting that percentage target.
And when they realized this distortion, they switched their internal focus to return on investment or ROI.
And that encouraged managers to maximize profit per dollar of invested capital, which is a much, much closer proxy for long term shareholder wealth creation.
Finally, long term planning is absolutely essential for valuing the firm.
As we've established in core finance principles, valuing a company requires forecasting its future free cash flows, or FCF, out to a terminal horizon.
And the pro forma statements that are generated by these long term planning models are the raw necessary inputs for estimating those FCFs.
Yeah.
Hashtag, tag, tag, tag, tag.
A long term model example.
Dynamic mattress pro forma.
Okay, let's construct dynamic mattresses five year strategic plan.
Now for long term models, we have to use a necessary simplification.
We collapse all current assets and current liabilities into one single figure, networking capital or NWC.
And dynamic plans for aggressive constant 20 % annual growth in sales and profits over five years.
They also commit to maintaining a 60 % dividend payout ratio.
Which means they retain 40 % of their earnings.
That's the plow back ratio.
So the model's central question becomes, can they finance this ambitious growth given their dividend policy without exceeding sustainable levels of debt?
The core mechanism of the model is balancing sources and uses.
When your planned investments and payouts exceed your internally generated cash flow, a financing gap opens up.
And this gap is the external capital required.
And the formula for that, formula 30 .2, is the engine of the plan.
It's external capital required, investment in NWC plus investment in fixed assets plus dividends, cash flow from operations.
This tells you exactly how much new debt or equity you have to issue each year.
Okay.
We follow the three steps laid out in table 30 .8.
Step one, project the income statement.
That's panel A.
Sales grow 20 % annually.
And because they assume costs remain a constant percentage of sales, net income also grows by 20%.
And since the plow back ratio is 40%, you calculate the reinvested earnings, which is the internal source of your equity growth.
Step two, project uses of capital.
That's panel B.
Since sales grow 20%, the required investment in NWC must also grow 20%.
That's a sales assumption.
Similarly, the investment in fixed assets needed to support that growth also increases.
And you add the dividends paid out.
So for 2022, Dynamic needs $181 .4 million in total capital uses.
But their internal cash flow, that's net income plus depreciation, is only $113 .5 million.
The model shows a clear gap.
$67 .9 million in external capital is required in 2022 alone.
So step three, construct the pro forma balance sheet, which is panel C.
The equity section of the balance sheet grows automatically each year because you're adding those reinvested earnings.
Yeah.
But how do you plug that external financing gap?
In the standard model, long -term debt is the balancing item.
It is.
It has to absorb that $67 .9 million required in 2022.
And then the cumulative amounts required in the subsequent years.
So the conclusion of this five -year plan is the strategic takeaway.
The 20 % growth rate is feasible, but it forces the debt ratio to accelerate dramatically, rising from 17 % in 2021 to a significantly higher 47 % by 2026.
And that is a flashing yellow light for management.
While 47 % might be manageable for five years, Dynamic couldn't continue to borrow at that accelerating pace indefinitely.
They would rapidly hit limits imposed by their banks, their debt covenants, or the bond rating agencies.
So this forces the financial manager right back to the drawing board.
If the debt ratio is too high, what do we have to change?
We could cut the dividend payout, which would free up retained earnings.
Or you could try to optimize operations to reduce the required investment in networking capital.
The model allows them to test the consequences of these strategic alternatives instantly.
But we have to be careful not to confuse the model's output with absolute truth, right?
Dynamic's model is a percentage of sales model.
It relies on the huge simplification that costs, NWC, and fixed assets are all perfectly proportional to sales growth.
And that simplification often fails the reality check.
In reality, your inventory or cash balances often rise less rapidly than sales, as economies of scale kick in.
And more critically, fixed assets are almost never proportional to sales.
Not at all.
A factory has capacity constraints.
Dynamic might be able to achieve 20 % sales growth for a few years without adding a single new machine, just because the existing plant was underutilized.
But then, to grow another 1%, they suddenly need one massive, discrete investment in a new wing or a completely new facility.
And the proportional assumption smooths out these massive, lumpy investment needs, which can lead to big forecasting errors.
And we should issue a strong warning against over -engineering these models.
Managers can fall into the trap of adding too much complexity.
If you try to include every detail of every single division, the model becomes cumbersome, rigid.
And it distracts management from the truly crucial strategic decisions like, what's the optimal dividend policy, or should we be raising equity instead of debt?
Right.
And the ultimate limitation is that the model provides consistency, but it doesn't provide optimality.
It shows you the consequences of your 20 % growth decision, but it does not tell you if that growth is generating a positive NPV.
The manager still has to decide the optimal capital structure and payout policy.
The model is a constraint checker, not a decision maker.
So now we circle right back to the core concept of corporate finance.
The detailed forecast that we generated from our long -term planning model can transition seamlessly into the valuation process.
So the model provides the foundational numbers we need to estimate the company's value today.
Exactly.
To value the company, we have to forecast the free cash flow, FCF, across the planning horizon.
And FCF is the cash generated by the business that is truly available to all investors, both debt and equity holders, after all the necessary investments are made.
And we define FCF as operating cash flow minus the investment in NWC and minus the investment in fixed assets.
And the sources show how to calculate operating cash flow by taking net income and adding back depreciation and after -tax interest.
Though the latter is only if we assume the firm is all equity financed for valuation purposes.
So table 30 .9 shows the calculation for dynamic.
And the key finding here is that dynamics FCF is negative for all five of the forecasted years.
For example, it's negative $10 .2 million in 2022.
That might sound terrifying to a casual observer.
It does sound alarming, but we have to understand the why.
The negative FCF reflects the high level of investment needed to support that plan 20 % growth.
Dynamic is plowing cash back into NWC and fixed assets faster than those assets are generating cash flow in the immediate term.
So the negative FCF is only a worry if the assets they're acquiring don't ultimately produce significant positive cash flows in the long run.
Exactly.
If the investments are positive NTV, then the negative FCF today is perfectly acceptable.
And this is why the valuation calculation relies so heavily on the final piece of the puzzle, the horizon value, HV.
Right.
The HV is the estimated value of the company at the end of the planning period in year five, and it represents all future cash flows beyond that point.
So to find the total present value or PV of the firm today, we discount the negative FCFs for years one through four, and then we discount the final FCF plus that massive horizon value from For Dynamic, if we assume a 15 persist WACC and a horizon value of about $1 .99 billion,
which is derived from estimating 10 times the 2026 all equity earnings, the total present value of the company is calculated to be $912 .8 million.
And this process directly links the manager's five -year operating and financing plan right back to the core concept of maximizing current shareholder value.
Okay, let's return to that critical connection, the link between growth and
In fact, table 30 .10 shows that for Dynamic, the required external financing drops precisely to zero when the annual growth rate is 5 .9%.
And that 5 .9 % rate is not arbitrary, is it?
It's the firm's inherent limit on growth without having to go out and ask for money.
It is.
And this brings us to the two fundamental constraints on growth, starting with the internal growth rate, IGR.
The IGR is defined as the maximum rate a firm can grow without raising any external funds whatsoever.
So no new debt, no new equity, growth has to be financed entirely through retained earnings.
And the basic formula for IGR gives you immediate intuition.
It's just internal growth rate for agree invested earnings sets.
But the sources break this down further using the modified DuPont framework, which is formula 30 .3.
And this is invaluable for managers who are trying to improve their IGR.
The full formula is internal growth rate, tile back ratio times return on equity times frequent net assets.
So let's unpack the drivers here.
First, the plow back ratio, the higher the proportion of earnings you retain in the business and don't pay out as dividends, the more internal capital you have available and the faster your IGR.
Make sense.
Second, return on equity, ROE.
The more profitable the business is relative to the capital shareholders have invested, the faster the earnings grow and the faster the firm can support that growth.
And third,
that final crucial term,
equity divided by net assets.
This ratio acts as the strict limiter.
Right.
If you can't borrow, which is a constraint of IGR, every single dollar of new asset growth has to be funded by your existing equity base.
Yeah.
So this term ensures the growth rate is reduced if the company relies heavily on debt in its existing structure.
And applying this to Dynamic, with their 40 % plow back ratio, 17 .9 % ROE, and a 0 .826 equity net assets ratio, their maximum IGR is indeed 5 .9%.
Which confirms why their planned 20 % growth requires massive external capital.
Okay.
Now let's look at the sustainable growth rate, SGR.
This is slightly different, a little less strict.
The SGR is the highest rate a firm can maintain without increasing its financial leverage.
Meaning keeping its debt to equity ratio constant.
Right.
And without issuing any new equity.
And because SGR allows the firm to issue new debt proportionally to its growth and equity, the formula simplifies dramatically.
Just formula 30 .4, sustainable growth rate plow back ratio times return on equity.
So for Dynamic, the SGR is 0 .40, their plow back, multiplied by 0 .1815, their ROE, which gives you 7 .26%.
Which brings us to the self -test question in the text.
Why is the SGR of 7 .26 % always higher than the IGR of 5 .9 %?
The difference is entirely in the allowance for proportional borrowing, isn't it?
The IGR strictly prohibits all external capital.
It has to fund all growth from retained earnings, which is why that equity to net assets term limits it.
Whereas the SGR allows the company to borrow enough money to maintain its current debt to equity ratio.
Since debt is an external source of capital, the SGR lets the firm sustain a rate of growth without running into problems with its capital structure stability.
These simple formulas are a great reminder to managers of a crucial strategic reality.
While firms can grow really rapidly in the short term by aggressively relying on new debt, that growth can rarely be maintained without incurring excessively high leverage levels.
Unless they can fundamentally increase their ROE or change their retention policy.
So this deep dive into financial planning has really shown that the process isn't just about making spreadsheets.
It's about forcing strategic clarity and consistency across the entire organization.
That's right.
Short -term planning, driven by the cash budget and the cash flow statement, is absolutely essential for operational survival.
It helps managers identify those peak seasonal financing requirements, like Dynamics' $208 .2 million crisis, and choose the least painful way to bridge those temporary funding gaps.
And long -term planning, using pro forma analysis, forces strategic alignment.
It makes sure that ambitious goals for growth are fully consistent with the firm's ability to generate cash internally and its stated financing decisions.
And it reveals red flags, like an unsustainable rise in the debt ratio.
Furthermore, these models are the critical input for valuation.
They provide the necessary forecasted income statements and balance sheets, which are then converted directly into free cash flows to determine the company's value today.
And we learned that a firm's inherent, unconstrained growth ability is fundamentally limited by its profitability, its ROE, and how much cash it chooses to retain the payback ratio.
That 7 .26 % sustainable growth rate is the real strategic speed limit for them.
And the final provocative thought is this.
Managers often obsess over maximizing growth, but the discipline of planning shows us the true constraint.
Rapid growth demands heavy, and often costly, financing.
The key strategic task isn't simply how fast you can grow, but whether you can execute a plan that ensures every new investment dollar generates a return above the cost of capital.
That is what determines if your detailed cohesive plan creates true shareholder wealth.
A huge thank you to you, our listener, for sharing the source material that made this deep dive possible.
We'll see you next time.
ⓘ This audio and summary are simplified educational interpretations and are not a substitute for the original text.
Using this chapter to study? Last Minute Lecture is free and student-run. If it helped, consider supporting the project.
Support LML ♥Related Chapters
- Full Disclosure in Financial ReportingIntermediate Accounting
- Understanding the Statement of Cash FlowsFinancial Accounting
- Accrual Accounting and Financial Statement AnalysisFinancial Accounting
- Business Transactions and the Accounting EquationFinancial Accounting
- Community Health Planning & EvaluationCommunity Health Nursing: A Canadian Perspective
- Community Health Planning & EvaluationCommunity/Public Health Nursing: Promoting the Health of Populations