Question

In: Finance

Please complete the following problems in Microsoft Word / Excel document and post to the drop...

Please complete the following problems in Microsoft Word / Excel document and post to the drop box.

1) Interest rates and bond ratings (LO16-2) A previously issued A2, 15-year industrial bond provides a return three-fourths higher than the prime interest rate of 11 percent. Previously issued A2 public utility bonds provide a yield of three-fourths of a percentage point higher than previously issued A2 industrial bonds of equal quality. Finally, new issues of A2 public utility bonds pay three-fourths of a percentage point more than previously issued A2 public utility bonds.What should be the interest rate on a newly issued A2 public utility bond?

2) Fourteen years ago, the U.S. Aluminum Corporation borrowed $6.5 million. Since then, cumulative inflation has been 98 percent (a compound rate of approximately 65 percent per year).

a. When the firm repays the original $6.5 million loan this year, what will be the effective purchasing power of the $6.5 million? (Hint: Divide the loan amount by one plus cumulative inflation.)

b. To maintain the original $6.5 million purchasing power, how much should the lender be repaid? (Hint: Multiply the loan amount by one plus cumulative inflation.)

c. If the lender knows he will receive $6.5 million in payment after 14 years, how might he be compensated for the loss in purchasing power? A descriptive answer is acceptable.

3)Tobacco Company of America is a very stable billion-dollar company with sales growth of about 5 percent per year in good or bad economic conditions. Because of this stability (a correlation coefficient with the economy of +.3 and a standard deviation of sales of about 5 percent from the mean), Mr. Weed, the vice-president of finance, thinks the company could absorb some small risky company that could add quite a bit of return without increasing the company’s risk very much. He is trying to decide which of the two companies he will buy. Tobacco Company of America’s cost of capital is 10 percent.

Computer Whiz Company (CWC)
(cost $75 million)


American Micro-Technology (AMT) (cost $75 million)

Probability

Aftertax Cash Flows for 10 Years
($ millions)

Probability

Aftertax Cash Flows for 10 Years
($ millions)

0.3

$ 6




0.2

$(1)

0.3

10




0.2

3

0.2

16




0.2

10

0.2

25




0.3.

25








0.1

31

a. What is the expected cash flow for each company?

b. Which company has the lower coefficient of variation?

c. Compute the net present value of each company.

d. Which company would you pick, based on net present values

Solutions

Expert Solution

1.

Interest rate on previously issue A2 15-year industrial bonds = 11% × 1.75 =          19.250

Additional return on A2 15-year public utility bond + .750

Additional return on new issues                                                     + .750%

Anticipated return on newly issue A2 public utility bonds 20.750%

2. a. Loan amount/(1 + Cumulative inflation) = $6,500,000/(1+0.98)=$6,500,000/1.98 = $ 3,282,828

b.   Loan amount * (1 + Cumulative inflation) = $6,500,000 * (1+0.98) = $ 12,870,000

c. We need to charge an interest rate which is pretty high so that it is able to to provide an adequate annual return on the borrowed funds and also compensate for the loss of purchasing power.

  A loan repayment of 12,870,000 in a 98 percent cumulative inflationary environment will provide $6,500,000 in purchasing power to the original lender.

3.

a)         Expected for CWC is 0.3 * 6 + 0.3 * 10 + 0.2 * 16 + 2 * 0.25 = 13 million

AMT is 0.2 * -1 + .2 * 3 + .2 * 10 + .3 *25 + .1 * 31 = 13 million

b)         Lower variation is for CWC

c)         NPV is -75 + 13/1.1 + ... 13/1.1^10 = $4,879,372.37

d)         Both companies are the same when compared on basis of NPV

e)         Yes, if risk is to be considered I would pick CWC as it has lesser variation

f)         AMT will be picked in this case as it can be used as a hedge against the primary business during bad market conditions.

g) Tobacco company's stock's market value might increase as the investment has positive NPV


Related Solutions

create a document in microsoft word or excel document which has the following: Fictitious names and...
create a document in microsoft word or excel document which has the following: Fictitious names and addresses of 10 folks including name, address and phone number. Recreate the bike table, which includes bike name, part number and hourly rate Please limit your submission to no more than 2 pages.
Assignment Requirements Please complete all parts in a Microsoft Word document. The body of your document...
Assignment Requirements Please complete all parts in a Microsoft Word document. The body of your document should be at least 900 words in length. Quoting should be less than 10% of the entire paper. Paraphrasing is necessary. Students must cite and reference at least 4 credible sources from the Library. Instructions Imagine that you are an administrator for a large hospital. As part of your role within healthcare leadership, you are involved in several committees for the organization. For this...
Complete the following problems in a word document. Please show values for all variables and circle...
Complete the following problems in a word document. Please show values for all variables and circle the correct answer. Failure to do so will result in lost points. You borrow $15,000 for your tuition costs. You agree to make payments at the end of each month for the next 10 years. If the interest rate on this loan is 6%, how much is your monthly payment? How much do you still owe after 20 payments? Jill would like to plan...
. Using a Microsoft Word document, please post one federal and one state statute utilizing standard...
. Using a Microsoft Word document, please post one federal and one state statute utilizing standard legal notation and a hyperlink to each statute. 2. In the same document, please post one federal and one state case using standard legal notation and a hyperlink to each case.
Complete the following questions using Microsoft Word or Excel, as appropriate. Review the grading rubric to...
Complete the following questions using Microsoft Word or Excel, as appropriate. Review the grading rubric to confirm you are meeting the assignment requirements. Below are the balance sheet and income statement for Happy Hamburger Company. Happy Hamburger Company Balance Sheet as of December 31, 20XX Assets Liabilities and Shareholder Equity Cash 85,000 Accounts payable 145,000 Accounts Receivable 340,000 Current portion of debt 90,000 Inventories 250,000 Other current liabilities 114,000 Total current assets 675,000 Total current liabilities 349,000 Net fixed assets...
2. In a Microsoft Word document, respond to the following: Recently, on the news there was...
2. In a Microsoft Word document, respond to the following: Recently, on the news there was a story about how a local city found itself in quite a financial bind due to the contracts the mayor had signed with the employees union. The contracts were so generous that it left the city with very little money for other things, like parks and festivals. Unfortunately, this type of agency problem is not unique. We see similar problems when school boards agree...
Name a type of document that can be created with Microsoft Word.
Name a type of document that can be created with Microsoft Word. Using what you have learned from practice, describe the functions of Microsoft Word that aid you in creating the document you named. Describe how you would use the Word functions for creating your document.
Please upload your calculations (e.g., an Excel spreadsheet, a Word document, a PDF file, or a...
Please upload your calculations (e.g., an Excel spreadsheet, a Word document, a PDF file, or a picture of your work) for Q21. Q21. Consider a 2-year bond. The coupon rate of the bond is 10%, and the bond pays coupons semiannually. The bond is selling at a yield to maturity of 8.0% annually, or 4.0% semi-annually. (a) What is the duration of the bond measured in half-years and in years? (10 points) (b) If the semi-annually yield changes from 4.0%...
Kindly, do not hand write, use excel or word document, please let the work be original...
Kindly, do not hand write, use excel or word document, please let the work be original Capacity Planning Homework Assignment—To be Submitted The Baltimore Manufacturing Company’s management forecasts demand for each quarter as follows: First Quarter Second Quarter Third Quarter Fourth Quarter Average quarterly demand 7000 units 9000 units 10000 units 8000 units Assume that Arundel, Inc. started the First Quarter with 20 workers and 2000 units in inventory. The company wishes to finish the year with an inventory of...
Microsoft leases rights to Microsoft Word, Excel, Powerpoint and other software applications to NJCU School of...
Microsoft leases rights to Microsoft Word, Excel, Powerpoint and other software applications to NJCU School of Business, Campus Administration for 14 annual payments of $8,500 at the beginning of each year. The payments will begin five years from today. If the market rate of interest is 8%, what is the present value of the payments? Provide the answer in Excel with formula please
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT