Hi there! As long as you understand capital budgeting, this should take around an hour to do.
I have attached the assignment brief, the two lectures the question is based on (in case you need to revise the content) as well as the preformatted excel that you need to fill in.
Case Study 25300 Fundamentals of Business Finance – Group Assignment 1 # Assignment instructions Please read the following information carefully: 1) Due date and time: Monday 8 October 2018 11:00am. 2) Weight: 20% of total grade. 3) Team formation: 3, 4 or 5 students per team. Teams may consist of members from different tutorials. We encourage team members to be all from the same tutorial so you can assess a potential team member’s level of dedication to the subject, and their likely contribution to the group assignment. 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. 4) Preformatted blank excel spreadsheet: You must record your answers in the provided blank excel spreadsheet (available on UTS Online). 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 9,999,999,999 (Hint: none of your cash flows/values for Q1-4 in your solution should be that large). The cells you cannot use are coloured grey. This preformatted spreadsheet is designed so that it will print on one double-sided A4 page, this is done to speed up the marking process allowing us to provide you with faster feedback. For Q1 to 3 enter the cash flow description and the dollar amount in the appropriate cells. Use whole dollars only and ignore cents. There are more rows than are required so if you’ve used all of the rows then it means you’ve got too many cash flow items. Please do not group cash flows into the same cell. We want to be able to easily identify each cash flow. Here is an example of how to report cash flows over the life of the project: Q4 and Q5 can be answered using the vacant cells provided. 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. Marked spreadsheets will be returned in the nominated tutorial only. 25300 Fundamentals of Business Finance – Group Assignment 2 # Assignment instructions: 5) Submission: Please 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 UTS Online. Users of Apple’s Numbers spreadsheet or other programs – you have been warned. You must submit your assignment by: 1) Submitting your team’s answer spreadsheet using the “Assignments” feature available under the Assignments folder on UTS Online. To submit, click on “Assignment submission”, click on “Browse My Computer” to open and attach your spreadsheet and then click the “Submit” button, that’s it! Check your gradebook (“Tools” -> “My Grades”) to verify that your spreadsheet has been submitted correctly. The date and time will be displayed along with an exclamation mark (!). If you have a padlock symbol it means you did not correctly submit your spreadsheet, so please try again. This information only appears in the gradebook of the student who submitted the spreadsheet. Please note we will only consider the first electronic submission that you make, therefore, make sure it is your final submission. AND, 2) Submitting a printed copy of your team’s answer spreadsheet in the nominated Assignment box “FINANCE 2” on level 5 of Building 8 of the Dr Chau Chak Wing Building (next to the lift lobby). If you would like to submit your assignment early, or whilst you are at UTS for FBF classes, the assignment box will be open from 3 October 2018. You must print your assignment as one A4 page with double sided printing. A map detailing the assignment box location is available under the Assignments folder on UTS Online. All team members must provide their signature in the space provided on the spreadsheet on the printed copy of your assignment only (your signature is not required for the online submission). 6) Assignment queries: We will not answer queries about the assignment content in person or by email (email is acceptable for only questions of personal/private nature). Assignment queries belong on UTS Online because everyone benefits from your question and answer (whether the answer is given by us or another student). Please refer to the paragraph number in the assignment details below when asking a query on UTS Online. We will not provide direct “yes/no” answers to your queries. Please read the existing posts on the discussion board before posting your query as it is likely to have been answered already (especially when we approach the submission date). In addition, please check the discussion board as we will clarify any perceived ambiguities in the assignment questions. It is not a sufficient excuse to ex-post make a complaint about the assignment because you have not been pro-active in seeking clarification via the discussion board. Of course we greatly encourage your queries! 25300 Fundamentals of Business Finance – Group Assignment 3 # Assignment instructions: 7) You will receive a zero mark for the assignment if any of the following apply to your team’s submission: 1) Failure to submit the assignment by the due time and due date. Please note that you have been given a sufficient amount of time to complete the assignment. 2) Failure to submit your assignment using the preformatted spreadsheet available on UTS Online. 3) You do not submit your assignment both via the Assignments feature on UTS Online and you do not submit a printed copy of your assignment in the nominated Assignment box. 4) Failure to comply with the required number of team members. Please note that you have been given sufficient time to form groups with like-minded individuals. 5) If your name appears on multiple assignment submissions. It is every team member’s responsibility to ensure that the assignment meets such requirements. Please contact the subject coordinator to discuss exceptional circumstances that may arise. 8) Statement on plagiarism: I refer you to the subject outline to make sure you are familiar with UTS’ statement on plagiarism. In a nutshell, do not copy another team’s solutions and do not share your assignment with another group. Please note that when you submit the assignment you are declaring that your assignment submission is plagiarism-free. Please note that even if one member of the team demonstrates plagiarism (without the knowledge of the other team members), this will lead to problems for all team members. You do not want to be responsible for causing issues to your team members. Last semester several teams were caught for plagiarism. All of these students did not think they would be caught and they seriously regret their actions. The students from all of the teams (guilty and non-guilty) are still awaiting their results which is affecting their ability to enrol in subsequent subjects. Some examples of penalties for plagiarism include: sanctions, having to redo the subject, and fees incurred to retake the subject. I don’t want to come across as the bad guy but you have been warned. 25300 Fundamentals of Business Finance – Group Assignment 4 Assignment information: Your team must answer the following five questions. Questions 1 to 4 require information relating to the capital budgeting decision of the QANTA Dreamflyer planes. Question 5 (detailed below on page 9) is a time value of money (TVM) problem for QANTA, this question is unrelated to QANTA’s Dreamflyer planes capital budgeting decision. Capital Budgeting Information (17 Marks) Present an itemised breakdown (and the total) for each of the following: Q1. The cash flows at the start. Q2. The cash flows over the life. Q3. The cash flows at the end. Q4. The NPV of the Dreamflyer planes and a short explanation of your recommendation. Congratulations, you were hired as a financial analyst for QANTA following your studies at the University of Technology Sydney. QANTA is the national carrier of Australia. You fought off tough competition for the job, the recruitment team selected you for your personable character, analytical mind, ability to solve problems, and experience of working well in teams. You have really impressed senior management with your finance knowledge and ability to get the job done. As a result, the Chief Financial Officer (CFO) Lionel Messi has asked you to perform a capital budgeting analysis of new Dreamflyer planes. The Dreamflyer planes will be the first planes capable of flying from Sydney to London non-stop. QANTA are only considering introducing the Dreamflyer planes for the Sydney to London route. In order to conduct your analysis you will need to collect information from different departments of the firm. The information that you have collected is detailed in the numbered paragraphs below (figures are in AUD). It is your job as a financial analyst to decipher which information is relevant to the capital budgeting analysis. Upon completion, you will present your analysis to the Board of Directors who will approve/decline investment in the new planes. Information gathered from various departments: 1. Five years ago QANTA paid $50,000 to Beckham & Co consultants to investigate demand for the Dreamflyer planes. The highlights from the report suggest that there is high demand for a non-stop service from Sydney to London (in particular for business travellers) and during the European spring and summer seasons. In addition, survey respondents indicated that reduced travel time and increased comfort would be a very attractive feature of the Dreamflyer planes, especially for a non-stop flight. 25300 Fundamentals of Business Finance – Group Assignment 5 2. Based on