QUESTION ONE:

a. What is the initial cash outlay (CFO)?

b. What are the operating cash flows in years I thru 6 - adjusted for taxes and depreciation?

c. What are the terminal-year cash flows added to the operating cash flow in year 6?

d. What is the Weighted Average Cost of Capital, assuming you use existing capital structure?

Please show results in Excel using the template above! Thanks!

Spring Back Recycling (SBR) is considering expanding into the Southeastern U.S., adding 40 centers to its fleet of 125 . As the expansion is expected to significantly enhance both revenues and costs, senior management is concerned about the profitability of such a major expansion. As a result, you were recently hired to participate on a team under SBR's CFO that is responsible for evaluating the cash flows and profitability associated with this specific project (beginning in the summer of 2023). Initially, your team concludes that such a full-scale expansion would require an increase in capital expenditures of $28,000,000. In addition, to accommodate increased cash and inventory needs, net working capital requirements are expected to rise by $$1,500,000 so the new centers will be operationally functional. The firm expects that 80% of the increase in net working capital will be returned at the project's termination. The capital equipment is to be depreciated using a 7year Modified Accelerated Cost Recovery System (MACRS) schedule. Not knowing what the future holds, your team also concludes that this expansion will exist for 6 years - thereby finishing in the summer of 2029. Adjustments to the company's operating cash flow's are expected to begin in June of 2023 when the centers are deemed fully operationally functional. Also, the capital equipment is expected to have a market value of $350,000 at the project's termination. Last, your team makes the following assumptions regarding marginal increases in sales and costs for SBR: - 2,100,000 total units will be recycled in years 1&2, generating on average $9.50 per unit, while 1,800,000 total units will be sold in years 3 \& 4 at an average sales price of $11.50 per unit, and 1,500,000 total units will be sold in years 5 \& 6 at an average sales price of $12.00 per unit. - Total operating costs (both fixed and variable) are anticipated to be 65% of sales in years 1&2,55% of sales in years 3&4, and 45% of sales in years 5&6. - SBR's marginal tax rate is 21% (used in deriving Operating Cash Flows) - SBR's capital gains tax rate is 15% (used in deriving Net Salvage Value0) Last, you assume that SBR will raise all of the capital to finance this project using a blend of debt and equity and intends to use the same capital structure to raise the funds for this expansion. As a result, you base your cost of capital assumptions on the following: - The firm currently has 440 bonds outstanding with the following terms: - Remaining Maturity =12 years, Coupon Rate =6.78% (semiannual pay), Current Price =$1012. o The firm currently has 23,000 common shares outstanding with the following price and market terms: - Stock price =$44; Beta =1.10; Rf Rate =3%;ERm=7% - The firm currently has 8000 preferred shares currently priced at $88 and has a $3.80 annual fixed dividend. STEP \#1 Calculate CFo Cost Basis Change in NWC CF0 STEP \#2 Calculate OCF1 - OCF(N Terminal Year) STEP \#3 Add NWC \& Net Salvage Value to Terminal Year \begin{tabular}{|l|ll} \hline NWC & Net Salvage Value Calculation \\ \hline NSV & Market Value & \\ \hline & Book Value & \\ \hline & Capital Gain/Loss & \\ \hline & Tax Gain/Loss & \\ \hline & & \\ \hline \end{tabular} Net Salvage STEP \#4 Calculate Cost of Capital (WACC) \begin{tabular}{|l|l|l|} \hline Mkt Value Debt D & D/N & Rd \\ \hline Mkt Value Common & E/N & Re \\ \hline Mkt Value Pfd P & P/V & Rp \\ \hline Total Value (V) & & T \\ \hline \end{tabular} WACC