ETF2700/ETF5970 – MATHEMATICS FOR BUSINESS代写

  • 100%原创包过,高质代写&免费提供Turnitin报告--24小时客服QQ&微信:120591129
  • ETF2700/ETF5970 – MATHEMATICS FOR BUSINESS代写
    ETF2700/ETF5970 – MATHEMATICS FOR BUSINESS
    Semester 2 2016
    Assignment 3 – due Monday 24 October 2016
     
     
    This assignment comprises 10% of the assessment for ETF2700 and 10% for ETF5970.
    You must submit a printed “hard copy” of your written work - with an Assignment Cover Sheet (from the “Assignments” tab on Moodle).  Submit it in your tutorial before the due time, or submit it to your tutor’s mailbox, 5th floor H Block, by the due time.
    ENSURE that you
    ·         submit a printed “hard copy” of your assignment to your tutor.  Your assignment must be typed.
           Your tutor will NOT print or mark your assignment from Moodle.
    ·         Name your assignment: Surname-Initials_A3.docx, eg, Clinton-HR_A3.docx.
    ·         Upload this file to Moodle (as a backup) – as follows.
          Go to the “ASSIGNMENTS” section.  Click on the “ASSIGNMENT 3” link to upload. 
          The following message will appear momentarily, “File uploaded successfully.”
          [To later confirm your upload was successful, go to the “ASSIGNMENTS” section and click
           on the “Assignment 3” uploading link.  The uploaded file’s name will be shown.]
           NB, DO NOT submit any Excel files.  You may upload only ONE file.
    ·      Retain your marked assignment until after the publication of final results for this unit.
    ·      A maximum penalty of 20% of the total mark allocated to this assessment will be deducted for each working day that it is late.
    ·      Extensions beyond the due date will only be allowed in special circumstances.  Contact your tutor.
    ·      Do not submit your assignment in a folder – stapled pages are easier for the marker.
    ·      Save trees!  Double-sided printing is encouraged.
    ·      Retain your marked assignment work until after the publication of final results for this unit.
     

    Plagiarism
    Intentional plagiarism amounts to cheating in terms of Monash University Statute 4.1 – Discipline.
    Plagiarism: Plagiarism means to take and use another person’s ideas and or manner of expressing them and to pass these off as one’s own by failing to give appropriate acknowledgement.  This includes material from any source, staff, students or the Internet – published and unpublished works.
    Collusion: Collusion is unauthorised collaboration with another person or persons.
    Where there are reasonable grounds for believing that intentional plagiarism or collusion has occurred, this
    will be reported to the Chief Examiner, who may disallow the work concerned by prohibiting assessment or
    refer the matter to the Faculty Manager.

     
     

     
    Question 1    Show your working.
    (a)   A and B are non-singular n × n matrices.  Prove that (AB)-1 = B-1A-1.
    (b)   We wish to determine the inverse of matrix M without using any
    electronic calculation device.
    Obtain, and solve algebraically by elimination, a set of simultaneous equations
    ·         for a, b and c.
    ·         for d, e and f.
    ·         for g, h and i.
    M =  
    M-1 =  
     
     
     
    Question 2    Show your working.  (You may use screenshots.)
    If you use software in this question, you must use only Excel.
    Refer to Worksheet Q2 of Assgt 3.xlsx on Moodle.  For a system of equations, AX = C, in 5 unknowns (x1, x2, x3, x4 and x5), A is the coefficient matrix and C is the right-hand side vector. 
    IMPORTANT: you MUST display your Excel formulas AND you MUST also display the row and column headings (see the Excel Appendix below) so that your formulas can be interpreted.  Marks WILL be deducted if you neglect to do this.
    (a)   Obtain the rank of the coefficient matrix.
    (b)   Obtain the rank of the augmented matrix.
    (c)   From what has been established so far in this question, what is known about this system of equations? 
    (No calculation required.)
    (d)   Is there a unique solution to this system of equations?  If so, obtain it.  If not, explain why not.
    (e)   Is this system of equations ill-conditioned?  Discuss. 
    Provide suitable calculations to support your answer.
     
     
    Question 3    Show your working, including the formula(s) that you used.  Do not use software.
    A rocket travelled 0.5 km in its first minute of flight.  Each minute thereafter, the distance travelled was 40% more than the distance travelled in the previous minute.
    (a)        Calculate, correct to 2 decimal places, the distance (km) travelled in the 10th minute of flight.  
    (b)       How long does it take for the rocket to travel a total distance of more than 1,044 km?
    Give your answer correct to the nearest minute.
     
     
    Question 4    Show your working, including the formula(s) that you used. 
    IMPORTANT: you MUST display your Excel formulas AND you MUST also display the row and column headings (see the Excel Appendix below) so that your formulas can be interpreted.  Marks WILL be deducted if you neglect to do this.
    Sharon bought a new car for $24,500.  She has monthly repayments of $937.50 on a flat rate loan for 3 years.
    (a)        Calculate the annual flat rate of interest.  Give your answer as a percentage, correct to 3 decimal place.
    (b)   A loan of $50,000 has a 9.95% per annum flat rate and monthly payments of $1,456.25 for 4 years.
           (i)    For a flat rate loan, the annual effective rate of interest r is often approximated by the formula
           r = 2nR/(n + 1).  Use this formula to calculate r as a percentage to 3 decimal places.
    (ii)        Calculate the annual effective rate of interest, as a percentage, correct to 3 decimal places.   
    (iii)       Calculate the nominal rate of interest, as a percentage, correct to 3 decimal places.

     
    Question 5    Show your working, including the formula(s) that you used. 
    This item appeared recently in Money magazine.
    For the following calculations, you may ignore taxation and inflation.  Calculate percentages to 3 decimal places.
    (a)   Assuming that money compounds annually,
    calculate the percentage discount rate underlying this statement (to which 1/3 of readers agreed).
    (b)   Assuming that money compounds monthly,
    calculate the discount rate underlying this statement (to which 1/3 of readers agreed) as
    (i)      a percentage per month.
    (ii)     a nominal rate.
    (iii)    an effective annual rate.

     

    Source: Money/The Beddoes Institute.

     
    (c) ZNA Bank plans to advertise to encourage people to deposit into its new E-friendly account.  The
    account pays monthly compounding interest.  Should ZNA advertise the nominal rate or the effective annual rate for the account?  Briefly discuss this
    (i)      from the bank’s perspective.
    (ii)     from an investor’s perspective.
     
     
    Question 6    Show your working.
    The mining company OreFull Mining Pty Ltd is considering three alternative investments, each involving an initial outlay of $100 million and yielding a return at the end of each of the next 15 years.  Net returns ($ million) are estimated as shown below.  OreFull has unlimited borrowing capacity on the capital market at a cost of 16% per annum.
    Investment A:       $30m per year for the next 15 years.
    Investment B:       $20m per year for the next 10 years; $10m per year thereafter.
    Investment C:       $20m, $60m and $100m, respectively, for years 1, 2 and 3; $5m per year thereafter.
    IMPORTANT: you MUST display your Excel formulas AND you MUST also display the row and column headings (see the Excel Appendix below) so that your formulas can be interpreted.  Marks WILL be deducted if you neglect to do this.
    (a)   For each investment, calculate
    (i)      the sum of the returns ($m)
    (ii)     the NPV ($m to 3 decimal places).
    (iii)    the IRR (as a percentage to 3 decimal places).
    (b)   Imagine that you had perused the set of cash flows for each investment before calculation of any NPV
    or IRR values.  Were there any indications that C would have the highest IRR?  Briefly give reasons for your answer.
    (c)   Without further calculation, how do you know that the NPV for investment B will be negative if the
    cost of capital is 21%?
    (d)   Explain why the sum of the returns is, or is not, a good criterion on which to compare investments A, B
    and C.
    (e)   Which of the three investments (give reasons) would you recommend on the basis of
    (i)      NPV
    (ii)     IRR
    (iii)    all things being considered?  Briefly discuss.
    Excel TipsETF2700/ETF5970 – MATHEMATICS FOR BUSINESS代写
    If you need help with Excel,
    ·      use Excel’s Help/Microsoft Excel Help menu item.
    ·      see the “EXCEL” icon on the Moodle site for some Help files.
    To display the formulas which underlie your spreadsheet calculations
    While pressing the Ctrl key, press the  key.  (You may now need to widen some columns of the spreadsheet in order to fully display the revealed formulas.)
    Repeat these key strokes to return to the usual display.
    To alter the page margins, in order to optimise the use of a page before printing it
    Click on the Office Button and select Print/Print Preview/Preview/ShowMargins.  Then, click on and drag the margins.
    To print in “Landscape”           view, rather than in “Portrait”  view
    Click on Page Layout (at the top of the screen)/Orientation/Landscape.
    To print the gridlines which border the spreadsheet cells
    Select Click on Page Layout (at the top of the screen) /Sheet Options/Gridlines/Print
    To print the Row (“1”, “2”, “3”, etc) and Column (“A”, “B”, “C”, etc) headings
    Before printing, select Click on Page Layout (at the top of the screen) /Sheet Options/Headings/Print
     
    To Copy part of your spreadsheet, eg to Paste it into a Word document
    ·         Select the desired cells in Excel.
    ·         Click on the Copy command. 
    ·         Go to the Word document and select the triangle under the Paste command and select
    Paste Special/Picture(Enhanced Metafile).
    An alternative to the procedures above is to use “Snipping Tool” when your spreadsheet is displayed.  This captures an image of your screen, which may then be Pasted into a Word document.  Use Word’s “Crop” tool to reduce the Pasted image to your desired selection.
    If you are unable to make Excel display the row and column headings clearly on your printout, then you MUST write them on by hand.
     
    Word Tips
    To capture a screen image & Paste it into Word
    To capture the image (any image, eg, an Excel page, an internet page, a photo, etc) currently displayed on your screen,
    ·         press the Print Scrn button on your keyboard.
    ·         go to the required location in your Word document.  Hold the Ctrl key and press the letter “V”.
    ·         to trim (“Crop”) this image, select View/Toolbars/Picture and click on the “Crop” icon:
    Then, apply the “Crop” icon to the small square “handles”  of the image.
    The “Snipping Tool” (available via START button/Programs/Accessories) is very useful too.
     
    To arrange graphs and pictures within a “Word” document
    Graphs and pictures can be more manageable if you insert a table into Word and place your graphs and pictures (and text) into cells of the table.
     ETF2700/ETF5970 – MATHEMATICS FOR BUSINESS代写