Finance and accounting

profileSaeed AlGhamdi
ACCT212andFIN220.rar

helping resources/ACCT 212/Exercises/Module 1/ACCT212 - 161 Exercise Module 1.pdf

ACCT212 – Managerial Accounting Exercise Module 1

Theory

1. (a) “Managerial accounting is a field of accounting that provides economic information for all

interested parties.” Do you agree? Explain.

(b) Joe Delong believes that managerial accounting serves only manufacturing fi rms. Is Joe

correct? Explain.

2. Distinguish between managerial and financial accounting as to (a) primary users of reports, (b)

types and frequency of reports, and (c) purpose of reports.

3. How do the content of reports and the verification of reports differ between managerial and

financial accounting?

4. In what ways can the budgeting process create incentives for unethical behavior?

5. Linda Olsen is studying for the next accounting midterm examination. Summarize for Linda what

she should know about management functions.

6. “Decision-making is management’s most important function.” Do you agree? Why or why not?

9. Tony Andres is studying for his next accounting examination. Explain to Tony what he should

know about the differences between the income statements for a manufacturing and for a

merchandising company.

10. Jerry Lang is unclear as to the difference between the balance sheets of a merchandising

company and a manufacturing company. Explain the difference to Jerry.

11. How are manufacturing costs classified?

12. Mel Finney claims that the distinction between direct and indirect materials is based entirely on

physical association with the product. Is Mel correct? Why?

Calculations

helping resources/ACCT 212/Exercises/Module 1/Module 1 Exercises E1-3 E1-4 E1-8 E1-10 E1-12.pdf

Module 1 Managerial Accounting Question1 E1-3 Ryan Corporation incurred the following costs while manufacturing its product.

Materials used in product $100,000 Advertising expense $45,000

Depreciation on plant 60,000 Property taxes on plant 14,000

Property taxes on store 7,500 Delivery expense 21,000

Labor costs of assembly-line workers 110,000 Sales commissions 35,000

Factory supplies used 13,000 Salaries paid to sales clerks 50,000

Instructions (a) Identify each of the above costs as direct materials, direct labor, manufacturing overhead or period cost.

Question 2 E1-4 Knight Company reports the following costs and expenses in May.

Factory utilities $ 15,500 Direct labor $69,100

Depreciation on factory equipment 12,650 Sales salaries 46,400

Depreciation on delivery trucks 3,800 Property taxes on factory building 2,500

Indirect factory labor 48,900 Repairs to office equipment 1,300

Indirect materials 80,800 Factory repairs 2,000

Direct materials used 137,600 Advertising 15,000

Factory manager’s salary 8,000 Office supplies used 2,640

Instructions

From the information, determine the total amount of:

(a) Manufacturing overhead.

(b) Product costs.

(c) Period costs.

Question 3 E1-8 Lopez Corporation incurred the following costs while manufacturing its product.

Materials used in product $120,000 Advertising expense $45,000

Depreciation on plant 60,000 Property taxes on plant 14,000

Property taxes on store 7,500 Delivery expense 21,000

Labor costs of assembly-line workers 110,000 Sales commissions 35,000

Factory supplies used 23,000 Salaries paid to sales clerks 50,000

Work in process inventory was $12,000 at January 1 and $15,500 at December 31.

Finished goods inventory was $60,000 at January 1 and $45,600 at December 31.

Instructions

(a) Compute cost of goods manufactured.

(b) Compute cost of goods sold.

Question 4

E1-10 Manufacturing cost data for Copa Company are presented below.

Case A Case B Case C

Direct materials used $ (a) $68,400 $130,000

Direct labor 57,000 86,000 (g)

Manufacturing overhead 46,500 81,600 102,000

Total manufacturing costs 195,650 (d) 253,700

Work in process 1/1/14 (b) 16,500 (h)

Total cost of work in process 221,500 (e) 337,000

Work in process 12/31/14 (c) 11,000 70,000

Cost of goods manufactured 185,275 (f) (i)

Instructions

Indicate the missing amount for each letter (a) through (i).

Question 5 E1-12 Cepeda Corporation has the following cost records for June 2014.

Indirect factory labor $ 4,500 Factory utilities $ 400

Direct materials used 20,000 Depreciation, factory equipment 1,400

Work in process, 6/1/14 3,000 Direct labor 40,000

Work in process, 6/30/14 3,800 Maintenance, factory equipment 1,800

Finished goods, 6/1/14 5,000 Indirect materials 2,200

Finished goods, 6/30/14 7,500 Factory manager’s salary 3,000

Instructions (a) Prepare a cost of goods manufactured schedule for June 2014.

(b) Prepare an income statement through gross profit for June 2014 assuming sales revenue is $92,100.

helping resources/ACCT 212/Exercises/Module 2/Module 2 Answer to Exercise Process Costing.pdf

BRIEF EXERCISE 3-4 Materials Conversion Costs

January March July

45,000 (35,000 + 10,000) 48,000 (40,000 + 8,000) 61,000 (45,000 + 16,000)

39,000 (35,000 + 4,000 a )

46,000 (40,000 + 6,000 b )

49,000 (45,000 + 4,000 c )

a. 10,000 X 40% b. 8,000 X 75% c. 16,000 X 25%

BRIEF EXERCISE 3-5

Total materials costs

$36,000

÷

Equivalent units of materials

10,000

=

Unit materials cost $3.60

Total conversion

costs $54,000

÷

Equivalent units of conversion costs

12,000

=

Unit conversion cost $4.50

Unit materials

cost $3.60

+

Unit conversion cost $4.50

=

Total manufacturing cost per unit

$8.10 BRIEF EXERCISE 3-6 Assignment of Costs Equivalent Units Unit Cost Transferred out Transferred out 40,000 $11 $440,000 Work in process, 4/30 Materials Conversion costs Total costs

5,000 2,000

$ 4 $ 7

$20,000 14,000

34,000 $474,000

BRIEF EXERCISE 3-7 Total materials

costs $16,000

÷

Equivalent units of materials

20,000

=

Unit materials cost $.80

Total conversion

*costs* $47,500

÷

Equivalent units of conversion costs

19,000

=

Unit conversion cost $2.50

*$29,500 + $18,000 BRIEF EXERCISE 3-8 Costs accounted for Transferred out Work in process Materials Conversion costs Total costs

(18,000 X $3.30) (2,000 X $.80) (1,000* X $2.50)

$1,600 2,500

$59,400

4,100 $63,500

*2,000 X 50% BRIEF EXERCISE 3-9 (a)

Materials (b)

Conversion Costs

Units transferred out Work in process, November 30 Materials (7,000 X 100%) Conversion costs (7,000 X 40%) Total equivalent units

8,000

7,000 15,000

8,000

2,800 10,800

EXERCISE 3-5 (a) January May Units to be accounted for

Beginning work in process Started into production Total units Units accounted for Transferred out Ending work in process Total units

0 11,000 11,000

9,000 2,000 11,000

0 23,000 23,000

16,000 7,000 23,000

(b) (1) Materials (2) Conversion Costs January

March May July

11,000 ( 9,000 + 2,000) 15,000 (12,000 + 3,000) 23,000 (16,000 + 7,000) 11,500 (10,000 + 1,500)

10,200 ( 9,000 + 1,200) 12,900 (12,000 + 900) 21,600 (16,000 + 5,600) 10,600 (10,000 + 600)

EXERCISE 3-6 (a) (1)

Materials (2)

Conversion Costs Units transferred out

Work in process, July 31 3,000 X 100% 3,000 X 60% Total equivalent units

12,000

3,000 15,000

12,000

1,800 13,800

(b) Materials: $45,000 ÷ 15,000 = $3.00 Conversion costs: ($16,200 + $18,300) ÷ 13,800 = $2.50 Costs accounted for

Transferred out (12,000 X $5.50) Work in process, July 31 Materials (3,000 X $3.00) Conversion costs (1,800 X $2.50) Total costs

$9,000 4,500

$66,000

13,500 $79,500

EXERCISE 3-9

(a) Materials: 34,000* + 6,000 = 40,000

Conversion costs: 34,000* + (6,000 X 40%) = 36,400

*40,000 – 6,000

(b) Materials: $72,000/40,000 = $1.80

Conversion costs: ($81,000 + $101,000)/36,400 = $5.00

(c) Transferred out: 34,000 X $6.80 = $231,200 Ending work in process:

Materials (6,000 X $1.80) = $10,800 Conversion costs (2,400 X $5.00) = 12,000 Total $22,800

EXERCISE 3-10 (a) Physical

Units

Equivalent Units

Beginning work in process 20,000

Units started into production 164,000

184,000 Conversion

Materials Costs

Units transferred out 160,000 160,000 160,000

Ending work in process 24,000 24,000 14,400 (60% X 24,000)

184,000 184,000 174,400

(b) Conversion Materials Costs Total Costs incurred $101,200 $348,800 $450,000 Equivalent units 184,000 174,400 Unit costs $0.55 $2.00 $2.55 (c) Assignment of costs: Transferred out (160,000 X $2.55) $408,000 Ending work in process Materials (24,000 X $.55) $13,200 Conversion costs (14,400 X

$2.00)

28,800 42,000

Total costs $450,000

helping resources/ACCT 212/Exercises/Module 2/Module 2 Answer to Exercise Activity Based.pdf

EXERCISE 4-5 (a)

Activity Cost Pools

Estimated Overhead

÷

Expected use

of Cost Drivers

=

ABC Overhead Rates

Scheduling and travel $105,000 1,500 $ 70.00

Setup time $ 70,000 700 $100.00

Supervision $ 60,000 $400,000* $ .15

*$100,000 + $300,000

Commercial

Activity Cost Pools

Expected use of Cost

Drivers per Product

X

ABC Overhead Rates

=

Cost Assigned

Scheduling and travel 1,000 $ 70.00 $ 70,000

Setup time 450 $100.00 45,000

Supervision $100,000 $ .15 15,000

Total assigned costs $130,000

Residential

Activity Cost Pools

Expected use of Cost

Drivers per Product

X

ABC Overhead Rates

=

Cost Assigned

Scheduling and travel 500 $ 70.00 $ 35,000

Setup time 250 $100.00 25,000

Supervision $300,000 $ .15 45,000

Total assigned costs $105,000

EXERCISE 4-12 Total overhead assigned:

Activity Cost Pools

Cost Drivers

Used

X

Activity-

Based

Overhead

Rates

=

Overhead Cost

Assigned Sales commissions

Advertising—TV/Radio

Advertising—Newspaper

Catalogs

Cost of catalog sales

$900,000

250

2,000

60,000

9,000

$.05

$300

$10

$2.50

$1.00

$ 45,000

75,000

20,000

150,000

9,000

Credit and collection

Total assigned cost for March

$900,000 $.03 27,000

$326,000

PROBLEM 4-1A

(b) Activity Based Overhead Rate (per cost driver)

Activity Cost Pool

Estimated

Overhead

÷

Expected

Use of Cost Drivers

=

Activity-Based

Overhead Rate Receiving

Forming

Assembling

Testing

Painting

Packing and shipping

$ 70,350

150,500

412,300

51,000

52,580

820,750

$1,557,480

335,000 Pounds

35,000 Machine hours

217,000 Parts

25,500 Tests

5,258 Gallons

335,000 Pounds

$ .21 per pound

$ 4.30 per machine hour

$ 1.90 per part

$ 2.00 per test

$10.00 per gallon

$ 2.45 per pound

(c) Total Overhead cost per product Home Model Commercial Model

Activity Cost Pool

Expected

Use of Drivers

X

Activity- Based

Overhead Rates

=

Cost Assigned

Expected

Use of Drivers

X

Activity- Based

Overhead Rates

=

Cost Assigned

Receiving

Forming Assembling Testing Painting Packing and shipping Total costs assigned Units produced

(a) (b)

215,000 27,000 165,000 15,500 3,680 215,000

$ .21 $ 4.30 $ 1.90 $ 2.00 $10.00 $ 2.45

$ 45,150 116,100 313,500 31,000 36,800 526,750 $1,069,300

54,000

120,000 8,000 52,000 10,000 1,578 120,000

$ .21 $ 4.30 $ 1.90 $ 2.00 $10.00 $ 2.45

$ 25,200 34,400 98,800 20,000 15,780 294,000 $488,180

10,200

Overhead cost per unit [(a) ÷ (b)] $ 19.80 $ 47.86

helping resources/ACCT 212/Exercises/Module 2/Module 2 Exercise Activity Based Costing_Questions 02.pdf

MODULE 2 – ACTIVITY BASED COSTING

helping resources/ACCT 212/Exercises/Module 2/Module 2 Exercise Activity Based Costing_Questions.pdf

Module 2

Activity Based Costing

E4-5 Shady Lady sells window coverings (shades, blinds, and awnings) to both commercial and residential customers . The following information relates to its budgeted operations for the current year.

Commercial Residential

Revenues $300,000 $480,000

Direct material costs $ 30,000 $ 50,000

Direct labor costs 100,000 300,000

Overhead costs 85,000 215,000 150,000 500,000

Operating income (loss) $ 85,000 ($ 20,000)

The controller, Peggy Kingman, is concerned about the residential product line. She cannot understand why this line is not

more profitable given that the installations of window coverings are less complex for residential customers. In addition, the

residential client base resides in close proximity to the company office, so travel costs are not as expensive on a per client visit

for residential customers. As a result, she has decided to take a closer look at the overhead costs assigned to the two product

lines to determine whether a more accurate product costing model can be developed. Here are the three activity cost pools and

related information she developed:

Activity Cost Pools Estimated Overhead Cost Drivers

Scheduling and travel $105,000 Hours of travel

Setup time 70,000 Number of setups

Supervision 60,000 Direct labor cost

Expected Use of Cost Drivers per Product

Commercial Residential

Scheduling and travel 1,000 500

Setup time 450 250

Instructions

(a) Compute the activity-based overhead rates for each of the three cost pools, and determine the overhead cost assigned to

each product line.

E4-12 Kragan Clothing Company manufactures its own designed and labeled sports attire and sells its products through catalog sales and retail outlets. While Kragan has for years used activity-based costing in its manufacturing activities, it has

always used traditional costing in assigning its selling costs to its product lines. Selling costs have traditionally been assigned to

Kragan’s product lines at a rate of 70% of direct material costs. Its direct material costs for the month of March for Kragan’s

“high-intensity” line of attire are $400,000. The company has decided to extend activity-based costing to its selling costs. Data

relating to the “high-intensity” line of products for the month of March are as follows.

Number of Cost

Overhead Drivers Used Activity Cost Pools Cost Drivers Rate per Activity

Sales commissions Dollar sales $0.05 per dollar sales $900,000

Advertising—TV/Radio Minutes $300 per minute 250

Advertising—Newspaper Column inches $10 per column inch 2,000

Catalogs Catalogs mailed $2.50 per catalog 60,000

Cost of catalog sales Catalog orders $1 per catalog order 9,000

Credit and collection Dollar sales $0.03 per dollar sales $900,000

Instructions

(a) Compute the selling costs to be assigned to the “high-intensity” line of attire for the

month of March using activity-based costing.

helping resources/ACCT 212/Exercises/Module 2/MODULE 2 Job Order Costing Exercise 2.pdf

MODULE 2 – JOB ORDER COSTING EXERCISE 2

helping resources/ACCT 212/Exercises/Module 2/Module 2 Job Order Costing Exercises.pdf

Summary Problem 1 Torn Baker manufactures custom teakwood patio furniture. Suppose Baker has the following transactions: .

a. Purchased rawmaterials on account, $135~000. b. Materials costing $130,000 were requisitioned (used) for production. Of .

this total, $30,000 were indirect materials.· . c. Labor rlm:e~ecords show that direct labor of $22,000 and indirect labor . of $5,000 were incurred (but not yet paid). .. . d. Assigned labor cost to work in process and manufacturing overhead.

Requirement

1. Prepare journal entries for each transaction. Then explain each journal entry in terms of what got increased and what got decreased.

"",.9 c\.s»: d- es D~ \)('W COS~\')j

-:s D\A\ r-.0-\, "2-\ 0J

Summary Problem 2 Skippy Scooters manufactures motor scooters. The company has automated production, so it allocates manufacturing overhead based on machine hours. Skippy expects to incur $240,000 of manufacturing overhead costs and to use 4,000 machine hours during 201L At the end of 2010, Skippy reported the following inventories:

Materials inventory . Work in process inventory . Finished goods inventory -

$20,000 17,000 11,000

During January 2011, Skippy actually used 300 machine hours and recorded the following transactions: -

a. Purchased materials on account, $31,000 b. Used direct materials, $39,000 c. Manufacturing wages incurred totaled $40,000 d. Manufacturing labor was 90% direct labor and 10% indirect labor e. Used indirect materials, $3,000 f. Incurred other manufacturing overhead, $13,000 (credit Accounts

payable) g. Allocated manufacturing overhead for January 2011 h. Cost of completed motor scooters, $100,000 i. Sold motor scooters on account, $175,000; cost of motor scooters sold,

$95,000

Requirements

1. Compute Skippy's predetermined manufacturing overhead rate for 201l. 2. Record ~~: tra~~~ctions ~_t~e ge~:r~U.9~~~l~ . _

----------------------------

MODULE 2 JOB ORDER COSTING

. EXERCISE 1 JOB ORDER COSTING

Accounting for Materials and Labor Cliffs Custom Machine Shop had the following transactions during April: a. Purchased raw materials on account for $98,000. b. Requisitioned $80,000 of materials into production. Of this total, $70,000 was for direct materials. c. Actual labor cost totaled $240,000. Assume labor has not yet been paid. d. Direct labor incurred for the period totaled $190,000 and indirect labor totaled $50,000. Requirement 1. Prepare summary journal entries for each transaction.

EXERCISE 2 ALLOCATING MANUFACTURING OVERHEAD

Luscious Licorice manufactures custom-made candy. The company is highly labor intensive, so it uses direct labor hours to allocate its manufacturing overhead. Luscious expects to incur $126,000 of manufacturing overhead costs and to use 14,000 direct labor hours during 2010. At the end of March 2010, Luscious Licorice reported the following inventories:

Materials inventory

Work in process inventory Finished goods inventory

$26,000

15,500 12,100

During April 2010, Luscious actually used 1,300 direct labor hours and recorded the following transactions: a. Indirect manufacturing labor, $1,200. b. Indirect materials used, $4,000. c. Other manufacturing overhead incurred, $7,000 (credit AlP). d. Allocated overhead for April. e. Finished jobs that totaled $3,000 on their job cost records. f. Sold inventory for $50,000 that cost $20,000 to produce. Requirements 1. Compute the predetermined manufacturing overhead rate for Luscious Licorice. 2. Journalize the transactions. 3. Prepare the journal entry to close the ending balance of manufacturing overhead.

helping resources/ACCT 212/Exercises/Module 2/Module 2 Process Costing Exercises.pdf

Module 2 Process Costing

Exercises

BE3-4 Goode Company has the following production data for selected months.

Ending

Beginning Units

Work in Process

% Complete as to

Month Work in Process Transferred Out Units Conversion Cost

January –0– 35,000 10,000 40%

March –0– 40,000 8,000 75

July –0– 45,000 16,000 25

Compute equivalent units of production for materials and conversion costs, assuming

materials are entered at the beginning of the process.

BE3-5 In Lopez Company, total material costs are $36,000, and total conversion costs are $54,000. Equivalent units of production are materials 10,000 and conversion costs 12,000. Compute

the unit costs for materials, conversion costs, and total manufacturing costs.

BE3-6 Trek Company has the following production data for April: units transferred out 40,000, and ending work in process 5,000 units that are 100% complete for materials and 40% complete

for conversion costs. If unit materials cost is $4 and unit conversion cost is $7, determine

the costs to be assigned to the units transferred out and the units in ending work in process.

BE3-7 Production costs chargeable to the Finishing Department in June in Cascio Company are materials $16,000, labor $29,500, overhead $18,000. Equivalent units of production are materials 20,000 and conversion costs 19,000. Compute the unit costs for materials and

conversion costs.

BE3-8 Data for Cascio Company are given in BE3-7. Production records indicate that 18,000 units were transferred out, and 2,000 units in ending work in process were 50% complete as to conversion cost and 100% complete as to materials. Prepare a cost reconciliation schedule.

BE3-9 The Smelting Department of Mathews Company has the following production and

cost for data November.

Production: Beginning work in process 2,000 units that are 100% complete as to

materials and 20% complete as to conversion costs; units transferred out 8,000 units;

and ending work in process 7,000 units that are 100% complete as to materials and

40% complete as to conversion costs.

Compute the equivalent units of production for (a) materials and (b) conversion costs for

the month of November.

E3-5 In Wayne Company, materials are entered at the beginning of each process. Work in process inventories, with the percentage of work done on conversion costs, and production data for its

Sterilizing Department in selected months during 2014 are as follows.

Beginning Ending

Work in Process Work in Process

Conversion Units Conversion Month Units Cost% Transferred Out Units Cost%

January –0– — 9,000 2,000 60

March –0– — 12,000 3,000 30

May –0– — 16,000 7,000 80

July –0– — 10,000 1,500 40

Instructions

(a) Compute the physical units for January and May.

(b) Compute the equivalent units of production for (1) materials and (2) conversion costs for each

month.

E3-6 The Cutting Department of Cassel Company has the following production and cost data for July.

Production Costs 1. Transferred out 12,000 units. Beginning work in process $ –0–

2. Started 3,000 units that are 60% Materials 45,000

complete as to conversion Labor 16,200

costs and 100% complete as Manufacturing overhead 18,300

to materials at July 31.

Materials are entered at the beginning of the process. Conversion costs are incurred uniformly

during the process.

Instructions

(a) Determine the equivalent units of production for (1) materials and (2) conversion costs.

(b) Compute unit costs and prepare a cost reconciliation schedule.

E3-9 Kostrivas Company has gathered the following information.

Units in beginning work in process

–0–

Units started into production 40,000

Units in ending work in process 6,000

Percent complete in ending work in process: Conversion costs 40%

Materials 100%

Costs incurred: Direct materials $72,000

Direct labor $81,000

Overhead $101,000

Instructions

(a) Compute equivalent units of production for materials and for conversion costs.

(b) Determine the unit costs of production.

(c) Show the assignment of costs to units transferred out and in process.

helping resources/ACCT 212/Exercises/Module 3/Module 3 Exercises Extra Questions.pdf

Module 3 – Additional Exercises

helping resources/ACCT 212/Exercises/Module 3/Module 3 Exercises_Answer.pdf

E5-4 1. Wood used in the production of furniture. Variable. 2. Fuel used in delivery trucks. Variable. 3. Straight-line depreciation on factory building. Fixed. 4. Screws used in the production of furniture. Variable. 5. Sales staff salaries. Fixed. 6. Sales commissions. Variable. 7. Property taxes. Fixed. 8. Insurance on buildings. Fixed. 9. Hourly wages of furniture craftsmen. Variable. 10. Salaries of factory supervisors. Fixed. 11. Utilities expense. Mixed. 12. Telephone bill. Mixed.

E5-3 (a) Maintenance Costs:

$4,900 – $2,500

700 – 300 =

$2,400

400 = $6 variable cost per machine hour

700 Machine Hours

300 Machine Hours

Total costs

Less: Variable costs 700 X $6 300 X $6 Total fixed costs

$4,900

4,200 $ 700

$2,500

1,800 $ 700

Thus, maintenance costs are $700 per month plus $6 per machine hour.

E5-5 (a) Maintenance Costs:

$5,000 – $2,750

8,000 – 3,500 =

$2,250

4,500 = $.50 variable cost per machine hour

Activity Level

High Low Total cost

Less: Variable costs 8,000 X $.50 3,500 X $.50 Total fixed costs

$5,000

4,000 00,000 $1,000

$2,750

1,750 $1,000

Thus, maintenance costs are $1,000 per month plus $.50 per machine hour.

E5-8 (a) Contribution margin per lawn

Contribution margin per lawn Contribution margin ratio

= = =

$60 – ($12 + $10 + $2) $36 $36 ÷ $60 = 60%

Fixed costs = $1,400 + $200 + $2,000 = $3,600 Break-even point in lawns = $3,600 ÷ $36 = 100 (b) Break-even point in dollars = 100 lawns X $60 per lawn

= $6,000 per month OR

Fixed costs ÷ Contribution margin ratio = $3,600 ÷ .60 = $6,000 per month

E5-9 1. Contribution margin per room

Contribution margin per room Contribution margin ratio

= = =

$60 – ($11 + $28) $21 $21 ÷ $60 = 35%

Fixed costs = $6,200 + $1,100 + $1,000 + $100 = $8,400 Break-even point in rooms = $8,400 ÷ $21 = 400

2. Break-even point in dollars = 400 rooms X $60 per room

= $24,000 per month OR

Fixed costs ÷ Contribution margin ratio = $8,400 ÷ .35 = $24,000 per month

BE 6-7

Model

Sales Mix Percentage

Unit Contribution Margin

Weighted-Average Unit Contribution Margin

A12 B22

C124

60% 15% 25%

$10 ($50 – $40) $30 ($100 – $70)

$100 ($400 – $300)

$ 6.00 4.50 25.00 $35.50

BE 6-8 Total break-even = ($213,000 ÷ $35.50*) = 6,000 units *Computed in BE 6-7 Sales Units Units of A12 = .60 X 6,000 = 3,600 Units of B22 = .15 X 6,000 = 900 Units of C124 = .25 X 6,000 = 1,500 6,000

BE 6-9 (a) Weighted-average contribution = (.30 X .20) + (.50 X .20) + ( .20 X .45) = .25 margin ratio (b) Total break-even point = ($440,000 ÷ .25) = $1,760,000 in dollars

Birthday $1,760,000 X .30 = $ 528,000 Standard tapered $1,760,000 X .50 = 880,000 Large scented $1,760,000 X .20 = 352,000

$1,760,000 BE 6-10 (a) Sales Mix Bedroom Division $500,000 ÷ $1,250,000 = .40 Dining Room Division $750,000 ÷ $1,250,000 = .60 (b) Weight-average contribution

= $575,000

= .46 margin ratio $1,250,000

OR Contribution Margin Ratio Bedroom Division ($275,000 ÷ $500,000) = .55 Dining Room Division ($300,000 ÷ $750,000) = .40

Weighted-average contribution margin ratio = (.55 X .40) + (.40 X .60) = .46

E6-9

(a) Weighted-average unit contribution margin = ($40 X .30) + ($20 X .60) + ($60 X .10) = $30

Break-even point in units = $630,000 ÷ $30 = 21,000

(b) Shoes (21,000 X .30) = 6,300 pairs of shoes

Gloves (21,000 X .60) = 12,600 pairs of gloves Range-finders (21,000 X .10) = 2,100 range-finders

(c) Shoes: 6,300 X $40 = $252,000

Gloves: 12,600 X $20 = 252,000 Range-finders: 2,100 X $60 = 126,000 Total contribution margin 630,000 Fixed costs 630,000 Net income $ 0

E6-10 (a) Sales mix percentage

iPad division: $600,000 ÷ ($600,000 + $400,000) = .60 iPod division: $400,000 ÷ ($600,000 + $400,000) = .40

Contribution margin ratio: iPad division: $180,000 ÷ $600,000 = .30 iPod division: $140,000 ÷ $400,000 = .35

(b) Weighted-average contribution

= $320,000

= .32 OR margin ratio $1,000,000

Weighted-average contribution

margin ratio = (.60 X .30) + (.40 X .35) = .32 (c) Break-even point in dollars = $120,000 ÷ .32 = $375,000 (d) Sales dollars needed at break-even point for each division

iPad division: $375,000 X .60 = $225,000 iPod division: $375,000 X .40 = $150,000

helping resources/ACCT 212/Exercises/Module 3/Module 3 Exercises_Questions.pdf

Module 3 Cost Volume Profit Analysis

E5-4 Family Furniture Corporation incurred the following costs. 1. Wood used in the production of furniture. 2. Fuel used in delivery trucks. 3. Straight-line depreciation on factory building. 4. Screws used in the production of furniture. 5. Sales staff salaries. 6. Sales commissions. 7. Property taxes. 8. Insurance on buildings. 9. Hourly wages of furniture craftsmen. 10. Salaries of factory supervisors. 11. Utilities expense. 12. Telephone bill. Instructions Identify the costs above as variable, fixed, or mixed. E5-3 The controller of Furgee Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs.

Total Total

Month Maintenance Costs Machine Hours

January $2,500 300

February 3,000 350

March 3,600 500

April 4,500 690

May 3,200 400

June 4,900 700

Instructions

(a) Determine the fixed- and variable-cost components using the high-low method.

E5-5 The controller of Dousmann Industries has collected the following monthly expense data for use in analyzing the cost behavior of maintenance costs.

Total Total

Month Maintenance Costs Machine Hours

January $2,750 3,500

February 3,000 4,000

March 3,600 6,000

April 4,500 7,900

May 3,200 5,000

June 5,000 8,000

Instructions

(a) Determine the fixed- and variable-cost components using the high-low method.

E5-8 All That Blooms provides environmentally friendly lawn services for homeowners. Its operating costs are as follows. Depreciation $1,400 per month Advertising $200 per month Insurance $2,000 per month Weed and feed materials $12 per lawn Direct labor $10 per lawn Fuel $2 per lawn All That Blooms charges $60 per treatment for the average single-family lawn. Instructions Determine the company’s break-even point in (a) number of lawns serviced per month and (b) dollars.

E5-9 The Green Acres Inn is trying to determine its break-even point. The inn has 50 rooms that it rents at $60 a night. Operating costs are as follows. Salaries $6,200 per month Utilities $1,100 per month Depreciation $1,000 per month Maintenance $100 per month Maid service $11 per room Other costs $28 per room Instructions Determine the inn’s break-even point in (a) number of rented rooms per month and (b) dollars. BE6-7 Markowis Corporation sells three different models of mosquito “zapper.” Model A12 sells for $50 and has variable costs of $40. Model B22 sells for $100 and has variable costs of $70. Model C124 sells for $400 and has variable costs of $300. The sales mix of the three models is: A12, 60%; B22, 15%; and C124, 25%. What is the weighted-average unit contribution margin? BE6-8 Information for Markowis Corporation is given in BE6-7. If the company has fixed costs of $213,000, how many units of each model must the company sell in order to break even?

BE6-9 Peine Candle Supply makes candles. The sales mix (as a percentage of total dollar sales) of its three product lines is birthday candles 30%, standard tapered candles 50%, and large scented candles 20%. The contribution margin ratio of each candle type is shown below.

Candle Type Contribution Margin Ratio

Birthday 20%

Standard tapered 20%

Large scented 45%

(a) What is the weighted-average contribution margin ratio? (b) If the company’s fixed costs are $440,000 per year, what is the dollar

amount of each type of candle that must be sold to break even? BE6-10 Faune Furniture Co. consists of two divisions, Bedroom Division and Dining Room Division. The results of operations for the most recent quarter are:

Bedroom

Division

Dining

RoomDivision

Total

Sales

Variable costs

$500,000

225,000

$750,000

450,000

$1,250,000

675,000

Contribution

margin $275,000 $300,000 $ 575,000

(a) Determine the company’s sales mix. (b) Determine the company’s weighted-average contribution margin ratio.

E6-9 Palmer Golf Accessories sells golf shoes, gloves, and a laser-guided range-finder that measures distance. Shown below are unit cost and sales data.

Pairs of

Shoes

Pairs of

Gloves

Range-

Finder

Unit sales price

Unit variable costs

$100

60

$30

10

$260

200

Unit contribution margin $ 40 $20 $ 60

Sales mix 30% 60% 10%

Fixed costs are $630,000. Instructions (a) Compute the break-even point in units for the company. (b) Determine the number of units to be sold at the break-even point for each product line. E6-10 Personal Electronix sells iPads and iPods. The business is divided into two divisions along product lines. CVP income statements for a recent quarter’s activity are presented below.

iPad Division iPod Division Total

Sales

Variable costs

$600,000

420,000

$400,000

260,000

$1,000,000

680,000

Contribution margin $180,000 $140,000 320,000

Fixed costs 120,000

Net income $ 200,000

Instructions (a) Determine sales mix percentage and contribution margin ratio for each division. (b) Calculate the company’s weighted-average contribution margin ratio. (c) Calculate the company’s break-even point in dollars. (d) Determine the sales level in dollars for each division at the break-even point.

helping resources/ACCT 212/Exercises/Module 4/Module 4 Short Term Business Decisions Exercise Combined.pdf

Module 4 SHORT TERM BUSINESS DECISION

EXERCISES BE7-3 (Special Order) At Jaymes Company, it costs $30 per unit ($20 variable and $10 fixed) to make a product at full capacity that normally sells for $45. A foreign wholesaler offers to buy 3,000 units at $25 each. Jaymes will incur special shipping costs of $2 per unit. Assuming that Jaymes has excess operating capacity, indicate the net income (loss) Jaymes would realize by accepting the special order. BE7-4 (Outsourcing/Make or Buy) Manson Industries incurs unit costs of $8 ($5 variable and $3 fixed) in making a subassembly part for its finished product. A supplier offers to make 10,000 of the assem- bly part at $6 per unit. If the offer is accepted, Manson will save all variable costs but no fixed costs. Prepare an analysis showing the total cost saving, if any, Manson will realize by buying the part. BE7-5 (Sell as is or process further) Chudrick Inc. makes unfinished bookcases that it sells for $62. Production costs are $36 variable and $10 fixed. Because it has unused capacity, Chudrick is considering finishing the bookcases and selling them for $70. Variable finishing costs are expected to be $7 per unit with no increase in fixed costs. Prepare an analysis on a per unit basis show- ing whether Chudrick should sell unfinished or finished bookcases. BE7-7 (Keep or Replace Asset) Kobe Company has a factory machine with a book value of $90,000 and a remain- ing useful life of 5 years. It can be sold for $30,000. A new machine is available at a cost of $300,000. This machine will have a 5-year useful life with no salvage value. The new ma- chine will lower annual variable manufacturing costs from $600,000 to $500,000. Prepare an analysis showing whether the old machine should be retained or replaced.

E7-2 (Special Order) Gruden Company produces golf discs which it normally sells to retailers for $7 each. The cost of manufacturing 20,000 golf discs is: Materials $ 10,000

Labor 30,000

Variable overhead 20,000

Fixed overhead 40,000

Total $100,000

Gruden also incurs 5% sales commission ($0.35) on each disc sold. McGee Corporation offers Gruden $4.80 per disc for 5,000 discs. McGee would sell the discs under its own brand name in foreign markets not yet served by Gruden. If Gruden accepts the offer, its fixed overhead will increase from $40,000 to $46,000 due to the purchase of a new imprinting machine. No sales commission will result from the special order. Instructions (a) Prepare an incremental analysis for the special order. (b) Should Gruden accept the special order? Why or why not? E7-5 (Outsourcing/Make or Buy) Schopp Inc. has been manufacturing its own shades for its table lamps. The com- pany is currently operating at 100% of capacity, and variable manufacturing overhead is charged to production at the rate of 70% of direct labor cost. The direct materials and direct labor cost per unit to make the lamp shades are $4 and $5, respectively. Normal production is 30,000 table lamps per year. A supplier offers to make the lamp shades at a price of $12.75 per unit. If Schopp Inc. accepts the supplier’s offer, all variable manufacturing costs will be eliminated, but the $45,000 of fixed manufacturing overhead currently being charged to the lamp shades will have to be absorbed by other products. Instructions (a) Prepare the incremental analysis for the decision to make or buy the lamp shades. (b) Should Schopp Inc. buy the lamp shades?

Flowers Inc. manufactures silk roses. Bud Company has approached Flowers with a proposal to buy 2,000 silk roses for $4.00 each. Regular customers are charged $4.25 for each rose. Flowers has the necessary capacity. The following costs are associated annually with silk roses with the company's normal production and sales of 10,000 roses:

Direct material $21,000 Direct labor 13,000 Manufacturing overhead 9,000 Total $43,000

Forty percent of the manufacturing overhead is variable. All fixed overhead is allocated equally to all products produced. In good form, prepare an incremental analysis to analyze whether Flowers should accept the order from Bud Company. Solution Step 1: Determine incremental revenue. The sale of 2,000 roses at $4 each will increase revenue by $8,000 and is relevant.

$4.00 x 2,000 = $8,000 The normal sales of 10,000 roses is not incremental as it will produce the same revenue regardless if the special order is accepted or not. Step 2: Determine incremental variable costs. When 2,000 additional roses are produced, the company will incur material, labor, and variable overhead costs for these roses. Because unit variable costs remain the same regardless of the activity level, you must calculate the variable unit cost for both materials and labor. Unit direct material cost = $21,000/10,000 roses = $2.10 per rose Unit direct labor cost = $13,000/10,000 roses = $1.30 per rose Unit variable overhead cost = [$9,000 x 40%]/10,000 roses = $0.36 per rose

The unit costs of $2.10, $1.30, and $0.36 are for a single rose. Multiple the unit costs by the 2,000 roses in the special order to obtain total incremental variable costs: Direct materials cost for the special order = $2.10 x 2,000 = $4,200 Direct labor cost for the special order = $1.30 x 2,000 = $2,600 Variable overhead cost for the special order = $0.36 x 2,000 = $720

Because variable costs are increased, profit will decrease by these three incremental amounts. The incremental variable costs are shown as negative amounts in the incremental analysis. Step 3: Determine incremental fixed costs. Allocated fixed overhead is not relevant because the total fixed overhead of $5,400 (60% x $9,000) will result in the same total amount no matter if the order is accepted or not.

Step 4: List the amounts in good form beginning with incremental revenue. The analysis should appear similar to the form of an income statement with descriptive line item labels:

Incremental revenue $8,000

Incremental costs:

Direct materials (4,200) Direct labor (2,600) Variable overhead (720) Incremental increase in profit if the order is accepted $ 480

Note the distinctive label adjacent to the $480 net total line of the analysis. It contains three key components:

 The 'incremental increase' (or decrease) indicates that the change is incremental, and whether the change is an increase or decrease.

 The 'in profit' indicates what financial component the change will affect.  'If the order is accepted' indicates what action must be taken to result in

the additional (reduction of) profit.

Because profit is expected to increase by $480 if the order is accepted, managers should follow through and accept the order unless qualitative issues warrant otherwise.  

E8-2 Eckert Company is involved in producing and selling high-end golf equipment. The

company has recently been involved in developing various types of laser guns to measure

yardages on the golf course. One small laser gun, called LittleLaser, appears to have a very large

potential market. Because of competition, Eckert does not believe that it can charge more than

$90 for LittleLaser. At this price, Eckert believes it can sell 100,000 of these laser guns. Eckert

will require an investment of $8,000,000 to manufacture, and the company wants an ROI of

20%.

E8-4 Kaspar Corporation makes a commercial-grade cooking griddle. The following information

is available for Kaspar Corporation’s anticipated annual volume of 30,000 units.

The company uses a 40% markup percentage on total cost.

Instructions

(a) Compute the total cost per unit.

(b) Compute the target selling price.

E8-5 Paige Corporation makes a mechanical stuffed alligator that sings the Martian national

anthem. The following information is available for Paige Corporation’s anticipated annual

volume of 500,000 units.

The company has a desired ROI of 25%. It has invested assets of $26,000,000.

Instructions

(a) Compute the total cost per unit.

(b) Compute the desired ROI per unit.

(c) Compute the markup percentage using total cost per unit.

(d) Compute the target selling price.

Module 4 Short Term Business Decision

Keep or Replace Equipment

Johnson Enterprises uses a computer to handle its sales invoices. Lately, business has been so good that it takes an extra 3 hours per night, plus every third Saturday, to keep up with the volume of sales invoices. Management is considering updating its computer with a faster model that would eliminate all of the overtime processing.

Current Machine New Machine Original purchase cost $15,000 $25,000 Accumulated depreciation $ 6,000 — Estimated annual operating costs $25,000 $20,000 Useful life 5 years 5 years If sold now, the current machine would have a salvage value of $6,000. If operated for the remainder of its useful life, the current machine would have zero salvage value. The new machine is expected to have zero salvage value after 5 years. Instructions Should the current machine be replaced?

  • Module 4 Short Term Business Decision_Question.pdf
  • Module 4 Short Term Business Decsion Special Order Flowers Inc.pdf
  • Module 4 Short Term Business Target Costing Cost Plus Pricing Exercise.pdf
  • Module 4 Short Term Business Decision keep or replace.pdf

helping resources/ACCT 212/Exercises/Module 5/MODULE 5_EXERCISES_ANSWER.pdf

BE 9-2

PALERMO COMPANY Sales Budget

For the Year Ending December 31, 2014 Quarter 1 2 3 4 Year

Expected unit sales Unit selling price Total sales

10,000

X $70 $700,000

12,000

X $70 $840,000

15,000

X $70 $1,050,000

18,000

X $70 $1,260,000

55,000

X $70 $3,850,000

BE9-3

PALERMO COMPANY Production Budget

For the Six Months Ending June 30, 2014 Quarter Six

Months 1 2

Expected unit sales Add: Desired ending finished goods Total required units Less: Beginning finished goods inventory Required production units

10,000 3,000 13,000 2,500 10,500

a

b

12,000 3,750 15,750 3,000 12,750

c

23,250 a12,000 X .25 b10,000 X .25 c15,000 X .25

BE 9-4

PERINE COMPANY Direct Materials Budget

For the Month Ending January 31, 2014 Units to be produced ........................................................ 4,000 Direct materials per unit ................................................... X 2 Total pounds required for production ............................. 8,000 Add: Desired ending inventory (25% X 5,000 X 2) ....... 2,500 Total materials required ................................................... 10,500 Less: Beginning materials inventory (4,000 X 2 X 25%) ................................................... 2,000 Direct materials purchases .............................................. 8,500 Cost per pound .................................................................. X $6 Total cost of direct materials purchases ........................ $51,000 BE 9-5

MIZE COMPANY Direct Labor Budget

For the Six Months Ending June 30, 2014 Quarter Six

Months 1 2

Units to be produced Direct labor time (hours) per unit Total required direct labor hours Direct labor cost per hour Total direct labor cost

5,000 X 1.6 8,000 X $15 $120,000

6,000 X 1.6

9,600 X $15 $144,000

$264,000

BE 9-6

ROCHE INC. Manufacturing Overhead Budget

For the Year Ending December 31, 2014 Quarter 1 2 3 4 Year Variable costs Fixed costs Total manufacturing overhead

$20,000 40,000 $60,000

$25,000 40,000 $65,000

$30,000 40,000 $70,000

$35,000 40,000 $75,000

$110,000 160,000 $270,000

BE 9-7

NOBLE COMPANY Selling and Administrative Expense Budget

For the Year Ending December 31, 2014 Quarter 1 2 3 4 Year Variable expenses Fixed expenses Total selling and administrative expenses

$22,000 40,000

$62,000

$26,000 40,000

$66,000

$30,000 40,000

$70,000

$34,000 40,000

$74,000

$112,000 160,000

$272,000

BE 9-8

NORTH COMPANY Budgeted Income Statement

For the Year Ending December 31, 2014 Sales ................................................................................... $2,250,000 Cost of goods sold (50,000 X $25) ................................... 1,250,000 Gross profit........................................................................ 1,000,000 Selling and administrative expenses .............................. 300,000 Income before income taxes ............................................ 700,000 Income tax expense .......................................................... 210,000 Net income ......................................................................... $ 490,000

E 9-14

DANNER COMPANY Cash Budget

For the Two Months Ending February 28, 2014 January February

Beginning cash balance .......................................... Add: Receipts Collections from customers ....................... Sale of marketable securities ..................... Total receipts ............................................... Total available cash ................................................. Less: Disbursements Direct materials ........................................... Direct labor .................................................. Manufacturing overhead ............................. Selling and administrative expenses ........ Total disbursements ................................... Excess (deficiency) of available cash over cash disbursements ..................................................... Financing Add: Borrowings .................................................... Less: Repayments ................................................... Ending cash balance ...............................................

$ 45,000

85,000 12,000 97,000 142,000

50,000 30,000 19,500 15,000 114,500

27,500

0

0 $ 27,500

$ 27,500

150,000 0 150,000 177,500

75,000 45,000 23,500 20,000 163,500

14,000

6,000 0 $ 20,000

E 9-15

AARON CORPORATION Cash Budget

For the Quarter Ended March 31, 2014 Beginning cash balance ............................................................. Add: Receipts Collections from customers .......................................... Sale of equipment .......................................................... Total receipts ........................................................... Total available cash .................................................................... Less: Disbursements Direct materials .............................................................. Direct labor ..................................................................... Manufacturing overhead ................................................ Selling and administrative expenses ........................... Purchase of securities ................................................... Total disbursements ................................................ Excess of available cash over disbursements......................... Financing Add: Borrowings ....................................................................... Less: Repayments ..................................................................... Ending cash balance ..................................................................

$ 30,000

180,000 3,000 183,000 213,000

41,000 70,000 35,000 45,000

14,000 205,000

8,000

17,000 –0– $ 25,000

helping resources/ACCT 212/Exercises/Module 5/MODULE 5_EXERCISES_QUESTIONS.pdf

MODULE 5 MASTER BUDGET

EXERCISES

BE9-2 (Sales Budget)

Palermo Company estimates that unit sales will be 10,000 in quarter 1; 12,000 in quarter 2; 15,000 in

quarter 3; and 18,000 in quarter 4. Using a sales price of $70 per unit, prepare the sales budget by

quarters for the year ending December 31, 2014.

BE9-3 (Production Budget)

Sales budget data for Palermo Company are given in BE9-2. Management desires to have an ending

finished goods inventory equal to 25% of the next quarter’s expected unit sales. Prepare a production

budget by quarters for the first 6 months of 2014.

BE9-4 (Direct Material Budget)

Perine Company has 2,000 pounds of raw materials in its December 31, 2013, ending inventory.

Required production for January and February of 2014 are 4,000 and 5,000 units, respectively. Two

pounds of raw materials are needed for each unit, and the estimated cost per pound is $6. Management

desires an ending inventory equal to 25% of next month’s materials requirements. Prepare the direct

materials budget for January.

BE9-5 (Direct Labor Budget)

For Mize Company, units to be produced are 5,000 in quarter 1 and 6,000 in quarter 2. It takes 1.6 hours

to make a finished unit, and the expected hourly wage rate is $15 per hour. Prepare a direct labor

budget by quarters for the 6 months ending June 30, 2014.

BE9-6 (Manufacturing Overhead Budget)

For Roche Inc., variable manufacturing overhead costs are expected to be $20,000 in the first quarter of

2014, with $5,000 increments in each of the remaining three quarters. Fixed overhead costs are

estimated to be $40,000 in each quarter. Prepare the manufacturing overhead budget by quarters and

in total for the year.

BE9-7 (Selling and Administrative Expenses Budget)

Noble Company classifies its selling and administrative expense budget into variable and fixed

components. Variable expenses are expected to be $22,000 in the first quarter, and $4,000 increments

are expected in the remaining quarters of 2014. Fixed expenses are expected to be $40,000 in each

quarter. Prepare the selling and administrative expense budget by quarters and in total for 2014.

BE9-8 (Budgeted Income Statement)

North Company has completed all of its operating budgets. The sales budget for the year shows 50,000

units and total sales of $2,250,000. The total unit cost of making one unit of sales is $25. Selling and

administrative expenses are expected to be $300,000. Income taxes are estimated to be $210,000.

Prepare a budgeted income statement for the year ending December 31, 2014.

E9-14 (Cash Budget)

Danner Company expects to have a cash balance of $45,000 on January 1, 2014.

Relevant monthly budget data for the first 2 months of 2014 are as follows.

Collections from customers: January $85,000, February $150,000.

Payments for direct materials: January $50,000, February $75,000.

Direct labor: January $30,000, February $45,000. Wages are paid in the month they are incurred.

Manufacturing overhead: January $21,000, February $25,000. These costs include depreciation of

$1,500 per month. All other overhead costs are paid as incurred.

Selling and administrative expenses: January $15,000, February $20,000. These costs are exclusive of

depreciation. They are paid as incurred.

Sales of marketable securities in January are expected to realize $12,000 in cash. Danner

Company has a line of credit at a local bank that enables it to borrow up to $25,000. The

company wants to maintain a minimum monthly cash balance of $20,000.

Instructions

Prepare a cash budget for January and February.

E9-15 (Cash Budget)

Aaron Corporation is projecting a cash balance of $30,000 in its December 31, 2013, balance sheet. Aaron’s schedule of expected collections from customers for the first quarter of 2014 shows total collections of $180,000. The schedule of expected payments for direct materials for the first quarter of 2014 shows total payments of $41,000. Other information gathered for the first quarter of 2014 is sale of equipment $3,000; direct labor $70,000, manufacturing overhead $35,000, selling and administrative expenses $45,000; and purchase of securities $14,000. Aaron wants to maintain a balance of at least $25,000 cash at the end of each quarter. Instructions

Prepare a cash budget for the fi rst quarter.

helping resources/ACCT 212/Exercises/Module 6/Module 6 Exercises_ Question.pdf

MODULE 6

EXERCISES

Question 1

Consider the following key performance indicators (KPI):

a. Number of employee suggestions implemented

b. Revenue growth

c. Number of on-time deliveries

d. Percentage of sales force with access to real-time

inventory levels

e. Customer satisfaction ratings

f. Number of defects found during manufacturing

g. Number of warranty claims

h. Return on investment

i. Variable cost per unit

j. Percentage of market share

k. Number of hours of employee training

l. Number of new products developed

m. Yield rate (number of units produced per hours)

n. Average repair time

o. Employee satisfaction

p. Number of repeat customers

Classify each of the preceding key performance indicators according to the balanced scorecard

perspective it address. Choose from financial perspective, customer perspective, internal

business perspective or learning and growth perspective.

Question 2

Consider the following key performance indicators (KPI):

a. Number of customer complaints

b. Number of information system upgrades completed

c. Economic value added

d. New product development time

e. Employee turnover rate

f. Percentage of products with online help manuals

g. Customer retention

h. Percentage of compensation based on performance

i. Percentage of orders filled each week

j. Gross margin growth

k. Number of new patents

l. Employee satisfaction ratings

m. Manufacturing cycle time (average length of production

process)

n. Earnings growth

o. Average machine setup time

p. Number of new customers

q. Employee promotion rate

r. Cash flow from operations

s. Customer satisfaction ratings

t. Machine downtime

u. Finished products per day per employee

v. Percentage of employees with access to upgraded

system

w. Wait time per order prior to start of production

Classify each of the preceding key performance indicators according to the balanced scorecard

perspective it address. Choose from financial perspective, customer perspective, internal

business perspective or learning and growth perspective.

helping resources/ACCT 212/Slides/MODULE 1 Managerial Accounting.pptx

MODULE 1 INTRODUCTION TO MANAGEMENT ACCOUNTING

1

Prepared by: Ms Rahayu Abdull razak

2

Prepared by: Ms Rahayu Abdull razak

.

Management accountability

Management accountability is the manager’s responsibility to the various stakeholders of the company

Management accountability requires two forms of accounting:-

Financial accounting provides financial statements that report results of operations, financial position and cash flows both to managers and to external stakeholders: owners, creditors, suppliers, customers, the governments and society.

Management or managerial accounting provides information to help manager plan and control operations as they lead the business.

3

Prepared by: Ms Rahayu Abdull razak

Managerial accounting is a field of accounting that provides economic and financial information for managers and other internal users.

Managerial accounting applies to all types of businesses.

Corporations

Proprietorships

Partnerships

Not-for-profit

Managerial Accounting Basics

4

Prepared by: Ms Rahayu Abdull razak

Comparing Managerial and Financial Accounting

Managerial Accounting Basics

5

Prepared by: Ms Rahayu Abdull razak

a. Is governed by generally accepted accounting principles.

b. Places emphasis on special-purpose information.

c. Pertains to the entity as a whole and is highly aggregated.

d. Is limited to cost data.

Managerial accounting:

Review Question

Managerial Accounting Basics

6

Prepared by: Ms Rahayu Abdull razak

Management Functions

Planning

Maximize short-term profit and market share.

Commit to environmental protection and social programs.

Add value to the business.

Directing

Controlling

Coordinate diverse activities and human resources.

Implement planned objectives.

Provide incentives to motivate employees

Hire and train employees.

Produce smooth-running operation.

Keeping activities on track.

Determine whether goals are met.

Decide changes needed to get back on track.

May use an informal or formal system of evaluations.

Managerial Accounting Basics

7

Prepared by: Ms Rahayu Abdull razak

a. Planning, directing, and selling.

b. Directing, manufacturing, and controlling.

c. Planning, manufacturing, and controlling.

d. Planning, directing, and controlling.

The management of an organization performs several broad functions. They are:

Managerial Accounting Basics

Review Question

8

Prepared by: Ms Rahayu Abdull razak

Indicate whether the following statements are true or false.

Managerial accountants have a single role within an organization, collecting and reporting costs to management.

Financial accounting reports are general-purpose and intended for external users.

Managerial accounting reports are special-purpose and issued as frequently as needed.

False

True

True

9

Prepared by: Ms Rahayu Abdull razak

Business Ethics

Managerial Accounting Basics

Business process and accounting system change.

However the need for accountants to maintain high ethical standards of professional conduct will never change.

The Institute of Management Accountants says that ethics deals with human conduct in relation to what is morally good and bad, right and wrong.

It is the application of values to decision making.

These values include honesty, fairness, responsibility, respect and compassion

10

Prepared by: Ms Rahayu Abdull razak

Business Ethics

Creating Proper Incentives

Systems and controls sometimes create incentives for managers to take unethical actions.

Controls need to be effective and realistic.

Managerial Accounting Basics

All employees are expected to act ethically.

Many organizations have codes of business ethics

11

Prepared by: Ms Rahayu Abdull razak

Business Ethics

Sarbanes-Oxley Act (SOX)

Clarifies management’s responsibilities.

Requires certifications by CEO and CFO.

Selection criteria for Board of Directors and Audit Committee.

Substantially increased penalties for misconduct.

Code of Ethical Standards

Managerial Accounting Basics

12

Prepared by: Ms Rahayu Abdull razak

IMA Code of conduct

Managerial Accounting Basics

Competence – maintain professional expertise by continually developing knowledge and skills, perform professional duty accordance with relevant laws, regulations and technical standard, provide decision support information and recommendation that are accurate, clear, concise and timely and recognize and communicate professional limitations.

Confidentiality – keep information confidential, refrain from using the confidential information and inform all relevant parties regarding appropriate use of confidential information.

Integrity – avoid conflict of interest, refrain from engaging in conduct that would be prejudice and abstain from engaging in or supporting activity that might discredit the profession.

Credibility – communicate information fairly and objectively and disclose all relevant information that can influence user decision

13

Prepared by: Ms Rahayu Abdull razak

Managers should ask questions such as the following.

What costs are involved in making a product or providing a service?

If we decrease production volume, will costs decrease?

What impact will automation have on total costs?

How can we best control costs?

Manufacturing Costs

14

Prepared by: Ms Rahayu Abdull razak

Manufacturing consists of activities and processes that convert raw materials into finished goods.

Manufacturing Costs

Manufacturing Costs

15

Prepared by: Ms Rahayu Abdull razak

Direct Materials

Raw Materials

Basic materials and parts used in manufacturing process.

Direct Materials

Raw materials that can be physically and directly associated with the finished product during the manufacturing process.

Manufacturing Costs

16

Prepared by: Ms Rahayu Abdull razak

Indirect Materials

Not physically part of the finished product or they are an insignificant part of finished product in terms of cost.

Considered part of manufacturing overhead.

Direct Materials

Manufacturing Costs

17

Prepared by: Ms Rahayu Abdull razak

Work of factory employees that can be physically and directly associated with converting raw materials into finished goods.

Indirect Labor

Work of factory employees that has no physical association with the finished product or for which it is impractical to trace costs to the goods produced.

Direct Labor

Manufacturing Costs

18

Prepared by: Ms Rahayu Abdull razak

Costs that are indirectly associated with manufacturing the finished product.

Includes all manufacturing costs except direct materials and direct labor.

Also called factory overhead, indirect manufacturing costs, or burden.

Manufacturing Overhead

Manufacturing Costs

19

Prepared by: Ms Rahayu Abdull razak

Which of the following is not an element of manufacturing overhead?

a. Sales manager’s salary.

b. Plant manager’s salary.

c. Factory repairman’s wages.

d. Product inspector’s salary.

Review Question

Manufacturing Costs

20

Prepared by: Ms Rahayu Abdull razak

Components:

Costs that are an integral part of producing the product.

Recorded in “inventory” account.

Not an expense (COGS) until the goods are sold.

Product Costs

Direct materials

Direct labor

Manufacturing overhead

Product Versus Period Costs

Period Costs

Charged to expense as incurred.

Non-manufacturing costs.

Includes all selling and administrative expenses.

21

Prepared by: Ms Rahayu Abdull razak

Product Versus Period Costs

22

Prepared by: Ms Rahayu Abdull razak

A bicycle company has these costs: tires, salaries of employees who put tires on the wheels, factory building depreciation, wheel nuts, spokes, salary of factory manager, handlebars, and salaries of factory maintenance employees. Classify each cost as direct materials, direct labor, or overhead.

Direct Materials

Tires.

Spokes.

Handlebars.

Direct Labor

Overhead

Salaries of employees who put tires on the wheels.

Factory depreciation.

Factory manager salary.

Factory maintenance employees salary.

23

Prepared by: Ms Rahayu Abdull razak

Determining the Cost of Goods Manufactured

Total Work in Process – (1) cost of beginning work in process and (2) total manufacturing costs for the current period.

Total Manufacturing Costs – sum of direct material costs, direct labor costs, and manufacturing overhead in the current year.

LO 6 Indicate how cost of goods manufactured is determined.

Illustration 1-6

Manufacturing Costs in Financial Statements

24

Prepared by: Ms Rahayu Abdull razak

Illustration 1-8

Illustration 1-7

25

Prepared by: Ms Rahayu Abdull razak

Manufacturing Costs in Financial Statements

26

Prepared by: Ms Rahayu Abdull razak

26

Illustration 1-8

Inventory accounts for a manufacturer

The balance sheet for a merchandising company shows just one category of inventory.

Balance Sheet

Manufacturing Costs in Financial Statements

27

Prepared by: Ms Rahayu Abdull razak

Illustration 1-9

Current assets sections of merchandising and manufacturing balance sheets

Balance Sheet

Manufacturing Costs in Financial Statements

28

Prepared by: Ms Rahayu Abdull razak

a. Raw materials and work in process only

b. Work in process only

c. Raw materials only

d. Raw materials, work in process, and finished goods

A cost of goods manufactured schedule shows beginning and ending inventories for:

Review Question

Manufacturing Costs in Financial Statements

29

Prepared by: Ms Rahayu Abdull razak

Illustration 1-10

Illustration: Suppose you started your own snowboard factory, KRT Boards. Here are some of the costs that your snowboard factory would incur. Assign the following costs:

Manufacturing Costs in Financial Statements

30

Prepared by: Ms Rahayu Abdull razak

Illustration 1-10

Manufacturing Costs in Financial Statements

31

Prepared by: Ms Rahayu Abdull razak

Refers to all business process associated with providing a product or service.

For a manufacturing firm these include the following:

Focus on the Value Chain

Illustration 1-12

Managerial Accounting Today

32

Prepared by: Ms Rahayu Abdull razak

The process or activities by which a company adds value to an article, including production, marketing, and the provision of after-sales service.

Definition: A value chain is the whole series of activities that create and build value at every step. The total value delivered by the company is the sum total of the value built up all throughout the company. Michael Porter developed this concept in his 1980 book 'Competitive Advantage'. Description: The significance of the value chain: The value chain concept separates useful activities (which allow the company as a whole to gain competitive advantage) from the wasteful activities (which hinder the company from getting a lead in the market). Focusing on the value-creating activities could give the company many advantages. For example, the ability to charge higher prices; lower cost of manufacture; better brand image, faster response to threats or opportunities.

What is the value chain made of? Porter defines the value chain as made of primary activities and support activities. Primary involves inbound logistics (getting the material in for adding value by processing it), operations (which are all the processes within the manufacturing), outbound (which involves distribution to the points of sale), marketing and sales (which go sell it, brand it and promote it) and service (which maintains the functionality of the product, post sales). The support functions which feed into all the primary functions are the firm infrastructure, like MIS which allows managers to monitor the environment well; Human Resource, which develops the skills needed to steer the company well; procurement to buy/ source goods at the right price, which increasingly takes importance because of difficult economic conditions and technology, which could give the firm speed, accuracy and quality. Both these allow the firm to charge a margin, which partly comes from the value addition of the primary and support functions and partly from the advantage that the company gains due to communication of the value addition to the consumer (brand image, faith, trust and so on).

Just-In-Time Inventory Methods

Inventory system in which goods are manufactured or purchased just in time for sale.

LO 8 Identify trends in managerial accounting.

Reduce defects in finished products, with the goal of zero defects.

Total Quality Management (TQM)

Managerial Accounting Today

33

Prepared by: Ms Rahayu Abdull razak

Constraints (“bottlenecks” ) limit the company’s potential profitability.

A specific approach to identify and manage these constraints in order to achieve company goals.

Theory of Constraints

LO 8 Identify trends in managerial accounting.

Software programs designed to manage all major business processes.

Enterprise Resource Planning (ERP)

Managerial Accounting Today

34

Prepared by: Ms Rahayu Abdull razak

Allocates overhead based on use of activities.

Results in more accurate product costing and scrutiny of all activities in the value chain.

LO 8 Identify trends in managerial accounting.

Activity-Based Costing (ABC)

Managerial Accounting Today

35

Prepared by: Ms Rahayu Abdull razak

Evaluates operations in an integrated fashion.

Uses both financial and non-financial measures.

Links performance to overall company objectives.

Balanced Scorecard

LO 8 Identify trends in managerial accounting.

Managerial Accounting Today

36

Prepared by: Ms Rahayu Abdull razak

Which of the following managerial accounting techniques attempts to allocate manufacturing overhead in a more meaningful manner?

Just-in-time inventory.

Total-quality management.

Balanced scorecard.

Activity-based costing.

Review Question

Managerial Accounting Today

37

Prepared by: Ms Rahayu Abdull razak

3. ______ Systems implemented to reduce defects in finished products with the goal of achieving zero defects.

1. ______ All activities associated with providing a product or service.

2. ______ A method of allocating overhead based on each product’s use of activities in making the product.

Match the descriptions that follow with the corresponding terms.

e

a

d

38

Prepared by: Ms Rahayu Abdull razak

4. ______ A performance-measurement approach that uses both financial and nonfinancial measures, tied to company objectives, to evaluate a company’s operations in an integrated fashion.

b

c

5. ______ Inventory system in which goods are manufactured or purchased just as they are needed for use.

Match the descriptions that follow with the corresponding terms.

39

Prepared by: Ms Rahayu Abdull razak

Net sales revenue$$$$$$$

Cost of goods sold:

Beginning finished goods inventory$$$$$$

Plus: Cost of goods manufactured$$$$$

Less: Ending finished goods inventory($$$$$)

Cost of goods sold$$$$$$

Gross profit$$$$$$

Selling and administrative expense$$$$$

Operating income$$$$$$

Any Manufacturing Company

Income Statement

For the year ended December 31, 2011

Sheet1

Any Manufacturing Company
Income Statement
For the year ended December 31, 2011
Net sales revenue $$$$$$$
Cost of goods sold:
Beginning finished goods inventory $$$$$$
Plus: Cost of goods manufactured $$$$$
Less: Ending finished goods inventory ($$$$$)
Cost of goods sold $$$$$$
Gross profit $$$$$$
Selling and administrative expense $$$$$
Operating income $$$$$$

Sheet2

Sheet3

helping resources/ACCT 212/Slides/MODULE 2 Job Order Costing, Process Costing and Activity Based Costing.pptx

MODULE 2 Process costing, Job order costing and Activity based Costing

1

Prepared by: Ms Rahayu Abdull razak

Cost Accounting involves:

Measuring, Recording, and Reporting product costs.

The cost accounting system typically includes two processes:-

1. Cost accumulation: Collecting costs by some natural classification such as materials or labor or by activities performed such as order processing or machine processing.

2. Cost assignment: Attaching costs to one or more cost objects, such as activities, processes, departments, customers or products.

Three basic types: (1) a job order cost system and (2) a process cost system and (3) ABC

Cost Accounting Systems

2

Prepared by: Ms Rahayu Abdull razak

Job Order Cost System

Costs are assigned to each job or batch.

Key feature: Each job or batch has its own distinguishing characteristics.

Objective: Compute the cost per job.

Measures costs for each job completed – not for set time periods.

Cost Accounting Systems

3

Prepared by: Ms Rahayu Abdull razak

Cost Accounting Systems

4

Prepared by: Ms Rahayu Abdull razak

Advantages

More precise in assignment of costs to projects than process costing.

Provides more useful information for determining the profitability of particular projects and for estimating costs when preparing bids on future jobs.

LO 5 Prepare entries for jobs completed and sold.

Disadvantage

Requires a significant amount of data entry.

Job Order Cost Flow

5

Prepared by: Ms Rahayu Abdull razak

The cost flow parallels the physical flow of the materials as they are converted into finished goods

Manufacturing costs are assigned to Work in Process (WIP).

Cost of completed jobs is transferred to Finished Goods.

When units are sold, the cost is transferred to Cost of Goods Sold.

Job Order Cost Flow

6

Prepared by: Ms Rahayu Abdull razak

LO 5

Job Order Cost Flow

Summary

7

Prepared by: Ms Rahayu Abdull razak

Accumulating Manufacturing Costs

Raw Material Costs

Job Order Cost Flow

Journal entry when company purchase direct material and indirect material.

When materials are used,

direct material costs go directly into the Work in process inventory account.

Indirect materials are debited to manufacturing overhead.

For both direct materials and indirect materials, the production team completes a document called a materials requisition to request the transfer of materials to the production floor.

8

Prepared by: Ms Rahayu Abdull razak

S01 – 09/09/2015

S02 – 09/09/2015

Accumulating Manufacturing Costs

Labor Costs

Job Order Cost Flow

Incurrence of labor cost -assign labor cost to individual jobs.

Assignment of labor cost to jobs –

Direct labor - transfer labor cost out of the Manufacturing wages account and into Work in process inventory

Indirect labor – transfer into Manufacturing overhead

9

Prepared by: Ms Rahayu Abdull razak

Many types of overhead costs

For example, property taxes, depreciation, insurance, and repairs.

Costs unrelated to manufacturing process are expensed.

Costs related to manufacturing process are accumulated in Manufacturing Overhead.

Manufacturing overhead subsequently assigned to work in process.

Job Order Cost Flow

Manufacturing Overhead Costs

10

Prepared by: Ms Rahayu Abdull razak

Relates to production operations as a whole.

Cannot be assigned to specific jobs based on actual costs incurred.

Companies assign to work in process and to specific jobs on an estimated basis through the use of a …

Manufacturing Overhead Costs

Predetermined Overhead Rate

Job Order Cost Flow

11

Prepared by: Ms Rahayu Abdull razak

Based on the relationship between estimated annual overhead costs and expected annual operating activity

Expressed in terms of an activity base such as

Direct labor costs

Direct labor hours

Machine hours

Any other activity that is an equitable base for applying overhead costs to jobs

Job Order Cost Flow

Predetermined Overhead Rate

12

Prepared by: Ms Rahayu Abdull razak

Established at the beginning of the year.

Formula for computing the predetermined rate overhead rate is

Job Order Cost Flow

Predetermined Overhead Rate

13

Prepared by: Ms Rahayu Abdull razak

Assigned to Work in Process during the period to get timely information about the cost of a completed job.

Job Order Cost Flow

Manufacturing Overhead Costs

To allocate overhead to jobs, the application rate is multiplied by the actual quantity of allocation base used on the job.

14

Prepared by: Ms Rahayu Abdull razak

Assigning Costs to Finished Goods

LO 5

When a job is completed, the costs are summarized and the job cost sheet is completed.

Job Order Cost Flow

15

Prepared by: Ms Rahayu Abdull razak

LO 5 Prepare entries for jobs completed and sold.

Job Order Cost Flow

Summary

16

Prepared by: Ms Rahayu Abdull razak

LO 6 Distinguish between under- and overapplied manufacturing overhead.

Under- or Overapplied Overhead

A debit balance in manufacturing overhead means that overhead is underapplied.

A credit balance in manufacturing overhead means that overhead is overapplied.

Illustration 2-19

Reporting Job Cost Data

17

Prepared by: Ms Rahayu Abdull razak

Any Year-End Balance in manufacturing overhead is eliminated by adjusting cost of goods sold.

Underapplied overhead is debited to COGS

Overapplied overhead is credited to COGS

LO 6 Distinguish between under- and overapplied manufacturing overhead.

Reporting Job Cost Data

Under- or Overapplied Overhead

18

Prepared by: Ms Rahayu Abdull razak

Refer to handout exercise

Reporting Job Cost Data

19

Prepared by: Ms Rahayu Abdull razak

Use to apply costs to similar products that are mass-produced in a continuous fashion

Examples include the production of Cereal, Paint, Manufacturing Steel, Oil Refining and Soft Drinks

Illustration 3-1

Uses of Process Cost Systems

Nature of Process Cost Systems

20

Prepared by: Ms Rahayu Abdull razak

Illustration 3-2

Process and Job Cost Comparison

Nature of Process Cost Systems

21

Prepared by: Ms Rahayu Abdull razak

Which of the following items is not a characteristic of a process cost system:

a. Once production begins, it continues until the finished product emerges.

b. The focus is on continually producing homogenous products.

c. When the finished product emerges, all units have precisely the same amount of materials, labor, and overhead.

d. The products produced are heterogeneous in nature.

Review Question

Nature of Process Cost Systems

22

Prepared by: Ms Rahayu Abdull razak

Similarities and Differences Between Job Order Cost and Process Cost Systems

Job Order Cost

Costs assigned to each job.

Products have unique characteristics.

Process Cost

Costs tracked through a series of connected manufacturing processes or departments.

Products are uniform or relatively homogeneous and produced in a large volume.

Nature of Process Cost Systems

23

Prepared by: Ms Rahayu Abdull razak

Similarities

Manufacturing cost elements.

Accumulation of the costs of materials, labor, and overhead.

Flow of costs.

Number of work in process accounts used.

Documents used to track costs.

Point at which costs are totaled.

Unit cost computations.

Differences

Nature of Process Cost Systems

24

Prepared by: Ms Rahayu Abdull razak

Both a job order and a process cost system track the same three manufacturing cost elements – direct materials, direct labor, and manufacturing overhead.

b. In a job order cost system, only one work in process account is used, whereas in a process cost system, multiple work in process accounts are used.

c. Manufacturing costs are accumulated the same way in a job order and in a process cost system.

d. Manufacturing costs are assigned the same way in a job order and in a process cost system.

Indicate which of the following statements is not correct:

Review Question

Nature of Process Cost Systems

25

Prepared by: Ms Rahayu Abdull razak

Process Cost Flow

.

Nature of Process Cost Systems

There are two methods for handling process costing: weighted average and FIFO.

Two building blocks for process costing using weighted average:

Conversion costs – combining direct labor and manufacturing overhead. It is called conversion cost because this cost is involved in converting raw materials into finished goods.

Equivalent units of production - allows us to measure the amount of work done on a partially finished group of units during a period and to express it in terms of fully complete units of output.

26

Prepared by: Ms Rahayu Abdull razak

Process Cost Flow

.

Nature of Process Cost Systems

In process costing, all units go through the same production process and therefore, have the same unit cost.

Each process requires the use of a separate Work in process inventory account.

Costs are collected by process (or department).

The costs accumulate until all costs have been added to the product, and it is sent to finished goods.

27

Prepared by: Ms Rahayu Abdull razak

Process Cost Flow

Nature of Process Cost Systems

28

Prepared by: Ms Rahayu Abdull razak

Summarize the flow of physical units

Compute the cost per equivalent unit

Assign costs to completed and ending inventory units

Compute output in equivalent units

Refer to handout exercise

Reporting process Cost Data

29

Prepared by: Ms Rahayu Abdull razak

Allocates overhead using a single predetermined rate.

Job order costing: direct labor cost may be the relevant activity base.

Process costing: machine hours may be the relevant activity base.

Assumption was satisfactory when direct labor was a major portion of total manufacturing costs.

Wide acceptance of a high correlation between direct labor and overhead costs.

Traditional Costing Systems

Traditional Costing and Activity-Based Costing

30

Prepared by: Ms Rahayu Abdull razak

Activity-Based Costing

Allocates overhead to multiple activity cost pools and

Assigns the activity cost pools to products or services by means of cost drivers.

Traditional Costing and Activity-Based Costing

The business environment has become more complex.

This has led to the most significant improvement in cost accounting system design – activity-based costing (ABC).

31

Prepared by: Ms Rahayu Abdull razak

Activity-Based Costing

Activity: any event, action, transaction, or work sequence that causes a cost to be incurred in producing a product or providing a service.

Activity Cost Pool: a distinct type of activity. For example: ordering materials or setting up machines.

Cost Drivers: any factors or activities that have a direct cause-effect relationship with the resources consumed.

Traditional Costing and Activity-Based Costing

32

Prepared by: Ms Rahayu Abdull razak

Activity-Based Costing

ABC allocates overhead costs in two stages:

Stage 1: Overhead costs are allocated to activity cost pools.

Stage 2: Assigns overhead allocated to the activity cost pools to products, using cost drivers.

The more complex a product’s manufacturing operation, the more activities and cost drivers are likely to be present.

Traditional Costing and Activity-Based Costing

33

Prepared by: Ms Rahayu Abdull razak

Activity-Based Costing

Illustration 4-2

Activities and related cost drivers

Traditional Costing and Activity-Based Costing

34

Prepared by: Ms Rahayu Abdull razak

Activity-Based Costing

Illustration 4-3

ABC system design—Lift Jack Company

Traditional Costing and Activity-Based Costing

35

Prepared by: Ms Rahayu Abdull razak

Indicate whether the following statements are true or false.

A traditional costing system allocates overhead by means of multiple overhead rates.

Activity-based costing allocates overhead costs in a two-stage process.

Direct material and direct labor costs are easier to trace to products than overhead.

As manufacturing processes have become more automated, more companies have chosen to allocate overhead on the basis of direct labor costs.

In activity-based costing, an activity is any event, action, transaction, or work sequence that incurs cost when producing a product.

Solution: 1. false. 2. true. 3. true. 4. false. 5. true.

36

Prepared by: Ms Rahayu Abdull razak

Activity-Based Costing

Involves the following four steps.

Identify and classify the activities involved in the manufacture of specific products, and allocate overhead to cost pools.

Identify the cost driver that has a strong correlation to the costs accumulated in the cost pool.

Compute the activity-based overhead rate for each cost driver.

Assign overhead costs to products, using the overhead rates determined for each cost pool (cost per driver).

Example of ABC Versus Traditional Costing

37

Prepared by: Ms Rahayu Abdull razak

Atlas Company produces two products (abdominal trainers):

Ab Bench: a high volume item with sales totaling 25,000 units annually.

Ab Coaster: a low volume item with sales totaling 5,000 units annually.

Each product requires 1 hour of direct labor.

Total annual direct labor hours (DLH) 30,000 (25,000 + 5,000)

Direct labor cost $12 per unit for each product

Expected annual manufacturing overhead costs $900,000.

Direct materials cost:

Ab Bench - $40 per unit

Ab Coaster - $30 per unit

Illustration:

Required: Calculate unit costs under ABC.

Example of ABC Versus Traditional Costing

Identify and Classify Activities and Allocate

Overhead to Cost Pools (Step 1)

Illustration 4-4

Overhead costs are assigned directly to the appropriate activity cost pool.

Example of ABC Versus Traditional Costing

39

Prepared by: Ms Rahayu Abdull razak

Identify Cost Drivers (Step 2)

Cost driver must accurately measure the actual consumption of the activity by the various products. In assigning overhead costs, it is necessary to know the expected use of cost drivers for each product. Because of its low volume, Ab Coaster requires more set-ups and inspections than Ab Bench

Example of ABC Versus Traditional Costing

40

Prepared by: Ms Rahayu Abdull razak

Compute Overhead Rates (Step 3)

Illustration 4-6

Illustration 4-7

Next, the company computes an activity-based overhead rate per cost driver.

Example of ABC Versus Traditional Costing

41

Prepared by: Ms Rahayu Abdull razak

Assign Overhead Cost to Products (Step 4)

To assign overhead costs, Atlas multiplies the activity-based overhead rates per cost driver by the number of cost drivers expected to be used per product

Example of ABC Versus Traditional Costing

42

Prepared by: Ms Rahayu Abdull razak

Assign Overhead Cost to Products (Step 4)

To assign overhead costs, Atlas multiplies the activity-based overhead rates per cost driver by the number of cost drivers expected to be used per product .

Example of ABC Versus Traditional Costing

43

Prepared by: Ms Rahayu Abdull razak

Example of ABC Versus Traditional Costing

Calculate cost per products.

44

Prepared by: Ms Rahayu Abdull razak

Casey Company has five activity cost pools and two products. It expects to produce 200,000 units of its automobile scissors jack and 80,000 units of its truck hydraulic jack. Having identified its activity cost pools and the cost drivers for each cost pool, Casey Company accumulated the following data relative to those activity cost pools and cost drivers.

45

Prepared by: Ms Rahayu Abdull razak

Casey Company has five activity cost pools and two products. It expects to produce 200,000 units of its automobile scissors jack and 80,000 units of its truck hydraulic jack. Having identified its activity cost pools and the cost drivers for each cost pool, Casey Company accumulated the following data relative to those activity cost pools and cost drivers.

Using the above data, do the following.

Prepare a schedule showing the computations of the activity-based overhead rates per cost driver.

Prepare a schedule assigning each activity’s overhead cost to the two products.

Compute the overhead cost per unit for each product.

Comment on the comparative overhead cost per unit.

46

Prepared by: Ms Rahayu Abdull razak

Prepare a schedule showing the computations of the activity-based overhead rates per cost driver.

47

Prepared by: Ms Rahayu Abdull razak

Prepare a schedule assigning each activity’s overhead cost to the two products.

48

Prepared by: Ms Rahayu Abdull razak

c. Compute the overhead cost per unit for each product.

These data show that the total overhead assigned to 80,000 hydraulic jacks exceeds the overhead assigned to 200,000 scissors jacks. The overhead cost per hydraulic jack is $34.25. It is only $12.80 per scissors jack.

d. Comment on the comparative overhead cost per unit.

49

Prepared by: Ms Rahayu Abdull razak

More accurate product costing through:

Use of more cost pools to assign overhead costs.

Enhanced control over overhead costs.

Better management decisions.

Benefits of ABC

Can be expensive to use.

Some arbitrary allocations continue.

Limitations of ABC

Activity-Based Costing: A Closer Look

Value-Added Versus Non–Value-Added Activities

Activity Based Management (ABM):

An extension of ABC from a product costing system to a management function that focuses on reducing costs and improving processes and decision making.

Value-added activities

Non–value-added activities

Activity-Based Costing: A Closer Look

51

Prepared by: Ms Rahayu Abdull razak

19

Total estimated manufacturing overhead costsTotal estimated quantity of the manufacturing overhead allocation base

Primary cost driver of overhead costs

Examples: Direct labor hoursDirect labor costMachine hours

Copyright (c) 2009 Prentice Hall. All rights reserved.

19

Predetermined Manufacturing Overhead Rate

Total estimated manufacturing overhead costs

Total estimated quantity of the manufacturing

overhead allocation base

Primary cost driver of overhead costs

Examples:

Direct labor hours

Direct labor cost

Machine hours

Copyright (c) 2009 Prentice Hall. All rights reserved.

19

The most accurate allocation can be made only when total overhead cost is known—and that is not until the end of the year. But managers cannot wait that long for product cost information. So the predetermined overhead rate is calculated before the year begins. Then throughout the year, companies use this predetermined rate to allocate estimated overhead cost to individual jobs.

The key to assigning indirect manufacturing costs to jobs is to identify a workable manufacturing overhead allocation base. The allocation base is a common denominator that links overhead costs to the products. Ideally, the allocation base is the primary cost driver of manufacturing overhead—that is, the more “allocation base,” the more overhead costs and vice-versa. As the phrase implies, a cost driver is the primary factor that causes (drives) a cost. Traditionally, manufacturing companies have used:

• Direct labor hours (for labor-intensive production environments)

• Direct labor cost (for labor-intensive production environments)

• Machine hours (for machine-intensive production environments)

20

Allocated manufacturing overhead costActual quantity of allocation base used on the jobPredetermined overhead application rate

Copyright (c) 2009 Prentice Hall. All rights reserved.

Allocate Overhead Costs to Jobs

20

Allocated manufacturing overhead cost

Actual quantity of allocation base used on the job

Predetermined overhead application rate

Copyright (c) 2009 Prentice Hall. All rights reserved.

To allocate overhead to jobs, the application rate is multiplied by the actual quantity of allocation base used on the job. So, if the overhead application rate is based on direct labor hours, the rate is multiplied by the direct labor hours used on each job.

20

helping resources/ACCT 212/Slides/MODULE 3 Cost Behavior and CVP Analysis.pptx

MODULE 3 COST VOLUME PROFIT (CVP) ANALYSIS

1

Prepared by: Ms Rahayu Abdull Razak

Cost Behavior Analysis is the study of how specific costs respond to changes in the level of business activity.

Some costs change; others remain the same.

Helps management plan operations and decide between alternative courses of action.

Applies to all types of businesses and entities.

Starting point is measuring key business activities.

Cost Behavior Analysis

Cost Behavior Analysis is the study of how specific costs respond to changes in the level of business activity.

Activity levels may be expressed in terms of:

Sales dollars (in a retail company)

Miles driven (in a trucking company)

Room occupancy (in a hotel)

Dance classes taught (by a dance studio)

Many companies use more than one measurement base.

Cost Behavior Analysis

Cost Behavior Analysis is the study of how specific costs respond to changes in the level of business activity.

Changes in the level or volume of activity should be correlated with changes in costs.

Activity level selected is called activity or volume index.

Activity index:

Identifies the activity that causes changes in the behavior of costs.

Allows costs to be classified as variable, fixed, or mixed.

Cost Behavior Analysis

Variable Costs

Cost Behavior Analysis

Costs that vary in total directly and proportionately with changes in the activity level.

Cost that increase or decrease in total as the volume of activity increases or decreases.

Total variable costs increase as activity increases, but the variable cost per unit does not change.

Example: If the activity level increases 10 percent, total variable costs increase 10 percent.

Example: If the activity level decreases by 25 percent, total variable costs decrease by 25 percent.

Illustration: Damon Company manufactures tablet computers that contain a $10 camera. The activity index is the number of

tablets produced. As Damon manufactures each tablet, the total cost of the camera increases by $10.

Cost Behavior Analysis

Units produced Direct materials cost per unit Total direct materials cost
2000 $10 $20,000
4000 $10 40,000
6000 $10 60,000
8000 $10 80,000
10,000 $10 100,000

The illustration shows, total cost of the cameras will be $20,000 if Damon produces 2,000 tablets, and $100,000 when it produces 10,000 tablets. We also can see that a variable cost remains the same per unit as the level of activity changes.

Illustration 5-1

Cost Behavior Analysis

Fixed Costs

Costs that remain the same in total regardless of changes in the activity level.

Per unit cost varies inversely with activity: As volume increases, unit cost declines, and vice versa

Examples:

Property taxes

Insurance

Rent

Depreciation on buildings and equipment

Cost Behavior Analysis

8

Prepared by: Ms Rahayu Abdull Razak

Illustration: Damon Company leases its productive facilities at a cost of $10,000 per month. Total fixed costs of the facilities will remain constant at every level of activity, as part of Illustration shows.

Cost Behavior Analysis

Illustration: Damon Company leases its productive facilities at a cost of $10,000 per month. Total fixed costs of the facilities will remain constant at every level of activity. But, on a per unit basis, the cost of rent will decline as activity increases. At 2,000 units, the unit cost per tablet computer is $5 ($10,000 ÷ 2,000). When Damon produces 10,000 tablets, the unit cost is only $1 ($10,000 ÷ 10,000).

Cost Behavior Analysis

Variable costs are costs that:

a. Vary in total directly and proportionately with changes in the activity level.

b. Remain the same per unit at every activity level.

c. Neither of the above.

d. Both (a) and (b) above.

Review Question

Cost Behavior Analysis

11

Prepared by: Ms Rahayu Abdull Razak

Costs that have both a variable cost element and a fixed cost element.

Mixed Costs

Cost Behavior Analysis

Change in total but not proportionately with changes in activity level.

Helena Company, reports the following total costs at two levels of production.

Classify each cost as variable, fixed, or mixed.

Variable

Fixed

Mixed

13

Prepared by: Ms Rahayu Abdull Razak

High-Low Method

Mixed costs must be classified into their fixed and variable elements.

High-Low Method uses the total costs incurred at both the high and the low levels of activity to classify mixed costs.

The difference in costs between the high and low levels represents variable costs, since only variable costs change as activity levels change.

Cost Behavior Analysis

STEP 1: Determine variable cost per unit using the following formula:

Cost Behavior Analysis

High-Low Method

STEP 2: Determine the fixed cost by subtracting the total variable cost at either the high or the low activity level from the total cost at that level.

STEP 3: An equation is formulated to show the cost behavior

Illustration: Metro Transit Company has the following maintenance costs and mileage data for its fleet of buses over a 6-month period.

Change in Costs

(63,000 - 30,000) $33,000

High minus Low

(50,000 - 20,000) 30,000

=

$1.10

cost per unit

Cost Behavior Analysis

High-Low Method

STEP 2: Determine the fixed cost by subtracting the total variable cost at either the high or the low activity level from the total cost at that level.

Cost Behavior Analysis

High-Low Method

Maintenance costs are therefore $8,000 per month plus $1.10 per mile. This is represented by the following formula:

Maintenance costs = Fixed costs + ($1.10 x Miles driven)

Example: At 45,000 miles, estimated maintenance costs would be:

Fixed

$ 8,000

Variable

($1.10 x 45,000) 49,500

$57,500

Cost Behavior Analysis

High-Low Method

Mixed costs consist of a:

a. Variable cost element and a fixed cost element.

b. Fixed cost element and a controllable cost element.

c. Relevant cost element and a controllable cost element.

d. Variable cost element and a relevant cost element.

Cost Behavior Analysis

Review Question

19

Prepared by: Ms Rahayu Abdull Razak

Byrnes Company accumulates the following data concerning a mixed cost, using units produced as the activity level.

Compute the variable and fixed cost elements using the high-low method.

Estimate the total cost if the company produces 6,000 units.

20

Prepared by: Ms Rahayu Abdull Razak

Compute the variable and fixed cost elements using the high-low method.

Variable cost: ($14,740 - $11,100) / (9,800 - 7,000) = $1.30 per unit

Fixed cost: $14,740 - $12,740 ($1.30 x 9,800 units) = $2,000

or $11,100 - $9,100 ($1.30 x 7,000) = $2,000

21

Prepared by: Ms Rahayu Abdull Razak

Estimate the total cost if the company produces 6,000 units.

Total cost (6,000 units): $2,000 + $7,800 ($1.30 x 6,000) = $9,800

22

Prepared by: Ms Rahayu Abdull Razak

Cost-volume-profit (CVP) analysis is the study of the effects of changes of costs and volume on a company’s profits.

Important in profit planning

Critical factor in management decisions as

Setting selling prices,

Determining product mix, and

Maximizing use of production facilities.

Cost-Volume-Profit Analysis

Illustration 5-9

Cost-Volume-Profit Analysis

Basic Components

Basic Components - Assumptions

Behavior of both costs and revenues is linear throughout the relevant range of the activity index.

All costs can be classified as either variable or fixed with reasonable accuracy.

Changes in activity are the only factors that affect costs.

All units produced are sold.

When more than one type of product is sold, the sales mix will remain constant.

Cost-Volume-Profit Analysis

Which of the following is NOT involved in CVP analysis?

a. Sales mix.

b. Unit selling prices.

c. Fixed costs per unit.

d. Volume or level of activity.

Cost-Volume-Profit Analysis

Review Question

26

Prepared by: Ms Rahayu Abdull Razak

A statement for internal use.

Classifies costs and expenses as fixed or variable.

Reports contribution margin in the body of the statement.

Contribution margin – amount of revenue remaining after deducting variable costs.

Reports the same net income as a traditional income statement.

CVP Income Statement

Cost-Volume-Profit Analysis

Illustration: Vargo Video produces a high-definition digital camcorder with 15x optical zoom and a wide-screen, high-resolution LCD monitor. Relevant data for the camcorders sold by this company in June 2014 are as follows.

Cost-Volume-Profit Analysis

CVP Income Statement

Cost-Volume-Profit Analysis

CVP Income Statement

Illustration: The CVP income statement for Vargo Video therefore would be reported as follows.

Contribution margin is available to cover fixed costs and to contribute to income.

Formula for contribution margin per unit and the computation for Vargo Video are:

Cost-Volume-Profit Analysis

Contribution Margin per Unit

Vargo’s CVP income statement assuming a zero net income.

Cost-Volume-Profit Analysis

Contribution Margin per Unit

Assume that Vargo sold one more camcorder, for a total of 1,001 camcorders sold.

Cost-Volume-Profit Analysis

Contribution Margin per Unit

Shows the percentage of each sales dollar available to apply toward fixed costs and profits.

Formula for contribution margin ratio and the computation for Vargo Video are:

Cost-Volume-Profit Analysis

Contribution Margin Ratio

Assume Vargo Video’s current sales are $500,000 and it wants to know the effect of a $100,000 (200-unit) increase in sales.

Illustration 5-18

Cost-Volume-Profit Analysis

Contribution Margin Ratio

Contribution margin:

a. Is revenue remaining after deducting variable costs.

b. May be expressed as contribution margin per unit.

c. Is selling price less cost of goods sold.

d. Both (a) and (b) above.

Cost-Volume-Profit Analysis

Review Question

35

Prepared by: Ms Rahayu Abdull Razak

Process of finding the break-even point level of activity at which total revenues equal total costs (both fixed and variable).

Can be computed or derived

from a mathematical equation,

by using contribution margin, or

from a cost-volume profit (CVP) graph.

Expressed either in sales units or in sales dollars.

Cost-Volume-Profit Analysis

Break-Even Analysis

Computation of break-even point in units.

Break-Even Analysis

Mathematical Equation/income statement

Break-even occurs where total sales equal variable costs plus fixed costs; i.e., net income is zero

At the break-even point, contribution margin must equal total fixed costs

(CM = total revenues – variable costs)

Break-even point can be computed using either contribution margin per unit or contribution margin ratio.

Break-Even Analysis

Contribution Margin Technique

When the BEP in units is desired, contribution margin per unit is used in the following formula which shows the computation for Vargo Video:

Break-Even Analysis

Contribution Margin Technique

When the BEP in dollars is desired, contribution margin ratio is used in the following formula which shows the computation for Vargo Video:

Break-Even Analysis

Contribution Margin Technique

Because this graph also shows costs, volume, and profits, it is referred to as a cost-volume-profit (CVP) graph.

Graphic Presentation

Break-Even Analysis

Gossen Company is planning to sell 200,000 pliers for $4 per unit. The contribution margin ratio is 25%. If Gossen will break even at this level of sales, what are the fixed costs?

a. $100,000.

b. $160,000.

c. $200,000.

d. $300,000.

Review Question

Break-Even Analysis

42

Prepared by: Ms Rahayu Abdull Razak

Level of sales necessary to achieve a specified income.

Can be determined from each of the approaches used to determine break-even sales/units:

from a mathematical equation,

by using contribution margin, or

from a cost-volume profit (CVP) graph.

Expressed either in sales units or in sales dollars.

Target Net Income

Cost-Volume-Profit Analysis

Sales necessary to achieve a specified level of income.

Mathematical Equation

Cost-Volume-Profit Analysis

Target Net Income

Formula for required sales to meet target net income.

Using the formula for the break-even point, simply include the desired net income as a factor.

Target Net Income

Mathematical Equation

Target Net Income

To determine the required sales in units for Vargo Video:

Contribution Margin Technique

Target Net Income

To determine the required sales in dollars for Vargo Video:

Contribution Margin Technique

The mathematical equation for computing required sales to obtain target net income is:

Required sales =

a. Variable costs + Target net income.

b. Variable costs + Fixed costs + Target net income.

c. Fixed costs + Target net income.

d. No correct answer is given.

Review Question

Target Net Income

48

Prepared by: Ms Rahayu Abdull Razak

Difference between actual or expected sales and sales at the break-even point.

Measures the “cushion” that management has if expected sales fail to materialize.

May be expressed in dollars or as a ratio.

Assuming actual/expected sales are $750,000:

Cost-Volume-Profit Analysis

Margin of Safety

Computed by dividing the margin of safety in dollars by the actual or expected sales.

Assuming actual/expected sales are $750,000:

The higher the dollars or percentage, the greater the margin of safety.

Cost-Volume-Profit Analysis

Margin of Safety

Marshall Company had actual sales of $600,000 when break-even sales were $420,000. What is the margin of safety ratio?

a. 25%.

b. 30%.

c. 33 1/3%.

d. 45%.

Review Question

Cost-Volume-Profit Analysis

51

Prepared by: Ms Rahayu Abdull Razak

Zootsuit Inc. makes travel bags that sell for $56 each. For the coming year, management expects fixed costs to total $320,000 and variable costs to be $42 per unit. Compute the following: (a) break-even point in dollars using the contribution margin (CM) ratio; (b) the margin of safety assuming actual sales are $1,382,400; and (c) the sales dollars required to earn net income of $410,000.

52

Prepared by: Ms Rahayu Abdull Razak

Compute: (a) break-even point in dollars using the contribution margin (CM) ratio.

Unit selling price $56

Unit variable costs - 42

Contribution margin per unit 14

Unit selling price 56

Contribution margin ratio 25%

Fixed costs $320,000

Contribution margin ratio 25%

Break-even sales in dollars $1,280,000

53

Prepared by: Ms Rahayu Abdull Razak

Actual (Expected) sales $ 1,382,400

Break-even sales - 1,280,000

Margin of safety in dollars 102,400

Actual (Expected) sales 1,382,400

Margin of safety ratio 7.4%

Compute: (b) the margin of safety assuming actual sales are $1,382,400.

54

Prepared by: Ms Rahayu Abdull Razak

Fixed costs $ 320,000

Target net income + 410,000

730,000

Contribution margin ratio 25%

Required sales in dollars $2,920,000

Compute: (c) the sales dollars required to earn net income of $410,000.

55

Prepared by: Ms Rahayu Abdull Razak

Blue Diamond, Inc. sold 20,000 units and recorded sales of $800,000 for the first quarter of 2014. In making the sales, the company incurred the following costs and expenses.

Prepare a CVP income statement for the quarter ended March 31, 2014.

Compute the contribution margin per unit.

Compute the contribution margin ratio.

56

Prepared by: Ms Rahayu Abdull Razak

(a) Prepare a CVP income statement for the quarter ended March 31, 2014.

57

Prepared by: Ms Rahayu Abdull Razak

÷ 20,000 = $40.00

÷ 20,000 = $21.60

$18.40

Per unit

(b) Compute the contribution margin per unit.

58

Prepared by: Ms Rahayu Abdull Razak

÷ 800,000 = 46%

or,

$18.40 ÷ $40 = 46%

(c) Compute the contribution margin ratio.

59

Prepared by: Ms Rahayu Abdull Razak

Illustration: Original camcorder sales and cost data for Vargo Video:

Cost-Volume-Profit (CVP) –sensitivity analysis

CVP and Changes in the Business Environment

Case I: A competitor is offering a 10% discount on the selling price of its camcorders. Management must decide whether to offer a similar discount.

Question: What effect will a 10% discount on selling price ($500 x 10% = $50) have on the breakeven point?

Cost-Volume-Profit (CVP) Review

CVP and Changes in the Business Environment

Case II: Management invests in new robotic equipment that will lower the amount of direct labor required to make camcorders. Estimates are that total fixed costs will increase 30% and that variable cost per unit will decrease 30%.

Question: What effect will the new equipment have on the sales volume required to break even?

Cost-Volume-Profit (CVP) Review

CVP and Changes in the Business Environment

S2 - 20151101

Variable cost per unit increases to $325 ($300 + $25).

Fixed costs are reduced to $182,500 ($200,000 - $17,500).

Contribution margin per unit becomes $175 ($500 - $325).

Case III:

Cost-Volume-Profit (CVP) Review

CVP and Changes in the Business Environment

Summary

Cost-Volume-Profit (CVP)

64

Prepared by: Ms Rahayu Abdull Razak

Croc Catchers calculates its contribution margin to be less than zero. Which statement is true?

a. Its fixed costs are less than the variable cost per unit.

b. Its profits are greater than its total costs.

c. The company should sell more units.

Its selling price is less than its variable costs.

Review Question

Cost-Volume-Profit (CVP) Review

65

Prepared by: Ms Rahayu Abdull Razak

Break-Even Sales in Units

Sales mix is the relative percentage in which a company sells its products.

If a company’s unit sales are 80% printers and 20% computers, its sales mix is 80% to 20%.

Sales mix is important because different products often have very different contribution margins.

Sales Mix

Companies can compute break-even sales for a mix of two or more products by determining the weighted-average unit contribution margin of all the products.

Illustration: Vargo Video sells not only camcorders but TV sets as well. Vargo sells its two products in the following amounts: 1,500 camcorders and 500 TVs. The sales mix, expressed as a function of total units sold, is as follows.

Sales Mix

Break-Even Sales in Units

Additional information related to Vargo Video.

Sales Mix

Break-Even Sales in Units

First, determine the weighted-average contribution margin.

Sales Mix

Break-Even Sales in Units

Second, use the weighted-average unit contribution margin to compute the break-even point in units

Sales Mix

Break-Even Sales in Units

With a break-even point of 1,000 units, Vargo must sell:

750 Camcorders (1,000 units x 75%)

250 TVs (1,000 units x 25%)

At this level, the total contribution margin will equal the fixed costs of $275,000.

Sales Mix

Break-Even Sales in Units

Works well if the company has many products.

Calculates break-even point in terms of sales dollars for

divisions or

product lines,

NOT individual products.

Sales Mix

Break-Even Sales in Dollars

Illustration: Kale Garden Supply Company has two divisions.

Illustration 6-18

Sales Mix

Break-Even Sales in Dollars

Illustration 6-19

First, determine the weighted-average contribution margin.

Illustration 6-20

Second, calculate break-even point in dollars.

Illustration 6-21

Sales Mix

Break-Even Sales in Dollars

With break-even sales of $937,500 and a sales mix of 20% to 80%, Kale must sell:

$187,500 from the Indoor Plant division

$750,000 from the Outdoor Plant division

If the sales mix becomes 50% to 50%, the weighted average contribution margin ratio changes to 35%, resulting in a lower break-even point of $857,143.

Sales Mix

Break-Even Sales in Dollars

Net income will be:

a. Greater if more higher-contribution margin units are sold than lower-contribution margin units.

b. Greater is more lower-contribution margin units are sold than higher-contribution margin units.

c. Equal as song as total sales remain equal, regardless of which products are sold.

d. Unaffected by changes in the mix of products sold.

Review Question

Sales Mix

76

Prepared by: Ms Rahayu Abdull Razak

Copyright (c) 2009 Prentice Hall. All rights reserved33

CauseEffectResultChangeContributionmarginBreakeven pointSellingprice increasesIncreaseDecreaseSelling price decreasesDecreaseIncreaseVariable cost per unit increasesDecreaseIncreaseVariable cost per unit decreasesIncreaseDecreaseFixed costs increaseNoeffectIncrease Fixed costs decreaseNo effectDecrease

Sensitivity Analysis

Copyright (c) 2009 Prentice Hall. All rights reserved

33

Cause Effect Result
Change Contribution margin Breakeven point
Selling price increases Increase Decrease
Selling price decreases Decrease Increase
Variable cost per unit increases Decrease Increase
Variable cost per unit decreases Increase Decrease
Fixed costs increase No effect Increase
Fixed costs decrease No effect Decrease

This table summarizes the effect of changes in selling price, variable costs per unit, and fixed costs on both the contribution margin and breakeven point. Notice the inverse relationship between contribution margin and breakeven point on the first four lines of the table.

helping resources/ACCT 212/Slides/MODULE 4 Short Term Business Decision.pptx

MODULE 4 SHORT TERM BUSINESS DECISION

1

Prepared by: Ms Rahayu Abdull Razak

Making decisions is an important management function.

Does not always follow a set pattern.

Decisions vary in scope, urgency, and importance.

Steps usually involved in process include:

Illustration 7-1

Management’s Decision-Making Process

In making business decisions,

Considers both financial and non-financial information.

Financial information

Revenues and costs, and

Effect on overall profitability.

Non-financial information

Effect on employee turnover

The environment

Overall company image.

Management’s Decision-Making Process

Decisions involve a choice among alternative actions.

Process used to identify the financial data that change under alternative courses of action.

Both costs and revenues may vary or

Only revenues may vary or

Only costs may vary

Incremental Analysis Approach

Management’s Decision-Making Process

Special sales order

Pricing

Dropping product, department or territories

Outsourcing (make or buy)

Selling as it is or process further

Keep or replace

5

Prepared by: Ms Rahayu Abdull Razak

Short term business decision

How Incremental Analysis Works

Incremental revenue is $15,000 less under Alternative B.

Incremental cost savings of $20,000 is realized.

Alternative B produces $5,000 more net income.

Illustration 7-2

Management’s Decision-Making Process

Important concepts used in incremental analysis:

Relevant cost- the predicted future costs and revenues that will differ among alternatives.

Opportunity cost.

Sunk cost - costs that were incurred in the past and cannot be changed, regardless of which future action is taken. Past purchases are an example of a sunk cost.

Management’s Decision-Making Process

How Incremental Analysis Works

a. Do not change under alternative courses of action.

b. Change under alternative courses of action.

c. Are mixed under alternative courses of action.

d. None of the above.

Incremental analysis is the process of identifying the financial data that

Review Question

Management’s Decision-Making Process

8

Prepared by: Ms Rahayu Abdull Razak

1. Special Order

A special order occurs when a customer requests a one-time order at a reduced sale price.

Decision rule: Accept special order if the expected increase in revenues exceeds expected increase in variable and fixed costs. Reject special order if expected increase in revenues is less than expected increases in variable and fixed costs.

Illustration: see handout

Special order - example

Prepared by: Ms Rahayu Abdull Razak

12

The price of a good or service is affected by many factors.

Regardless of the factors involved, the price must cover the costs of the good or service as well as earn a reasonable profit.

Illustration 8-1

2. Setting regular price

The price of a good or service is affected by many factors.

Company must have a good understanding of market forces.

Where products are not easily differentiated from competitor goods, prices are not set by the company, but rather by the laws of supply and demand – such companies are called price takers.

Where products are unique or clearly distinguishable from competitor goods, prices are set by the company.

2. Setting regular price

2. Setting regular price

Company usually ask these questions before deciding on the price

2. Setting regular price

Companies are price-takers when they have little or no control over the prices of their products or services

Companies are price-setters when their products are unique, which results in less competition.

A company’s approach to pricing depends on whether its product or service is on the price-taking or price-setting side of the spectrum.

Price-takers emphasize a target-pricing approach.

Price-setters emphasize a cost-plus pricing approach.

Laws of supply and demand significantly affect product price.

To earn a profit, companies must focus on controlling costs.

Requires setting a target cost that will provide the company’s desired profit.

Target Costing

Target cost: Cost that provides the desired profit when the market determines a product’s price.

If a company can produce its product for the target cost or less, it will meet its profit goal.

Pricing Goods for External Sales

Target Costing

First, company should identify its market niche where it wants to compete.

Second, company conducts market research to determine the target price – the price the company believes will place it in the optimal position for the target consumers.

Third, company determines its target cost by setting a desired profit.

Last, company assembles a team to develop a product to meet the company’s goals.

Target Costing

The desired profit for this new product line is

$1,000,000 x 25% = $250,000

Each cover must result in profit of $250,000 ÷ 200,000 units = $1.25

Market price Desired profit Target cost per unit

$20 $1.25 $18.75 per unit

Fine Line Phones is considering introducing a fashion cover for its phones. Market research indicates that 200,000 units can be sold if the price is no more than $20. If Fine Line decides to produce the covers, it will need to invest $1,000,000 in new production equipment. Fine Line requires a minimum rate of return of 25% on all investments. Determine the target cost per unit for the cover.

-

=

21

Prepared by: Ms Rahayu Abdull Razak

Target cost related to price and profit means that:

a. Cost and desired profit must be determined before selling price.

b. Cost and selling price must be determined before desired profit.

c. Price and desired profit must be determined before costs.

d. Costs can be achieved only if the company is at full capacity.

Review Question

Pricing Goods for External Sales

22

Prepared by: Ms Rahayu Abdull Razak

In an environment with little or no competition, a company may have to set its own price.

When a company sets price, the price is normally a function of product cost: cost-plus pricing.

Approach requires establishing a cost base and adding a markup to determine a target selling price.

Cost- Plus pricing

In determining the proper markup, a company must consider competitive and market conditions.

Size of the markup (the “plus”) depends on the desired return on investment for the product:

ROI = net income ÷ invested assets

Cost-Plus Pricing

Pricing Goods for External Sales

Illustration: Thinkmore Products, Inc. is in the process of setting a selling price on its new video camera pen. It is a functioning pen that will record up to 2 hours of audio and video. The per unit variable cost estimates for the new video camera pen are as follows.

Cost-Plus Pricing

In addition, Thinkmore has the following fixed costs per unit at a budgeted sales volume of 10,000 units.

Illustration 8-6

Cost-Plus Pricing

Thinkmore has decided to price its new video camera pen to earn a 20% return on its investment (ROI) of $1,000,000.

Markup = 20% ROI of $1,000,000

Expected ROI = $200,000 ÷ 10,000 units = $20

Sales price per unit =

Cost-Plus Pricing

Use markup on cost to set a selling price:

Compute the markup percentage to achieve a desired ROI of $20 per unit:

Compute the target selling price:

Cost-Plus Pricing

3. Dropping products/territories/department

Managers must often decide whether to drop products, departments, or territories that are not as profitable as desired.

3. Dropping products/territories/department

follow the two key guidelines for special business decisions: (1) focus on relevant data, and (2) use a contribution margin approach.

Key: Focus on Relevant Costs.

Consider effect on related product lines.

Fixed costs allocated to the unprofitable segment must be absorbed by the other segments.

Net income may decrease when an unprofitable segment is eliminated.

Decision Rule: Retain the segment unless fixed costs eliminated exceed contribution margin lost.

Dropping a product/territories/department

Illustration: Venus Company manufactures three models of tennis rackets:

Profitable lines: Pro and Master

Unprofitable line: Champ

Illustration 7-16

Should Champ be eliminated?

Dropping a product/territories/department

Prepare income data after eliminating Champ product line. Assume fixed costs are allocated 2/3 to Pro and 1/3 to Master.

Total income is decreased by $10,000.

Dropping a product/territories/department

If an unprofitable segment is eliminated:

a. Net income will always increase.

b. Variable expenses of the eliminated segment will have to be absorbed by other segments.

c. Fixed expenses allocated to the eliminated segment will have to be absorbed by other segments.

d. Net income will always decrease.

Review Question

Types of Incremental Analysis

34

Prepared by: Ms Rahayu Abdull Razak

4. Make or Buy ( outsource)

Company sometimes has to decide whether to make their own product or buy it in order to save costs

Illustration: Baron Company incurs the following annual costs in producing 25,000 ignition switches for motor scooters.

Instead of making its own switches, Baron Company might purchase the ignition switches at a price of $8 per unit. “What should management do?”

4. Make or Buy

Total manufacturing cost is $1 higher per unit than purchase price.

Must absorb at least $50,000 of fixed costs under either option.

Types of Incremental Analysis

Make or Buy

In a make-or-buy decision, relevant costs are:

a. Manufacturing costs that will be saved.

b. The purchase price of the units.

c. Opportunity costs.

d. All of the above.

Review Question

Types of Incremental Analysis

38

Prepared by: Ms Rahayu Abdull Razak

May have option to sell product at a given point in production or to process further and sell at a higher price.

Decision Rule:

Process further as long as the incremental revenue from such processing exceeds the incremental processing costs.

5. Sell or Process further

Illustration: Woodmasters Inc. makes tables. The cost to manufacture an unfinished table is $35. The selling price per unfinished unit is $50. Woodmasters has unused capacity that can be used to finish the tables and sell them at $60 per unit. For a finished table, direct materials will increase $2 and direct labor costs will increase $4. Variable manufacturing overhead costs will increase by $2.40 (60% of direct labor). No increase is anticipated in fixed manufacturing overhead.

S Sell or Process Further - Single-Product Case

Should Woodmasters sell or process further.

Should Woodmasters sell or process further?

The incremental analysis on a per unit basis is as follows.

Illustration 7-9

Types of Incremental Analysis

Sell or Process Further - Single-Product Case

6. Keep or replace assets

A common business decision involves deciding whether to keep or replace the old machine or equipment

In deciding whether to replace or keep existing asset, company must consider the relevance of four commonly encountered items:-

Book value of old asset; irrelevant because it is part of past cost ( sunk cost). Therefore depreciation on old asset is also irrelevant.

Disposal value of old equipment: relevant because it is an expected future inflow that usually differs across alternatives.

Gain or loss on disposal: is the difference between book value and disposal value. So it is a combination of irrelevant and relevance

Cost of new asset: relevant

Illustration: Jeffcoat Company is considering replacing a factory machine with a new machine. Jeffcoat Company has a factory machine that originally cost $110,000. It has a balance in Accumulated Depreciation of $70,000, so its book value is $40,000. It has a remaining useful life of four years. The company is considering replacing this machine with a new machine. A new machine is available that costs $120,000. It is expected to have zero salvage value at the end of its four-year useful life. If the new machine is acquired, variable manufacturing costs are expected to decrease from $160,000 to $125,000 , and the old unit could be sold for $5,000. The incremental analysis for the four-year period is as follows.

Repair, Retain, or Replace Equipment

Retain or Replace?

Retain or Replace?

Prepare the incremental analysis for the four-year period.

Types of Incremental Analysis

Repair, Retain, or Replace Equipment

Is there excess

capacity?

Will the reduced

price cover the

incremental

costs?

Will special

order affect

sales in the

long-run?

Copyright (c) 2009 Prentice Hall. All rights reserved.9

Copyright (c) 2009 Prentice Hall. All rights reserved.

9

Special Order Considerations

A special order occurs when a customer requests a one-time order at a reduced sale price. Before agreeing to the special deal, management must consider the questions shown here.

Is there excess capacity?

Will the reduced price cover the incremental costs?

Will special order affect sales in the long-run?

What is our

target profit?

How much will

customers

pay?Are we a

price-taker or

a price-setter?

Copyright (c) 2009 Prentice Hall. All rights reserved.14

Copyright (c) 2009 Prentice Hall. All rights reserved.

14

Setting Regular Price

Managers start with three basic questions when setting regular prices for their products or services, as shown here. The answers to these questions are often complex and ever-changing.

Stockholders expect the company to achieve certain profits. Economic conditions, historical company earnings, industry risk, competition, and new business developments all affect the level of profit that stockholders expect. Stockholders usually tie their profit expectations to the amount of assets invested in the company.

This leads to the second question: How much will customers pay? Managers cannot set prices above what customers are willing to pay or sales will decline. The amount customers will pay depends on the competition, the product’s uniqueness, the effectiveness of marketing campaigns, general economic conditions, and so forth.

To address the third pricing question, imagine a horizontal line with price-takers at one end and price-setters at the other end. A company’s products and services fall somewhere along this line, which is shown in Exhibit 19-8 and on the next slide.

What is our target profit?

How much will customers pay?

Are we a price-taker or a price-setter?

Does the product

provide a positive

contribution

margin?

Will fixed costs

continue?

Can any fixed

costs be avoided

if we drop the

product?

Will the sales of

other products be

affected?What could we

do with the freed

capacity?

20Copyright (c) 2009 Prentice Hall. All rights reserved.

20

Dropping Products, Departments, or Territories

Copyright (c) 2009 Prentice Hall. All rights reserved.

Managers must often decide whether to drop products, departments, or territories that are not as profitable as desired. How do managers make these decisions? Here are some of the questions managers must consider when deciding whether to drop a product line, department, or territory.

Does the product provide a positive contribution margin?

Will fixed costs continue?

Can any fixed costs be avoided if we drop the product?

Will the sales of other products be affected?

What could we do with the freed capacity?

DECISION RULE: Drop a product, department, or territory?

Are lost revenues > cost savings?

Do not drop

Are lost revenues < cost savings?

Drop

Dropping Products, Departments or Territories

23

The decision rule on whether to drop a product, department, or territory rests on the lost revenues versus the cost savings.

DECISION RULE:

Drop a product, department, or territory?

Are lost revenues >

cost savings?

Do not drop

Are lost revenues <

cost savings?

Drop

29Copyright (c) 2009 Prentice Hall. All rights reserved.

How do variable costs compare to the outsourcing costs?Are any fixed costs avoidable if we outsource?What would we do with the freed capacity?

29

Outsourcing (Make or Buy)

Copyright (c) 2009 Prentice Hall. All rights reserved.

How do variable costs compare to the outsourcing costs?

Are any fixed costs avoidable if we outsource?

What would we do with the freed capacity?

How much revenue will be earned if sold “as is”?How much revenue will be earned if processed further?How much will it cost to process further?

32Copyright (c) 2009 Prentice Hall. All rights reserved.

32

Sell As-Is or Process Further

Copyright (c) 2009 Prentice Hall. All rights reserved.

How much revenue will be earned if sold “as is”?

How much revenue will be earned if processed further?

How much will it cost to process further?

helping resources/ACCT 212/Slides/MODULE 5 Master Budget.pptx

MODULE 5 BUDGETARY PLANNING

1

Prepared by: Ms Rahayu Abdull Razak

MODULE 5

Budgetary Planning

Learning Objectives

After studying this chapter, you should be able to:

[1] Indicate the benefits of budgeting.

[2] State the essentials of effective budgeting.

[3] Identify the budgets that comprise the master budget.

[4] Describe the sources for preparing the budgeted income statement.

[5] Explain the principal sections of a cash budget.

[6] Indicate the applicability of budgeting in non-manufacturing companies.

2

Prepared by: Ms Rahayu Abdull Razak

Budget: a formal written statement of management’s plans for a specified future time period, expressed in financial terms.

Primary way to communicate agreed-upon objectives to all parts of the company.

Promotes efficiency.

Control device - important basis for performance evaluation once adopted.

Budgeting Basics

Requires all levels of management to plan ahead.

Provides definite objectives for evaluating performance.

Creates an early warning system for potential problems.

Facilitates coordination of activities within the business.

Results in greater management awareness of the entity’s overall operations.

Motivates personnel throughout organization to meet planned objectives.

The Benefits of Budgeting

Budgeting Basics

Which of the following is not a benefit of budgeting?

a. Management can plan ahead.

b. An early warning system is provided for potential problems.

c. It enables disciplinary action to be taken at every level of responsibility.

d. The coordination of activities is facilitated.

Review Question

Budgeting Basics

5

Prepared by: Ms Rahayu Abdull Razak

Base budget goals on past performance

Collect data from organizational units.

Begin several months before end of current year.

Develop budget within the framework of a sales forecast.

Shows potential industry sales.

Shows company’s expected share.

The Budgeting Process

Budgeting Basics

Participative Budgeting: Each level of management should be invited to participate.

Flow of budget data from lower management to top levels

Budgeting Basics

7

Prepared by: Ms Rahayu Abdull Razak

Types of budget

Budgeting Basics

Strategic plan – the most forward looking and least detailed budget which sets the overall goal and objectives of the organization. Strategic plan provides the overall framework for the long range plan.

Long range plan – typically produced forecasted financial statements for 5 to 10 year period. Company usually coordinates the long range plan with capital budget.

Capital budget – detail the planned expenditures for facilities, equipment, new products and other long term investment.

8

Prepared by: Ms Rahayu Abdull Razak

Types of budget

Budgeting Basics

Master budget – a detailed and comprehensive analysis of the first year of the long range plan. It quantifies targets for sales, purchase, production, distribution and financing in the form of forecasted financial statements and supporting operating schedule.

Continuous or rolling budget – are master budget that simply add a month or quarter in the future as the company drop the month or quarter just ended.

9

Prepared by: Ms Rahayu Abdull Razak

Set of interrelated budgets that constitutes a plan of action for a specified time period.

Contains two classes of budgets:

Operating budgets.

Financial budgets.

The Master Budget

Individual budgets that result in the preparation of the budgeted income statement – establish goals for sales and production personnel.

Budgeting Basics

Set of interrelated budgets that constitutes a plan of action for a specified time period.

Contains two classes of budgets:

Operating budgets.

Financial budgets.

The Master Budget

The capital expenditures budget, the cash budget, and the budgeted balance sheet – focus primarily on cash needs to fund operations and capital expenditures.

Budgeting Basics

Illustration 9-2

Components of the Master

Budget

Budgeting Basics

12

Prepared by: Ms Rahayu Abdull Razak

First budget prepared.

Derived from the sales forecast.

Management’s best estimate of sales revenue for the budget period.

Every other budget depends on the sales budget.

Prepared by multiplying expected unit sales volume for each product times anticipated unit selling price.

Preparing the Operating Budgets

Sales Budget

Expected sales volume: 3,000 units in the first quarter with 500-unit increases in each succeeding quarter.

Sales price: $60 per unit.

Illustration – Hayes Company

Preparing the Operating Budgets

Shows units that must be produced to meet anticipated sales.

Derived from sales budget plus the desired change in ending finished goods inventory.

Essential to have a realistic estimate of ending inventory.

Preparing the Operating Budgets

Production Budget

Hayes Co. believes it can meet future sales needs with an ending inventory of 20% of next quarter’s sales. First quarter of 2014 has 3,000 sales unit and company expect the first quarter of 2015 to have 5000 sales unit.

Illustration – Hayes Company

Preparing the Operating Budgets

Shows both the quantity and cost of direct materials to be purchased.

Formula for direct materials quantities.

Direct Materials Budget

Budgeted cost of direct materials to be purchased = required units of direct materials x anticipated cost per unit.

Inadequate inventories could result in temporary shutdowns of production.

Preparing the Operating Budgets

Because of its close proximity to suppliers,

Hayes Company maintains an ending inventory of raw materials equal to 10% of the next quarter’s production requirements.

The manufacture of each product requires 2 pounds of raw materials, and the expected cost per pound is $4.

Assume that the desired ending direct materials amount is 1,020 pounds for the fourth quarter of 2014.

Beginning direct material is 620 pounds for the first quarter of 2014.

Prepare a Direct Materials Budget.

Preparing the Operating Budgets

Illustration – Hayes Company

Preparing the Operating Budgets

Illustration – Hayes Company

Soriano Company is preparing its master budget for 2014. Relevant data pertaining to its sales, production, and direct materials budgets are as follows:

Sales: Sales for the year are expected to total 1,200,000 units. Quarterly sales are 20%, 25%, 30%, and 25% respectively. The sales price is expected to be $50 per unit for the first three quarters and $55 per unit beginning in the fourth quarter. Sales in the first quarter of 2015 are expected to be 10% higher than the budgeted sales for the first quarter of 2014.

Production: Management desires to maintain ending finished goods inventories at 25% of next quarter’s budgeted sales volume.

Direct materials: Each unit requires 3 pounds of raw materials at a cost of $5 per pound. Management desires to maintain raw materials inventories at 5% of the next quarter’s production requirements. Assume the production requirements for the first quarter of 2015 are 810,000 pounds.

20

Prepared by: Ms Rahayu Abdull Razak

Prepare the sales, production, and direct materials budgets by quarters for 2014.

21

Prepared by: Ms Rahayu Abdull Razak

Prepare the sales, production, and direct materials budgets by quarters for 2014.

22

Prepared by: Ms Rahayu Abdull Razak

Prepare the sales, production, and direct materials budgets.

23

Prepared by: Ms Rahayu Abdull Razak

Shows both the quantity of hours and cost of direct labor necessary to meet production requirements.

Critical in maintaining a labor force that can meet expected production.

Total direct labor cost formula:

Illustration 9-8

Direct Labor Budget

Preparing the Operating Budgets

Illustration: Direct labor hours are determined from the production budget. At Hayes Company, two hours of direct labor are required to produce each unit of finished goods. The anticipated hourly wage rate is $10.

Illustration 9-9

Preparing the Operating Budgets

Shows the expected manufacturing overhead costs for the budget period.

Distinguishes between fixed and variable overhead costs.

Manufacturing Overhead Budget

Preparing the Operating Budgets

Illustration: Hayes Company expects variable costs to fluctuate with production volume on the basis of the following rates per direct labor hour: indirect materials $1.00, indirect labor $1.40, utilities $0.40, and maintenance $0.20. Thus, for the 6,200 direct labor hours to produce 3,100 units, budgeted indirect materials are $6,200 (6,200 x $1), and budgeted indirect labor is $8,680 (6,200 x $1.40). Hayes also recognizes that some maintenance is fixed. The amounts reported for fixed costs are assumed.

Prepare a Manufacturing Overhead Budget.

Manufacturing Overhead Budget

Manufacturing Overhead Budget

Illustration 9-10

Projection of anticipated operating expenses.

Distinguishes between fixed and variable costs.

Selling and Administrative Expense Budget

Illustration: Variable expense rates per unit of sales are sales commissions $3 and freight-out $1. Variable expenses per quarter are based on the unit sales from the sales budget (Illustration 9-3). Hayes expects sales in the first quarter to be 3,000 units. Fixed expenses are based on assumed data.

Prepare a selling and administrative expense budget.

Preparing the Operating Budgets

Selling and Administrative Expense Budget

A sales budget is:

a. Derived from the production budget.

b. Management’s best estimate of sales revenue for the year.

c. Not the starting point for the master budget.

d. Prepared only for credit sales.

Review Question

Preparing the Operating Budgets

31

Prepared by: Ms Rahayu Abdull Razak

Important end-product of the operating budgets.

Indicates expected profitability of operations.

Provides a basis for evaluating company performance.

Prepared from the operating budgets:

Budgeted Income Statement

Manufacturing Overhead

Selling and Administrative Expense

Sales

Direct Materials

Direct Labor

Preparing the Operating Budgets

Illustration: Hayes company has the following information Company sold 15,000 units of product. Sales price is $60 per unit.

Budgeted Income Statement

To calculate Cost of Goods Sold by multiplying units sold times unit cost: 15,000 units x $44 = $660,000

Illustration: All data for the income statement come from the individual operating budgets except the following: (1) interest expense is expected to be $100, and (2) income taxes are estimated to be $12,000.

LO 4

Preparing the Operating Budgets

Each of the following budgets is used in preparing the budgeted income statement except the:

a. Sales budget.

b. Selling and administrative budget.

c. Capital expenditure budget.

d. Direct labor budget.

Review Question

Preparing the Operating Budgets

35

Prepared by: Ms Rahayu Abdull Razak

Shows anticipated cash flows.

Often considered to be the most important output in preparing financial budgets.

Contains three sections:

Cash Receipts

Cash Disbursements

Financing

Shows beginning and ending cash balances.

Cash Budget

Preparing the Financial Budgets

Cash Receipts Section

Expected receipts from the principal sources of revenue.

Expected interest and dividends receipts, proceeds from planned sales of investments, plant assets, and capital stock.

Cash Disbursements Section

Expected cash payments for direct materials and labor, taxes, dividends, plant assets, etc.

Financing Section

Expected borrowings and repayments of borrowed funds plus interest.

Cash Budget

Cash Budget - Basic Format

Preparing the Financial Budgets

Developed from the budgeted balance sheet for the preceding year and the budgets for the current year.

Budgeted Balance Sheet

Preparing the Financial Budgets

Illustration: Pertinent data from the budgeted balance sheet at December 31, 2013, are as follows.

Illustration 9-18

Preparing the Financial Budgets

Budgeted Balance Sheet

helping resources/ACCT 212/Slides/MODULE 6 Performance Evaluation and Balance Scorecard.pptx

MODULE 6 PERFORMANCE EVALUATION & BALANCE SCORECARD

1

Prepared by: Ms Rahayu Abdull Razak

A responsibility center is a part or subunit of an organization whose manager is accountable for specific activities.

Responsibility accounting is a system for evaluating the performance of each responsibility centers and its managers

Responsibility accounting accumulate and report costs (and revenues, where relevant) on the basis of the manager who has the authority to make the day-to-day decisions about the items.

Responsibility Accounting

Conditions:

Costs and revenues can be directly associated with the specific level of management responsibility.

Costs and revenues can be controlled by employees at the level of responsibility with which they are associated.

Budget data can be developed for evaluating the manager’s effectiveness in controlling the costs and revenues.

Responsibility Accounting

Levels of responsibility for controlling costs.

Responsibility Accounting

Especially valuable in a decentralized company.

Control of operations delegated to many managers throughout the organization.

Segment – area of responsibility for which reports are prepared.

Two differences from budgeting in reporting costs and revenues:

Distinguishes between controllable and noncontrollable costs.

Emphasizes or includes only items controllable by the individual manager in performance reports.

Applies to both profit and not-for-profit entities.

Profit entities: maximize net income.

Not-for-profit: minimize cost of providing services

Responsibility Accounting

Involves preparation of a report for each level of responsibility in the company's organization chart.

Begins with the lowest level of responsibility and moves upward to higher levels.

Permits management by exception (means that top management’s review of a budget report is focused primarily on differences between actual results and planned objectives) at each level of responsibility.

Each higher level can obtain the detailed report for each lower level.

Responsibility Reporting System

Responsibility Accounting

Four basic types:

Cost centers.

Revenue Center

Profit centers

Investment centers

Types of Responsibility Centers

Cost centers

Manager have authority to incur costs but not directly generates revenue.

Usually manager of a production department or a service department

Based on a manager’s ability to control cost in order to meet budgeted goals for controllable costs.

Results in responsibility reports which compare actual controllable costs with flexible budget data.

Include only controllable costs in reports.

No distinction between variable and fixed costs.

Types of Responsibility Centers

Revenue centers

managers are primarily accountable for revenues.

This manager is responsible for generating revenue.

Revenue center performance report compares actual with budgeted revenues

Example: sales region at Kraft food, central reservation office of Saudi airlines.

Types of Responsibility Centers

Profit centers

Based on detailed information about both controllable revenues and controllable costs.

Manager is judged on profitability of the center.

Manager controls operating revenues earned, such as sales.

Manager controls all variable costs incurred by the center because they vary with sales.

Examples include individual departments of a retail store or branch bank offices.

Types of Responsibility Centers

Investment centers

Incurs costs, generates revenues, and has investment funds available for use.

Manager evaluated on profitability of the center and rate of return earned on funds.

Often a subsidiary company or a product line.

Manager able to control or significantly influence investment decisions such as plant expansion.

Types of Responsibility Centers

Return on investment (ROI) is the primary basis for evaluating the performance of a manager of an investment center.

Shows the effectiveness of the manager in using the assets at his/her disposal.

Useful performance measure.

Factors in ROI formula are controllable by manager.

Responsibility Accounting for Investment Centers

Types of Responsibility Centers

Scope of manager’s responsibility affects content.

Investment center is an independent entity for operating purposes.

All fixed costs are controllable by center manager.

Shows budgeted and actual ROI below controllable margin.

Types of Responsibility Centers

Responsibility Report

Once a company decentralizes operations, top management is no longer involved in running the subunits’ day-to-day operations.

Performance evaluation systems provide top management with a framework for maintaining control over the entire organization.

When companies decentralize, top management needs a system to communicate its goals to subunit managers

Additionally, top management needs to determine whether the decisions being made at the subunit level are effectively meeting company goals.

Performance evaluation

Performance evaluation

Goal of performance evaluation

Promoting Goal Congruence and Coordination - provide incentives for coordinating the subunits’ activities and direct them toward achieving the overall company goals.

Communicating Expectations - spell out the unit’s most critical objectives

Motivating Unit Managers - offer bonuses to unit managers who meet or exceed performance targets.

Providing Feedback - provide upper management with the feedback they need to maintain control over the entire organization, even though they have delegated responsibility and decision-making authority to unit managers

Benchmarking - the practice of comparing the company’s achievements against the best practices in the industry

15

Prepared by: Ms Rahayu Abdull Razak

The balanced scorecard recognizes that management must consider both financial performance measures and operational performance measures when judging the performance of a company and its subunits.

These measures should be linked with the company’s goals and its strategy for achieving those goals

Management uses key performance indicators (KPI) to measure critical factors that affect the success of the company

The balanced scorecard evaluates company performance from a series of “perspectives.” The four most commonly employed perspectives are as follows

Balance scorecard

Companies that adopt the balanced scorecard usually have specific objectives they wish to achieve within each of the four perspectives.

Once management clearly identifies the objectives, they develop KPIs that will assess how well the objectives are being achieved.

To focus attention on the most critical elements and prevent information overload, management should use only a few KPIs for each perspective.

Balance scorecard

In summary, the balanced scorecard does the following:

Employs both financial and nonfinancial measures.

Creates linkages so that high-level corporate goals can be communicated all the way down to the shop floor.

Provides measurable objectives for such nonfinancial measures such as product quality, rather than vague statements such as “We would like to improve quality.”

Integrates all of the company’s goals into a single performance measurement system, so that an inappropriate amount of weight will not be placed on any single goal.

LO 8 Describe the balanced scorecard approach to performance evaluation.

Balanced Scorecard

18

Prepared by: Ms Rahayu Abdull Razak

helps managers answer the question, “How do we look to shareholders?” The ultimate goal of companies is to generate income for their owners.

The financial perspective focuses management’s attention on KPIs that assess financial objectives, such as revenue growth and cost cutting

Some commonly used KPIs include: sales revenue growth, gross margin growth, and return on investment, RI, EVA

Balance scorecard

Financial perspective

helps managers answer the question, “How do customers see us?”

Some KPI use include customer satisfaction rating, percentage of market share, increase in the number of customers, number of repeat customers, and rate of on-time deliveries

Customers are typically concerned with four specific product or service attributes:

the product’s price,

the product’s quality,

the sales service quality, and

the product’s delivery time (the shorter, the better).

Balance scorecard

Customer perspective

helps managers answer the question, “At what business processes must we excel to satisfy customer and financial objectives?”

Incorporate three factors:

innovation,

operations, and

post-sales service

Some KPI use include the number of new products developed or new-product development time, manufacturing cycle time, number of units produced per hour, defect rate), number of warranty claims received, average repair time, and average wait time on the phone for a customer service representative

Balance scorecard

Internal business perspective

helps managers answer the question, “How can we continue to improve and create value?”

focuses on three factors:

employee capabilities

information system capabilities, and

the company’s “climate for action.”

Some KPI use include hours of employee training, employee satisfaction, employee turnover, and number of employee suggestions implemented, the percentage of employees having online access to information about customers, and the percentage of processes with real-time feedback on quality, cycle time, and cost.

Balance scorecard

Learning and growth perspective

Balanced Scorecard

Illustration 11-29

Examples of objectives within the four perspectives of balanced scorecard

23

Prepared by: Ms Rahayu Abdull Razak

helping resources/FIN 220/Exercises/FIN220 - Module 2 Practice 1 Simple Interest.pdf

MODULE 2 – TIME VALUE OF MONEY: Simple Interest Problems

1. Robert deposits $ 3000 in State Bank of India for 3 year which earn him an interest of

8%.What is the amount he gets after 1 year, 2 years and 3 years?

2. Richard deposits $ 5400 and got back an amount of $ 6000 after a year. Find the

simple interest he got.

3. Seth invested a certain amount of money and got back an amount of $ 8400. If the

bank paid an interest of $ 700, find the amount Sam invested.

4. Diego deposited $ 10000 for 4 year at a rate of 6% p.a. Find the interest and amount

Diego got.

5. Dick takes a loan of $8,000 to buy a used truck at the rate of 9 % simple interest.

Calculate the annual interest to be paid for the loan amount.

6. Steve invested $ 10,000 in a savings bank account that earned 2% simple interest.

Find the interest earned if the amount was kept in the bank for 4 years.

7. Ryan bought $ 15,000 from a bank to buy a car at 10% simple Interest. If he paid $

9,000 as interest while clearing the loan, find the time for which the loan was given.

8. In how much time will the simple interest on $3,500 at the rate of 9% p.a be the

same as simple interest on $4,000 at 10.5% p.a for 4 years?

9. Mr. Thomas invested an amount of 13,900 divided in two different schemes A and B

at the simple interest rate of 14% p.a. and 11% p.a. respectively. If the total amount

of simple interest earned in 2 years be 3508, what was the amount invested in

Scheme B?

10. How much time will it take for an amount of 450 to yield 81 as interest at 4.5% per

annum of simple interest?

helping resources/FIN 220/Exercises/FIN220 - Module 2 Practice 1 TVM.pdf

FIN220 – Time value of Money Practice Questions.

1) If you deposit $10,000 in a bank account that pays 10 percent interest annually, how much money will be in your account after 5 years? (Answer: $16,105.10)

2) What is the present value of a security that promises to pay you $5,000 in 20 years? Assume that you can earn 7 percent if you were to invest in other securities of equal risk. (Answer: $1,292.095014)

3) What is the future value of a 5-year ordinary annuity that promises to pay you $300 each

year? The rate of interest is 7 percent. (Answer: $1,725.221703)

4) What is the future value of a 5-year annuity due that promises to pay you $300 each year? Assume that all payments are reinvested at 7 percent a year, until Year 5. (Answer: $1,845.987222)

5) An investment pays you $100 at the end of each of the next 3 years. The investment will

then pay you $200 at the end of Year 4, $300 at the end of Year 5, and $500 at the end of Year 6. If the interest rate earned on the investment is 8 percent, what is its present value? What is its future value? (Answer: PV=$923.975442, FV=$1,466.232904)

6) Which amount is worth more at 14 percent, compounded annually: $1,000 in hand today

or $2,000 due in 6 years? (Answer: $1,000 today because PV of $2,000 is only $911.173095)

7) You need to accumulate $10,000. To do so, you plan to make deposits of $1,250 per year,

with the first payment being made a year from today, in a bank account that pays 12 percent interest, compounded annually. Your last deposit will be less than $1,250 if less is needed to round out to $10,000. How many years will it take you to reach your $10,000 goal, and how large will the last deposit be? (Answer: 6 years, deposit in year 6 will be $1,106.013696)

8) You just started your first job, and you want to buy a house within 3 years. You are

currently saving for the down payment. You plan to save $5,000 the first year. You also anticipate that the amount you save each year will rise by 10 percent a year as your salary increases over time. Interest rates are assumed to be 7 percent, and all savings occur at year end. How much money will you have for a down payment in 3 years? (Answer: $17,659.500000)

9) Today is your birthday, as for your birthday present your uncle gives you these options to choose from :

a) SR50,000 in 10 years’ time. If the money is placed in an investment giving 10% return, calculate the value of the investment today.

b) SR18,000 today to be placed in the same investment, i.e. earning 10% return. The amount will not be withdrawn for 10 years. What will be the value of the investment at maturity?

c) SR3,500 to be given annually for the next 10 years (at the end of the period) with rate of return of 8%. Compute the value of the cash flows in 10 years.

FIN220 – Time value of Money Practice Questions.

10) Your client is 40 years old and wants to begin saving for retirement. You advise the client to put $5,000 a year into the stock market. You estimate that the market’s return will be, on average, 12 percent a year. Assume the investment will be made at the end of the year.

a. If the client follows your advice, how much money will she have by age 65?

(Answer: $666,669.3503) b. How much will she have by age 70? (Answer: $1,206,663.422)

11) A 15-year security has a price of $340.4689. The security pays $50 at the end of each of

the next 5 years, and then it pays a different fixed cash flow amount at the end of each of the following 10 years. Interest rates are 9 percent. What is the annual cash flow amount between Years 6 and 15? (Answer: $35.000009)

12) Find the interest rates, or rates of return, on each of the following: a) You borrow $700 and promise to pay back $749 at the end of 1 year. (Answer: 7%) b) You lend $700 and receive a promise to be paid $749 at the end of 1 year. (Answer:

7%) c) You borrow $85,000 and promise to pay back $201,229 at the end of 10 years.

(Answer: 9%) d) You borrow $9,000 and promise to make payments of $2,684.80 per year for 5 years.

(Answer: 15%)

helping resources/FIN 220/Exercises/FIN220 - Module 2 Practice 2 TVM.pdf

MODULE 2 – Compound Interest Exercise Questions.

helping resources/FIN 220/Exercises/FIN220 - Module 2 Simple_Interest_Problems.pdf

Simple Interest Problems

Revised @ 2009 MLC page 1 of 2

Simple Interest Problems Interest is money paid for the use of money. If you borrow from the bank to

buy a car, the bank will charge you interest for its use. If you open a savings

account at the bank, the bank will pay you interest for as long as the account

is open. Note: Banks usually charge compound interest not simple interest. See your local accounting teacher for more information.

The interest (I) is the dollar amount earned or owed.

The interest rate (R) is per year (T) unless otherwise noted.

Note: If the time is in months, T can be found using the ratio

12

months of number .

The principal (P) is the amount borrowed or deposited.

This is the formula to express simple interest:

I(nterest) = P(rincipal) x R(ate) x T(ime)

I = P x R x T or I = PRT

Solve each of these interest problems:

1) You get a student loan from the New Mexico Educational Assistance

Foundation to pay for your educational expenses this year.

Find the interest on the loan if you borrowed $2,000 at 8% for 1 year. (You may wish to use the percent key on your calculator or change 8% to .08)

2) You are starting your own small business in Albuquerque. You borrow

$10,000 from the bank at a 9% rate for 5 years.

Find the interest you will pay on this loan.

Simple Interest Problems

Revised @ 2009 MLC page 2 of 2

3) You are tired at the end of the term and decide to borrow $500 to go

on a trip to Whatever Land. You go to the bank and borrow the money

at 11% for 2 years.

a) Find the interest you will pay on the loan.

b) How much will you have to pay the bank at the end of the two years?

4. a) Find the interest on a loan of $2500 that is borrowed at 9% for

7 months.

b) How much would it cost to repay the loan from 4a) above?

5. Do you understand what interest means? Circle one YES! NO!

6. Have you ever borrowed money from a bank or loan office to buy a car,

house, or whatever? Circle one YES! NO!

Answers

1. $160

2. $4500

3. a) $110

b) $610

4. a) $131.25

b) $2631.25

5. Yes = good job

No = ask your teacher or IT for help

6. Yes = you know it all

No = go out and buy something big today!

helping resources/FIN 220/Exercises/FIN220 - Module 2 TVM Practice 1.pdf

Khaled plans to buy a car on 1/1/2015. He expects the price of the car will be SAR50,000. Today,

1/1/2013 he can save his money in an account which earns him 10% return annually. How much money

should he save now to reach the amount to purchase the car.

Khaled plans to buy a car on 1/1/2015. He expects the price of the car will be SAR50,000. Today,

1/1/2013 he can save his money in an account which earns him 10% return annually. How much money

should he save annually during the period to reach the amount to purchase the car.

Khaled plans to buy a car on 1/1/2015. He expects the price of the car will be SAR50,000. Today,

1/1/2013 he can save his money in an account which earns him 10% return annually. His uncle informs

him that he will contribute SAR10,000 to Khaled’s savings on 1/1/2014. How much money should he

save now to reach the amount to purchase the car.

Khaled plans to buy a car on 1/1/2015. He expects the price of the car will be SAR50,000. Today,

1/1/2013 he can save his money in an account which earns him 10% return annually. His uncle informs

him that he will contribute SAR10,000 to Khaled’s savings now to help him purchase the car. How much

money should he save now to reach the amount to purchase the car.

Khaled plans to buy a car on 1/1/2015. He expects the price of the car will be SAR50,000. Today,

1/1/2013 he can save his money in an account which earns him 10% return annually. His uncle informs

him that he will contribute SAR10,000 in two equal payments to Khaled’s savings now and on 1/1/2014.

How much money should he save now to reach the amount to purchase the car.

helping resources/FIN 220/Exercises/FIN220 - Module 2 TVM Practice 2.pdf

FIN220 – Time value of Money Practice Questions.

1) If you deposit $10,000 in a bank account that pays 10 percent interest annually, how much money will be in your account after 5 years? (Answer: $16,105.10)

2) What is the present value of a security that promises to pay you $5,000 in 20 years? Assume that you can earn 7 percent if you were to invest in other securities of equal risk. (Answer: $1,292.095014)

3) What is the future value of a 5-year ordinary annuity that promises to pay you $300 each

year? The rate of interest is 7 percent. (Answer: $1,725.221703)

4) What is the future value of a 5-year annuity due that promises to pay you $300 each year? Assume that all payments are reinvested at 7 percent a year, until Year 5. (Answer: $1,845.987222)

5) An investment pays you $100 at the end of each of the next 3 years. The investment will

then pay you $200 at the end of Year 4, $300 at the end of Year 5, and $500 at the end of Year 6. If the interest rate earned on the investment is 8 percent, what is its present value? What is its future value? (Answer: PV=$923.975442, FV=$1,466.232904)

6) Which amount is worth more at 14 percent, compounded annually: $1,000 in hand today

or $2,000 due in 6 years? (Answer: $1,000 today because PV of $2,000 is only $911.173095)

7) You need to accumulate $10,000. To do so, you plan to make deposits of $1,250 per year,

with the first payment being made a year from today, in a bank account that pays 12 percent interest, compounded annually. Your last deposit will be less than $1,250 if less is needed to round out to $10,000. How many years will it take you to reach your $10,000 goal, and how large will the last deposit be? (Answer: 6 years, deposit in year 6 will be $1,106.013696)

8) You just started your first job, and you want to buy a house within 3 years. You are

currently saving for the down payment. You plan to save $5,000 the first year. You also anticipate that the amount you save each year will rise by 10 percent a year as your salary increases over time. Interest rates are assumed to be 7 percent, and all savings occur at year end. How much money will you have for a down payment in 3 years? (Answer: $17,659.500000)

FIN220 – Time value of Money Practice Questions.

9) Your client is 40 years old and wants to begin saving for retirement. You advise the client to put $5,000 a year into the stock market. You estimate that the market’s return will be, on average, 12 percent a year. Assume the investment will be made at the end of the year.

a. If the client follows your advice, how much money will she have by age 65?

(Answer: $666,669.3503) b. How much will she have by age 70? (Answer: $1,206,663.422)

10) A 15-year security has a price of $340.4689. The security pays $50 at the end of each of

the next 5 years, and then it pays a different fixed cash flow amount at the end of each of the following 10 years. Interest rates are 9 percent. What is the annual cash flow amount between Years 6 and 15? (Answer: $35.000009)

11) Find the interest rates, or rates of return, on each of the following: a) You borrow $700 and promise to pay back $749 at the end of 1 year. (Answer: 7%) b) You lend $700 and receive a promise to be paid $749 at the end of 1 year. (Answer:

7%) c) You borrow $85,000 and promise to pay back $201,229 at the end of 10 years.

(Answer: 9%) d) You borrow $9,000 and promise to make payments of $2,684.80 per year for 5 years.

(Answer: 15%)

  • FIN220 - 121 Practice 1 TVM with Answer
  • FIN220 - 121 Practice 1 Pg 2 TVM

helping resources/FIN 220/Exercises/FIN220 - Module 3 Practice 2 Risk_Return.pdf

FIN220 – Practice Questions (Module 2)

1. A stock’s expected return has the following distribution:

DEMAND FOR THE COMPANY’S PRODUCTS

PROBABILITY OF THIS

DEMAND OCCURRING

RATE OF RETURN IF

THIS DEMAND OCCURS

(%)

Weak 0.1 (50)

Below Average 0.2 (5)

Average 0.4 16

Above Average 0.2 25

Strong 0.1 60

Calculate the stock’s expected return, standard deviation, and coefficient of variation.

Answer: Expected return, E(r) = 11.4%, standard deviation=26.69%

2. The stock price for Stock A was SAR15 per share 1 year ago. The stock is currently trading at

SAR17.50 per share and shareholders just received a SAR2 dividend. What return was earned

over the past year?

3. Selena Maranjian invests the following sum of money in common stock having expected returns

as follows:

Common Stock Amount Invested in $ Expected Return

WOOPS 6,000 0.14

KABOOM 11,000 0.16

KAPOWW 9,000 0.17

UPDWN 7,000 0.13

RINGG 5,000 0.20

Calculate the return for this portfolio: Answer: 15.89%

4. Stocks X and Y have the following probability distributions of expected future returns:

Probability X Y

0.1 -10% -35%

0.2 2% 0%

0.4 12% 20%

0.2 20% 25%

0.1 38% 45%

a) Calculate the expected rate of return, 𝑟 ̂ , for Stock Y. Return for Stock X, (�̂�X =12%).

Answer: 𝑟 ̂for stock Y =14%

b) Calculate the standard deviation of expected returns for Stock X. (That for Stock Y is 20.35

percent.)

Answer: standard deviation for Stock X = 12.20%

c) Given that investment in stock Y is $4000 and in stock X is $6000 and the covariance between

the two stocks is 0.6,

a. Calculate the expected return of the portfolio.

b. Calculate the standard deviation of the portfolio.

d) Now calculate the coefficient of variation for Stock Y. Is it possible that most investors might

regard Stock Y as being less risky than Stock X? Explain.

5. Suppose RF = 5%, RM = 10%, and RA = 12%. a) Calculate Stock A’s beta. (Answer = 1.4) b) If Stock A’s beta were 2.0, what would be A’s new required rate of return? (Answer: 15%)

6. Suppose RF = 9%, RM = 14%, and βi = 1.3.

a) What is Ri, the required rate of return on Stock i? (Answer: 15.5%) b) Now suppose kRF (1) increases to 10 percent or (2) decreases to 8 percent. The slope of the

SML remains constant. How would this affect RM and Ri? Answer: RM would remain constant since there is no change in the systematic risk Beta, Ri on the other hand will change due changes in the Rf.

c) Now assume kRF remains at 9 percent but RM (1) increases to 16 percent or (2) falls to 13 percent. The slope of the SML does not remain constant. How would these changes affect Ri? Answer: Ri will change according to the change in the slope of SMS which means change in the systematic risk as well.

1. (Capital asset pricing model) Using the CAPM, estimate the appropriate required rate of return for the following three stocks, given that the risk-free rate is 5 percent, and the

expected return for the market is 17 percent.

Answer:

A 14.00%

B 15.80%

C 21.80%

2. (Security market line) Determine the expected return and beta for the following portfolio:

Answer: Return of Portfolio: 12.800%, Beta of portfolio: 1.0425

3. You own a portfolio consisting of the following stocks:

Calculate the expected return of your portfolio. (Hint: The expected return of a portfolio

equals the weighted average of the individual stock's expected return, where the weights

are the percentage invested in each stock.)

Answer: Return of Portfolio:15.800% Beta of portfolio: 0.945

4. Suppose we have the following investments:

What is the expected return on this portfolio? What is the beta of this portfolio? Does this portfolio have more or less systematic risk than an average asset?

Answer: Return of Portfolio: 14.90% Beta of portfolio: 1.16 Since beta (systematic risk) of the portfolio is more than 1, it has more risk than the average asset in the market.

helping resources/FIN 220/Exercises/FIN220 - Module 3 Practice Risk_Return.pdf

FIN220 – Practice Questions (Module 3)

1. A stock’s expected return has the following distribution:

DEMAND FOR THE COMPANY’S PRODUCTS

PROBABILITY OF THIS

DEMAND OCCURRING

RATE OF RETURN IF

THIS DEMAND OCCURS

(%)

Weak 0.1 (50)

Below Average 0.2 (5)

Average 0.4 16

Above Average 0.2 25

Strong 0.1 60

Calculate the stock’s expected return and standard deviation.

2. Selena Maranjian invests the following sum of money in common stock having expected returns

as follows:

Common Stock Amount Invested in $ Expected Return

WOOPS 6,000 0.14

KABOOM 11,000 0.16

KAPOWW 9,000 0.17

UPDWN 7,000 0.13

RINGG 5,000 0.20

3. Stocks X and Y have the following probability distributions of expected future returns:

Probability X Y

0.1 -10% -35%

0.2 2% 0%

0.4 12% 20%

0.2 20% 25%

0.1 38% 45%

a) Calculate the expected rate of return, 𝑟 ̂ , for Stock Y. Return for Stock X, (�̂�X =12%).

b) Calculate the standard deviation of expected returns for Stock X. (That for Stock Y is 20.35

percent.)

4. Suppose RF = 5%, RM = 10%, and RA = 12%. a) Calculate Stock A’s beta. b) If Stock A’s beta were 2.0, what would be A’s new required rate of return?

5. Suppose RF = 9%, RM = 14%, and βi = 1.3. a) What is Ri, the required rate of return on Stock i? b) Now suppose kRF (1) increases to 10 percent or (2) decreases to 8 percent. The slope of the

SML remains constant. How would this affect RM and Ri? c) Now assume kRF remains at 9 percent but RM (1) increases to 16 percent or (2) falls to 13

percent. The slope of the SML does not remain constant. How would these changes affect Ri?

1. (Capital asset pricing model) Using the CAPM, estimate the appropriate required rate of return for the following three stocks, given that the risk-free rate is 5 percent, and the

expected return for the market is 17 percent.

2. (Security market line) Determine the expected return and beta for the following portfolio:

3. You own a portfolio consisting of the following stocks:

Calculate the expected return of your portfolio. (Hint: The expected return of a portfolio

equals the weighted average of the individual stock's expected return, where the weights

are the percentage invested in each stock.)

4. Suppose we have the following investments:

What is the expected return on this portfolio? What is the beta of this portfolio? Does this portfolio have more or less systematic risk than an average asset?

helping resources/FIN 220/Exercises/FIN220 - Module 4 Practice 1 Capital Budgeting.pdf

Prepared by: Rahayu Abdull Razak

Exercise on capital budgeting Exercise 1 Rawan Company is considering buying a machine. The firm’s required rate of return is 9%.

Year Machine 0 -$10,000 1 $6,000 2 $4,000 3 $3,000 4 $2,000

a. Payback period (Answer: 2 years)

b. Find the NPV? (Answer: $2,604.71) c. Find the PI? (Answer: 1.260471) d. Should the company purchased the machine? Explain your reason.

Exercise 2 Reem Company is considering buying a machine. The firm’s required rate of return is 10%.

Year Machine 0 -$30,000 1 $6,000 2 $6,000 3 $6,000 4 $6,000 5 $6,000

a. Find payback period. (Answer: 5 years)

b. Find the NPV? (Answer: -$7,255.28) c. Find the PI? (Answer: 0.758157)

d. Should the company purchased the machine? Explain your reason.

Prepared by: Rahayu Abdull Razak

Exercise 3 Bayan Company is considering the following two projects. Projected cash flows for these ventures are as follows:

Plan X Plan Y Initial Outlay = $2,000 Initial Outlay = $7,000 Cash Flow: Cash Flow: Yr 1 = $1,000 Yr 1 = $ 3,000 Yr 2 = 1,000 Yr 2 = $ 4,000 Yr 3 = 1,000 Yr 3 = $ 5,000 Yr 4 = 1,000 Yr 4 = $6,000

The cost of capital for this project is 12%. a. If the project is independent. Which projects should Bayan company choose?

(Answer: NPV X = $1,037.35; PI X=1.518675; PBP X= 2 yrs, NPV Y=$6,239.36; PI Y=1.891337; PBP Y= 2 yrs)

b. If the project is a mutually exclusive project, which project should Bayan choose?

Exercise 6 Haneen company is considering the two mutually exclusive project listed below            

Assume a required rate of return of 14%,

a. If all projects are mutually exclusive, which project will you choose? b. If the investment is subjected to a capital constraints of $50,000, which project (s)

will you choose?

Answer:

Project NPV PI PBP

A ($10,535.35) 0.72275 3.75 years B $1,471.19 1.08173 3.33 years

C ($14,717.22) 0.63207 more than 5

years

Project investment 1 2 3 4 5 A $38,000 $8,000 $8,000 $8,000 $8,000 $8,000 B $18,000 $5,000 $5,000 $6,000 $6,000 $7,000 C $40,000 $6,000 $6,000 $8,000 $9,000 $9,000

Prepared

Exercise Manar C and cash

The comp

1. C (A

2. C 3. (A 4. W

d by: Rahayu

e 10

ompany is in flows as fol

pany’s hurd

Calculate payb Answer: PBP

Calculate PI fo Answer: PI A

Which machin

u Abdull Raz

n the proces llows:

le rate is 11%

back period fo P A=2 yrs; P or A and B

A=1.221857; P ne should Man

zak

s of buying a

%. Required

or A and B. PBP B=2.12

PI B=1.41106 nar Company

a new autom

d:-

5)

69) y purchased?

mated machinne with initial investmen

nts

helping resources/FIN 220/Exercises/FIN220 - Module 4 Practice 2 Capital Budgeting Practice.pdf

FIN220 – Capital Budgeting Practice

1) Briarcliff Stove Company is considering a new product line to supplement its range line. It is anticipated that the new product line will involve cash investment of $700,000 at

time 0 and $1.0 million in year 1. After tax cash inflows of $250,000 are expected in year

2, $300,000 in year 3, $350,000 in year 4, and $400,000 each year thereafter through year

6. Though the product line might be viable after year 6, the company prefers to be

conservative and end all calculations at that time.

a) If the required rate of return is 15 percent, what is the net present value of the project? Is it acceptable?

b) Calculate Accounting Rate of Return c) What is the project’s payback period? d) What is the project’s profitability index? e) What would be the case if the required rate of return was 10 percent?

2) Carbide Chemical Company is considering the replacement of two old machines with a new, more efficient machine. It has determined that the relevant after-tax incremental

operating cash flows of this replacement proposal are as follows:

END OF YEAR

0 1 2 3

Cash flows -$204,424 $86,890 $106,474 $91,612

END OF YEAR

4 5 6 7 8

Cash flows $84,801 $84,801 0 0 0

What is the project’s accounting rate of return, net present value, payback period and,

profitability index? Assume that the required of return for this project is 14%. Is the project

acceptable?

mzahe
Cross-Out

helping resources/FIN 220/Exercises/FIN220 - Module 4 Practice 2 Capital Budgeting.pdf

FIN220 – Capital Budgeting Practice

1) Briarcliff Stove Company is considering a new product line to supplement its range line. It is anticipated that the new product line will involve cash investment of $700,000 at time 0 and $1.0 million in year 1. After tax cash inflows of $250,000 are expected in year 2, $300,000 in year 3, $350,000 in year 4, and $400,000 each year thereafter through year 10. Though the product line might be viable after year 10, the company prefers to be conservative and end all calculations at that time. a) If the required rate of return is 15 percent, what is the net present value of the project?

Is it acceptable? b) Calculate Accounting Rate of Return c) What is the project’s payback period? d) What is the project’s profitability index? e) What would be the case if the required rate of return was 10 percent?

2) Carbide Chemical Company is considering the replacement of two old machines with a new, more efficient machine. It has determined that the relevant after-tax incremental operating cash flows of this replacement proposal are as follows:

END OF YEAR 0 1 2 3

Cash flows -$404,424 $86,890 $106,474 $91,612

END OF YEAR 4 5 6 7 8

Cash flows $84,801 $84,801 $75,400 $66,000 $92,400

What is the project’s accounting rate of return, net present value, payback period and, profitability index? Assume that the required of return for this project is 14%. Is the project acceptable?

helping resources/FIN 220/Exercises/FIN220 - Module 5 Practice 1 Cost of Capital.pdf

1) Calculating Cost of Equity: The Mays Co. just issued a dividend of $2.60 per share on its 

common stock. The company is expected to maintain a constant 6 percent growth rate in its 

dividends indefinitely. If the stock sells for $60 a share, what is the company’s cost of equity? 

 

2) Calculating Cost of Equity: The City Street Corporation’s common stock has a beta of 1.2. If the 

risk‐free rate is 4.5 percent and the expected return on the market is 13 percent, what is the 

company’s cost of equity capital? 

 

3) Calculating Cost of Equity: Stock in Country Road Industries has a beta of 1.25. The market risk 

premium is 7 percent, and T‐bills are currently yielding 5 percent. Country Road’s most recent 

dividend was $2.10 per share, and dividends are expected to grow at a 5 percent annual rate 

indefinitely. If the stock sells for $34 per share, what is your best estimate of the company’s cost 

of equity? 

 

4) Calculating Cost of Preferred Stock: Holdup Bank has an issue of preferred stock with a $5 

stated dividend that just sold for $87 per share. What is the bank’s cost of preferred stock? 

 

5) Calculating Cost of Debt: A company has a debt issue on the market, a zero coupon bond with 

seven years left to maturity; the book value of this issue is $50 million, and the bonds sell for 61 

percent of par. What is the company’s total book value of debt? The total market value? What is 

your best estimate of the after tax cost of debt now? 

 

6) Calculating WACC: Mullineaux Corporation has a target capital structure of 50 percent common 

stock, 5 percent preferred stock, and 45 percent debt. Its cost of equity is 15 percent, the cost of 

preferred stock is 6 percent, and the cost of debt is 8 percent. The relevant tax rate is 35 

percent. 

a. What is Mullineaux’s WACC? 

b. The company president has approached you about Mullineaux’s capital 

structure. He wants to know why the company doesn’t use more preferred 

stock financing because it costs less than debt. What would you tell the 

president? 

helping resources/FIN 220/Exercises/FIN220 - Module 5 Practice 2 Cost of Capital.pdf

Exam 

Name___________________________________ 

 

ESSAY.   Write your answer in the space provided or on a separate sheet of paper. 

 

Maschale Corp. wants to issue bonds with a zero coupon bond, a face value of $1,000, and 12 years to maturity. Maschale 

estimates that the bonds will sell for $384.    Maschale Corp. common stock currently sells for $30 per share. Maschale paid 

a dividend yesterday of $4.00 per share and expects the dividend to grow at a constant rate of 5% per year. Maschaleʹs 

capital structure is $4 million debt, $6 million common equity and $5 million preferred stock which pays $3.2 dividend and 

selling at $40 per share. Maschaleʹs marginal tax rate is 35%. 

a. Calculate the after-tax cost of debt assuming Maschaleʹs bonds are its only debt.

b. Calculate the cost of preferred stock.

c. Calculate the cost of common equity.

d. Calculate the weighted average cost of capital 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MULTIPLE CHOICE.   Choose the one alternative that best completes the statement or answers the question. 

2) Milton Parker has a capital structure that consists of $7 million of debt, $2 million of preferred stock, and $11 million of 

common equity, based upon current market values. Parkerʹs yield to maturity on its bonds is 7.4%, and investors require 

an 8% return on Parkerʹs preferred and a 14% return on Parkerʹs common stock. If the tax rate is 35%, what is Parkerʹs 

WACC?  2) _______ 

 

A) 12.25%  B) 10.18%  C) 8.12%  D) 7.21% 

 

helping resources/FIN 220/Slides/FIN220 - M1 Intro.pptx

FIN220 - Module 1

The Role of Financial Management

YANBU UNIVERSITY COLLEGE

Management Science Department

© Yanbu University College

© Yanbu University College

I - ‹#›

After studying Module 1, you should be able to:

Explain why the role of the financial manager today is so important.

Describe "financial management" in terms of the three major decision areas that confront the financial manager.

Identify the goal of the firm and understand why shareholders' wealth maximization is preferred over other goals.

Understand the potential problems arising when management of the corporation and ownership are separated (i.e., agency problems).

Demonstrate an understanding of corporate governance.

Discuss the issues underlying social responsibility of the firm.

Understand the basic responsibilities of financial managers and the differences between a "treasurer" and a "controller."

Slide 2

© Yanbu University College

Why should I care about Financial Management ?

Prepare for the workplace of tomorrow.

Broadening expectations of financial knowledge and skills.

Use and understand financial terminology and concepts in team communication.

Developing cross-functional capabilities.

Critical thinking.

Slide 3

© Yanbu University College

The Role of Financial Management

What is Financial Management?

The Goal of the Firm

Corporate Governance

Organization of the Financial Management Function

Slide 4

© Yanbu University College

What is Financial Management?

Concerns the acquisition, financing, and management of assets with some overall goal in mind.

Slide 5

© Yanbu University College

Investment Decisions

What is the optimal firm size?

What specific assets should be acquired?

What assets (if any) should be reduced or eliminated?

Most important of the three decisions.

Slide 6

© Yanbu University College

Investment Decisions

Begins with determination of the total amount of assets needed to be held by the firm.

Balance sheet structure of a firm – Assets on left hand and Liabilities and Shareholders’ equity on right hand side.

Financial managers need to determine the dollar amount that appears on asset side – that is the size of the firm.

They also need to decide composition of the assets.

For example how much of the firm’s total assets should be devoted to cash or inventory?

Disinvestment question: what assets should be reduced, eliminated or replaced?

Explanation:

Slide 7

© Yanbu University College

Financing Decisions

What is the best type of financing?

What is the best financing mix?

What is the best dividend policy (e.g., dividend-payout ratio)?

How will the funds be physically acquired?

Determine how the assets (left-hand side of balance sheet) will be financed (right-hand side of balance sheet).

Slide 8

© Yanbu University College

Financing Decisions

Financial managers are concerned with the makeup of the right-hand side of the balance sheet.

It is the mix of financing for firms – the mix and the type of financing will differ across industries.

Dividend policy is viewed as an integral part of the firm’s financing decision.

Dividend payout ratio – determines the amount of earnings in the firm means that fewer dollars will be available for current dividend payments. It indicates the percentage of a firm’s earnings that is paid out to shareholders in cash.

Once the mix of financing has been decided, the financial managers must still determine how best to physically acquire the needed funds (process of getting a short-term or long term loan; sale of stocks or bonds).

Slide 9

Explanation:

© Yanbu University College

Asset Management Decisions

How do we manage existing assets efficiently?

After assets have been acquired and appropriate financing provided, these assets must still be managed efficiently.

Financial Manager has varying degrees of operating responsibility over existing assets.

It require the financial managers be more concerned with the current asset management than with fixed asset management.

Slide 10

© Yanbu University College

What is the Goal of the Firm?

Maximization of Shareholder Wealth!

Slide 11

Efficient financial management requires the existence of some objectives of goals.

Shares of common stock give evidence of ownership in a corporation.

Shareholder wealth is represented by the market price per share of the firm’s common stock, which in turn, is a reflection of the firm’s investment, financing and asset management decisions.

The success of a business decision should be judged by the effect that it ultimately has on share price.

Value creation occurs when we maximize the share price for current shareholders.

© Yanbu University College

Shortcomings of Alternative Perspectives

Could increase current profits while harming firm (e.g., defer maintenance, issue common stock to buy T-bills, etc.).

This would result in a decrease in each owner’s share of profits – that is earnings per share would fall.

Ignores changes in the risk level of the firm.

Profit Maximization

Maximizing a firm’s earnings after taxes.

Problems:

Slide 12

© Yanbu University College

Shortcomings of Alternative Perspectives

Does not specify timing or duration of expected returns.

Ignores changes in the risk level of the firm

Calls for a zero payout dividend policy (firms would never pay dividend)

Earnings per Share Maximization

Maximizing earnings after taxes divided by shares outstanding.

Problems:

Slide 13

© Yanbu University College

Strengths of Shareholder Wealth Maximization

Takes account of: current and future profits and EPS; the timing, duration, and risk of profits and EPS; dividend policy; and all other relevant factors.

Thus, share price serves as a indicator for business performance.

It also indicates how well management is doing on behalf of its shareholders.

Slide 14

© Yanbu University College

The Modern Corporation

There exists a SEPARATION between owners and managers.

Modern Corporation

Shareholders

Management

Slide 15

© Yanbu University College

The Modern Corporation

Slide 16

Agency Problems:

Separation of ownership and control in the modern corporation results in potential conflicts between owners and managers.

In particular, objectives of management may differ from the firm’s shareholders.

In a large corporation, stocks may be widely held; the shareholders cannot even make known their objectives, much less control or influence management.

Thus this separation ownership from management creates a situation in which management may act in its own best interests rather than for the interest of the shareholders.

© Yanbu University College

Role of Management

An agent is an individual authorized by another person, called the principal, to act in the latter’s behalf.

Shareholders hope that the agents will act in the shareholders’ best interest, delegate decision-making authority to the agents.

Management acts as an agent for the owners (shareholders) of the firm.

Slide 17

© Yanbu University College

Agency Theory

Agency Theory is a branch of economics relating to the behavior of principals (owners) and their agents (managers).

Jensen and Meckling developed a theory of the firm based on agency theory.

Slide 18

© Yanbu University College

Agency Theory

Incentives include, stock options, bonuses, and perquisites (“perks” such as company’s automobiles and expensive office).

Principals (shareholders) must provide incentives to the agents so that the agents (management) act in the principals’ best interests and then monitor results.

Slide 19

© Yanbu University College

Agency Theory

Monitoring is done by bonding the agents, reviewing management perquisites, auditing financial statements, and limiting management decisions.

Monitoring activities involve costs, results from the separation of ownership and control of a corporation.

Slide 20

© Yanbu University College

Corporate Social Responsibility Discussion

Class Discussion: What role should CSR and/or sustainability have on living the “goal of the firm”?

Corporate Social Responsibility (CSR): A business outlook that acknowledges a firm’s responsibilities to its stakeholders and the natural environment.

Sustainability: Meeting the needs of the present without compromising the ability of future generations to meet their own needs.

Slide 21

© Yanbu University College

Corporate Social Responsibility (CSR)

Wealth maximization does not mean that the management should CSR (such as protecting the customer, paying fair wages to employees, maintaining fair hiring practices and safe working conditions, supporting education, and becoming involved in environmental issues as clean air and water)

Management should also consider the interest of stakeholders.

Stakeholders include creditors, employees, customers, suppliers, communities in which a company operates, and others.

Only through attention to the concerns of the firm’s various stakeholders, then shareholder wealth maximization remains the appropriate goal in governing the firm.

Slide 22

© Yanbu University College

Corporate Governance

Corporate governance: represents the system by which corporations are managed and controlled.

Includes the relationship among a company’s shareholders, board of directors, and senior management.

This relationship provides frameworks within which corporate objectives are set and performance is monitored.

Three categories of individuals who are the key to corporate governance success:

i) Common shareholders who elect board of directors (BOD)

ii) the company’s board of directors

iii) top executives officers led by the chief executive officer (CEO)

Slide 23

© Yanbu University College

Board of Directors (BOD)

Typical responsibilities:

Set company-wide policy;

Advise the CEO and other senior executives;

Hire, fire, and set the compensation of the CEO;

Review and approve strategy, significant investments, and acquisitions; and

Oversee operating plans, capital budgets, and financial reports to common shareholders.

The BOD – the critical link between shareholders and managers.

The BOD when operating properly, is also an independent check on corporate management to ensure that management acts in the shareholders’ best interests.

Slide 24

© Yanbu University College

Organization of the Financial Management Function

Board of Directors

President

(Chief Executive Officer)

Executive Vice

President

(Operations)

Executive Vice

President

(Marketing)

Executive Vice

President

(Finance - CFO)

Slide 25

© Yanbu University College

Vice President (Treasurer)

Capital Investment

Cash Management

Commercial/investment banking relationships

Credit Management

Dividend Disbursement

Financial Analysis/Planning

Investor Relations

Mergers and Acquisitions

Pension Management

Insurance/Risk Management

Tax Analysis/Planning

Organization of the Financial Management Function

EVP of Finance

Controller

Cost Accounting

Cost Management

Data Processing

General Ledger

Government Reporting

Internal Control

Preparing Financial Statements

Preparing Budgets

Preparing Forecasts

Slide 26

© Yanbu University College

helping resources/FIN 220/Slides/FIN220 - M2 TVM.pptx

FIN220

MODULE 2

TIME VALUE AND MONEY

Copyright ©2014 Pearson Education, Inc. All rights reserved.

6-‹#›

Learning Objectives

Understand what is meant by time value of money.

Explain the mechanics of compounding, that is, how money grows over time when it is invested.

Understand the relationship between present value and future value

Distinguish between an ordinary annuity and an annuity due.

Calculate both the future and present value of: i) an amount invested today; ii) a stream of equal cash flows (an annuity) and iii) a stream of mixed cash flows.

Use interest factor tables and understand how they provide a shortcut to calculating present and future value.

Use interest factor tables to find an unknown interest rate or growth rate when the number of time periods and future and present values are known.

2-‹#›

Introduction to TVM

Time value of money; that is, a dollar today is worth more than a dollar received a year from now because a dollar today can be invested and earn interest.

Concept of Interest - This concept illustrates what economists call an opportunity cost of passing up the earning potential of a dollar today.

This opportunity cost is the time value of money.

Time value of money is one of the most important concepts in finance.

The time value of money refers to a dollar in hand being worth more than a dollar received in the future, because you can invest today’s dollar in an interest bearing account that grows in value over time.

2-‹#›

Introduction to TVM

The time value of money is the key concept in determining the value of the firm and the value of investment proposals.

Different investment proposals produce different sets of cash flows over different time periods.

How does the manager compare these?

We will see that the concept of the time value of money will let us do this.

Thus, an understanding of the time value of money is essential to an understanding of financial management, whether basic or advanced.

Understanding the techniques of compounding and moving money through time (time value of money) are critical to almost every business decision.

It will also help you to understand such varied things as how stocks and bonds are valued, how much you should save for your children's education, and how much your mortgage payments will be.

2-‹#›

The Time Value of Money

The Interest Rate

Simple Interest

Compound Interest

Annuities

Compounding More Than Once per Year

2-‹#›

Present Value (PV) : Value as of today

Future Value (FV) : Value at some point in the future

Interest rate (r) : rate of return (FV) or discount rate (PV)

Cost of capital

Required return

Number of Periods (n) : usually measured in months or years

Payment (C) : used for annuity problems

The terms:

2-‹#›

COMPOUND INTEREST, FUTURE, AND PRESENT VALUE

2-‹#›

Using Timelines to Visualize Cash Flows

A series of cash flows lasting several periods is defined as a stream of cash flows. We can represent a stream of cash flows on a timeline, a linear representation of the timing of the expected cash flows.

2-‹#›

Simple Interest

Interest is earned only on principal.

Example: Compute simple interest on $100 invested at 6% per year for three years.

1st year interest is $6.00

2nd year interest is $6.00

3rd year interest is $6.00

Total interest earned: $18.00

2-‹#›

2-‹#›

Compound Interest

Compounding is when interest paid on an investment during the first period is added to the principal; then, during the second period, interest is earned on the new sum (that includes the principal and interest earned so far).

2-‹#›

Compound Interest

Example: Compute compound interest on $100 invested at 6% for three years with annual compounding.

1st year interest is $6.00 Principal now is $106.00

2nd year interest is $6.36 Principal now is $112.36

3rd year interest is $6.74 Principal now is $119.10

Total interest earned: $19.10

2-‹#›

2-‹#›

Future Value

Future Value is the amount a sum will grow to in a certain number of years when compounded at a specific rate.

FVN = PV (1 + r)n

FVN = the future of the investment at the end of “n” years

r = the annual interest (or discount) rate

n = number of years

PV = the present value, or original amount invested at the beginning of the first year

2-‹#›

Future Value Example

Example: What will be the FV of $100 in 2 years at interest rate of 6%?

FV2 = PV(1 + r)2 = $100 (1 + 0.06)2

= $100 (1.06)2

= $112.36

2-‹#›

How to Increase the Future Value?

Future Value can be increased by:

Increasing number of years of compounding (N)

Increasing the interest or discount rate (r)

Increasing the original investment (PV)

See example on next slide

2-‹#›

Changing R, N, and PV

a. You deposit $500 in bank for 2 years. What is the FV at 2%? What is the FV if you change interest rate to 6%?

FV at 2% = 500*(1.02)2 = $520.2

FV at 6% = 500*(1.06)2 = $561.8

b. Continue the same example but change time to 10 years. What is the FV now?

FV = 500*(1.06)10= $895.42

c. Continue the same example but change contribution to $1500. What is the FV now?

FV = 1,500*(1.06)10 = $2,686.27

2-‹#›

Figure 5-1

2-‹#›

Figure 5-2

2-‹#›

Figure 5-2

Figure 5-2 illustrates that we can increase the FV by:

Increasing the number of years for which money is invested; and/or

Investing at a higher interest rate.

2-‹#›

Computing Future Values using Calculator or Excel

Review discussion in the text book

Excel Function for FV:

= FV(rate,nper,pmt,pv)

2-‹#›

2-‹#›

2-‹#›

22

Present Value

Present value reflects the current value of a future payment or receipt.

2-‹#›

Present Value

PV = FVn {1/(1 + r)n}

FVn = the future value of the investment at the end of n years

n = number of years until payment is received

r = the interest rate

PV = the present value of the future sum of money

2-‹#›

PV example

What will be the present value of $500 to be received 10 years from today if the discount rate is 6%?

PV = $500 {1/(1+0.06)10}

= $500 (1/1.791)

= $500 (0.558)

= $279

2-‹#›

Figure 5-3

2-‹#›

Figure 5-3

Figure 5-3 illustrates that PV is lower if:

Time period is longer; and/or

Interest rate is higher.

2-‹#›

2-‹#›

Using Excel

Excel Function for PV:

= PV(rate,nper,pmt,fv)

2-‹#›

ANNUITIES

2-‹#›

Annuity

An annuity is a series of equal dollar payments for a specified number of years.

Ordinary annuity payments occur at the end of each period.

2-‹#›

FV of Annuity

Compound Annuity

Depositing or investing an equal sum of money at the end of each year for a certain number of years and allowing it to grow.

2-‹#›

FV Annuity - Example

What will be the FV of a 5-year, $500 annuity compounded at 6%?

FV5 = $500 (1 + 0.06)4 + $500 (1 + 0.06)3 + $500(1 + 0.06)2 + $500 (1 + 0.06) + $500

= $500 (1.262) + $500 (1.191) + $500 (1.124) + $500 (1.090) + $500

= $631.00 + $595.50 + $562.00 + $530.00 + $500

= $2,818.50

2-‹#›

Table 5-1

2-‹#›

FV of an Annuity – Using the Mathematical Formulas

FVn = PMT {(1 + r)n – 1/r}

FV n = the future of an annuity at the end of the nth year

PMT = the annuity payment deposited or received at the end of each year

r = the annual interest (or discount) rate

n = the number of years

2-‹#›

FV of an Annuity – Using the Mathematical Formulas

What will $500 deposited in the bank every year for 5 years at 10% be worth?

FV = PMT ([(1 + r)n – 1]/r) = $500 (5.637) = $2,818.50

2-‹#›

FV of Annuity: Changing PMT, N, and r

What will $5,000 deposited annually for 50 years be worth at 7%?

FV = $2,032,644

Contribution = 250,000 (= 5000*50)

Change PMT = $6,000 for 50 years at 7%

FV = 2,439,173

Contribution= $300,000 (= 6000*50)

2-‹#›

FV of Annuity: Changing PMT, N, and r

3. Change time = 60 years, $6,000 at 7%

FV = $4,881,122

Contribution = 360,000 (= 6000*60)

4. Change r = 9%, 60 years, $6,000

FV = $11,668,753

Contribution = $360,000 (= 6000*60)

2-‹#›

Present Value of an Annuity

Pensions, insurance obligations, and interest owed on bonds are all annuities. To compare these three types of investments we need to know the present value (PV) of each.

2-‹#›

Table 5-2

2-‹#›

PV of Annuity – Using the Mathematical Formulas

PV of Annuity = PMT {[1 – (1 + r)–1]}/r

= 500 (4.212)

= $2,106

2-‹#›

Annuities Due

Annuities due are ordinary annuities in which all payments have been shifted forward by one time period. Thus, with annuity due, each annuity payment occurs at the beginning of the period rather than at the end of the period.

2-‹#›

Annuities Due

Continuing the same example: If we assume that $500 invested every year at 6% to be annuity due, the future value will increase due to compounding for one additional year.

FV5 (annuity due) = PMT {[(1 + r)n – 1]/r} (1 + r)

= 500(5.637)(1.06)

= $2,987.61

(versus $2,818.80 for ordinary annuity)

2-‹#›

2-‹#›

2-‹#›

Amortized Loans

Loans paid off in equal installments over time are called amortized loans. Example: Home mortgages, auto loans.

Reducing the balance of a loan via annuity payments is called amortizing.

2-‹#›

Amortized Loans

The periodic payment is fixed. However, different amounts of each payment are applied toward the principal and interest. With each payment, you