In: Finance
You have just graduated from the MBA program of a large university, and one of your favorite courses was Today’s Entrepreneurs. In fact, you enjoyed it so much you have decided you want to “be your own boss.” While you were in the master’s program, your grandfather died and left you $1 million to do with as you please. You are not an inventor, and you do not have a trade skill that you can market; however, you have decided that you would like to purchase at least one established franchise in the fast-foods area, maybe two (if profitable). The problem is that you have never been one to stay with any project for too long, so you figure that your time frame is 3 years. After 3 years you will go on to something else. You have narrowed your selection down to two choices: (1)Franchise L, Lisa’s Soups, Salads & Stuff, and (2)Franchise S, Sam’s Fabulous Fried Chicken. The net cash flows that follow include the price you would receive for selling the franchise in Year 3 and the forecast of how each franchise will do over the 3-year period. Franchise L’s cash flows will start off slowly but will increase rather quickly as people become more health-conscious, while Franchise S’s cash flows will start off high but will trail off as other chicken competitors enter the marketplace and as people become more health-conscious and avoid fried foods. Franchise L serves breakfast and lunch, whereas Franchise S serves only dinner, so it is possible for you to invest in both franchises. You see these franchises as perfect complements to one another: You could attract both the lunch and dinner crowds and the health-conscious and not-so-health-conscious crowds without the franchises directly competing against one another.
Here are the net cash flows (in thousands of dollars):
Expected Net Cash Flows | ||
Year | Franchise L | Franchise S |
0 | ($100) | ($100) |
1 | 10 | 70 |
2 | 60 | 50 |
3 | 80 | 20 |
Depreciation, salvage values, net working capital requirements, and tax effects are all included in these cash flows.
You also have made subjective risk assessments of each franchise and concluded that both franchises have risk characteristics that require a return of 10%. You must now determine whether one or both of the franchises should be accepted.
Question: Please show all your work including formulas in excel if used.
You are also considering another project that has a physical life of 3 years—that is, the machinery will be totally worn out after 3 years. However, if the project were terminated prior to the end of 3 years, the machinery would have a positive salvage value. Here are the project’s estimated cash flows:
Year | Initial Investment and Operation Cash Flows | End of Year Ned Salvage Value |
0 | -5000 | 5000 |
1 | 2100 | 3100 |
2 | 2000 | 2000 |
3 | 1750 | 0 |
Using the 10% cost of capital, what is the project’s NPV if it is operated for the full 3 years? Would the NPV change if the company planned to terminate the project at the end of Year 2? At the end of Year 1? What is the project’s optimal (economic) life?
Calculation of NPV of Franchise L & Franchise S:
Below Sheet show the Excel Formula used for calculation of NPV:
Decision: Both Franchises have positive NPV, hence both should be accepted.
Regarding another project please refer to below below working:
Calculation of NPV of the project:
Below Sheet show the Excel Formula used for calculation of NPV:
Option A - In option A when Project run for 3 years then NPV is -123.22
Option B - In option B when project run for 2 years then NPV is 214.88
Option C - In option C when project run for only 1 year then again NPV is -272.73
Decision: In Option B NPV is postive hence it should be accepted and project should be run for only 2 years.
Further, I would like to request your valuable feedback on the submitted answer. Kindly let me know in case you would like to have any changes made in terms of any adjustments, format changes or disclosures to further enhance the quality and help me in serving you better. Should you have any queries regarding this answer, please let me know.