Assignment 2 Economics Exercise

 Submit: A report (pdf) plus excel spreadsheet. The report is to be no longer than ~2000 words (penalties will be applied if exceeded by more than 20%). Submit your assignment via the Assignment Submission Area (located

below the discussion forum on the course studydesk). Assignment cover sheet not required. Your submitted files should be formatted as :-



Format: Type using 12 font size, arial or times new roman font, single line spaced. Structure sentences into paragraphs, leaving a single blank line between paragraphs. Use your excel spreadsheet to generate graphs

which explain the analysis that you have undertaken. Organise your report into sections with headings and sub-headings, and then auto generate a table of contents (TOC) using your report headings. Describe all findings from your excel spreadsheet analysis in your report, as your excel spreadsheet will be looked at only briefly.

References: Include a single reference list at the end of the report. Try to source some refereed journal (i.e. non-internet) high quality references. Use intext citation of your references. The Harvard system of referencing must

be used. Do not use too many references, just cite the most important/ pertinent ones.

Extension policy: No extension allowed except in extenuating circumstances – see Course Specification.

Warning about plagiarism

You will be severely penalised if it is found that you have copied verbatim from the work of other authors, including from web sites. You may quote the work of others but quotations should be used sparingly. For each question, quotations should amount to no more than 5 per cent of the specified word limit for that question, and each quotation must be cited correctly. Plagiarism detection software may be used to check your assignment. To answer the assignment questions you are expected to consult your study package and other sources. However, the work you submit as your own work has to be in your own words. You are encouraged to discuss the concepts covered in the assignment questions with your classmates and others, but you should not release your written responses to the questions to anyone except the University. Students submitting a section or sections of assignment work which is the

same as other students’ work will be severely penalised. Further information about plagiarism can be found on the University website.
Assignment Two Task – spreadsheet and report (word limit: 2000) (200 marks) This assignment is relevant to all of the course objectives (as follows):

1. Converse proficiently upon general knowledge and current affairs of the day

2. Appreciate the history of technology and associated benefits to human society

3. Understand the basic concepts behind environmental sustainability

4. Understand the basic concepts behind environmental impact assessment

5. Understand the role of politics, politicians, power and government

6. Acquire a basic knowledge of economics and profitability forecasting, and be able to

perform a simple Net Present Value (NPV) exercise using Excel spreadsheet

7. Appreciate the relevance of social structures and values

8. Suggest strategies for working effectively in multi-cultural environments

9. Acquire basic knowledge of international legal systems

10. Appreciate the basic philosophies behind modern engineering management

TASK – a written report, plus excel spreadsheet. Please note that all findings from your spreadsheet analysis should be reproduced in the written report. Your report should be no longer than 2000 words, and should summarise your analysis (using NPV) of the future the profitability of your chosen alternative industry. Activities which you should embark upon, and also include in your report

1. Use the internet and other sources to research and evaluate historical and present economics associated with Sand Mining on North Stradbroke Island. Attempt to define how important the industry is presently (or will be) to the Queensland economy.

2. Imagine that you are the chief engineer working for a large international firm, and that the Queensland Government has consulted your best advice. What alternative forms of agriculture/industry it might be appropriate for the country to invest into? What is the likely level of investment required? What employment would be provided and what would be the likely ‘flow-on-benefits’ from your chosen alternative enterprise?

3. To start with, set up an excel spreadsheet similar to the example provided to you on ENG2002 study desk, named ‘NPVCalc’. You are welcome to use this provided spreadsheet, as a ‘starter’ to the one that you are going to develop and refine for your own purposes. Feel free to ‘play around’ i.e., experiment. Make adjustments and improvements to the spreadsheet, to suit your own requirements and arguments which you want to present in your report. The idea is to set up your spreadsheet to calculate, using the Net Present Value (NPV) economic calculation method, the future profitability of the industry, based on the assumed market profitability of your chosen path forward.

You may choose to recommend government financial assistance (i.e. grants), with setting up your alternative.

Some additional guidance
 As a way of best demonstrating your predicted range of future profitabilities, for your chosen alternative industry, it is recommended that you run your NPV simulations (graphical analysis) using interest rates on borrowed money (or discount rate if you prefer) scenarios of 3,6,9,12,15 and 18%. You should be able to plot all six curves on the
one graph. This should cover all eventualities and will cover you, in case there is a sudden collapse in economic conditions, which normally brings about high inflation rates, and therefore high interest rates on any borrowed money.
 If the cost of borrowing money is added to all the other business costs, eg. asset and equipment depreciation, maintenance costs, labour costs, government taxation, cost of environmental rehabilitation, and falling future commodity price due to competing industries, then this can be all aggregated together to produce what is known in
economics as the ‘discount rate’. Based upon historical performance data, this is what banks and lending institutions use to assess risk, and it is how they calculate what interest rate to charge against money lent to the various different industries.
 Of course you have to research, study and make many assumptions (educated guesses) with this type of economic analysis, e.g., future market/commodity prices, growth/stagnation in population and other parts of the economy. Clearly state your assumptions in the methodology section to your report


10% off for this assignment.

Our Prices Start at $11.99. As Our First Client, Use Coupon Code GET10 to claim 10% Discount This Month!!

Why US?

100% Confidentiality

Information about customers is confidential and never disclosed to third parties.

Timely Delivery

No missed deadlines – 97% of assignments are completed in time.

Original Writing

We complete all papers from scratch. You can get a plagiarism report.

Money Back

If you are convinced that our writer has not followed your requirements, feel free to ask for a refund.