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

Discussionread case study 53 project management at

DISCUSSION Read Case Study 5.3: Project Management at Dotcom.com. Dotcom.com is a software engineering and systems development consulting firm that needs some organizational improvements in the area of project management ...

Create a multi-level work breakdown structurethis

Create a multi-level work breakdown structure This assignment consists of two parts: a project schedule, and a written response. You must submit both parts as separate files for the completion of this assignment. Label e ...

A pure shear deformation is applied to the square element

A pure shear deformation is applied to the square element as shown in the figure such that σ 12  = σ 21  is only nonzero stress component. At load step n, the stress value was σ 12  = 50, and there was no plastic deforma ...

Given is the recommendation cisco system1read the

Given is the recommendation cisco System. 1. Read the recommendations for Cisco Systems Inc. The document is uploaded, names "Cisco Systems -Recommendations". The recommendation/analysis was done by your peers. Your assi ...

Question 1 list the four criteria for assessing the rigor

Question 1: List the four criteria for assessing the rigor of qualitative studies. Imagine that you are planning to conduct in-depth interviews of program participants to assess program effects. For each criterion, give ...

One of the most common reasons for not wanting to adopt a

One of the most common reasons for not wanting to adopt a matrix is the excessive administrative costs and accompanying overhead costs. Would you expect the overhead rates to decrease as the matrix matures? (Disregard ot ...

Selling the idea of implant chips at your schoollets assume

SELLING THE IDEA OF IMPLANT CHIPS AT YOUR SCHOOL Let's assume for a moment that your team is in favor of using implant chips that contain vitally important information such as identification and medical information. Your ...

1 a company often test markets a proposed product in a

1. A company often test markets a proposed product in a specific area or location. Suppose that you wish to test market your new revolutionary Super Wax car wax, which requires only one application for a lifetime finish. ...

Describe the two main physical causes answer number of

Describe the two main physical causes (Answer: Number of particle and interparticle distance or particle density) that make classical Newtonian and classical statistical mechanics inadequate to describe the motion of ele ...

When youre big you can be your own b2b e-market place

WHEN YOU'RE BIG , YOU CAN BE YOUR OWN B2B E-MARKET PLACE Business to Business (B2B) e-marketplaces are the growing trend in the B2B e-commerce business model. Businesses from all industries and countries can gather, perf ...

  • 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

Section onea in an atwood machine suppose two objects of

SECTION ONE (a) In an Atwood Machine, suppose two objects of unequal mass are hung vertically over a frictionless

Part 1you work in hr for a company that operates a factory

Part 1: You work in HR for a company that operates a factory manufacturing fiberglass. There are several hundred empl

Details on advanced accounting paperthis paper is intended

DETAILS ON ADVANCED ACCOUNTING PAPER This paper is intended for students to apply the theoretical knowledge around ac

Create a provider database and related reports and queries

Create a provider database and related reports and queries to capture contact information for potential PC component pro

Describe what you learned about the impact of economic

Describe what you learned about the impact of economic, social, and demographic trends affecting the US labor environmen