Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hi I need help with question 1 and a solution and explanation in a exel spreadsheet. 25300 Fundamentals of Business Finance - Group Assignment #
Hi I need help with question 1 and a solution and explanation in a exel spreadsheet.
25300 Fundamentals of Business Finance - Group Assignment # Assignment instructions Please read the following information carefully: 1) Due date and time: Monday 9 October 2017 12:00pm (lunchtime). 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 9 text, this ensures that your inputs are not converted to ######. Your answers will be converted to ###### if your cash flow/value is greater than 999,999,999 (Hint: none of your cash flows/values in your spreadsheet 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 in 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. 1 25300 Fundamentals of Business Finance - Group Assignment # 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 nonEXCEL file extensions from UTS Online. Users of Apple's Numbers spreadsheet - 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\Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started