Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A small bookstore on Gran Via, one of the main arteries through Madrid and a famous shopping street, has come up with the idea of
A small bookstore on Gran Via, one of the main arteries through Madrid and a famous shopping street, has come up with the idea of delivering books to visitors to Madrid who stay in local hotels. Given the central location of the bookstore, the books would be delivered to tourists staying in nearby hotels within less than minutes.
The idea for the delivery service originally came from five MBA students at IE Business School who conducted a market study into the potential need for such a service. From personal experience, the students knew that it is easy to forget ones current book at home while traveling. The five MBA students spent last summer interviewing local tourists about the desirability of such a service. Manuel Munoz, the bookstore owner, sponsored this market study with The market study also revealed that Amazon was planning to set up a similar delivery service in central Madrid. Due to various administrative delays, Amazon would only be able to start its delivery service in exactly years from now. It would then immediately price Manuels bookstore out of the market.
The bookstore would need to buy two electrical bicycles for the delivery guys for each. The two bicycles would be fully depreciated in a straight line over the three years. They could be sold for each at the end of the project. The bookstore would also need to use an empty room at the back of the store as a storeroom. If the bookstore were not to go ahead with the delivery service, the empty room could be rented out at an annual rent of The storage room would require heavyduty metal shelves at a total cost of These metal shelves would have to be fixed to the walls and would therefore be difficult to remove once fixed. Hence, Manuel assumes that the shelves will not have a resale value. He also assumes that they will not be depreciated.
If going ahead, Manuel wants to advertise the new delivery service by distributing leaflets to nearby hotels. He has been quoted a fee of for the design of various promotional items and another for the printing of sufficient leaflets and other promotional items such as free keyholders to last for the next three years.
The new delivery service would generate sales of books, books, and books each month during the first year, the second year, and the third year, respectively. The average sales price of the books would be The cost of the books sold is of their sales price to the customers. Manuel expects that the number of books sold instore would drop by of the number of books sold via the delivery service. The average sales price per book for the eroded sales is and the cost of the books sold is The bookstore pays a tax on its profits.
The two delivery guys needed for the delivery service would be paid pa However, Manuel expects to relocate an existing employee who already works for the bookstore to the delivery service. Given the erosion of the instore book sales, if Manuel were to go ahead with the delivery service, this employee would no longer be needed in the store. This employee currently earns pa
Net working capital of of the annual sales revenue would need to be in place at the start of each year. The net working capital would be fully recovered at the end of the project.
Instructions
a Attached is an Excel file with the potential incremental cash flows for this project. Determine which ones are incremental cash flows by stating Yes or No in the second column of the table below. Then state your reason for answering yes or no in the third column.
b Based on your answer to part a and following the general structure in the excel sheet, compile your cash flow statements.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started