Graph the internal rates of retun on investment projects against the marginal cost of capital...
70.2K
Verified Solution
Question
Accounting
Graph the internal rates of retun on investment projects against the marginal cost of capital for the following 6 projects. Which projects should be selected? Use Excel.
Project | Cost (M) | IRR |
1 | $ 7,000,000.00 | 8.73% |
2 | $ 7,000,000.00 | 8.40% |
3 | $ 8,000,000.00 | 9.60% |
4 | $ 5,000,000.00 | 9.14% |
5 | $ 5,000,000.00 | 8.20% |
6 | $ 8,000,000.00 | 8.18% |
EXHIBIT 1
Wyoming Energy Development, Inc.
\Balance SheetFor Year Ending April 30, 1991.A
ssets1991
Cash$9,000.000
Accounts receivable31,000.000
Inventories12,000.000
Total current assets$52,000.000
Net fixed assets193,000.000
Goodwill7,000.000
Total assets$252,000.000
Liabilities and EquityAccounts payable$850.000
Current debt10,000.000
Accrued taxes1,150.000
Total current liabilities$12,000.000
Long-term debt72,000.000
Preferred stock43,000,000
Common stock114,000.000
Retained earnings11,000.000
Total liabilities and equity$ 252,000.000
To determine a weighted average cost of capital for WED, it was necessary for LindaBellich to examine the costs associated with each source of funding used. In the past, thelargest sources of funding had been the issuance of new common stock and internallygenerated funds. Through conversationswith the comptroller and other members of theboard of directors, Bellich learned that the firm, in fact, wished to maintain its currentfinancialstructure since it is in accordance with the book value weights shown in Exhibit I.She further determined that the strong growth patterns that WED had exhibited over thepast 10 years were expected to continue indefinitely because of the dwindling supply ofU.S. and Japanese domestic oil and the growing importance of, and U.S. and Japanesedependence on, coal and other alternative energy resources. Through further investigation,Bellich learned that WED could issue additional shares of common stock, which had a parvalue of $25 per share and were selling at a current market price of $45. The expecteddividend for the next period would be $2 pershare,withexpectedgrowthatarateof6 percent per year for the foreseeable future. The underwriting commission paid to WEDsinvestment banker would amount to$2 per share and would be for insuring the issue againstthe risk of adverse market fluctuations in the stocks selling price during the distributionprocess, in addition to performing the function of actually selling the security and providingadvice as to the timing and pricing of the issue
Preferred stock at 6 percent also could be issued with the help of an investment banker at$97 per share with a par value of $100 per share. Of this $97, 3.1 percent would go to theinvestment banker for his help in marketing the issue, with the remainder of the funds goingto WED.
Finally, Bellich learned that it would be possible for WED to raise an additional $1 millionthrough a one-year loan from WEDs Chicago bank at 9 percent. Any amount raised over$1 million would cost WED 14 percent., Short-term debt has always been used byWyoming to finance capital expenditures, and as WED grows, it is expected to maintain itsproportion in the capital structure to support capital expansion. Also, $6 million could beraised through a bond issue with 30 years maturity with a 10 percent coupon at 98 percentof face value. On this issue, 2 percent of the face value would be charged as anunderwriting commission. If it became necessary to raise more funds via long-termdebt,$3 million more could be accumulated through the issuance of additional 30 year bondssold at 95 percent of face value,withthecouponratebeingraisedto11percentand2 percent of the face value being charged as an underwriting commission. While anyadditional funds raised via long-term debt would necessarily have a 30-year maturity with a14 percent coupon yield and be sold at 95 percent of face value, 2 percent of this face valuewould be charged as an underwriting fee. Here again, this fee would go to the investmentbanker for hishelp in marketing the issue.
In the past, WED has calculated a weighted average of these sources of funds to determineits cost of capital. In discussions with the current comptroller, the point was raised thatwhile this served as an appropriate calculation for externally generated funds, it did not takeinto account the fact that much of the funds used for capital expenditures by WED wereinternally generated. For example, WED is expected to produce $5 million in depreciation-generated funds in addition to retaining $4 million of its earnings during the coming period.The comptroller agreed that there should be some cost associated with retained earningsfinancing incorporated into the calculations, but depreciation charges should not beincluded since they, as opposed to all other financing methods, do not appear on theliability side of the balance sheet. Although Bellich was not completely convinced by thecomptrollers logic, she continued with her work
Get Answers to Unlimited Questions
Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!
Membership Benefits:
- Unlimited Question Access with detailed Answers
- Zin AI - 3 Million Words
- 10 Dall-E 3 Images
- 20 Plot Generations
- Conversation with Dialogue Memory
- No Ads, Ever!
- Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Other questions asked by students
StudyZin's Question Purchase
1 Answer
$0.99
(Save $1 )
One time Pay
- No Ads
- Answer to 1 Question
- Get free Zin AI - 50 Thousand Words per Month
Unlimited
$4.99*
(Save $5 )
Billed Monthly
- No Ads
- Answers to Unlimited Questions
- Get free Zin AI - 3 Million Words per Month
*First month only
Free
$0
- Get this answer for free!
- Sign up now to unlock the answer instantly
You can see the logs in the Dashboard.