Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Arkansas Best Freightways is considering a purchase of three different potential trucks. it is considering three different investment scenarios and their respective cash flows. Arkansas
Arkansas Best Freightways is considering a purchase of three different potential trucks. it is considering three different investment scenarios and their respective cash flows. Arkansas Best Freightways use a cost of capital of 9 percent to evaluate the investments. Cost of Capital 98 Year Year 0 (today) Year 1 Year 2 Year 3 Year 4 Buy new truck Increased profits Increased profits Increased profits Increased profits Investment i (85,000) 25,000 25,000 25,000 25,000 Investment 2 (105,000) 20,000 30,000 40,000 50,000 Investment 3 (125,000) 40,000 30,000 20,000 10,000 Required: 1. Calculate the net cash flows (not discounted) over the life of the three investments. (Negative amounts should be entered using a minus sign.) Investment 1 Investment 2 Investment 3 Net cash flows over life (not discounted) 2. Calculate the net present value for each of the three possible investments, using the 9 percent cost of capital as the interest (or discount) rate. (Negative amounts should be entered using a minus sign. Round your answer to 2 decimal places. Use the Excel NPVO function to calculate the net present value for each of the three possible investments.) Investment 1 Investment 2 Investment 3 Net present value (NPV) 3. Which investment has the highest net present value (NPV)? The lowest NPV? Highest net present value Lowest net present value
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started