our excel fin4414 (1)

our excel fin4414 (1) - $48.33 46.65 less R&D Amort...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
1996 1997 1998 1999 2000 2001 $12,487.00 $14,610.00 $17,094.00 $20,000.00 $39,000.00 $20,000.00 $2,497.40 $2,497.40 $2,497.40 $2,497.40 $2,497.40 $2,922.00 $- $2,922.00 $2,922.00 $2,922.00 $2,922.00 $3,418.80 $- $- $3,418.80 $3,418.80 $3,418.80 $4,000.00 $- $- $- $4,000.00 $4,000.00 $7,800.00 $- $- $- $- $7,800.00 $4,000.00 $20,638.20 $22,140.80 $103,191.00 $133,864.00 less Cumm. Amort. $50,231.40 $83,045.20 $52,959.60 $50,819.00 1996 1997 1998 1999 2000 2001 Ad Expense $34.00 $38.00 $41.00 $45.00 $50.00 $45.00 $11.33 $11.33 $11.33 $- $- $- $- $12.67 $12.67 $12.67 $- $- $- $- $13.67 $13.67 $13.67 $15.00 $- $- $- $15.00 $15.00 $16.67 $- $- $- $- $16.67 $15.00 $45.33 $46.67 Cumm. Ad Expense $208.00 $253.00 less Cumm. Amort. $159.67 $206.35 Capitalized Ad Expense $48.33 $46.65 CAPITAL 2000 2001 NOPAT 2000 2001 NOA $135,000.00 110000 Operating Earnings $51,000.00 20000 $52,959.60 50819 $39,000.00 20000 add Ad Expense
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $48.33 46.65 less R&D Amort. $20,638.20 22140.8 Add acc. Goodwill $10,000.00 12500 add Ad Expense $50.00 45 Capital $198,007.93 173365.7 less Ad Amort. $45.33 46.67 add Goodwill $2,500.00 2500 Cost of Capital 11% 11% NOPBT $71,866.47 20358.53 less taxes $18,725.00 7875 NOPAT $53,141.47 12,483 EVA in 2000 EVA = NOPAT - (CAPITAL * COST OF CAPITAL) EVA in 2001 $31,360.60 = NOPAT - (CAPITAL * COST OF CAPIT $(6,587.23) BONUS PAYOUT 2000 BONUS PAYOUT 2001 CALCULATED BONUS = TARGET BONUS * EVA PERFORMANCE CALCULATED BONUS = TARGET BONUS * EVA PERFORMANCE FORMANCE = 1 + ((ACTUAL IMPROVEMENT - IMPROVEMENT GOAL)/INRFORMANCE = 1 + ((ACTUAL IMPROVEMENT - IMPROVEMENT GOAL)/INTE EVA PERFORMANCE 3.1908833333 EVA PERFORMAN-2.341485392 CALCULATED BONUS $382,906.00 CALCULATED BO ### BONUS PAYOUT = TARGET BONUS + 50% REMANINING BALANCE BONUS PAYOUT = TARGET BONUS + 50% REMANINING BALANCE BONUS PAYOUT $251,453.00 BONUS PAYOUT $-...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online