Using Financial Statements to Evaluate Financial Choices
Learning Objectives
- Define pro forma financial statements.
- Explain how pro forma financial statements can be used to project future scenarios for the planning process.
Now that you understand the relationship of time and value, especially looking forward, you can begin to think about how your ideas and plans will look as they happen. More specifically, you can begin to see how your future will look in the mirror of your financial statements. Projected or pro forma financial statements can show the consequences of choices. To project future financial statements, you need to be able to envision the expected results of all the items on them. This can be difficult, for there can be many variables that may affect your income and expenses or cash flows (CF), and some of them may be unpredictable. Predictions always contain uncertainty, so projections are always, at best, educated guesses. Still, they can be useful in helping you to see how the future may look.
We can glimpse Alice’s projected cash flow statements and balance sheets for each of her choices, for example, and their possible outcomes. Alice can actually project how her financial statements will look after each choice is followed.
When making financial decisions, it is helpful to be able to think in terms of their consequences on the financial statements, which provide an order to our summary of financial results. For example, in previous chapters, Alice was deciding how to decrease her debt. Her choices were to continue to pay it down gradually as she does now; to get a second job to pay it off faster; or to go to Vegas, hit it big (or lose big), and eliminate her debt altogether (or wind up with even more). Alice can look at the effects of each choice on her financial statements (Figure 4.14 “Potential Effects on Alice’s Financial Statements”)
Figure 4.14 Potential Effects on Alice’s Financial Statements
Choices | Income Statement | Cash Flow Statement | Balance Sheet |
Continue | No new effects | No new effects | Debt (Down) Net worth (Up) |
Second job | Income (up) | No net effect (increased cash flow from wages is used to pay debt) | Debt faster (down) Net worth faster(up) |
Vegas: Win | Expenses – for the trip (up) | No net effect (increased cash flow from winnings is used to pay debt) | Eliminate debt; Net worth (up) |
Vegas: Lose | Expenses – for the trip (up) | Net cash flow (down) | Debt (up) Net worth (down) |
Looking more closely at the actual numbers on each statement gives a much clearer look at Alice’s situation. Beginning with the income statement, income will increase if she works a second job or goes to Vegas and wins, while expenses will increase (travel expense) if she goes to Vegas at all. Assume that her second job would bring in an extra $20,000 income and that she could win or lose $100,000 in Vegas. Any change in gross wages or winnings (losses) would have a tax consequence; if she loses in Vegas, she will still have income taxes on her salary. Figure 4.15 “Alice’s Pro Forma Income Statements” begins with Alice’s pro forma income statements.
Figure 4.15 Alice’s Pro Forma Income Statement
Continue | Second Job | Vegas: Win | Vegas: Lose | |
For the Year Ending | 12/31/10 | 12/31/10 | 12/31/10 | 12/31/10 |
Gross wages | $44,650 | $64,650 | $144,650 | ($55,350) |
Income taxes and deductions | $8,930 | $12,930 | $28,930 | |
Disposable income | $35,720 | $51,720 | $115,720 | ($55,350) |
Rent expense | $10,800 | $10,800 | $10,800 | $10,800 |
Food | $3,900 | $3,900 | $3,900 | $3,900 |
Car expenses | $3,600 | $3,600 | $3,600 | $3,600 |
Clothing | $1,800 | $1,800 | $1,800 | $1,800 |
Cell phone | $1,200 | $1,200 | $1,200 | $1,200 |
Internet and cable TV | $1,200 | $1,200 | $1,200 | $1,200 |
Entertainment, travel, etc. | $2,700 | $2,700 | $3,700 | $3,700 |
Total living expenses | $25,200 | $25,200 | $26,200 | $26,200 |
Car loan interest | $240 | $240 | $240 | $240 |
Student loan interest | $4,240 | $4,240 | $4,240 | $4,240 |
Total interest expense | $4,480 | $4,480 | $4,480 | $4,480 |
Net income | $6,040 | $22,040 | $85,040 | ($86,030) |
While Vegas yields the largest increase in net income or personal profit if she wins, it creates the largest decrease if she loses; it is clearly the riskiest option. The pro forma cash flow statements (Figure 4.16 “Alice’s Pro Forma Cash Flow Statements”) reinforce this observation.
Figure 4.16 Alice’s Pro Forma Cash Flow Statements
Continue | Second Job | Vegas: Win | Vegas: Lose | |
For the Year Ending | 12/31/10 | 12/31/10 | 12/31/10 | 12/31/10 |
Cash from Gross wages | $44,650 | $64,650 | $44,650 | $44,650 |
Cash paid for: | ||||
Income taxes and deductions | ($8,930) | ($12,930) | ($8,930) | ($8,930) |
Rent expense | ($10,800) | ($10,800) | ($10,800) | ($10,800) |
Food | ($3,900) | ($3,900) | ($3,900) | ($3,900) |
Car expenses | ($3,600) | ($3,600) | ($3,600) | ($3,600) |
Clothing | ($1,800) | ($1,800) | ($1,800) | ($1,800) |
Cell phone | ($1,200) | ($1,200) | ($1,200) | ($1,200) |
Internet and cable TV | ($1,200) | ($1,200) | ($1,200) | ($1,200) |
Entertainment, travel, etc. | ($2,700) | ($2,700) | ($3,700) | ($3,700) |
Car loan interest | ($240) | ($240) | ($240) | ($240) |
Student loan interest | ($4,240) | ($4,240) | ($4,240) | ($4,240) |
Operating cash flow | $6,040 | $22,040 | $5,040 | $5,040 |
Cash from gambling | – | – | $100,000 | ($100,000) |
Cash for repayment of car loan | ($2,160) | ($2,160) | ($2,160) | ($2,160) |
Cash for repayment of student loan | ($3,480) | ($19,000) | ($53,000) | ($7,760) |
Proceeds from new loan | – | – | – | $104,880 |
Financing cash flows | ($5,640) | ($21,160) | ($44,300) | ($5,040) |
Net cash flows | $400 | $880 | $49,340 | 0 |
If Alice has a second job, she will use the extra cash flow, after taxes, to pay down her student loan, leaving her with a bit freer cash flow than she would have had without the second job. If she wins in Vegas, she can pay off both her car loan and her student loan and still have an increased free cash flow. However, if she loses in Vegas, she will have to secure more debt to cover her losses. Assuming she borrows as much as she loses, she will have a small negative net cash flow and no free cash flow, and her other assets will have to make up for this loss of cash value.
So, how will Alice’s financial condition look in one year? That depends on how she proceeds, but the pro forma balance sheets (Figure 4.17 “Alice’s Pro Forma Balance Sheets”) can give a glimpse.
Figure 4.17 Alice’s Pro Forma Balance Sheets
Continue | Second Job | Vegas: Win | Vegas: Lose | |
12/31/10 | 12/31/10 | 12/31/10 | 12/31/10 | |
Assets | ||||
Car | $5,000 | $5,000 | $5,000 | $5,000 |
Savings | $650 | $1,130 | $49,590 | 0 |
Total assets | $5,650 | $6,130 | $54,590 | $5,000 |
Liabilities | ||||
Car loan | $540 | $540 | – | $540 |
Student loan | $45,240 | $34,000 | – | $45,240 |
New loan | – | – | – | $104,880 |
Total liabilities | $45,780 | $34,540 | 0 | $150.660 |
Net worth | ($40,130) | ($28,410) | $54,590 | ($145,660) |
If Alice has a second job, her net worth increases but is still negative, as she has paid down more of her student loan than she otherwise would have, but it is still larger than her asset value. If she wins in Vegas, her net worth can be positive; with her loan paid off entirely, her asset value will equal her net worth. However, if she loses in Vegas, she will have to borrow more, her new debt quadrupling her liabilities and decreasing her net worth by that much more.
A summary of the critical “bottom lines” from each pro forma statement (Figure 4.18 “Alice’s Pro Forma Bottom Lines”) most clearly shows Alice’s complete picture for each alternative.
Figure 4.18 Alice’s Pro Forma Bottom Lines
Alice’s Choices | Continue | Second Job | Vegas: Win | Vegas: Lose |
12/31/10 | 12/31/10 | 12/31/10 | 12/31/10 | |
Net Income | $6,040 | $22,040 | $85,040 | ($86,030) |
Net cash flow | $400 | $880 | $49,340 | ($4,880) |
Net worth | ($40,130) | ($28,410) | $54,590 | ($145,660) |
Going to Vegas creates the best and the worst scenarios for Alice, depending on whether she wins or loses. While the outcomes for continuing or getting a second job are fairly certain, the outcome in Vegas is not; there are two possible outcomes in Vegas. The Vegas choice has the most risk or the least certainty.
The Vegas alternative also has strategic costs: if she loses, her increased debt and its obligations—more interest and principal payments on more debt—will further delay her goal of building an asset base from which to generate new sources of income. In the near future, or until her new debt is repaid, she will have even fewer financial choices.
The strategic benefit of the Vegas alternative is that if she wins, she can eliminate debt, begin to build her asset base, and have even more choices (by eliminating debt and freeing cash flow).
The next step for Alice would be to try to assess the probabilities of winning or of losing in Vegas. Once she has determined the risk involved—given the consequences now illuminated on the pro forma financial statements—she would have to decide if she can tolerate that risk, or if she should reject that alternative because of its risk.
Key Takeaways
- Pro forma financial statements show the consequences of financial choices in the context of the financial statements.
Exercises
- What do pro forma financial statements show?
- What are pro forma financial statements based on?
- What are the strategic benefits of making financial projections on pro forma statements?