Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Financial Accounting

Authors: Richard Lewis, David Pendrill

7th Edition

0273658492, 978-0273658498

More Books

Students also viewed these Finance questions

Question

1. Too reflect on self-management

Answered: 1 week ago

Question

Food supply

Answered: 1 week ago