Question: 1. Suppose Keynes, Inc is considering buying a machine that will generate revenues of $6 million annually for two years and $2 million in the

1. Suppose Keynes, Inc is considering buying a machine that will generate revenues of $6 million annually for two years and $2 million in the third year. After three years the machine is worthless. If Keynes, Inc buys the machine, it must make a deposit of $ 2 million today and pay a further $11 million two years from now. Keynes, Inc has a minimum acceptable rate of the return policy on investments set at 5%.

a. Using an Excel function, find the breakeven interest rate.

b. Using the project balances, show that this is a mixed investment.

c. Write formulas for the project balances to correctly reflect that this is a mixed investment. Note make cell B1 the location of the (as yet unknown) True IRR.

d. Use the Excel Goal Seek function (located in Data | WhatIf Analysis) to find the True IRR.

e. Should Keynes, Inc buy the machine?

Step by Step Solution

★★★★★

3.40 Rating (159 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a Using an Excel function find the breakeven interest rate The breakeven interest rate can be found using the Excel XIRR function This function takes values of cash inflows and outflows and the corres... View full answer

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!

ABC Corp. is considering leasing an asset from XYZ Corp. Here are the relevant facts: ABC's interest costs are 10% and XYZ's interest costs are 7% Find the Maximum rental that ABC will pay and the...

The Four Brothers Lumber Company is considering buying a machine that planes lumber to the correct thickness. The machine is advertised to produce 6-inch lumber having a thickness that is normally...

A corporation is considering purchasing a machine that will save $150,000 per year before taxes. The cost of operating the machine (including maintenance) is $30,000 per year. The machine will be...

You are considering buying a machine that will cost you $12,000. There will be a maintenance cost of $1,000 at the beginning of each year, and the machine will generate cash flows of $5,000 over the...

Suppose Keynes, Inc is considering buying a machine that will generate revenues of $6 million annually for two years and the $2 million in the third year. After three years the machine is worthless....

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

PowerPoint Assignment for BUS 401: Principles of Finance You have been asked by a manager in your organization to put together a training program explaining Net Present Value (NPV) and Future Value...

BLC Inc. is a medium-sized manufacturing company based in the UK. The company operates mainly in the London area and is based in Peterborough. At a recent board meeting, the company decided to expand...

Hi. I need Chapter 11 part 1-4 Let me know. Thanks! (it wont letme add more than $8, but I will give $12+ tip) Personal Finance, Fifth Edition by Jeff Madura BUILDING YOUR OWN FINANCIAL PLAN WORKBOOK...

Hi Erylee88, I would like to utilize your service again. Same format different questions. Please find attached document for your review. Let me know. Thank you, Sam...

The auditors know that the clients accounting for deferred income taxes is not in accordance with generally accepted accounting principles, but because of a very significant scope limitation they...

5 kg of steam occupies a volume of 10 m^3. Find the quality of the temperature is measured at 75 C.

Evaluate lim x 0 ( 1 x ) x Select one: a . e 2 b . 0 c . 1 d . e

Two kilograms of water at 120C with a quality of 25% has its temperature raised 20C in a constant volume process. What are the new quality and specific entropy?

Why must a corporation have good transactional processing systems before implementing a DSS?

Using the health records of every student at a high school, the school nurse created a scatterplot relating y = height (in centimeters) to x=age (in years). After verifying that the conditions for...

A closed rigid container is filled with 1.5 kg water at 100 kPa, 55C, 1 kg of stainless steel and 0.5 kg of polyvinyl chloride, both at 20Cand 0.1 kg of hot air at 400 K, 100 kPa. It is now left...

A motor and generator are set up to drive a load as shown in Figure P5.19. If the generator output voltage is e g (t) = K f i f (t), where if (t) is the generators field current, find the transfer...

The standardized measure of association that indicates the difference between the mean of the experimental group and the mean of the control group on the dependent variable, adjusted for the average...

iHeartMedia, Inc. in their annual report for the year ending December 31, 2015, state that the plant assets reported on its balance sheet includes the following: Plant Asset...

Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...

1. Compare and contrast the different types of debt problems that were discussed in this chapter in terms of (a) the source of the debt, (b) the interests of major actors in each situation, and (c)...

Suppose that in period 0, a referendum is organized to ask Calvin and Hobbes whether they want the government to implement a policy that shuts down payday lending. The policy would require some...

Red Inc. issued 100 15-year bonds each with a face value of $1,000 on January 1, 20X1. The bonds have a coupon rate of 4% and coupons are paid on June 30 th and December 31 st . When the bonds are...

Refer to Cornerstone Exercise 10.4. Required: 1. If Carreker, Inc., has a transfer pricing policy that requires transfer at full product cost, what would the transfer price be? Do you suppose that...