Your software company was invited to provide a proposal for a company in Australia. You currently have the cost in US dollars and need to convert the prices to the Australian dollar. Write a 2-part program using Ruby, Java®, or Python. Part 1: Write a function to gather the following costs from the user: Travel Cost: $9,800 Hotel Cost: $3,500 Rental Car Cost: $1,600 Labor Cost: $15,500 Part 2: Write a function to convert the costs from United States dollar (USD) to Australian dollar (AUD). Note: Look up the current USD to AUD exchange rate to use in your function. Test the program 3 times by providing different costs in USD. Provide the code and take a screenshot of the output, then paste the screenshot(s) into a Microsoft® Word document. Write a half-page response in the same Microsoft® Word document to address the following: Provide a manual for the user explaining how to use the program. Explain what type of user input validations you should have. What happens if the user enters a negative number? What happens if the user puts a $ in the input?

Please use Excel to solve the assignment and submit as an excel spreadsheet.

Bethesda Mining Company Based on a Mini Case presented in the textbook Ross, S.A., R.W. Westerfield and J. Jaffe, Corporate Finance, McGraw Hill/Irwin. Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies has led to an improved market demand for high sulfur coal. Bethesda has just been approached by Mid-Ohio Electric Company with a request to supply coal for its electric generators for the next four years. Bethesda Mining does not have enough excess capacity at its existing mines to guarantee the contract. The company is considering opening a strip mine in Ohio on 5,000 acres of land purchased 10 years ago for $5 million. Based on a recent appraisal, the company feels it could receive $4.2 million on an aftertax basis if it sold the land today. Strip mining is a process where the layers of topsoil above vein are removed and the exposed soil is removed. Some time ago, the company would simply remove the coil and leave the land in an unusable condition. Changes in the mining regulations now force the a company to reclaim the land; that is, when mining is completed, the land must be restored to near its original condition. The land can then be used for other purposes. Because it is currently operating at full capacity, Bethesda will need to purchase additional necessary equipment, which will cost $32 million. The equipment will be depreciated on a seven-year MACRS schedule. The contract runs for only four years. At that time the coal from the site will be entirely mined. The company feels that the equipment can be sold for 60 percent of its initial purchase price. However, Bethesda plans to open another strip mine at that time and will use the equipment at the new mine. The contract calls for the delivery of 500,000 tons of coal per year at a price of $40 per ton. Bethesda Mining feels that call production will be 530,000 tons, 630,000 tons, 700,000 tons, and 630,000 tons, respectively, over the next four years. The excess production will be sold in the spot market at an average of $45 per ton. Variable costs amount to $15 per ton, and fixed costs are $2,200,000 per year. The mine will require a net working capital investment of 2 percent of sales. The NWC will be built up in the year prior to sales. Bethesda will be responsible for reclaiming the land at termination of the mining. This will occur in year 5. The company uses an outside company for reclamation of all the company’s strip mines. It is estimated the cost of reclamation will be $3 million. After the land is reclaimed, the company plans to denote the land to the state for use as a public park and recreation area. This will occur in year 6 and result in a charitable expense deduction of $5 million. Bethesda faces a 40 percent tax rate and has a 10 percent required return on new strip mine projects. Assume that a loss in any year will result in a tax credit. You have been approached by the president of the company with a request to analyze the project. Calculate the payback period, profitability index, net present value and internal rate of return for the new strip mine. Should Bethesda Mining take the contract and open the mine?

Question: BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located i... BETHESDA MINING COMPANY Bethesda Mining is a midsized coal mining company with 20 mines located in Ohio, Pennsylvania, West Virginia, and Kentucky. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market. The coal mining industry, especially high-sulfur coal operations such as Bethesda, has been hard-hit by environmental regulations. Recently, however, a combination of increased demand for coal and new pollution reduction technologies has led to an improved market demand for high-sulfur coal. Bethesda has just been approached by Mid-Ohio Electric Company with a request to supply coal for its electric generators for the next four years. Bethesda Mining does not have enough excess capacity at its existing mines to guarantee the contract. The company is considering opening a strip mine in Ohio on 5,000 acres of land purchased 10 years ago for $5 million. Based on a recent appraisal, the company feels it could receive $5.5 million on an aftertax basis if it sold the land today. Strip mining is a process where the layers of topsoil above a coal vein are removed and the exposed coal is removed. Some time ago, the company would simply remove the coal and leave the land in an unusable condition. Changes in mining regulations now force a company to reclaim the land; that is, when the mining is completed, the land must be restored to near its original condition. The land can then be used for other purposes. Because it is currently operating at full capacity, Bethesda will need to purchase additional necessary equipment, which will cost $85 million. The equipment will be depreciated on a seven-year MACRS schedule. The contract runs for only four years. At that time the coal from the site will be entirely mined. The company feels that the equipment can be sold for 60 percent of its initial purchase price in four years. However, Bethesda plans to open another strip mine at that time and will use the equipment at the new mine. The contract calls for the delivery of 500,000 tons of coal per year at a price of $82 per ton. Bethesda Mining feels that coal production will be 620,000 tons, 680,000 tons, 730,000 tons, and 590,000 tons, respectively, over the next four years. The excess production will be sold in the spot market at an average of $76 per ton. Variable costs amount to $31 per ton, and fixed costs are $4,100,000 per year. The mine will require a net working capital investment of 5 percent of sales. The NWC will be built up in the year prior to the sales. Bethesda will be responsible for reclaiming the land at termination of the mining. This will occur in Year 5. The company uses an outside company for reclamation of all the company's strip mines. It is estimated the cost of reclamation will be $2.7 million. In order to get the necessary permits for the strip mine, the company agreed to donate the land after reclamation to the state for use as a public park and recreation area. This will occur in Year 6 and result in a charitable expense deduction of $6 million. Bethesda faces a 38 percent tax rate and has a 12 percent required return on new strip mine projects. Assume that a loss in any year will result in a tax credit. You have been approached by the president of the company with a request to analyze the project. Calculate the payback period, profitability index, net present value, and internal rate of return for the new strip mine. Should Bethesda Mining take the contract and open the mine? no need for excel i need calculations and show your work please

DSW is a midsized coal mining company with 20 mines located in Hessen region in central Germany. The company operates deep mines as well as strip mines. Most of the coal mined is sold under contract, with excess production sold on the spot market.

The coal mining industry, especially high-sulfur coal operations such as DSW, has been hard-hit by environmental regulations and warmer than expected winter 2014/2015 and 2016/2017. Recently, however, a combination of increased demand for coal and new pollution reduction technologies has led to an improved market demand for high-sulfur coal. DSW has just been approached by SudenKraftwerk Company with a request to supply coal for its electric generators for the next four years. DSW does not have enough excess capacity at its existing mines to guarantee the contract. The company is considering opening a strip mine in Broken on 5,000 acres of land purchased 10 years ago for € 5 million. Based on a recent appraisal, the company feels it could receive € 6.2 million on an after-tax basis if it sold the land today.

Strip mining is a process where the layers of topsoil above a coal vein are removed and the exposed coal is removed. Changes in mining regulations now force a company to reclaim the land; that is, when the mining is completed, the land must be restored to near its original condition. The land can then be used for other purposes. Because it is currently operating at full capacity, DWS will need to purchase additional necessary equipment, which will cost € 78 million. The equipment will be depreciated on a seven-year linear basis. The contract runs for only four years. At that time the coal from the site will be entirely mined. The company feels that the equipment can be sold for 60 percent of its initial purchase price in four years. However, DSW plans to open another strip mine at that time and will use the equipment at the new mine.

The contract calls for the delivery of 500,000 tons of coal per year at a price of €85 per ton. DWS feels that coal production will be 620,000 tons, 680,000 tons, 730,000 tons, and 590,000 tons, respectively, over the next four years. The excess production will be sold in the spot market at an average of € 80 per ton but the spot prices are highly volatile. The fact should be taken into consideration in the analysis. Variable costs amount to € 27 per ton, and fixed costs are € 3,700,000 per year. The mine will require net working capital of 5 percent of sales. The NWC will be built up in the year prior to the sales.

DSW will be responsible for reclaiming the land at termination of the mining. This will occur in year 5. The company uses an outside company for reclamation of all the company’s strip mines. It is estimated the cost of reclamation will be € 2.4 million. After the land is reclaimed, the company plans to donate the land to the state for use as a public park and recreation area. This will occur in year 6 and result in a charitable expense deduction of € 6.5 million. DSW faces a 19 percent tax rate. Assume that a loss in any year will result in a tax credit.

You have been approached by the CFO of the company with a request to analyze the project.

Calculate the payback period, profitability index, net present value, internal rate of return for the new strip mine. Please prepare also sensitivity analysis for the project.

To calculate WACC of DSW assume that it is rather illiquid company with capitalization on the level of € 680 million, beta equals 1,25, outstanding interest bearing debt on the level of € 300 million and cash level of € 78 million.[1] The current EBIT of DSW amounts € 80 million and the gross financial costs equals € 28 million.

Should DSW Mining take the contract and open the mine taking into consideration the risk of the project?

Question 3 :

A package delivery company is contemplating building a new shipping center. The most recent shipping center, 10,000 square feet large, was built in 2005, at a cost of $500,000. The new shipping center will be 15,000 square feet large. Using the power-sizing cost-estimating model, estimate the cost of building a new shipping center now, using the assumptions below to construct a weighted cost index value for 2005 and for today. Use 0.90 for the cost-capacity factor. The dollar cost of building a shipping center can be broken down into the cost of labor (20%), materials (35%), and equipment (45%). The cost index for labor is 120 in 2005, and 150 today. The cost index for materials is 180 in 2005 and 170 today. The cost index for equipment is 140 in 2005 and 200 today.

Question 4 Milana just deposited $10,000 in her account. Assuming the annual interest rate is 8%, how many years will it take before her account balance reaches $23,000? (Please make sure you use the time value of money Excel functions)

Wollongong City is considering the construction of a new waste treatment plant. Land acquisition will
cost $120,000. The construction works required for the plant will cost $600,000. Environmental
inspection and other expenses will cost $60,000. The plant will be built in Year 0 and will become fully
operational in Year 1 for six years (i.e. until Year 6). The annual operating cost for the plant is estimated
to be fixed at $120,000 during its anticipated 6-year service life. This waste treatment plant is expected
to reduce $12 in the average annual waste treatment fee for each of the 35,000 households that it will
serve. The reduction in the annual waste treatment fee and the number of households in Wollongong
City are both assumed to be fixed for the 6 years. Changes in the environmental conditions (air
pollution and contamination to surrounding lands) must be reflected at the cost of $150,000 at the end
of the service life of the plant.

Determine the Internal Rate of Return (IRR) of the project, given that the IRR is between
25% and 30%.

Question 2

Mark Limited is an investment company that purchases buildings and holds them for a, number
of purposes, such as resale, leasing and its own use.
On 1 January 2019, Mark Limited purchased an old building, Mark Towers, for N$300 000.
Conveyancer’s fees amounted to N$20 000
• This building is situated in an isolated part of Durban (South Africa) and there is no
development anywhere nearby. At the time of purchase, there had been no property
transactions in this area for many years and the possibility of leasing the building to tenants
was remote.
• During November 2019, development began of a new industrial park in the area. As a
result, the building was able to be leased to tenants involved in the development of the
industrial park. Due to the influx of people of people into the area, the directors decided to
paint one side of the buildings with the corporate logo of Mark Limited.
• This building has never had an air-conditioning system. After numerous complaints from
tenants about not being able to tolerate the Durban heat, Mark Limited decided to upgrade
the building by installing a ducted air-conditioning system on 1 December 2019.
The cost of installation included the following:
- Adjustments to the structure of the building 30 000
- Painting 50 000
- Air-conditioning system 200 000
- Installation costs 50 000
The ducted air-conditioning system has a 10 year life and a nil residual value
• As a result of the new industrial park, there was suddenly a demand for properties in the
area. As a result, the fair value of Mark Towers was able to be determined on 31 December
2019 at N$420 000. Mark Limited would like to measure this investment property at fair
value now that fair values have become available.
• The building has a 10 year useful life and an estimated residual value of N$50 000
Mark Limited also holds other investment property, which is measured under the fair value model.
The fair value of this other investment property is as follows:
• 1 January 2019 N$ 1 000 000
• 31 December 2019 N$ 1 250 000

Lavage Rapide is a Canadian company that owns and operates a large automatic car wash facility near Montreal. The following table provides estimates concerning the company’s costs:

For example, electricity costs should be $1,400 per month plus $0.08 per car washed. The company actually washed 8,200 cars in August and collected an average of $6.50 per car washed.

Required:

Prepare the company’s flexible budget for August.