FIN20014 Financial Management
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 analysis should include the following
• Table of cash flows
• Use of excel formulae where appropriate (refer eLearning video of Week-6)
• 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 presented in a separate section in the
FREQUENTLY asked Questions and Suggestions:
Q1. Do I have to upload the soft copy of the same file as I submit for hard copy?
A. NO. Soft copy submission requires ONLY ONE FILE including the Cover Page and the Report only.
Q2. Can I upload more than one file via Turnitin?
A. NO. You can upload ONLY ONE FILE via Turnitin. You cannot change the file once uploaded.
Q3. Can I get any help in understanding the assignment question?
A. 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 inthe assignment for students to ponder and respond. It is expected that you have clarified all assumptions you may have made in your assignment report.
Q4. Are there specific resources that can help me understand the assignment questions? A. 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.
Q5. I don’t know how to take print out of Excel spreadsheet displaying Formulas only.
A. Google it! For different versions of Excel, different ways are there. All you can find in Google and Youtube. Q6. Can I send my works on assignment to any teaching staff for having any comment and/or guidance?
A. 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.
Q7. What would be the content and structure of my report?
A. 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.
Q8. Can I submit hard copy of assignment in the drop box?
A. YES. If you don’t 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’s NAME and Tutorial Time correctly on the cover page, you will forfeit the marks of assignment.
Q9. How do I know the name of my tutor?
A. Tutorial timetable with tutor’s name and contact email are available on BB site for this unit.
Q10. What will happen if my assignment is similar to another submission?
A. 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