Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Subject 2 (40%) A. (30%) The CFO of the supermarket chain Aldi is examining an investment in a new delivery service for internet orders. The

image text in transcribed

Subject 2 (40%) A. (30%) The CFO of the supermarket chain Aldi is examining an investment in a new delivery service for internet orders. The initial investment of the project consists of a cash outflow of 700,000 for the following items: a) distribution fleet, b) computer servers, c) delivery packages, and d) other fixed assets. These assets will be fully depreciated for tax purposes over a 5-year period, which is the lifetime of the project, using the straight-line depreciation method. At the end of this project, the distribution fleet and computer servers can be sold for 60,000. The revenue of the new service will be equal, for the first year, to 15% of the current total sales of the traditional service, which are 7.5 million. For the following years, the revenues of the new service will be 20%, 25%, 30%, and 35% respectively of the initial traditional sales. This new service for internet ordering is a premium service. Therefore, the prices of the home delivery goods will be 5% higher than the current supermarket prices. It should be taken into account that the cost of goods sold represents 70% of the supermarket sales price. Aldi expects to spend each year 7% of the sales of the new service for advertising. The company already has the available warehouse capacity needed for this service. The service will occupy 10% of the warehouse. The warehouse is rented at an annual cost of 300,000. The wages for the project workers will be 150,000 per year, however, 20% of them are workers transferred from other Aldi businesses the company has a lifetime job policy). The distribution costs (fuel, etc.) are 3% of sales of the new service. The introduction of the new internet ordering service will have as a consequence the reduction of the traditional sales of the supermarket business. Sales in the traditional supermarket business are expected to decrease from 7.5 million a year to 7.4 million a year for the next five years. Accounts payable are equal to 4% of cost of goods sold, inventory corresponds to 8% of cost of goods sold, and accounts receivables are 10% of sales. At the end of the internet sales project, all remaining net working capital would be liquidated, and the cash recovered. Aldi has profits from its current business, pays taxes of 25% and has a cost of capital equal to 10%. You are required to: a. Calculate the project's profit after tax throughout its five-year cycle (7.5%) b. What is the change in Net Working Capital for each year? (7.5%) c. Calculate the project's Net Cash Flows for each year (7.5%) d. Evaluate the project according to its NPV, IRR, Profitability Index, and Payback Period (7.5%)

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

Introductory Econometrics For Finance

Authors: Chris Brooks

3rd Edition

1107661455, 9781107661455

More Books

Students also viewed these Finance questions