Question

In: Finance

A savvy business owner who owns several chicken franchises is seeking to add another store to...

A savvy business owner who owns several chicken franchises is seeking to add another store to his portfolio of stores. He wants to buy a store in the Memphis market at a cost of $8.00 million. However, the owner will sell the store to him, BUT he also has to buy a second store in the Oxford market at a cost of $6.00 million as part of the deal. The Memphis store is doing well, but the Oxford store has cash flow issues. The business owner will have to buy BOTH stores or NONE at all. The owner has a discount rate of 10.00%. The owner will value the opportunities over a five-year period.

STORE 0 1 2 3 4 5
MEMPHIS -$8.00 $1.98 $2.10 $2.23 $2.51 $6.00
OXFORD -$6.00 $0.74 $0.52 $0.84 $0.91 $4.00

What is the NPV and rate of return of buying both stores?

Solutions

Expert Solution

As per the above data, Discount rate is 10%

NPV = R1/(1+i)1 + R2/(1+i)2 + R3/(1+i)3 + .......- Initial Investment

For Memphis:-

NPV

= 1.98/1.1000 + 2.10/1.2100 + 2.23/1.3310 + 2.51/1.4641 + 6.00/1.6105 - 8.00

=1.8000 + 1.7355 + 1.6754 + 1.7144 + 3.7256 - 8.00

=10.6509 - 8.00

=2.6509

For Oxford :-

NPV

=0.74/1.1000 + 0.52/1.2100 + 0.84/1.3310 + 0.91/1.4641 + 4.00/1.6105 - 6.00

=0.6727 + 0.4298 + 0.6311 + 0.6215 + 2.4837 - 6.00

=4.8388 - 6.00

= - 1.1612

Combined NPV = 2.6509 - 1.1612 = 1.4897

IRR (Rate of Return) Calculations:

For Memphis:-

0 = CF0 + CF1/ (1+r)1 + CF2/ (1+r)2 + CF3/ (1+r)3 + CF4/ (1+r)4 + CF5/ (1+r)5

​​​​​0 = -8.00 + 1.98 / (1+r)1 +2.10/ (1+r)2 +2.23/ (1+r)3 +2.51/ (1+r)4 +6.00/ (1+r)5

=20%

For Oxford:-

0 = CF0 + CF1/ (1+r)1 + CF2/ (1+r)2 + CF3/ (1+r)3 + CF4/ (1+r)4 + CF5/ (1+r)5

​​​​​0 = -6.00 + 0.74 / (1+r)1 +0.52/ (1+r)2 +0.84/ (1+r)3 +0.91/ (1+r)4 +4.00/ (1+r)5

=4%

Combined IRR (rate of return) = 20% + 4% = 24%

So, the combined NPV is 1.4897 & Combined IRR (rate of return) is 24%


Related Solutions

Big Al’s Gas Company owns several gas stations, and they are looking to add another. One...
Big Al’s Gas Company owns several gas stations, and they are looking to add another. One station they are evaluating is located at a site that has been leased. The lease currently has 30 years before expiration (so the last cash flow will occur at t = 30). The gas station is expected to generate a net cash flow of $65,000 for 30 years starting at the end of the first year. If Big Al needs to invest $500,000 in...
The Subway Sandwich Shop, Inc. is seeking to sell new franchises for its business. The company...
The Subway Sandwich Shop, Inc. is seeking to sell new franchises for its business. The company is in the process of developing a business plan to present to potential investors. Following are various projected cost data for a typical sandwich shop: Lease of store space $500/month Equipment lease $500/month License $240/year Advertising 2.5% gross sales revenue Royalty 8% of gross sales revenue Salaries $2,000/month Utilities $400/month Insurance $1,500/year The average order (sandwich) sells for $4, with food cost of $2....
Big Z Chicken is a private fast food business located in Georgia. The company sells franchises...
Big Z Chicken is a private fast food business located in Georgia. The company sells franchises in the chicken business and charges a 7.00% royalty on all sales of its stores. Here is a quick summary of Big Z company financials: Company Data Fiscal Year 2018 # of Stores 505.00 Revenues per store $1,000,000.00 Royalty on sales 7.00% EBITDA Margin on Sales 18.00% Balance Sheet Data Fiscal Year 2018 Interest bearing debt $15,000,000.00 Shareholder equity $12,000,000.00 Cash and Marketable Securities...
Big Z Chicken is a private fast food business located in Georgia. The company sells franchises...
Big Z Chicken is a private fast food business located in Georgia. The company sells franchises in the chicken business and charges a 7.00% royalty on all sales of its stores. Here is a quick summary of Big Z company financials: Company Data Fiscal Year 2018 # of Stores 502.00 Revenues per store $1,000,000.00 Royalty on sales 7.00% EBITDA Margin on Sales 15.00% Balance Sheet Data Fiscal Year 2018 Interest bearing debt $15,000,000.00 Shareholder equity $12,000,000.00 Cash and Marketable Securities...
A savvy business owner wanted to assess whether the type of fragrance influenced the amount of...
A savvy business owner wanted to assess whether the type of fragrance influenced the amount of money spent. He tried peppermint, lavender, male cologne, and a floral perfume in his four stores. Amount of money spent (in hundreds) is reported for each type of fragrance. Conduct a one-way repeated measures ANOVA to determine whether fragrance influences total amount of money spent. Peppermint Lavender Cologne Floral 4.2 3.3 5.1 3.9 5.1 1.8 4.9 4.3 4.8 3.0 3.2 3.5 6.2 3.2 4.0...
A retail store serves a variety of ice cream flavors. The owner would like to add...
A retail store serves a variety of ice cream flavors. The owner would like to add a flavor to the menu and needs to decide between Blueberry Cheesecake and Lemon Custard. To help her​ decide, she randomly selects 10 customers and asks them to taste each flavor and rate them on a scale of 1 to 20. A rating of 1 indicates the taster does not like the​ flavor, and a rating of 20 indicates that the taster likes it...
The owner of a high end US apparel store, Feminine Fashions, is planning to open another...
The owner of a high end US apparel store, Feminine Fashions, is planning to open another faacility in her hometown of Izmir, Turkey. She can open a large store, a small store, or, to hedge her debts, she could open a medium-sized store. The market for high-end apparel in Izmir could be favorable or unfavorable. If the market is favorable, a large store will earn her a payoff of $200,000. If unfavorable, she will suffer a net loss of $180,000....
To increase business, the owner of a shoe store is running a promotion in which a...
To increase business, the owner of a shoe store is running a promotion in which a customer's bill can be selected at random to receive a discount. When a customer's bill is printed, a program in the cash register determines randomly whether the customer will receive a discount on the bill. The program was written to generate a discount with a probability of 0.15; that is, 15% of the bills get a discount in the long run. However, the owner...
41. An investor who holds a portfolio a. Owns investments in several industries. b. Owns more...
41. An investor who holds a portfolio a. Owns investments in several industries. b. Owns more than one investment. c. Owns both bonds and stocks. d. Has invested an equal amount in several securities. 42. The rate of return from a portfolio is: a. Always greater than the return from any security within the portfolio. b. Equal to the rate of return from the best performing security in the portfolio. c. The weighted average of the rates of return of...
Problem Set 4: One-Way Repeated Measures ANOVA (7 pts) Research Scenario: A savvy business owner wanted...
Problem Set 4: One-Way Repeated Measures ANOVA (7 pts) Research Scenario: A savvy business owner wanted to assess whether the type of fragrance influenced the amount of money spent. He tried peppermint, lavender, male cologne, and a floral perfume in his four stores. Amount of money spent (in hundreds) is reported for each type of fragrance. Conduct a one-way repeated measures ANOVA to determine whether fragrance influences total amount of money spent. Peppermint Lavender Cologne Floral 4.2 3.3 5.1 3.9...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT