FINA2006: Principles of Finance

Assessment 2: Excel Practice
Individual/Group Individual
Length
250 words
Learning Outcomes

The Subject Learning Outcomes demonstrated by successful completion of the task below include:
a) To apply financial mathematics to investment evaluation.
b) To apply concepts of risk and return to stock valuation.
c) To apply spreadsheet techniques to financial analysis.

Submission Due by 11:55pm AEST/AEDT Sunday end of Week 9.
Weighting 15%
Total Marks 100 marks

Context:
Assessments 2 assesses students’ understanding of time value of money, capital budgeting and spreadsheet applications. These are examined using a combination of Excel practice tasks and a 250-word summary outlining the steps involved in using Excel spreadsheet to apply financial mathematics. Students are required to conduct independent research on how to use Microsoft Excel to complete the assessment tasks.
Tasks:
You will use Microsoft Excel to complete the two independent tasks for Assessment 2. Working individually, you are required to prepare solutions to all tasks using solely Microsoft Excel. You are also required to prepare a 250-word summary explaining the Excel commends/functions/operations you have used to solve the calculation tasks.

Submission Instructions:
Submit all Assessment 2 tasks (including the 250-word summary) as a single Excel file via the Assessment submission link in the main navigation menu in FINA2006: Principles of Finance. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades. You will answer each task on a separate worksheet using Excel. Before submitting, name the Excel file using only your student number. Do NOT submit any other types of files, only submit one single Excel file containing answers to all tasks. Failure to adhere to these requirements will result in a deduction of 20 marks.

Excel Practice Task 1 (Time Value of Money): (40 marks)
Freddy Fox has just inherited a commercial building that is expected to produce the following cash flows for the next 8 years:
Year 1: $1,000,000; Year 2: $1,200,000; Year 3: $1,400,000; Year 4: $1,600,000;
Year 5: $1,800,000; Year 6: $2,000,000; Year 7: $2,200,000; Year 8: $2,400,000.
However, Freddy Fox would rather receive the same cash flow each year and as such, he approached a bank to sell the commercial building in return for a fixed cash flow each year for the next 8 years. The bank has agreed to this arrangement, based on an interest rate of 10% p.a. compounded monthly applied to the valuation of the commercial building. If this arrangement goes ahead, how much will Freddy Fox receive each year? To answer Task 1, you MUST use Excel commends/functions to do ALL calculations.

Excel Practice Task 2 (Capital Budgeting): (40 marks)
Oil Search is considering a major investment in a new oil field in Western Australia. According to initial estimates, the investment outlay would be $2,500,000 and the project would generate incremental cash flows of $500,000 per year for 9 years. The required rate of return by the investors is 7% p.a. compounded annually.
(a) Calculate the Accounting Rate of Return (ARR) (10 marks)
(b) Calculate the Net Present Value (NPV) (10 marks)
(c) Calculate the Internal Rate of Return (IRR) (10 marks)
(d) Based on (b) and (c) above, should this project be accepted? Why? (10 marks)
To answer Task 2, you MUST use Excel commends/functions to do ALL calculations.

Excel Procedure Summary Task: (20 marks)
Provide a 250-word summary detailing the Excel commends/functions/operations you have used to solve Task 1 and Task 2. In your summary, you must explain clearly each step you performed in using Excel to arrive at the final answers, including the purpose of each calculation and the inbuilt Excel commends/functions employed.

Referencing
It is essential that you use appropriate APA style for citing and referencing research. Please see more information on referencing here in the Academic Writing Guide found via the Academic Skills website.

Academic Integrity
All students are responsible for ensuring that all work submitted is their own and is appropriately referenced and academically written according to the Academic Writing Guide. Students also need to have read and be aware of Torrens University Australia Academic Integrity Policy and Procedure and subsequent penalties for academic misconduct. These are viewable online.
Students also must keep a copy of all submitted materials and any assessment drafts.

Order Now
No Fields Found.
Universal Assignment (February 9, 2023) FINA2006: Principles of Finance. Retrieved from https://universalassignment.com/fina2006-principles-of-finance/.
"FINA2006: Principles of Finance." Universal Assignment - February 9, 2023, https://universalassignment.com/fina2006-principles-of-finance/
Universal Assignment June 18, 2022 FINA2006: Principles of Finance., viewed February 9, 2023,<https://universalassignment.com/fina2006-principles-of-finance/>
Universal Assignment - FINA2006: Principles of Finance. [Internet]. [Accessed February 9, 2023]. Available from: https://universalassignment.com/fina2006-principles-of-finance/
"FINA2006: Principles of Finance." Universal Assignment - Accessed February 9, 2023. https://universalassignment.com/fina2006-principles-of-finance/
"FINA2006: Principles of Finance." Universal Assignment [Online]. Available: https://universalassignment.com/fina2006-principles-of-finance/. [Accessed: February 9, 2023]

Please note along with our service, we will provide you with the following deliverables:

Please do not hesitate to put forward any queries regarding the service provision.

We look forward to having you on board with us.

Get 90%* Discount on Assignment Help

Most Frequent Questions & Answers

Universal Assignment Services is the best place to get help in your all kind of assignment help. We have 172+ experts available, who can help you to get HD+ grades. We also provide Free Plag report, Free Revisions,Best Price in the industry guaranteed.

We provide all kinds of assignmednt help, Report writing, Essay Writing, Dissertations, Thesis writing, Research Proposal, Research Report, Home work help, Question Answers help, Case studies, mathematical and Statistical tasks, Website development, Android application, Resume/CV writing, SOP(Statement of Purpose) Writing, Blog/Article, Poster making and so on.

We are available round the clock, 24X7, 365 days. You can appach us to our Whatsapp number +1 (613)778 8542 or email to info@universalassignment.com . We provide Free revision policy, if you need and revisions to be done on the task, we will do the same for you as soon as possible.

We provide services mainly to all major institutes and Universities in Australia, Canada, China, Malaysia, India, South Africa, New Zealand, Singapore, the United Arab Emirates, the United Kingdom, and the United States.

We provide lucrative discounts from 28% to 70% as per the wordcount, Technicality, Deadline and the number of your previous assignments done with us.

After your assignment request our team will check and update you the best suitable service for you alongwith the charges for the task. After confirmation and payment team will start the work and provide the task as per the deadline.

Yes, we will provide Plagirism free task and a free turnitin report along with the task without any extra cost.

No, if the main requirement is same, you don’t have to pay any additional amount. But it there is a additional requirement, then you have to pay the balance amount in order to get the revised solution.

The Fees are as minimum as $10 per page(1 page=250 words) and in case of a big task, we provide huge discounts.

We accept all the major Credit and Debit Cards for the payment. We do accept Paypal also.

Popular Assignments

BSBWOR502 – Lead and manage team effectiveness

BSBWOR502 – Lead and manage team effectiveness The BSBWOR502 – Lead and manage team effectiveness is a unit of the resource training. Also, it is competency training that helps aspiring team leaders build the necessary skills. Since team leadership in the workplace requires many abilities, this unit provides an approach

Read More »

BUSN 732 Writing Assignment 2

Description This assignment gives you an opportunity to read, summarize, and analyze material to be presented in a short report. Specifically, you are asked to read the five assigned articles on the Canadian Pension Plan (CPP) and make notes on the pros and cons of pension adoption discussed in each

Read More »

Assignment 2: Recorded Presentation

Weighting Percentage: 45% The purpose of this assessment task is to link an Aboriginal and / or Torres Strait Islander artwork with an issue that relates to health and wellbeing of Aboriginal and Torres Strait Islander people and explore the associated cultural and historical factors.  Each student is required to plan, create and submit

Read More »

Assignment 2 Research Proposal

ASSIGNMENT TWO GUIDE The Research Proposal This document contains everything you need to know for your second assignment. Please make sure to read this in full prior to asking any questions on Moodle. Below are the key things covered and the corresponding page numbers for easy access. Assignment 2 Research

Read More »

NUR133 ASSESSMENT 2 – Digital Presentation

NUR133 ASSESSMENT 2 – Digital Presentation (500 words + 10-minute presentation) TASK Select a service or program designed to improve the health outcomes of Aboriginal and/or Torres Strait Islander people and prepare a poster presentation that could be used to develop a brief, engaging education session for your peers. In

Read More »

MGMT2007 Organisational Behaviour

2021, MGMT2007 Organisational Behaviour 3,000-word Major Essay Pick ONE of these major essay questions to write an essay: Topic 1: Dealing with problems in an organisation under organisational change Example Scenario: Organisation X has implemented some drastic organisational changes recently. As a result, some of its employees have been laid

Read More »

NSB204 MENTAL HEALTH: Self and Others

Assessment Task 2 Assessment name: Case Study Task description: This assignment aims to help you to begin to use your professional and clinical judgement to think like nurses working in a mental health setting and/or in relation to the mental health needs of people regardless of the setting.   Choose

Read More »

MBA600 Business Report Individual written analysis

Assessment 2 Information Subject Code: MBA600 Subject Name: Capstone: Strategy Assessment Title: Assessment Type: Length: Business Report Individual written analysis 2000 words (+/- 10% allowable range) Weighting: 35% Total Marks: Submission: 100 Online Due Date: Week 10 Your task Using the same organisation from the first assessment, individually, you are

Read More »

HNN300 Child and Adolescent Health Assessment

Task 1: Written Assignment 1500 words (40%) Purpose of assessment task Childhood immunisation is a critical public health intervention that helps protect health and support normal development in infants, children, and young people. This assignment is designed to help you to analyse data, assess risk, and to develop skills to

Read More »

Importance of Aboriginal language

Due Date: 12 hrs   Format/Length: 800 words written Purpose: To explore, deconstruct and analyses the importance of Aboriginal language(s) in a contemporary context.  Task: You are to select an Aboriginal language initiative to research and develop your knowledge and understanding on the importance of keeping languages alive. This can

Read More »

Diverse Populations and Nursing Practice Reports

WORD LIMIT – 2500 – no introduction and conclusion required 7 headings required – headings, text-citations,                1200 words 1) Social determinants of health – 300 words 2) Health inequalities – 300 words 3) Health inequities – 300 words 4) Health outcomes – 300 words 1200 words 5) Application of

Read More »

Chronic Diseases

Introduction: The term “chronic disease” is increasingly often used by patients, healthcare professionals, researchers, etc. This term is defined differently by each person, and each definition encompasses a different set of medical disorders. Last but not least, the World Health Organization asserts that chronic illnesses are not contagious. They progress

Read More »

3. REPORT – Essay

STUDENT INSTRUCTIONS You are required to write a report as outlined in the assessment instruction and criteria listed below. It is important to ensure you read all aspects of the assessment topics and discuss any areas that require clarification with your assessor. Where there is a word limit it is

Read More »

Quality Areas 2 and 5 of the National Quality Standard

Access and review each of the Quality Areas in the ACECQA website, and for each of the given elements, provide one requirement that the element requires from an early years learning centre. You can access the page on the Quality Areas of the NQS using the link below: Quality Area

Read More »

National Health and Medical Research Council

Element Underpinning regulation from National Regulations Requirement of the regulation Underpinning section from the ECSNL Requirements of the section Element 2.1.1: Wellbeing and comfort         Element 2.2.1: Supervision         Element 5.1.1: Positive educator to child interactions         Element 5.2.2: Self-regulation  

Read More »

International Health and Development

Assessment Brief Module title: International Health and Development Assessment Point: First assessment point Assessment task: PART A: PowerPoint Presentation: 15 slides PART B: Word document: 1000-word count limit script for the slides Submission deadline: Please consult the VLE. Submission procedure: Please submit via the submission link on the VLE. Submission

Read More »

Outline the historical development of the policy

Outline the historical development of the policy including other linked policies highlighting key changes The Disability Support Pension is Australia’s universal health insurance scheme that guarantees all people who are unable to work due to a physical, mental, or intellectual disability financial help, which is a payment administered by Centrelink (Legal Services

Read More »

 SITHCCC027 – Prepare dishes using basic methods of cookery

Student Name  Student ID  Unit Name   SITHCCC027 – Prepare dishes using basic methods of cookery Practical Date  Submission Date  Student Declaration ☐ Student Plagiarism Declaration: By submitting this assessment to the college, I declare that this assessment task is original and has not been copied or taken from another source

Read More »

SITHCCC027 – Prepare dishes using basic methods of cookery

Student Name    Student ID   Blc01102 Unit Name   SITHCCC027 – Prepare dishes using basic methods of cookery Practical Date   07/02/2023 Submission Date    Student Declaration ☒ Student Plagiarism Declaration: By submitting this assessment to the college, I declare that this assessment task is original and has not been copied or

Read More »

Resource – Health promotion resource

ASSESSMENT:-             Resource – Health promotion resource Due date: – 10th August 2021   Length: – N/A Type of Collaboration:-                Individual Assessment Details It is the nurse’s role to provide information and education to enhance people’s control over their health (NMBA, 2016). The purpose of this assessment is to produce a

Read More »

The Aged Care Royal Commission Final Report

Discussion PAPER Assignment References 8 Australian Harvard 800 words  due 10th august The Aged Care Royal Commission Final Report titled Care, Dignity and Respect has now been released. The report calls for significant reforms to Australia’s aged care system. The final report also makes 148 recommendations for reform. In this

Read More »

HC3131 Business Research Project

Assessment Details and Submission Guidelines Trimester T2 2021 Unit Code HC3131 Unit Title Business Research Project Assessment Type 1, Topic Approval, Presentation Assessment Title Topic Approval Purpose of the assessment (with ULO Mapping) 1.Clearly identify your chosen topic, having carried out some basic review of available secondary data to secure

Read More »

Cases: Assessment Task 2

Case 1 Tina Tina is 18 years old and lives with her grandmother, older brother and two younger sisters. At present no one has a full-time job with both the grandmother and older brother currently on welfare. The two younger sisters currently enrolled in high school. Tina’s mother lives in

Read More »

NURBN3030 Supplementary Assessment

Written Case Study Report Application of health assessment, planning, implementation and evaluation of professional nursing care to a clinical deterioration patient scenario Due date:         As specified by the Course Coordinator Weighting:       Students must achieve a Pass grade (50%) for the Supplementary Assessment to achieve a Pass grade overall for the

Read More »

Competitive Advantage Video Project

Assessment 1 Information Subject Code: MBA600 Subject Name: Capstone: Strategy Assessment Title: Assessment Type: Length: Competitive Advantage Video Project Individual video recording 10 minutes (no more) Weighting: 25% Total Marks: Submission: 100 Online Due Date: Week 6 Your task Individually, you are required to record a 10-minute video, in which

Read More »

Analysis of Foundational Theory of Management

Class: Day and Time   Lecturer name   Student name / ID   ASSESSMENT 1 (30%) Written – Individual   Due:  Week 4 – Sunday, 15 August 2021 @ 23:59 Analysis of Foundational Study of Management – in the context of contemporary multidisciplinary business This assessment task is designed to address

Read More »

Relating the Class to World Events

Submit your assignment soon Even though your assignment is due on Aug 23, 4:59 PM AEST, try to submit it 1 or 2 days early if you can. Submitting early gives you a better chance of getting the peer reviews you need in time. Topic: Relating the Class to World

Read More »

Can't Find Your Assignment?

Open chat
1
Free Assistance
Universal Assignment
Hello 👋
How can we help you?