Purpose of
Assignment
The purpose of this
assignment is to allow the students to become familiar with and practice the
measurement of Net Present Value (NPV), payback, and Weighted Average Cost of Capital
(WACC) using Microsoft® Excel®.
Assignment
Steps
Resources: Microsoft®
Excel®, Capital Budgeting Decision Models Template
Calculate the
following problems using Microsoft® Excel®:
Calculate the NPV
for each project and determine which project should be accepted.
Your
company is considering three independent projects. Given the following cash
flow information, calculate the payback period for each. If your company
requires a three-year payback before an investment can be accepted, which project(s)
would be accepted?
Using
market value and book value (separately), find the adjusted WACC, using 30% tax
rate.
“Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!”
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but splendidwritings.com proved they are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 14***| Rating: ⭐⭐⭐⭐⭐
"The company has some nice prices and good content. I ordered a term paper here and got a very good one. I'll keep ordering from this website."
