Please help with the following Problems. Please do this in Excel and put each problem in its own tab.

Complete the following problem sets from the "Problems" section in Chapters 9-11 and 23 ofFinancial Management: Theory and Practice.

1. Chapter 9: 9-2, 9-5, 9-6, and 9-8
2. Chapter 10: 10-1, 10-2, 10-3, 10-4, 10-5, 10-6, and 10-8
3. Chapter 11: 11-1, 11-2, 11-3, 11-4, and 11-6
4. Chapter23: 23-1 and 23-2

{10-1} A project has an initial cost of $40,000, expected net cash inows of $9,000 per year for 7 NPV years, and a cost of capital of 11%. What is the project's NPV? (Hint: Begin by cunstructing a time line.) {10-2} Refer to Problem 10-1. What is the project's IRR? [RR {10-3} Refer to Problem 10-1. What is the project's MLRR? MIRR (10-4; Refer to Problem 10-1. What is the project's P1? Protability Index {10-5} Refer to Problem 10-1. What is the project's payback period? Payback {10-0} Refer to Problem 10-1. What is the project's discounted payback period? Discounted Payback {1043} NEWS. IRRs. and MERRs for Indepen- dent Projects Edelman Engineering is considering including two pieces of equipment, a truck and an overhead pulley system, in this year's capital budget. The projects are independent The cash outlay for the truck is $17,100 and that for the pulleyr system is $22,430. The rm's cost of capital is 14%. After-tax cash ows, including depreciation, are as follows: Yea r Truck 1 $5,100 2 5.100 3 5.100 4 5.100 5 5.100 Calailate the 111R, the NW, and the MIRR for each project. and indicate the correct accept-reject decision for each. Pulley $7.500 ?,500 ?,500 7,500 7,500 {11-1} mvestment Outlay Talbot Industries is considering launching a new product. The new manufacturing equipment will cost $17 million, and production and sales will require an initial $5 million investment in net operating working capital. The company' s tax rate is 40%. a. What is the initial investment outlay?I b. The company spent and espensed $150,000 on research related to the new product last year. Would this change your answer?l Explain. c. Rather than build a new manufacturing facility, the company plans to install the equipment in a building it owns but is not now using. The building could be sold for $1.5 million after taxes and real estate commissions. How would this affect your answer? {11-2} Operating Cash Flow {11-3} Net Salvage Value {1141 Replacement Analysis The nancial staff of Cairn Communications has identied the following infomation for the rst year of the roll-out of its new proposed service: Projected sales $13 million Operating costs (not including depreciatilnl $ 9 million Depreciation $ 4 million Interest expense $ 3 million The company faces a 40% tax rate. What is the project's operating cash flow for the rst year (t = 1)?l Allen Air Lines must liquidate some equipment that is being replaced. The equipment originally cost $12. million, of which 75% has been depreciated. The used equipment can be sold today for $4 million, and its tax rate is 40%. What is the equipment's after-tax net salvage value?l Although the Chen (Tompany> s milling machine is old, it is still in relatively good working order and would last for another 10 years. It is inefcient compared to modern standards. though, and so the company is considering replacing it. The new milling machine, at a cost of $110,000 delivered and installed, would also last for 10 years and wuld produce after-tax cash ows (labor savings and depreciation tax savings] of $19,000 per year. It would have zero salvage value at the end of its life. The rm's WACC is 10%, and its marginal tax rate is 35%. Should Chen buy the new machine? me New-Project Analysis 1; t o v o The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,030,000, and it would cost another $22,500 to install it. The machine falls into the MACRS 3-year class, and it would he sold after 3 years for $605,000. The MACRS rates for the first three vears are 0.3333, 0.4445, and 0.1431. The machine would require an increase in net working capital (inventory) of $15,500. The sprayer would not change revenues, but it is expected to save the rm $330,000 per year in hesre-tax operating costs, mainly labor. Campbell's marginal tax rate is 35%. a. What is the Year 0 net cash ow? 1:. What are the net operating cash mvs in Years 1, 2, and 3? c. What is the additional Year-3 cash ow (ie., the after-tax salvage and the return of working capital]!' d. if the project's cost of capital is 12%, should the machine be purchased? {23-1} Zhae Automotive issues xed-rate debt at a rate of 100%. Zhae agrees to an interest rate Swaps swap in which it pays LIBOR to Lee Financial and Lee pays 6.3% to Zhae. What is Zhae's resulting net payment? (3-2} A Treasury bond futures contract has a settlement price of BQ'DB. What is the implied Bum-es annual yield? {9-2} After-Tar: Cost of Debt {9-3} Cost of Preferred Stock e-s Cost of Preferred Stock with Flotation Costs {9-5} Cost of Equity: DCF {9-5} Cost of Equity: cam {9-7} WAEC {9-21 WACC LL incorporated's currently outstanding 11% coupon bonds have a yield to maturity of 3%. LL believes it could issue new bonds at par that would provide a similar yield to maturity. If its marginal tax rate is 35%, what is LL's after-tax cost of debt!| Duggins Veterinary Supplies can issue perpetual preferred stock at a price of $50 a share with an annual dividend of $4.50 a share. Ignoring otation costs, what is the company' s cost of preferred stock, r13? Burnwood Tech plans to issue some $60 par preferred stock with a 6% dividend. A similar stock is selling on the market for $10. Burnwood must pay otation costs of 5% of the issue price. What is the cost of the preferred stock? Summerdahl Resort's common stock is currently trading at $36 a share. The stock is expected to pay a dividend of $3.00 a share at the end of the year (D1 = $3.00], and the dividend is expected to grow at a constant rate of 5% a year. What is its cost of common equity?I Booher Book Stores has a beta of 0.3. The yield on a 3-month T-bill is 4%, and the yield on a 10-year T-bond is 6%. The market risk premium is 5.5%, and the return on an average stock in the market last year was 15%. What is the estimated cost of common equity using the CAPM? Shi Importers's balance sheet shows $300 million in debt, $50 million in preferred stock. and $250 million in total common equity. Shi's tax rate is 40%, rd = 6%. rp, = 5.3%, and r5 = 12%. If 5hr has a target capital structure of 30% debt. 5% prer'red stock. and 65% common stock. what is its WACC? David Ortiz Motors has a target capital structure of 40% debt and 60% equity. The yield to maturity on the company' s outstanding bonds is 9%, and the company' s tax rate is 40%. Ortiz's CFO has calculated the company' s WACC as 9.96%. What is the company' s cost of equity capital