ASSUME THAT YOU WERE RECENTLY HIRED AS ASSISTANT TO

JERRY LEHMAN, FINANCIAL VP OF COLEMAN TECHNOLOGIES.

YOUR FIRST TASK IS TO ESTIMATE COLEMAN$$S COST OF CAPITAL.

LEHMAN HAS PROVIDED YOU WITH THE FOLLOWING DATA, WHICH

HE BELIEVES MAY BE RELEVANT TO YOUR TASK:

$(1)$ THE FIRM$$S MARGINAL TAX RATE IS $40$ PERCENT.

$(2)$ THE CURRENT PRICE OF COLEMAN$$S $12$ PERCENT COUPON,

SEMIANNUAL PAYMENT, NONCALLABLE BONDS WITH $15$ YEARS

REMAINING TO MATURITY IS $$1,153\mathrm{.}72.$ COLEMAN DOES NOT USE

SHORT$-$TERM INTEREST$-$BEARING DEBT ON A PERMANENT

BASIS. NEW BONDS WOULD BE PRIVATELY PLACED WITH NO

FLOTATION COST.

$(3)$ THE CURRENT PRICE OF THE FIRM$$S $10$ PERCENT, $$100$ PAR

VALUE, QUARTERLY DIVIDEND, PERPETUAL PREFERRED

STOCK IS $$113\mathrm{.}10.$ COLEMAN WOULD INCUR FLOTATION COSTS

OF $$2\mathrm{.}00$ PER SHARE ON A NEW ISSUE.

$(4)$ COLEMAN$$S COMMON STOCK IS CURRENTLY SELLING AT $$50$

PER SHARE. ITS LAST DIVIDEND $($D$0)$ WAS $$4\mathrm{.}19,$ AND DIVIDENDS

ARE EXPECTED TO GROW AT A CONSTANT RATE OF $5$ PERCENT

IN THE FORESEEABLE FUTURE. COLEMAN$$S BETA IS $1\mathrm{.}2,$ THE

YIELD ON TREASURY BONDS IS $7$ PERCENT, AND THE MARKET

RISK PREMIUM IS ESTIMATED TO BE $6$ PERCENT. FOR THE

BOND$-$YIELD$-$PLUS$-$RISK$-$ PREMIUM APPROACH, THE FIRM USES

A $4$ PERCENTAGE POINT RISK PREMIUM.

$(5)$ UP TO $$300,000$ OF NEW COMMON STOCK CAN BE SOLD AT A

FLOTATION COST OF $15$ PERCENT. ABOVE $$300,000,$ THE

FLOTATION COST WOULD RISE TO $25$ PERCENT.

$(6)$ COLEMAN$$S TARGET CAPITAL STRUCTURE IS $30$ PERCENT

LONG$-$ TERM DEBT, $10$ PERCENT PREFERRED STOCK, AND $60$

PERCENT COMMON EQUITY.

$(7)$ THE FIRM IS FORECASTING RETAINED EARNINGS OF $$300,000$

FOR THE COMING YEAR.

Please Show work in excel for these questions:

WHAT IS A MARGINAL COST OF CAPITAL $($MCC$)$ SCHEDULE?

CONSTRUCT A GRAPH THAT SHOWS COLEMAN$$S MCC SCHEDULE.

OLEMAN$$S DIRECTOR OF CAPITAL BUDGETING HAS IDENTIFIED THE

FOLLOWING POTENTIAL PROJECTS:

PROJECT COST LIFE CASH FLOW IRR

A $$700,0005$ YEARS $$218,79517\mathrm{.}0\%$

B $500,0005152,70516\mathrm{.}0$

B$*500,0002079,88115\mathrm{.}0$

C $800,0005219,18511\mathrm{.}5$

PROJECTS B AND B$*$ ARE MUTUALLY EXCLUSIVE, WHEREAS THE OTHER

PROJECTS ARE INDEPENDENT. ALL OF THE PROJECTS ARE EQUALLY

RISKY.

$(1)$ PLOT THE IOS SCHEDULE ON THE SAME GRAPH THAT CONTAINS

YOUR MCC SCHEDULE. WHAT IS THE FIRM$$S MARGINAL COST OF

CAPITAL FOR CAPITAL BUDGETING PURPOSES?

L$.(2)$WHAT IS THE DOLLAR SIZE, AND THE INCLUDED PROJECTS, IN

COLEMAN'S OPTIMAL CAPITAL BUDGET? EXPLAIN YOUR ANSWER FULLY.

L$.(3)$ WOULD COLEMAN$$S MCC SCHEDULE REMAIN CONSTANT AT $12\mathrm{.}8$

PERCENT BEYOND $$2$ MILLION REGARDLESS OF THE AMOUNT OF

CAPITAL REQUIRED?

L$.(4)$ IF WACC$3$ HAD BEEN $18\mathrm{.}5$ PERCENT RATHER THAN $12\mathrm{.}8$ PERCENT, BUT

THE SECOND WACC BREAK POINT HAD STILL OCCURRED AT

$$1,000,000,$ HOW WOULD THAT HAVE AFFECTED THE ANALYSIS?

M$.$ SUPPOSE YOU LEARNED THAT COLEMAN COULD RAISE ONLY $$200,000$ OF

NEW DEBT AT A $10$ PERCENT INTEREST RATE AND THAT NEW DEBT

BEYOND $$200,000$ WOULD HAVE A YIELD TO INVESTORS OF $12$ PERCENT.

TRACE BACK THROUGH YOUR WORK AND EXPLAIN HOW THIS NEW

FACT WOULD CHANGE THE SITUATION.