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%

## post psy341 unit 1 discussions both latest 2016 ja...

Why is research important for the fields of Psychology and Sociology? When responding to ALL discussion...

## Last minute assignment need done by 11:30 est (Eng...

Due Week 5 and worth 80 points  B. The state school board chairperson has asked you (a consultant on health and we...

## Community Teaching Plan: Teaching Experience Paper...

The RN to BSN program at Grand Canyon University meets the requirements for clinical competencies as defined by the Commission on Collegiate Nursin...

## Mathematics : binomial probability tables, statis...

(The work needs to be shown in Exel to turn in)Seventy percent of the students applying to a university are accepted. Using...

## BUSN460 Individual Financial Analysis Project...

Find these ratios, providing the following information for each; Formula (express the ratio in words), a detailed calculation (actual numbers from...

## DQ...

From your experience, how can developing strong interprofessional relationships increase collaboration and benefit patient outcomes or orga...

## Eek One Discussion Formal Report Topic First Post...

eek One Discussion: Formal Report Topic (First post should occur by Wednesday 11:59 PM.) In preparation for the Formal Rep...

## Trident Bus499 module 2 case and SLP...

n the last module we looked at the Balanced Scorecard and how it is implemented from more of a purist’s approach and...

## Develop a process map about the prescription filli...

Ben Davis had just completed an intensive course in Statistical Thinking for Business Improvement, which was offered to all employees of a large he...

## Engineering : Capstone Project T...

Running Head: CYBERCRIME1CybercrimeName of ProfessorName of StudentCourseSubmission DateCYBERCRIME2IntroductionCybercrime is a form of fraud that is...

### 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
\$65
Order a paper. Study better. Sleep tight. Calculate Price!
Calculate Price
Approx. price
\$65