Boeing Corporation has just issued a callable​ (at par)​ three-year, 4.7 % coupon bond with​ semi-annual coupon payments. The bond can be called at par in two years or anytime thereafter on a coupon payment date. It has a price of $98.65.

a. What is the​ bond's yield to​ maturity?

b. What is its yield to​ call?

c. What is its yield to​ worst?

Weiland Co. shows the following information on its 2016 income statement: sales = $173,000; costs = $91,400; other expenses = $5,100; depreciation expense = $12,100; interest expense = $8,900; taxes = $21,090; dividends = $9,700. In addition, you’re told that the firm issued $2,900 in new equity during 2016 and redeemed $4,000 in outstanding long-term debt. a. What is the 2016 operating cash flow? b. What is the 2016 cash flow to creditors? c. What is the 2016 cash flow to stockholders? d. If net fixed assets increased by $23,140 during the year, what was the addition to NWC?

1. Compute the future value of:
   1. An initial $2,000 compounded annually for 10 years at 8%
   2. An initial $2,000 compounded annually for 10 years at 10%
   3. An annuity of $2,000 for 10 years at 8%
   4. An annuity of $2,000 for 10 years at 10%

You are trying to decide how much to save for retirement. Assume you plan to save $8,000 per year with the first investment made one year from now. You think you can earn 8.5​% per year on your investments and you plan to retire in 39 ​years, immediately after making your last $8,000 investment. a. How much will you have in your retirement account on the day you​ retire? b.​ If, instead of investing $8,000 per​ year, you wanted to make one​ lump-sum investment today for your retirement that will result in the same retirement​ saving, how much would that lump sum need to​ be? c. If you hope to live for 24 years in​ retirement, how much can you withdraw every year in retirement​ (starting one year after​ retirement) so that you will just exhaust your savings with the 24th withdrawal​ (assume your savings will continue to earn 8.5​% in​ retirement)? d.​ If, instead, you decide to withdraw $435,000 per year in retirement​ (again with the first withdrawal one year after​ retiring), how many years will it take until you exhaust your​ savings? (Use​ trial-and-error, a financial​ calculator: solve for​ "N", or​ Excel: function​ NPER) e. Assuming the most you can afford to save is $1,600 per​ year, but you want to retire with $1,000,000 in your investment​ account, how high of a return do you need to earn on your​ investments? (Use​ trial-and-error, a financial​ calculator: solve for the interest​ rate, or​ Excel: function​ RATE)

You proposed a portfolio for your client with 60% in stock A and 40% in stock B. Stock A has an average weekly return of 0.88% and stock B has an average weekly return of 1.32%. Beta for stock A and B are 0.8 and 1.3 respectively. Now you want to deliver a performance report to the client regarding portfolio performance on a weekly basis. (a). What’s the portfolio average weekly return?

(b). What’s the portfolio beta?

(c). You have calculated the portfolio weekly standard deviation: 3.9%. What’s the Sharpe ratio of the portfolio? Assuming weekly market return is 0.9% and weekly riskfree rate is 0.04%.

(d). Still assume the portfolio weekly standard deviation is 3.9%, weekly market return is 0.9% and weekly risk-free rate is 0.04%, what’s Jensen’s Alpha of the portfolio?

Bond X is a premium bond making semiannual payments. The bond pays a coupon rate of 7.4%, has a YTM of 6.8%, and has 13 years to maturity. Bond Y is a discount bond making semiannual payments. This bond pays a coupon rate of 6.8%, has a YTM of 7.4%, and also has 13 years to maturity. What is the price of each bond today? If interest rates remain unchanged, what do you expect the price of these bonds to be one year from now? In three years? In eight years? In 12 years? In 13 years? What's going on here? Illustrate your answers by graphing bond prices versus time to maturity. Please work on Excel, that's how I need to see this problem worked out THANKS SO MUCH

Assume that two athletes sign 10-year contracts that pay out a total of $100 million over the life of the contracts. One contract will pay the $100 million in equal installments over the 10 years. The other contract will pay the $100 million in installments, but the installments increase 5% per year. Which athlete received the better deal? You must show your work and explain your position in detail.

I've seen this question answered but can someone show step-by-step how they arrived at their answer?

Portfolio analysis

4. Suppose you form a portfolio that invests 10% in T, 20% in JPM, 30% in NEM and 40% in CVX. Calculate (a) portfolio monthly returns, (b) portfolio's average monthly return, and (c) standard deviation of portfolio monthly returns. Discuss. Highlight your final answers.

Average Return E (r) of each stock: The average return on each of these stocks were calculated in excel using today's price-yesterdays price/yesterday's price and then the average taken from 114 days of adj. closing cost.

Ave. Return E(T)=0.85% StDEV(T)=4.46%

Ave. Return(JPM)=1.36% StDEV(JPM)=6.94%

Ave.Return E(NEM)=0.60% StDEV(NEM)10.30%

Ave. Return E(CVX)=0.90% StDEV(CVX)5.74%

Weight

WW(T)=10%

W(JPM)20%

W(NEM)30%

W(CVX)40%

E (r)ptf = W(T)*E(T) + W(JPM)*E(JPM) + W(NEM)*E(NEM)+ W(CVX)*E(CVX)

******I calculated in excel and got these answers: Is the E(r)ptf the portfolio monthly returns or the average monthly return? How do you calculate the (a) portfolio montly returns and (b) the average monthly return?

E(r) ptf=0.90%

StDEV(r) ptf=2.51%

Snowy Mountain Timber Ltd is considering purchasing a new wood saw that costs $70,000. The saw will generate revenues of $100,000 per year for five years. The cost of materials and labour needed to generate these revenues will total $60,000 per year, and other cash expenses will be $10,000 per year. The machine is expected to sell for $3,500 at the end of its five-year life and will be depreciated on a straight-line basis over five years to zero. Snowy Mountain’s tax rate is 34 percent, and its opportunity cost of capital is 10.70 percent. The project's NPV is $ .

The project should be (accept or rejected?).

(Round your intermediate calculations to three decimal places and round each of your final answers to the nearest dollar. Use parenthesis to enter negative amounts.)

Take Five Systems, a new start-up, is developing a new iPhone application (“app”) and provides you with the following assumptions:

1. Development and testing of the new app will take four months. Month five is the first month of revenue generation.

2. Initial monthly app sales of 5,000 downloads at a price of $2.99

3. Unit sales will grow at 15% per month for months six through twelve and then will be flat thereafter

4. The app will become obsolete and will need to be revised/replaced after month 18

1. Take Five Systems is concerned about the accuracy of their revenue estimates in Question 1. Specifically, they wish to use sensitivity analysis to evaluate the impact on Month 18 revenue of the following:

   1. Variations in 2% increments between 9-21% in the growth rate of unit sales in Months 5-12 (that is, 9%, 11%,..., 19%, 21%)

   2. Variationin500unitincrementsbetween2,500and7,500inthelevelofinitial sales (that is, 2,500, 3,000,..., 7,000, 7,500)

Snowy Mountain Timber Ltd is considering purchasing a new wood saw that costs $50,000. The saw will generate revenues of $100,000 per year for five years. The cost of materials and labour needed to generate these revenues will total $60,000 per year, and other cash expenses will be $10,000 per year. The machine is expected to sell for $4,000 at the end of its five-year life and will be depreciated on a straight-line basis over five years to zero. Snowy Mountain’s tax rate is 34 percent, and its opportunity cost of capital is 13.30 percent.

The project's NPV is?

The project should be accepted/rejected

• Summarize the most significant uses of the funds banks obtain; include a description of each and the risks involved. Next, discuss why a bank might invest in securities, even though loans typically generate a higher return; discuss risk as a factor. Finally, discuss how a bank might allocate funds to each type of asset and how this helps a bank to manage risk for the bank and its customers.

• Describe what is meant by bank capital and discuss how banks determine the optimal amount of capital to hold. Since a bank’s capital is generally less than 10% of its assets, discuss how this compares to the average capital structure of manufacturing corporations and explain this difference.

1. Take Five Systems, a new start-up, is developing a new iPhone application (“app”) and provides you with the following assumptions: a. Development and testing of the new app will take four months. Month five is the first month of revenue generation. b. Initial monthly app sales of 5,000 downloads at a price of $2.99 c. Unit sales will grow at 15% per month for months six through twelve and then will be flat thereafter d. The app will become obsolete and will need to be revised/replaced after month 18 Use the data provided to forecast Take Five’s monthly revenue for Months 1-18

2. Take Five Systems is concerned about the accuracy of their revenue estimates in Question 1. Specifically, they wish to use sensitivity analysis to evaluate the impact on Month 18 revenue of the following: a. Variations in 2% increments between 9-21% in the growth rate of unit sales in Months 5-12 (that is, 9%, 11%,…, 19%, 21%) b. Variation in 500 unit increments between 2,500 and 7,500 in the level of initial sales (that is, 2,500, 3,000,…, 7,000, 7,500)

could you please show me how to do question 2 on excel? Thank you