help asap will leave good review thanks

Flax Industries is considering replacing a 4-year old FlaxXer Machine with a newer and more efficient FlaxXer Machine. You are to evaluate the problem based on the information below and make a decisions whether to replace the Old FlaXer Machine. You are also required to estimate a weighted average cost of capital (WACC) for the problem based on the information given. - Assume a combined Federal and State Tax Rate =20% for this problem - Round all dollar numbers to whole dollars - Round all percentages to 2 decimals, e.g., .04563 becomes 4.56% NOT 4.6% Calculate WACC: Flax Industries finances its projects using a Target Capital Structure of: Cost of Short and Long Term Borrowing (3 points) 1. Flax Industries uses a permanent line of credit thru a Short-Term Credit Facility to finance Short-Term Notes at a flat rate cost of 5%/ year. (i.e., Rs-t =5% ) 2. Flax Industries can issue New Bonds with a $1000 par value bonds, a 4.50% coupon rate with a 30 -year maturity at a price of \$1041.95. Coupon payments are annually. Assume no flotation costs for issuing bonds. Find YTM = Rd Cost of Preferred Stock (3 points) 3. Flax can also issue New Preferred Stock paying a 7% dividend coupon on $25 par at a price = $24.56 per share. Flotation costs for issuing new Preferred Stock is equal to 5% of the sales price. Dividends are paid once per year. Estimate the cost of New Preferred Stock with flotation costs (Rp). Cost of Common Equity ( 9 points) 4. Flax's common stock is currently trading at $60 per share. Next year, Flax expects to pay a dividend of $.75/ share out of earnings of $3.75 per share (i.e., EPS1=$3.75;D1=$.75 ). Current Return on Equity =NOI/ Equity =12% (i.e., ROE=12% ). 4. Flax's common stock is currently trading at $60 per share. Next year, Flax expects to pay a dividend of $.75/ share out of earnings of $3.75 per share (i.e., EPS1=$3.75;D1=$.75 ). Current Return on Equity =NOI/ Equity =12% (i.e., ROE=12% ). Calculate the cost of equity (Rs) using the DDM: Rs =(D1/PO)+g. Remember an estimate of g=ROEb, where b is the percent of eamings retained within the firm: b= Earnings retained/EPS; Retained Earnings = EPS - dividends. 5. Analyst estimate the company's beta at =1.10; the 10 -year T-Note risk free rate =3%(Rf=3%); and the return on the market portfolio is estimated at 11.0%(Rm=11.0%). Using the CAPM estimate required return on equity (Rs). 6. Flax also estimates Cost of Equity using its 30 -year Bond Yield +7% equity risk premium. What is the Cost of Equity? 7. Find an overall average Cost of Equity by averaging the costs you found in 4,5,&6 above. You will use this Rs estimate in calculating Flax Industries WACC in (8) below. 8. Calculate the WACC using the Target Structure weights given above, and your calculations for Short-Term Notes (1); Long Term Bonds YTM (2); Cost of Preferred Stock (3), and Overall Average for the Cost of Common Equity (7). You will use your WACC estimate in the Capital Budgeting Problem. (5 points) - Use the 5-Year Class and 7-Year Class MACR Depreciation schedules that are provided below for this problem. - Use the Capital Budget Template that I posted under Canvas to answer all questions. - Assume a combined Federal and State Tax Rate =20% for this problem. - "Do not just type in numbers. The point of Excel is to make it interactive. For example, if I were to change an input such as a tax rate, or cost of new machine, then it should change all values in the spreadsheet that are affected by taxes (e.g., earnings after taxes, tax on a sale of an asset), or cost of the new machine (e.g., depreciation schedule). Flax Industries is considering replacing a 4-year old FlaxXer Machine with a newer and more efficient FlaxXer Machine. You are to evaluate the problem based on the information below and make a decisions whether to replace thenOld FlaXer Machine. The Old FlaxXer was originally purchased for $1,000,000 four years ago and is being depreciated using a 5 -year MACR schedule (thus, there are 2 years left of depreciation). If replaced, it could be sold for a current price of $185,000. The Old FlaxXer still has another 5 years left in its remaining economic life and could be sold as scrap metal for $30,000 at the end of the 5 years. The New Flax Xer purchase price is $625,000, and it also has a useful economic life of 5 years. However, the IRS requires that Flax Industries depreciate the new machine using a 7-year MACR schedule. If purchased, the New FlaxXer will generate $130,000 per year in Earnings before depreciation and taxes (EBITD). The project will be terminated at the end of 5-years, and the New FlaxXer will be sold for an estimated price of \$62,500. If the New FlaxXer is purchased, then Net Working Capital will increase by $10,000 due to the necessity of holding more Inventory parts. However, Net Working Capital will decrease by $10,000 when the project is terminated at the end of the 5 -year life of the project. 9. Find the Incremental Depreciation (the difference between the depreciation of the New and Old FlaxXer) for each year over the 5-year life of the project. (10 points) 10. What is the Initial Cash outlay (Initial Investment) if the New FlaxXer is purchased to replace the Old FlaxXer? (12 points) 11. Find the Incremental After-tax Operating Cash Flows for Years 15. If the New FlaxXer is purchased, then Net Working Capital will increase by $10,000 due to the necessity of holding mo Inventory parts. However, Net Working Capital will decrease by $10,000 when the project is terminated at the end of th 5 -year life of the project. 9. Find the Incremental Depreciation (the difference between the depreciation of the New and Old FlaxXer) for ea year over the 5-year life of the project. (10 points) 10. What is the Initial Cash outlay (Initial Investment) if the New FlaxXer is purchased to replace the Old FlaxXer? (12 points) 11. Find the Incremental After-tax Operating Cash Flows for Years 15. (17 points) 12. Find the Terminal Year cash flow (i.e., the cash flow associated with ending the project at the end of Year 5). (12 points) 13. Calculate the NPV, IRR, and the MIRR for purchasing the New FlaxXer. [Don't forget to include Terminal Ye CF as part of cash flows received in Year 5!] (17 points) 14. Based on your answer in (13) above, explain why or why not the firm should buy the New FlaxXer. In your answer provide an interpretation of the NPV and IRR. (i.e., I don't want as a "Why" that NPV > or WACC. I want to know what it means if NPV > or or or WACC. I want to know what it means if NPV > or or