Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Xelly, Inc. (XLY) is currently considering upgrading system hardware in approximately 250 of its existing restaurants to accommodate greater traffic flow in several strategic areas

Xelly, Inc. (XLY) is currently considering upgrading system hardware in approximately 250 of its existing restaurants to accommodate greater traffic flow in several strategic areas of the Southeastern U.S. The upgrade will offer two primary advantages over their existing structures: (1) significantly greater revenue, and (2) stronger economies of scale in maintaining fixed and variable costs per store. Assume you were recently hired to participate on a team under XLYs CFO that is responsible for evaluating the cash flows and profitability associated with this specific project (starting in the summer of 2022). Initially, your team concludes that such a full-scale expansion would require new equipment costs (within existing restaurants) of $262,000,000, plus an additional shipping and installation costs of $3,500,000 (to be included in the initial cost). In addition, to accommodate increased cash and inventory needs, net working capital requirements are expected to rise by $18,000,000 so the refurbished restaurants will be operationally functional. The equipment is to be depreciated using a 5-year Modified Accelerated Cost Recovery System (MACRS) schedule. Not knowing what the future holds, your team also concludes that this new project will exist for only 5 years thereby finishing in the summer of 2027. Adjustments to the companys operating cash flows are expected to begin in July of 2022 when the stores are deemed fully operationally functional. Also, the new equipment is expected to have a market value of $26,400,000 at the projects termination. Last, your team makes the following assumptions regarding marginal increases in sales and costs for XLY: 15,000,000 units will be sold in years 1 & 2, at an average sales price of $11.80 per unit, while 12,500,000 units will be sold in years 3, 4 & 5, at an average sales price of $16.40 per unit. Total operating costs (both fixed and variable) are anticipated to be 48% of sales in years 1 & 2, 54% of sales in years 3, 4, and 5. SLYs marginal tax rate is 22% (used in deriving Operating Cash Flows) and capital gains tax rate is 15% (used in deriving salvage value). Last, you assume that XLY will raise all of the capital to finance this project only debt, using the following assumptions: The firm currently has a Coupon Rate (Cost of Capital) = 4.78% In order to evaluate this project, answer the following questions in deriving a cash flow analysis and recommendation. 5. What is the initial cash outlay (CF0)? (10 points) 6. What are the operating cash flows in years 1 thru 5 - adjusted for taxes and depreciation? (35 points) 7. What are the terminal-year cash flows added to the operating cash flow in year 5? (25 points) 8. Given your results for CF0 thru C05 and the cost of capital, would you recommend that the company take-on this project? Compute and explain the uses and significance of the NPV & IRR to support your answer. (35 points)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Investment Analysis and Portfolio Management

Authors: Frank K. Reilly, Keith C. Brown

10th Edition

538482109, 1133711774, 538482389, 9780538482103, 9781133711773, 978-0538482387

More Books

Students also viewed these Finance questions

Question

Essential Elements of map ?

Answered: 1 week ago

Question

Evaluate common feachers of social reform movement in Kerala?

Answered: 1 week ago

Question

Name the biggest tragedy in Malabar rebellion?

Answered: 1 week ago

Question

Write a short note on khan Abdul ghafar khan ?

Answered: 1 week ago

Question

Prepare a short note on dandi March ?

Answered: 1 week ago