Help!!! the last two pages are the template for the answer to go on

Flax Industries is considering replacing a 4-year old FlaxXer Machine with a newer and more efficient Flax Xer Machine. You ane to eraluate the problem based on the information below and make a decieions whether to replace the Old Fla Xer Machine. You are also required to estimate a weighited 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, o.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 polnts) 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 boods, a 4.50% coupon rate with a 30 -year maturity at a price of $1041.95. Coupon payments are andually. 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.c, EPS1=$3.75;D1=$.75 ) Current Return on Equity = NOI/Equity =12% (i.c. ROE =12% ). Calculate the cost of equity (Rs) using the DDM: Rs = (DI/PO) +g. Remember an estinate of g= ROE b, where b is the percent of earnings retained within the firm: b= Earoings retainedEPS; Rctained Eamings = EPS - dividends. 5. Analyst estimate the company's beta at =1.10; the 10-ycar T-Note risk free rate =3%(Rf=3%); and the rrturn on the market portfolio is estimated at 11.0%(Rm=11.0%). Using the CAPM estimate required retum on equif) (Rs). 6. Flax also cstimates Cost of Equity using its 30 -ycar 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,8,6 above. You will use this Rs estimate in calculating Flax Industries WACC in (8) below. 8. Calculate the WACC using the Target Strueture weights given above, and your calculations for Short-Term Notes (1) Long Tcm Bonds YTM (2); Cost of Preferred Stock (3), and Overall Average for the Cost of Common Equity (3). 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) Capital Budreting Problem - Use the 5-Year Class and 7-Year Class MACR Deprociation schedules that are providod 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 affocted by taxes (e.go carnings 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 Flax Xer Machine with a newer and more cfficient Flax Xer Machine. You are to evaluate the problem based on the information below and make a decisions whether to replace the Old 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 FlsxXer still has another 5 years left in its remaining economic life and could be sold as serap 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-ycar MACR schedule. If purchased, the New Flax Xer 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 S62,500. If the New FlaxXer is purchased, then Net Working Capital will inercase by $10,000 due to the necessity of holding more Inventory parts. However, Net Working Capital will decrease by $10,000 when the projeet is terminated at the end of the 5-year life of the projoct. 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) Flax Industries is considering replacing a 4-year old Flax Xer Machine with a newer and more eftelent Flax Xer Machine. You are to evahuate the problem based on the information below and make a decisions whether to replace the Old Fis Xer Machine. The Old FlaxXer was originally purchased for $1,000,000 four years ago and is being depreciated using a S-year MACR sahedule (thus, there are 2 years left of depreciation). If replaced, it conld be sold for a current price of $185,000. The Old FlaxXer still has another 5 years left in its remaining oconomic life and could be sold as scrap metal for $30,000 at the ead of the 5 yeans. The New FlaxXer purchase price is $625,000, and it also has a useful economic life of 5 years. However, the IRS requires that Flax Industries deprociate the new machine using a 7-year MACR schedule. If purchased, the New FlaxXer will gencrate $130,000 per year in Parnings before depreciation aad taxes (BBITD). 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 purchused, 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 Flax Xer) for cach year over the 5 -year lifo of the project. (10 polnts) 10. What is the Initial Cash outlay (laitial 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 1 -5. (17 polnts) 12. Find the Terminal Year cach flow (i.e., the cash flow associated with ending the project at the end of Year 5 ). (12points) 13. Calculate the NPV, IRR, and the MIRR for purchasing the New FlaxXer. [Don't forget to include Terminal Year CF as part of cash flows reccived in Year 5!] (17 pelnts) 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