Question

In: Finance

You have just graduated from the MBA program of a large university, and one of your...

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?

Solutions

Expert Solution

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.


Related Solutions

You have just graduated from the MBA program of a large university, and one of your...
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...
You have just graduated from the MBA program of a large university, and one of your...
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.5 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...
Assume you just graduated from a university with an MBA and were hired by a small...
Assume you just graduated from a university with an MBA and were hired by a small American company generating 100% of its $20 million revenue from domestic sales. Your job as International Sales Director is quite simple: to make sure international sales generate as much revenue as domestic sales within five years. Where do you start? What are some of your first initiatives? Why?
Q2: You have just graduated from MBA program with finance major. Immediately after graduation you have...
Q2: You have just graduated from MBA program with finance major. Immediately after graduation you have been hired as a financial analyst in a highly prestigious listed company name Cornejo. Your first assignment is to estimate the cost of equity capital and stock price of the company. Your assistant gathered the following information for you: The dividend per share (DPS) record of the company over the last 5 years is as follows:                                        Year Dividend per Share (DPS) t-5 7.80...
Congratulations! You have just graduated from your University. Your first day on your new job involves...
Congratulations! You have just graduated from your University. Your first day on your new job involves a lot of paperwork including your decision to participate in the company 401K plan. First, should you participate? Second, describe the benefits of diversification if any including adding international stocks to your investment portfolio? You must include a full explanation to support your answer.
You have just entered an MBA program and have decided to pay for your living expenses...
You have just entered an MBA program and have decided to pay for your living expenses using a credit card that has no minimum monthly payment. You intend to charge $1, 000 per month on the card for the next 21 months. The card carries a monthly interest rate of 1%. How much money will you owe on the card 22 months from now, when you receive your first statement postgraduation?
You have recently graduated from your university course and start work with an audit firm. You...
You have recently graduated from your university course and start work with an audit firm. You meet an old school friend, Nayan, for dinner — you haven't seen each other for several years. Nayan is surprised that you are now working as an auditor because your childhood dream was to be a ballet dancer. Unfortunately, your knees were damaged in a fall, and you can no longer dance. The conversation turns to your work, and Nayan wants to know how...
You have recently graduated from your university and started work with an accounting firm. You meet...
You have recently graduated from your university and started work with an accounting firm. You meet an old school friend, Kim, for dinner—you haven’t seen each other for several years. Kim is surprised that you are now working as an auditor because your childhood dream was to be a ballet dancer. Unfortunately, your knees were damaged in a fall and you can no longer dance. The conversation turns to your work and Kim wants to know how you do your...
Being an auditor You have recently graduated from your university and started work with an accounting...
Being an auditor You have recently graduated from your university and started work with an accounting firm. You meet an old school friend, Kim, for dinner—you haven’t seen each other for several years. Kim is surprised that you are now working as an auditor because your childhood dream was to be a ballet dancer. Unfortunately, your knees were damaged in a fall and you can no longer dance. The conversation turns to your work and Kim wants to know how...
You have recently graduated from college with an MBA. Upon graduation, you start working for Roosevelt...
You have recently graduated from college with an MBA. Upon graduation, you start working for Roosevelt Power Plant. The boss, Mr. Jones, invites you into his office. Mr. Jones describes to you a large fraud that has recently taken place in the company. He asks you what actions should be taken to ensure that fraud does not occur again. After analyzing the company, you compile a list of actions that will be needed to prevent fraud from occurring again. Upon...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT