{"id":3271,"date":"2018-05-10T15:41:01","date_gmt":"2018-05-10T05:41:01","guid":{"rendered":"https:\/\/casestudyhelp.com\/sample-questions\/?p=3271"},"modified":"2019-09-19T20:10:11","modified_gmt":"2019-09-19T10:10:11","slug":"faculty-of-business-and-law-higher-education-division-fin20014-financial-management-individual-assignment-semester-1-2018-1435","status":"publish","type":"post","link":"https:\/\/casestudyhelp.com\/sample-questions\/faculty-of-business-and-law-higher-education-division-fin20014-financial-management-individual-assignment-semester-1-2018-1435\/","title":{"rendered":"Faculty of Business and Law Higher Education Division FIN20014 Financial Management Individual Assignment – Semester 1 2018-1435"},"content":{"rendered":"

Faculty of Business and Law Higher Education Division FIN20014 Financial Management<\/h2>\n

Required<\/em><\/strong><\/p>\n

Using Excel Spreadsheet, prepare a full analysis to be presented to the CFO of PENTAG Company in evaluating whether either project should be started or not. Your report should include the following.<\/p>\n

\u2022 Table of cash flows
\n\u2022 Use of excel formulae where appropriate (refer eLearning video of Week-6)
\n\u2022 A written report (1500 words, +\/- 10%) outlining your recommendation as to whether PENTAG Company should proceed with either project. Justify your recommendations using quantitative and qualitative issues and your analysis of probable risks and benefits relating to the project. Comparison statement is to present in a separate section in the report.<\/p>\n

Marks with ll be awarded for:<\/p>\n

\u2022 Set out of a spreadsheet (watch eLearning video of week-6)
\ni. Ease of reading worksheet
\nii. Use of excel formulae in organized spreadsheet
\niii. Correct application of the theoretical model
\n\u2022 The overall presentation of answer including the written report.<\/p>\n

*\u00a0 \u00a0 Carefully read the Report Format Guide (on page-4) and Marking Rubric (on page-5) for required components and presentation of the formal report.<\/p>\n

Guidelines for Marking and Submission of Excel Assignment FIN20014 Financial Management\u00a0<\/strong><\/p>\n

Semester 1 2018<\/strong><\/p>\n

Total Marks for the assignment = 20 marks
\nOrganised Excel Spreadsheet = 10 marks and
\nConcise Formal Business Report (1500 +\/- 10% words) = 10 marks<\/p>\n

The attached marking rubric (Excel Assignment Information Page-5) should be considered by students when preparing their assignment for submission.<\/p>\n

Students are required to solve a capital budgeting difficulty using an excel spreadsheet.<\/p>\n

HARD COPY SUBMISSION:<\/strong><\/span><\/p>\n

Submit a hard copy of your assignment<\/p>\n

\u2022 Containing (i) assignment cover sheet; (ii) a copy of the formal report; (iii) a copy of the excel spreadsheet displaying values; and (iv) a copy of the excel spreadsheet displaying excel formulas.
\n\u2022 EITHER directly to your tutor in cities in the WEEK BEGINNING Monday the 9th of May,
\n\u2022 OR into the assignment drop box on Level-11 BA Building, clearly indicating the name of your tutor and tutorial time. All assignments will then be forwarded directly to the respective tutors for marking. Assignment box will remain open from 7 May to 11 May (to be closed at 5:00 pm on 11 May).<\/p>\n

SOFT COPY SUBMISSION:<\/strong><\/span><\/p>\n

Submit the soft copy of your assignment via Blackboard TURNITIN submission under ASSESSMENT folder:<\/p>\n

\u2022 By FRIDAY the 11th of May 5:00 pm AEST.
\n\u2022 Submit ONLY ONE FILE comprising the cover sheet and required Report only.
\n\u2022 Submit final assignment by using the FINAL SUBMIT option.<\/p>\n

Late assignments will be determined based on the SOFT COPY SUBMISSION time\u00a0 as\u00a0 recorded in TURNITIN. Late Assignments will not\u00a0 be\u00a0 accepted\u00a0 unless\u00a0 an\u00a0 arrangement has been made directly with the convenor.<\/p>\n

Should you be unable to submit your assignment due to ill health then you will need to contact Miraj Ahmmod on sahmmod@swin.edu.au (indicating who your tutor is) to make alternative arrangements.<\/p>\n

SUGGESTED FORMAT FOR ASSIGNMENT REPORT<\/strong><\/span><\/p>\n

Components of a FORMAL report are expected in the assignment structure. Following table shows one example of major sections: (other sections may be added, if needed)<\/p>\n\n\n\n\n\n
Structure Example<\/td>\n<\/tr>\n
COVER PAGE [ Must be correctly filled in; otherwise, you will forfeit marks]Executive Summary Table of Contents Body1.\u00a0 Introduction2.\u00a0 Findings\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/em>Quantitative (with explanation of results)<\/em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <\/em>Qualitative<\/em><\/p>\n

3.\u00a0 Recommendations and Justifications<\/p>\n

4.\u00a0 Detail Comparison and Further Recommendations 5.Conclusion<\/p>\n

References Appendix<\/em><\/p>\n

Workings<\/em><\/p>\n

Exact Copy of Excel Spreadsheet displaying values (not edited in Word doc)*<\/em><\/p>\n

Exact Copy of Excel Spreadsheet displaying Excel formulas (not edited in Word doc)*<\/em><\/td>\n<\/tr>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Carefully read the following Marking Rubric for required components and presentation of formal report.<\/strong><\/p>\n

Marking Rubric<\/strong><\/span><\/p>\n

\"Marking<\/a><\/p>\n

FREQUENTLY ASKED QUESTIONS and SUGGESTIONS:<\/strong><\/span><\/p>\n

Q1.\u00a0\u00a0\u00a0\u00a0<\/em>\u00a0 Do I have to upload the soft copy of the same file as I submit for hard copy?<\/p>\n

    \n
  1. NO. Soft copy submission requires ONLY ONE FILE including the Cover Page and the Report only.<\/li>\n<\/ol>\n

    Q2.\u00a0\u00a0\u00a0\u00a0\u00a0 Can I upload more than one file via Turnitin?<\/p>\n

      \n
    1. NO. You can upload ONLY ONE FILE via Turnitin. You cannot change the file once uploaded.<\/li>\n<\/ol>\n

      Q3.\u00a0\u00a0\u00a0\u00a0\u00a0 Can I get any help in understanding the assignment question?<\/p>\n

        \n
      1. Whilst we (the members of the Finance teaching panel) understand your concern, we cannot answer to any direct query you may ask relating to the assignment. The problem has specifically been included in the assignment for students to ponder and respond. It is expected that you have clarified all assumptions you may have made in your assignment report.<\/li>\n<\/ol>\n

        Q4.\u00a0\u00a0\u00a0\u00a0\u00a0 Are there specific resources that can help me understand the assignment questions?<\/p>\n

          \n
        1. YES. Issues relating to assignment are discussed in relevant lectures (Week-5 & 6) for multiple times and\/or in different ways. To assist you with understanding the concepts of finding Net Cash Flows, it is suggested that you review the lecture illustrations discussed on relevant topics (4a & 4B). You can also check relevant past exam questions and solutions, Sunburst Case and solutions, as well as your text and lecture materials for that topic. All these resources, included recorded lectures and notes written in lectures, are available on BB. eLearning video of week-6 will guide about the way to prepare cash flow table using Excel.<\/li>\n<\/ol>\n

          Q5.\u00a0\u00a0\u00a0\u00a0\u00a0 I don\u2019t know how to take print out of Excel spreadsheet displaying Formulas only.<\/p>\n

            \n
          1. Google it! For different versions of Excel, different ways are there. All you can find in Google and Youtube.<\/li>\n<\/ol>\n

            Q6.\u00a0\u00a0\u00a0\u00a0\u00a0 Can I send my works on assignment to any teaching staff for having any comment and\/or guidance?<\/p>\n

              \n
            1. NO. Assignment is an individual assessment item and members of the Finance teaching panel can neither view the spreadsheet nor make comments on it before submission.<\/li>\n<\/ol>\n

              Q7.\u00a0\u00a0\u00a0\u00a0\u00a0 What would be the content and structure of my report?<\/p>\n

                \n
              1. A sample of format is provided on page-4 and that is followed by a marking rubric on page-5. If you go through these documents, it will give you the idea about the structure and content expected in your report. You are required to provide necessary calculations, results, logical explanations of findings and justifications to convince the manager of the firm to support your recommendations.<\/li>\n<\/ol>\n

                Q8.\u00a0\u00a0\u00a0\u00a0\u00a0 Can I submit hard copy of assignment in the drop box?<\/p>\n

                  \n
                1. YES. If you don\u2019t submit hard copy of your assignment to you tutor, you can submit it in the drop box on Level-11 BA Building by 5:00 pm 11 May. If you do not mention your TUTOR\u2019s NAME and Tutorial Time correctly on the cover page, you will forfeit the marks of assignment.<\/li>\n<\/ol>\n

                  Q9.\u00a0\u00a0\u00a0\u00a0\u00a0 How do I know the name of my tutor?<\/p>\n

                    \n
                  1. Tutorial timetable with tutor\u2019s name and contact email are available on BB site for this unit.<\/li>\n<\/ol>\n

                    Q10. What will happen if my assignment is similar to another submission?<\/p>\n

                      \n
                    1. Both of the similar assignments will be sent to a review committee for identifying the probable case of plagiarism. In the case of identified plagiarism, further steps would follow the University Policies.<\/li>\n<\/ol>\n

                      Details of Assignment PENTAG Company
                      \nQ-powerboats
                      \nPENTAG invested
                      \nFinancial Estimates PENTAG Company
                      \ncapital (NWC)
                      \ncost of capital (WACC)
                      \nQ-Powerboat project<\/p>\n

                      View complete question \u00bb<\/a><\/span><\/strong><\/span><\/p>\n

                      FIN20014 Financial Management: Individual Assignment<\/i><\/strong><\/span><\/p>\n

                      \"Strategic-Project-Management-Module-Guide-BAC\"<\/a><\/p>\n

                      \"Hire<\/a><\/p>\n