Average Rate of Return Method, Net Present Value Method, and Analysis The capital investment committee of Ellis...

90.2K

Verified Solution

Question

Accounting

Average Rate of Return Method, Net Present Value Method, andAnalysis

The capital investment committee of Ellis Transport and StorageInc. is considering two investment projects. The estimated incomefrom operations and net cash flows from each investment are asfollows:

WarehouseTracking Technology
YearIncome from
Operations
Net Cash
Flow
Income from
Operations
Net Cash
Flow
1$46,000$142,000$97,000$227,000
246,000142,00074,000192,000
346,000142,00037,000135,000
446,000142,00016,00092,000
546,000142,0006,00064,000
Total$230,000$710,000$230,000$710,000

Each project requires an investment of $460,000. Straight-linedepreciation will be used, and no residual value is expected. Thecommittee has selected a rate of 10% for purposes of the netpresent value analysis.

Present Value of $1 at CompoundInterest
Year6%10%12%15%20%
10.9430.9090.8930.8700.833
20.8900.8260.7970.7560.694
30.8400.7510.7120.6580.579
40.7920.6830.6360.5720.482
50.7470.6210.5670.4970.402
60.7050.5640.5070.4320.335
70.6650.5130.4520.3760.279
80.6270.4670.4040.3270.233
90.5920.4240.3610.2840.194
100.5580.3860.3220.2470.162

Required:

1a. Compute the average rate of return for eachinvestment. If required, round your answer to one decimalplace.

Average Rate of Return
Warehouse%
Tracking Technology%

1b. Compute the net present value for eachinvestment. Use the present value of $1 table above. If required,use the minus sign to indicate a negative net present value.

WarehouseTracking Technology
Present value of net cash flow total$$
Less amount to be invested$$
Net present value$$

2. The warehouse has a net present value astracking technology cash flows occur     in time. Thus, if only one of the two projects can be accepted,the   would be the more attractive.

Answer & Explanation Solved by verified expert
4.0 Ratings (428 Votes)
Solution 1a Average rate of return Average annual income Average investment Average annual income Warehouse 230000 5 46000 Tracking technology 230000 5 46000 Average investment Warehouse 460000 0 2 230000 Tracking    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students