Hi, I need your help to get answers for the following ten questions and please put all calculation at Excel sheet

I o appreciate your help

(Cost of debt) Belton Distribution Company is issuing a $1,000 par value bond that pays 10 percent annual interest and matures in 15 years that is paid semiannually. Investors are willing to pa);r $958 for the bond. The company;' is in the 18 percent marginal tax bracket. What is the rm's after-tax cost of debt on the bond? The rm's after-tax cost of debt on the bond is |:|%. (Round to two decimal places.) {Defining capital structure weights] In August 2015 the capital structure of the Emerson Electric Corporation (EMR) (measured in book and market values) was as follows: % Shortterm debt $2,550 $2,550 Longterm debt 4,250 4,250 Common equity 5,025 55,?55 Total capital $14,525 $42,555 What weights should Emerson use when computing the rm's weighted average cost of capital? The appropriate weight of debt, wd, is 'ib. (Round to one decimal place.) The appropriate weight ofcommon equity, wcs, is 'ib. (Round to one decimal place.) (Measuring growth] If Peppercline, lnc.'s return on equity is 15 percent and the management plans to retain 58 percent of earnings for investment purposes, whatwill be the rm's growth rate? The rm's growth rate will be |:|%. (Round to two decimal places.) (Computing interest tax savings) Dharma Supply has earnings before interest and taxes (EBIT) of $527,000, interest expenses of $290,000, and faces a corporate tax rate of 34 percent . What is Dharma Supply's net income? a b. What would Dharma's net income be it it didn't have any debt (and consequently no interest expense)? c. What are the rm's interest tax savings? a. Dharma Supply's net income is $ . (Round to the nearest dollar.) b. if it didn't have an},r debt, Dharma Supply's net income is $ , (Round to the nearest dollar) c. The rm's interest tax savings are $ , (Round to the nearest dollar) (Computing the cost of preferred stock) In the spring of 2017 the Marrion Metal Shaping Company was planning on issuing preferred stock to help nance a major plant expansion. Your rm is planning to issue preferred stock. The stock is expected to sell for $97.35 a share and will have a $100 par value on which the rm will pay a 10.4 percent dividend. What is the cost of capital to the rm for the preferred stock? The rm's cost of capital for the preferred stock is |:|%. (Round to two decimal places.) (Common stock valuation) Gilliland Motor, Inc., paid a $4.29 dividend last year. If Gilliland's return on equity is 32 percent, and its retention rate is 22 percent, what is the value of the common stock if the investors require a rate of return of 22 percent? The value ofthe common stock is $|:|. (Round to the nearest cent.) Moody'sto Put Bank Hybrids on Review for Downgrades Source: Mendy-dd, 5am. and John elm "Moody's b Pul Bank Hytmds on Remem- hr mummies," Blooming-rum". httpwww.Hoornbe!g.eorr\lappsirlew7pid=205lmsid=evUDvRtbml# paged "muons The nancial crisis and subsequent government Intervention In the bankIng Industry has created some uncertaInty for bondholders. ln many cases the government's eorts to prop up troubled nancial InstItutIons has actually been harmful to bondholders For example. ll'I some countries nancial Instrlution bonds have skipped interest payments wrthout defaulbng due to government mandates. Hybrid securrties have been particularly problematic sincethey have characteristlcs of both debt and equrty. Based on the way that some countries have treated these securities Moody's has been forced to reevaluate someolthe underlying assumptions used when the bonds were rated The new model will lIkely result Ina numberofdowngradee for many hybrids sincethe levelofrisk ofthese securItiee is higher than previously thought. Thinlung Cnlioally Quesh'ons 1. All ofthe folloimng are bond ratIng agencies except; 0 A. Moody's O a. NYSE Bond Haters O I: FItches O n Standard and Poors 2 Companies wIth higher bond ratlngs can borrow money at a rate 0 A. prIme 0 El. Fed funds 0 (3- higher 0 [l lower 3. Unrated debt typically carries a higher Interest rate because Investors assume It must be 0 A. higher risk 0 El. risk free 0 c. lbwerrisk O n a better Investment (Related to Checkpoint 10.1) (Common stock valuation) Header Motor, Inc., paid a $3.84 dividend last year. At a constant growth rate of 4 percent, what is the value of the common stock if the investors require a 13 percent rate of return? The value of the common stock is $|:|. (Round to the nearest cent.) (Preferred stock valuation] Pioneer's preferred stock is selling for $33 in the market and pays a $2.60 annual dividend. a. If the market's required yield is 9 percent, what is the value of the stock for that investor? b. Should the investor acquire the stock? a. The value of the stock for that investor is $|:| per share. (Round to the nearest cent.) b. Should the investor acquire the stock? [Select from the drop-down menus.) The investor l1 acquire the stock because it is currently l1 in the market. Enter your answer in the answer box. underprlced overpriced (Preferred stock valuation) Pioneer's preferred stock is selling for $33 in the market and pays a $2.60 annual dividend. a. If the market's required yield is 9 percent, what is the value of the stock for that investor? b. Should the investor acquire the stock? a. The value of the stock for that investor is 33'] per share. (Round to the nearest cent.) b. Should the investor acquire the stock? (Select from the drop-down menus.) The investor I: acquire the stock because it is currently I: in the market. should not Enter your an r box. should