Premium Essay

Pro Forma

In:

Submitted By ssy1990
Words 1472
Pages 6
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 at a certain rate every year.
(2) There is no issue of new shares
(3) There are tendencies of the ratios, such as net interest income margin, net income margin, return on asset, return on equity, etc., that could be used for forecasting.
(4) Simplify the accounts of Balance Sheet, Income Statement and Cash Flow Statement.

* 2. I/S Pro Forma
Interest Income

Graph 2-1 Interest Income

Graph 2-1 shows the total interest income of Orrstown from year 2006-2013. As it takes a longer time for small financial institutions to react on the financial crisis, the negative interest income of orrstown showed in year 2012 and 2013. Because there would be little chance of any big financial crisis in the following five years, it is reasonable to take outliers. Take the average of the annual growth rate of total interest income from 2006 to 2011, and use it as the annual growth rate of total interest income for the nest five years.

Net Interest Income Margin

Graph 2.2 Net Interest Income Margin

As is shown on Graph 2.2, the net interest income margin grew steadily from 2006-2013. Get the geometric average and Use the result as the predictor of net interest income margin for

Similar Documents

Free Essay

Pro Forma

...Analyzing Pro Forma Statements Christopher Radko has been in business for thirty years making blown glass Christmas ornaments. They have expanded their line to include snow globes and cookie jars and even a line of jewelry. I propose that Christopher Radko market a new product to their collectors; a home décor line that showcases their style. This line would include throw pillows, rugs, paintings and tabletop accent pieces. Pro Forma statements are hypothetical assumptions of a company for a time span, in this case five years. Taking an already successful company and adding to the line can be both a good idea and tricky because the customer base can split two ways. They can either decide that they love the addition and buy it or become upset at the perception that the company is changing its product line. A pro forma statement can include and exclude whatever the company feels is relevant or irrelevant; onetime expenses are usually not used in pro forma statements either. The pro forma guidelines are not as strict as generally accepted accounting principles. The calculations that were arrived to for Christopher Radko show how the line would be beneficial if it included a new home décor line. It is worth mentioning that the net income does not reflect one time buys therefore the pro forma statement does not reflect that information. While it was not shown in the attached pro forma statement there are companies that write off merchandise to in attempt to manipulate their outcomes...

Words: 297 - Pages: 2

Premium Essay

Analyzing Pro Forma Statement

...Pro forma income statement is similar to historical income statement, the difference is that the pro forma income statement projects the future. Pro forma income statements provide an important benchmark for operating a business throughout the year ( BusinessTown 2001 ). It provides the information that they need to help them make the right choices for their business. The XYZ Company are looking to increase their sales in the next five years. The company will introduce a new product and they will also maximize capacity in order to achieve company’s growth. Through the increase sale, the company will be able to get fixed assets with the use of their excess cash and in necessary they will take some loans to cover the additional cost that will arise. The pro forma income statement show a 12% increase in their gross sales and in the next five years there will be an 11% increase. There will be an increase in the cost of sales and those for the supplies, raw materials and product ion labor of the company that will happen when they start to add the new product. The increase will be tied to the expense of selling and under that are the new products commission sale, marketing the new product and hiring new workers. The total cost of sale represent 60.1 % and the gross profit is 39.9% of increase on sales. The total operating expenses will be 16.4 % of the sales and under that are payroll taxes, major expenses wages and benefits. Under the wages is hiring new worker, if needed, but the...

Words: 628 - Pages: 3

Premium Essay

Analyzing Pro Forma Statements

...XYZ Company, Inc: Analyzing Pro Forma Statements Karen E. Estremera Pizarro University of Phoenix FIN/571 - Foundations of Corporate Finance June 23, 2014 Prof. Victor Mojica – Rivera Analyzing Pro Forma Statements Pro Forma Statements are financial statements that a company prepares to consider the effects of potential activity (Pro Forma Statement, 2013). It is a financial statement showing the forecast or projected operating results and balance sheet, as in pro forma income statements, balance sheets, and statements of cash flows ((Parrino, Kidwell, and Bates, 2012). The XYZ Company, Inc. is looking to increase the sales in the next five years with the introduction of a new product in their organization. The following paper will review XYZ Company’s five-year financial plan to grow the organization. To achieve the company growth the strategy is introduce a new product and maximize capacity. Through increased sale, we will be getting fixed assets with the excess cash and will be taking loan if is necessary to cover any additional costs arise or are not sufficiently measured. Below in Figure 1-1, the pro forma income statement shows a 12% increase in gross sales for the year 2014 and 11 % in the next five-years. Therefore, in same proportion have been estimated the increase in the cost of sales, then other operating expenses and selling expenses will increase in the same ratio of sales. The increase in cost of sales are the purchases of raw...

Words: 789 - Pages: 4

Premium Essay

What Is a Pro Forma Income Statement

...What is the purpose of a Pro Forma income statement? How would you use the information from the Pro Forma income statement? Provide an example. According to businesstown.com, Pro Forma income statements are “an important tool for planning future business operations. If the projections predict a downturn in profitability, you can make operational changes such as increasing prices or decreasing costs before these projections become reality.” Pro Forma income statements are used to let investors know a company’s operating results, conforming to investopedia.com, “Pro Forma financial statements take out one-time charges to smooth earnings.” In addition, “Pro-forma earnings describe a financial statement that has hypothetical amounts, or estimates, built into the data to give a "picture" of a company's profits if certain nonrecurring items were excluded.” (investopedia.com) The information from a Pro Forma income statement can be used through: * To give investors a clearer view of company operations - This applies to the nature of a business. investopedia.com explains that “Companies in certain industries tend to use pro-forma reporting more than others, as the impetus to report pro-forma numbers is usually a result of industry characteristics. For example, some cable and telephone companies almost never make a net operating profit because they are constantly writing down big depreciation costs.” (businesstown.com) But; * For companies that do not include cash charges...

Words: 382 - Pages: 2

Premium Essay

Ye Task Complete the ‘Prince’s Trust’ Business Plan Pro Forma Which You Have Been Given (P5). for Distinction Level You Will Need to Present a Comprehensive Proposal, with All Sections Completed in Full Detail. (D1)

...Contents Page |Criteria |Issue Date |Due Date |Submitted |Achieved |Page | |How the unit works and Command Words | | | | |2 | |Pass 2/Merit 1 | | | | |4 | |Pass 3/Merit 2 | | | | |5 | |Pass 4/Merit 3 | | | | |6 | |Pass 5/Distinction 1 | | | | |7 | How this unit works: You will be working in a small team (chosen by your tutor) throughout the unit. You will come up with a business idea together. Each team will occasionally be partnered with another group who will be known as your ‘critical friend team’. You will exchange ideas and feedback with them. • Your group will pitch the business idea to a panel who will decide whether to accept your idea, and who will also give you some advice and guidance • You will produce a report on your target market ...

Words: 1050 - Pages: 5

Premium Essay

Check Point Week 3 Fin 200

...Check Point Financial Forecasting November 12, 2012 The most comprehensive means of financial forecasting is to develop a series of pro forma, or projected, financial statements. Financial forecast is about the pro-forma income statement, cash budget, and pro-forma balance sheet. The statements are often required by bankers and other lenders as a guide for the future. A brand new company needs to have sales projection plan, production plan, and have a pro forma income statement because it is a new business, so it would not have any prior financial reports. If there was a new business that I would trying to open, I would have to know, how much money products are going to cost, how much revenue. I would need to make and what is expected of the business. Family owned company, would need the same thing. It is still treated like a brand new company because you still need financial reports, which are production plan, cash balance and sales projections to get the banks to finance and to know how the bill are going to be paid. A long-standing corporation is a little different because they have been there longer and there are more financial statements. There are pro-forma income statements, cash budget, and other budgets used together equal pro-forma balance sheet are used by business small and large to obtain lending, set production levels, forecast sales, and forecast profits. There is an end budget plan because the business has been there longer, than the other...

Words: 275 - Pages: 2

Premium Essay

American Barrick Case

...Introduction Managing the risk of changing prices of gold is central to the business strategy of American Barrick Resources Corp., one of North America's largest and most successful gold-mining firms. The case contrasts this firm's hedging policies with those of its rivals that do not hedge and details the wide range of hedging products (gold loans, forwards, options, and spot deferred contracts) used to manage price risk. In 1992 the management of American Barrick is pleasantly surprised by unexpected new gold finds, but this new production places demands on the firm's hedging program and tests the firm's commitment to hedging when prices of gold and of many hedging vehicles are unattractive. The gold mining industry has been heavily impacted by the fluctuating gold prices and continuously rising operating costs. Hedging gold prices has become important to ensure financial stability in a sector where mines are unprofitable due to high volatility. Through this case we question the value created by hedging and analyse various instruments to decide upon the best available instrument to Barrick. In this document we explore: 1. Popular theories of hedging and focus on hedging in the gold industry. 2. Analyse features and risk of the gold hedging program at Barrick. 3. Analyse characteristics of Barrick’s gold hedging program. In this document we conclude that value of hedging gold prices creates value for shareholders especially when other firms remain exposed. ...

Words: 929 - Pages: 4

Premium Essay

Jct Task 1

...Financial Performance | -73.50 | 211.50 | 8.54 | 0.41 | Market Performance | 0.00 | 0.65 | 0.10 | 0.39 | Marketing Effectiveness | 0.00 | 0.82 | 0.20 | 0.60 | Investment in Future | 0.00 | 468.30 | 1.01 | 2.73 | Wealth | -2.12 | 5.21 | 0.41 | 0.78 | Human Resource Management | 0.00 | 0.82 | 0.21 | 0.70 | Asset Management | 0.00 | 2.10 | 0.33 | 1.30 | Manufacturing Productivity | 0.00 | 1.00 | 0.22 | 0.49 | Financial Risk | 0.00 | 1.00 | 0.27 | 0.99 | A2. B1 Until Quarter four I did not fully grasp the purpose of the Pro forma statements. I did not understand that the pro-forma was a projection of your decisions that you were making in the current quarter. Had I closely analyzed my Pro forma statement in quarter two I would have seen that I had set my demand for my sales team at zero and overspent in production. My revenue was not enough to cover the cost of production and overhead. Just by doing the simple math using my Pro-forma sheet I could have quickly assessed that the Revenues of +$990,900 would not cover the Cost of production-$576,338 and an excess capacity cost of -$491,524. Q1 my largest investment was in $470,000 in the sales office. I chose to open offices in Tokyo and New York since the market research showed this would be the best investment for my targeted segments Traveler and Mercedes. I invested $120,000 in market research, which was a very important resource throughout the simulation I wanted make sure I didn’t overspend during the first quarter...

Words: 2849 - Pages: 12

Premium Essay

Tire City

...Professor Crocker H. Liu   | Financial Management, Spring 2000 Tire City Case Frequently Asked Questions | | Note: What I'm trying to make you do is THINK! To read things carefully. To make judgements for yourself without your parents/teachers telling you what to do.  This is an INDIVIDUAL project and therefore, anyone who cheats will be given an F in the course. Marine Corp. slogan: The weak quit when they experience pain, the strong quit only when the mission is accomplished. Hawaiian: ho'oikaika Collaborating with Others: * I would like to know if we can work on the case with another student to make things a bit easier and more productive, but still hand in separate copies. If you wish to discuss the case with another student that's fine. However, if you are "borrowing his spreadsheet" and modifying it slightly and/or "lifting his analysis" but putting it in your own words the answer is NO!!  It's always easier to work in a group but there is too much free ridership. I HATE remoras (a tiny fish that gets a free ride and free eats but sticking to the belly of a shark). Also, you already know the grade you'll be getting if your report and spreadsheet resemble another student's. I don't make idle threats. In Class Example: * I was wondering whether you were going to post a completed version of the Financial Planning Spreadsheet on the net. As far as posting a completed version of the Financial Planning Spreadsheet on the net, it is already in your Financial...

Words: 3725 - Pages: 15

Premium Essay

Snapple Case

...Snapple – The best stuff on earth Snapple was founded in 1972 East Meadow NY as Unadulterated Food Products. It had a huge growth spurt with case sales doubling in 1990. Sales reached $516Mand had a return of 195.8%. Quaker Oats & its Strategy Quaker Oats is an American food conglomerate. The story of Quaker Oats’ success is one of a company led by a strong management effectively growing in the face of increasing competition and economic cycles through internal and inorganic growth. Its non-beverage businesses were growing only at 1% in real terms. It had a 10% growth target set, and that target was accomplished through acquisition strategy. To maintain this growth rate the management felt that Snapple presented highly compatible product offering. Overall, the company has used a growth through acquisition strategy and diversification. Diversity is necessary to secure the whole company’s survival. In addition, Quaker Oats thought they had the resources to make Snapple expand internationally. Gatorade Acquisition - A Huge Success Purchase of Gatorade in 1983 (as part of the Stokely-Van Camp purchase) catapulted Quaker to the top of an untapped beverage segment that, to this day, dominates 80% of the market. This deal was vital to Quaker’s long-term success. The company attributed success to its global sales and marketing team. Quaker acquired Gatorade in 1983 for $238M. Since it experienced a 22% compound growth rate with US Sales going from $122M in 1984 to $1.2B...

Words: 781 - Pages: 4

Premium Essay

Financial Acct.

...and general staffing plan. I will also provide a rationale for my plan, (b) the form of my business and the benefits it offers my particular business, and (c) a chart of accounts specific to my business, including a rationale as to the selection of each account, the sources of those resources (liabilities and equity), the sources of revenue and expenditures that I expect to incur to earn those revenues. I will build a detailed chart that includes business units, divisions, product lines, etc.) Next, I will analyze whether I will be required to use GAAP or IFRS accounting methods and how the IFRS/ GAAP convergence will impact my business. I will then seek ways to incorporate any changes into my books and records. Then, I will prepare a pro form balance sheet and an income statement providing the assumptions made and support for these valuations. Fourthly, First Steps Educational Program, I will recommend two...

Words: 2649 - Pages: 11

Free Essay

Weatherfield Limited Trades as the Private Clinic (Tpc)

...Weatherfield Limited trades as The Private Clinic (TPC), one of the longest established private hospitals in the city.TPC has 220 beds in addition to a well established Daycare and Outpatient clinic, generating annual revenues in excess of €60 million per annum.TPC primarily bills the main health insurer in the country, as well as three smaller other healthcare insurers who represent just 5% of the total billings to the insurers. TPC also has a small number of private uninsured patients, many of them people from outside the country. TPC bill their insurer customers as soon as the bills are ready to submit, with all medical details and doctor sign offs in place, and the insurers pay twice a month, with a very detailed remittance advice specifying which claims have been paid (and to what extent, and which claims have been cut in part, rejected in full or deferred seeking further information or details). Approximately 90% of claims by number (but slightly less by value) are paid on time by the insurers (many of them at an agreed fixed price for the more typical procedures), but once a claim has been queried or rejected it can take up to nine months or more to be resolved and paid. The insurers will pend, query or reject claims for a variety of reasons, quite typically because the person is no longer a valid insured member but also because the insurers believe the treatment that the member has received was excessive or unjustified and thus unduly expensive for the insurer. TPC...

Words: 1752 - Pages: 8

Premium Essay

Forecasting

...develop a series of pro forma, or projected, financial statements. Based on the projected statements, any firm is able to estimate its future level of Receivables inventory, payables, and other corporate accounts as well as its anticipated profits and borrowing requirements. A brand new company needs to have a sales projection plan, production plan, to put together a pro forma income statement a new company doesn’t have a prior balance sheet, a income statement, cash balance sheet and other budgets plans would be used to secure operating capital and loans from the bank. I as a new company would need to know how much product we need to make, how much each item cost to make, and how much revenue is expected. A family owned company is in the same boat, sales projection, production plan, cash balance and any other plans are needed in this situation. I really don’t see any difference in this situation then a new business. Knowing a family business has a sales plan and budget sheets, is necessary to get lending from the bank and for planning on how to pay personal monthly bills. A long standing company is no different, and then the previous two companies otherwise it would be long standing. Pro forma income statements, cash budget, and other budgets used together equal a pro forma balance sheet are used by business small and large to obtain lending, set production levels, forecast sales, and forecast profits. What financial forecasting is looking at is the pro forma balance sheet this...

Words: 328 - Pages: 2

Premium Essay

Mci Case Analysis

...operating margins shrink in an attempt to acquire 20% market share by 1990. To accomplish this, MCI will need to infuse huge capitals into their business. As per the pro forma statements, MCI would need significant amounts of capital to finance their plans. The figures range from $890 million in 1984 to $2.76 billion in 1987. Looking back at history, MCI has been known for issuing stock and debentures/convertible debentures. To finance their forecasts, MCI will begin by selling $481 million in common stock in 1984 the same way it did in the past. The share price is currently $47 per share and MCI needs to capitalize on the high value while it can. From 1985 to 1989, MCI will sell convertible debentures. A Convertible debenture is a type of loan issued by a company that can be converted into stock by the holder and, under certain circumstances, the issuer of the bond. The debentures allow investors to turn them into stock while at the same time allow MCI to issue more debt. Thus, each year from 1985 to 1989, MCI can take on more debt while converting older ones. The additional cash will provide for MCI’s growth plans and allow them to compete in a dynamic market. Pro Forma Statements Pro Forma statements are helpful in estimating future inflows and outflows. In any growing company, pro forma statements are vital in constructing future plans for growth. For MCI, we made assumptions based off growth in the case book. Also, we assumed that the economy was going...

Words: 926 - Pages: 4

Premium Essay

Analyzing Proforma

...Pro Forma Statements are “financial statements that a company prepares to consider the effects of potential activity” (Pro Forma Statement, 2013). It is a financial statement showing the forecast or projected operating results and balance sheet, as in pro forma income statements, balance sheets, and statements of cash flows (Pro Forma Statement, 2013).XYZ Company, Inc. is looking to expand their organization in the next five years. The following paper will review XYZ Company’s five-year financial plan to expand their organization. The pro forma income statement for XYZ Company, Inc. is a five-year projection that accounts for a 10% increase in gross sales each of the five-years. The projections for XYZ Company, Inc. show that the break-even point will occur in 2013 when net sales equal $1,747,698, gross profits equal $697,428, and total operating expenses equal $285,850. In 2014 the break-even point will equal $767,170.80 gross profits,$1,922,467.80 net sales, and $288,370.17 total operating expenses. In 2016 equal$2,326,186.04 net sales, $914,822.99 gross sales, and $349,451.05 total operating expense. In 2018 net sales will equal $5,140,871.14, gross sales equal $205,120,758.49and total operating expenses equal $430,386.70.In order for XYZ Company, Inc. to expand they need to increase current assets by$10,000. This is to increase the likelihood of needed finance. The expansion is costing$250,000 meaning the organization will need to utilize $175,000 in other forms of equity...

Words: 514 - Pages: 3