Financial Statement Analysis And Financial Models

FINANCIAL STATEMENT ANALYSIS AND FINANCIAL MODELS

Jaffe and Jordan want to use financial planning models to prepare a projected (pro forma) financial statement to determine the profitability and financial health of the business for next year, ending Dec 31, 2021. Use the pro forma financial statement below to answer the following questions:

PRO FORMA INCOME STATEMENT

($millions)

Total operating revenues

82

Less expenses

27

Less depreciation

9

Earnings before interest and taxes

46

Less interest

4

Net income before taxes

42

Less taxes @ 23.8%

10

Net income

32

PRO FORMA BALANCE SHEET

Assets:

Cash

19

Other current assets

28

Net Fixed Assets

40

Total Assets

87

Liabilities and Equities:

Accounts payable

12

Long-term debt

28

Stockholders' Equity

47

Total Liabilities & Equities

87

a. What is the estimated profit of the business for 2021?

b.  Compute the following profitability ratiosand explain to Jaffe and Jordan whether the business looks profitable relative to the performance of the industry.

i. Profit margin

 ii. Return on assets

 iii. Return on equity

 iv. calculate and explain operating cash flow

The industry ratios are as follows:

Industry ratios

Profit margin

32.80%

Return on assets

34.00%

Return on equity

42.50%

c. Assuming you project a 25% increase in operating revenue (sales) per year what will be the anticipated operating revenue in 2022?

d. If net income is projected to increase by 20% per year, what will be the profit margin in 2022?

e. What will be the estimated earnings per share (EPS) in 2022 if 1,000,000 shares are issued?