Question

Simply Chocolate Company is considering two possible expansion plans.Proposal X involves opening five stores in North...

Simply Chocolate Company is considering two possible expansion plans.Proposal X involves opening five stores in North Carolina at a cost of $2,400,000. Under Proposal Y, the company would focus on Virginia and open six stores at a cost of $3,000,000. The following information is given for the two proposals:

                                                                 

                                                                           Proposal X           Proposal Y

Required investment                                      $2,400,000        $3,000,000

Estimated life                                                   10 years              10 years

Estimated residual value                                  $200,000              $200,000

Estimated annual net cash flows                        $450,000             $580,000

Required rate of return                                       14%                      14%

Based on the above following problem,

Required: for each proposal, you are asked to calculate

a.Pay back Period

b.Accounting Rate of Return

c.Net Present Value      

d.Profitability Index

3.Indicate which proposal is the better investment.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

a. Payback period for Proposal X= 2400000/450000=5.33 year and for proposal Y=3000000/580000= 5.17 year

b. Accounting rate of return for X=450000/2400000=18.75% and for Y= 580000/3000000=19.33%

c.

For Proposal X present value of annual net cash flow=$2347252.04.Calculation given below:

A C D E G rate 14% 14% rate PMT 450000 PMT 450000 10 10 nper nper PV |=PV(E1,E3,E2) ($2,347,252.04) PV PV(rate, nper, pmt, [f

So, NPV=-2400000+2347252.04+200000/1.14^10=$1200.80

For proposal Y present value of annual net cash flow=$3025347.07 Calculation given below:

A B D F rate PMT 14% 14% rate 580000 PMT 580000 nper PV 10 10 nper |=PV(E1,E3,E2) ($3,025,347.07) PV PV(rate, nper, pmt, [fv]

So, NPV for proposal Y= 3025347.07-3000000+200000/1.14^10=$79295.83

d. Profitability index for X= (NPV+Initial investment)/initial investment=(1200.80+2400000)/2400000=1.0005

Similarly PI for Y= (79295.83+3000000)/3000000= 1.026

As PI for proposal Y is more than X, so proposal Y should be chosen.

Add a comment
Know the answer?
Add Answer to:
Simply Chocolate Company is considering two possible expansion plans.Proposal X involves opening five stores in North...
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
  • O'Mally Department Stores is considering two possible expansion plans. One proposal involves opening 5 stores in...

    O'Mally Department Stores is considering two possible expansion plans. One proposal involves opening 5 stores in Indiana at the cost of $1,890,000. Under the other proposal, the company would focus on Kentucky and open 6 stores at a cost of $2,500,000. The following information is available: Indiana proposal Kentucky_proposal Required investment $1,890,000 $2,500,000 Estimated life 5 years 5 years Estimated residual value $50,000 $40,000 Estimated annual cash inflows over the next 10 years $700,000 $900,000 Required rate of return 15%...

  • 8 years Redwood Corporation is considering two alternative investment proposals with the following data: Proposal X...

    8 years Redwood Corporation is considering two alternative investment proposals with the following data: Proposal X Proposal Y Investment $800,000 $494,000 Useful life 8 years Estimated annual net cash inflows for 8 years $135,000 $83,000 Residual value $37,000 $- Depreciation method Straight-line Straight-line Required rate return 15% 14% How long is the payback period for Proposal Y? A. 5.95 years OB. 5.93 years O c. 21.62 years OD. 13.35 years

  • Capital Rationing Decision for a Service Company Involving Four Proposals Clearcast Communications Inc. is considering allocating...

    Capital Rationing Decision for a Service Company Involving Four Proposals Clearcast Communications Inc. is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated Operating income, and net cash flow for each proposal are as follows: Investment Year Operating Income Net Cash Flow Proposal A: $450,000 1 $30,000 $120,000 2    30,000   120,000 3    20,000   110,000 4    10,000   100,000 5   (30,000)    60,000 $60,000 $510,000 Proposal B: $200,000 1 $60,000 $100,000 2    40,000     80,000...

  • HomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing...

    HomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing fresh, local produce, meats, and dairy products to consumers in urban areas. HomeGrown is considering opening several stores in a new city, and has proposals from three contractors (Alpha, Beta, and Gamma companies) who would like to provide buildings for the new stores. The amount of expected revenue from the stores will depend on the design of the contractor. For example, if HomeGrown decides...

  • Please answer correctly ASAP. HomeGrown Company HomeGrown Company is a chain of grocery stores that are...

    Please answer correctly ASAP. HomeGrown Company HomeGrown Company is a chain of grocery stores that are similar to indoor farmer's markets, providing fresh, local produce, meats, and dairy products to consumers in urban areas. HomeGrown is considering opening several stores in a new city, and has proposals from three contractors (Alpha, Beta, and Gamma companies) who would like to provide buildings for the new stores. The amount of expected revenue from the stores will depend on the design of the...

  • Capital Rationing Decision for a Service Company Involving Four Proposals Renaissance Capital Group is considering allocating...

    Capital Rationing Decision for a Service Company Involving Four Proposals Renaissance Capital Group is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated income from operations, and net cash flow for each proposal are as follows: Investment Year Income from Operations Net Cash Flow Proposal A: $680,000 1 $ 64,000 $ 200,000 2    64,000    200,000 3    64,000    200,000 4    24,000    160,000 5    24,000    160,000 $240,000 $ 920,000 Proposal B: $320,000 1...

  • Capital Rationing Decision for a Service Company Involving Four Proposals Renaissance Capital Group is considering alloc...

    Capital Rationing Decision for a Service Company Involving Four Proposals Renaissance Capital Group is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated operating income, and net cash flow for each proposal are as follows: Investment Year Operating Income Net Cash Flow Proposal A: $680,000 1 $ 64,000 $ 200,000 2    64,000    200,000 3    64,000    200,000 4    24,000    160,000 5    24,000    160,000 $240,000 $ 920,000 Proposal B: $320,000 1 $ 26,000...

  • Capital Rationing Decision for a Service Company Involving Four Proposals Renaissance Capital Group is considering allocating...

    Capital Rationing Decision for a Service Company Involving Four Proposals Renaissance Capital Group is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated operating income, and net cash flow for each proposal are as follows: Investment Year Operating Income Net Cash Flow Proposal A: $680,000 1 $ 64,000 $ 200,000 2    64,000    200,000 3    64,000    200,000 4    24,000    160,000 5    24,000    160,000 $240,000 $ 920,000 Proposal B: $320,000 1 $ 26,000...

  • -NM PR 11-6B Capital rationing decision for a service company involving Obj. 2, 3,5 four proposals...

    -NM PR 11-6B Capital rationing decision for a service company involving Obj. 2, 3,5 four proposals Clearcast Communications Inc. is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated income from operations, and net cash flow for each proposal are as follows: Income from Net Cash Investment Year Operations Flow Proposal A: $450,000 $ 30,000 $120,000 30,000 120,000 20,000 110,000 10,000 100,000 (30,000) 60,000 $ 60,000 $510,000 Proposal B: $200,000 $...

  • Capital Rationing Decision for a Service Company Involving Four Proposals Renaissance Capital Group is considering allocating...

    Capital Rationing Decision for a Service Company Involving Four Proposals Renaissance Capital Group is considering allocating a limited amount of capital investment funds among four proposals. The amount of proposed investment, estimated income from operations, and net cash flow for each proposal are as follows: Investment Year Income from Operations Net Cash Flow Proposal A: $680,000 1 $ 64,000 $ 200,000 2    64,000    200,000 3    64,000    200,000 4    24,000    160,000 5    24,000    160,000 $240,000 $ 920,000 Proposal B: $320,000 1...

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