Compute annual rate of return, cash payback, and net present value. Excel P27.1A (LO 1,...

80.2K

Verified Solution

Question

Accounting

image

Compute annual rate of return, cash payback, and net present value. Excel P27.1A (LO 1, 2, 5) U3 Company is considering three long-term capital investment proposals. Each investment has a useful life of 5 years. Relevant data on each project are as follows. Project Bono Project Edge Project Clayton Capital investment $160,000 $175,000 $200,000 Annual net income: Year 1 14,000 18,000 27,000 2 14,000 17,000 23,000 3 14,000 16,000 21,000 4 14,000 12,000 13,000 5 14,000 9,000 12,000 Total $ 70,000 $ 72,000 $ 96,000 Depreciation is computed by the straight-line method with no salvage value. The company's cost of cap- ital is 15%. (Assume that cash flows occur evenly throughout the year.) Problems: Set A 2 b. E $(7,312); C $2,163 Instructions a. Compute the cash payback period for each project. (Round to two decimals.) b. Compute the net present value for each project. (Round to nearest dollar.) c. Compute the annual rate of return for each project. (Round to two decimals.) (Hint: Use average annual net income in your computation.) d. Rank the projects on each of the foregoing bases. Which project do you recommend

Answer & Explanation Solved by verified expert
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