Calculate the payback period for the proposed investment

Assignment Help Corporate Finance
Reference no: EM132288418

Problem 1: Elysian Fields, inc., uses a maximum payback period of 6 years and currently must choose between two mutually exclusive projects. Project Hydrogen requires an initial outlay of $25,000; project Helium requires an initial outlay of $35,000. Using the expected cash inflows given for each project in the following table, calculate each project's payback period. Which project meets Elysian's standards?

Year Expected cash inflows
Hydrogen Helium

1

$6,000 $7,000

2

6,000 7,000

3

8,000 8,000

4

4,000 5,000

5

3,500 5,000

6

2,000 4,000

Problem 2:  NPV for varying costs of capital Dane Cosmetics is evaluating a new fragrance-mixing machine. The machine requires an initial investment of $24,000 and will generate after-tax cash inflows of $3,000 per year for 8 years. For each of the costs of capital listed, (1) calculate the net present value (NAV), (2) indicate whether to accept or reject the machine, and (3) explain your decision.
a. The cost of capital is 10%.
b. The cost of capital is 12%.
c. The cost of capital is 14%.

Problem 3: Mutually exclusive projects Bell Manufacturing is attempting to choose the better of two mutually exclusive projects for expanding the firm's warehouse capacity. The relevant cash flows for the projects are shown in the following table. The firm's cost of capital is 15%.

Initial investment (Ch)

Project X

Project Y

$500,000

$325.000

Year in

Cash inflows (CF,)

1

$100,000

5140,000

2

120,000

120,000

3

150,000

95,000

4

190,000

70,000

5

250,000

50,000

a. Calculate the MR to the nearest whole percent for each of the projects.

b. Assess the acceptability of each project on the basis of the IRRs found in part a.

c. Which project, on this basis, is preferred?

Problem 4: Payback, NPV, and IRR Rieger International is attempting to evaluate the feasibility of investing $95,000 in a piece of equipment that has a 5-year life. The firm has esti¬mated the cash inflows associated with the proposal as shown in the following table. The firm has a 12% cost of capital.

Year (t)

Cash inflows (CF,}

1

520,000

2

25,000

3

30,000

4

35,000

5

40,000

a. Calculate the payback period for the proposed investment.
b. Calculate the net present value (NPV) for the proposed investment.
c. Calculate the internal rate of return (IRR), rounded to the nearest whole percent, for the proposed investment.
d. Evaluate the acceptability of the proposed investment using NPV and IRR. What recommendation would you make relative to implementation of the project? Why?

Problem 5: Payback, NPV, and IRR Rieger International is attempting to evaluate the feasibility of investing $95,000 in a piece of equipment that has a 5-year life. The firm has estimated the cash inflows associated with the proposal as shown in the following table. The firm has a 12% cost of capital.

Year (t)

Cash inflows (CFI)

1

$20,000

2

25,000

3

30,000

4

35,000

5

40,000

a. Calculate the payback period for the proposed investment.
b. Calculate the net present value (NPV) for the proposed investment.
c. Calculate the internal rate of return (IRR), rounded to the nearest whole percent, for the proposed investment.
d. Evaluate the acceptability of the proposed investment using NPV and IRR. What recommendation would you make relative to implementation of the project? Why?

Problem 6: Calculating initial investment Vastine Medical, Inc., is considering replacing its ex¬isting computer system, which was purchased 2 years ago at a cost of $325,000. The system can be sold today for $200,000. It is being depreciated using MACRS and a 5-year recovery period (see Table 4.2, page 120.) A new computer system will cost $500,000 to purchase and install. Replacement of the computer system would not involve any change in net working capital. Assume a 40% tax rate.
a. Calculate the book value of the existing computer system.
b. Calculate the after-tax proceeds of its sale for $200,000.
c. Calculate the initial investment associated with the replacement project.

Attachment:- Assignment template.rar

Verified Expert

" The assignment is prepared with the intention of carrying out a capital budgeting analysis of the given problems in the excel document by applying the excel formuales and also provide conclusions and recommendations regarding the same. This assignment was prepared in Microsoft word and APA referencing has been adopted for the same".

Reference no: EM132288418

Questions Cloud

Innovation and strategic management : Discuss the importance of innovation in the survival and success of a business. Next, suggest three (3) strategies that you, as an entrepreneur
Young adults with mental health issues : How would explain the segmentation strategy for young adults with mental health issues?
Organizational learning connect with organizational change : How does organizational learning connect with organizational change, and what are strategies to involve others in planning organizational change?
Why is there a huge gap in theory : Why is there a huge gap in theory (what should be done) and practice (what actually doing) about leadership development with Gen Y leadership
Calculate the payback period for the proposed investment : Calculate the book value of the existing computer system - Calculate the initial investment associated with the replacement project
Identify issues of diversity that impact practice : Identify issues of diversity that impact practice with this client system, especially within the particular environmental/organizational context of your agency.
Responsible for making sure the group of individuals : A team leader is responsible for making sure the group of individuals is able to function as a unit and deliver on its tasks.
What can organization decision makers do : What can organization decision makers do, when setting up a team environment, to improve a team's COHESIVENESS?
Identify what menopause or andropause is : Select either menopause or andropause or both for this discussion. Identify what menopause or andropause is and its impact to the individual, their work.

Reviews

len2288418

4/19/2019 10:52:18 PM

If you just input 13,000 in the cell C3, then that is not showing your work. There are some answer cells during the course where there is no data to input. You will just need to input a date or type in a word for your answer. You will also need to use the correct built-in Excel formulas in Excel when warranted. Be sure to go over the “Excel Example” file It will help you if you have never used a built-in formula in Excel. Note that simple math such as adding, subtracting, etc. are not considered built-in formulas.

len2288418

4/19/2019 10:52:09 PM

I need assistance with the attached assignment Instructions: Assignment problems •P10-1 on p.421 P10-6 on p.423 P10-16 on p.425-426 P10-22 on p.427 P11-11 on p.459 Please use the excel template included in the attachment Be sure to show your work in the blank gray Excel cells when warranted. Most of them will require you to use inputs to derive the answer. For example, if cell A1 contains 5,000 and cell B2 contains 8,000 and you need to add them together in cell C3, then in the cell C3 you would input the following: =A1+B2. Then push enter. When I click on the cell C3 I will see the you used the correct formula and cell locations (that contains the correct data) to derive your answer.

Write a Review

Corporate Finance Questions & Answers

  What was the cash flow to creditors

What was the 2014 operating cash flow? What was the 2014 cash flow to creditors? What was the 2014 cash flow to stockholders? (Do not round intermediate calculations.)

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  What are the key functions of whole life insurance policies

FIN 3660- What are the key functions of whole life insurance policies? Describe the two types of joint life insurance policies and what they are commonly used for.

  What would be the reason to pay dividends

What would be the reason to pay dividends if the company bestow US $ 2 common action? Assume that the stock is trading $ 60 per share, determine what the return on dividends if the company distributes USD 2 per share.

  Calculate the firms earnings per share for each year

Calculate the firm's earnings per share (EPS) for each year, recognising that the number of shares issued has remained unchanged since the firm's inception. Comment on the EPS performance in view of your response to question 1a.

  How ratio analysis may be used to predict an individual firm

How ratio analysis may be used to predict an individual firm's stock price. Pick an actual company firm on the New York Stock Exchange and prepare a ratio analysis utilizing at least six common ratios.

  Asset management strategic planning backgroundyou are an

asset management strategic planning backgroundyou are an asset manager for a medium sized company the primary purpose

  The capital structure of campbell company

The capital structure of Campbell Company Long-Term debt, with an incremental borrowing rate of 8%

  What would be the price of bond a

Why is the yield on bonds A and B 5%? Why is the yield on bond C different and what would be the price of Bond A?

  What is the cost of new equity for the firm

If the stock is currently selling for $50 per share with a 10% flotation cost, what is the cost of new equity for the firm? What are the advantages and disadvantages of using this type of financing for the firm?

  Create statement of affairs and deficiency account

The Company was formed on 1 January 2006 and had made losses of $15,69,500. Prepare statement of affairs and deficiency account.

  How the cost of capital influences the mncs

Determine how the cost of capital influences the MNCs international financing decisions. How would proper risk handling normally affect the WACC - and why?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd