"

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?

 

License

Icon for the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License

Personal Finance Copyright © by Saylor Foundation & Montgomery College is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License, except where otherwise noted.