Analyzing Pro Forma Statements Essay

Total Length: 919 words ( 3 double-spaced pages)

Total Sources: 2

Page 1 of 3

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

1,747,698

1,922,414

2,114,656

2,326,121

2,558,733

2,814,607

Cost of sales

60.00%

1,050,270

1,155,297

1,270,827

1,397,909

1,537,700

1,691,470

Gross profit

697,428

767,117

843,829

928,212

1,021,033

1,123,136

Selling expenses

7.14%

125,000

137,480

151,228

166,351

182,986

201,285

Operating expenses

16.33%.....

Show More ⇣


     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Analyzing Pro Forma Statements" (2013, September 16) Retrieved May 17, 2024, from
https://www.aceyourpaper.com/essays/analyzing-pro-forma-statements-96465

Latest MLA Format (8th edition)

Copy Reference
"Analyzing Pro Forma Statements" 16 September 2013. Web.17 May. 2024. <
https://www.aceyourpaper.com/essays/analyzing-pro-forma-statements-96465>

Latest Chicago Format (16th edition)

Copy Reference
"Analyzing Pro Forma Statements", 16 September 2013, Accessed.17 May. 2024,
https://www.aceyourpaper.com/essays/analyzing-pro-forma-statements-96465