Premium Essay

Analyzing Proforma

In:

Submitted By Omgthis
Words 514
Pages 3
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 to collateral the balance. XYZ Company, Inc. does not have a parent company or partner to assist in funding or providing a loan so XYZ Company will use a small business loan through a bank. Financial information will be used to see where deficits lie and to correct those deficits. For example, if deficits were showing more products being purchased than sold this would need to be corrected. A

Similar Documents

Premium Essay

Analyzing Proforma

...Analyzing Pro Forma Statements FIN 571 September 11, 2014 Introduction This paper is the analysis of pro forma financial statements. Pro forma statements are forecasted or projected financial statements as a result of financial planning. The financial statements are based on the inputs and assumptions such as percent of sales model in which most of the entries vary directly with the level of sales. The attached excel spreadsheet includes pro forma statements for the next five years. This company decided to invest in the purchase of new equipment to help increase sales. The resulting projections are the focus of this paper. Analysis of pro forma statements will determine if the company requires any external financing to support its planned initiatives. Assumptions supporting each line for forecasted statements This paper covers a five year plan with the basic assumptions for the pro forma statements that the equipment purchase initiative will increase sales by 12% for the first two years, and then 5% for the next three years. The cost of sales including purchases, production and labor, and ending inventory will vary with sales, while beginning inventory comes from prior year ending inventory. Depreciation will increase by $40K for the additional equipment in year one. Fixed assets will not vary from year to year, except for $200K increase in equipment expected in the first year to support sales growth. Retained earnings for the prior year comes from previous year, and...

Words: 696 - Pages: 3

Premium Essay

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

Words: 1327 - Pages: 6

Premium Essay

Jet2 Task 2

...Competition Bikes, Inc. Summary Report II S.J. Abke Western Governor’s University Table of Contents Preface: Master Budget………………………………………………………………………….3 1. Summary Report for Budgets…………………........................................................................4 2. Concerns of Budget Planning and Profomas…….....................................................................4 3. Evaluation of Flexible Budget and Variances………………...................................................5 4. Identify, Described, Analyze, and Outcomes…………………………………………………6 5. Favorable or Unfavorable…………………………………………………………………..…6 6. Reaction to Changes………………………………………………………………..…………6 7. Results of Budget …………………………………………………………………………….6 8. Corrective Action for Variance Analysis……..........................................................................6 9. Concepts of Management by Exception (MBE).......................................................................7 10. Choosing a Flexible Budget…………………………………………………………………..8 11. Reference Page………………………………..........................................................................9 Competition Bikes, Inc. MASTER BUDGET 1. Management anticipates that the market will improve moderately during the coming year. 2. The Sales forecast is 3510 CarbonLite units in Year 9. 3. No change in this pricing is expected for the coming year. 4. Factory overhead will be has been budgeted at $481,798...

Words: 1883 - Pages: 8

Premium Essay

Supply Chain Task 1

...Task 1 Assessment for Supply Chain Management B. I named my microcomputer company GigaJet. I don’t know if it is true for everyone that opens a business, but I find that naming a business is a very difficult task. The company name is reflective of what I wanted shareholders to feel when they saw and used the product; a microcomputer that has a lot of storage, “Giga”, and is fast and can go anywhere, “Jet”. Within the simulation each business was required to pick two segments to manufacture the microcomputers for. At GigaJet I chose to focus the manufacturing of our products to supply the workhorse and traveler customers. I chose these two segments because they had similar customer needs and wants, as well as a high potential demand. The next step within the simulation was to choose which markets to sell the microcomputers to. I developed a simple spreadsheet to analyze what markets would be the best fit for the company’s long term success. This spreadsheet was developed by multiplying the potential demand in each segment by the price that customers were willing to pay. From the following spreadsheet, I determined that the best markets for GigaJet to sell to were in the North American and European markets. |North America|Europe|Asia|South America|Total| Workhorse|$17,985,000|$19,377,500|$12,410,000|$13,905,000|$63,677,500| Mercedes|$19,288,000|$13,836,000|$16,960,000|$9,424,000|$59,508,000| Traveler|$12,041,600|$8...

Words: 4234 - Pages: 17

Premium Essay

Cases in Financial Management

...CASES IN FINANCIAL MANAGEMENT SYLLABUS FIN 522 Professor James A. Gentry Cases In Financial Management 343M Wohlers Hall Spring Semester 2009 333-7995 2043 BIF j-gentry@uiuc.edu Office Hours: 10:30 a.m. to 11:45 a.m. on Mon. and Wed/. or by Appointment I. Teaching Objectives Financial decision making cases are used to… • Create a highly interactive learning environment; • Learn about the application of financial management and credit analysis concepts; • Discover what you do not know about the practice of financial management; • Show what you have learned; • Highlight the relationships between strategic goals and the creation of firm value; • Develop techniques for interpreting a firm’s financial data and strategic plans; • Enhance your critical thinking and problem solving skills; • Expand your understanding of financial theory and its application; • Improve your listening and cooperative learning skills. II. Learning Promises At the end of this course your will be able to… • Think like a financial manager; • Interpret a company’s financial health by evaluating the performance...

Words: 5389 - Pages: 22

Premium Essay

Busn278 Course Project

...Papa Geo’s Restaurant Budget Proposal For [2014-2019] BUSN-278 [Term] Professor[name] DeVry University ------------------------------------------------- Table of Contents Section | Title | Subsection | Title | Page Number | 1.0 | Executive summary | | | | 2.0 | Sales Forecast | | | | | | 2.1 | Sales Forecast | | | | 2.2 | Methods and Assumptions | | 3.0 | Capital Expenditure Budget | | | | 4.0 | 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 | Appendix 1: [description] | | | | 7.2 | Appendix 2: [description] etc | | * 1.0 Executive Summary 1.0 Executive Summary * Papa Geo’s an Italian restaurant will be a start up business which will be located in Orland, Florida. The restaurant will have strong emphasis on quality and will work on low cost strategy which will help in attracting more and more consumers across the place. Being located in the heart of the city and its value pricing strategy, the company will be able to attract the large junk of consumers. The company will not compete with the established international brands but will make its own image with...

Words: 3910 - Pages: 16

Premium Essay

Butler Lumber Case

...were found to have contributed to the shortage of funds. From the analysis, we were able to conclude that the main reasons for the firm’s insufficient funds were due to its slower collection of accounts receivable, higher costs of goods sold, heavy reliance on debt financing and most importantly a growth rate that is not sustainable. From Exhibit 1 in the Appendix, the current and quick ratios have been declining since 1988; furthermore, the quick ratio is less than 1, which indicates that the firm is deeply reliant on its inventory to meet the payments of its current liabilities. This is a problem since more inventory means more cash tied up in less liquid assets, which decreases the firm’s cash.            Secondly, when analyzing the firm’s profitability, ROA increased by 3% from 1989 to 1990, but this was mainly due to the increase in total asset turnover which increased from 3.03 to 3.23 (Exhibit 1).  Another component of ROA, net profit margin, declined from 1.69% to 1.63% (Exhibit 1). This is indicative of the fact that, asset turnover is higher due to higher sales. However, net profit margin indicates that in addition to the increase in sales, cost of goods sold increased at a greater rate than sales. This is an important factor because both higher sales and higher costs lead to diseconomies of sales, which is...

Words: 964 - Pages: 4

Premium Essay

Strategic Plan

...Final Project SUO BUS 3101 Week 6 Assignment 2 Linda Taylor February 15, 2013 Instructor Donna Whitaker Abstract This paper is a comprehensive strategic plan for a floating fishing pliers manufacturing company that is made using an extrusion process. Included will be a mission statement, a resource needs assessment, business goal, measurable and observable objectives, the hardware, software and facility resource requirement, training resource requirement and a staff development plan, a marketing plan, and an itemized budget. PART I: THE BUSINESS Mission Statement The mission of Floating Pliers Manufacturing Company, (FPMC), is to exceed our customer’s expectations in quality, delivery, and cost through continuous improvement and customer interaction. In 2010, this business began in New Lakes, Wisconsin. After much thought and consideration, it was decided to leave the constraints of working for someone else and to venture into owning and manufacturing our own brand and design of floating fishing pliers. Timothy, who has over 20 years in the fishing industry, attends to purchasing of new equipment, assigns what each extrusion machine will produce daily, and the maintenance and repair schedules. Michele, who has extensive management experience, attends to the financial, office management, tax preparation and also shares responsibility for overall decisions that affect operations. At steady growth since...

Words: 2258 - Pages: 10

Premium Essay

Capital Budgeting

...OUTLINE OF MBA 520 Fall Semester 2008 Business Finance Instructor: Grant McQueen Teaching Assistants: Mark Cherrington & Office: 636 TNRB Christian Hsieh Phone: 422-3017 Office: 324 TNRB Office Hours: MW 2:00 - 3:00 p.m. Phone: 422-6835 e-mail: Office hours: forthcoming Home page: Course Description and Objectives This course introduces basic financial concepts all business managers should understand regardless of functional specialization. Topics include financial analysis and planning, time value of money, valuation, capital budgeting, risk/return trade-offs, cost of capital, and capital structure. The pedagogical approach used is a mixture of lectures and case examples. Cases are often used as a vehicle for discussing the complexities of real-world financial problems. To benefit most from this method of teaching, you will want to come prepared to discuss the cases in detail. By the end of the semester, students should be able to: (1) describe essential characteristics of the finance profession and institutions, (2) be conversant in basic financial jargon, (3) value paper assets (stocks and bonds) and tangible assets (capital budgeting) using the tools of time value of money, including NPV and IRR, (4) explain the various sources of financing, their associated costs, and their advantages and disadvantages, (5) calculate and use financial statements and ratios to analyze a business and create and use pro forma statements for planning...

Words: 2362 - Pages: 10

Premium Essay

Abc Defg

...Course Description and Objectives This course introduces basic financial concepts all business managers should understand regardless of functional specialization. Topics include financial analysis and planning, time value of money, valuation, capital budgeting, risk/return trade-offs, cost of capital, and capital structure. The pedagogical approach used is a mixture of lectures and case examples. Cases are often used as a vehicle for discussing the complexities of real-world financial problems. To benefit most from this method of teaching, you will want to come prepared to discuss the cases in detail. By the end of the semester, students should be able to: (1) describe essential characteristics of the finance profession and institutions, (2) be conversant in basic financial jargon, (3) value paper assets (stocks and bonds) and tangible assets (capital budgeting) using the tools of time value of money, including NPV and IRR, (4) explain the various sources of financing, their associated costs, and their advantages and disadvantages, (5) calculate and use financial statements and ratios to analyze a business and create and use pro forma statements for planning and decision-making purposes, (6) appreciate the complexities international business, and (7) demonstrate team skills by actively participating in group written cases. Course Materials Text: Background readings and problem sets are from Ross, Westerfield and Jordan (RWJ), Fundamentals of Corporate Finance...

Words: 2388 - Pages: 10

Premium Essay

Ndp Case Paper

...In C ategory: Trade C opyright © Tekle S. (ID 584) , a prequalified Trainer from Brentwood, United States Article Stats Added: 16/01/07 787 Words 14119 x Read Any company, before committing its resources to venture in the export business, must carefully assess the advantages and disadvantages of exporting into a new market. While some companies enter the export business unintentionally after receiving order to purchase from foreign buyer that found their product. Others make a deliberate move and conduct thorough research before entering new market. Whether it is unintentional or deliberate move companies need to evaluate and carefully assess the advantages and challenges of exporting before committing resources. In: Trade Using Proforma Invoice Will Help To Increase Your Profit In: Trade Preventing Fraud When Sourcing From Overseas In: Trade Essentials To Export/Import Success In: Trade Approaches to Importing/Exporting 4 more free full-text Whitepapers from Tekle S.:...

Words: 1429 - Pages: 6

Premium Essay

The Capital Budgeting of Capitaland

...the evaluation of two potential mutually exclusive capital investments as well as the objective of these investments for this company. This report also contents the analysis of four main different capital budgeting techniques used in the investments for supporting decision making process. Definition, formula of each technique will be given along with the figure of the investments as well as its advantages and disadvantages. The numeric data (initial investment, cash flows…) used for the calculating process will be disguised by our group. Recommendations and Suggestions will be given based on the analytic figure before having the final decision of which project will be chosen.   1. INTRODUCTION Capital Budgeting is the process of analyzing a company’s investible decisions in which the company determines if the projects are worth pursuing and will yield the most return over an applicable period of time. The investments can be purchasing new machinery, replacement machinery, new plants, new products, or research development projects. Select an effective and profitable investment is one of the most important of the financial management of an organization, moreover, having a suitable choice of investment helps the organization to stay competitive and take advantages over other competitors. Hence, capital budgeting is one of the most important step to evaluate the opportunity before making the final decision of which investment will be chosen. 1.1 CapitaLand Organization 1...

Words: 6799 - Pages: 28

Premium Essay

You Are an Entrepreneur

...Assignment 2: You Are an Entrepreneur Student: Peter M. Burke Instructor: Dr. Muhammad Sumadi ACC557: Financial Accounting November 18, 2012 Introduction When I was about two years old, my grandfather took me on my first of many fishing trips to a small lake near his house. When his grandchildren visited, we all went along with him. He gave each of us our own special fishing poles, and he taught us everything about fishing, from how to set up our poles to how to bait our hooks, and eventually how to clean fish. As I grew older, our fishing trips grew from hour-long visits to a local lake to trips to the coast, where we would go on deep-sea fishing expeditions. He found relaxation and peace in the hobby, and it became my favorite way to relax as well. I have decided that there is no reason that I cannot turn this hobby that I love into a profitable business, and have decided to become a deep sea fishing guide. Type of business The business that I intend to start is a charter fishing boat business. The name of the business will be Blue Water Fishing Guides. I will operate the business out of Islamorada, Florida, a small town located in the Florida Keys. I will start the business with two fishing boats with a total passenger capacity of 6 guest fishermen per boat in addition to a captain. One boat will operate on a daily basis as long as there are at least two customers, with the second boat being in use if the first boat’s capacity is exceeded. There are...

Words: 1993 - Pages: 8

Premium Essay

Finance

...FINC/070 CO PY IBS Center for Management Research Commercial Paper Market in India D O N O T This case was written by Nitya Nand Tripathi, IBS Center for Management Research and D.S. Chary, IBS, Hyderabad. It was compiled from published sources, and is intended to be used as a basis for class discussion rather than to illustrate either effective or ineffective handling of a management situation. 2011, IBS Center for Management Research. All rights reserved. To order copies, call +91-08417-236667/68 or write to IBS Center for Management Research (ICMR), IFHE Campus, Donthanapally, Sankarapally Road, Hyderabad 501 504, Andhra Pradesh, India or email: info@icmrindia.org www.icmrindia.org FINC/070 Commercial Paper Market in India “Volumes of commercial papers will increase because it will be cheaper for companies to raise money through this route rather than loans from banks.”1 - Paritosh Kashyap, www.livemint.com, in March 2010 CO PY “Close to $210 billion have flown into the Indian debt market this calendar year alone. Investment by local banks in commercial paper has surged from Rs 25.188 billion in March 2010 to Rs 37.863 billion in August. Is the moribund Indian debt market finally showing signs of life 18 years after it was opened up to global money?… The current sets of circumstances have been favorable for the Indian bond market.”3 - Abheek Barua, The Economic Times4, November 2010 “CP issuances are going to rise...

Words: 4872 - Pages: 20

Premium Essay

Service Merketing

...CHAPTER - 7 Export procedure and documentation Export business occurs between two independent nations for expanding business there are some rules that have to follow. Accepting orders from abroad the sellers send their products with a traditional system under this rule. In this case the sellers are treated as exporter. There are various persons, government or non government organizations are involved with export business at present. These persons or organizations are divided into two criteria based on their nature and functions. Such as direct and indirect export. The direct exporters send their manufacturing products abroad themselves. Some companies run their export management system by setting dealers in abroad. In export business the intermediaries are treated as indirect exporters. These classes of exporters do not manufacture any product but export. Most of them complete the direct export exporting by buying products from home market after receiving orders. They are known as export merchant. Again many exporters work as a percent agent. Many intermediaries export product by making contract with manufacturers. They seek for foreign buyer on behalf of the exporters and take orders. They are known as manufacturers export agent. These kinds of exporters also take commission from buyers if they get chance. It is not the matter the exporters are treated in which name they have to do business of course under the international rule and regulations....

Words: 10307 - Pages: 42