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 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...
PURPOSE The purpose of this assignment is to enable students in understanding an organisation’s financial goals...
PURPOSE The purpose of this assignment is to enable students in understanding an organisation’s financial goals through the preparation of functional and cash budgets that together integrate into a business plan. Explain how cash budgets help in: (i) forecasting future needs; (ii) controlling cash expenditure; (iii) evaluation of performance; and (iv) acting as a sound dividend policy.
The purpose of this assignment is to provide students with an opportunity to develop a framework...
The purpose of this assignment is to provide students with an opportunity to develop a framework for the development of a database that would support a Post-operative Follow-Up Module in an Ambulatory Surgery Center. Please read the article contained in this link and answer the following questions: [Article about Structured Vs. Unstructured Data]. What are the critical issues that Post-Anesthesia Care Unit (PACU) staff must address when contemplating the development of a Post-operative Follow-Up Module? When considering the issue of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT