Question

In: Finance

Purpose of Assignment The purpose of this assignment is to allow the students to become familiar...

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. 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%

I need the answers to be shown in Excel

Solutions

Expert Solution

SEE IMAGES

WE TAKE GREAT CARE IN PROVIDING SOLUTIONS TO YOU. BUT OCCASSIONALLY MISTAKES CAN HAPPEN.

SO IF THAT HAPPENS, LET US KNOW, WILL CORRECT IT.

ANY DOUBTS, FEEL FREE TO ASK. HAPPY TO HELP YOU


Related Solutions

Purpose of Assignment  The purpose of this assignment is to allow the students to understand and...
Purpose of Assignment  The purpose of this assignment is to allow the students to understand and practice the measurement of present value, future value, and interest rate using Microsoft® Excel®.  Assignment Steps  Resources: Microsoft® Office® 2013 Accessibility Tutorials, Microsoft® Excel®, Time Value of Money Calculations Template Calculate the following time value of money problems using Microsoft® Excel®: If we place $8,592.00 in a savings account paying 7.5 percent interest compounded annually, how much will our account accrue to in 9.5 years? What is the present value of...
Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research...
Purpose of Assignment The purpose of this assignment is to allow students the opportunity to research a Fortune 500 company stock using the popular online research tool, Yahoo Finance. The tool allows the student to review analyst reports and other key financial information necessary to evaluate the stock value and make an educated decision on whether to invest. Assignment Steps Select a Fortune 500 company from one of the following industries: Pharmaceutical Energy Retail Automotive Computer Hardware Manufacturing Mining Review...
Co-occurring Treatment and Recovery Chart The purpose of this assignment is to become familiar with the...
Co-occurring Treatment and Recovery Chart The purpose of this assignment is to become familiar with the treatment and recovery methods, modalities, and strategies. After reading all assigned material complete the “Co-occurring Treatment and Recovery Chart” by filling in the information for the following categories below. Description or definition of the strategy: What is the strategy and modality? For example, regarding stages of change, what is the brief definition of this method? Key concepts and brief definitions: What are the common...
Question Objective: The purpose of this lab is for you to become familiar with Python’s built-in...
Question Objective: The purpose of this lab is for you to become familiar with Python’s built-in text container -- class str -- and lists containing multiple strings. One of the advantages of the str class is that, to the programmer, strings in your code may be treated in a manner that is similar to how numbers are treated. Just like ints, floats, a string object (i.e., variable) may be initialized with a literal value or the contents of another string...
Purpose of Assignment The purpose of the assignment is to develop students' abilities in using data...
Purpose of Assignment The purpose of the assignment is to develop students' abilities in using data sets to apply the concepts of sampling distributions and confidence intervals to make management decisions. Assignment Steps Resources: Microsoft Excel®, The Payment Time Case Study, The Payment Time Case Data Set Review the Payment Time Case Study and Data Set. Develop a 700-word report including the following calculations and using the information to determine whether the new billing system has reduced the mean bill...
The purpose of this assignment is to allow the student an opportunity to explain what it...
The purpose of this assignment is to allow the student an opportunity to explain what it means to have an efficient capital market. Students will gain an understanding of the different levels of market efficiency and how behavioral finance can inhibit reaching market transparency. Explain in 525 words what it means to have efficient capital market, including: Describe the behavioral challenges in achieving efficiency. Discuss the three forms of market efficiency. What are the implications to corporate finance? Would you...
PURPOSE: The purpose of this assignment is to enable the students to enhance their knowledge on...
PURPOSE: The purpose of this assignment is to enable the students to enhance their knowledge on the environmental engineering and sustainable development for environmental engineering. TASK 1 (DOCUMENTATION) Development in science and technology has increase the level of human lifestyle which leads to technology advancement. However, everything good comes with a price. One of the greatest problems that the world is facing today is that of environmental pollution, increasing with every passing year and causing grave and irreparable damage to...
The purpose of this lab:  Wireshark Intro Lab is to get students familiar with the use of...
The purpose of this lab:  Wireshark Intro Lab is to get students familiar with the use of their VMs and running wireshark on their VMs. We also examine Ethernet, IPv4, and TCP addressing at the Network Access, Network, and Transport layers of the TCP/IP stack. Reflection: In two paragraphs reflect the experience of using Wireshark capture (in the lab) on the following questions: What was the most valuable feature of the lab? How did you prepare for this lab? What changes...
The purpose of this assignment is to allow you to examine both an in-house software development...
The purpose of this assignment is to allow you to examine both an in-house software development and a commercially purchased software package. Scenario: CSU has a sporting goods shop that sells sports equipment, as well as hiking and camping supplies. The CSU shop owner, Peter, wants to develop a customer-order entry system and has hired your IT consulting firm to advise him about software alternatives. Peter is leaning toward in-house development because he does not want to depend on a...
Objective: The objective of this assignment is to allow students to understand the basic principles of...
Objective: The objective of this assignment is to allow students to understand the basic principles of arrays Program Requirements: The assignment will require the students use arrays to perform mathematical calculations. Program Setup: Functions to include in the program The program will have three functions Function 1: Responsible for setting values in the arrays Function 2: Responsible for printing values in arrays Function 3: Responsible for doing calculations to arrays Function 1 Details: Setting array values Parameters: 3 Array of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT