Compute the future worth of the cash flows

Assignment Help Finance Basics
Reference no: EM13753878

1. Compute the Future Worth of the cash flows shown in the diagram below. Use interest rates shown.

2. A capital equipment project is expected to provide positive cash flows of $4,400 the first year, $5,500 the second year, $6,600 the third year, -$4,300 the fourth year, $8,800 the fifth year, and $9,900 the sixth year. It is estimated the initial project cost would be about $25,000. What is the internal rate of return for the project? Use spreadsheet to solve the problem (draw the NPW plot (NPW vs interest rate) and IRR function).

3. For the cash flows tabulated below, compute the rate of return to the nearest 0.10%.

Year

0

1

2

3

4

5

6

Cash Flow, $

-300

400

250

100

-50

-200

-350


4. Using Rate of Return Analysis, determine the most economical alternative below. Assume a minimum attractive rate of return of 6%, and a 5-year life with no salvage value for each. The alternatives are mutually exclusive.

Data

 

Alternative

 

 

 

A

B

C

D

Intial Cost

$400,000

$100,000

$500,000

$200,000

Annual Cost

$900

$120,000

$23,000

$9,000

Annual Benefits

$101,800

$39,700

$148,200

$55,200


5. The cash flows for three different alternatives are given in the table below. Assume that alternatives are replaced at the end of their useful lives. Life = 8 years. Use "EXCEL" to solve this problem (graph the NPW of each alternative versus the interest rate).

i. Develop a choice table from 0-10%.

ii. Choose the best alternative for a MARR of 7%.

 

A

B

C

First cost

2,000

6,000

5,000

EUAB

275

400

750

Salvage Value

750

5,000

0

6. A machine costs $5,240 and generates an annual end-of-year benefit of $1,000 for 8 years. If a nominal annual interest rate of 9.532% with continuous compounding is assumed, calculate the breakeven point in years, at which the purchase price equals the present value of the benefits received.

7. The following data is available for three different alternatives. MARR =12%

Data

Alt. A

Alt. B

Alt. C

Intial Cost

$6,000

$900

$1,500

Uniform Annual Benefit

$525

$300

$450

Useful Life, Years

20

5

10


Alternatives B and C are replaced at the end of their useful lives with identical replacements. Using the above data, find the best alternative using benefit cost ratio analysis.

8. Find the rate of return for the following cash flow. (i) determine how many roots are possible and (ii) graph the PW versus the interest rate to see whether multiple roots occur. (iii) use MIRR as the project's ROR if it is necessary. (external investing rate is 12% and external borrowing rate is 6%)

Year

Cash Flow

0

-$5,000

1

$20,000

2

-$12,000

3

-$3,000

Reference no: EM13753878

Questions Cloud

Discussion on an overview of financial management : In your judgment, what were the principal causes of the recent financial crisis and Great Recession? Would you include Government policies that encouraged housing purchases for those who could not afford them
Describe basic computer components and their uses : Explores computer literacy topics in a very basic, hands-on environment. Presents the fundamentals of computer hardware and software, the Internet, operating systems, and current application software within Microsoft Office Suite. Describe basic c..
In what ways did the meat packing industry in chicago : In what ways did the meat packing industry in Chicago abuse its workers? Give examples of the abuses and at least one direct quote from the book. Do not use the same passages found in the lecture notes for your quote(s).
Describe how indians confronted modernity in general : Describe how Indians confronted modernity in general and , more specifically, how they responded to the weight of a hegemonic European presence in the subcontinent.
Compute the future worth of the cash flows : 1. Compute the Future Worth of the cash flows shown in the diagram below. Use interest rates shown.
Brief explanation of porters generic strategies : A brief explanation of Porter's generic strategies and Identification of the strategy US Airways uses
Explain a business process and give an example : Define a business process and give an example. Compare the book's methodology to the methodology you found in your research
Explain why economic instability can lead to social change : Use the information presented in this chapter to explain the chapter's Enduring understanding statement: Economic instability can lead to social and political change.
Calculate financial ratios interpret results : Analyze each company's history, product/services, major customers, major suppliers, and leadership, and provide a synopsis of each company -  prepare a report to summarize your findings on the financial health of each company.

Reviews

Write a Review

Finance Basics Questions & Answers

  Calculate the dividend yield

Suppose you expect a share of stock to pay dividends of $1.00, $1.25, and $1.50 in each of next three years. You believe the stock will sell for $20 at the end of third year

  In a two page paper report your top three strengths and how

1.take three minutes to list as many positive emotions and negative emotions as you possibly can. what is your ratio of

  Find two articles that discuss financial ratio analysis

Using the Ashford University Library as a resource, find two articles that discuss financial ratio analysis. Identify two advantages and two disadvantages to using ratios in financial analysis.

  Problem-solving stages of conflict resolution

Identify and briefly describe the conflict situation between you and another person and how a covert conflict behavior was used within the conflict.

  For january february and march prepare a schedule of

1. you have really enjoyed the early years of your working life just turned 45 and have saved zero for retirement.nbsp

  What should be the fair price

What should be the fair price of this asset today?

  What will the price be in three years and in fifteen years

Patience, Inc., just paid a dividend of $3.15 per share on its stock. The dividends are expected to grow at a constant rate of 6.00 percent per year, indefinitely. Assume investors require an 11 percent return on this stock.

  What is the expected capital gains yield

What is the dividend yield? (Round your answer to 2 decimal places. What is the expected capital gains yield?

  Periodic review system

You work for a retailer that uses a monthly periodic system to maintain the inventory of water heaters it sells. Below is the sales data for the last 5 months.

  A local retailer of pet food faces demand for one of its

1. pet food inc. a local retailer of pet food faces demand for one of its items at a constant rate of 30000 bags per

  Ballack cos common stock currently sells for 5100 per share

ballack co.s common stock currently sells for 51.00 per share. the growth rate is a constant 8.4 and the company has an

  Which of the following is not true about a stock dividend

With a stock dividend, the firm issues a percentage of outstanding stock as new shares to existing shareholders.

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