Question

In: Finance

XYZ Company has two good businesses. Each has an initial investment of $ 25,000 with each...

XYZ Company has two good businesses. Each has an initial investment of $ 25,000 with each cash flow as follows:

Year Business 1 Cash Flow Business 2 Cash Flow
1 7,500 7,500
2 7,000 7,500
3 6,000 7,500
4 5,000 7,500
5 3,500 7,500

If the cost of capital is 12.5%, calculate:

A. Payback Period and NPV

B. In your opinion, which business is better chosen? Business 1 and Business 2? And Why?

Solutions

Expert Solution

A.Business 1

Payback period= full years until recovery + unrecovered cost at the start of the year/cash flow during the year

                             = 3 years + ($25,000 - $20,500)/ $5,000

                             = 3 years + $4,500/ $5,000

                             = 3 years + 0.90

                             = 3.90 years.

Net present value is solved here using a financial calculator. The steps to solve on the financial calculator:

  • Press the CF button.
  • CF0= -$1,000,000. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for all the years should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow, press the NPV button and enter cost of capital of 12.5%.
  • Press the down arrow and CPT buttons to get the net present value.

The net present value is $3,524.75.

Business 2

Payback period= full years until recovery + unrecovered cost at the start of the year/cash flow during the year

                             = 3 years + ($25,000 - $22,500)/ $7,500

                             = 3 years + $2,500/ $7,500

                             = 3 years + 0.33

                             = 3.33 years.

Net present value is solved here using a financial calculator. The steps to solve on the financial calculator:

  • Press the CF button.
  • CF0= -$1,000,000. It is entered with a negative sign since it is a cash outflow.
  • Cash flow for all the years should be entered.
  • Press Enter and down arrow after inputting each cash flow.
  • After entering the last cash flow, press the NPV button and enter cost of capital of 12.5%.
  • Press the down arrow and CPT buttons to get the net present value.

The net present value is $1,704.26.

B.According to me, Business 1 is better chosen since it has the highest net present value.

In case of any query, kindly comment on the solution.


Related Solutions

XYZ Company has two good businesses. Each has an initial investment of $ 25,000 with each...
XYZ Company has two good businesses. Each has an initial investment of $ 25,000 with each cash flow as follows: Year Business 1 Cash Flow Business 2 Cash Flow 1                                      7,500                                       7,500 2                                      7,000                                       7,500 3                                      6,000                                       7,500 4                                      5,000                                       7,500 5                                      3,500                                       7,500 If the cost of capital is 12.5%, calculate: A. Payback Period and NPV B. In your opinion, which business is better chosen? Business 1 and Business...
XYZ Company plans to develop stores in UAE. Each new store will require an initial investment...
XYZ Company plans to develop stores in UAE. Each new store will require an initial investment of $270,000 and a monthly operating cost of $25.000. Each will 578.500 h value after 5 years. The company also estimates that a new store will bring in revenue of $40,000 each month. Using the annual worth w method in the way investment if the company's MARR is 8% per year, compounded monthly. AW = 12,586 + investment should be rejected. AW = $9,586...
XYZ Company will invest with an initial investment of $ 1 million. The assumption of a...
XYZ Company will invest with an initial investment of $ 1 million. The assumption of a market interest rate of 5% and cash flow for 5 years is expected as in the table below: year Cash Flow 1 425.000 2 384.000 3 321.500 4 282.500 5 200.000 Calculate the payback period and Net Present Value (NPV)
Company XYZ is considering project A. Project A requires an initial investment of $75,000.
Company XYZ is considering project A. Project A requires an initial investment of $75,000. It generates $35,000 each year for the coming 3 years. What is the discounted payback period for this project if the proper discount rate is 18%?
XYZ Investment company invests clients’ money across 200 different investment portfolios, each of which has been...
XYZ Investment company invests clients’ money across 200 different investment portfolios, each of which has been structured and managed by a specialist portfolio manager. Mr Jack Nelsen, the Director of XYZ Investment suspects that a significant difference exists between the returns on portfolios managed by male portfolio managers and those managed by female portfolio managers. Mr Jack Nelsen decided to conduct an empirical study to determine whether the returns on portfolios differ significantly according to the gender on the portfolio...
A farmer estimates that a 50 acre peach orchard will require an initial investment of $25,000...
A farmer estimates that a 50 acre peach orchard will require an initial investment of $25,000 for soil preparation and tree purchase and planting costs. Assume the farmer already owns the land that the orchard will be planted on. After planting, cash outflows are expected in years 1-3 as the young trees are established and produce no harvestable crops. Assume outflows of $10,000, $5000, and $5000 in years 1 through 3, respectively. In years 4 and 5 production will occur...
A farmer estimates that a 50 acre peach orchard will require an initial investment of $25,000...
A farmer estimates that a 50 acre peach orchard will require an initial investment of $25,000 for soil preparation and tree purchase and planting costs. Assume the farmer already owns the land that the orchard will be planted on. After planting, cash outflows are expected in years 1-3 as the young trees are established and produce no harvestable crops. Assume outflows of $10,000, $5000, and $5000 in years 1 through 3, respectively. In years 4 and 5 production will occur...
A company has identified the following investments as looking promising. Each requires an initial investment of $1.2 million. Which is the best investment?
  A company has identified the following investments as looking promising. Each requires an initial investment of $1.2 million. Which is the best investment? A. a perpetuity that generates a cash flow at the end of year 1 of $100,000, has a growth rate of 1.25%, and a cost of capital of 10.7% B. a perpetuity that generates a cash flow at the end of year 1 of $800,000, has a growth rate of 2.25%, and a cost of capital...
A four-year project requires an initial investment of $165,000 in fixed assets and $25,000 in net...
A four-year project requires an initial investment of $165,000 in fixed assets and $25,000 in net working capital. The project has annual year-end costs of $14,501 after taxes. The fixed assets belong in a 20% CCA class and will have no salvage value. Any investment in working capital is returned at the end. What is the project's equivalent annual cost if the required return is 14% and the firm's tax rate is 34%
The XYZ Company purchased a specialized machine three years ago for $25,000. This machine is not...
The XYZ Company purchased a specialized machine three years ago for $25,000. This machine is not readily resalable and thus assumed to have a salvage value of $0. Operating costs are expected to be $10,000 next year and to increase by $800 per year thereafter (the ‘G’ term). The company has an opportunity to replace this machine with another specialized one for a cost of $12,000. This machine also has no salvage value, a useful life of 10 years, and...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT