Bullock 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.
Year
Cash Flow
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 from the mine. She also has projected the expense of opening the mine and the annual operating expenses. If the company opens the mine, it will cost $625 million today, and it will have a cash outflow of $90 million nine years from today in costs associated with closing the mine and reclaiming the area surrounding it. The expected cash flows each year from the mine are shown in the nearby table. Bullock Gold Mining has a 12 percent required return on all of its gold mines.
QUESTIONS
Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return, and net present value of the proposed mine.
Based on your analysis, should the company open the mine?
Bonus question: Most spreadsheets do not have a built-in formula to calculate the payback period. Write a VBA script that calculates the payback period for a project.[supanova_question]
regarding a Salvation theology from one of the Apostle Paul’s Epistle
A- Required Cover Page (does not count these words)B- Required – The select Salvation message (5-8 pages of content)C- Required – Work Cited Page: (does not count these words) Paper requirements:a. The term paper must be typedb. A minimum of 8 pagesc. Using 12 point font,a. 1” margins all around,b. Double-spaced.d. A minimum of required sources must be used. (any direct quotes more than 5 lines should be single spaced-indented)Use (3) three different printed Bible version andUse (2) two books (you can use the class textbook as a source)Use (2) two internet research sourceUse (1) a Bible dictionary (BOOK FORM)?e. Any additional 2 resources as you may need- Encyclopedia ?- Bible map?- Concordance ?- Magazine article ?- Bible Atlas?- Internet source (web site)? You will prepare:B-Required – The selected epistle of your choice must be typed with a minimum of page 1000 words?a. Describe “only one” SALVATION specific doctrine1. You will first describe:a. The audienceb. The problem that requires the Apostle’s need to address the question.b. Describe how Paul gives a solution1. What is the solution2. How does the Apostle instruct the early church to handle the issue. c. Your conclusion:1. You will compare the problem and solution as it would be handled by your pastor and/or church elders (give specific examples-no real names). C- Required Work Cited Page: (do not count these words)Consult other resources;1. Referral of (3) three different printed Bible version:a. (use three different versions of the Bible (when quotes use various Bibles always use “quotes marks”)2. Use (2) two books you used3. Use (2) two internet research4. Use (1) a Bible dictionarySample Book Choice: ?The Call to Holiness (Thessalonians 4:1-2) ?4:1 finally then, brothers and sisters, we ask you and urge you in?The Lord Jesus, that as you received instruction from us about how?You must live and please God (as you are in fact living) that you doso more and more. 4:2 For you know what commands we gave youthrough the Lord Jesus.[supanova_question]
regarding a Salvation theology from one of the Apostle Paul’s Epistle
A- Required Cover Page (does not count these words)B- Required – The select Salvation message (5-8 pages of content)C- Required – Work Cited Page: (does not count these words) Paper requirements:a. The term paper must be typedb. A minimum of 8 pagesc. Using 12 point font,a. 1” margins all around,b. Double-spaced.d. A minimum of required sources must be used. (any direct quotes more than 5 lines should be single spaced-indented)Use (3) three different printed Bible version andUse (2) two books (you can use the class textbook as a source)Use (2) two internet research sourceUse (1) a Bible dictionary (BOOK FORM)?e. Any additional 2 resources as you may need- Encyclopedia ?- Bible map?- Concordance ?- Magazine article ?- Bible Atlas?- Internet source (web site)? You will prepare:B-Required – The selected epistle of your choice must be typed with a minimum of page 1000 words?a. Describe “only one” SALVATION specific doctrine1. You will first describe:a. The audienceb. The problem that requires the Apostle’s need to address the question.b. Describe how Paul gives a solution1. What is the solution2. How does the Apostle instruct the early church to handle the issue. c. Your conclusion:1. You will compare the problem and solution as it would be handled by your pastor and/or church elders (give specific examples-no real names). C- Required Work Cited Page: (do not count these words)Consult other resources;1. Referral of (3) three different printed Bible version:a. (use three different versions of the Bible (when quotes use various Bibles always use “quotes marks”)2. Use (2) two books you used3. Use (2) two internet research4. Use (1) a Bible dictionarySample Book Choice: ?The Call to Holiness (Thessalonians 4:1-2) ?4:1 finally then, brothers and sisters, we ask you and urge you in?The Lord Jesus, that as you received instruction from us about how?You must live and please God (as you are in fact living) that you doso more and more. 4:2 For you know what commands we gave youthrough the Lord Jesus.[supanova_question]
regarding a Salvation theology from one of the Apostle Paul’s Epistle
Writing Assignment Help A- Required Cover Page (does not count these words)B- Required – The select Salvation message (5-8 pages of content)C- Required – Work Cited Page: (does not count these words) Paper requirements:a. The term paper must be typedb. A minimum of 8 pagesc. Using 12 point font,a. 1” margins all around,b. Double-spaced.d. A minimum of required sources must be used. (any direct quotes more than 5 lines should be single spaced-indented)Use (3) three different printed Bible version andUse (2) two books (you can use the class textbook as a source)Use (2) two internet research sourceUse (1) a Bible dictionary (BOOK FORM)?e. Any additional 2 resources as you may need- Encyclopedia ?- Bible map?- Concordance ?- Magazine article ?- Bible Atlas?- Internet source (web site)? You will prepare:B-Required – The selected epistle of your choice must be typed with a minimum of page 1000 words?a. Describe “only one” SALVATION specific doctrine1. You will first describe:a. The audienceb. The problem that requires the Apostle’s need to address the question.b. Describe how Paul gives a solution1. What is the solution2. How does the Apostle instruct the early church to handle the issue. c. Your conclusion:1. You will compare the problem and solution as it would be handled by your pastor and/or church elders (give specific examples-no real names). C- Required Work Cited Page: (do not count these words)Consult other resources;1. Referral of (3) three different printed Bible version:a. (use three different versions of the Bible (when quotes use various Bibles always use “quotes marks”)2. Use (2) two books you used3. Use (2) two internet research4. Use (1) a Bible dictionarySample Book Choice: ?The Call to Holiness (Thessalonians 4:1-2) ?4:1 finally then, brothers and sisters, we ask you and urge you in?The Lord Jesus, that as you received instruction from us about how?You must live and please God (as you are in fact living) that you doso more and more. 4:2 For you know what commands we gave youthrough the Lord Jesus. [supanova_question]
regarding a Salvation theology from one of the Apostle Paul’s Epistle
A- Required Cover Page (does not count these words)B- Required – The select Salvation message (5-8 pages of content)C- Required – Work Cited Page: (does not count these words) Paper requirements:a. The term paper must be typedb. A minimum of 8 pagesc. Using 12 point font,a. 1” margins all around,b. Double-spaced.d. A minimum of required sources must be used. (any direct quotes more than 5 lines should be single spaced-indented)Use (3) three different printed Bible version andUse (2) two books (you can use the class textbook as a source)Use (2) two internet research sourceUse (1) a Bible dictionary (BOOK FORM)?e. Any additional 2 resources as you may need- Encyclopedia ?- Bible map?- Concordance ?- Magazine article ?- Bible Atlas?- Internet source (web site)? You will prepare:B-Required – The selected epistle of your choice must be typed with a minimum of page 1000 words?a. Describe “only one” SALVATION specific doctrine1. You will first describe:a. The audienceb. The problem that requires the Apostle’s need to address the question.b. Describe how Paul gives a solution1. What is the solution2. How does the Apostle instruct the early church to handle the issue. c. Your conclusion:1. You will compare the problem and solution as it would be handled by your pastor and/or church elders (give specific examples-no real names). C- Required Work Cited Page: (do not count these words)Consult other resources;1. Referral of (3) three different printed Bible version:a. (use three different versions of the Bible (when quotes use various Bibles always use “quotes marks”)2. Use (2) two books you used3. Use (2) two internet research4. Use (1) a Bible dictionarySample Book Choice: ?The Call to Holiness (Thessalonians 4:1-2) ?4:1 finally then, brothers and sisters, we ask you and urge you in?The Lord Jesus, that as you received instruction from us about how?You must live and please God (as you are in fact living) that you doso more and more. 4:2 For you know what commands we gave youthrough the Lord Jesus.[supanova_question]
regarding a Salvation theology from one of the Apostle Paul’s Epistle
A- Required Cover Page (does not count these words)B- Required – The select Salvation message (5-8 pages of content)C- Required – Work Cited Page: (does not count these words) Paper requirements:a. The term paper must be typedb. A minimum of 8 pagesc. Using 12 point font,a. 1” margins all around,b. Double-spaced.d. A minimum of required sources must be used. (any direct quotes more than 5 lines should be single spaced-indented)Use (3) three different printed Bible version andUse (2) two books (you can use the class textbook as a source)Use (2) two internet research sourceUse (1) a Bible dictionary (BOOK FORM)?e. Any additional 2 resources as you may need- Encyclopedia ?- Bible map?- Concordance ?- Magazine article ?- Bible Atlas?- Internet source (web site)? You will prepare:B-Required – The selected epistle of your choice must be typed with a minimum of page 1000 words?a. Describe “only one” SALVATION specific doctrine1. You will first describe:a. The audienceb. The problem that requires the Apostle’s need to address the question.b. Describe how Paul gives a solution1. What is the solution2. How does the Apostle instruct the early church to handle the issue. c. Your conclusion:1. You will compare the problem and solution as it would be handled by your pastor and/or church elders (give specific examples-no real names). C- Required Work Cited Page: (do not count these words)Consult other resources;1. Referral of (3) three different printed Bible version:a. (use three different versions of the Bible (when quotes use various Bibles always use “quotes marks”)2. Use (2) two books you used3. Use (2) two internet research4. Use (1) a Bible dictionarySample Book Choice: ?The Call to Holiness (Thessalonians 4:1-2) ?4:1 finally then, brothers and sisters, we ask you and urge you in?The Lord Jesus, that as you received instruction from us about how?You must live and please God (as you are in fact living) that you doso more and more. 4:2 For you know what commands we gave youthrough the Lord Jesus.[supanova_question]