FBF_25300_assignment (1)

.pdf

School

University of Technology Sydney *

*We aren’t endorsed by this school

Course

23500

Subject

Finance

Date

Apr 3, 2024

Type

pdf

Pages

10

Uploaded by KidTeamHare45

Report
UTS CRICOS 00099F FUNDAMENTALS OF BUSINESS FINANCE ASSIGNMENT QUANTUM GRAPHITE LIMITED “THE GIGA FLAKE FACTORY”
Assignment Instructions Page 1 Please read the following information carefully: 1) Due date and time: 9pm on Monday, 8 May 2023. 2) Weight: 20% of total subject mark. 3) Teams: You can have an assignment team of: 1 student, which means you do the assignment by yourself. OR 2 to 6 students, which means you do the assignment in a team of students. Teams may consist of members from different workshops or tutorials. We encourage you to form teams consisting of 2 to 6 students as you will develop skills that are important to your professional life, and your assignment submission is likely to be stronger as it considers input from different students in your team. All team members receive the same assignment mark. Teaching staff are unable to award team members different marks in the event a team has a ‘free-rider’. Therefore, you should give considerable thought into selecting team members. In the event of a conflict within the group, it is your group’s responsibility to resolve the issue respectfully and maturely. In severe situations please contact the subject coordinator. For more information on working in groups: https://www.uts.edu.au/current-students/support/helps/self-help-resources/group-work
Assignment Instructions 4) Preformatted blank excel spreadsheet: You must record your answers in the provided blank excel spreadsheet (available on Canvas). This spreadsheet is protected which means that only a restricted number of cells can be used. All of your inputs into the spreadsheet should be using Arial font and size 8 text, this ensures that your inputs are not converted to ######. Your answers will be converted to ###### if your cash flow/value is greater than 99,999,999,999 (Hint: none of your cash flows/values for Q1-3 in your solution should be that large). The cells you cannot use are coloured grey. This preformatted spreadsheet is designed in such a way to speed up the marking process. For Q1 to 3 enter the cash flow description and the dollar amount in the appropriate cells. Use whole dollars only and ignore cents . We want to be able to easily identify each cash flow. We provide many empty rows – this does not mean you must use all rows. Q4, Q5, Q6, and Q7 can be answered using the vacant cells provided . Please be brief and precise when answering these questions. The student number and name of all group members must be entered into the relevant section of the spreadsheet . You must also nominate one team member as the team leader and supply their tutorial details in the corresponding fields of the spreadsheet. In your solution please do not simply type your answer into the spreadsheet. Where appropriate, you must use Excel functions/formulas within the spreadsheet, this way we can work out what calculations you have done (and provide marks to you). If we cannot understand how you got your answers you increase your chances of losing marks. Page 2
Assignment Instructions 5) Submission: You must save your spreadsheet file with its original “.xlsx” extension. Do not save the spreadsheet in any other format other than “.xlsx” as we are unable to open non-EXCEL file extensions from Canvas. Users of Apple’s Numbers spreadsheet or other programs, you have been warned. You must submit your assignment in Canvas via the “Assignments” navigation tab, and within the “Assignment Information” page. Only one person from the team should submit the assignment (i.e., the team leader). You can submit multiple times but we mark the most recent submission only. Only .xlsx file extensions can be submitted. When submitting your assignment please do the following: 1) Click the “Choose file” button to upload your completed EXCEL spreadsheet. 2) In the “Comments…” section please type the student names and student numbers of all members in your assignment team. 3) Click the blue “Submit Assignment” button to submit your assignment. Page 3
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help