Sign In
Not register? Register Now!
Pages:
2 pages/≈550 words
Sources:
No Sources
Style:
Other
Subject:
Accounting, Finance, SPSS
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 11.23
Topic:

Net Present Value of Ecsy-Cola24

Coursework Instructions:

Ecsy-Cola24
Libby Flannery, the regional manager of Ecsy-Cola, the international soft drinks empire, was reviewing her investment plans for Central Asia. She had contemplated launching Ecsy-Cola in the ex-Soviet republic of Inglistan in 2025. This would involve a capital outlay of $20 million in 2024 to build a bottling plant and set up a distribution system there. Fixed costs (for manufacturing, distribution, and marketing) would then be $3 million per year from 2025 onward. This would be sufficient to make and sell 200 million liters per year—enough for every man, woman, and child in Inglistan to drink four bottles per week! But there would be few savings from building a smaller plant, and import tariffs and transport costs in the region would keep all production within national borders.
The variable costs of production and distribution would be 12 cents per liter. Company policy requires a rate of return of 25% in nominal dollar terms, after local taxes but before deducting any costs of financing. The sales revenue is forecasted to be 35 cents per liter.
Bottling plants last almost forever, and all unit costs and revenues were expected to remain constant in nominal terms. Tax would be payable at a rate of 30%, and under the Inglistan corporate tax code, capital expenditures can be written off on a straight-line basis over four years.
All these inputs were reasonably clear. But Ms. Flannery racked her brain trying to forecast sales. Ecsy-Cola found that the “1–2–4” rule works in most new markets. Sales typically double in the second year, double again in the third year, and after that remain roughly constant. Her best guess was that, if she went ahead immediately, initial sales in Inglistan would be 12.5 million liters in 2026, ramping up to 50 million in 2028 and onward.
Ms. Flannery also worried whether it would be better to wait a year. The soft drink market was developing rapidly in neighboring countries, and in a year’s time she should have a much better idea whether Ecsy-Cola would be likely to catch on in Inglistan. If it didn’t catch on and sales stalled below 20 million liters, a large investment probably would not be justified.
Ms. Flannery had assumed that Ecsy-Cola’s keen rival, Sparky-Cola, would not also enter the market. But last week she received a shock when, in the lobby of the Kapitaliste Hotel, she bumped into her opposite number at Sparky-Cola. Sparky-Cola would face costs similar to Ecsy-Cola. How would Sparky-Cola respond if Ecsy-Cola entered the market? Would it decide to enter also? If so, how would that affect the profitability of Ecsy-Cola’s project?
Ms. Flannery thought again about postponing investment for a year. Suppose Sparky-Cola were interested in the Inglistan market. Would that favor delay or immediate action?
Maybe Ecsy-Cola should announce its plans before Sparky-Cola has a chance to develop its own proposals. It seemed that the Inglistan project was becoming more complicated by the day.
QUESTIONS
Calculate the NPV of the proposed investment, using the inputs suggested in this case. How sensitive is this NPV to future sales volume?

Coursework Sample Content Preview:

Net Present Value of Ecsy-Cola24
Name
University
Course
Instructor
Due Date
Net Present Value of Ecsy-Cola24
An investment plan prepared by the company’s regional manager seeks to pursue the launch of Ecsy-Cola in Inglistan in 2025. Net Present value can be used to calculate the value of the project using the provided assumption. It is also essential to conduct a sensitivity analysis to assist in the assessment of the value of the investment project. To this end, the following report presents an analysis of the present value of the proposed investment and the influence of sales volume fluctuation on the value.
Cashflow after Tax Calculation
The regional manager points out that the capital expenditure associated with the investment will amount to US$ 20 million in 2024 which will be directed towards building the bottling plant and establishing the distribution system that can produce 200 million liters every year. annual fixed costs associated with the investment is US$ 3 million, and the variable cost shall be 12 cents for every year. The sales revenue generated for every liter is 35 cents. The local tax rate is 30 percent, and the capital expenditures are depreciated on a straight-line basis for four years. The 1-2-4 rule is used to forecast sales volume with 12.5 liters of the new products expected to be sold in 2026. Based on the following information, the cash flow after tax was calculated for the investment project and presented in the table below.
Year

Capital Expenditure

Fixed Expenses

Sales Volume Forecast

Forecasted Revenue

Variable Expenses

Operating Cash Flow Income

Depreciation

Taxable Income

Tax

Cashflow after Tax

2024

$20,000,000.00


0.00

$0.00

$0.00

-$20,000,000.00




-$20,000,000.00

2025


$3,000,000.00

0.00

$0.00

$0.00

-$3,000,000.00




-$3,000,000.00

2026


$3,000,000.00

12500000.00

$4,375,000.00

$1,500,000.00

-$125,000.00

$5,000,000.00

-$5,125,000.00

$0.00

-$125,000.00

2027


$3,000,000.00

25000000.00

$8,750,000.00

$3,000,000.00

$2,750,000.00

$5,000,000.00

-$2,250,000.00

$0.00

$2,750,000.00

2028


$3,000,000.00

50000000.00

$17,500,000.00

$6,000,000.00

$8,500,000.00

$5,000,000.00

$3,500,000.00

$1,050,000.00

$7,450,000.00

2029


$3,000,000.00

50000000.00

$17,500,000.00

$6,000,000.00

$8,500,000.00

$5,000,000.00
Updated on
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

👀 Other Visitors are Viewing These Other Coursework Samples:

HIRE A WRITER FROM $11.95 / PAGE
ORDER WITH 15% DISCOUNT!