Question

In: Accounting

You have finally saved​ $10,000 and are ready to make your first investment. You have the...

You have finally saved​ $10,000 and are ready to make your first investment. You have the three following alternatives for investing that​ money:

A Microsoft bond with a par value of ​$1000 that pays 8.75 percent on its par value in​ interest, sells for ​$1235.11​, and matures in 9 years.

Southwest Bancorp preferred stock paying a dividend of ​$2.59 and selling for ​$22.63.

Emerson Electric common stock selling for ​$56.03​, with a par value of​ $5. The stock recently paid a ​$1.38 ​dividend, and the​ firm's earnings per share has increased from ​$2.39 to ​$3.85 in the past 5 years. The firm expects to grow at the same rate for the foreseeable future.

Your required rates of return for these investments are 5.50 percent for the​ bond, 12.00 percent for the preferred​ stock, and 13.00 percent for the common stock. Using this​ information, answer the following questions.

a. Calculate the value of each investment based on your required rate of return.

b. Which investment would you​ select? Why?

c. Assume Emerson​ Electric's managers expect an earnings to grew at 3 percent above the historical growth rate. How does this affect your answers to parts ​(a​) and ​(b​)?

d. What required rates of return would make you indifferent to all three​ options?

If your required rate of return on the bonds is 5.50​%, what is the value of Microsoft​ bond?

Solutions

Expert Solution

To solve this question just input those variables which are to be used in logistic regression, as the question talks about using two variables only that is total loans and leases to total assets & total expenses/ total assets, so we will not input total cap/assets as an input variable in our excel, here we go

As one can see, we have taken only two variables , total exp/assets and total lns & leases/ assets in calculation, follwing steps have been followed to construct the above table

1. Assume logit= b0+ b1* independent variable1+ b2* independent variable 2 , take values of b0=0.1, b1=0.1, b2=0.1, note that these values of b0, b1 and b2 are just taken for calculation, one could assume any values here for bo , b1 and b2

2. Calculate exponential of logit in the next column by using exp (value in previous column)

3. Calculate probability by using formula, probability= exp (logit)/ { 1+ exp(logit)} in the next column

4. In next column, calculate log likelihood by using formula : financial condition value (i.e. 1 or 0) * LN( probability calculated in previous column) + (1- financial condition value)* LN( 1- probability calculated in previous column)

5. take the total of the column values of log likelihood

6. use solver function in excel to change this total by putting max value of 0 and changing the variable cells containing assumed values of b0, b1 and b2 , by clicking on solve, you will get actual values of b0, b1 and b2

which comes out to be b0=-14.72, b1=89.83, b2= 8.37

therefore you will get logit as

-14.72+ 89.83* Total exp/assets+8.37*Total lns & lsses/ assets

With values given in the question as total exp/ assets= 0.11 and total loans & leases/ assets= 0.6 , we get

logit as -14.72+ 89.83* 0.11+ 8.37*0.6= 0.1833

exp (logit) = 1.20

Probability= 0.546

Loglikelihood= 1*LN(0.546)+0*LN(1-0.546)= LN(0.546)= -0.605


Related Solutions

You have finally saved​ $10,000 and are ready to make your first investment. You have the...
You have finally saved​ $10,000 and are ready to make your first investment. You have the three following alternatives for investing that​ money: A Microsoft bond with a par value of $1,000 that pays8.75 percent on its par value in​ interest, sells for ​$1,203.06​, and matures in 18 years. Southwest Bancorp preferred stock paying a dividend of ​$3.253.25 and selling for $22.69. Emerson Electric common stock selling for $55.55​, with a par value of​ $5. The stock recently paid a...
You have finally saved​ $10,000 and are ready to make your first investment. You have the...
You have finally saved​ $10,000 and are ready to make your first investment. You have the three following alternatives for investing that​ money: • A Microsoft bond with a par value of ​$1,000 that pays 9.50 percent on its par value in​ interest, sells for ​$1,283.61​, and matures in19 years. • Southwest Bancorp preferred stock paying a dividend of ​$3.23 and selling for ​$21.56. • Emerson Electric common stock selling for ​$63.11​, with a par value of​ $5. The stock...
You have finally saved​ $10,000 and are ready to make your first investment. You have the...
You have finally saved​ $10,000 and are ready to make your first investment. You have the three following alternatives for investing that​ money: bullet • A Microsoft bond with a par value of ​$ 1 comma 000 1,000 that pays 9.25 9.25 percent on its par value in​ interest, sells for ​$ 1 comma 218.53 1,218.53​, and matures in 7 7 years. bullet • Southwest Bancorp preferred stock paying a dividend of ​$ 2.11 2.11 and selling for ​$ 28.27...
You have finally saved​ $10,000 and are ready to make your first investment. You have the...
You have finally saved​ $10,000 and are ready to make your first investment. You have the three following alternatives for investing that​ money: •A Microsoft bond with a par value of ​$1,000 that pays 8.75 percent on its par value in​ interest, sells for ​$1,251.99​, and matures in 17 years. •Southwest Bancorp preferred stock paying a dividend of ​$3.36 and selling for ​$24.49. •Emerson Electric common stock selling for $56.48​, with a par value of​ $5. The stock recently paid...
You have finally saved​ $10,000 and are ready to make your first investment. You have the...
You have finally saved​ $10,000 and are ready to make your first investment. You have the three following alternatives for investing that​ money: • A Microsoft bond with a par value of ​$1000 that pays 9.75 percent on its par value in​ interest, sells for ​$1,213.93​ , and matures in 99 years. • Southwest Bancorp preferred stock paying a dividend of ​$3.34 and selling for ​$28.92. • Emerson Electric common stock selling for ​$63.46​, with a par value of​ $5....
You have finally saved​ $10,000 and are ready to make your first investment. You have the...
You have finally saved​ $10,000 and are ready to make your first investment. You have the three following alternatives for investing that​ money: A Microsoft bond with a par value of ​$1,000 that pays 8.00 percent on its par value in​ interest, sells for ​$1,150.62​, and matures in 18 years. Southwest Bancorp preferred stock paying a dividend of ​$2.33 and selling for ​$29.71. Emerson Electric common stock selling for ​$58.67​, with a par value of​ $5. The stock recently paid...
You have finally saved​ $10,000 and are ready to make your first investment. You have the...
You have finally saved​ $10,000 and are ready to make your first investment. You have the three following alternatives for investing that​ money: A Microsoft bond with a par value of ​$1,000 that pays 9.50 percent on its par value in​ interest, sells for ​$1,147.45​, and matures in 17 years. bullet Southwest Bancorp preferred stock paying a dividend of ​$3.14 and selling for ​$24.61. Emerson Electric common stock selling for ​$59.27​, with a par value of​ $5. The stock recently...
You have finally saved $10,000 and are ready to make your first investment. You have the...
You have finally saved $10,000 and are ready to make your first investment. You have the three following alternatives for investing that money: Bank of America bonds with a par value of $1,000, that pays a 6.35 percent on its par value in interest, sells for $1,020, and matures in 5 years. Southwest Bancorp preferred stock paying a dividend of $2.63 and selling for $26.25. Emerson Electric common stock selling for $52, with a par value of $5. The stock...
you have finally saved $10,000 and are ready to make your first investment. You have the...
you have finally saved $10,000 and are ready to make your first investment. You have the three following alternatives for investing that money: Captial cities ABC, Inc. bonds with a par value of $1,000, that pays and 8.75 percent on its par value in interest, sells for $1,314, and marures in 12 years. southwest bancorp preferred stock paying a dividend f $2.50 and selling for $25.50. emerson electric common stock selling for $36.75, with a par value of $5. The...
You have finally saved​ $10,000 and are ready to make your first investment. You have the...
You have finally saved​ $10,000 and are ready to make your first investment. You have the three following alternatives for investing that​ money: A Microsoft bond with a par value of ​$1 comma 000 that pays 10.00 percent on its par value in​ interest, sells for ​$1,112.43​, and matures in 18 years. bullet Southwest Bancorp preferred stock paying a dividend of ​$2.84 and selling for ​$20.57. bullet Emerson Electric common stock selling for ​$62.47​, with a par value of​ $5....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT