You are the CFO of a business and have the opportunity to evaluate two different investment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are the CFO of a business and have the opportunity to evaluate two different investment opportunities. Information related to these investments follows: Investment 1 Investment Cost Salvage Value Useful Life Required Rate of Return Sales Variable Costs Fixed Costs (excluding depreciation) Tax Rate $ 800,000 $ 80,000 10 years 10% Investment 2 $ 600,000 $ 60,000 12 years 10% $ 500,000 $ 240,000 $ 500,000 $ 200,000 $ 100,000 35% $ 120,000 35% Your company has a required rate of return of 10% for all new investments and is subject to a tax rate of 35%. 1) Determine the annual after tax cash flow for each investment. In addition, determine the after-tax cash flow for the salvage value if you assume that the actual market value of Investment #1 at the end of ten years is $100,000 and the actual market value of Investment #2 at the end of twelve years is $40,000. 2) Prepare a schedule of expected cash flows for each investment. Note that all positive cash flows must be shown as positive numbers and all negative cash flows must be shown as negative numbers. 3) Calculate the Net Present Value for each investment using the NPV function in Excel. 4) Calculate the Internal Rate of Return for each investment using the IRR function in Excel. (Note your guess for the interest rate in the formula should be the required rate of return) 5) Recalculate the Net Present Value for INVESTMENT #1 ONLY but assume that the required/target rate of return is 6%, 12%, and 20%. You are the CFO of a business and have the opportunity to evaluate two different investment opportunities. Information related to these investments follows: Investment 1 Investment Cost Salvage Value Useful Life Required Rate of Return Sales Variable Costs Fixed Costs (excluding depreciation) Tax Rate $ 800,000 $ 80,000 10 years 10% Investment 2 $ 600,000 $ 60,000 12 years 10% $ 500,000 $ 240,000 $ 500,000 $ 200,000 $ 100,000 35% $ 120,000 35% Your company has a required rate of return of 10% for all new investments and is subject to a tax rate of 35%. 1) Determine the annual after tax cash flow for each investment. In addition, determine the after-tax cash flow for the salvage value if you assume that the actual market value of Investment #1 at the end of ten years is $100,000 and the actual market value of Investment #2 at the end of twelve years is $40,000. 2) Prepare a schedule of expected cash flows for each investment. Note that all positive cash flows must be shown as positive numbers and all negative cash flows must be shown as negative numbers. 3) Calculate the Net Present Value for each investment using the NPV function in Excel. 4) Calculate the Internal Rate of Return for each investment using the IRR function in Excel. (Note your guess for the interest rate in the formula should be the required rate of return) 5) Recalculate the Net Present Value for INVESTMENT #1 ONLY but assume that the required/target rate of return is 6%, 12%, and 20%. You are the CFO of a business and have the opportunity to evaluate two different investment opportunities. Information related to these investments follows: Investment 1 Investment Cost Salvage Value Useful Life Required Rate of Return Sales Variable Costs Fixed Costs (excluding depreciation) Tax Rate $ 800,000 $ 80,000 10 years 10% Investment 2 $ 600,000 $ 60,000 12 years 10% $ 500,000 $ 240,000 $ 500,000 $ 200,000 $ 100,000 35% $ 120,000 35% Your company has a required rate of return of 10% for all new investments and is subject to a tax rate of 35%. 1) Determine the annual after tax cash flow for each investment. In addition, determine the after-tax cash flow for the salvage value if you assume that the actual market value of Investment #1 at the end of ten years is $100,000 and the actual market value of Investment #2 at the end of twelve years is $40,000. 2) Prepare a schedule of expected cash flows for each investment. Note that all positive cash flows must be shown as positive numbers and all negative cash flows must be shown as negative numbers. 3) Calculate the Net Present Value for each investment using the NPV function in Excel. 4) Calculate the Internal Rate of Return for each investment using the IRR function in Excel. (Note your guess for the interest rate in the formula should be the required rate of return) 5) Recalculate the Net Present Value for INVESTMENT #1 ONLY but assume that the required/target rate of return is 6%, 12%, and 20%. You are the CFO of a business and have the opportunity to evaluate two different investment opportunities. Information related to these investments follows: Investment 1 Investment Cost Salvage Value Useful Life Required Rate of Return Sales Variable Costs Fixed Costs (excluding depreciation) Tax Rate $ 800,000 $ 80,000 10 years 10% Investment 2 $ 600,000 $ 60,000 12 years 10% $ 500,000 $ 240,000 $ 500,000 $ 200,000 $ 100,000 35% $ 120,000 35% Your company has a required rate of return of 10% for all new investments and is subject to a tax rate of 35%. 1) Determine the annual after tax cash flow for each investment. In addition, determine the after-tax cash flow for the salvage value if you assume that the actual market value of Investment #1 at the end of ten years is $100,000 and the actual market value of Investment #2 at the end of twelve years is $40,000. 2) Prepare a schedule of expected cash flows for each investment. Note that all positive cash flows must be shown as positive numbers and all negative cash flows must be shown as negative numbers. 3) Calculate the Net Present Value for each investment using the NPV function in Excel. 4) Calculate the Internal Rate of Return for each investment using the IRR function in Excel. (Note your guess for the interest rate in the formula should be the required rate of return) 5) Recalculate the Net Present Value for INVESTMENT #1 ONLY but assume that the required/target rate of return is 6%, 12%, and 20%. You are the CFO of a business and have the opportunity to evaluate two different investment opportunities. Information related to these investments follows: Investment 1 Investment Cost Salvage Value Useful Life Required Rate of Return Sales Variable Costs Fixed Costs (excluding depreciation) Tax Rate $ 800,000 $ 80,000 10 years 10% Investment 2 $ 600,000 $ 60,000 12 years 10% $ 500,000 $ 240,000 $ 500,000 $ 200,000 $ 100,000 35% $ 120,000 35% Your company has a required rate of return of 10% for all new investments and is subject to a tax rate of 35%. 1) Determine the annual after tax cash flow for each investment. In addition, determine the after-tax cash flow for the salvage value if you assume that the actual market value of Investment #1 at the end of ten years is $100,000 and the actual market value of Investment #2 at the end of twelve years is $40,000. 2) Prepare a schedule of expected cash flows for each investment. Note that all positive cash flows must be shown as positive numbers and all negative cash flows must be shown as negative numbers. 3) Calculate the Net Present Value for each investment using the NPV function in Excel. 4) Calculate the Internal Rate of Return for each investment using the IRR function in Excel. (Note your guess for the interest rate in the formula should be the required rate of return) 5) Recalculate the Net Present Value for INVESTMENT #1 ONLY but assume that the required/target rate of return is 6%, 12%, and 20%. You are the CFO of a business and have the opportunity to evaluate two different investment opportunities. Information related to these investments follows: Investment 1 Investment Cost Salvage Value Useful Life Required Rate of Return Sales Variable Costs Fixed Costs (excluding depreciation) Tax Rate $ 800,000 $ 80,000 10 years 10% Investment 2 $ 600,000 $ 60,000 12 years 10% $ 500,000 $ 240,000 $ 500,000 $ 200,000 $ 100,000 35% $ 120,000 35% Your company has a required rate of return of 10% for all new investments and is subject to a tax rate of 35%. 1) Determine the annual after tax cash flow for each investment. In addition, determine the after-tax cash flow for the salvage value if you assume that the actual market value of Investment #1 at the end of ten years is $100,000 and the actual market value of Investment #2 at the end of twelve years is $40,000. 2) Prepare a schedule of expected cash flows for each investment. Note that all positive cash flows must be shown as positive numbers and all negative cash flows must be shown as negative numbers. 3) Calculate the Net Present Value for each investment using the NPV function in Excel. 4) Calculate the Internal Rate of Return for each investment using the IRR function in Excel. (Note your guess for the interest rate in the formula should be the required rate of return) 5) Recalculate the Net Present Value for INVESTMENT #1 ONLY but assume that the required/target rate of return is 6%, 12%, and 20%.
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
You are the CFO of a company called "Buy Low, Sell High Investments, LLC" The President has asked you to make a presentation to the Board of Directors as to whether or not your company should make a...
-
You are the CFO of a U.S. firm whose wholly owned subsidiary in Mexico manufactures component parts for your U.S. assembly operations. The subsidiary has been financed by bank borrowings in the...
-
You are the CFO of a U.S. firm whose wholly owned subsidiary in Mexico manufactures component parts for your U.S. assembly operations. The subsidiary has been financed by bank borrowings in the...
-
XY is a pharmaceutical company with the head-quarter in the United States. However, its cash flow depends only on sales in Japan. It receives a cash flow of Yen 20 billion with certainty in t=1. The...
-
Highway Construction Incorporated (HCI) bought a large piece of construction equipment at the beginning of 20X5. The construction equipment was a large piece of heavy equipment with an original cost...
-
Show how a 74HC541 (Figure 9-50) can be used in the circuit of Figure 9-84. Figure 9-84 Figure 9-50 +5 V 1 SW3 SW2 SW1 SWO 74HC125 CLOCK- (from Figure 9-47) 1 1 Data bus from Figure 9-47 DB 3 DB DB,...
-
With reference to the preceding exercise, change the equation obtained in part (a) to the form \(\widehat{y}=a \cdot e^{-c x}\), and use the result to rework part (b).
-
1. Assume Jennie Lin is a CPA. Evaluate her actions with respect to the rules of conduct of the AICPA. 2. Jennie believes that her actions were proper because taking the money from the church and...
-
A fund manager wants to hedge the exposure of her US equity portfolio using futures contracts on the S&P 500. Her portfolio has a value of 10 million USD and a beta of 1.4. The S&P 500 futures is...
-
The links of the chain are made steel that has a working stress of 300 MPa in tension. If the chain is to support the force P = 45 kN, determine the smallest safe diameter d of the links. P
-
An object is placed at (i) 10 cm, (ii) 5 cm in front of a concave mirror of radius of curvature 15 cm. Find the position, nature, and magnification of the image in each case.
-
How does a preference for liquidity influence an individual or organizations financial decisions?
-
A converging lens for which \(f=50 \mathrm{~mm}\) forms an image that is three times larger than the object. How far from the lens is the object?
-
What are some advantages and disadvantages of deferring salaries (both from the players and the teams perspectives)?
-
What mistake did the NBA make in its dealings with the owners of the Spirits of St. Louis?
-
What concerns should a sport organization contemplate when negotiating future payments from sponsorships or other long-term agreements?
-
The margin is the one required for APA formatted papers. O wide O moderate O narrow normal D
-
DC has unused FTC carryover from 2017 in the separate category for GC income as the result of income generated by a foreign branch. The income was foreign source general category income. In 2018 the...
-
Do you think the standard IMF policy prescriptions of tight monetary policy and reduced government spending are always appropriate for developing nations experiencing a currency crisis? How might the...
-
Read the Country Focus on India in this chapter and answer the following questions: a. What kind of economic system did India operate under during 1947 to 1990? What kind of system is it moving...
-
What are the economic and political arguments for regional economic integration? Given these arguments, why dont we see more substantial examples of integration in the world economy?
-
For the CPM Calculation Exercise found on the companion website, determine the ES, EF, LS, LF, FF, and TF for each activity. Identify the activities through which the critical path runs. How many...
-
Why is the bar chart not an adequate planning and scheduling tool?
-
What are impediments to planning, both at the beginning of a project and throughout the project?
Study smarter with the SolutionInn App