Question

Please answer in step-by-step detail. Thanks!

annual return on U.3 At the end of 2019, Uma Corporation is considering a major long-term project effort to remain competitive in its industry. The production and sales departmen determined the potential annual cash flow savings that could accrue to the firm if i soon. Specifically, they estimate that a mixed stream of future cash flow savings occur at the end of the years 2020 through 2025. The years 2026 through 2030 consecutive $90,0000 cash flow savings at the end of each year. The firm estimate its discount rate over the first 6 years will be 7%. The expected discount rate years 2026 through 2030 will be 11% in an ents have HEET EXERCISE will see s t at low savings of at least $860,000. The following cash flow savings data are supplied. to the finance department for analysis. The project managers will find the project acceptable if it results in present cash Year 2020 2021 2022 2023 2024 2025 2026 2027 2028 2029 2030 Cash flow savings $110,000 120,000 130,000 150,000 160,000 150,000 90,000 90,000 90,000 90,000 90,000 TO DO Create spreadsheets similar to Table 5.3, and then answer the following questions. a. Determine the value (at the end of 2019) of the future cash flow savings expected b. Based solely on the one criterion set by management, should the firm undertake c. What is the interest rate risk, and how might it influence the recommendation to be generated by this project. this specific project? Explain. made in part b: Explain.

0 0
Add a comment Improve this question Transcribed image text
Answer #1

1: We determine the present value of cash flows as CF/(1+r)^n, then add them up to arrive at the present value of the cash flows.

Value at the end of 2019= 820036.49 (As per spreadsheet below)

Year N Cash flows PV of cash flows
2020 1 110000 102803.74
2021 2 120000 104812.65
2022 3 130000 106118.72
2023 4 150000 114434.28
2024 5 160000 114077.79
2025 6 150000 99951.33
2026 7 90000 43349.26
2027 8 90000 39053.38
2028 9 90000 35183.23
2029 10 90000 31696.60
2030 11 90000 28555.50
Value at the end of 2019 820036.49

2: The project will not be accepted since its PV is lesser than $860,000

3: Interest rate risk is the risk that the interest rate may not be as estimated by the management. It may be greater than that in which case the present value will be even lower. If it is lower than that, the PV may be higher in which case the project may have a value of more than $860,000 and in that case it will be wrong to reject the project.

WORKINGS

AutoSave Book1 - Excel 《Product Activation Failed) Sign in File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do 수 Share Calibri General 田FF Conditional Fornat as Cell Insert Delete Fornat FormattingTable Styles- 、. Sort & Find & Editing Paste . 녀 . 의 _ . 로三들經垣臣 Merge & Center-5 . % , : Filter Select Clipboard Alignment Number Styles Cells B1 Cash flows 110000 120000 130000 150000 160000 150000 90000 PV of cash flows C2/1.07AB2 C3/1.07 B3 C4/1.07AB4 C5/1.07 B5 C6/1.07AB6 1 Year 2 2020 3 2021 4 2022 5 2023 6 2024 7 2025 8 2026 9 2027 10 2028 11 2029 12 2030 13 14 15 16 17 C8/1.11AB8 C9/1.11AB9 C10/1.11 B10 C11/1.11 B11 -C12/1.11 B12 90000 10 Value at the end of 2019 SUM(D2:D12) Sheet1 Ready + 100 C ENG 8:37 AM

Add a comment
Know the answer?
Add Answer to:
Please answer in step-by-step detail. Thanks! annual return on U.3 At the end of 2019, Uma...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • At the end of 2019, Uma Corporation is considering a major long-term project in an effort...

    At the end of 2019, Uma Corporation is considering a major long-term project in an effort to remain 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 2020 through 2025. The years 2026 through 2030 will see consecutive $90,0000 cash flow savings...

  • Please answer this fully. This is a major final project so it's crucial I get it...

    Please answer this fully. This is a major final project so it's crucial I get it right. Thank you so much! You are working in a strategic management role at Best Bean, Inc., a chain of coffee shops. Your team is considering expanding in 2020 by building one or more new retail outlets in the Detroit area. Four locations (A, B, C, and D) are being considered. Locations A, B, and Care ten year investments, with income projections shown in...

  • It is the end of 2020. You plan to complete a Ph.D. in 5 years. Your...

    It is the end of 2020. You plan to complete a Ph.D. in 5 years. Your favorite uncle has promised to help you with your school expenses by giving you the following amounts for Christmas: Year 2021 2022 2023 2024 2025 Cash flow 1,200 1,600 1,800 2,000 2,200 Your uncle is fairly wealthy and very reliable. You currently have $10,000 in a savings account paying an annual interest rate of 15%. ALL PARTS (1-7) TO BE COMPLETED. Part 1 Create...

  • The Minot Kit Aircraft Company of​ Minot, North​ Dakota, uses a plasma cutter to fabricate metal...

    The Minot Kit Aircraft Company of​ Minot, North​ Dakota, uses a plasma cutter to fabricate metal aircraft parts for its plane kits. The company currently is using a cutter that it purchased four years ago that has a book value of ​$90,000 and is being depreciated ​$22,500 per year over the next 4 years. If the old cutter were to be sold​ today, the company estimates that it would bring in an amount equal to the book value of the...

  • 4) (3 pts) Assume that Company D's Free Cash Flow from assets has been estimated to...

    4) (3 pts) Assume that Company D's Free Cash Flow from assets has been estimated to be $80 million in 2020 and $90 million in 2021. The free cash flow is expected to grow at a constant rate of 5% after 2021. a) If the appropriate discount rate for Company D's FCF model is 7.7%, what is the horizon value at the end of 2021 for Company D using the Free Cash Flow Model? 2019 2020 2021 FCF $80 m...

  • please do not round until the end answer only 7,8,9 please 12 XYZ Company is considering...

    please do not round until the end answer only 7,8,9 please 12 XYZ Company is considering whether a project requiring the purchase of new equipment is worth investing. The cost of a new machine is $340,000 including shipping and installation. The project will increase annual revenues by $400,000 and annual costs by $100,000. The machine will be depreciated via straight-line depreciation for three years to a salvage value of $40,000. If the firm does this project, $30,000 in net working...

  • Please answer both questions, I would appreciate it greatly! (: If you cannot see the picture, I...

    Please answer both questions, I would appreciate it greatly! (: If you cannot see the picture, I have transcribed below: 1. Consider the following project and its cash flow: Investment cost $10,000 Expected life 5 years Market (salvage) value* -$1,000 Annual receipts $8,000 Annual expense -$4,000 * A negative market value means that there is a net cost to dispose of an asset. a. Determine its PW and FW with MARR 15% per year. Is the project acceptable? b. What...

  • Please, help!! Traxo Manufacturing Ltd. shares are publicly traded on the Toronto Stock Exchange under the...

    Please, help!! Traxo Manufacturing Ltd. shares are publicly traded on the Toronto Stock Exchange under the ticker symbol TRX.TO. The shares currently trade at a price of $2.25 per share. Security analysts that follow the stock have estimated it's beta coefficient to be 0.9. Traxo paid a dividend on its common stock last year that totaled $0.08 per share. Dividends have been growing at a 3.25% compound rate for the past three years and the expectation is that this growth...

  • Question 1 Answer 1(a) & 1(d) Your company is considering a new 3-year project that requires...

    Question 1 Answer 1(a) & 1(d) Your company is considering a new 3-year project that requires an initial investment in equipment of $3 million. Prior to this, you had engaged a consultant to study the feasibility of the new project and after an extensive market survey, the consultant confirmed your belief that the project would be viable. Your company is charged $100,000 for the feasibility study. The equipment will be depreciated straight line to zero over the 3 years of...

  • LOL (the “Company”), an SEC registrant with a calendar year-end, is a manufacturer and distributor of sports equipment....

    LOL (the “Company”), an SEC registrant with a calendar year-end, is a manufacturer and distributor of sports equipment. The Company was created in 1989 and is headquartered in Southern California. The Company has manufacturing operations and numerous sales and administrative locations in the United States. LOL files a consolidated U.S. federal tax return. (This case will not consider the evaluation of the state jurisdictions; it will only consider the federal jurisdiction.) As LOL’s auditors, you are now performing the Company’s...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT