CASE 10-3 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 ita cash flows to meet a maturing bank loan involved grinding, mixing and drying. To simplify their opera the partners decided to serve the needs of distributors of Rome o processor under a tolling contract. Under this arrangements 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 loen had a grace period during which time the company paid only the interest. The first loan amortization was due on May 30. Wiliam 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. Chun 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 Ledesmo, both of whom were engineers with a knack for research and development and entrepreneurship. They A8 an opportunity to build a plant that could process the raw mineral kaolin. Manufacturers were importing processed kaown which was not locally available. The partners pooled their savings to build an Oxperimental 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 develop- ment 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 TNS Ga we written by Dr. CeiroSaldane, Ph.D.o PSR Censulting freas a besit for dission in de ning semine. Ces not mended ustrele comeen handling of management situmens. Not to be produced or photocopied within the passion of the In November of the previous year, the company approached Mege 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 threo truckloade, 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 koolin was of acceptable quality. Mege Industries gave Magma Minerale contract to process keolin 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 feos lin pesos) for the next eight months, as follows: 900,000 February 975, co0 March 1,125,000 April 2,200,000 1,050,000 June 900,000 July 600,000 August 1,850.000 MAY September reneged on its amortization schedule, the balance of the would become due and demandeble. In case the internal cas 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 Oxamining the loan documents, Chue 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 QUESTIONS a) Prepare an estimated income statement for the coming eight months. ballveries under the tolling contract matched the hlohl seasonal sales pattern of ceramic tiles which thrived during the construction peak season from April to July. 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 sales, and 20 percent two months after sale. The staggered payment schedule was designed to allow Mega Industrios 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 mixingl. 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. Fuol 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 exponses were salaries to administrative staff and sundry expenses amounting to P196,000 per month. Depre- ciation expense came to P129,750 per month. The company had to pay some remaining balancos 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 Chuo worried about the payment of the first loan amortization on the long-term loan from First Development Benk. The test processing for the initial 60 MT of kaolin nearly depleted the company's cash balance which currently stood at only P50,467. Chun would have wanted to keep at least P150,000 in the bank at any given time, Chun remembered that one of the conditions involved an "acceleration clause" that meant that if the company b) Prepare a cash forecast for Magma Minerals for the coming eight months. c) What variables determine the monthly cash position of the company? d) Will the company have sufficient cash to pay Its first loan aTwor tization? lf not, vht should Chu% do