Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Project Management Expert

Objective: This task will give you some experience using common time value of money related finance methods.
 
Specific Requirements for this Assignment:
 
1) You should use Microsoft Excel software for this assignment.

2) Submit a Microsoft Excel workbook titled SEB324 A3 Part 4.xlsx (or .xls)

3) Provide the computations and answers for all problems with one sheet in the workbook used for each problem. So that means your single submitted workbook file should consist of two spreadsheets. Label each spreadsheet in your workbook file respectively as problem 1 and problem 2.

4) Provide all answers to two decimal places and/or the nearest cent.

problem 1: You receive an offer in the mail from the Norman Harvey Bank inviting you to apply for a new personal loan. The offer invites you to access immediately up to $20,000 on this special personal loan with the principal amount to be repaid in full plus all accumulated interest in 24 months’ time. (There are no interim repayments to be made between now and when the total amount is due in 24 months’ time.) Interest will be computed on a monthly compounding basis at 0.72% per month. 
 
Also in the mail you have received an offer from the West Bank inviting you to apply for a new term deposit account which pays a nominal interest rate of 8.65% p.a. computed monthly on a compounding basis. The minimum initial deposited amount required is $20,000 and any deposits must be left in the account for a minimum of 24 months. 
 
You are considering applying for the personal loan from the Norman Harvey Bank in order to immediately invest the entire $20,000 into the West Bank term deposit account being offered. Does this investment opportunity offer a worthwhile positive return on investment from combining these two offers? Would you recommend this opportunity? Justify your answer.

problem 2: You have been asked to evaluate the financial viability of three investment options for your company. You are asked to use the Simple Payback, IRR, and NPV methods to evaluate the options and make a recommendation on which of them, if any, to proceed with. The selection of any option is mutually exclusive. Perform simple payback, IRR, and NPV analyses on the investment options.
 
The expected nominal cashflows for Years 1 through 5 produced by each investment option are provided in the table below. The initial amount required for all three-investment options is $15,000. For the NPV analysis assume a cost of capital of 10% p.a. For the IRR analyses assume the minimum rate of return required for any option to be considered viable is 15% p.a.

1324_nominal cash flows.jpg

Which investment option, if any, would you recommend and why? Justify your answer.

Project Management, Management Studies

  • Category:- Project Management
  • Reference No.:- M9348

Have any Question? 


Related Questions in Project Management

It project management techniques assignmenttask - team

IT Project Management Techniques Assignment Task - Team Project Management Plan. Objectives - This assessment task relates to the following course objectives: Identify traditional and agile approaches and lifecycles for ...

Final project frameworkin order to fulfill all parts of

Final Project Framework In order to fulfill all parts of this assignment, you must complete and submit the Assignment Worksheet. This assignment is meant to help you get your Final Project started by: • Focusing on your ...

Assignment - course objectivesthis assessment task relates

Assignment - Course Objectives This assessment task relates to the following course objectives: - Identify traditional and agile approaches and lifecycles for managing information technology projects; - Employ a systems ...

Project managementpreviously in the course you were asked

Project Management Previously in the course, you were asked to think of a project you have been involved with at your place of employment. Think of that same project, imagine that you have been appointed the project mana ...

Change management communication and leadershipduring this

Change Management Communication and Leadership During this course, you have developed many of the artifacts utilized by project managers. You have learned that, contrary to common misconceptions, project managers are inv ...

Fundamentals of project managementdefining the projectusing

Fundamentals of Project Management Defining the Project Using the South University Online Library or the Internet, research, select, and scope out any project of your choice. The project you select must meet the followin ...

As an hr manager discuss ways you can promote a wellness

AS an HR manager, discuss ways you can promote a wellness program for all employees and encourage them to join? What incentives can you use to encourage participation without making it mandatory to join? What are the ben ...

Assignment - reflection writingquestion 1in module 1 the

Assignment - Reflection Writing (Question 1): In Module 1, the first required assignment asked you to examine the course and relate it to a current, real-world event or recent news story. Based on what you have learned i ...

Part ayou are wishing to breed sheep for increased fleece

Part A: You are wishing to breed sheep for increased fleece weight. Fleece weight is measured annually, beginning at 12 months of age. Heritability for fleece weight is 31%, repeatability is 50% and genetic standard devi ...

Theeggbot project according to the youtube video from the

TheEggBot project, according to the YouTube video from the reference, it is slow and shaky. We assume it was poorly designed so it ended up with shakiness. In addition, we think the slowness is a result of the programing ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate