Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Capital budgeting excel assignment

09/01/2021 Client: saad24vbs Deadline: 3 days

Capital Budgeting Report and Analysis


___________________________________________________________________________________


General information


Format: Report and Analysis


Submission: Submit report with CRA matrix to Assignment Minder. Note that you need to attach the Assignment Minder ‘assignment cover sheet’ to the front of the document wallet.


Submit Excel analysis file by either:




- Submitting a USB or CD containing the Excel file with your report to Assignment Minder. If using this method, you must ensure that the USB or CD is securely attached inside the document wallet.


When saving the Excel file, please ensure that:


- the file name includes your name and student number.


- the file is a .xls or .xlsx file (mac files, such as .numbers are not accepted).




__________________________________________________________________________________


Outline


Primitive Energy owns several coal seam gas reserves in south-west Queensland. As a relatively minor player in the Queensland Liquefied Natural Gas (LNG) market, Primitive does not have the capacity to transfer and process the gas for sale to international buyers. Instead, Primitive simply extracts the gas and then sells it immediately (at the well-head, which is at the surface) to one of the major gas companies operating in the area. Recently, Primitive entered into a contract to sell gas from one of its reserves for the next 12 years. The contract stipulates that the price is set at $3.50 per gigajoule in the first year and that the price will increase by 2.50% per year to adjust for inflation.


With this contract in place, Primitive’s management are currently trying to determine the optimal well type for extracting the gas. The choice has been narrowed to two types:


A-Type Wells: Drill 3 A-Type wells per year up to and including the beginning of the 9th year. Wells have a 4 year life. The project will operate for 12 years.


B-Type Wells: Drill 3 B-Type wells per year up to and including the beginning of the 10th year. Wells have a 3 year life. The project will operate for 12 years.


Primitive’s finance department conducted a preliminary discounted cash flow analysis of the wells (found in Analysis of Well Types.xlsx). Based on the annual equivalent (AE) figure for each type of well they have recommended that the B-Type well be selected because it generates the highest AE.


A member of the management team, who studied EFB210 Finance 1, believes that the analysis is flawed (wrong) and should be re-done. They have asked that you complete the following task.


Task


Provide a detailed financial analysis that reports the net present value (NPV) that each well type generates over the full life of the project. In addition, you are to write a detailed but concise report. In completing this task, the manager has requested the following:


- 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 well conducted on separate sheets.


- 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 analytical tools. It should have the following sections:


o Summary


o Methodology


o Recommendations


o Limitations


The ‘Methodology’ section must explain how the NPV was calculated over the project’s total life and must justify why this methodology is preferred over that used by the finance department.


- In making recommendations, the analysis and report must determine at what level of variable costs do B-Type wells become equivalent to A-type wells. Note: in doing this hold the variable costs of the A-type well fixed.




In order to prepare your analysis and report, your can refer to the information provided in the Analysis of Well Types xlsx file provided. 

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Best Coursework Help
University Coursework Help
Top Essay Tutor
Helping Hand
Writer Writer Name Offer Chat
Best Coursework Help

ONLINE

Best Coursework Help

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$100 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$102 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$105 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$100 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Hlf polyurethane manufacturing - Ambiguously defined triangle - Environmental invaders portfolio - Two Discussion Responses Needed 100 words each 200 words - Does prospero free caliban - Million dollar baby character analysis - Hands on a hardbody character descriptions - Essex county cricket ground map - How to select cells a3 through f3 in excel - Ritz carlton brand positioning - Typhoon haiyan case study - Animal farm chapter 8 10 questions and answers - Organizational Challenges - 6 pages due by 24 hours and 48 hrs - Paper plasmid lab answers - 1.11 macbeth observation interpretation and critique - The baldwin company currently has the following balances - Cisco metro ethernet design and implementation guide - Doro liberto 810 specs - Fda medical device advisory notice - Quantitative strategic planning matrix of starbucks - Sector Research Paper - Assassin's creed freedom cry common sense media - Pizza hut income statement - V character analysis v for vendetta - 7 30 pm military time - Variable resistor in multisim - Abc sells 400 shares of its $23 par common stock for $27. the entry would entail credit(s) to - Ftttt urban dictionary - Pipework energy losses lab report - Wk 5 - Multiple Governments and Intergovernmental Relationships Paper [due Mon] - Cilicaine vk 500mg and alcohol - Cabbage tree creek aspley - Beyond complete dominance worksheet answers - Metal or nonmetal worksheet - Art - 27 riemann sums homework answers - What does the ghost tell hamlet - Pv cell module array - Interpreting Test Results - Scattering of light diagram - Linguistics statement of purpose - Case study - Only Bethuel best 9 - Business studies syllabus acronyms - Template for literature review - Elora jean - Harry and rachel skydell - Shelly mack and the reunion band - 0737179697 MAMA SHANANI ABORTION CLINIC IN ELIM - Chicano - Finance discussion wk 2 - University of phoenix college algebra - Year 10 australian curriculum physics - 8 mile wasting my time - Bcaa rental car insurance - Due tomorrow - Southwestern university's food service case study - Sae oil viscosity temperature chart - Critically evaluate essay structure - Basic skills and drills in badminton - Rogers products uses a periodic inventory system - 13.1 build a computer from scratch - Liu zhang operates lawson consulting - Edexcel gcse percentages answers - IOCDQ1 - Soc 110 teamwork collaboration and conflict resolution - Swot analysis of biotech industry - I need this assignment done as followed as in the content APA style no plagisirism please make sure that everything is in details. - Nurse practitioner core competencies 2016 - Smugmug rex tranter - Need report based on cesim simulation - Sonny's blues short story summary - Inches per revolution chart - Infrastructure solution - Please read carefully - Graham v connor pdf - 571 mount barker road bridgewater - University of windsor phd - How Book Editors Add Value to Your Publishing Journey - 26 lee street sydney nsw 2000 - Tyrell quotes blade runner - Disappearing by monica wood summary - Air pollution webquest - Brandon brown versus yucatan chapter 3 - Ayen laurel ex husband - Charles bukowski i changed jobs and cities - Wk 5, HCS/341: DR 1 - Selective attention definition ap psychology - What is word building in english grammar - DISC 2 Transition t p of n - Castlederg high school website - Four square writing template - Physics units and dimensions formulas - 1.1 10 practice written assignment - Texting and driving persuasive speech examples - Bashundhara group share price - I need 1500 words in Arabic language articles in sports - Determination to achieve goals - John blondel goldman sachs