subject
Business, 23.04.2021 15:50 chrisspa13

At the end of 2019, Uma Corporation is considering a major long-term project in an effort competitive in its industry. The production and sales departments have determined the potential annual cash flow savings that could accrue to the firm if it acts soon. Specifically, they estimate that a mixed stream of future cash flow savings will occur at the end of the years 2021 through 2026. The years 2027 through 2031 will see consecutive and equal cash flow savings at the end of each year. The firm estimates that its discount rate over the first 6 years will be 7%. The expected discount rate over the years 2027 through 2031 will be 11%. The project managers will find the project acceptable if it results in present cash flow savings of at least $860,000. The following cash flow savings data are supplied to the finance department for analysis. a. Determine the value (at the beginning of 2019) of the future cash flow savings expected to be generated by this project.
b. Based solely on the one criterion set by management, should the firm undertake this specific project? Explain.
c. What is the "interest rate risk," and how might it influence the recommendation made in part b? Explain.
Discount rate for years 2020 - 2025 7%
Discount rate for years 2026 - 2030 11%
Cash Present
Year Year (n) Flow Value
2020 1 $110,000
2021 2 120,000
2022 3 130,000
2023 4 150,000
2024 5 160,000
2025 6 150,000
2026 7 90,000
2027 8 90,000
2028 9 90,000
2029 10 90,000
2030 11 90,000
Could you please fill the present value for each year in excel and showing me the formula for each year?
The concept of interest-rate risk states that changes in the interest rates may adversely affect the value of an investor's securities portfolio. While this is not a securities problem, the relationship between the change in rates and the subsequent change in the value of an asset hold true. If the the interest rates were to rise just 1%, the present value of the expected savings would fall below the required $860,000 limit set by mangement.

ansver
Answers: 2

Another question on Business

question
Business, 22.06.2019 11:00
The following transactions occurred during july: received $1,000 cash for services provided to a customer during july. received $4,000 cash investment from bob johnson, the owner of the business received $850 from a customer in partial payment of his account receivable which arose from sales in june. provided services to a customer on credit, $475. borrowed $7,000 from the bank by signing a promissory note. received $1,350 cash from a customer for services to be rendered next year. what was the amount of revenue for july?
Answers: 1
question
Business, 23.06.2019 14:30
Problem 1. the following balance sheet contains errors. lopez services,inc. balance sheet for the year ended december 31, 20-- assets liabilities current assets: current liabilities: cash $ 6,170 accounts receivable $ 9,000 accounts payable 8,500 accum. depr- building 13,525 supplies 1,590 accum. depr- equipment 6,340 prepaid insurance 345 net income 12,500 land 25,000 total current assets $ 42,105 total liabilities $ 40,865 stockholders equity property, plant, and equipment: wages payable $ 500 building $ 45,500 retained earnings 10,000 equipment 28,250 total stockholders' equity $ 64,490 total property, plant, and equipment 73,750 total assets $115,855 total liabilities and stockholders' equity $115,855 (a) list the errors in the balance sheet above and (b) prepare a corrected balance sheet using ms excel
Answers: 3
question
Business, 23.06.2019 23:30
Successful firms focus their efforts on satisfying customer needs that match their core competencies. select one: a. true b. false
Answers: 1
question
Business, 24.06.2019 01:00
The is created by a number of institutions and arrangements that allow the suppliers and demanders of longminus−term funds to make transactions.
Answers: 3
You know the right answer?
At the end of 2019, Uma Corporation is considering a major long-term project in an effort competitiv...
Questions
question
Mathematics, 27.09.2019 00:00