Prepare before tax cash inflows and cash outflows

Assignment Help Business Management

Reference no: EM1376721

Roche Brothers is planning two options for a capacity expansion of its supermarket - (1) 3-stage expansion, and (2) 1-stage expansion.

The first alternative expands the supermarket at the end of year 0 to 60,000 customers, to 70,000 at the end of year 3, and to 80,000 at the end of year 5. Since the first stage expansion provides a big leap for the company to provide services from 30,000 to 60,000 customers, the initial investment would be higher at the end of year 0 than other two investments. The initial investment would be $1,000,000 at the end of year 0, $500,000 at the end of year 3, and $200,000 at the end of year 5. With this alternative, the company must pay $50,000 of monthly operating expenses.

The second alternative expands the supermarket at the end of year 0 to 75,000. The initial investment would be $1,500,000 at the end of year 0. With this alternative, the company must pay $30,000 of monthly operating expenses.

The projected demand for the next 7 years is shown below.

Year Projected Demand
1 50,000
2 55,000
3 60,000
4 65,000
5 70,000
6 75,000
7 80,000

The current effective capacity is equivalent to 30,000 customers per year and the pre-tax profit is approximately $3 per month of customer spending. Using information given above, please prepare the following information in details:

a. Before-tax cash inflows , cash outflows, and cumulative cash flow through year 7 for each alternative
b. What is the final contribution at the end of year 7 for each alternative?
c. What is the break-even years and months for each alternative?
d. According to the question (c), if the annual compound interest rate is 10%, which alternative is better? Why?

Reference no: EM1376721

Questions Cloud

A manager states that his process is actually working well : A manager states that his process is actually working well. Out of 1,550 parts, 1,473 were produced free of a particular defect as well as passed inspection

Sternberg''s triarchic theory of intelligence : Intelligent behavior is a function of how well people draw on their cognitively process and prior experiences information in order to adapt to their particular environmental situation.

Describe how a race condition is possible : Elucidate how a race condition is possible also illustrate what might be done to prevent race condition from occurring.

Thoughts that might reflect self-serving principles except : All of the subsequent are statements or thoughts that might reflect self-serving principles except- This act really would not hurt anybody.

Prepare before tax cash inflows and cash outflows : Roche Brothers is planning two options for a capacity expansion of its supermarket - three stage expansion, and one stage expansion.

Barnwell''s effective interest revenue : Organize amortization schedules that designate Barnwell's effective interest revenue for every interest period during the term to maturity.

Evaluate the total bond proceeds : Evaluate the total bond proceeds and what portion of bond proceeds is accounted for as debt under IFRS?

Illustrate what ways were project''s planning also scope : In illustrate what ways were project's planning also scope management appropriate. When did planners begin taking unknowing or unnecessary risk.

Evaluate the monthly margin of safety in dollars : Evaluate the monthly margin of safety in dollars if the business achieves it's operating income goal?

User Account

All Pages