Verified Document

Analyzing Pro Forma Statements Essay

Accounting Pro Forma Forecasts for XYZ Company

XYZ Company wishes to increase sales. There are different strategies which are available. One of the most straightforward approaches to increase sales is to increase the marketing budget with the aim of increasing total sales. As long as the firm has sufficient capacity for the increase, there will not be any need for capital investment. However, as production and sales increase, many other costs will increase; these will include the cost of the goods sold including the materials used, labor and commissions paid. The indirect and overhead costs will also increase.

When assessing the profit and loss forecasts, the first stage is to assess the impact that the change is likely to have on sales. In this caser it is assumed that a 10% increase in the marketing budget will increase sales by 10%. Most of the direct and indirect costs are then calculated so that they make up the same percentage of sales as in the current year. However, this approach is not suitable for all items. Interest is a proportion of the outstanding debt in any year. In the current year this is 9.1%, so it is assumed that the interest rate paid remains the same on a decreasing balance. The payments due in the following 12 months are given, so the long-term debt is reduced by this amount each year (assuming level payments). There have also been some assumptions regarding the depreciation and amortization, the fixed assets are reduced by level of depreciation each year, and when an asset is fully deprecated it disappears off the deprecation total. It is also assumed that amortization being taken off assets included in the property category. It is assumed all deprecation is on a straight line basis. Tax is assessed as 45% on the per tax profit. The net profit is carried over as retained earnings.

The pro forma for the profit and loss account is presented below.

Figure 1; Pro forma profit and loss forecast

Current

Forecast

Profit and loss

Percentage of sales xx0

XX1

XX2

XX3

XX4

XX5

Sales

1,750,450

1,925,495

2,118,045

2,329,849

2,562,834

2,819,117

Returns and allowances

0.16%

2,752

3,081

3,389

3,728

4,101

4,511

Net sales

However, some assumptions have to be made. The retained earnings are included in the equity, but this also has to be accounted for as an asset or a liability (Harrison et al., 2012). In most cases the money would be out to work, but in this case we are assuming that it is held as cash, so the cash balance increases significantly. As there is no forecast capital investment, the value of the capital assets gradually decreases, and as there is no new loan taken out the debt also decreases. The items on the…

Sources used in this document:
References

Baye Michael, (2007), Managerial Economics and Business Strategy, McGraw-Hill/Irwin

Harrison Jr. Walter T; Horngren, Charles T; C. Thomas, William R. (2012), Financial Accounting, Prentice Hall
Cite this Document:
Copy Bibliography Citation

Related Documents

Analyzing Business Plan for Day Night Care Center
Words: 2479 Length: 7 Document Type: Business Plan

Business Plan for Day-Night Care Center Thomson Hall is a startup business that provides day and night care services to New Hampshire, Manchester. This middle-sized child care center aims to serve children who are from six months up to six years of age. This facility is not a babysitting institution and ensures the children being taken care of are engaged at all times, and taught new skills and talents every day.

Wal-Mart: Financial Statement Analysis WAL-MART Financial Statement...
Words: 3639 Length: 13 Document Type: Essay

Wal-Mart: Financial Statement Analysis WAL-MART FINANCIAL STATEMENT ANALYSIS Company Description Wal-Mart Stores Inc. (WMT) is a world largest grocery chain and retail stores. The company operates 8000 stores across three business segments which include apparel, groceries, electronics and small appliances. While the company operates globally, half of the company stores are located in the United States. To complete in the international markets, Wal-Mart also operates its business through subsidiaries in Canada, Argentina, China,

Halliburton Management Analysis in Analyzing
Words: 1365 Length: 4 Document Type: Thesis

Today Halliburton must address transparency and compliance to the U.S. Government, the Securities and Exchange Commission (SEC) in accordance with the Sarbanes-Oxley Act, and also the shareholders. This has added cost and time constraints to their strategic planning process that could potentially cost them incremental business if they were able to respond to the market faster without having to contend with compliance initiatives first. Ethics Another aspect of the strategic planning

Owner's Equity Statement Is a
Words: 549 Length: 2 Document Type: Essay

It helps a company understand its capabilities and plan for future budgeting strategies. In order to understand the cash flow, one must be able to conduct appropriate forecasting through thorough cash flow projections. These are done through a number of ways. One is by examining a company's receipts and disbursements directly. This is appropriate for short-term forecasting, normally of about 30 days. Additionally, there is adjusted net income, where

Business Plan Business Financial Plan for Sweet
Words: 1625 Length: 6 Document Type: Essay

Business Plan Business Financial Plan for Sweet Tooth Treats Baking has always been a major part of my family life, and for generations there has been infamous cookie recipes past down from one cook to the next. Every holiday season, my cookies are notorious for being the best any gift receivers have ever had. Finally, I believe it is time to make my baking hobby and actual money making enterprise. I know

Shuffle Master Is a Little Known Equity,
Words: 1404 Length: 5 Document Type: Term Paper

Shuffle master is a little known equity, as evidenced by the fact that it is 95% owned by institutional investors such as pension funds and mutual funds. It is what would be considered a small cap stock, with a capitalization of a mere 500 million dollars. The company is unique in that it maintains almost no debt and maintains no long-term debt. With a beta of.659, Shuffle Master has less

Sign Up for Unlimited Study Help

Our semester plans gives you unlimited, unrestricted access to our entire library of resources —writing tools, guides, example essays, tutorials, class notes, and more.

Get Started Now