Business Finance
Business Finance
FINANCE
1
2
BUSINESS FINANCE
MODULE
Learning Competencies
The learner shall be able to illustrate the formula and format for the
preparation of budgets and projected financial statement.
Code: ABM_BF12-IIIc-d-11
1. SALES BUDGET
Sales is the most important financial statement account because almost all other accounts are
affected by it. If you analyze the SCI, the accounts such as the Cost of Sales, Gross Profit,
Operating Expenses and other expenses are based on the sales figure. Higher income tax
expense is also expected with higher sales. The decision to expand production capacity is
based on projected increase in sales. Moreover, if you look at the accounts in the SFP, almost
all of them are also correlated with sales. The amount of cash that the company maintains, its
accounts receivable and inventories, PPE and trade payables are affected by sales.
Given the importance of the sales forecast, the following external and internal factors should
be considered in forecasting sales:
3
EXTERNAL FACTORS INTERNAL FACTORS
4
What will be the implications if sales budget is not correct? If understated,
there can be lost opportunities in the form of forgone sales. If it is too
optimistic, the management may decide to unnecessarily increase capacity or
hire more employees and end up with more inventories.
2. PRODUCTION BUDGET
Production budget is a schedule which provides information regarding the number of units
that should be produced over a given accounting period based on expected sales and targeted
level of ending inventories.
It is computed as follows:
QUARTER YEAR
1 2 3 4
Projected Sales 20,000 22,000 25,000 30,000 97,000
Target Level of
Ending
3,000 3,500 5,000 3,500 3,500
Inventories
Total 23,000 25,500 30,000 33,500 100,500
Less: Beginning
Inventories
2,500 3,000 3,500 5,000 2,500
Required
Production
20,500 22,500 26,500 28,500 98,000
Table 1.1 shows that the required production in the first quarter is 20,500 units. The ending
inventory level of the present quarter will be the beginning inventory level of the next
quarter. The target level of ending inventories of the fourth quarter is the same as that of the
5
year while the beginning inventory of the first quarter is the same as the beginning inventory
for the year.
From the number of units that is expected to be produced, the cost of production can be
estimated especially if the company has developed standard production cost per unit.
3. OPERATING BUDGET
Operations budget refers to the variable and fixed costs needed to run the operations of the
company but are not directly attributable to the generation of sales.
Rent payments
Wages and Salaries of selling and administrative personnel
EXAMPLES
Administrative Costs
Travel and representation expenses
Professional fees
Interest Payments
Tax Payments
3. CASH BUDGET
A cash budget itemizes the projected sources and uses of cash in a future period. This budget
is generally used to estimate whether a company has a sufficient amount of cash to uphold
regular operations. If not, management must find additional funding sources. It can also be
used to determine whether too much of a company’s cash is being spent in unproductive
ways.
If the ending cash balance after payment of all required disbursements (expenses) is less than
the required ending balance, the company needs to borrow additional cash from short term
borrowings to meet its required ending balance. Should the ending cash balance exceed the
company’s minimum cash requirement the next period, the company may be able to repay the
loan plus accrued interest.
5. PROJECTED FINANCIAL STATEMENTS
Projected financial statements is a tool of the company to set an overall goal of what the
company’s performance and position will be for and as of the end of the year. It sets targets
to control and monitor the activities of the company. The following reports may be
forecasted:
6
‣ Projected Statement of Comprehensive Income (SCI)
‣ Projected Statement of Financial Position (SFP)
**Let us use the SCI and SFP of PAPA Company for years ending December 31, 2012-
2016 below to forecast the different financial statements.
PAPA COMPANY
Statement of Comprehensive Income
For the Years Ending December 31, 2012-2016
2016 2015 2014 2013 2012
Net Sales 52,501,085 47,345,223 42,174,283 38,340,257 35,336,643
Cost of Sales 41,954,730 37,988,628 33,980,174 31,439,011 29,329,413
Gross Profit 10,546,355 9,356,595 8,194,109 6,901,246 6,007,230
Operating Expenses 6,497,659 6,196,804 5,393,621 4,926,723 4,505,422
Operating Income 4,048,696 3,159,791 2,800,488 1,974,523 1,501,808
Interest Expense 250,000 250,000 250,000 450,000 300,000
Income before Taxes 3,798,696 2,909,791 2,550,488 1,524,523 1,201,808
Taxes 1,139,609 872,937 765,146 457,357 360,542
Net Income 2,659,087 2,036,854 1,785,342 1,067,166 841,266
PAPA COMPANY
Statement of Financial Position
December 31, 2012-2016
2016 2015 2014 2013 2012
ASSETS
Current Assets
Cash 1,062,527 996,904 777,415 766,805 883,416
Accounts Receivables 2,300,500 1,921,799 1,722,513 1,454,426 1,396,639
Inventories 4,849,304 4,499,998 3,797,668 3,293,030 3,351,933
Other Current Assets 1,050,000 983,746 984,786 735,608 998,763
9,262,331 8,402,447 7,282,382 6,249,869 6,630,751
Noncurrent Assets
Property, Plant, and Equipment, net 12,200,000 11,300,000 9,050,000 9,350,000 9,500,000
Other Noncurrent Assets 835,689 925,681 896,842 876,235 827,490
13,035,689 12,225,681 9,946,842 10,226,235 10,327,490
Total Assets 22,298,020 20,628,128 17,229,224 16,476,104 16,958,241
LIABILITIES AND EQUITY
Current Liabilities
Accounts Payables 5,050,810 4,746,252 4,137,815 3,298,699 2,874,911
Income Taxes Payable 433,051 283,705 267,801 149,441 115,330
Current Portion of Long-term Debt 2,250,000 2,500,000 1,000,000 2,000,000 2,000,000
Other Current Liabilities 85,600 28,700 40,990 30,688 37,890
7,819,461 7,558,657 5,446,606 5,478,828 5,028,131
7
Noncurrent Liabilities
Long-term Debt, Net of Current
Portion 2,000,000 1,250,000 1,000,000 3,000,000
Total Liabilities 9,819,461 8,808,657 5,446,606 6,478,828 8,028,131
Stockholders' Equity
Capital Stock 8,000,000 8,000,000 8,000,000 8,000,000 8,000,000
Retained Earnings 4,478,559 3,819,472 3,782,618 1,997,276 930,110
Total Stockholders' Equity 12,478,559 11,819,472 11,782,618 9,997,276 8,930,110
Total Liabilities and Equity 22,298,020 20,628,129 17,229,224 16,476,104 16,958,241
**Projecting financial statements in this part will use financial statement method.
Based on the financial statement method, you should follow the following steps:
***Note: In the examples used below, the historical financial statements of Papa Company above will
be used to make the forecast.
1. Forecast Sales
Sales forecasting is the process of estimating future sales. Accurate sales forecasts enable
companies to make informed business decisions and predict short-term and long-term
performance. Companies can base their forecasts on past sales data, industry-wide
comparisons, and economic trends. Moreover, it is easier for established companies to predict
future sales based on years of past business data.
Before the end of 2016, the president of the PAPA Company had instructed the Vice
President for Finance to prepare the 2017 projected financial statements based on their most
recent planning workshop. Based on the results of the planning workshop, the following
assumptions were prepared for the 2017 projected financial statements.
Sales are expected to increase by 10% in 2017 from the 2016 sales level. This growth
assumption is based on the assessment of the external and internal factors related to PAPA
Company and the historical growth of the company. The company’s sales grew by 10.4%
annually from 2102 to 2016 (based on the historical financial statement—statement of
comprehensive income—above)
8
How to compute for the Projected Net Sales?
wherein:
Variable operating expense is 7.5% of sales. Depreciation expense is 10% of the gross
beginning balance of property, plant and equipment. As of December 31, 2016, the gross
balance of PPE is 26,000,000. For January 2017, P5 million new PPE will be acquired. It
is the policy of the company that PPE acquired in the first half of the year will be depreciated
for one full year.
9
= (41,954,730 ÷ 52,501,085) x 100%
= 79.91%
b. Then, compute for the projected cost of sales using the formula below.
Cost of Sales in 2017 = Cost of Sales Percentage in 2016 x Projected Net Sales 2017
= 79.91% x 57,751,194
= 46,148,979
10
3. Determine payment schedule for loan
These could be based on the disclosures provided in the notes to financial statements and the
plans of management on how to pay the loans if no details about payment terms are provided
in the notes to financial statements.
As of December 31, 2016, there are two long-term loans. Both have annual interest rate of
8%.
i. The first loan will mature on June 30, 2017 and the remaining principal balance to be
paid on the said date is P1,250,000.
ii. The second loan amounting to P3 million which was incurred on December 31, 2016
is paid at the rate of P500,000 principal balance every June 30 and December 31.
New loans of P3,500,000 will be incurred on December 31, 2017 payable at the rate of
P500,000 every June 30 and December 31. Annual interest rate is expected at 8%.
Second Loan
Note that the current portion of long-term debt of P1 million is added to long-term portion of
P2 million for the second loan to determine the interest expense for the first six months. The
year has to be divided into two because there is a principal payment of P500,000 on June 30,
11
2017 which will reduce the principal balance starting July 1, 2017. The interest expense will
also go down on the second half of 2017 because the principal balance has gone down too.
How to compute for the current and non-current portion of long-term loans?
For 2017 projected statement of financial position, this will be the breakdown of the
remaining balances of long-term loans as to current portion and long-term portions as of Dec.
31, 2017.
Loan Current Portion Non-current Portion Total
Loan of P3 million
incurred on December
1,000,000 1,000,000 2,000,000
31, 2016
*Note: The amount of the current and non-current portion of long-term loans will be used in the
preparation of the Projected Statement of Financial Position (SFP) for 2017.
Income tax rate is 30% of the income before taxes. Seventy-five percent (75%) of the income
tax expense will be paid in 2017 while the balance will be paid in 2018.
*Note: Return to this when all income statement items are complete.
12
Thus, the Projected Statement of Comprehensive Income for the year ending December 31,
2017 will be as follow:
PAPA COMPANY
Projected Statement of Comprehensive Income
For the Year Ending December 31, 2017
Net Sales P57,751,194
Cost of Sales 46,148,979
How did we come up with the P1,170,263 tax expense? Let’s go back to item no. 4
which states that income tax rate is 30% of the income before taxes. Seventy-five
percent (75%) of the income tax expense will be paid in 2017 while the balance will be paid
in 2018. So, to compute:
Projected Tax Expense = Income Before Tax Expense x 30%
= 3,900,875 x .30
= 1,170,263
How about the way on how to come up with the amount of the income tax payable?
Projected Income Tax Payable (2017) = Projected Tax Expense x (1-75%)
= 1,170,263 x 0.25
= 292,566
13
How to compute for the retained earnings?
Retained Earnings, beginning P4,478,559 where in:
6. Determine balance sheet items that will vary with sales or whose balances will be highly
correlated with sales.
*The balance sheet items that may vary with sales or will be highly correlated with sales are
cash, accounts receivable, inventories, accounts payable and accrued payables.
The following financial statement accounts are expected to vary with sales based on the 2016
financial statements:
A. Cash D. Other current assets
B. Trade accounts receivable E. Trade accounts payable
C. Inventories
14
Accounts Receivables as % of Sales in 2016 = (Accounts Receivables 2016 ÷ Net Sales 2016) x 100%
= (2,300,500 ÷ 52,501,085) x 100%
= 4.38%
Projected Accounts Receivables in 2017 = Accounts Receivables as a % of Sales in 2016 x
Projected Net Sales 2017
= 0.0438 x 57,751,194
= 2,529,502
*Note: The same process of computation goes with inventories, other current assets and
accounts payable.
EFN 479,996
If the value of the EFN is negative, this means that the company will have an excess cash.
However, if its amount is positive, this means that there will be a need for additional
financing. If the latter is the case, it is the management decision on how to finance it. It can
all be through debt or equity or a combination of both debt and equity.
THUS, the Projected Statement of Financial Position for 2017 will be presented as
follows:
15
PAPA COMPANY
Projected Statement of Financial Position
December 31, 2017
LIABILITIES AND
ASSETS EQUITY
Current Assets Current Liabilities
Cash 1,166,574 Notes Payable (EFN) 479,996
Accounts Receivables 2,529,502 Accounts Payable 5,555,665
Inventories 5,336,210 Income Taxes Payable 292,566
Current Portion of Long-term
Other Current Assets 1,155,024 Loan 2,000,000
10,187,310 Other Current Liabilities 85,600
Noncurrent Assets 8,413,827
Property, Plant, and
Equipment, net 14,100,000 Noncurrent Liabilities
Other Noncurrent Assets 835,689 Non-current Portion of Long- 3,500,000
14,935,689 term Loan
Total Assets 25,122,999 Total Liabilities 11,913,827
Stockholders' Equity
Capital Stock 8,000,000
Retained Earnings 5,209,172
Total Stockholders' Equity 13,209,172
Total Liabilities and Equity 25,122,999
Let’s Apply
I. Using the given information, complete the table on the next page on
how many units should the XYZ Company produce in order to fulfill the expected sales
of the company.
XYZ Company forecasts sales in units for January to May as follows:
January February March April May
Additional Information:
a. XYZ Company would like to maintain 100 units in its ending inventory at the end of each
month.
b. Beginning inventory at the start of January amounts to 50 units.
16
MONTH TOTAL
January February March April May
Projected Sales
Target level of
ending inventories
Total
Less: beginning
inventories
Required
production
II. Prepare the following pro-forma financial statements without any numbers written
on it:
1. Statement of Comprehensive Income
2. Statement of Financial Position
Take note that the name of the company will be Tiktok Corporation for the year ending
December 31, 2020.
Let’s Analyze
Direction: Using the information in the case study on how Olivia Tan come up
with her sales budget report, answer the guide questions on the next page.
Case Study
Olivia Tan works as the Financial Analyst of Step Up which manufactures and sells a range
of practical yet stylish shoes for both men and women. Olivia is in the process of preparing
the company’s sales budget for the coming year. After her meeting with the Operations
Manager, she found out that the company recently finished building another production plant
located in Laguna which has effectively doubled the company’s production capacity. Based
on the fact that last financial year the company had trouble keeping up with the demand for
most of its popular styles, Olivia has, in preparing the new sale’s budget, made the
assumption that stock manufactured in Laguna plant will be sold, resulting in a huge increase
in the company’s sales revenue.
17
Guide Questions
1. What do you think are the factors Olivia considered in preparing her sales budget?
2. What do Olivia presumed as she prepared her company’s sales budget?
3. If you are Olivia, will you have the same assumption and come up with the same sales
budget report? Why or Why not?
4. What will be the implications if sales budget is not correct?
5. What are the characteristics shown by Olivia while preparing the sales budget for the
company?
18
Let’s Try (Evaluation)
Direction: Using the information below, prepare a PROJECTED STATEMENT OF
FINANCIAL POSITION for 2016.
E. Papa Company
Projected Statement of Comprehensive Income
for the year ending December 31, 2016
Sales P 200,000,000
Cost of Sales 150,000,000
Gross Profit 50,000,000
Operating Expenses 30,000,000
Income before Interest and Taxes 20,000,000
Interest Expense 2,500,000
Income before Taxes 17,500,000
Income Taxes 7,000,000
Net Income P 10,500,000
E. Papa Company
Statement of Financial Position
December 31, 2015
Stockholders Equity
ADDITIONAL INFORMATION:
1. 2015 Sales was P180,000,000.
19
2. The following financial statement accounts are expected to vary with sales based on the
2015 financial statements:
2.1. cash
2.2. accounts receivable
2.3. inventories
2.4. accounts payable
2.5. accrued expense payable
3. For March 2016, P5 million new PPE will be acquired. It is the policy of the company
that PPE acquired in the first half of the year will be depreciated for one full year.
Depreciation will be 10% annually.
4. As of December 31, 2015, there are two long-term loans. Both have annual rate of 10%.
4.1. The first loan will mature on July 30, 2016 and the remaining principal balance to be
paid on the said date is P10 million.
4.2. The second loan amounting to P50 million which was incurred on December 31, 2015
is paid at the rate of P5 million principal balance every June 30 and December 31.
5. Income tax rate is 25%. Seventy five percent (75%) will be paid in 2016 while the rest
will be on 2017.
6. The Cash dividends of P1,000,000 will be paid for 2016.
7. If not mentioned in the terms/additional information, the accounts should remain
unchanged.
Note: All data/accounts presented in the table must be present in the projected SFP.
Convert the figures/amounts into whole number.
20
REFERENCES
The content of this module is adapted from the different websites and books. The module
writer is in a heartfelt gratitude to the following references and its authors:
Cayanan, A. & Borja, D. 2016. Business Finance. First Edition. Quezon City. Rex Bookstore.
Cayanan, et. al. 2016. Teaching Guide for Senior High School - Business Finance.
Commission on Higher Education.
https://www.accountingtools.com/articles/2017/5/15/cash-budget
https://debitoor.com/dictionary/cash-budget
https://nsfsakai.nthsydney.tafensw.edu.au/access/content/group/0f4ea869-0e76-4936-b16e-
7407f58a3a5d/AccountingAndFinance/Diploma%20Units/FNSACC503A_Budgeting/WEEK
%202_FNSACC503A_Budgeting_LESSON%202%20PowerPoint%20Slides%20_Compatibi
lity%20Mode_.pdf
https://trackmaven.com/marketing-dictionary/sales-forecasting/
21
BUSINESS FINANCE (Grade XII)
Self-Learning Module
Quarter 1 - Module 4: Budget Preparation and Projected Financial Statement
First Edition, 2020
Republic Act 8293, section 176 states that: No copyright shall subsist in any work
of the Government of the Philippines. However, prior approval of the government agency or
office wherein the work is created shall be necessary for exploitation of such work for profit.
Such agency or office may, among other things, impose as a condition the payment of
royalties.
Borrowed materials (i.e., songs, stories, poems, pictures, photos, brand names,
trademarks, etc.) included in this module are owned by their respective copyright holders.
Every effort has been exerted to locate and seek permission to use these materials from
their respective copyright owners. The publisher and authors do not represent nor claim
ownership over them.
22