1
.docx
keyboard_arrow_up
School
Northern Arizona University *
*We aren’t endorsed by this school
Course
521
Subject
Finance
Date
Apr 3, 2024
Type
docx
Pages
1
Uploaded by DoctorOtterPerson4041
Read the following scenarios and calculate your answers using the ROI Cost of Capital Excel spreadsheet.
1.
In 20XX, Olentangy Health Care’s (OHC) cost of capital was 6%. Its investments are $80,000 on a historical cost valuation basis, $100,000 on a replacement cost basis, and $110,000 on a current market value basis. If you were on OHC’s board, what minimum level of annual cash flow would you require in order to continue operations and proceed with planned significant new investments?
Answer
: After plugging in the appropriate numbers, I noticed that the break-even cash flow for OHC would be $6,600. That means that OHC would need to, at minimum
, bring in this amount to continue operations. When plugging this number in, I noticed that $6,600 would be the minimum required amount to invest as well as continue operations. If I was on OHC’s board, we would need (at the very least) a $6,600 cash flow if we wanted to proceed with operations as well as the
planned significant investments. 2.
A hospital’s cost of capital is 10%. Its cash flow return on investment (ROI) based on replacement
cost is 8%. Given this information, the hospital should not receive significant new investment. Answer True
or False then explain your decision. Answer
: True. The Cost of Capital is also known as the “hurdle rate.” This is the calculation or percentage that shows the minimum necessary return to accept or justify undertaking a capital project. In this case, the hospital’s cost of capital is 10%. That means that the hospital must at least have 10% return on investment for this to be a smart and valuable capital investment decision. If the ROI to implement a new investment decision is 8% then it is falling 2% under the minimum threshold and is not a valuable new investment decision. 3.
Beverly Enterprises owns a nursing home that is currently earning $2 million in cash flow on an annual basis, but this amount is expected to drop in the future. The nursing home has a book value of $20 million, a replacement cost of $40 million, and a current sale value of $10 million. If Beverly Enterprises has a cost of capital equal to 15%, at what value of annual cash flow would Beverly Enterprises be likely to be sell or close the nursing home?
Helpful hint:(fill out the spreadsheet for #3 by entering the current cash flow of $2,000,000 as well
as the other information given. Then at the bottom of the sheet it will give you the answer that represents the cash flow at which you will be at the minimum cash required, the formula is set for one dollar less, at that point you would consider selling or closing the business. (answer is below the breakeven by $1) Answe
r: After plugging in the appropriate numbers, it is noted that our break-even amount is $1,500,000 and therefore if we make $1,499,999 or less as annual cash flow, we will need to sell or close
the nursing home.
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Please see attached:
arrow_forward
Profitability index. Given the discount rate and the future cash flow of each project listed in the following table, .
use the Pl to determine which projects the company should accept.
What is the Pl of project A?
i Data Table
(Round to two decimal places.)
(Click on the following icon o in order to copy its contents into a spreadsheet.)
Cash Flow
Project A
-%241,900,000
$150,000
$350,000
Project B
Year 0
$2,300,000
$1,150,000
$950 000
$750,000
$550,000
Year 1
Year 2
Year 3
$550,000
Year 4
$750,000
$950,000
4%
Year 5
$350.000
Discount rate
18%
Print
Done
arrow_forward
Complete the table and show the solution. Then, compute for the payback period.
arrow_forward
Please help me.
Thankyou.
arrow_forward
The CEO asked you to take charge of the following projects for the company. However, he told you that because of the limited funds available, you have to pursue the
projects one at a time. Using the profitability index, decide on which of the projects you are going to accomplish first, second, and third.
Project 1 requires an initial investment of P500,000, will provide future cash inflow of P1,300,000, and present value of the future cash inflow of P850,000.
Project 2 requires an initial investment of P1,000,000, will provide future cash flow of P3,000,000, and present value of the future cash flow is P1,550,000
Project 3 requires an initial investment of P1,500,000, will provide future cash flow of P5,000,000 and the present value of the future cash flow is P2,835,000.
arrow_forward
The company is in search of resources for a new investment of TL 3,000,000. As a financial manager,
a) Find the current weighted average cost of capital according to the resource distribution below.
b) What kind of financing strategy would you suggest for the investment project in question?
arrow_forward
Below are four cases that you will have to solve
using Excel spreadsheets.
1st case
The company COMERCIAL SA has two investment alternatives that present the following
information:
PROJECT
A
B
It is requested
Initial
investment.
$25,000
$22,000
Cash flows
year 1
1. Determine the internal rate of return.
2. Determine the present value.
$7,000
$12,000
The discount rate for the project will be 10% and the MARR will be 20%.
3. Determine the recovery period.
4. Define which is the most viable project.
Year 2 cash
flows
$15,000
$8,000
Year 3 cash
flows
$18,000
$12,000
arrow_forward
Imagineering, Inc., is considering an investment in CADCAM compatible design software with the cash flow profile shown in the table below. Imagineering’s MARR is 18%/year. a. What is the present worth of this investment? b. What is the decision rule for judging the attractiveness of investments based on present worth? c. Should Imagineering invest?
arrow_forward
The company is in search of resources for a new investment of TL 3,000,000. As a financial manager,a) Find the current weighted average cost of capital according to the resource distribution below.b) Discuss, what kind of financing strategy would you propose for the investment project in question.
arrow_forward
Financial Manager of Timmy Company is considering two projects (project A and project H), which have cash flows as follows:
Year
Cash Flow of Project A (in $)
Cash Flow of Project H (in $)
0
-100
-100
1
10
70
2
60
50
3
80
20
Timmy Company’s cost of capital is 10 percent.
Calculate payback, NPV, IRR, and MIRR for both projects.
(Please have a step by step format to your answer with explainations. Thanks (=)
arrow_forward
Please help me
arrow_forward
Dogwood Company is considering a capital investment in machinery:
(Click the icon to view the data.)
8.
Calculate the payback.
9.
Calculate the ARR. Round the percentage to two decimal places.
10. Based on your answers to the above questions, should Dogwood invest in the machinery?
8. Calculate the payback.
Amount invested
Expected annual net cash inflow
Payback
1,500,000
24
500,000
3
years
9. Calculate the ARR. Round the percentage to two decimal places.
Average annual operating income
Average amount invested
ARR
Data Table
Initial investment
$
1,500,000
Residual value
350,000
Expected annual net cash inflows
500,000
Expected useful life
4 years
Required rate of return
15%
arrow_forward
Please see attached:
arrow_forward
Please use the images attached to answer the following:Determine the weighted average cost of capital (WACC) for VigourPharmaceuticals.
arrow_forward
Please help me to solve this problem
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Related Questions
- Please see attached:arrow_forwardProfitability index. Given the discount rate and the future cash flow of each project listed in the following table, . use the Pl to determine which projects the company should accept. What is the Pl of project A? i Data Table (Round to two decimal places.) (Click on the following icon o in order to copy its contents into a spreadsheet.) Cash Flow Project A -%241,900,000 $150,000 $350,000 Project B Year 0 $2,300,000 $1,150,000 $950 000 $750,000 $550,000 Year 1 Year 2 Year 3 $550,000 Year 4 $750,000 $950,000 4% Year 5 $350.000 Discount rate 18% Print Donearrow_forwardComplete the table and show the solution. Then, compute for the payback period.arrow_forward
- Please help me. Thankyou.arrow_forwardThe CEO asked you to take charge of the following projects for the company. However, he told you that because of the limited funds available, you have to pursue the projects one at a time. Using the profitability index, decide on which of the projects you are going to accomplish first, second, and third. Project 1 requires an initial investment of P500,000, will provide future cash inflow of P1,300,000, and present value of the future cash inflow of P850,000. Project 2 requires an initial investment of P1,000,000, will provide future cash flow of P3,000,000, and present value of the future cash flow is P1,550,000 Project 3 requires an initial investment of P1,500,000, will provide future cash flow of P5,000,000 and the present value of the future cash flow is P2,835,000.arrow_forwardThe company is in search of resources for a new investment of TL 3,000,000. As a financial manager, a) Find the current weighted average cost of capital according to the resource distribution below. b) What kind of financing strategy would you suggest for the investment project in question?arrow_forward
- Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000arrow_forwardImagineering, Inc., is considering an investment in CADCAM compatible design software with the cash flow profile shown in the table below. Imagineering’s MARR is 18%/year. a. What is the present worth of this investment? b. What is the decision rule for judging the attractiveness of investments based on present worth? c. Should Imagineering invest?arrow_forwardThe company is in search of resources for a new investment of TL 3,000,000. As a financial manager,a) Find the current weighted average cost of capital according to the resource distribution below.b) Discuss, what kind of financing strategy would you propose for the investment project in question.arrow_forward
- Financial Manager of Timmy Company is considering two projects (project A and project H), which have cash flows as follows: Year Cash Flow of Project A (in $) Cash Flow of Project H (in $) 0 -100 -100 1 10 70 2 60 50 3 80 20 Timmy Company’s cost of capital is 10 percent. Calculate payback, NPV, IRR, and MIRR for both projects. (Please have a step by step format to your answer with explainations. Thanks (=)arrow_forwardPlease help mearrow_forwardDogwood Company is considering a capital investment in machinery: (Click the icon to view the data.) 8. Calculate the payback. 9. Calculate the ARR. Round the percentage to two decimal places. 10. Based on your answers to the above questions, should Dogwood invest in the machinery? 8. Calculate the payback. Amount invested Expected annual net cash inflow Payback 1,500,000 24 500,000 3 years 9. Calculate the ARR. Round the percentage to two decimal places. Average annual operating income Average amount invested ARR Data Table Initial investment $ 1,500,000 Residual value 350,000 Expected annual net cash inflows 500,000 Expected useful life 4 years Required rate of return 15%arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College