Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Manuel is somewhat confused about his cost of capital. He knows that he should not rely on the bookstore's historic cost of debt. He therefore

Manuel is somewhat confused about his cost of capital. He knows that he should not rely on the bookstore's historic cost of debt. He therefore phoned up his bank manager who quoted him an interest rate of \( 7 \% \) if he were to take out a loan today. Following some extensive research on the internet, he is pretty sure that the equity beta of his bookstore is roughly 1.3 . He asked one of his regular customers, a finance professor at IE, what risk premium he should use for the market premium. The professor suggested to use a market risk premium of \( 5.8 \% \) p.a. However, Manuel does not know what rate to use for the riskfree rate. He looked up the yields on various debt securities issued by the Spanish government and he found the following: Note: The Spanish word for bond is "boso": The bookstore is currently financed by \( 35 \% \) of debt and \( 65 \% \) of equity. The new project is expected to require the same capital structure or mix of debt and equity as the entire bookstore. Net working capital of \( 12 \% \) 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. Manuel does not feel very confident about estimating his cost of capital. Would you be able to help him? What value would you suggest for the cost of capital?
Please answer each of the following questions:
1. Determine the incremental cash flows for this project.
Clearly explain why a given cash flow is incremental or not.
2. Compute the NPV, IRR and payback period for the project. Should Manuel go ahead with this project?
3. Manuel does not feel very confident about his estimated cost of capital. Would you be able to reassure him? If yes, how?
In this final assignment, you are asked to answer several questions regarding a potential business idea (described below). Apply all that you have learnt throughout the course to answer the questions - and good luck! 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 30 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 one's current book at home while travelling. The five MBA students spent last summer interviewing local tourists about the desirability of such a service. Manuel Muoz, the bookstore owner, sponsored this market study with \( 1,250 \). The market study also revealed that Amazon were planning to set up a similar delivery service in eentral Madrid. Due to various administrative delays, Amazon would only be able to start its delivery service in exactly 3 years from now. It would then immediately price Manuel's bookstore out of the market. The bookstore would need to buy two electric bicycles for the delivery people at a price of \( I, 500 \mathrm{each} \). The two bicycles would be fully depreciated in a straight line over the three years. They could be sold for \( e 400 \) 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 a monthly rent of \( 2,000 \). The storage room would require heavy-duty metal shelves at a total cost of \( 4,000 \). If going ahead, Manuel wants to advertise the new delivery service by distributing leaflets to nearby hotels. He has been quoted a fee of \( 15,000 \) for the design of various promotional items and another \( 3,200 \) for the printing of sufficient leaflets and other promotional items (such as free cupholders) to last for the next three years. The two delivery people needed for the delivery service would be paid 616,000 p.a. However, Manuel expects to relocate an existing employee who already works for the bookstore to the delivery service. This employee currently earns \( 15,000 \mathrm{p} \).a. The new delivery service would generate sales of 750 books, 1,000 books and 1,200 books each month during the first year, the second year and the third year, respectively. The average sales price of the books would be \( 20 \). The cost of the books sold is \( 75 \% \) of their sales price to the customers. Manuel expects that the number of books sold instore would drop by \( 25 \% \) of the number of books sold via the delivery service. The average sales price per book for the eroded sales is \( E 15 \) and the cost of the books sold is \( 80 \% \). The bookstore pays \( 30 \% \) of tax on its profits.
Assignment Structure Your assignment will be an Excel spreadsheet cleary showing your answers to the questions below (three main questions, with each question subdivided into parts).
For Question 1 ( \( 25 \% \) of your grade):
A. Determine the incremental cash flows for this project calculate each.
B. Clearly explain why a given cash flow is incremental or not - write your thought process/justification in another cell (to the right of your calculations for each selected cash flow).
For Question 2 (50\% of your grade):
A. Compute the NPV, IRR and payback period for the project - calculate each.
B. Should Manuel go ahead with this project? Write your recommendation (paragraph, using a cell in the Excel sheet and clearly label it as your answer to Question 2B) with your explanation for what your suggestion is for Manuel as far as going ahead with the project.
For Question 3 (25\% of your grade):
A. Manuel does not feel very confident about his estimated cost of capital - calculate the cost of capital (show your calculation).
B. Would you be able to help him? What would be your suggested cost of capital? Write your recommendation (paragraph, using a cell in the Excel sheet and clearly label it as your answer to Question 3B) explaining your thought process.

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

Monetary Policy Strategy

Authors: Frederic S. Mishkin

1st Edition

0262513374, 978-0262513371

More Books

Students also viewed these Finance questions

Question

What is the function of an income statement?

Answered: 1 week ago