Answered: Consider the following cash flow…

Consider the following cash flow diagram. Compute the equivalent annual worth at i-12% $5,000 $6,000 $4,000 $3,000 0 1 4 5 6 . Years $3,000 Yr 2.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter19: Capital Investment

Section: Chapter Questions

Problem 19E

See similar textbooks

Related questions

Q: Calculate the equivalent AW at i 10% per year for the following net cash flow Year Cash flow, $…

A: Equivalent annual worth is the uniform annual worth of all estimated cash inflows and outflows that…

Q: Compute the rate of return represented by the cash flow. Year Cash Flow -S20, 000 6, 000 6, 500 3 7,…

A: In order to determine the profitability the rate of return is used by the management, it helps to…

Q: For the given cash flow of geometric gradient, if A= $8,000 , the present value, P is closest to: A…

A: We need to compute the present value of the given cash flows series.

Q: 1. Compute the net present value at i=15% per year, compounded annually, for cash flow below: End of…

A: Note : As per the guidelines, only first question will be answered. Kindly post the remaining parts…

Q: From the following data, calculate Internal Rate of Return (IRR): Year 1 2 3 4 5 Cash Flow…

A: Internal Rate of Return is the discounting rate where the net present value of the project is zero.

Q: Refer to the following cash flow diagram. If / 12% per year, what is P, when N- o0? 1234 EOY P A…

A: When N = Infinite, we are dealing with perpetuity

Q: Compute for the value of x so that the two cashflows will be equivalent. 5X .. 1400 2800 2100 AX 700…

A: This question is based on present value concept. Present value is given by PV = C/(1+r)n Where C =…

Q: Please help me answer this. Thank you.

A: Future value of amount includes the amount being deposited over the time and amount of interest…

Q: Construct a cash flow diagram to find the present worth in year 0 of a $400 expenditure in year 3, a…

A: Year Cash Expense DF @15% Amount at year 0 3 400 for 3 years= 2.28 175.44 =400/2.28 4 (900)…

Q: Compute the value of P for the accompanying cash flow diagram. Assume i = 6% per year.

A: Present value (PV), if the stated rates of return are provided, is the current value of a future…

Q: Compute the present value for the cash flow diagram shown below if i=6%, compounded annually. $500…

A: Year Cash Flow 1 300.00 2 300.00 3 300.00 4 100.00 5 200.00 6 300.00 7 400.00 8…

Q: $500 $500 $500 $500 Year 2 3 i =12% compunded annually B P=?

A: Let CFn be the cashflow in year n. CF1 = B = - $1200 CF2 = $500 CF3 = $500 CF4 = $500 CF5 = $500 i =…

Q: In the following cash flows diagram, Determine the value of F that makes the two cash flows diagrams…

A: To calculate equivalent cash flows at end of year 5, present value of cash flows will be calculate…

Q: Example 1: Find the Net Present Value assuming cost of capital is 10 %? Year Cash Flow Rs.…

A: The given problem can be solved using NPV function in excel.

Q: In a geometric sequence of annual cash flows starting at the EOY zero, the value of A0 is $1,304.35…

A: A company's cash flows equals the cash coming into the business minus the cash going out.

Q: 2. For the cash flows shown below, determine the present worth at an interest rate of 12% per year.…

A: The present value is the value of the sum received at time 0. It is the current value of the sum…

Q: • For the cash flow series shown below, a) Find the present worth b) Find the equivalent annual…

A: The present value is the value of the sum received at time 0 or the current period. It is the value…

Q: Let i = 10% per year, find the present worth in year 0 for the cash flows diagram shown below: i =…

A: Present Value of cash flow is the cash flow of a certain year multiplied by the discounting factor…

Q: Investment Perlod 1 2 3. 4 $(1,000) $100 $100 $100 $100 $1,100 B (1,000) 264 264 264 264 264 (1,000)…

A: Net present value: NPV = Present value of cash inflows - present value of cash outflows. Formula:…

Q: Construct a cash flow diagram for the following cash flows: $10,000 outflow at time zero, $3000 per…

A: Outflow at time 0= ($10,000) Inflow in years 1 through 5= $3000 per year Time= 5 years Rate= 5%…

Q: Cash Flow Diagram Below: Find the present Worth for i =7% Compute annual series value for the cash…

A: Present Value = Cashflow/(1 + r)1 + Cashflow/(1+r)2 + ......+ Cashflow/(1+r)n = 600/(1.07)1 +…

Q: X = ? 10,000 A1 = 20,000 30,000 A2 = 40,000 %3D

A: Let CFn = Cashflow in year n CF4 = CF5 = CF6 = A1 = $20000 CF7 = CF8 = A2 = $40000 CF9 = $10000 CF11…

Q: Determine the present equivalent value of the cash-flow diagram shown below P = ? $5,000 $3500 8% iz…

A: The worth of the money changes according to time. Therefore, the time value of money shows the worth…

Q: Given: Base amount = $500, gradient = -$100, i = 10%, n = 3. For the given values, determine the…

A: NPV can be calculated by following function in excel =NPV(rate,value1,[value2],…) + Initial…

Q: calculate annual cash flow of $250000 invested at 6%

Q: F10 - 8% B B. B B B. |= 6.5 % 0 1 2 3 4 5 6 7 8 9 10 1 12 18 19 20 // A A A A 100,000

A: If the deposits are made on the time they grow with time bigger amounts and than they retuned into…

Q: W $1,000 $1,000 1 3 4 7 End of Year End of Year $1,000

A: Computation of net present value for the left hand side is as…

Q: Refer to the following table of cash flows: End of year 0 3 6 9 12 Cash Flow P25,000 P25,000…

A: Annual worth has equal value to future value when cash flows occur uniformly throughout life.

Q: Consider a cash flow and interest profile as shown: The worth at the end of Year 3 of these cash…

Q: Compute the rate of return represented by the cash flow. Year Cash Flow -$14,000 1 5,000 5,500 3…

A: Rate of return = IRR = that rate that makes the NPV as nil. We know that PV = FV/(1+r)^n Let the…

Q: The annual worth for years 1 through 8 of the cash flows shown is $30,000. What is the amount of the…

A: Cash flow is the net amount of cash and cash-equivalents being transferred into and out of a…

Q: 1. Use MS Excel to determine the Present Worth of the following cash-flow diagram: a) At 7%, PW = b)…

A: Present Value: The present value is the value of cash flow stream or the fixed lump sum amount at…

Q: What is the present value of the following cash flow stream at a rate of 6.25%? Years 1 2 3 4…

A: Since you have asked multiple questions, we will solve the first question for you. If you want any…

Q: In the following cash flows diagram, Determine the Future Worth at the end of year 12 f the interest…

A: Future value = cashflow *(1+rate)^years

Q: For the cash flow series shown, determine the future worth in year 5 at an interest rate of 10% per…

A: Time value of money- It is based on the concept that money earned today is worth more than similar…

Q: Find the ROR of the following cash flow. MARR is 18% per year. Year 0 1 3 4 5 7 8 Cash -32,000…

A: The ROR is the interest rate that results in net present worth(NPW) of project zero. It can be…

Q: For the cash flows shown in the diagram, determine the value of x and 2x that will make the future…

A: Calculation of values of x and 2x:Answer:The values of x and 2x are 10,744.42 and 21,488.84

Q: For the value of P shown, what is the NPV for the cashflow? Value of P S1,000 Rate 5% Year Cash Flow…

A: NPV is calculated as the difference of present value of inflows and outflows associated with the…

Q: Calculate the equivalent AW at i 10% per year for the following net cash flow: Year Cash flow, $…

A: Given: Year Cash flows 0 1 -$2,000.00 2 -$2,000.00 3 -$2,000.00 4 $5,000.00 5…

Q: Determine the rate of return per year for the cash flows shown below. Year 0 1 2 3 Cash…

A: Rate of return is the rate at which the present value of all the cash inflows and outflows becomes…

Q: Given the cash flow diagram below, evaluate the "X" value using an interest rate of 8%. Year |1 2 3…

A: Present value of cash flow is equal to the initial investment of the project. From that unknown…

Q: In the following cash flows diagram, Determine the value of F that makes the two cash flows diagrams…

A: We have to calculate the future value of 1st four cash flows till the end of 5 the year and the…

Q: For the cash flows shown, determine the value of G that makes the present worth in year 0 equal to…

Q: $20,000 now is equivalent to cash flows worth 5X at the end of year 3, 4X at the end of year 4, 3X…

A: present value of each cash flow = cash flow/(1+rate)^n

Q: The following table represents the cashflows (in rand) of a company. Year Cash flows 3 40000 5…

A: The Modified Internal Rate of return: The modified rate of return is a useful measure to evaluate…

Q: For the cash flows shown (in $1000 units), calculate the value of x that makes the present worth in…

A: The present value of a cash flow represents the worth of money at present time. It is also known as…

Q: For the cash flows shown, determine the future worth in year 5. Year Cash Flow, $/Year Estimated i…

A: Future Value is the value of current investments at a certain future date at the assumed…

Question

100%

Please show how to do this on excel. Thank you!

Consider the following cash flow diagram. Compute the equivalent annual worth at i-12%
$6,000
$5,000
$4,000
$3,000
0 1 2
3
4
6.
Years
$3,000 Yr

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.

Similar questions

Assume that an investment of 100,000 produces a net cash flow of 60,000 per year for two years. The discount factor for year 1 is 0.89 and for year 2 is 0.80. The NPV is a. 0 b. 6,800 c. 1,400 d. (4,000)
Carter Swimming Pools has $16 million in net operating profit after taxes (NOPAT) in the current year. Carter has $12 million in total net operating assets in the current year and had $10 million in the previous year. What is its free cash flow?
Brook Corporation’s free cash flow for the current year (FCF0) was $3.00 million. Its investors require a 13% rate of return on (WACC = 13%). What is the estimated value of operations if investors expect FCF to grow at a constant annual rate of (1) −5%, (2) 0%, (3) 5%, or (4) 10%?
Chasse Building Supply Inc. reported net cash provided by operating activities of $243,000, capital expenditures of $112,900, cash dividends of $35,800, and average maturities of long-term debt over the next 5 years of $122,300. What is Chasses free cash flow and cash flow adequacy ratio? a. $94,300 and 0.77, respectively c. $130,100 and 1.06, respectively b. $94,300 and 0.82, respectively d. $165,900 and 1.36, respectively
An investment of 1,000 produces a net cash inflow of 500 in the first year and 750 in the second year. What is the payback period? a. 1.67 years b. 0.50 year c. 2.00 years d. 1.20 years e. Cannot be determined
Swasey Company earned net income of 1,800,000 in 20X2. Swasey provided the following information: Required: Compute the financing cash flows for the current year.
The Berndt Corporation expects to have sales of 12 million. Costs other than depreciation are expected to be 75% of sales, and depreciation is expected to be 1.5 million. All sales revenues will be collected in cash, and costs other than depreciation must be paid for during the year. Berndts federal-plus-state tax rate is 40%. Berndt has no debt. a. Set up an income statement. What is Berndts expected net income? Its expected net cash flow? b. Suppose Congress changed the tax laws so that Berndts depreciation expenses doubled. No changes in operations occurred. What would happen to reported profit and to net cash flow? c. Now suppose that Congress changed the tax laws such that, instead of doubling Berndts depreciation, it was reduced by 50%. How would profit and net cash flow be affected? d. If this were your company, would you prefer Congress to cause your depreciation expense to be doubled or halved? Why?
For the cash flows shown, calculate the equivalent annual worth in years 1 through 4 at an interest rate of 10% per year. Year 0 1 2 3 4 Cash Flow, $ 250,000 275,000 300,000 325,000 375,000
From the following data, calculate internal rate of return (IRR) Year Cash Flow(Rs) 0 (3,84,000) 1 1,50,000 2 1,25,000 3 1,00,000 4 75,000 5 55,000
Determine the rate of return per year for the cash flows shown below. Year 0 1 2 3 Cash Flow, $ −125,000 −7,500 84,000 78,000
An arithmetic cash flow gradient series equals $600 in year 1, $800 in year 2, and amounts increasing by $200 per year through year 5. At i = 6% per year, determine the factor from the compound interest factor table that is used to calculate the equivalent annual worth of the revenue through year 5. Multiple choice question. A. 4.212 B. 5.637 C. 1.884 D. 7.934
The annual worth for years 1 through 8 of the cash flows shown is $30,000. What is the amount of the cash flow labeled x in year 3, if i = 10% per year? Solve using (a) tabulated factors, and (b) a spreadsheet.