The capital investment committee of Ellis Transport and StorageInc. is considering two investment projects....

Free

90.2K

Verified Solution

Question

Accounting

  1. 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$37,800$120,000$79,000$192,000
    237,800120,00060,000162,000
    337,800120,00030,000114,000
    437,800120,00013,00078,000
    537,800120,0007,00054,000
    Total$189,000$600,000$189,000$600,000

    Each project requires an investment of $360,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

    • larger
    • smaller
    net present value as tracking technology cash flows occur
    • earlier
    • more evenly
    • later
    in time. Thus, if only one of the two projects can be accepted, the
    • tracking technology
    • warehouse
    would be the more attractive.

Answer & Explanation Solved by verified expert
4.3 Ratings (774 Votes)

Average Annual net income 37800 =189000/5
Average Investment 180000 =360000/2
1a
Average Rate of Return
Warehouse 21% =37800/180000
Tracking Technology 21% =37800/180000
1b
Warehouse Tracking Technology
Present value of net cash flow total 454800 480762
Less amount to be invested 360000 360000
Net present value 94800 120762
2
The warehouse has a smaller net present value as tracking technology cash flows occur earlier in time. Thus, if only one of the two projects can be accepted, the Tracking Technology would be the more attractive.
Workings:
Warehouse Tracking Technology
Year Cash flows PV factor Present value Cash flows PV factor Present value
1 120000 0.909 109080 192000 0.909 174528
2 120000 0.826 99120 162000 0.826 133812
3 120000 0.751 90120 114000 0.751 85614
4 120000 0.683 81960 78000 0.683 53274
5 120000 0.621 74520 54000 0.621 33534
Total 454800 Total 480762

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

Transcribed Image Text

In: AccountingThe capital investment committee of Ellis Transport and StorageInc. is considering two investment projects. The...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 TechnologyYearIncome fromOperationsNet CashFlowIncome fromOperationsNet CashFlow1$37,800$120,000$79,000$192,000237,800120,00060,000162,000337,800120,00030,000114,000437,800120,00013,00078,000537,800120,0007,00054,000Total$189,000$600,000$189,000$600,000Each project requires an investment of $360,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 CompoundInterestYear6%10%12%15%20%10.9430.9090.8930.8700.83320.8900.8260.7970.7560.69430.8400.7510.7120.6580.57940.7920.6830.6360.5720.48250.7470.6210.5670.4970.40260.7050.5640.5070.4320.33570.6650.5130.4520.3760.27980.6270.4670.4040.3270.23390.5920.4240.3610.2840.194100.5580.3860.3220.2470.162Required:1a. Compute the average rate of return for eachinvestment. If required, round your answer to one decimalplace.Average Rate of ReturnWarehouse%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 TechnologyPresent value of net cash flow total$$Less amount to be invested$$Net present value$$2. The warehouse has alargersmallernet present value as tracking technology cash flows occurearliermore evenlylaterin time. Thus, if only one of the two projects can be accepted, thetracking technologywarehousewould be the more attractive.

Other questions asked by students