Show work in excel please

A pension fund manager is considering three mutual funds. The first is a stock fund, the second is a long-term government and corporate bond fund, and the third is a T-bill money market fund that yields a sure rate of 4.8%. The probability distributions of the risky funds are:

b. The correlation between the fund returns is .1313. Suppose now that your portfolio must yield an expected return of 15% and be efficient, that is, on the best feasible CAL. a. What is the standard deviation of your portfolio? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

b-1. What is the proportion invested in the T-bill fund? (Do not round intermediate calculations. Round your answer to 2 decimal places.)

b-2. What is the proportion invested in each of the two risky funds? (Do not round intermediate calculations. Round your answers to 2 decimal places.)

An office building is expected to create operating cash flows of $26,500 a year for three years, based on tenants' rental income. The purchase of the fixed assets for this building will cost $55,000. These assets will have no value at the end of the project. An additional $5,000 of net working capital will be required throughout the life of the project. Calculate the net present value of this project if the required rate of return is 15 percent?

Multiple Choice

• $8,793.05

• $3,793.05

• $1,566.67

• $505.47

• $-1,206.95

Titan Mining Corporation has 9.8 million shares of common stock outstanding and $420,000 5.2% semiannual bonds outstanding, par value $1000 each. The common stock currently sells for $46 per share and has a beta of 1.3; the bonds have 15 years to maturity and sell for 117 percent of par. The market risk premium is 8.6%, T-bills are yielding 4%, and the company's tax rate is 23%.

a. What is the firm's market value capital structure (debt and equity)?

b. If the company is evaluating a new investment project that has the same risk as the firm's typical project, what rate should the firm use to discount the project's cash flows?

In doing a five-year analysis of future dividends, the Dawson Corporation is considering the following two plans. The values represent dividends per share. Use Appendix B for an approximate answer but calculate your final answer using the formula and financial calculator methods.

a. How much in total dividends per share will be paid under each plan over five years? (Do not round intermediate calculations and round your answers to 2 decimal places.)

b-1. Mr. Bright, the Vice-President of Finance, suggests that stockholders often prefer a stable dividend policy to a highly variable one. He will assume that stockholders apply a lower discount rate to dividends that are stable. The discount rate to be used for Plan A is 10 percent; the discount rate for Plan B is 14 percent. Compute the present value of future dividends. (Do not round intermediate calculations and round your answers to 2 decimal places.)

b-2. Which plan will provide the higher present value for the future dividends?

Kansas Corp, an American company, has a payment of 5 million euros due to Tuscany Corp. one year from today. At the prevailing spot rate of 0.90 euro/dollar, this would cost Kansas $5,555,556, but Kansas faces the risk that the euro/dollar rate will fall in the coming year, so that it will fall in the coming year, so that it will end up paying a higher amount in dollar terms. To hedge this risk, Kansas has two possible strategies. Strategy 1 is to buy 5 million euros forward today at a one-year forward rate of 0.80 euro/dollar. Strategy 2 is to pay a premium of $100,000 for a one-year call option on 5 million euros at an exchange rate of 0.88 euro/dollar. a. Suppose that in one year the spot exchange rate is 0.85 euro/dollar. What would be Kansas' net dollar cost for the payable under each strategy? b. Suppose that in one year the spot exchange rate is 0.95 euro/dollar. What would be Kansas' net dollar cost for the payable under each strategy? c. Which hedging strategy would you recommend to Kansas Corp? Why?

Determine why it is sometimes misleading to compare a company’s financial ratios with those of other firms that operate within the same industry. Support your response with one (1) example from your research.

REPLACEMENT ANALYSIS

The Bigbee Bottling Company is contemplating the replacement of one of its bottling machines with a newer and more efficient one. The old machine has a book value of $575,000 and a remaining useful life of 5 years. The firm does not expect to realize any return from scrapping the old machine in 5 years, but it can sell it now to another firm in the industry for $250,000. The old machine is being depreciated by $115,000 per year, using the straight-line method.

The new machine has a purchase price of $1,125,000, an estimated useful life and MACRS class life of 5 years, and an estimated salvage value of $155,000. The applicable depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. It is expected to economize on electric power usage, labor, and repair costs, as well as to reduce the number of defective bottles. In total, an annual savings of $250,000 will be realized if the new machine is installed. The company's marginal tax rate is 35%, and it has a 12% WACC.

1. What initial cash outlay is required for the new machine? Round your answer to the nearest dollar. Negative amount should be indicated by a minus sign.
   $
   
2. Calculate the annual depreciation allowances for both machines and compute the change in the annual depreciation expense if the replacement is made. Round your answers to the nearest dollar.

   Year	Depreciation Allowance, New	Depreciation Allowance, Old	Change in Depreciation
   1	$	$	$
   2
   3
   4
   5

3. What are the incremental net cash flows in Years 1 through 5? Round your answers to the nearest dollar.

   Year 1	Year 2	Year 3	Year 4	Year 5
   $	$	$	$	$

4. Should the firm purchase the new machine?
   -Select-YesNoItem 22
   
   Support your answer. The input in the box below will not be graded, but may be reviewed and considered by your instructor.
   
5. In general, how would each of the following factors affect the investment decision, and how should each be treated?
   1. The expected life of the existing machine decreases.

   The input in the box below will not be graded, but may be reviewed and considered by your instructor.

   2. The WACC is not constant, but is increasing as Bigbee adds more projects into its capital budget for the year.

   The input in the box below will not be graded, but may be reviewed and considered by your instructor.

Turn to the Right Drilling Co. (“TTR Drilling”) operates an aging fleet of offshore drilling rigs that are contracted to major integrated oil companies for exploration and production. Since the recent Deepwater Horizon disaster in the Gulf of Mexico, the majors have shown a strong preference for the safer, more technologically-advanced newbuild rigs and are willing to lease these rigs at higher rates than the older ones. Consequently, TTR Drilling is considering replacing their older rigs to take advantage of the higher potential dayrates for their contracts over the next five years. TTR’s current fleet produces annual revenues of $35 M per rig with cash costs of $16 M per rig. The older rigs also currently have $5 M tied up in NWC per rig. The CFO of the company has estimated annual revenues for newbuild rigs at $185 M per rig with cash costs of $30 M per rig. The new rigs would require $15 M in NWC each. The purchase price of a new rig is $750 M. They expect to depreciate this on a straight-line basis to zero over the next five years. However, the company estimates that a new rig could be sold for $400 M at the end of the project. If they purchased a new rig today, they could sell an old one on the open market for $30 M. The old rigs are currently carried on the books at $35 M each and are being depreciated on a straight-line basis by $5 M per year. If they decided to stick with the old rigs, they expect them to have a market value of only $15 M in five years. Assume that TTR Drilling faces a 40% corporate tax rate and an 19% cost of capital. What is the NPV of the decision (in $M per rig) to replace the old vessels with the new ones? (Hint: There is a very similar HW problem in your text.)

. Assume the following information:

What is your percentage return from covered interest arbitrage with $550,000 for one year?

1. You observed the bid rate of a New Zealand dollar is $.6723 while the ask rate is $.6812 at Bank X. The bid rate of the New Zealand dollar is $.6712 while the ask rate is $.6701 at Bank Y. What would be your dollar amount profit if you use $1,000,000 to execute locational arbitrage?

Suppose managers of a firm know that the company is approaching financial distress. Should the managers borrow from creditors and issue a large one-time dividend to shareholders? How might creditors control this potential transfer of wealth?

Dunder-Mifflin is considering opening a new branch in Columbia with an initial fixed asset cost of $2.46 million which will be depreciated straight-line to a zero book value over the 10-year life of the project.

At the end of the project the equipment will be sold for an estimated $300,000. The project will not directly produce any sales but will reduce operating costs by $725,000 a year. The tax rate is 35 percent. The project will require $45,000 of inventory which will be recouped when the project ends. What is the NPV of this project if the firm requires a 10.80 percent rate of return? Enter the dollar amount as an integer value (ex. -$5,000.45 as -5000 or +$3,450.70 as 3451).

An investor has a bearish view of the stock, which he would like to take advantage of by constructing an option ‘spread’ strategy. Your goal is to maximize the initial cash inflow using this strategy. Suppose there exists the following options on the same underlying share of the stock. The share is currently trading in the market at $40.

1. Which options would you use for your spread strategy? Explain your answer.
2. Construct a payoff table for your option strategy. Show the payoff for individual options you use and the total payoff of the spread.
3. Draw a payoff diagram for your strategy, show the maximum and minimum level of payoff and strike price(s).

Bombardier, after spending $250,000 on a feasibility study, has determined that its customers will be willing to pay more money for the C Series model if Bombardier invests in a manufacturing technology upgrade that can enhance the safety of the engine. Bombardier realizes that the delays in the C Series program are likely costing them potential sales of the C Series jets. The feasibility study allowed management to better understand the implementation costs of the new technology as well as the potential payoff. Thus, they see the opportunity to make a short-term investment in the engine technology that will affect the next eight years of production in order to improve their overall offering to their customers.

Because the C Series production facilities are already covered in original cost estimates, no additional costs for production facilities are required. However, the required new machinery will cost $2,000,000 and will be subject to capital cost allowance depreciation (Asset Class 8, 20% CCA rate). When the C Series program expires after year eight, Bombardier executives figure there will be $324,578 in salvage on the equipment. Sales across the eight years of the C Series program are projected to be 18 units, 22 units, 29 units, 43 units, 54 units, 34 units, 36 units, and 39 units.

Bombardier expects that the price to their customers will start at an additional $120,000 with three per cent increases per year, as they wish to keep their prices competitive. Material costs of production are expected to be $68,000 per unit, growing at four per cent a year. Fixed costs per annum will amount to $680,000. The corporate tax rate Bombardier is subject to is 26.7 per cent, as of end of fiscal 2018.

Finally, Bombardier requires a maintained investment in working capital of $375,000 at the beginning of the project. This will stay at 15 per cent of sales at the end of each year, and reduces to 0 by the project's end; therefore, the investment in working capital is fully recovered by the project's end. As the company will be purchasing raw materials prior to production and sales delivery, they must create an investment in inventory as well as maintaining some cash as a buffer against unforeseen expenses. If the firm has negative taxable income from the project in a given year, please assume that the firm has positive income from other projects, so that the loss can be written off (as a tax benefit) against this other project income in the same year.

Questions

2.     What is the Net Present Value of the project if the required rate of return (Weighted Average Cost of Capital) is equal to 3.80 per cent?

3.    By how much would the Net Present Value of the project change if unit sales were 25 per cent less than expected (round down toward zero the number of units)?