Even complicated and confusing topics will be easily developed and covered if you request our help writing an essay. Place an order today!

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

Calculatethe following problems using Microsoft ®Excel ®:

  • Calculate the NPV for each project and determine which project should be accepted.
Project A Project B Project C Project D
Inital Outlay (105,000.000) (99,000.00) (110,000.00) (85,000.00)
Inflow year 1 53,000.00 51,000.00 25,000.00 45,000.00
Inflow year 2 50,000.00 47,000.00 55,000.00 50,000.00
Inflow year 3 48,000.00 41,000.00 15,000.00 30,000.00
Inflow year 4 30,000.00 52,000.00 21,000.00 62,000.00
Inflow year 5 35,000.00 40,000.00 35,000.00 68,000.00
Rate 7% 10% 13% 18%
  • 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?
Project D Project E Project F
Cost 205,000.00 179,000.00 110,000.00
Inflow year 1 53,000.00 51,000.00 25,000.00
Inflow year 2 50,000.00 87,000.00 55,000.00
Inflow year 3 48,000.00 41,000.00 21,000.00
Inflow year 4 30,000.00 52,000.00 9,000.00
Inflow year 5 24,000.00 40,000.00 35,000.00
  • Using market value and book value (separately), find the adjusted WACC, using 30% tax rate.
Component Balance Sheet Value Market Value Cost of Capital
Debt 5,000,000.00 6,850,000.00 8%
Preferred Stock 4,000,000.00 2,200,00.00 10%
Common Stock 2,000,000.00 5,600,000.00 13%

Clickthe Assignment Files tab to submit your assignment.

testimonials icon
 Use the job description from the individual assignment in Week Two to complete this paper.  The topic for week two is  ...
testimonials icon
Running head: SPIRITUALITY AND SOCIAL WORK1Spirituality and Social Work PracticeNameClassDateProfessorSPIRITUALITY AND SOCIAL WORK2Spirituality and S...
testimonials icon
Running Head: THE EQUALITY PAY ACT OF 1963The Equality Pay Act of 1963Student NameInstitutional AffiliationDate12THE EQUALITY PAY ACT OF 1963The Equa...
testimonials icon
make sure to mention the famous presidents and what they did...
testimonials icon
Write a paper of approximately 500-words that addresses the following scenario: You are asked in the final pr...
testimonials icon
You are a financial analyst for a Fortune 500 company and you must present an analysis of the financial data to the executives....
testimonials icon
testimonials icon
/*! elementor - v3.6.5 - 27-04-2022 */ .elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading...
testimonials icon
Assignment 2: Gene Technology   Due Week 8 and worth 120 pointsGene technology carries with it...
testimonials icon
Make a presentation including 15 pages with the links I put in documents....

Other samples, services and questions:

Calculate Price

When you use PaperHelp, you save one valuable — TIME

You can spend it for more important things than paper writing.

Approx. price
Order a paper. Study better. Sleep tight. Calculate Price!
Created with Sketch.
Calculate Price
Approx. price