Construct a spreadsheet to calculate the payback period

Assignment Help Financial Accounting
Reference no: EM132962690

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 $850 million today, and it will have a cash outflow of $75 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 following table. Bullock Mining has a 12 percent required return on all of its gold mines.

Year                    Cash Flow
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

Problem 1: Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return (assume the investment rate is the same as the borrowing rate), profitability index and net present value of the proposed mine.

Problem 2: Based on your analysis, should the company open the mine?

Problem 3: What would your opinion be if Bullock Mining evaluated the risk of spending $850 million and decided in the current environment, they required a 30% required return on all of its new gold mines? Why?

Reference no: EM132962690

Questions Cloud

What is the capital balance of Etonaman : The merchandise inventory is to be valued at P120,000. What is the capital balance of Etonaman before the admission of Subukanmo
What should do if want the standard deviation to rise : You would like the standard deviation to drop to 14%. What should you do? What should you do if you want the standard deviation to rise to 23%.
What is Frank recognized gain : Frank exchanges his apartment building (FMV $6,400,000; AB $6,300,000) for Nico's apartment building. What is Frank recognized gain
What is the value of the option to abandon : A firm is considering a 2-year project,What is the project correct NPV, considering the abandonment option, and what then is the value of the option to abandon?
Construct a spreadsheet to calculate the payback period : Construct a spreadsheet to calculate the payback period, internal rate of return, modified internal rate of return (assume the investment rate is the same)
Compute the depreciation expense for the third year : The machine cost $240,000 and is expected to be used for five years, or 10,000 hours of operation. Compute the depreciation expense for the third year
What is T basis in his partnership interest : T transfers a building ($90,000 market value, $40,000 basis), plus a $60,000 recourse debt on the building, What is T basis in his partnership interest
Concept of organizational justice : Post a summary of the top 3 factors that you feel have led to the decline in union membership over past few decades. For your "top 3" comment on any ties to the
What is the company net operating capital for the year : A company's balance sheet for its last fiscal year is presented in the table. What is the company's net operating capital (NOC) for the year?

Reviews

Write a Review

Financial Accounting Questions & Answers

  Identify key financial ratios that important to creditors

Identify key financial ratios that will be important to creditors. Calculate the 4 financial ratios (above) based on the financial statements.

  Solve tax paid on gain on disposal

Solve tax paid on gain on disposal. Round the answer to two decimals. Genetic Insights has a tax rate of 30%. The asset is sold at the end of six years

  Addition is revenue expenditure or capital expenditure

Revenue and Capital Expenditures Shively Company built an addition to its chemical plant. Indicate whether each of the following expenditures related to the addition is a revenue expenditure or a capital expenditure:

  Prepare any journal entries you consider necessary

Prepare any journal entries you consider necessary, including year-end entries (December 31), assuming these are available-for-sale securities.

  Find what will earnings per share be after the merger

You will pay for TargetCo by issuing new shares. If you pay no premium to buy TargetCo, what will your earnings per share be after the merger?

  What is the present value of the project after-tax cash flow

What is the present value of the project's after-tax cash flows from operations (excluding the present value of the CCA tax shields) over the project's life?

  What was amount of collection for the skyline corporation

What was the amount of collection in 2009 for The Skyline Corporation? The Skyline Corporation began constructing building with a contract price of P 43,800,000

  What is the maturity value of the? note

If the interest rate on a note is? 12.5% and the principal was? $57,000, what is the maturity value of the? note, if the term of the note is 5? months?

  Determine the amounts of the missing items

Determine the amounts of the missing items, identifying them by letter. (Suggestion: First determine the amount of increase or decrease in stockholders' equity during theyear.)

  Implementing a just-in-time processing system

List two requirements for implementing a just-in-time processing system. Would factory security and assembly activities be best classified at an appliance manufacturing plant as unit-level, batch-level, product-level, or organization-sustaining?

  How much compensation was paid to the underwriters of prada

How much compensation was paid to the underwriters of Prada Hong Kong IPO in 2011? How does it compare to the average compensation paid

  What the most important things to concentrate on are

To be successful in sales, the most important things to concentrate on are? Territory management, planning and closing skills./ Positive mindset, goals

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd