To construct: A spreadsheet to compute the payback period,
Payback Period:
It is ascertained when cost of project is divided by the annual cash flows of the respective project. The payback period is a method used in capital budgeting. It does not involve the
Internal Rate of Return (IRR):
IRR is also a technique of capital budgeting that includes the time value of money concept. The IRR of a project is shows as the profitability arises from the project. The IRR of a project is calculated with the help of NPV calculations.
Modified Internal Rate of Return(MIRR):
It is also a kind of technique used in capital budgeting while selecting a project. It is modified version of the IRR and commonly used in large scale business to purchase heavy investment.
Net Present Value (NPV):
NPV is a technique used in capital budgeting to see the project is profitable for the company or not. The selection is based on the result of NPV as if it is positive then it should be selected and in the case of negative NPV it should be rejected.
Want to see the full answer?
Check out a sample textbook solutionChapter 5 Solutions
Corporate Finance (The Mcgraw-hill/Irwin Series in Finance, Insurance, and Real Estate)
- seth bullock, the owner of bullock gold mining, is evaluating a new gold mine in south dakota. dan dority, the company's geologist, has just finished his analysis of the mine site. he has estimated that the mine would be productive for eight years, after which the gold would be completely mined. dan has taken an estimate of the gold deposits to alma garrett. the compnay's financial officer alma has been asked by seth to perform an analysis of the new mine and present her recommendation on wheter the company should open the new mine. year cashflow 0 -625,000,000 1 70,000,000 2 129,000,000 3 183.000.000 4 235,000,000 5 210,000,000 6 164,000,000 7 108,000,000 8 86,000,000 9 -90,000,000 alma has used the estimates provided by dan to determine the revenues that could be expected form the mine. she also has projected the expense of opening the mine and the annual operating expenses. if the company opens the mine, it…arrow_forwardDr. Ron Patterson, the owner of Chadron Gold Mining, is evaluating a new gold mine in Colorado. Dr. Tawny Tibbits, the company's geologist, has just finished her analysis of the mine site. She has estimated that the mine would be productive for eight years, after which the gold would be completely mined. Tawny has taken an estimate of the gold deposits to Dr. Pil Joon Kim, the company's financial officer. Pil Joon has been asked by Ron to perform an analysis of the new mine and present his recommendation on whether the company should open the new mine. Year Cash Flow 0 1 2 -$650,000,000 80,000,000 121,000,000 3 162,000,000 4 221,000,000 5 210,000,000 6 154,000,000 7 108,000,000 8 9 86,000,000 -72,000,000 Pil Joon has used the estimates provided by Tawny to determine the revenues that could be expected from the mine. He has also projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost $650 million today, and it will have a…arrow_forwardBULLOCK GOLD MININGSeth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company’s geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for eight years, after which the gold would be completely mined. Dan has taken an estimate of the gold deposits to Alma Garrett, the company’s financial officer. Alma has been asked by Seth to perform an analysis of the new mine and present her recommendation on whether the company should open the new mine. Alma has used the estimates provided by Dan to determine the revenues that could be expected from the mine. She has also projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost $750 million today, and it will have a cash outflow of $105 million nine years from today in costs associated with closing the mine and reclaiming the area surrounding it. The expected cash flows…arrow_forward
- I need this in Excel Worksheet to show formulas and calculations please. Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company’s geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for eight years, after which the gold would be completely mined. Dan has taken an estimate of the gold deposits to Alma Garrett, the company’s financial officer. Alma has been asked by Seth to perform an analysis of the new mine and present her recommendation on whether the company should open the new mine. Year Cash Flow0 −$625,000,0001 70,000,0002 129,000,0003 183,000,0004 235,000,0005 210,000,0006 164,000,0007 108,000,0008 86,000,0009 − 90,000,000 Alma has used the estimates provided by Dan to determine the revenues that could be expected from the mine. She also has projected the expense of opening the mine…arrow_forward3. Seth Bullock the owner of bullock Gold Mining, is evaluating a new gold mine in south Dakota. Dan Dority, the company's geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for three years, after which the gold would be completely mined. Dan has taken an estimate of the gold deposits to alma Garrett, the company's financial officer. Alma has been asked by Seth to perform an analysis of the new mine and present her recommendation on whether the company should open the new mine. Alma has used the estimates provided by Dan to determine the revenues that could be expected from the mine. She also has projected the expense of opening the mine with two different alternatives. A project cost 25000 is expects to generate cash flows are given as follows @12% for both the projects. Year 1 2 3 4 5 Alternative 1 13000 8000 6000 8000 7000 Alternative 28000 14000 5000 6500 4000 PV factor 0.893 0.792 0.7120.6360.567 Required: 1. Compute the…arrow_forwardBullock Gold Mining Seth Bullock, the owner of Bullock Gold Mining, is evaluating a new gold mine in South Dakota. Dan Dority, the company’s geologist, has just finished his analysis of the mine site. He has estimated that the mine would be productive for eight years, after which the gold would be completely mined. Dan has taken an estimate of the gold deposits to Alma Garrett, the company’s financial officer. Alma has been asked by Seth to perform an analysis of the new mine and present her recommendation on whether the company should open the new mine. Alma has used the estimates provided by Dan to determine the revenues that could be expected from the mine. She has also projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost $745 million today, and it will have a cash outflow of $55 million nine years from today in costs associated with closing the mine and reclaiming the area surrounding it. The expected cash flows…arrow_forward
- Rearden Metals is considering opening a strip mining operation to provide some of the raw materials needed in producing Rearden metal. The initial purchase of the land and the associated costs of opening up mining operations will cost $100 million today. The mine is expected to generate $16 million worth of ore per year for the next 12 years. At the end of the 12th year Rearden will need to spend $20 million to restore the land to its original pristine nature appearance. The number of potential IRRs that exist for Rearden's mining operation is equal to: O A. 2 OB. 1 O C. 12 O D. 0 Carrow_forwardRearden Metals is considering opening a strip mining operation to provide some of the raw materials needed in producing Rearden metal. The initial purchase of the land and the associated costs of opening up mining operations will cost $100 million today. The mine is expected to generate $16 million worth of ore per year for the next 12 years. At the end of the 12th year Rearden will need to spend $20 million to restore the land to its original pristine nature appearance.The payback period for Rearden's mining operation is closest to:arrow_forwardAfter discovering a new gold vein in the Colorado mountains, CTC Mining Corporation must decide whether to go ahead and develop the deposit. The most cost-effective method of mining gold is sulfuric acid extraction, a process that could result in environmental damage. Before proceeding with the extraction, CTC must spend 900,000 for new mining equipment and pay 165,000 for its installation. The mined gold will net the firm an estimated 350,000 each year for the 5-year life of the vein. CTCs cost of capital is 14%. For the purposes of this problem, assume that the cash inflows occur at the end of the year. a. What are the projects NPV and IRR? b. Should this project be undertaken if environmental impacts were not a consideration? c. How should environmental effects be considered when evaluating this or any other project? How might these concepts affect the decision in part b?arrow_forward
- A new diamond deposit has been found in northern Alberta. Your researchers have determined that it will cost $2.5 million to purchase the land and prepare it for mining. At the beginning of both the second and third years, another $1 million investment will be required to establish the mining operations. Starting at the end of the second year, the deposit is expected to earn net profits of $3 million, which will be sustained for three years before the deposit is depleted. If the cost of capital is 16%, should your company pursue this venture? Provide calculations to support your decision.arrow_forwardA mining company in South Africa has discovered a new gold vein in a mountain 150 kilometers north of Johannesburg. SA Mining Corporation will have to decide if they should set up a mine in the newly discovered location. They will be using the most cost-effective, but environmentally damaging method of gold mining sulfuric acid extraction. To go ahead SA Mining Corporation must spend $900,000 on new mining equipment and pay $165,000 for its installation. The goldmine will make an annual profit contribution of $350,000 each year for the next five years of the extraction. SA’s cost of capital is 14% and assumes that cash flows occur at the end of each year. What is the NPV, and IRR of the project? [Note: you are supposed to show every step of your calculation and interpret the result.] Critically discuss how environmental effects should be considered when evaluating these types of projects (impact investing), include in your discussion the challenges in quantifying these issues in…arrow_forwardCoyote Co. is building a waste landfill in the desert between Arizona and California. Coyote estimates that this landfill will be in operation for five years, will cost $250 million to build, and will generate $800 million in revenues during its useful life. Federal law requires that Coyote decommission and decontaminate the site at the end of its useful life. A team of engineers has studied the decontamination procedure and has estimated that Coyote will have to spend $15 million on the decommissioning process when the landfill is shut down in five years. Coyote’s credit-adjusted rate of interest is 10%. Use tables (PV of 1, PVAD of 1, and PVOA of 1) (Use the appropriate factor(s) from the tables provided.) Required: 1-a. Prepare the entry required for the recognition of any ARO asset and liability. 1-b. Prepare an amortization table.arrow_forward
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning