Pro Forma Homework Handout S13

In: Business and Management

Submitted By brothernathan
Words 353
Pages 2
Pro-forma Homework Handout
Spring 2013
Allen Products, Inc. wants to project their earnings and income for 2012. Allen’s income statement for the most recent year follows: Allen Products Inc. Income Statement | For the Year Ended December 31, 2011 | Sales Revenue | $97,500 | Less: Cost of Goods Sold | 41,875 | Gross Profits (Margin) | $55,625 | Less: Operating Expenses | 24,375 | Operating Profits (Margin) (EBIT) | $31,250 | Less: Interest Expense | 3,000 | Net profits before tax (EBT) | $28,250 | Less: Taxes (rate = 35%) | 9,888 | Net Profits after taxes (EAT, net income, net margin) | $18,362 |

Use the percent of sales method, the income statement for December 31, 2011, and the sales revenue estimate of $107,250 to develop a pro forma income statement for the coming year. Allen Products plans to pay a 50% dividend in 2012.

Allen Products Inc. Income Statement | 2012 | Sales Revenue | $107,250 | Less: Cost of Goods Sold | 46,062.5 | Gross Profits (Margin) | 61,187.5 | Less: Operating Expenses | 26,812.5 | Operating Profits (Margin) (EBIT) | 34,375 | Less: Interest Expense | 3000 | Net profits before tax (EBT) | 31,375 | Less: Taxes (rate = 35%) | 10,981.25 | Net Profits after taxes (EAT, net income, net margin) | 20,393.75 | Dividends | 10,196.875 | To Retained Earnings | 10,196.875 |

* Allen Products has the following balance sheet for December 31, 2011: Current assets | $ 5,000 | Accounts payable | $ 1,000 | Net fixed assets | 10,000 | Accruals | 1,000 | | | Long-term debt | 5,000 | | | Common equity | 6,000 | | | Retained Earnings | 2,000 | Total assets | $15,000 | Total | $15,000 | Fixed and current assets are fully utilized,…...

Similar Documents

Week+3-Assignment-Pro+Forma+Statements

...Save Cancel Bottom of Form ------------------------------------------------- Top of Form * ------------------------------------------------- Word Count: words * ------------------------------------------------- Percentage: % or Cancel Bottom of Form * preferences Document Viewer Turnitin Originality Report * Processed on: 22-Dec-2012 10:11 AM CST * ID: 294959697 * Word Count: 227 * Submitted: 1 Week+3-Assignment-Pro+Forma+Statements[1] By Robert Oxendine   Similarity Index 41% What's this? Similarity by Source Internet Sources: 41% Publications: 0% Student Papers: N/A include quoted include bibliography exclude small matches download refresh print mode: 18% match (Internet from 8/2/10) http://www.jiskha.com 9% match (Internet from 4/3/10) http://sprott.carleton.ca 8% match (Internet from 2/18/12) http://www.coursehero.com 6% match (Internet from 9/30/10) http://studentoffortune.com ------------------------------------------------- Week 3-Assignment-Pro Forma Statements The Landis Corporation A.) ( ) Spontaneous Assets = 5% + 15% + 25% + 40% = 85% Spontaneous Liabilities = 15% + 10% = 25% RNF = ( ) ( ) = .85 ($15 million) - .25 ($15 million) - .06 ($115) (1 -.5) = $12.75 million - $3.75 million - $3.45 million = $5.55 million B.) An increase in Landis Corporation’s payout ratio will reduce the company’s retained earnings and profit margin, and therefore will increase its need for external funding. A......

Words: 630 - Pages: 3

Pro Forma Statements

...Quinniece Garrett Individual: Pro Forma Statements Comprehensive Problem: Landis Corporation The Landis Corporation had 2008 sales of $100 million. The balance sheet items that vary directly with sales and the profit margin are as follows: Percent Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5% Accounts receivable. . . . . . . . . . . . . . . . . . . . . . 15 Inventory . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25 Net fixed assets . . . . . . . . . . . . . . . . . . . . . . . . . 40 Accounts payable . . . . . . . . . . . . . . . . . . . . . . . 15 Accruals . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 Profit margin after taxes . . . . . . . . . . . . . . . . . . 6% The dividend payout rate is 50 percent of earnings, and the balance in retained earnings at the end of 2008 was $33 million. Common stock and the company’s long-term bonds are constant at $10 million and $5 million, respectively. Notes payable are currently $12 million. A- How much additional external capital will be required for next year if sales increase 15 percent? (Assume that the company is already operating at full capacity.) B- What will happen to external fund requirements if Landis Corporation reduces the payout ratio, grows at a slower rate, or suffers a decline in its profit margin? Discuss each of these separately. C- Prepare a pro forma balance sheet for 2009 assuming that any external funds......

Words: 396 - Pages: 2

Analyzing Pro Forma Statements

...Analyzing Pro Forma Statements FIN/571 Kalena Armstrong-Henry November 4, 2013 Analyzing Pro Forma Statements General and financial managers can both benefit from forecasting financial statements. Proforma statements assist financial managers to plan accordingly, in terms of the company’s financial needs. How much financing is needed and when it is needed can be determined by acquiring an estimate of the company’s future balance sheet accounts and income statement. Hence, the purpose of the Proforma analysis is to forecast the company’s financial statements under a particular condition (Parrino et al., 2012). Subsequently, total assets must equate the sum of total liabilities and owner’s equity; otherwise the manager must consider corrective action (Parrino et al., 2012). The Proforma analysis has been proven to be instrumental for general managers in the planning of inventory and employment intensities; particularly problems solving issues. During the developing stages of the forecasting a manager is permitted to analyze the results; thus, identifying potential “hot spots” and handling the issues accordingly. Dealing with “hot spots” with ample time to spare during the forecasting stage is vital to any financial manager. When performing a Proforma Analysis the financial manager can handle forthcoming issues weeks or months in advance; thus, providing the manager ample time to avoid a potential real-time calamity. Subsequently, the manager will gain the ability......

Words: 1327 - Pages: 6

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

Pro Forma

...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......

Words: 1472 - Pages: 6

Fin 571 Pro Forma Statement

...Per forma Statements of XYZ Company INC We assume that there is an increase in the sales due to the introduction of new product and increase in the production capacity. With increased sale, we will be acquiring fixed assets with the excess cash and will be taking loan as follows: XYZ Company INC Performa Income Statement Income Statement | 20XX | % Ratio to the Sales | 20X1 | 20X2 | 20X3 | 20X4 | 20X5 | Revenue (net) | $1,747,698 | 100.0% | $2,097,238 | $2,306,961 | $2,537,657 | $2,791,423 | $3,070,566 | Cost of revenue | $1,050,270 | 60.1% | $1,260,324 | $1,386,356 | $1,524,992  | $1,677,491 | $1,845,240 | Gross Profit | $697,428 | 39.9% | $836,914 | $920,605 | $1,012,665 | $1,113,932 | $1,225,325 | Selling expense | $125,000 | 7.2% | $150,000 | $165,000 | $181,500 | $199,650 | $219,615 | Operating expenses | $285,850 | 16.4% | $343,020 | $377,322 | $415,054 | $456,560 | $502,216 | Operating profit | $286,578 | 16.4% | $343,894 | $378,283 | $416,111 | $457,722 | $503,495 | Other income (expense), net | $24,150 | 1.4% | $28,980 | $31,878 | $35,066 | $38,572 | $42,430 | Pretax profit | $262,428 | 15.0% | $314,914 | $346,405 | $381,045 | $419,150 | $461,065 | Income Tax allowance | $118,093 | 6.8% | $141,712 | $155,883 | $171,471 | $188,618 | $207,480 | Net Profit | $144,335 | 8.3% | $173,202 | $190,522 | $209,574 | $230,532 | $253,585 | Revenue will increase by twice in year 20X1, after......

Words: 722 - Pages: 3

Pro Forma Analysis Cash Flow Forecasting

...Pro forma analysis cash flow forecasting Apartment Investment Case Study Scenario An investor is considering buying an apartment building with 140 units offered for sale at $16,500,000. The subject apartment building has the following unit mix: Additionally, the following assumptions are also being made by the investor in order to construct a 5-year cash flow pro forma: Vacancy and Credit Loss In the current market, vacancy and credit losses are running at 9%. Due to the improving market conditions as well as the investor’s prior experience leasing and operating multifamily buildings, it’s expected that vacancy will steadily decline over the next 5 years to 5%. Potential Rental Income Potential rental income is based on the above unit mix. The 1-bedroom and studio rental rates are expected to increase at 1% annually. The 2-bedroom units are expected to increase at 2% annually. Financing After a preliminary discussion with a relationship manager at a local bank it’s determined that a loan can be extended based on the lesser of a 1.25x debt service coverage ratio or 80% loan to value. Additionally, assuming the underwriting process doesn’t reveal any red flags, it’s expected that the loan will be based on a 20 year amortization and a 6% interest rate. Operating Expenses The following table breaks out historical operating expenses for the property as well as projected increases over the holding period. Reserves for Replacement In addition to the above operating......

Words: 1486 - Pages: 6

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......

Words: 382 - Pages: 2

Analyzing Pro Forma Statements Paper

... Analyzing Pro Forma Statements Paper Gregory Curry FIN/571 April 22, 2015 CRISTINA MARINE Analyzing Pro Forma Statements Analyzing Pro Forma Statements can be used internally or externally to determine how financially stable a company is whether International or within the USA, ratios play a key role in determining how a company is doing financially either for the good or the bad or indifferent. I we will use three common ratios to determine how financially stable from how Shimizu International and Lexmark US based company balance sheets with their business information is doing these last three years. Balance sheets from Shimizu International and Lexmark, companies no matter the industry no company wants a current ratio less than one because this suggests that the company has more liabilities than assets meaning that in the short run they will be more likely not able to pay their debts. This is why “the current ratio is a popular financial ratio used to test a company's liquidity also referred to as its current or working capital position by deriving the proportion of current assets available to cover current liabilities” (Richard Loth, 2015). The figures for both Shimizu International and Lexmark companies will display their current ratios from 2012, 2013 and 2014. It's takes time to convert a company's...

Words: 851 - Pages: 4

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,...

Words: 628 - Pages: 3

Analyzing Pro Forma Statement

...Analyzing Pro Forma Statements Kaleah S. Daniels FIN/571 Analyzing Pro Forma Statements Pro forma statements are prepared to forecast financial results that are based on anticipated future projects or events. It is design to show projection of revenues, cash flows deducting the estimated expenses or costs for a particular business plan. Pro forma statements assist financial managers to plan accordingly, in terms of the company’s financial needs. How much financing is needed and when it is needed can be determined by acquiring an estimate of the company’s future balance sheet accounts and income statement. Hence, the purpose of the Pro forma analysis is to forecast the company’s financial statements under a particular condition (Parrino et al., 2012). XYZ Company, INC. is planning for business expansion in the coming years. This paper will discuss and analyze pro forma statements of five year projections created. The company’s income statement displays that the break in the current year occurred when; “Net sales equals $1,747,698, Gross profit equals $697,428 and Total operating expenses equals $285,850” (UOP, 2014). XYZ’s “management expects sales to increase by 10 percent for the coming year. Assuming that the financial statement accounts vary directly with changes in sales and that management has no financing plan at this time” (Parrino, 2012, pg. 613). Using the data from the current statement (income & balance sheet) we are able to calculate, 1)......

Words: 670 - Pages: 3

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......

Words: 297 - Pages: 2

Fin 571 Week 4 – Individual Assignment – Analyzing Pro Forma Statements

...FIN 571 Week 4 – Individual Assignment – Analyzing Pro Forma Statements Click Link Below To Buy: http://hwcampus.com/shop/fin-571-week-4-individual-assignment-wileyplus-quiz/ Or Visit www.hwcampus.com FIN 571 Week 4 Individual Assignment WileyPlus Quiz (1) Present value: Tommie Harris is considering an investment that pays 6.5 percent annually. How much must he invest today such that he will have $25,000 in seven years? (Round to the nearest dollar.) (2) PV of multiple cash flows: Jack Stuart has loaned money to his brother at an interest rate of 5.75 percent. He expects to receive $625, $650, $700, and $800 at the end of the next four years as complete repayment of the loan with interest. How much did he loan out to his brother? (Round to the nearest dollar.) (3) PV of multiple cash flows: Hassan Ali has made an investment that will pay him $11,455, $16,376, and $19,812 at the end of the next three years. His investment was to fetch him a return of 14 percent. What is the present value of these cash flows? (Round to the nearest dollar.) (4) PV of multiple cash flows: Pam Gregg is expecting cash flows of $50,000, $75,000, $125,000, and $250,000 from an inheritance over the next four years. If she can earn 11 percent on any investment that she makes, what is the present value of her inheritance? (Round to the nearest dollar.) (5) Present value of an annuity: Transit Insurance Company has made an investment in another company that will guarantee it a cash......

Words: 536 - Pages: 3

Fin 571 Week 4 – Individual Assignment – Analyzing Pro Forma Statements

...FIN 571 Week 4 – Individual Assignment – Analyzing Pro Forma Statements Click Link Below To Buy: http://hwcampus.com/shop/fin-571-week-4-individual-assignment-wileyplus-quiz/ Or Visit www.hwcampus.com FIN 571 Week 4 Individual Assignment WileyPlus Quiz (1) Present value: Tommie Harris is considering an investment that pays 6.5 percent annually. How much must he invest today such that he will have $25,000 in seven years? (Round to the nearest dollar.) (2) PV of multiple cash flows: Jack Stuart has loaned money to his brother at an interest rate of 5.75 percent. He expects to receive $625, $650, $700, and $800 at the end of the next four years as complete repayment of the loan with interest. How much did he loan out to his brother? (Round to the nearest dollar.) (3) PV of multiple cash flows: Hassan Ali has made an investment that will pay him $11,455, $16,376, and $19,812 at the end of the next three years. His investment was to fetch him a return of 14 percent. What is the present value of these cash flows? (Round to the nearest dollar.) (4) PV of multiple cash flows: Pam Gregg is expecting cash flows of $50,000, $75,000, $125,000, and $250,000 from an inheritance over the next four years. If she can earn 11 percent on any investment that she makes, what is the present value of her inheritance? (Round to the nearest dollar.) (5) Present value of an annuity: Transit Insurance Company has made an investment in another company that will guarantee it a cash......

Words: 536 - Pages: 3

Pro Forma Financial Statements for Walt Disney Co.

...#14- Walt Disney Company: Pro Forma financial statements: income statement, balance sheet, cash flow statement, and applicable financial ratios with a baseline year and three years into the future. Income Statement 12/31/2014 12/31/2015 Percent Change Revenues $48,813,000 $52,465,000 1 7.48% Cost of Goods Sold 26,420,000 28,364,000 1 7.36% Gross Profit 22,393,000 24,101,000 1 7.63% Operating Expenses 37,378,000 39,294,000 1 5.13% EBIT (14,985,000) (15,193,000) 1 1.39% Interest Expense - - ####### #VALUE! EBT 12,246,000 13,868,000 1 13.25% Tax 4,242,000 5,016,000 1 18.25% Non-Recurring Events 140,000 53,000 -1 -62.14% Net Income 8,144,000 8,905,000 1 9.34% Balance Sheet 12/31/2014 12/31/2015 Percent Change Assets Cash and Equivalents $3,421,000 $4,269,000 1 25% Accounts Receivable 8,319,000 8,786,000 1 6% Inventory 1,574,000 1,571,000 -1 0% Other Current Assets 1,855,000 2,132,000 1 15% Total Current Assets 15,169,000 16,758,000 1 10% Property Plant & Equipment 47,054,000 50,023,000 1 6% Goodwill 27,881,000 27,826,000 -1 0% Intangibles 12,759,000 13,355,000 1 5% Other Long-Term Assets 857,000 832,000 -1 -3% Total Assets 84,186,000 88,182,000 1 5% Liabilities Accounts Payable 5,371,000 5,504,000 1 2% Other Current Liabilities 3,988,000 4,470,000 1 12% Total Current Liabilities 13,292,000 16,334,000 1 23% Long-Term Debt 12...

Words: 870 - Pages: 4