Reference no: EM131052435
FINANCE - Capital Budgeting Report and Analysis
Overview
Following the recent state and federal government approvals of Adani's Carmichael mine in the Galilee Basin in western Queensland, refer link:https://www.abc.net.au/news/2016-04-03/mning-leases-approved-carmichael-mine-qld-galilee-basin-adani/7295188, a representative of a mining company has approached you to undertake some preliminary financial analysis on their behalf.
The company, which plans to remain anonymous at this stage, wants you to evaluate the relative feasibility of two options for transporting coal from their mine pit to the railway line (approximately 80km) that will service the Carmichael mine. With most mine-to-port/rail type analysis, the company understands that it can transport the coal by road (truck), conveyor or rail. However, given the distance to travel and limitations associated with the electricity infrastructure in the area, the company has limited its choices to either road or rail. Information on the road and rail transportation options is available in the ‘Initial Information' file provided.
Task
Based on the information provided, the representative has asked that you provide a detailed financial analysis of each transportation option and prepare a report that recommends a preferred option from those available. The following requests have been made about the analysis and report:
- The financial analysis is to be completed in Excel. The file is to be easily adjustable for different scenarios and all inputs must be in the one sheet called ‘Assumptions' with the analysis of each option conducted on a separate sheet.
- The report is to be short (600 words + 20% tolerance) and written in a manner that can be understood by a person with a basic understanding of financial terminologies and analytical tools.
- The report sections to include: Summary, Methodology, Recommendations and Limitations.
-Summary: outlines the task and advises of the recommendation.
-Methodology: must explain and justify the methodology employed.
-Recommendations: recommends a preferred option from those available. In addition, includes some further analysis on whether an assumption of $0 ‘wages' would affect the recommendation. This additional analysis is requested given recent developments with automated trucks and trains in the mining sector.
-Limitations: must identify key limitations with the analysis.
Attachment:- Finance Initial Information.rar
|
Difference between waterproofi ng and dampproofi ng
: Explain the difference between waterproofi ng and dampproofi ng. When is either an appropriate choice for protecting a foundation from moisture?
|
|
Used to document progress or detail issues
: Reports are often used to document progress or detail issues. For example, Saint Catherine Children's Hospital might use reports to track budgets, incidents with patients, employees by department, or proposals for new construction. In this assignm..
|
|
Tutorial on taking a screen shot
: If you need a tutorial on taking a screen shot, visit one of the following locations: (PC users: http://www.take-a-screenshot.org/) (MAC users: http://binged.it/1xriOcN).
|
|
What soil conditions favor the use of belled caissons
: What soil conditions favor the use of belled caissons?
|
|
Provide a detailed financial analysis of each transportation
: EFB210: FINANCE - Capital Budgeting Report and Analysis. Based on the information provided, the representative has asked that you provide a detailed financial analysis of each transportation option and prepare a report that recommends a preferred o..
|
|
Determine the charge for each customer
: The program should display the charge for the current customer and should calculate and display the running total of yesterday's receipts. The program should use the method calculate-Charges to determine the charge for each customer.
|
|
Pertain to asset backed securities
: Which of the following does not pertain to asset backed securities?
|
|
Purchasing a new piece of manufacturing equipment
: A company is considering various options for purchasing a new piece of manufacturing equipment. The price of the equipment is $150,000. It is estimated that the equipment will be worthless after 10 years of service. Compute the best monetary value fo..
|
|
Different components included in a variety of business
: Business documents can be used for a variety of reasons and fall into three basic categories. If you are in a situation where you need to offer data, facts, feedback, and other types of information, you would use Informational reports.
|