What is the present value of the following cash flow stream at a rate of 6.25%?YEAR O=0 YEAR 1= P75 YEAR 2= P225 YEAR 3=PO YEAR 4=P300 *411.57433.23456.03480.03505.30

To open the "PV function" window - MS-Excel --> Formulas --> Financials --> PV.

Answered: What is the present value of the…

What is the present value of the following cash flow stream at a rate of 6.25%? YEAR O=O YEAR 1= P75 YEAR 2= P225 YEAR 3=PO YEAR 4=P300 * 411.57 433.23 456.03 480.03 505.30

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: 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: What is the present value of the following cash flow at a 12% discount rate?…

A: Present value is calculated using the discounting factor of Rate @ 12%

Q: For the cash flows shown, determine the equivalent future worth in year 10 at an interest rate of…

A: Since you have asked a question with multiple parts, we will solve the first 3 parts for you. Please…

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: For the net cash flow series, find the external rate of return (EROR) using the MIRR method with an…

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

Q: What is the present value of the cash flows?

A: Information Provided: Discount Rate = 7.83% Cash flow Year 1 = $2570 Cash flow Year 2 = 0 Cash flow…

Q: At a rate of 9%, what is the present value of the following cash flow stream? $0 at Time 0; $1,000…

A: Introduction:- Present value is the current value of the future sum of money, at a specified rate of…

Q: Problem 07.037 - MIRR calculation For the net cash flow series, find the external rate of return…

A: given information the investment rate = 16% borrowing rate = 11%

Q: Given the following cash flow for a certain investment and a MARR of 12% per year: 0 1 2 3 4 5 6…

A: Here, Cash Flow in Year 0 is -P30,000 Cash Flow in Year 1 is -P 19,000 Cash Flow in Year 2, 3 and 4…

Q: Calculate the future (terminal) value of each stream at the end of year 5 with a compound annual…

A: Future Value: Future value is the value of an asset after a particular period of time, considering…

Q: Required: a. What are the operating cash flows in each year? b. What are the total cash flows in…

A: Calculation of operating cash flow and total cash flows 1 to 5 years Particulars Year 1 Year 2…

Q: For the nonconventional net cash flow series shown, the external rate of return per year using the…

A: Computation:

Q: Given the following cash flows, what is the future value at year ten when compounded at an interest…

A: Future value of an asset is the value of that asset at a future date at a given growth rate. It is…

Q: Compute the payback period for an investment with the following net cash flows. (Round your answer…

A: >Payback period is the amount of time it will take to get the money invested back. >It is…

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

A: Future value of Annuity formula is Future value of first 5 years of Annuity x , at end of 5…

Q: Compute the payback period for an investment with the following net cash flows. (Round your answer…

A: Last year in which cumulative net cash flow is negative (Y) = 4th year Minimum cash inflow required…

Q: Assume that you will receive $2,000 a year in Years 1 through 5, $3,000 a year in Years 6 through 8,…

A: Let CFn be the cashflow in year n. CF1 to CF5 = $2000 CF6 to CF8 = $3000 CF9 = $4000 r = 14%

Q: Find the Modified Internal Rate of Return (MIRR) for the following annual series of cash flows,…

A: Modified internal rate of return assumes that positive cash flows are invested at a firm’s cost of…

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: Consider the following cash flows over a 5-year period: −$100,000 @ t = 0;$35,000 @ t = 1; $45,000 @…

A: Net cash flows and cumulative cash flows Year Net Cash Flow Cumulative Cash Flow 0 -100,000…

Q: b) Aida Kamilia won RM1,000,000 in a contest, to be paid in twenty RM50,000 payments at yearly…

A: Hi, there, Thanks for posting the question. As per our Q&A honour code, we must answer the first…

Q: Ann knows that the effective rate is 17% per year compounded monthly. She has asked you to evaluate…

A: Interest rate (r) = 17% per annum = 1.41667% per month Let cashflows be denoted by CFn. As the…

Q: Find the annual worth (AW) that is equivalent to the following cash flow diagram, if the interest…

A: Given information: Interest rate: 8% Year Cash flows 0 0 1 0 2 2000 3 3000 4 4000 5…

Q: For the cash flow shown below. Find the external rate of return (EROR) using rate of return approach…

A: Cash Flow Statement is a part of the Financial Statement of a company. It literally means a…

Q: A cash flow series is described by the following: $10,000 + $250(t), where t is the number of…

A: Present Worth means the current value of the future stream of cash flows at a specific rate of…

Q: For the nonconventional net cash flow series shown, the external rate of return per year using the…

A: Given, Borrowing rate 8%. Investment rate is 20%.

Q: What is the present value of the following uneven cash flow stream? The annual interest rate is10%.…

A: Present value of cash flows the equivalent value of future cash flows discounted to present date.…

Q: The projected annual net cash flows associated with an investment opportunity are shown below in…

A: Here,

Q: Consider the following cash flow cash flow year 0 -1000 TL 2 +300 TL 3 +300 TL 4 +300 TL 5 +300 TL…

A: Internal Rate of Return is the rate at which NPV of the Investment is zero. It is compared with MARR…

Q: For the nonconventional net cash flow series shown, the extermal rate of retum per year using the…

A: Excel Spreadsheet:

Q: Justine Global Info Tech records the following cash flows at the end of each year for a project. If…

A: Capital budgeting: It is a method of evaluating the projects which required huge investments and…

Q: Projection of yearl cashflow Year Cashflow($) 0 (239000.00) 1 3789.00 2…

Q: For the nonconventional net cash flow series shown, the extermal rate of retum per year using the…

A: Excel Spreadsheet:

Q: Solve for the present worth of this cash flow using at 12% interest rate annually. 60 630 160 190 1…

A: Interest Rate =12% Annually Present Worth is Present value of future cash flows. Future cash flow =…

Q: Determine the rate of return per year for the cash flow series shown below. Year Cash Flow, $…

A: Internal rate of return is one of the modern techniques of capital budgeting that take into…

Q: What is the future value (as at year 4) of the following cash flows, given an interest rate of 5%…

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

Q: For the cash flows shown, determine: (a) the number of possible i* values (b) the i* value displayed…

A: Calculation of the possible i* values, IRR and external rate of return using MIRR is shown below:…

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

A: Rate ie. i =12% We have to find the Present Value of 1st diagram and then we have to calculate the…

Q: For the cash flows shown, find the value of x that makes the equivalent annual worth in years 1…

A: Equivalent annual worth is the tool which can be used by investors for assessment of investment…

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: What is the payback period of a £40000 investment with the following cash flows? Year CF 1 £20000 2…

A: The payback period refers to the amount of time it takes to recover the cost of an investment. In…

Q: Cannonier, Inc., has identified an investment project with the following cash flows: Year Cash Flow…

A: In this question we need to compute the future value of stream of cash flows after 4 years. Future…

Q: Consider another set of net cash flows: Year Cash flow 0 1,500 1 2,000 2 0 3 1,500 4…

A: Formulas:

Q: Consider the following cash flow: Year Cash Flow -$ 29,800 13,900 15,000 11,400 1 2 3 a). What is…

A: Calculation of profitability index: Answer: Profitability index at 9% rate is 1.15 Profitability…

Q: Find IRR

A: Internal Rate of Return (IRR) is a capital budgeting technique that evaluates the proposed projects…

Concept explainers

Production Budget

A budget can be defined as a financial plan designed by an undertaking for a definite period in the future that can contribute towards enhancing the financial success of the business undertaking. It is used to estimate the revenue and expenses. The budget generally takes into account both current and future income and expenses.

Question

What is the present value of the following cash flow stream at a rate of 6.25%?
YEAR O=0 YEAR 1= P75 YEAR 2= P225 YEAR 3=PO YEAR 4=P300 *
411.57
433.23
456.03
480.03
505.30

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

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%?
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
Start with the partial model in the file Ch07 P25 Build a Model.xlsx on the textbook’s Web site. Selected data for the Derby Corporation are shown here. Use the data to answer the following questions. Calculate the estimated horizon value (i.e., the value of operations at the end of the forecast period immediately after the Year-4 free cash flow). Assume growth becomes constant after Year 3. Calculate the present value of the horizon value, the present value of the free cash flows, and the estimated Year-0 value of operations. Calculate the estimated Year-0 price per share of common equity.
Project Y cost $8,000 and will generate net cash inflows of $1,500 in year one, $2,000 in year two, $2,500 in year three, $3,000 in year four and $2,000 in year five. What is the NPV using 8% as the discount rate?
Project B cost $5,000 and will generate after-tax net cash inflows of $500 in year one, $1,200 in year two, $2,000 in year three. $2,500 in year four, and $2,000 in year five. What is the NPV using 8% as the discount rate? For further instructions on net present value in Excel, see Appendix C.
What is the present value of the following cash flow stream at a rate of 15.0%? Years: 0 1 2 3 4 CFs: $0 $1,500 $3,000 $4,500 $6,000 Select one: a. $10,261 b. $12,453 c. $12,154 d. $10,859 e. $9,962
At a rate of 8%, what is the present value of the following cash flow stream? $0 at Time 0; $100 at the end of Year 1; $300 at the end of Year 2; $0 at the end of Year 3; and $500 at the end of Year 4? use excel.
What is the present value of the following cash flow stream at a rate of 9.0%? Years: 0 1 2 3 CFs: $650 $2,450 $3,175 $4,400 Group of answer choices $7,749.11 $8,967.65 $8,317.65 $10,866.57
What is the present value of the following cash flow stream at a rate of 10.0%? Years: 0 1 2 3 CFs: $750 $2,450 $3,175 $4,400 a. $10,755.00 b. $13,143.15 c. $11,855.25 d. $9,722.73 e. $8,907.02
At a rate of 5.25%, what is the future value of the following cash flow stream? Year 0: $0 Year 1: $75 Year 2: $225 Year 3: $0 Year 4: $300
What is the Net Present Value (NPV) of the following cash flows, assuming a 8.25% interest rate? Year 0 $(400,000) Year 1 $25,000 Year 2 $35,000 Year 3 $45,000 Year 4 $475,000
For the cash flows shown, determine: (a) the number of possible i* values (b) the i* value displayed by the IRR function (c) the external rate of return using the MIRR method if ii = 18% per year and ib = 10% per year. Year 0 1 2 3 4 Revenues, $ 0 25,000 19,000 4000 18,000 Costs, $ −6000 −30,000 −7000 −6000 −12,000