Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Summary Spreadsheet for The Case of CG Scooper BOY 1 EOY 1 EOY 2 EOY 3 Price per Transaction 11 Transactions per Day Price inflation/deflation

Summary Spreadsheet for The Case of CG "Scooper" BOY 1 EOY 1 EOY 2 EOY 3 Price per Transaction 11 Transactions per Day Price inflation/deflation Operating Days per Year Volume - Transactions per Store per Year 1995 Transactions per Store Year 1 Transaction Volume growth Growth - Transactions per Store per Year Stores per Year 250 Tax Rate Store growth Cost of Capital Cost of Sales (% of Sales) Operating Costs (% of Sales) * Inventory % of Sales 15% 15% Receivables % of Sales Payables % of Sales Capital Expenditures 2000000 Cap in Years 5 Straight Line Depreciation * Excluding Depreciation

Introduction to Project

Economics and Capital Budgeting

Case of CG Scooper*

Case Objective

As a result of the case, participants will be able

to create, evaluate and present the financials of an

Appropriation Request

*This case was developed by TRI Corporation and is solely for educational purposes.

Introduction to Project

Economics and Capital Budgeting

The Case of CG Scooper

A business project team has recently concluded that a new product/service (hereafter Scooper) can be a significant value

creation opportunity for CG Co. CG has been in business for over 20 years and is always looking for innovative ways to

create growth for its Shareholders. Scooper will allow an expansion into major retailers such as Home Depot, Lowes &

Wall-Mart. The opportunity will involve the 20 lb. Scoopers commonly used by consumers during home parties.

Prior teams had put together Capital Expenditure proposals for Scooper type programs, recognizing the potential demand

from consumers who would desire the convenience of one-stop shopping at the aforementioned retailers. Unfortunately,

sensitivity analyses performed during these prior proposals could never justify an acceptance decision in their downside cases

(i.e., below base case). Our new management team, however, has identified recent trends in consumer life styles could revive

interest in this channel of distribution.

The base case assumptions are as follows:

Input Value

Cost of Sales (% Sales) ***** 60%

Capital Expenditures* $2,000,000

Transactions per day ** 7

Operating days in year 300

Price per Transaction *** $10.00

Stores**** 250

Operating Costs (% Sales) ****** 20%

Tax rate 38%

Working capital*******

Inventory (% Sales) 15%

Receivables (% Sales) 16%

Payables (% Sales) 12.5%

Cost of capital 14%

* Assumed paid today with 5-yr life and straight-line (linear) depreciation (no salvage value @ 5th year)....

.....Cap Expenditures include all upfront costs in buildings, machinery and equipment

** 7 per day for yr 1 (from focus and beta test) growing at -5% per yr for yrs 2 & 3

*** $10 is yr 1 price....assume selling price increase of 5% and 4.8% in yrs 2 & 3, respectively

**** 250 for yr 1 and 300 and 400 in yrs 2 & 3, respectively

***** 60% for yr 1 and 58% and 55% in yrs 2 & 3, respectively...includes labor, supplies and an inert gases

****** 20% for yr 1 and 21% and 22% in yrs 2 & 3, respectively...includes distribution, selling and administration

******* Assumed constant per year

The time horizon is 3 years. It is assumed the project is terminated at the end of year 3 (an alternative would be to model a

terminal value as a function of long-term growth). Any residual in net working capital (Inventory plus Receivables minus

Payables) and/or Capital Expenditures (un-depreciated value) is assumed to be recaptured in the year 3 cash flow.

Your task is to evaluate the economic feasibility of the Scooper opportunity by developing your own cash flow model (with

supporting decision metrics such as NPV, IRR, Payback, ROC, etc.). Sample Operating Cash Flow and Economic Profit

Statements can be found in the Appendix. Your model should be reasonably robust (allowing for sensitivity analysis). It is

suggested you create an input area that drives the model. You are free to pursue other options for valuing the opportunity you

consider to be more appropriate.

The purpose of the exercise is not to become an expert in financial modeling but for you to become cognizant of the major

issues in creating and evaluating the financials of a business proposal

APPENDIX

Operating Cash Flow & EP Model Structure

INPUTS (Drivers)

Yr. 0 Yr. 1 Yr. 2 Yr. 3

Sales ... ... ... ...

- Cost of Sales ... ... ... ...

Gross Margin ... ... ... ...

Gross Margin (% Sales) ... ... ... ...

- Operating Costs ... ... ... ...

- Depreciation ... ... ... ...

Operating Margin ... ... ... ...

OM (% Sales) ... ... ... ...

- Taxes ... ... ... ...

NOPAT ... ... ... ...

+ Depreciation ... ... ... ...

- Investment (Cap Exp) ... ... ... ...

- Change in Working Capital ... ... ... ...

Operating Cash Flow ... ... ... ...

Cumulative Cash Flow ... ... ... ...

NOPAT ... ... ... ...

- Capital Charge* ... ... ... ...

Economic Profit ... ... ... ...

METRICS

Decision

* For simplicity assume 14% Cost of Capital times beginning net assets (i.e., total capital at book)...net assets

equal net working capital (inventory plus receivables minus payables) plus net investment (initial investment

less accumulated depreciation).

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

A Journey Into Auditing Culture

Authors: Grant Thornton United Kingdom, Susan Jex, Eddie J. Best

1st Edition

1634540565, 978-1634540568

More Books

Students also viewed these Accounting questions