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

Free

60.1K

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$44,000$143,000$92,000$229,000
244,000143,00070,000193,000
344,000143,00035,000136,000
444,000143,00015,00093,000
544,000143,0008,00064,000
Total$220,000$715,000$220,000$715,000

Each project requires an investment of $400,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   netpresent value as tracking technology cash flowsoccur   in time. Thus, if only one of the twoprojects can be accepted, the   would be the moreattractive.

Answer & Explanation Solved by verified expert
3.9 Ratings (360 Votes)

Req 1.
Average rate of return:
Ware house Tracking
Year Income Income
1 44000 92000
2 44000 70000
3 44000 35000
4 44000 15000
5 44000 8000
Total 220000 220000
Divide: Year 5 5
Average Income 44000 44000
Divide: Average Investment 200000 200000
(400000/2)
Average rate of return 22% 22%
Req 2.
NPV at 10%
PVF at 10% Ware house Tracking
Year Cashflows PV of Cf Cashflows PV of CF
1 0.909091 143000 130000 229000 208181.8
2 0.826446 143000 118181.8 193000 159504.1
3 0.751315 143000 107438 136000 102178.8
4 0.683013 143000 97670.92 93000 63520.25
5 0.620921 143000 88791.75 64000 39738.96
Present value of inflows 542083 573124
Lss: Intial investment 400000 400000
Net present value 142083 173124

The Net present value of warehouse is lower than tracking as cashflows occur in earlier years. Thus tracking shall be accepted.


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