Question

Problem: Magma Minerals, Inc

Managerial Finance Concept: Cash budgeting as a support to credit planning

Financial Analysis Technique: Preparation of a cash budget

Decision Context: The company needs to program its cash flows to meet a maturing bank loan

William Chua was reviewing the figures he had gathered from his accountant at Magma Minerals, Inc, a processor of raw kaolin mineral. Kaolin was a nonmetallic mineral used in ceramics and rubber. The company had to pay the current portion of its long-term loan from First Development Bank due at the end of May. The company planned to generate cash from its sole source of revenue, namely, one processing or “tolling” contract with Mega Industries. Chua wanted to prepare a plan intended to raise the required cash to repay the loan out of that single contract.

Company Background

Magma Minerals, Inc, was founded by partners William Chua and Rufino Ledesma, both of whom were engineers with a knack for research and development and entrepreneurship. They saw an opportunity to build a plant that could process the raw mineral kaolin. Manufacturers were importing processed kaolin which was not locally available. The partners pooled their savings to build an experimental plant using machinery and equipment that they designed and fabricated. Chua became the general manager of the company while Ledesma continued in his research and development activities.

The production of processed kaolin actually involved several steps. The difficult part was manufacturing products that meet the narrow tolerance levels for the degree of fineness of the particles and in purity (from metallic content). The process involved grinding, mixing and drying. To simplify their operations, the partners decided to serve the needs of distributors of kaolin as a processor under a tolling contract. Under this arrangement, the distributor provided the raw kaolin and Magma Minerals only processed the materials, charging a straight per unit (kilogram) fee. Towards the end of the experimental phase of the project, the partners took a five year term loan from First Development Bank to build the machinery and refurbish the plant for full commercial operation. The loan had a grace period during which time the company paid only the interest. The first loan amortization was due on May 30.

In November of the previous year, the company approached Mega Industries, an importer specializing in kaolin and other mineral products for the ceramics industry, to offer their processed kaolin. Mega Industries agreed to try Magma Minerals’ product with an initial order of 60 tons or about three truckloads. Mega Industries provided raw kaolin to ensure quality of the raw material. The company tested the finished products before delivering to them. After a processing period of two months inclusive of quality testing and use by the ceramics manufacturers, the two parties agreed that the processed kaolin was of acceptable quality.   Mega Industries gave Magma Minerals a contract to process kaolin for one year, renewable at the end of each year. The contract was to begin in February.

Forecast Sales and Future Cash Flows

Before the end of January, Chua prepared an estimate of tolling fees (in pesos) for the next eight months, as follows:

February	900,000
March	975,000
April	1,125,000
May	2,200,000
June	1,050,000
August	900,000
August	600,000
September	1,850,000

Deliveries under the tolling contract matched the highly seasonal sales pattern of ceramic tiles which thrived during the construction peak season from April to August. Mega Industries shipped processed kaolin to these companies following the same pattern.

Under the tolling contract, Mega Industries paid the company 50 percent in the month of sale, 30 percent in the month following the sales, and 20 percent two months after the sale. The staggered payment schedule was designed to allow Mega Industries time to receive feedback from ceramics manufacturers, their customers, regarding the quality of the processed kaolin. If adverse responses were received, Mega Industries will ship back the identified lots and Magma Minerals would re-process them through a “beneficiating” process (further refining and mixing). In this way, the payments of accounts in the tolling contract were independent of the manufacturing of the product.

The company planned to hire factory labor and to run the plant according to the level of orders from Mega Industries. Fuel was the main expense at 10 percent of tolling fees per month. Labor was about 8 percent of tolling contract revenues per month. Maintenance expense was about 5 percent of tolling contract revenues. Other expenses were salaries to administrative staff and sundry expenses amounting to P195,000 per month. Depreciating expense came to P129,750 per month. The company had to pay some remaining balances to equipment contractors worth P278,400 in March. Taxes amounting to 35 percent of income were also payable at the end of each quarter.

The First Loan Amortization

Chua worried about the payment of the first loan amortization on the long-term loan from First Development Bank. The test processing for the initial 60 MT of kaolin nearly depleted the company’s cash balance which currently stood at only P50,467. Chua would have wanted to keep at least P150,000 in the bank at any given time. Chua remembered that one of the conditions involved an “acceleration clause” that meant that if the company reneged on its amortization schedule, the balance of the loan would become due and demandable. In case the internal cash was not sufficient, Chua thought that members of the family could put up the balance if he could give them at least a few months’ notice.

After examining the loan documents, Chua found out that the first loan amortization due on May 30 amounted to P620,450. He wondered whether he would have sufficient cash by then. He realized that he faced risks because such amortization had to be met to remain in good standing with First Development Bank.

Guide Question:

d.) Will the company have sufficient cash to pay its first loan amortization? If not, what should Chua do?

Answer 1

Solution:
Preparation of Cash Budget:
Particulars	February	March	April	May
Opening Cash Balance	50,467.00	98,467.00	-1,19,671.00	4,61,579.00
Tolling Fees	4,50,000.00	7,57,500.00	10,35,000.00	16,32,500.00
Less: Fuel Expenses 10%	90,000.00	97,500.00	1,12,500.00	2,20,000.00
Less: Loabour 8%	72,000.00	78,000.00	90,000.00	1,76,000.00
Less: Maintenance Expenses 5%	45,000.00	48,750.00	56,250.00	1,10,000.00
Less: Salary and sundry expenses	1,95,000.00	1,95,000.00	1,95,000.00	1,95,000.00
Less: Payment to equipment contractors		2,78,400.00
Less: Income tax paid		2,77,988.00
Closing Cash Balance	98,467.00	-1,19,671.00	4,61,579.00	13,93,079.00
Working:
Computation of profit for 1st quarter for Income Tax
Total Revenue	18,75,000.00
(900000+975000)
Less: Total Expense	8,21,250.00
(402000+419250)
Less: Depreciation @ 129750 per month	2,59,500.00
Taxable Profit	7,94,250.00
Tax Rate	0.35
Tax Payable	2,77,987.50
The Closing cash balance at the 30th May is 13,93,079. Out of which the minium desirable balnce which is need to be maintained
is 1,50,000. So the balance available for repayment of first amortization of bank loan is = (1393079-150000) = 1243079.
So the company have sufficient cash to repayment the first amortization. But in the month of February and March the desired cash balance
is not there so the partners should bring cash by their own to fulfill the deficit as per the terms of the business.