Question
Can you solve for the following? Thanks!

have just inherited $300,000 and have decided to purchase at least one established franchise in the fast food industry or possibly the if ) Franchise L:Lsas Soups, Salads, and the franchise in 3 ears and the forecast of how each franchise will do over the 3-year period Franchise Is cask Nows will shart off sowly but will increase rather quickly as people become more health while Pranchise Ss cash fows will start off high but will eail off as other chicken competisors enser the marketplace and as people become more healh conscious and avoid fried foods. Pranchise t serves breakfast and lunch, while franchise S serves only dinner, so i is possiMle to nvest in bosk franchises You see these franchises as perfect complements to on anoher: you could atract both the lunch and dinner crowds and the heaith conucious and not so bealth concious crowds with the franchises directly competing agalnut one another Here are the projectsnet cash Jlows (in chossands of dollars) Expected Net Cash Flows Yoar S100) 3100) 50 salvage valves, nef working capital requirements, and sar effects are all included in these cash lows You have made subjective risk assessment of each franchise, and concluded that bock . i rarkir hrve nk character stic, ahat require a return 10% You must now determine whether one or both of the projects should be accepted. 20. The NPV of franchise Lis 22. The NPV of franchise S is 223. The IRR of franchise L is 23The IRR of franchise S is 245. The MIRR ofL is 256 The MIRR is S is
0 0
Add a comment Improve this question Transcribed image text
Answer #1

As per rules I am answering the first 4 subparts of the question.

1: NPV of L = $18.78 thousand

2: NPV of S= $ 19.98 thousand

3: IRR of L = 18.13%

4: IRR of S= 23.56%

Expected Cash flows
Year L S
0 -100 -100
1 10 70
2 60 50
3 80 20
NPV 18.78 19.98
IRR 18.13% 23.56%

WORKINGS

AutoSave Book1 - Excel 《Product Activation Failed) Sign in File Insert Page Layout Formulas Data Review View Help Tell me what you want to do 수 Share Home Calibri General 田FF Paste . 녀 . 의 _ . 로三들經垣臣 Merge & Center-5 . % , Conditional Fornat as Cell Insert Delete Fornat FormattingTable Styles- 、. Sort & Find & : Filter-Select- Clipboard Alignment Number Styles Cells Editing G10 Expected Cash flows Year 100 10 60 80 100 70 50 20 4 NPV IRR =NPV(10%,15:17)+14 IRR(14:17) :NPV(10%)517)+4 IRR(J4:J7) 10 12 13 14 15 16 17 Sheet1 Ready + 100 Lo ENG 9:04 AM

Add a comment
Know the answer?
Add Answer to:
Can you solve for the following? Thanks! have just inherited $300,000 and have decided to purchase...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You have just inherited $300,000 and have decided to purchase at least one established franchise in...

    You have just inherited $300,000 and have decided to purchase at least one established franchise in the fast food industry or possibly two if profitable. Your investment horizon is 3 years. You have narrowed down your choices to two choices: (1) Franchise L: Lisa’s Soups, Salads, and Stuff and (2) Franchise S: Sam’s Fried Chicken. The net cash flows shown below include the price you would receive for selling the franchise in 3 years and the forecast of how each...

  • 0 2You have just inherited $300,000 and have decided to purchase at least one established franchise...

    0 2You have just inherited $300,000 and have decided to purchase at least one established franchise in the fast food industry or possibly nwo if profitable. Your investment horizon is 3 years. You have narrowed wn your choices to two choices: (1) Franchise L: Lisa's Soups, Salads, and Stuff and (2) Franchise S: Sam's Fried Chicken. The net cash flows shown below include the price you would receive for selling e franchise in 3 years and the forecast of how...

  • Question 4 (15 points): the Mini Case distributed in-class For the Chapter 8 Mini Case distributed...

    Question 4 (15 points): the Mini Case distributed in-class For the Chapter 8 Mini Case distributed in class, determine the following: a. Calculate the NPV, IRR, and Profitability Index for each option. b. If the projects are mutually exlcusive, what is your decision? Why? c. If the projects are independent, what is your d ecision? Why? 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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT