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

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
Order Essay

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 paper—including tables and graphs,
headings, title page, and reference page—is
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

Homework Market Pro
Calculate your paper price
Pages (550 words)
Approximate price: -

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!

Calculate the price of your order

Total price:
$0.00

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

Essay Writing Service

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.