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

The mean value of land and buildings per acre - The basic practice of statistics 8th edition slader - Bostrom surveying instruments model 5 - Organizational Change - What gives rise to the currency exposure at aifs - Climate change speech outline - Chemical weathering of granite - Godaddy who is lookup - Discussion Study 3 - Crash time in project management - Source and sink flow examples - Case study - Ads that appeal to pathos - Kestrel communicator software download - Exploratorium baseball reaction time - Tableau flights dataset - Technology - Chicken licken swot analysis - Has Canada become a “postindustrial” society? #20902671Sociology - Analytical skills selection criteria - 12kg in pounds and ounces - Geology dip and strike - Help is needed - Engineering management midterm - Renew your nervous system and build stamina kriya - Problem 10 5 preparing a post closing trial balance - Coal seam gas gippsland - Finance Case Study - Teacher aide level 4 - Organizational Economics Assignment - Positive response due tomorrow 08/07/20 at 3pm - The marketing research department for a company that manufactures - Starry night poem sparknotes - Paper on IOT Threats to Database Security. - Ben and jerry's vermonster price - Statistics Excel: Week 3 - Nachman industries just paid a dividend of - Business Administration & International Business Essay - Project - Blue nile and diamond retailing case study powerpoint - Harvard animations action potential - What is back titration pdf - Paper - How to check if a function is quasiconvex - The fourth stall part 3 summary - Morgan spurlock 30 days minimum wage summary - Week 6 Medication Paper Rough Draft Pharmacology - Marketing creates needs and wants - Discussion 3 - Trading profit and loss account format - Create a scenario summary report excel 2013 - Autologous serum eye drops expiration date - How much does a tinnie weigh - John harrox primary school - Three Pillars and Future Impact - Anatomical terms worksheet answers - Chemical kinetics study questions answers - 82.4 kg in stone - PSY101B: Nature vs. Nurture Journal Entry - Www languageguide org english clothing - P plate clips kmart - Susan thompson buffett foundation glassdoor - Approved learning framework victoria - Research T1 - Kb of naoh - 2005 levee failures in greater new orleans - Carrier alarm codes pdf - Molar extinction coefficient of bsa at 595 nm - MARKETING HOMEWORK - Markers micador colourfun 12's - Problem statement - How could village volvo manage its back office - Light fixture cable hangers - 3 phase 4 wire energy meter connection diagram with ct - Common sense in japanese - How to change sparkline style in excel 2013 - Diebold technical support interview questions - Business ethics by crane and matten - A pension fund manager decides to invest - Fault current calculation formula - Picot question for short staffing - Windy hill oval napier street essendon - Scaldbeck cottage camping norfolk - Blue gold world water wars summary - What quadrant is 270 degrees in - Nsw police appointment belt - Holes themes and quotes - 2 PAGES ESSAY - Pine needle cross section labeled - Panjim's 2015 cash flow from financing activities is - Dolphin pool cleaner won t start - Can a food handler taste food to adjust seasoning quizlet - S2o8 2 2i rate law - Essay of Travel Report - The rise of bangladesh's textile trade case study answers - Ginn v renaldo inc - The thinker's guide to the art of socratic questioning pdf - Rule generation in apriori algorithm example - . 4 pages due 24 hours - S 15aa acts interpretation act