Question

In: Finance

The Concord Silver Company ("Concord") is a silver mining company engaged in the exploration, development and...

The Concord Silver Company ("Concord") is a silver mining company engaged in the exploration, development and production of silver mining throughout Canada, Mexico and South America. It is one of the largest silver producers in the world. The company has great potential as it seeks to expand production at several new mining sites around the world.

Concord has hired SRK Consulting ("SRK"), a major geology firm, to analyze the silver production value from one of its new mines. SRK has completed its analysis and determined that the new mine would be productive for eight years after which the silver would be completely mined.

SRK has provided Concord with its financial analysis on the new mine. Specifically, SRK has projected that it would cost $850 million to open the mine and it would cost $75 million nine years from today to properly close the mine and reclaim the area surrounding it. Years one through eight would generate positive cash flows.

SRK has prepared Table 1 which shows the projected cash flows from the mine for each year.

TABLE 1

YEAR	CASH FLOWS
0	$-$850,000,000
1	170,000,000
2	190,000,000
3	205,000,000
4	265,000,000
5	235,000,000
6	170,000,000
7	160,000,000
8	105,000,000
9	-75,000,000

Year 0 represents the year that the mine will open and the costs to open the mine. Year 9 represents the year when the mine will close and the costs incurred to shutter the mine and reclaim the surrounding area.

Concord has asked you to assist them in analyzing this investment opportunity. Concord has informed you that they have a 12% required rate of return on all of its silver mines.

INSTRUCTIONS:

Answer both questions below. The assignment may be done in excel or by hand. Students may use HP12c Platinum Financial calculator to calculate the answers. Numerical answers should be to the nearest hundredths of one percent (ex: 8.13 or 3.56%) Do not round your answers to a whole number.

QUESTIONS:

1. Calculate the following. If possible, show the keystrokes for the HP12c Platinum Financial calculator or formulas applied on Excel.

a. Payback period

b. Net present value

c. Internal rate of return

d. Profitability index

2. Based on your analysis, should Concord open the mine? Answer "Yes" or "No" and provide an explanation that justifies your answer (no more than 1 paragraph).

Expert Solution

jeff jeffy answered 1 year ago

Suppose a silver miner finds a silver nugget and sells the nugget to a mining company for $200.

Suppose a silver miner finds a silver nugget and sells the nugget to a mining company for $200. The mining company melts down the silver, purifies it, and sells it to a jewelry maker for $800. The jewelry maker fashions the silver into a necklace that it sells to a department store for $1,000. Finally, the department store sells the necklace to a customer for $1,500. The value added by the silver miner is $ . The value added by...

Boondock Silver Mining Beth Boondock, owner of Boondock Silver Mining, is reviewing the details of a...

Boondock Silver Mining Beth Boondock, owner of Boondock Silver Mining, is reviewing the details of a new silver mine in South Dakota. According to the company's geologist, Dory Donovan, a detailed analysis of the mine suggests it would be productive for eight years. After that amount of time, all of the silver ore would be completely mined. Dory sent an estimate of the silver deposits to Gina Albert, the company's chief financial officer. Beth has contacted Gina to request a...

Scenario 1 Jupiter Mining Ore Limited is a major mining and exploration firm with operations in...

Scenario 1 Jupiter Mining Ore Limited is a major mining and exploration firm with operations in multiple galaxies. The company is looking to further expand its operations those solely within its core operations. The company’s total assets exceed $100 billion, liabilities of $45 billion, and annual sales close to $200 billion. The preferred auditor is Bad Eyesight Auditors. Required: Consider the following scenarios independently to determine the type of risk, level of risk, and extent of audit work that may...

Scenario 3 Jupiter Mining Ore Limited is a major mining and exploration firm with operations in...

Scenario 3 Jupiter Mining Ore Limited is a major mining and exploration firm with operations in multiple galaxies. The company is looking to further expand its operations those solely within its core operations. The company’s total assets exceed $100 billion, liabilities of $45 billion, and annual sales close to $200 billion. The preferred auditor is Bad Eyesight Auditors. Required: Consider the following scenarios independently to determine the type of risk, level of risk, and extent of audit work that may...

Perth Mining Company operates two mines for the purpose of extracting gold and silver. The Saddle...

Perth Mining Company operates two mines for the purpose of extracting gold and silver. The Saddle Mine costs $15,000/day to operate, and it yields 65 oz of gold and 2500 oz of silver each day. The Horseshoe Mine costs $16,000/day to operate, and it yields 70 oz of gold and 900 oz of silver each day. Company management has set a target of at least 485 oz of gold and 7,900 oz of silver. How many days should each mine...

Payback period and NPV calculations) Plato Energy is an oil and gas exploration and development company...

Payback period and NPV calculations) Plato Energy is an oil and gas exploration and development company located in Farmington, New Mexico. The company drills shallow wells in hopes of finding significant oil and gas deposits. The firm is considering two different drilling opportunities that have very different production potentials. The first is in the Barnett Shale region of central Texas and the other is in the Gulf Coast. The Barnett Shale project requires a much larger initial investment but provides...

9.7. You are auditing a company engaged in the development and sale of games software over...

9.7. You are auditing a company engaged in the development and sale of games software over the internet. Software is high quality and therefore we point our attention to controls over the sales of their products. The companies systems are fully integrated and sales automatically update the corresponding bank and trade receivable records (depending on payment type) and quantity inventory records. Your firm asks audit staff to classify control risk as low, medium or high. Initial discussions with management have...

HRE Mining Limited’s (HRE) is considering a major gold exploration project in South Sudan. Costs of...

HRE Mining Limited’s (HRE) is considering a major gold exploration project in South Sudan. Costs of financing have been declining recently causing the finance department to consider sourcing capital through debt and equity issues. The company’s bonds will mature in six years with a total face value of $100 million, paying a half yearly coupon rate of 10% per annum. The yield on the bonds is 15% per annum. The market value for the company’s preference share is $4.75 per...

Cutting Edge Incorporated is a company engaged in the development of computer-aided design (CAD) software packages....

Cutting Edge Incorporated is a company engaged in the development of computer-aided design (CAD) software packages. The management of Cutting Edge wants to develop a project tracking system to accumulate and report data on current projects, employees and departments. They have given you the following attributes they store on an excel spreadsheet. A project can have several employees assigned to it. An employee belongs to only one department. Make any necessary assumptions and normalize to 3NF. (ProjectNumber, ProjectName, StartDate, ProjectStatus,...

Condensed financial data of Concord Company for 2020 and 2019 are presented below. CONCORD COMPANY COMPARATIVE...

Condensed financial data of Concord Company for 2020 and 2019 are presented below. CONCORD COMPANY COMPARATIVE BALANCE SHEET AS OF DECEMBER 31, 2020 AND 2019 2020 2019 Cash $1,800 $1,130 Receivables 1,770 1,320 Inventory 1,560 1,890 Plant assets 1,900 1,700 Accumulated depreciation (1,220 ) (1,180 ) Long-term investments (held-to-maturity) 1,300 1,430 $7,110 $6,290 Accounts payable $1,220 $890 Accrued liabilities 190 250 Bonds payable 1,410 1,520 Common stock 1,870 1,730 Retained earnings 2,420 1,900 $7,110 $6,290 ONCORD COMPANY INCOME STATEMENT FOR...