Question: Make the following solution in excel sheet showing the formula of the following: Prepare a 5-year DCF based upon the following assumptions: NCF: Year 1

Make the following solution in excel sheet showing the formula of the following:

Prepare a 5-year DCF based upon the following assumptions:

NCF: Year 1 $677,000

Growth Rate: 2.7%

Cap Rate: 6.0%

Residual Rate: 9.5%

WACC: 6.5%

What is the Purchase Price?

What is the IRR?

What is the NPV?

Step by Step Solution

★★★★★

3.51 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 2 3 4 5 6 7 8 9 1 2 3 4 5 6 7 8 9 10 Yearn IRR NPV A IRR NPV A Yearn 0 1 2 3 4 5 1 B Cash f... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Q:

List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...

Q:

Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...

Q:

Enbridge assigns this project a cost of equity of 8% and a cost of debt of 5.48%. Treasury determines the optimal capital structure for the project is 75% debt and 25% equity. Using this information...

Q:

show alll work and in excel as well and explain how you get the answer Question 3: (20 Points) Prepare a 5-year DCF based upon the following assumptions: NCF: Year 1 $577,000 Growth Rate: 2.7% Cap...

Q:

Hello Finstat. I have really appreciated your help so far. Can you help with the attached? From what I can tell and what the instructor has told us is that this is less involved than the previous...

Q:

I do not understand anything I am reading. Which of the three valuation techniques (IV b,c,d) is most convincing to you and why? What are AHOLD?s strengths and weaknesses Evaluate the growth...

Q:

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Q:

Need help with this assignment.I've attached the excel workbook that should be used to record answers and the case scenario. The case discusses the dilemma of the CFO of PSUWC Energy LLC, an energy...

Q:

1. Calculate the cost of each capital component, after-tax cost of debt, cost of preferred, and cost of equity with the DCF method and CAPM method. 2. What do you estimate the company?s WACC? Please...

Q:

please calculate with formulas and answer the questions below. what is not clear??? i took screen shots and its very clear on my end. i already took a lot of pictures. which one exactly is not clear?...

Q:

A thick-walled spherical shell of charge Q and uniform volume charge density p is bounded by radii r1 and r2 > r1. With V = 0 at infinity, find the electric potential V as a function of distance r...

Q:

In 2020, OHU Ltd., which follows IFRS, reported accounting income of $300,000 and the 2020 tax rate was 18%. OHU had two timing differences for tax purposes: CCA on the company's tax return was...

Q:

A vertical plate is submerged in water and has the indicated shape. 6 ft 5 ft 5 ft 7 ft An isosceles triangle is submerged in water pointed down. The base of 6 ft is horizontal and 7 ft below the...

Q:

Calculate NPV of all benefits In 5 years labor costs reduced by $250,000 per year and gross revenue increase by $150,000 per year. Maintenance costs over 5 year period Table 1- CAD System Components...

Q:

On December 31, 2016, Price Corp. (Price) purchased 80% of the common shares of Sault Ltd. (Sault) for $2,040,000. On that date, Sault's shareholders' equity consisted of common shares of $1,000,000...

Q:

1.Assume that the general fund of the city of Troy gives $200,000 to the Citys debt service fund, to let the debt service fund pay for a principal payment on a long-term bond. There is no expectation...

Q:

An engineer keeps an inventory of car parts, but on paper. The usual operations on his inventory database include adding new parts, updating levels of current stock and producing different reports...

Q:

1 A CPA takes on a new individual tax client. The client drops off the information on February 10, 20xx. The CPA extends the return and notifies the client that it was extended. The client calls and...

Q:

A square has side lengths of 2x inches. An equilateral triangle has side lengths of (2x+(1)/(3)) inches. If the square and the triangle have the same perimeter, what is the value of x ?

Q:

J. Clark Inc. (JCI), a manufacturer and distributor of sports equipment, has grown until it has become a stable, mature company. Now JCI is planning its first distribution to shareholders. (See the...

Q:

Sam Strother and Shawna Tibbs are vice presidents of Mutual of Seattle Insurance Company and co-directors of the company's pension fund management division. An important new client, the North-Western...

Q:

Boehm Corporation has had stable earnings growth of 8% a year for the past 10 years and in 2016 Boehm paid dividends of $2.6 million on net income of $9.8 million. However, in 2017 earnings are...

Q:

Compare and contrast different theories on the nature of intelligence.

Q:

Research by Elizabeth Loftus shows that eyewitness recognition is very prone to what psychologists call a. a flashbulb memory. b. automatic encoding. c. a false positive. d. a recency effect.

Q:

Identify some methods that people use to solve problems and make decisions.