Management Accounting

Chapter 16 introduces you to some of the basic managerial accounting concepts you will use for the remainder of the course. The introduction to management accounting begins with an overview of the design requirements of a managerial accounting system. The system must allocate decision-making authority over a company's resources. Second, it must furnish the information to support decision-making by managers. Finally, the system must generate the information needed to evaluate and reward performance.

Managers deal with the operations of the business, and with information that is internal to the business. We call this operating information. It involves things like product costing information, payroll information and other sensitive or confidential information. For this reason, operating information is not released to the public, but is used by managers to improve business performance, and ensure the objectives of the company.

Manufacturing costs are first classified into direct material, direct labor and manufacturing overhead. With these definitions established, we introduce the critical distinction between product and period costs. This discussion in turn lays the foundation for introducing the manufacturing inventory accounts: raw materials, work-in-process, and finished goods.

The flow of costs through the inventory accounts is explained with the help of an extended illustration. The example includes a detailed analysis of the process of applying overhead using a predetermined rate. The text explains both the mechanics and the rationale underlying overhead application at this point, and calls attention to the potential weaknesses of volume based applications that will be addressed in later chapters.

The chapter closes with the development of financial statements for a manufacturing company. The schedule of cost of goods manufactured is introduced as a supplement to the financial statements intended to assist managers in evaluating the overall costs of manufactured products.
 

Management Accounting
Management (or managerial) accounting is intended to fulfill a large number of requirements. Financial accounting is intended to meet the needs of outside users of financial information, and follows GAAP. Management accounting is intended to satisfy the various needs of a large group of decision-makers inside the business, and does not follow GAAP.

A single set of financial statements satisfies the requirements of GAAP, but management accounting reports can be tailored for any situation and user. The form and format can vary widely, depending on the type of decision being analyzed.

You first need to learn to use a few basic concepts. After that, those concepts can be modified in an almost infinite number of ways to analyze business information, and make operating decisions.

A company's audited financial statements look backwards in to the prior year or years. But managers have to make decisions today, that affect the present and the future. Financial statements that are a year or more old are not very useful for the daily decisions managers have to make. They are more interested in current operating information, and projections about the future. They are also concerned with setting goals, measuring progress and achievement, eliminating waste, complying with government regulations, and a much, much more.

Accounting cycles

An accounting system is often organized into accounting cycles. These cycles are connected and interrelated. Costs flow the product costing system as illustrated in your text, and as described below. 

Separating the accounting process lets us assign different people to different tasks. Many companies have large Accounts Payable, Accounts Receivable and Payroll departments, not to mention huge Production departments and many sales people. Separating activities into accounting cycles helps us understand and apply managerial controls to these activities. 


Accounting Cycles are connected and interrelated.

Manufacturing Costs
We study manufacturing environments because they are some of the most complex business environments. What we learn here can easily be transferred to other, less complex, situations. Management accounting is really much easier than financial accounting. We classify all costs as either manufacturing or non-manufacturing. 

We separate manufacturing costs into three categories:
Manufacturing costs relate to making a product. 

Direct Materials (DM) - raw materials and parts, directly traceable to the product. Materials must attach themselves to, and become part of, the finished product to be considered Direct Materials. 

Direct Labor (DL) - wages and other payroll costs of the employees that directly work to convert Direct Materials into finished products. These costs are directly traceable to the product.

Manufacturing Overhead (OHD) - all the other costs related to producing products that don't qualify as Direct Materials or Direct Labor. Picture a manufacturing plant and all the costs of the plant. Now subtract DM and DL. Everything that's left is Overhead. These costs are indirectly traceable to the product.
 

Non-Manufacturing Costs
Some costs are specifically not manufacturing costs, and therefore not DM, DL or OHD. These are costs not related to the manufacturing plant or producing the product. The include the following two categories:

Selling Costs
The costs associated with selling the product are Selling Costs. These include sales salaries and commissions, advertising, stores and their related fixtures and equipment. 

General and Administrative Costs
The costs associated with the central management and home office of a company, and general costs of being incorporated, are classified as General and Administrative (GA) costs. This includes buildings, offices, equipment, salaries, etc. that are part of the administrative arm of the business, provided these costs can't be traced directly or indirectly to the manufacturing function.

Period Costs
Some costs don't have any future value, and only relate to the current period. These include Selling costs and GA costs. Other period costs include income taxes and interest expense.
 

Inventories
There are three classifications of inventory.

Materials inventory - raw materials and parts used in producing goods

Work in process inventory (WIP)- all partially completed goods, not ready for sale

Finished goods inventory - all completed goods ready for sale
 

Cost Flow
We say that costs "flow" though a company. This means that we collect costs in the books in certain accounts, and transfer those costs to other accounts, in a way that resembles how those costs are actually incurred in the manufacturing process. 

In general here is the way costs flow through an accounting system:
 

Direct Materials >
Direct Labor  ==>
Mfg Overhead =>
Work in Process =>Finished Goods=>Cost of Goods Sold

These are the actual accounts that will be debited and credited in a way that approximates the way costs are actually incurred in the production process. These accounts are all debited to increase the account, and credited to decrease the account.

To move costs along we debit the account the cost is moving into, and credit the account the cost is moving from. Total cost increases as it moves along, just like a snowball gets bigger as you roll it around in the snow. As goods move through the manufacturing process they pick up all the related costs along the way. Materials and labor are added as the goods are worked on, and overhead is added along the way.

Let's look at how one unit of product picks up costs in its journey through the production process. Amalgamated Widget, Inc. produces a variety of widgets for home and commercial use. The production manager requisitions raw materials, from the Materials inventory. Materials inventory account is credited and the costs are transferred to the Work in Process inventory account.

Work is started in the shaping and forming department. Labor is added at this point by crediting Direct Labor and debiting Work in Process inventory. After the widgets are formed, they go to the finishing department. The appropriate finish is applied and the finished widget is sent to the packing department, where it is prepared for shipment. Additional Materials and Direct Labor costs are added to Work in Process in the finishing and packing departments. 

Overhead is added to the product cost at each stage of the operation by debiting Work in Process inventory and crediting the Overhead account. We will discuss Overhead allocation more in a moment. 

At this point the product is complete and ready for sale. The final cost is transferred to the Finished Goods inventory account. When the item is sold the cost will then be transferred to the Cost of Goods Sold account. 

The total cost of producing a widget accumulates as the widget moves along though the production process. 
 

Unit Product Costs
The word "unit" comes from the Latin unus, meaning one. The Spanish word uno comes from the same Latin root, and also means one. A Unit Cost is the cost of producing one unit of product. We might break that down into its component parts - labor, materials & overhead - perhaps in great detail.

Manufacturing companies usually make a large quantity of products at a time. Each batch of product may be thousands of units. In some cases production is done on an assembly line, and there is little distinction between departments, aside from those arbitrarily determined by management. 

Ultimately the company must set a selling price for its goods. Since goods are sold one at a time, the company must determine the total cost of producing a single unit of goods. Unit costs are tracked throughout the production cycle in some accounting systems. In other cases, unit costs are determined at the end of production, after all costs of production have been accumulated and the finished units have been counted.

It is important that you clearly distinguish between unit costs and total costs, in your mind, at all times in this class. 
 

Applying Overhead
Overhead consists of a large number of separate costs related to the manufacturing process. They are collected in a single account and allocated to the product cost using what is called an overhead application rate.

The overhead application rate is simply a way to divide the total overhead costs for a year, across all the units of goods produced that year. Here's the formula:

Total Annual Overhead Costs
Overhead Cost Driver

The overhead cost driver, is something related to production that can be used to help spread the total cost evenly to individual units of product. Sometimes that is simply the number of units of products produced in a given year. At other times that's not the best measure to use. For instance, hot dogs are produced by the tens-of-thousands per day, packed into boxes and sold by the palette load. The overhead cost applied to one hot dog would be a very small amount, and not very relevant to managers. They will apply overhead costs in a way relevant to the decisions they need to make.
 

Allocating overhead using labor hours
Labor hours are often used as a cost driver, to apply overhead. Total overhead costs are divided by total estimated labor hours to come up with a dollar rate per labor hour. Each time labor is recorded, a corresponding amount of overhead can also be allocated and recorded (transferred to WIP).

Advantages of using labor hours:
Tends to be a predictable & steady amount
Different pay rates among employees is irrelevant
Labor hours are closely related to production, so should be an accurate measure
 

Let's look at an example. The company estimates it will have 100,000 labor hours and spend $200,000 in overhead costs. The company records 8,300 labor hours this month. Their overhead allocation is:

$200,000 / 100,000 hours = $2 per labor hour x 8,300 hours = $16,600

The company would transfer $16,600 from the Overhead account to Work in Process for the month's production.
 

Allocating overhead using labor dollars
Some very large companies allocate overhead using labor dollars, because they have a large work force, and their total labor dollars tends to be a predictable amount. They may be operating under a labor contract. They may have a large and wide-spread work force.

Overhead costs are allocated in much the same manner as above, except that labor dollars would be used, instead of labor hours.
 

Other Overhead Allocation Methods
Some companies use other allocation methods for overhead. Whatever method is used should be a reliable and predictable method, where a cost driver or reasonable cause and effect relationship can be found between costs and production. 

Overhead costs are allocated using journal entries, which means that these managerial accounting entries will also affect the audited financial statements released to outsiders. The allocation method will come under the scrutiny of the company's auditors, so it should be a reasonable method that complies with GAAP.

from :http://www.middlecity.com/

Retirement and Pensions

TYPES OF PENSION PLANS

There are two types of Pension plans when we look at the basic attribute of who bears the risk of the size of the pension and for how long it will be paid after retirement. The defined benefit pension puts the risk on the employer and the defined contribution pension puts the risk on the employee

  • Defined Benefit Plan: The employer designs a set of rules that will state who is eligible for the plan and how much they will get once they retire. These plans usually include the following.
    • Minimum number of years of service
    • Minimum age to qualify for retirement
    • Formula which calculates the annual retirement benefit as some function of salary and years of service
    • Statement about fringe benefits such as medical coverage
    • Formula for coverage of surviving spouse
    • Maximum ages to force retirement are no longer legal in the USA
  • Defined Contribution Plan
    • Minimum years of service or age to begin coverage
    • Statement on vesting rights
    • Statement on employer contribution which is generally a percentage of salary
    • Statement on employee voluntary and matched contributions

DISCUSSION OF PLAN EFFECTS

SHIFTING PURCHASING POWER RISK

Defined benefit plans have some protection against inflation because the size of the retirement benefit is determined at the retirement age and is based on a salary that has probably kept up with inflation. In the best of plans the payments after retirement may also be indexed to the CPI but this is not common.

With the defined benefit plan the monies invested are under the control of the beneficiary and it is her responsibility to see that the value of the fund grows in a manner to keep up with the cost of living.

SHIFTING ACTUARIAL RISK

Under the defined benefit plan if you live longer than expected it is just tough luck for the employer. On the other hand, if you die young or before retirement the employer makes the gain. Under the defined contribution plan, if you live longer than you have planned for you will be broke, and old! If you die early you lose again, because you are dead and someone else spends your money! So the beneficiary really takes on a significant risk with the defined contribution plan. The only way to avoid this risk is to buy a retirement annuity from the insurance company that will guarantee payment until you and/or spouse dies.

SHIFTING THE INVESTMENT RISK

Under the defined benefit plan it is up to the employer to invest funds to make sure there is enough money available each year in the future to cover the expected cash obligations cause by the retirement promises. This is highly regulated, covered below and the subject of the ATLAS Pension Case. Under the defined contribution plan it is up to the beneficiary to manage his own portfolio both before and after retirement. Most people are not finance professionals and may make big mistakes here.

You should notice that the term spouse or surviving spouse is used frequently in this subject area. Such use is one of the central reasons for the controversy over legalizing gay marriages on both a federal a state basis.

Managing a Defined Benefit Pension Benefit Fund

Managing a defined benefit pension fund is both a common sense and regulated thing. In both cases the main aim is to ensure that the fund is able to meet the promised benefits for the foreseeable future. To simplify the process, we can think of setting up the plan from scratch with nobody getting any retirement payments yet. After the setup the plan must be reevaluated each year to make sure it remain adequately funded. The concept is simple. You just figure out how much the pension plan expects to pay out each year in the future and then invest the fund's money in assets that will provide a guarantee of the cash flow at the time it is needed.

Figuring out the annual outflow

  • Determine the date of birth of each person covered
  • Based on the date of birth and sex determine when the individual will die based on actuarial tables
  • Estimate when the individual will retire, the old mandatory retirement age made this easy
  • Estimate the retirement benefit and when the fund will start paying and stop paying
  • If there is coverage for a surviving spouse, work out all the above for that person too

Manage the fund. This task is the combination of the beginning balance on hand, the contribution rate and the assumed reinvestment rate.

  • If the fund has been around for a while there will be some balance available.
  • Generally the fund is built up each year by a contribution that is some percentage of the wages paid, say 10%
  • The funds assets are invested in securities like bonds and stocks. Bonds can give a steady return when held to maturity but stocks can give greater returns in the long run which is more attractive to the employer since the annual contributions can be lower.
  • The balance is estimated each year to make sure that it remains positive throughout the life of the plan.

The actual administration of these funds is constrained by the rules of the I.R.S. and the Department of Labor [ERISA]

http://academic.uofs.edu/

The Importance of Bond Calculations

Although the vast majority of finance professionals do not deal with bonds on a daily basis, the principles involved with calculating bond values go to the very foundation of finance. If you do not have a good working knowledge of what sets bond values, you are incompetent! Any business student with a basic finance course under his/her belt ought to be able to immediately give the right answers when confronted by a Finance or Economics professor about bonds or the bond market.

All that it takes to master this subject is a firm grasp of present value principles, bond terminology definitions, and supply and demand relationships.

  • Present Value Principle--An amount to be received in the future is always worth less than the same amount today! The method used is compound interest in reverse.
  • Bond Terminology--You have to know it cold-memorize it!
    • Face Value--printed on the bond, never changes, the amount you get at maturity.
    • Maturity--printed on the bond, never changes , the date at which you get the face value paid
    • Coupon rate--printed on the bond, never changes, the percentage of Face Value that is paid as interest each year [actually one half of the interest is paid every six months]
    • Yield or market yield--not on the bond, changes every day, determined by supply and demand of bonds in the bond market
    • Market value or price of the bond--not on the bond, changes every day, calculated by figuring the present value of the coupon payments and the present value of the face value at maturity at the discount rate set equal to the market yield.
  • Supply and Demand relationships--Funds flow into and out of the bond market and the level is not constant. Treasury actions to fund the deficit and monetary policy by the Federal Reserve profoundly affect the price [yield] in the market.

Examples

The following table show the present value calculations for a $1000 Face Value bond with a 9% coupon in both a 6% and a 13% market. Look through the table a see if you can explain where all of the numbers come from.

Market=

Market=

Period

Cash Flow

0.06

0.13

Face Value

1000

1

45

43.69

42.25

Coupon Rate

0.09

2

45

42.42

39.67

3

45

41.18

37.25

Interest Payment

45

4

45

39.98

34.98

Life

5

years

5

45

38.82

32.84

6

45

37.69

30.84

7

45

36.59

28.96

8

45

35.52

27.19

9

45

34.49

25.53

10

1045

777.58

556.7

Total Present Value of Bond

1127.95

856.22

The chart below depicts the magnitude of the present values of the cash flow coming from interest and face value under the 6% and the 13% market conditions. Notice the magnitude of the present value of the face value compared to the present value of all the interest payments. The largest proportion of present value comes from the face value at maturity because the maturity is relatively near [ 5years]. Notice a 9% coupon bond is worth more than face value when rates decline to 6% and it is worth less than face value if rates go up to 13%!. Why? Because a market yield of 6% means that new bonds are coming into the market at that rate and this 9% bond is more attractive than them. So investors bid up the price of the 9% bond until it yields 6% also.

The next example show similar calculation for a 9% coupon with a twenty year life. This is a different bond from the one above because maturity dates are printed on the bond and never change!

Market=

Market=

Period

Cash Flow

0.06

0.13

Face Value

1000

1

45

43.69

42.25

Coupon Rate

0.09

2

45

42.42

39.67

3

45

41.18

37.25

Interest Payment

45

4

45

39.98

34.98

Life

20

years

5

45

38.82

32.84

6

45

37.69

30.84

7

45

36.59

28.96

8

45

35.52

27.19

9

45

34.49

25.53

10

45

33.48

23.97

11

45

32.51

22.51

12

45

31.56

21.14

13

45

30.64

19.85

14

45

29.75

18.63

15

45

28.88

17.5

16

45

28.04

16.43

17

45

27.23

15.43

18

45

26.43

14.49

19

45

25.66

13.6

20

45

24.92

12.77

21

45

24.19

11.99

22

45

23.49

11.26

23

45

22.8

10.57

24

45

22.14

9.93

25

45

21.49

9.32

26

45

20.87

8.75

27

45

20.26

8.22

28

45

19.67

7.72

29

45

19.1

7.25

30

45

18.54

6.8

31

45

18

6.39

32

45

17.48

6

33

45

16.97

5.63

34

45

16.47

5.29

35

45

15.99

4.97

36

45

15.53

4.66

37

45

15.07

4.38

38

45

14.64

4.11

39

45

14.21

3.86

40

1045

320.35

84.17

Total Present Value of Bond

1346.72

717.09

 

Notice that the present value of the face value is now a much smaller proportion of the total value. It is the face value that provides the stability for a bond price when the maturity is nearby. In very long term bonds this stability is lost and they are very volatile as they react to daily yield changes.

http://academic.uofs.edu

Cash Budgets and Bank Financing

This tutorial starts at the point where you have completed the AS3.WK4 assignment cash budget schedule. The assumptions and directions for preparing the cash budget are not repeated here!

The sample table shown below is for the first six months of the planning cycle. Look it over to orient yourself. You should be familiar with this work and what it took to get this much done.

NOV

DEC

JAN

FEB

MAR

APR

MAY

JUN

Sales Forecast

108912

508912

118714

3665546

1883218

14359509

10794854

108912

cash sales

21782

101782

23743

733109

376644

2871902

2158971

21782

one month collection

54456

254456

59357

1832773

941609

7179754

5397427

two month collection

32673

152673

35614

1099664

564966

4307853

TOTAL COLLECTIONS

310820

945140

2245031

4913175

9903691

9727062

Purchases

305347

71229

2199327

1129931

8615705

6476913

65347

702172

Payments for purchases

305347

71229

2199327

1129931

8615705

6476913

65347

702172

Salaries

101560

101560

101560

101560

101560

101560

101560

101560

Wages

76337

17807

549832

282483

2153926

1619228

16337

175543

Taxes

50000

50000

Dividends

3300

33000

Other

TOTAL PAYMENTS

2900719

1546974

10871192

8247701

216244

979276

Net cash flow

-2589847

-601834

-8626161

-3334526

9687447

8747787

Beginning Balance

3000000

410153

-191681

-8817842

-11629025

-1941578

Ending Balance

410153

-191681

-8817842

-12152368

-1941578

6806208

Safety Margin

500000

500000

500000

500000

500000

500000

NET CASH POSITION---->

-89847

-691681

-9317842

-12652368

-2441578

6306208

The important number to study is the Net Cash Position for each month. This line indicates what the checking account balance would be if your cash flows worked out as planned and also includes the extra margin for safety. Another way to look at the net cash position is that it predicts your indebtedness to the bank if you borrow all the money you need from the bank to keep your checks from bouncing.

The chart of 12 months of the cash budget shows the behavior of the net cash position

Since net cash position increases and decreases the financial manager woould have to borrow and pay pack several times during the year.

Since net cash position gets above zero twice the firm will be able to completely get out of debt twice during the year.

The amount of borrowing or repayment is equal to the difference in the net cash position each month. Of course you would never pay back more than you borrowed.

EXAMPLE

Note the net cash position numbers do not match up exactly with the table above because this table was taken from another illustration of a similar problem.

The total loans outstanding are equal to the net cash position when it is negative and zero when it is positive and the amount of monthly borrowing is equal to the change in the loans outstanding.

net cash position

DELTA

loans outstanding

JAN

-91491

91491

91491

FEB

-693703

602212

693703

MAR

-9325140

8631437

9325140

AP

-12661646

3336506

12661646

MAY

-2435532

-10226114

2435532

JUN

6317701

-8753233

0

JUL

-11245880

17563580

11245880

AUG

-35080822

23834943

35080822

SEP

-21933063

-13147760

21933063

OCT

-6299456

-15633607

6299456

NOV

15146656

-21446112

0

DEC

22760437

-7613781

0

 

from:http://academic.uofs.edu/

Cash Flow Cycle of the Firm

Understanding the cash flow cycle of a business firm is critical to successful financial management. Since finance students often do not have any managerial business experience in the finance area, misunderstandings about how cash moves through a business can make all topics appear mysterious. This tutorial is provided to give this basic knowledge about the lifeblood flow in a business.

The term liquidity is often used to describe the ability to pay bills when they are due. Liquid assets include cash and a few other things that can be sold, [not inventory] to raise cash immediately. Fixed assets are buildings plant and equipment, short term assets are inventory and accounts receivable are routinely converted to cash as part of the cycle.

The diagram shown below is taken from [] and is the type often used to illustrate the cash flow cycle using the analogy of water.

Notice the central cash reservoir. This is the balance in the cash [checking account] that the financial manager must never let run out. If it runs out somebody is not going to be paid. A worst case scenario would be a default on a legal obligation followed by bankruptcy. Also notice that the main flow of cash is from the cash reservoir, through inventories, shipments to customers and accounts receivable and back to cash. Everything else in the system is there to support this flow.

Cash Flow Descriptions

  • Reservoir #4 share owners. The common stockholder that really own the company could be asked for more money. The way that this is done is through the issuance of additional stock to the public. This is not done very frequently, is expensive, and takes months to implement.
  • Reservoir #3 Borrowing capacity. Businesses use banks for short term loans to supplement the cash reservoir when needed, often several times per year. These loans are repaid whenever the cash reservoir goes above the planned level. The firm pays interest on the outstanding balance only. The capacity of this reservoir is called the line of credit. This line is negotiated with the bank before it is needed.This line of credit must be larger than the External Financing Needed as determined by the financial forecast. The bank tries to protect its position by making restrictions on borrowers. These restrictions are couched in terms of limits on certain financial ratios, especially the current ratio and the debt ratio.Violation of these limits is usually what provokes a liquidity crisis in a firm!
  • Reservoir #2 Marketable Securities. This is the Commercial Paper Market segment of the Money Market. It is an alternative for bank borrowing for only the largest firms with perfect credit ratings. It is unavailable to most ordinary sized businesses. Basically the firm writes IOU's for very large amounts payable at some future date and sells them at a discount in the Money Market, [over the telephone].
  • Interest. This is a one way drain. These payments must be made on time or a legal default will occur.
  • Plant and Equipment. This is also a one way drain of cash since most firms keep assets until they wear out rather than sell them. An alternative to this is leasing. The difficulty with this drain is that when it occurs it can be a really big one like flushing a toilet. Much planning is required. This is the subject of capital budgeting.
  • Inventories and manufacturing expenses. The main drain. There are two things to keep in mind. There is a constant flow through here. The flow is not constant and even. Inventories are built up to handle the unevenness of sales and to minimize costs of production. Higher levels of sales demand higher levels of inventories. Higher variability of sales demands higher inventories. Greater variety of product demands higher inventories. This is a major headache for the business and many crises develop because the production and inventory get out of whack.
  • Operating expenses. Another one way drain. This is the cash spent for expenses not directly related to production. Overhead is another word used.
  • Dividends. Most corporations that pay dividends to the stockholder pay them four times a year. Many stockholders depend of these dividends to live. Although they can be skipped without causing a default, stock prices will fall, stockholders will be unhappy and managers may be fired!
  • Income taxes. Corporations that make money pay income taxes. They must be estimated and paid quarterly. A corporation may get a refund when losses occur.
  • Accounts receivable. This is what we wait for! If everything goes as planned the flow into the cash reservoir from this source will be large enough to meet all the drains with some left over for growth. For many firms this inflow is very uneven and unpredictable. The greater the unpredictability the bigger the cash balance must be to avoid a crisis.

A financial manager must be able to look at any of the events that occur in a firm and be able to predict what and when the resultant cash flows will be. This is very difficult to do and is one of the reasons financial management can be a very stressful occupation.

from:http://academic.uofs.edu

Liquidity Crises Management

What is a liquidity crisis?

A liquidity crisis occurs whenever a firm is unable to pay its bills on time or lacks sufficient cash to expand inventory and production or violates some term of an agreement by letting some of its financial ratios exceed limits. It is the financial manager's job to ensure that this never happens. But it happens and all interests involved start to scramble to protect their positions.

Consider the following example:

SITUATION This company has received a call from its bank informing it that the company has violated some terms of its loan agreement, specifically, that debt ratio exceeded 55% and that the current ratio has fallen below 2.0. These ratios are highlighted in the table of ratios below.

Technically the bank could call the loan for the complete amount outstanding . If the company cannot repay in ten days then it could be forced into bankruptcy. You are surprised at this turn of events since you were going to the bank tomorrow anyway to ask for for an additional $1,000,000 to meet a payment due to the construction company working on the expansion of your facilities.

You will have to calculate whether you would be able to repay the existing loans to the bank and the additional money you want to borrow within six months if you could get your average collection period in line with the industry average and also do the same with your inventory turnover. Assume that you will generate cash from operations and depreciation at the same rate that you did last year for one half year.

FOREST RESOURCES CORP. BALANCE SHEETS

amounts in thousands of dollars

1993

1994

1995

CASH

807

628

612

ACCOUNTS RECEIVABLE

2682

2896

4605

INVENTORY

2970

5181

7319

LAND BUILDINGS PLANT & EQUIP

2786

3153

3558

ACCUMULATED DEPRECIATION

470

730

1050

TOTAL ASSETS

8775

11128

15074

SHORT TERM LOANS

500

800

2860

ACCOUNTS PAYABLE

1061

1648

3137

ACCRUALS

540

800

1150

LONG TERM BANK LOAN

1000

1500

1500

MORTGAGE

450

408

367

COMMON STOCK[3.65 MILL.SHS]

3650

3650

3650

RETAINED EARNINGS

1574

2322

2410

TOTAL LIABILITIES AND CAP

8775

11128

15074

-

-

-

-

INCOME STATEMENTS

1993

1994

1995

NET SALES

26820

28996

30703

COST OF GOODS SOLD

21216

23550

26140

GROSS PROFIT

5604

5416

4563

AMN AND SELLING EX

2006

2407

2648

DEPRECIATION

250

260

320

MISC EX

318

558

898

EBIT

3030

2191

697

INTEREST SHORT TERM

50

88

286

INTEREST LONG TERM

0

150

150

INTEREST MORTGAGE

41

37

33

NET INCOME BEFORE TAXES

2939

1916

228

TAXES

1411

919

110

NET INCOME AFTER TAXES

1528

997

118

DIVIDENDS

382

249

30

INCREASE IN RETAINED EARNINGS

1146

748

88

Ratio Analysis

1993

1994

1995

INDUSTRY AVG

-

-

-

-

-

CURRENT RATIO

3.07

2.68

1.75

2.5

QUICK RATIO

1.66

1.08

0.73

1

DEBT RATIO %

0.4

0.46

0.6

50

TIMES INTEREST EARNED

16.79

3.63

0.25

7.7

INVENTORY TURNOVER[COST]

7.14

4.55

3.57

4.7

INVENTORY TURNOVER[SELLING]

9.03

5.6

4.19

7

FIXED ASSET TURNOVER

11.58

11.97

12.24

12

TOTAL ASSETS TURNOVER

3.06

2.61

2.04

3

AVERAGE COLLECTION PERIOD

36

36

54

25

PROFIT MARGIN %

5.7%

3.4%

0.4%

2.9

GROSS PROFIT MARGIN %

20.9%

18.7%

14.9%

18

RETURN ON TOTAL ASSETS %

17.4%

9%

0.8%

8.8

RETURN ON OWNERS EQUITY %

29.2%

16.7%

1.9%

17.5

DIVIDEND PAYOUT RATIO

25%

25%

25.4%

20%

Using Logic to Attack this problem

This situation is a problem for the company and the bank:

  • The company has a problem because it owes the bank more than the amount of cash available.
  • The bank has a problem because this company has become a problem loan and causes additional burden from bank regulators.

What are the alternatives?

  1. Bank calls the loan.
  2. Bank gives company more time but does not lend additional money needed.
  3. Bank lends additional money and does not call the loan.

If the bank calls the loan the company has ten days to come up with the money. There is not enough cash so they might seek another bank to arrange financing. However with the lousy financial ratios they have at the present time, no sane banker would lend them the money. The company would default [not be able to pay], and bankruptcy would start. The bank may have to wait years and only recover a small percentage of what is owed.

If the bank does not call the loan the company will still be unable to meet the progress payment to the contractor who will then probably start the bankruptcy proceedings anyway. So alternative #2 really is not viable in this case.

If the bank lends the additional money, the crises will be averted for the moment, but how will the bank be able to protect its interest? And, is it really throwing good money after bad.

The bank is in the driver's seat and will have to make a quick determination if the company is better off dead or alive.

Method of Analysis

Facts
  • Poor Management of Accounts Receivable.Average Collection Period
  • Poor Management of Inventory.Inventory Turnover Ratio

What needs to be discovered
  • How much cash would be produced if the Accounts Receivable and the Inventory were lowered to a proportion consistent with the Industry Average?
  • How much cash will be gained or lost from operations while the Accounts Receivable and Inventory are reduced?
  • Is the total cash potential above greater than the total amount owed the bank and the contractor?
Actions
  • If the cash potential is greater than the need, force an change in management and make additional loan.
  • If the cash potential is less than the need, start bankruptcy proceedings immediately!

Calculating the Cash Potential

The important thing to realize is that the existing management is much worse than the industry average. If the company were managed at the industry average level there would be a lot less receivables and inventory. Inventory would be sold off and old account balances would be collected.

Amount of Cash Available from Receivables
Actual Accounts Receivable[from the balance sheet]4605
Ideal Accounts Receivable[ind ACP times avg. daily sales2132
Cash potential2473

Amount of Cash Available from Inventory
Actual Inventory[from the balance sheet]7319
Ideal Inventory[Sales divided by ind Inventory turnover6533
Cash Potential786

Amount of Cash Available from Operations
Estimated net income[one half of last year's]59
Depreciation[one half of last year's]160
Cash Potential219

Decision Table
Total Cash Available[sum of above three tables]3478
Total Cash required [sum of bank loans + amount due contractor]3860
DecisionBankruptcy

Implementation

If the decision is made to go with bankruptcy it is basically a legal process to protect the rights of all the creditors.

If the decision is made to continue in operation the bank must do something to insure that the old way of managing inventory and receivables stops

from:http://academic.uofs.edu