This website uses cookies to ensure you have the best experience. Learn more

Pro Forma Essay

1472 words - 6 pages

FINANCIAL STATEMENT OVERVIEW
ASSIGNMENT # 3

Members: Zhishuang Liu
Siyi Shang
Qihui Wu
Anqi Li
Context

1. Assumptions 2
2. I/S Pro Forma 2
1.1 Interest Income 2
1.2 Net Interest Income Margin 2
1.3 Provision for Loan Losses 5
1.4 Net Income Margin 6
1.5 Tax Rate 6
1.6 Non-interest income and Non-interest expense 7
3. B/S Pro Forma 8
3.1 ROA and ROE 8
3.2 The Accounts change according to the Interest Income and Interest Expense 9
3.3 The Other Asset and Liability Accounts 11
3.4 Shareholders’ Equity Forecast 12
3.5 Retained earnings 13
4. Cash Flow Statement Pro Forma 15

1. Assumptions
(1) Interest Income grows ...view middle of the document...

According to the predictive values of interest income and net interest income margin, get the values of net interest income (interest income* net interest income margin) and interest expense (interest income- net interest income).

Graph 2.3 Int and Fee on Loans/ Int Income

Graph 2.4 Sub-accounts/ Int Income

Graph 2.5 Interest on deposits/ Interest Expense

Graph 2.6 Sub-accounts/ Interest Expense

Based on Graph 2-3 – Graph 2-6, consult proportions of each sub-account of interest income and interest expense in the past years and get the predictive values of each sub-account of 2014-2018.

Provision for Loan Losses

Graph 2-7 Provision for Loan Losses

Graph 2-7 shows the provision for loan losses form year 2006 to year 2013. Orrstown increased its provision for loan losses dramatically since the outbreak of financial crisis. Considering that there is little chance that the financial crisis could happen in the near future, ignore the outliers and use the average of provision for loan losses before 2009 to predict.

Net Income Margin

Graph 2-8 Net Income Margin

Net Income Margin was steady from 2006 to 2013, except for year 2011 and 2012. Ignoring the outliers because of the financial crisis, use the average as the prediction of net income margin for the next five years. The net income equals to interest revenue multiplies net income margin.

Tax Rate

Graph 2-9 Tax Rate

Graph 2-9 tells the tax rates of Orrstown from 2006-2013. The last three years had anomalous tax rates owing to the negative net income before tax. Take the arithmetic average of the tax rates to estimate the tax rate from year 2006-2013.

Non-interest income and Non-interest expense

Graph 2-10 Non-interest income

Graph 2-11 Non-interest expense

Based on Graph 2-10 and Graph 2-11, assume that the non-interest income and non-interest expense grow at a geometric average rate. Make slight judgments in order to match with other accounts.

The pro forma of Income Statement is shown on appendix I.
1. B/S Pro Forma

Using the forecast data from Income Statement, we can forecast the total Asset and total Equity in Balance Sheet by predict ROA and ROE ratio.

ROA and ROE

Graph 3-1 ROA ratios

Graph 3-2 ROE ratios

According to the Graph 3-1 and 3-2, except the data in 2011 and 2012, the ROA and ROE ratio deceases gradually. So we assume that in five year, the ROA and ROE ratios will decease at a Compound Annual Growth Rate.
Then, we use Net Income dividend by ROA to derive the future total Asset. Also we use Net Income dividend ROE to obtain the future total Equity. The difference between Asset and Equity is the total Liability.

The Accounts change according to the Interest Income and Interest Expense
In the Balance Sheet, some asset accounts will change the same as the change in Interest Income account, and some liability will change according to the Interest Expanse, such as Interest bearing, Net Loans and...

Other assignments on Pro Forma

Businss Plan Outline Example

3131 words - 13 pages |0% | |Estimated Monthly Fixed Cost |$0 | Chart: Break-even Analysis [pic] 7.4 Projected Profit and Loss Table: Profit and Loss |Pro Forma Profit and Loss | | | | | |FY

Korean Restaurant Essay

5337 words - 22 pages Aspects A Pro-Forma Financial Statement is a projection to forecast a company’s future of two to three years. This helps to rethink strategies and make suitable adjustments when necessary. Figure 1.0 shows the Pro Forma Income Statement, Figure 2.0 shows the Pro Forma Balance Sheet and Figure 3.0 the Pro Forma Statement of Cash Flow for Joh-Eun Korean restaurant. Figure 1.0 Pro Forma Income Statement for Joh-Eun Korean Restaurant

Who?

3958 words - 16 pages ., a 42-stor retail video chain based in San Diego, Calif., for $6,380.861 in cash and 885,508 shares of common stock. In addition, during 1988, the Company acquired four other businesses for $4,840.462 in cash and notes, and 449,889 shares of its common stock. The aforementioned acquisitions were accounted for under the purchase method of accounting. The Company’s consolidated results of operations on an unaudited pro forma basis, assuming

Acct-311

2438 words - 10 pages and equity are not. No dividends are paid. Next year’s sales are projected to be $ 7,434. What is the external financing needed? An increase of sales to $7,424 is an increase of: Sales increase = ($7,424 – 6,300) / $6,300 Sales increase = .18 or 18% Assuming costs and assets increase proportionally, the pro forma financial statements will look like this: Pro forma income statement Pro forma balance sheet

Sure Cut Shears

732 words - 3 pages downturn and was slow to react to the financial impacts it had on the company. • If Mr. Fisher used a team of analyzers to construct the pro forma financial reports, perhaps the wrong assumptions about steady sales and other factors would not have been made. Doesn’t seem as if there were appropriate financial “checks and balances” in place. Which is concerning given the financial scrutiny company’s face from the public and Government. • Thinking

Supply Chain

3135 words - 13 pages full screen at 720p for best results. Competencies This course provides guidance to help you demonstrate the following 10 competencies: * Competency 326.1.5: Budgets The graduate utilizes budgets and a variety of pro-forma statements for planning and control purposes including analyzing cash flows to assure adequacy of funds for capitalizing on business opportunities. * Competency 327.3.1: Continuous Improvement and Quality Management

Petro

7556 words - 31 pages your own business plan.   Create your own business plan » Need actual charts?   We recommend using LivePlan as the easiest way to create graphs for your own business plan.   Create your own business plan » Pro Forma Profit and Loss | | Year 1 | Year 2 | Year 3 | Sales | $52,217 | $77,383 | $104,446 | Direct Cost of Sales | $12,114 | $17,772 | $24,227 | Other Costs of Sales | $0 | $0 | $0 | Total Cost of Sales | $12,114

Ust Case Solution

2980 words - 12 pages dividends to their shareholders (this makes the stock riskier, but the high dividends may still make them attractive to shareholders).  3. Should UST, Inc., undertake the $1 billion recapitalization? Calculate the marginal (incremental) effect on UST's value, assuming that the entire recapitalization is implemented immediately (January 1, 1999).  a. Assume a 38% tax rate.  b. Prepare a pro-forma income statement to analyze whether UST will be able

Fin 571 Week 2 Connect Problems Assignment

1999 words - 8 pages . • current liabilities divided by current assets. 12. Which statement expresses all accounts as a percentage of total assets? • pro forma balance sheet • common-size income statement • statement of cash flows • pro forma income statement • common-size balance sheet Find FIN 571 Week 4 Connect Problems quiz answers here FIN 571 Week 4 Connect Problems 13. Ratios that measure how efficiently a firm's management uses its assets and equity to

Financial Decision Making

1251 words - 6 pages desirable investment? iv. Is it likely that the required rate of return for DAD Ltd’s preference shares would be the same as the required rate of return on the bonds?. Why, why not? (a) $1,117.40 (b) i 9.26% ii $50.00 (2 + [2 + 2 + 2 + 2] = 10 marks) Question 7 As the financial manager for a manufacturing firm, you have constructed the following partial pro forma income statement for the next fiscal year

Financial Accounting Determination

3567 words - 15 pages . When reporting a cumulative effect of a change in accounting principle, 02 Income Determination current disclosure rules require that a. all prior years’ income statements be restated to reflect use of the new principle. b. all prior years’ income statements be restated to reflect use of the new principle, and include a pro forma income figure of the previously reported income. c. no prior years’ income statements be restated, but a pro forma

Similar Documents

Test Upload Essay

970 words - 4 pages | Investment Analysis | | | | | | 4.1 | Cash flows | | | | 4.2 | NPV Analysis | | | | 4.3 | Rate of Return Calculations | | | | 4.4 | Payback Period Calculations | | 5.0 | Pro Forma Financial Statements | | | | | | 5.1 | Pro Forma Income Statement | | | | 5.2 | Pro-Forma Cash flow Statement | | | | 5.3 | Pro-Forma Balance Sheets | | 6.0 | Works Cited | | | | 7.0 | Appendices | | | | | | 7.1

Devry Busn 278 Essay

967 words - 4 pages Analysis | | | | | | 4.1 | Cash flows | | | | 4.2 | NPV Analysis | | | | 4.3 | Rate of Return Calculations | | | | 4.4 | Payback Period Calculations | | 5.0 | Pro Forma Financial Statements | | | | | | 5.1 | Pro Forma Income Statement | | | | 5.2 | Pro-Forma Cash flow Statement | | | | 5.3 | Pro-Forma Balance Sheets | | 6.0 | Works Cited | | | | 7.0 | Appendices | | | | | | 7.1 | Appendix 1

Ust Case Essay

1000 words - 4 pages g = .019109 = 1.91% 3. Assume a 38% tax rate, and net sales will grow at 5% from 1998 level, and the ratio of EBIT to Net sales in 1999 will be equal to the 5-year average EBIT/Net sales ratio from 1994 to 1998 period, prepare a pro-forma income statement as the following table. Will UST will be able to make interest payments (4 points)? Income Statement Projections (in millions, except per-share data and ratios) | |Actual

Surecut Shears Essay

356 words - 2 pages the periodJuly—December of each year, when additional working capital was needed to support a seasonalsales peak. As a matter of policy, the company attempted to produce at an even rate throughoutthe year, and this accounted in good part for the sizable need for seasonal funds.In June 1995 Mr. Fischer arranged a line of credit of $3.5 million with the HudsonNational Bank to cover requirements for the fall. At the time, he anticipated that the loan wouldbe completely paid off by December 1995. He gave Mr. Stewart a pro forma estimate of the