FIN 571 University of Phoenix Project cash flow Assignment NO PLAGIARISM

FOLLOW THE INSTRUCTIONS

Don't use plagiarized sources. Get Your Custom Essay on

FIN 571 University of Phoenix Project cash flow Assignment NO PLAGIARISM
FOLLOW THE INSTRUCTIONS
ATTACHED ARE EXAMPLES AND THE GRADING GUIDE
Purpose of

Just from $13/Page

ATTACHED ARE EXAMPLES AND THE GRADING GUIDE

Purpose of Assignment

The purpose of this assignment is to allow the student to calculate the project cash flow using net present value (NPV), internal rate of return (IRR), and the payback methods.

VERY IMPORTANT – TWO SUBMISSIONS ARE REQUIRED FOR THIS ASSIGNMENT

Step 1 – (Submit as a WORD document in APA format)

Create a memo to management. Memo must include the four main headings (To, From, Date & Subject). Word has templates that you can download. Use a business or professional template. Your outline for your paper should look similar to the following:

· Intro

· Internal Rate of Return (include description of method, advantages & disadvantages)

· Net Present Value (include description of method, advantages & disadvantages)

· Payback Method (include description of method, advantages & disadvantages)

· Conclusion

· References

Each point above should be a paragraph containing 4-5 sentences, with the exception of the references page. There are required references for each assignment. Those are given to you below. So, all you need to do is copy, paste and then proceed to double-space, alphabetize and format into a hanging indent. You should not need to use other references. But if you do, format those using the Reference and Citation Generator Tool (see link below).

Minimum required references include your textbook. The textbook reference is as follows:

Ross, S., Westerfield, R., Jaffe, J. & Jordan, B. (2016). Corporate finance (11th edition). New York, N.Y. McGraw-Hill Education.

Step 2 – (Submit as an EXCEL spreadsheet)

Calculate the following time value of money problems. The calculations must be done in Excel. You must show your work. If you submit these in Word, you will not receive credit. If you do not show your work, you will not receive credit. Examples are provided above for review prior to starting this assignment. FOLLOW MY EXAMPLES!

If you want to accumulate $500,000 in 20 years, how much do you need to deposit today that pays an interest rate of 15%?

What is the future value if you plan to invest $200,000 for 5 years and the interest rate is 5%?

What is the interest rate for an initial investment of $100,000 to grow to $300,000 in 10 years?

If your company purchases an annuity that will pay $50,000/year for 10 years at a 11% discount rate, what is the value of the annuity on the purchase date if the first annuity payment is made on the date of purchase?

What is the rate of return required to accumulate $400,000 if you invest $10,000 per year for 20 years. Assume all payments are made at the end of the period.

See table below. What is the project cash flow generated for Project A and Project B using the NPV method? Which would you choose and why? Assume a 10% discount rate.

See table below. What is the payback period for Project A and Project B using the payback method? Which would you choose and why?

Table shows investments and returns for Project A and Project B. Project A has $10,000 initial investment with $5,000 returns in each of the first 3 years. Project B has $55,000 initial investment with $20,000 in each of the first 3 years.

Resources

Center for Writing Excellence

Reference and Citation Generator

Grammar and Writing Guides

Learning Team Toolkit

Copyright 2018 by University of Phoenix. All rights reserved. #1 – PRESENT VALUE OF SINGLE LUMP SUM

If you want to accumulate $5,000 in 10 years, how much do you need to deposit today that pays an

interest rate of 2%? This means ONE single lump sum invested at ONE time.

If they are asking you to find the value TODAY, this means they are asking you to find the

PRESENT VALUE. So, use your PV function in Excel as you are dealing with compounded interest.

Click formulas, insert function, financial, PV.

Variables are as follows:

Rate: .02 (this is your annual rate of interest)

Nper: 10 (this is the total number of compounding periods – in this case, you have been earning

interest on an annual basis for 10 years)

Pmt: 0 (not applicable as there are no payments)

FV: 5000 (this is your future value or value at the end of the period)

Click ok and you should get $4101.74 as your PV (ignore the negative as the negative in a PV

value for Excel simply means money out or the initial investment “out” of your pocket).

#2 – FUTURE VALUE OF SINGLE LUMP SUM

What is the future value if you plan to invest $1,000 for 7 years and the interest rate is 10%? This

means ONE single lump sum invested at ONE time.

Use your FV function in Excel. Click formula, insert function, financial, FV. Variables are as follows:

Rate: .10 (this is your annual rate of interest)

Nper: 7 (this is the total number of compounding periods – in this case, you have been earning

interest on an annual basis for seven years)

Pmt: 0 (not applicable as there are no payments)

PV: -1000 (this is the value at the beginning of the period – remember to enter as a negative in Excel

to indicate money out since this was your initial investment “out” of your pocket)

Click ok and you should get $1948.72 as your FV.

#3 – RATE OF INTEREST EARNED

What is the interest rate for an initial investment of $1050 to grow to $1500 in 1 year?

Use your RATE function in Excel. Click formulas, insert function, financial, RATE.

Variables are as follows:

Nper: 1 (this is the total number of compounding periods – in this case, you have been earning

interest on an annual basis for one year only)

Pmt: 0 (not applicable to this problem)

PV: -1050 (this is the value at the beginning of the period – remember to enter as a negative in Excel

to indicate money “out”)

FV: 1500 (this is the future value or value at the end of the period)

Click ok and you should get .4286 or 42.86% as your rate.

#4 – PRESENT VALUE OF PAYMENTS

If your company purchases an annuity that will pay $1,000/year for 20 years at a 15% discount rate,

what is the value of the annuity on the purchase date if the first annuity payment is made on the date

of purchase?

If they are asking you to find the value TODAY (in this case they say value on the purchase date

which is TODAY), this means they are asking you to find the PRESENT VALUE. So, use

your PV function in Excel as you are dealing with compounded interest. Note however, they are

asking you to find the PV of the series of payments and not the value in the future. Also, this

is VERY IMPORTANT, they say that the first payment is made on the date of purchase. So that

means that this payment is made IN ADVANCE as there wasn’t time for interest accrue. So, you will

need to note that under your Type variable. Click formulas, insert function, financial, PV.

Variables are as follows:

Rate: .15 (this is your annual rate of interest)

Nper: 20 (this is the total number of compounding periods – in this case, you have been earning

interest on an annual basis for 20 years)

Pmt: 1000 (this is the amount of each payment you will receive)

FV: 0 (this is your future value or value at the end of the period – in this case, there is no future value

as when the payments are done, the annuity is worth zero)

Type: 1 (this means that the first payment was made in advance or prior to interest accruing – read

the problems carefully as some payments are made in advance and some are made at the end of

the period which is the norm so in those cases you would simply ignore the type variable)

Click ok and you should get $7198.23 as your PV (ignore the negative as the negative in a PV

value for Excel simply means money out or the initial investment “out” of your pocket).

#5 RATE OF INTEREST EARNED

What is the rate of return required to accumulate $3000 if you invest $100 per year for 10 years.

Assume all payments are made at the end of the period. Note that payments are made at the end

of the period so we can ignore the type variable.

Use your RATE function in Excel. Click formulas, insert function, financial, RATE.

Variables are as follows:

Nper: 10 (this is the total number of compounding periods – in this case, you have been earning

interest on an annual basis for one year only)

Pmt: -100 (this is the amount of the payment you will make so it is money “out” of your pocket so it

needs to be noted with a negative)

PV: 0 (this is the value at the beginning of the period and there is no lump sum value today to worry

about as all you are doing is making series of payments)

FV: 3000 (this is the future value or value at the end of the period)

Click ok and you should get .2292 or 22.92% as your rate.

#6 – NPV CALCULATION

What is the net present value of a project with an initial cost of 50000 and cash inflows of 10000,

15000 and 25000 with a discount rate of 10%.

For this problem, PIECE OUT THE CASH FLOWS. So your equation here is:

Net Present Value = Purchase Price + Present Value of Cash Flows or abbreviated as PP + PVCF

PP: -50000 (This is given and in your equation, this should be a negative to indicate money out as

this is an outflow.)

PVCF: Use Excel and the NPV function. Click formula, insert function, financial, NPV. Variables are

as follows:

Rate: .10 (This is your discount rate in DECIMAL form.)

Value 1: 10000 (first year cash flow)

Value 2: 15000 (second year cash flow)

Value 3: 25000 (third year cash flow)

Click ok and you should get 40270.47 as your PVCF value.

Now all you do is add your PP and PVCF values together (round to 2 decimals) and you should be

good to go.

NPV = PP + PVCF

NPV = -50000 + 40270.47

NPV = -9729.53

This project should actually be REJECTED as the NPV is negative. If you had a choice

between two mutually exclusive projects, you would choose the one with the higher NPV.

#7 – PAYBACK CALCULATION

Danica, Inc has the following mutually exclusive projects:

Year Project A Cash Flows Project A Cumulative Inflows Project B Cash Flows Project B Cumulative Inflows

0

-20000

NA

-23000

NA

1

12000

12000

13000

13000

2

3

8500

2900

20500

23400

9500

8500

22500

31000

What is the payback? Which would you choose?

Payback is simply the amount of time it takes for the inflows to equal your original outflow (initial

investment). This does NOT take into account time value of money, so no Excel formulary is

necessary. Review the chart above. I added a couple of columns above to tally the Cumulative

Inflows for each project as I like to lay out my variables at the beginning and see how the totals pan

out.

For project A, you can see that payback is going to be before the end of Year 2 (this is the year you

would recoup your 20000), but what fractional part of Year 2?

So, you have ONE full year and a partial of the second year.

Payback Period = Number of Full Years + (Initial Investment – Full Year(s) Cumulative Inflow)/Cash

Flow in Year of Payback

Payback Period = 1 + (20000-12000)/8500

Payback Period = 1 + (8000/8500)

Payback Period = 1+.9411

Payback Period = 1.941 years

For project B, you can see that payback is going to be before the end of Year 3 (this is the year you

would recoup your 23000), but what fractional part of Year 3?

So you have TWO full years and a partial of the third.

Payback Period = Number of Full Years + (Initial Investment – Full Year(s) Cumulative Inflow)/Cash

Flow in Year of Payback

Payback Period = 2 + (23000-22500)/8500

Payback Period = 2 + (500/8500)

Payback Period = 2+.0588

Payback Period = 2.059 years

Since Project A has a shorter payback, that is your winner!

Using the Payback Method, IRR and NPV

Grading Guide

FIN/571 Version 9

Foundations of Corporate Finance

Copyright

Copyright © 2017, 2016, 2013 by University of Phoenix. All rights reserved.

University of Phoenix® is a registered trademark of Apollo Group, Inc. in the United States and/or other countries.

Microsoft®, Windows®, and Windows NT® are registered trademarks of Microsoft Corporation in the United States and/or other countries. All

other company and product names are trademarks or registered trademarks of their respective companies. Use of these marks is not intended

to imply endorsement, sponsorship, or affiliation.

Edited in accordance with University of Phoenix® editorial standards and practices.

Using the Payback Method, IRR

and NPV Grading Guide

FIN571 Version 9

Individual Assignment: Using the Payback Method, IRR and NPV

Purpose of Assignment

The purpose of this assignment is to allow the student to calculate the project cash flow using net present value

(NPV), internal rate of return (IRR) and the payback methods.

Resources Required

Corporate Finance

Grading Guide

Content

Met

Partially

Met

Not

Met

Total

Available

Total

Earned

Created a 350-word memo to management describing the use of

internal rate of return (IRR), net present value (NPV) and the

payback method in evaluating project cash flows. Described the

advantages and disadvantages of each method.

Calculated the following time value of money problems:

1. If you want to accumulate $500,000 in 20 years, how

much do you need to deposit today that pays an interest

rate of 15%?

2. What is the future value if you plan to invest $200,000 for

5 years and the interest rate is 5%?

3. What is the interest rate for an initial investment of

$100,000 to grow to $300,000 in 10 years?

4. If your company purchases an annuity that will pay

$50,000/year for 10 years at a 11% discount rate, what is

the value of the annuity on the purchase date if the first

annuity payment is made on the date of purchase?

5. What is the rate of return required to accumulate

$400,000 if you invest $10,000 per year for 20 years.

Assume all payments are made at the end of the period.

Calculated the project cash flow generated for Project A and

Project B using the NPV method. Which project would you select,

and why? Which project would you select under the payback

method? The discount rate is 10% for both projects. Used

Microsoft® Excel® to prepare the answer. Note that a similar

problem is in the textbook in Section 5.1.

Showed all work.

Comments:

2

Using the Payback Method, IRR

and NPV Grading Guide

FIN571 Version 9

Met

Content

Writing Guidelines

Met

Partially

Met

Not

Met

4

#/4

Partially

Met

Not Met

Total

Available

Total

Earned

2

#/2

6

#/6

The paperincluding tables and graphs,

headings, title page, and reference pageis

consistent with APA formatting guidelines and

meets course-level requirements.

Intellectual property is recognized with in-text

citations and a reference page.

Paragraph and sentence transitions are

present, logical, and maintain the flow

throughout the paper.

Sentences are complete, clear, and concise.

Rules of grammar and usage are followed

including spelling and punctuation.

Assignment Total

Additional comments:

#

Comments:

Comments:

3

Purchase answer to see full

attachment

Our Unique Features

Custom Papers Means Custom Papers

This is what custom writing means to us: Your essay starts from scratch. Plagiarism is unacceptable. We demand the originality of our academic essay writers and they only deliver authentic and original papers. 100% guaranteed! If your final version is not as expected, we will revise it immediately.

Qualified and Experienced Essay Writers

Our team consists of carefully selected writers with in-depth expertise. Each writer in our team is selected based on their writing skills and experience. Each team member is able to provide plagiarism-free, authentic and high-quality content within a short turnaround time.

Free Unlimited Revisions

If you think we missed something, send your order for a free revision. You have 10 days to submit the order for review after you have received the final document. You can do this yourself after logging into your personal account or by contacting our support.

Prompt Delivery and 100% Assuarance

We understand you. Spending your hard earned money on a writing service is a big deal. It is a big investment and it is difficult to make the decision. That is why we support our claims with guarantees. We want you to be reassured as soon as you place your order. Here are our guarantees: Your deadlines are important to us. When ordering, please note that delivery will take place no later than the expiry date.

100% Originality & Confidentiality

Every paper we write for every order is 100% original. To support this, we would be happy to provide you with a plagiarism analysis report on request.We use several writing tools checks to ensure that all documents you receive are free from plagiarism. Our editors carefully review all quotations in the text. We also promise maximum confidentiality in all of our services.

24/7 Customer Support

We help students, business professionals and job seekers around the world in multiple time zones. We also understand that students often keep crazy schedules. No problem. We are there for you around the clock. If you need help at any time, please contact us. An agent is always available for you.

Try it now!

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Our services are second to none. Every time you place an order, you get a personal and original paper of the highest quality.

Essays

While a college paper is the most common order we receive, we want you to understand that we have college writers for virtually everything, including: High school and college essays Papers, book reviews, case studies, lab reports, tests All graduate level projects, including theses and dissertations Admissions and scholarship essays Resumes and CV’s Web content, copywriting, blogs, articles Business writing – reports, marketing material, white papers Research and data collection/analysis of any type.

Admissions

Any Kind of Essay Writing!

Whether you are a high school student struggling with writing five-paragraph essays, an undergraduate management student stressing over a research paper, or a graduate student in the middle of a thesis or dissertation, homeworkmarketpro.com has a writer for you. We can also provide admissions or scholarship essays, a resume or CV, as well as web content or articles. Writing an essay for college admission takes a certain kind of writer. They have to be knowledgeable about your subject and be able to grasp the purpose of the essay.

Reviews

Quality Check and Editing Support

Every paper is subject to a strict editorial and revision process. This is to ensure that your document is complete and accurate and that all of your instructions have been followed carefully including creating reference lists in the formats APA, Harvard, MLA, Chicago / Turabian.

Reviews

Prices and Discounts

We are happy to say that we offer some of the most competitive prices in this industry. Since many of our customers are students, job seekers and small entrepreneurs, we know that money is a problem. Therefore, you will find better prices with us compared to writing services of this calibre.