calculate the payback period with a spreadsheet new iron ore

Please I need help Beth Boondock, owner of ...

Please I need help 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 ...

Iron Ore | Today''s Spot Price & Charts

Iron Ore (Fe) is mined in around 50 countries worldwide and used to make steel (buildings, cars, white goods etc.). Global economic growth is the primary factor that drives its supply and demand. When economies are growing, the need for steel in construction increases which drives the …

Metal Mining Financial Model Template | eFinancialModels

The DCF Model takes the financials from above to calculate the Free Cash Flow, Asset and Transaction level NPVs, and IRRS along with the Payback on the operation. The model contains two Sensitivity Analysis tables for IRR and NPV. For visualization, there are graphs to display cash flows over the valuation period, payback period, and gold ...

Project economics

2019-6-28 · Introduction. The easiest way to keep track of your project''s economics is with a spreadsheet. An example of this record-keeping method can be found here: File:Project Economics.xls.To use this spreadsheet, enter known values into the outlined boxes at the top and the calculations will be performed automatically.

Case Study

2021-11-4 · Therefore, the new improved design was required to stop the ingress of iron ore, coal and see water entering the carriages and corroding the open gear systems, which was the main origin for the high maintenance costs and loss of production. The biggest single challenge ERIKS Power Transmission ever faced Let''s make industry work better

Solved QUESTIONS: 1. Construct a spreadsheet to …

QUESTIONS: 1. 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. ... After that amount of time, all of the silver ore would be completely mined. ... Beth has contacted Gina to request a full financial analysis of the new mine and to ...

Calculating Cyanide Consumption

2016-9-15 · Calculating Cyanide Consumption. Computing Cyanide Consumption of a laboratory leach test may be done as in the following example: Ore taken, 250 grams. Ratio of solution to ore, 3:1 = 750 cc: 250 grams. Cyanide strength, …

Bid-Ask Spread Formula | Calculator (Excel template)

2  · This is the asking price for the security X. Hence we can calculate the bid-ask spread by simply subtracting bid price from the asking price. Bid-Ask Spread = Ask price – Bid Price. Bid-Ask Spread = $21 – $20. Bid-Ask Spread = $1. …

Solution manual of Engineering Economics 7th Ed | More ...

These results bracket the payback period for each retention period 7–12 price... Figure and sales ... 12 A new engineering graduate who started a consulting business borrowed money for 1 year to furnish ... single-cell spreadsheet function to calculate PG or AG for an arithmetic gradient... General formats for these functions are ‫ ؍‬NPV ...

Calculate The Payback Period With A Spreadsheet

calculate the payback period with a spreadsheet crusher in ... Grinding Mill. Grinding is the required powdering or pulverizing process when final size of below 2 mm is needed. Shenbang can provide the proper grinding measure to ...

Break Even Analysis Template

2021-11-30 · A break-even analysis can also be used to calculate the Payback Period or the amount of time required to break even. InvoiceBerry simplifies invoices and. Our Break-Even Analysis Calculator is a simple spreadsheet that contains 3 separate worksheets to solve for either 1 Break-Even Units 2 Break-Even Price or 3 Payback Period.

(Get Answer)

2021-5-12 · A. Basedon the above, construct a spreadsheet to calculate the Net Present Value, internal rate of return, the payback period and the discounted payback period (Assume a cut off of 5 years for the payback and discounted payback period). B. Based on...

Capital Investment Model Template

Capital Investment Model Template. This capital investment model template will help you calculate key valuation metrics of a capital investment including the cash flows, net present value (NPV), internal rate of return (IRR), and payback period. Below is a preview of the template:

Managerial Accounting Exam 4 Flashcards | Quizlet

2015-9-24 · Payback period (years) 3.6 3.2 4.0 2.0 NPV of project $ 142 comma 000$142,000 $ 168 comma 000$168,000 $ 252 comma 000$252,000 $ 116 comma 000$116,000 Calculate the profitability index for Project A. (Round your answer to two decimal places.

Gold Mine Investment Model Template | eFinancialModels

The model is available in two versions, a PDF Demo Version and the model in Excel with all cells editable (Normal). Current model version is 6.2. Excel Financial Model – $44.95. PDF Gold Mine Model Demo – $0.00. Screenshots of Executive Summary of the Gold Mine Financial Model. Excel Financial Model – $44.95.

BREAK-EVEN ANALYSIS OF MINING PROJECT

2010-5-14 · 2.5.1.1 Payback period method 12 2.5.1.2 Accounting rate of return method 13 2.5.2 Discounted cash flow methods 14 2.5.2.1 Net present value (NPV) 14 ... not change, but the amount of economically viable ore does change. The amount of economically viable ore is also dependent on the assumptions used for its calculation and can change with a

Ore Reserve Estimation Method

2017-3-24 · Estimates of the tonnage and average grade of ore deposits (ore-reserve estimates) are made for various purposes. They may be made by examining engineers as a basis for placing a value on a mining property in connection with reports on behalf of owners or vendors, on the one hand, or for prospective purchasers or lessees, on the other.

INVESTMENT FEASIBILITY STUDY FOR IRON ORE …

The payback period can be found by dividing the initial investment by the annual cash inflow. Although popular, the payback period is generally viewed as an unsophisticated capital budgeting technique, because it does not explicitly consider the time value of money. To calculate the payback period, the data can be seen on table 3.3 below.

Ocean Carrier

Payback Period The payback period allows an analyst to evaluate the duration it takes for the company to generate dollar returns that pay back the initial cost of the investment. ... To commission the construction of a new vessel would take 2 years from start to completion. ... while the demand will not increase because imports of iron ore and ...

Geology, Prospecting and Exploration for Iron Ore …

2015-4-9 · Exploitation of existing iron ore deposit is the easier part of the mining operations. The harder part is to find new ore deposits and to define their extent and the iron content (grade). Exploration is the process by which the accumulations of …

Real Options Valuation with MATLAB: A Mining Economics ...

2021-12-17 · Using the Distribution Fitting app in Statistics and Machine Learning Toolbox™, we calculate these values from a normal distribution for HWV and a generalized extreme value distribution for GBM. Note that in this scenario, all …

Chapter 5: Exercises | Managerial Accounting

Exercise C Compute the break-even point in sales dollars if fixed costs are $200,000 and the total contribution margin is 20% of revenue.. Exercise D Barney Company makes and sells stuffed animals.One product, Michael Bears, sells for $28 per bear. Michael Bears have fixed costs of $100,000 per month and a variable cost of $12 per bear.

Module 7

A company is considering an iron ore extraction project that requires an initial investment of $1,100,000 and will yield annual cash inflows of $676,507 for two years. The company''s discount rate is 9%. Calculate IRR. Present value of ordinary annuity of $1: 10% 12% 14% 15% 16% 18% 20% 1 0.909 0.893 0.877 0.870 0.862 0.847 0.833 2 1.736

Calculate The Payback Period With A Spreadsheet

Answer to Create a spreadsheet to compute the NPV and payback period to assist with a purchase decision. What is the machines payback period 3. 1. 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.

Quiz 7 Flashcards | Quizlet

Calculate the payback period for investment A. 3.6 years. Landmark Prints company is considering investing in new equipment costing $500,000. The equipment will be depreciated on a straight-line basis over a five-year life and its expected to generate net cash inflews of $120,000 the first year. $140,000 the second year, and $150,000 every year ...

Chapter 1: Exercises | Managerial Accounting

Iron ore in a steel mill. Oil, gasoline, and grease for forklift trucks in a manufacturing company''s warehouse. Services of painters in building construction. Cutting oils used in machining operations. Cost of paper towels in a factory employees'' washroom. Payroll taxes and fringe benefits related to direct labor. The plant electricians ...