uppose a project has an initial outflow of $600000. If the cash flows projected for years 1-6 are $225000, $200000, $250000, $100000, $0, and $50000, respectively the IRR. Create a data table in excel to solve for the NPV based on different costs of capital and initial outflow

uppose a project has an initial outflow of $600000. If the cash flows projected for years 1-6 are $225000, $200000, $250000, $100000, $0, and $50000, respectively the IRR. Create a data table in excel to solve for the NPV based on different costs of capital and initial outflow

Financial Management: Theory & Practice

16th Edition

ISBN:9781337909730

Author:Brigham

Publisher:Brigham

Chapter11: Cash Flow Estimation And Risk Analysis

Section: Chapter Questions

Problem 7MC: Calculate the project cash flows for each year. Based on these cash flows and the average project...

See similar textbooks

Related questions

Q: Consider a 5-year bond paying 6% coupon annually. The yield is 9%. Use the duration approximation to…

A: The following information has been provided in the question: Life of Bond = 5 Years Coupon rate= 6%…

Q: You buy a 6 year bond with an annual 5% coupon at par value, $1000. If the yield to maturity at the…

A: Solution: Bond value is the present value of the cash inflows receivable from the bond for the…

Q: A company has 200,000 bonds outstanding currently trading at $924, a current stock price of $24,…

A: WACC refers to the joint cost of company's capital from all the sources of the company. It includes…

Q: (a) at a rate of 3% p.a. effective, for 20 years. Compute the present value of an annuity due that…

A: As per Bartleby Honor Code, when multiple independent questions are asked, the expert is required…

Q: On July 1, 2000, the New York Mets reached an agreement with Bobby Bonilla to defer the remaining…

A: As per the information provided : Amount = $5.6 millionInstallment = 25 equal installmentsRate =…

Q: Average payment period of PETRON STATEMENT OF FINANCIAL POSITION AND INCOME STATEMENT OF 3 COMPANIES…

A: Average payment period is the time taken to pay accounts payable dues. It can be calculated Average…

Q: (Expected rate of return and risk) B. J. Gautney Enterprises is evaluating a security. One-year…

A: The expected return for a portfolio is the weighted average of return for the individual securities.…

Q: Define a floating-rate bond and give examples

A: Floating-rate bond is a bond pays a variable interest rate. The interest rate is depends on a…

Q: If $1000 is deposited at the end of each year for 5 years into an ordinary annuity earning 8.99%…

A: Interest amount using ordinary annuity can be calculated by subtracting principal by the end of the…

Q: ike Bank starts with $3000 in bank capital. It then accepts $2000 in deposits. It keeps 25 percent…

A: Here, Bank Capital is $3,000 Deposits of Bank is $2,000 Reserve is 25% of Deposits which is equal to…

Q: A project requires a current expenditure of $350 and expects to generate $100 cash inflows at the…

A: We need to examine the NPV profile and decide whether to accept the project and under what…

Q: Salvatore has the opportunity to invest in a scheme which will pay $7,500 at the end of each of the…

A: NPV is the difference between Present Value of cash Inflows and Initial Investment. A project with…

Q: 3) What is the capitalized worth, when i 12% per year, of $2.000 per year, starting in year one and…

A: Annual cost (A) = $2000 Repeating cost (R) = $11000 in year 5, every 4 years i = 12%

Q: A student needs P4000 per year for 4 years to attend college. Her father invested P5000 in a 7%…

A: Due to time value of money, the purchasing power of money changes over time. That is the value of a…

Q: Hack Wellington Co. is considering a three-year project that will require an initial investment of…

A: PV of Outflow = $35000 PV of Inflow under good condition = 40000*a<3> = 40000*(1-(1+i)^-n)/i =…

Q: Explain each of the investment instruments stated below that offered by financial institutions.…

A: Futures and Options are derivative products. The main purpose or objective of derivatives is to…

Q: Production, Direct Labor, Direct Materials, Sales Budgets, Budgeted Contribution Margin Greiner…

A: Answer- Working Note : Greiner Company Production Budget For the First Quarter of the…

Q: Find an expression for the marginal revenue function, s

A: Marginal revenue is the additional revenue earned from selling one more unit of output. It is…

Q: Debt ratio of JFC * STATEMENT OF FINANCIAL POSITION AND INCOME STATEMENT OF 3 COMIPANIES AS DECEMBER…

A: Solution:- Debt ratio means the ratio of total debt of a company to its total assets. So, Debt ratio…

Q: 1. Net Assets method 2. Yield method 3. Fair value method

A: Since in the given case, we firstly make the different class of shares to uniform class of shares,…

Q: The Sisyphean Company has a bond outstanding with a face value of $5,000 that reaches maturity in 15…

A: Par value (FV) = $5000 Years to maturity = 15 Years Coupon rate = 8.4% Semi annual coupon amount (C)…

Q: Machine A Machine B R100 000 R110 000 Initial cost 5 years 5 years Expected economic life R10 000 0.…

A: Payback period- It represents the time period required for recovery of the initial investment made…

Q: A small coffee shop currently offers a cup of cafe latte for P106. The variable costs are P63 per…

A: Here, Number of Units Sold is 10,079 Sales Price per cup is P106 Variable Cost per cup is P63 Profit…

Q: Use the following to answer the question below. Reserve Requirement Ratio 25.8% Initial Deposit $1…

A: Solution:- Total change in deposits is the change in initial amount after the effect of Reserve…

Q: UESTION 5 nd investor is considering investing $450 000 in a bond that would he expected inflation…

A: Nominal interest rate is interest rate including the impact of inflation but real interest rate is…

Q: Year 1 10 $245.0 $245.0 $245.0 $245.0 $245.0 + $5,000 A corporation issues a bond that generates the…

A: We need to calculate coupon rate of bond by dividing the coupon amount with face/notional value of…

Q: Slow 'n Steady Enterprises currently pays an annual dividend of $1.50 /share. Investors expect that…

A: Annual dividend = $1.5 Equity cost of capital = 0.09 Value of one share = ?

Q: A buyer is considering purchasing a 35-acre parcel in Apache Junction, Arizona for economic…

A: Solution: As per the terms and conditions of the loan, the loan can be repaid in equal periodic…

Q: Wyatt oil presently pays no dividend. You anticipate Wyatt Oil will begin paying an annual dividend…

A: Dividend after 2 years (D2) = $0.49 Growth rate (g) = 4.2% Required rate of return (r) = 11.2%

Q: Compute the above indicated ratios for DEL Bhd. b) Evaluate the overall performance of the company…

A: Indicated ratios are the same as Industry average ratios. So, the ratios that need to be computed…

Q: a. Compute the net present value of each project. b. If the company accepts all positive net present…

A: Net present value = - Initial outlay + Present value of future cash flows. Net present value is…

Q: (b) What do you mean by payback period? What are their significano:s and drawbacks? Find the payback…

A: Payback period is a method to appraise capital investment projects. It is the time required for a…

Q: Show your work for all answers! 1. Today Zack purchased an investment grade gold coin for $50,000.…

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

Q: You are planning on investing to save for retirement.You will invest $25,000 each year for 20…

Q: Diol Athletics is trying to determine its optimal capital structure, which now consists of only debt…

A: Formula of Levered Beta is as follows: Levered Beta= Unlevered Beta×1+1- Tax Rate×DebtEquity

Q: 9. Taxes and WACC Caddie Manufacturing has a target debt-equity ratio of .45. Its cost of equity is…

A: WACC used to represent the cost of capital of the company, where each and every category of the…

Q: 3b. Inflation is expected to average 2.4% per year for the next 44 years. What percentage of the…

A: We have to find the % loss in the purchasing power of the dollar under the given inflation scenario.

Q: |A stock's expected return has the following distribution: Demand for the product Probability Rate…

A: Demand for the product Probability Return of Return(ROR) Weak 10.00% 50.00% Below Average 20.00%…

Q: w (inputting a similar table, with related work shown above or below, is suggested). Payment EOY…

A: Loan are paid by equal amount but the amount of interest and principal amount paid are different for…

Q: (a) Self-regulation, regulation by the government and regulation by a governmental agency are three…

A: Self regulation is to involve government and private oversight , It is the unique combination of…

Q: 6c. An initial $2000 investment is made that returns profits of $1000 and 1500 in the first and…

A: Present Value: It is the current worth of a future amount of cash or stream of income given a…

Q: QUESTION 4 Which of the following statements are correct? Pick two correct answers. Deposits are…

A: Deposits normally created by the bank when some one new customer open account with in the bank and…

Q: Project A has the following information: Year 0 1 2 3 4 5 Initial investment outlay 125,000…

A: NPV is calculated by deducting present value of cash outflows from present value of cash inflows.

Q: co. Derive F= uhtre symbals have Hhei'r usual meoniage

Q: Suppose that in 2018 the price index was 120 and Ifikile purchased R35 000 worth of bonds. One year…

A: Bond Value in 2019 39,725.00 Bond Value in 2018 35,000.00 Tax Rate = 40%

Q: 15. If you make a single deposit into an account, at what annual interest rate compounded yearly…

A: It can be calculated using Yield to maturity can be calculated by following function in excel =RATE…

Q: What is Debt to equity ratio of PETRON?

A: The formula for the calculation of debt equity ratio is as follows: Debt equity ratio=Debt Equity

Q: If these projects were independent, which project(s) would be accepted? Why? If these projects were…

A: We use different capital budgeting tools to determine the financial feasibility of projects that are…

Q: Similar to a stock option, a warrant is a contract between two parties that gives one the right to…

A: When a warrant is exercised by the holder, he can get shares in the issuing party's company. The…

Q: Cash conversion cycle of PETRON * STATEMENT OF FINANCIAL POSITION AND INCOME STATEMENT OF 3…

A: Formula: Cash conversion cycle=Days inventory outstanding+Days sales outstanding-Days payable…

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

Suppose a project has an initial outflow of $600000. If the cash flows projected for years 1-6 are $225000, $200000, $250000, $100000, $0, and $50000, respectively the IRR.

Create a data table in excel to solve for the NPV based on different costs of capital and initial outflow.

Definition Definition Calculation used to evaluate the investment and financing decisions that involve cash flows occurring over multiple periods. NPV is calculated as the difference between the present value of cash inflow and cash outflow. NPV is used for capital budgeting and investment planning as well as to compare similar investment alternatives.

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

Internal rate of return For the project shown in the following table, , calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable. ..... The project's IRR is %. (Round to two decimal places.) Data table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial investment (CF,) $150,000 Year (t) Cash inflows (CF;) $35,000 $30,000 $35,000 $40,000 $50,000 1 2 3 4 5 Print Done
Suppose a project has an initial outflow of $600000. If the cash flows projected for years 1-6 are $225000, $200000, $250000, $100000, $0, and $50000, respectively the IRR. Draw the timeline. Set up (by hand) the equation to solve for IRR. DO NOT SOLVE. Solve for the IRR using excel. Create a data table in excel to solve for the NPV based on different costs of capital and initial outflow.
Calculate/estimate the IRR(s) for a 6-year project with the following cash flows: CF0 = -50, CF1 =28 = CF2 = CF3 = CF4 = CF5, and CF6 = -93. In Excel, plot the NPV (= Y axis) against r (= discountrate), using r = 0%, 2%, and so on until you find all IRRs in the chart. Identify/estimate all IRRs.
Internal rate of return and modified internal rate of return For the project shown in the following table,, calculate the internal rate of return (IRR) and modified internal rate of return (MIRR). If the cost of capital is 12.13%, indicate whether the project is acceptable according to IRR and MIRR. The project's IRR is %. (Round to two decimal places.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Initial investment (CF) Year (t) 1 2 3 4 5 Print $70,000 Cash inflows (CFt) $15,000 $25,000 $25,000 $15,000 $10,000 Done X
(a) Calculate the payback period for each project. (b) Calculate the net present value (NPV) for each project. (c) Calculate the profitability index of each project. (d) Explain to the company which project should be implemented. Support your answer.
Given the following cash flows for project A: C0 = -1000, C1 = +600 ,C2 = +400, and C3 = +1500, calculate the payback period)
The blue curve (labeled "L") depicts the NPV for a project with larger cash flows later of -$1,000, $100, $300, $400, and $675. The red curve (labeled "S") depicts the NPV for a project with larger cash flows sooner of -$1,000, $500, $400, $300, and $100. Drag on the graph either left or right to change the cost of capital interest rate at which the NPV is evaluated for the two projects. Project S: ��=��0+∑�=1��(1+�)�=−$1,000+$500(1+0.1000)1+$400(1+0.1000)2+$300(1+0.1000)3+$100(1+0.1000)4=$78.82
Calculate the project cash flows for each year. Based on these cash flows and the average project cost of capital, what are the projects NPV, IRR, MIRR, PI, payback, and discounted payback? Do these indicators suggest that the project should be undertaken?
Calculate the cash flows for each year. Based on these cash flows and the average project cost of capital, what are the projects NPV, IRR, MIRR, PI, payback, and discounted payback? Do these indicators suggest that the project should be undertaken?
What is the net present value (NPV) of a project with cashflow for two periods. Write down the formula, clearly explain each term.
NOTE: Provide a format and show your work (example: N = 6, PV = XXX, I = X%, etc.) 1. As the project manager at Jelz, Inc., you are considering a project that will cost $4,276 and produce cash flows of $1,050 in year 1, $1,250 in year 2, $1,250 in year 3, and $1,550 in year 4. Find the rate of return for the project and determine if you should take the project if your required rate of return is 7.15%. (This is a 2 part question, make sure you answer both parts. Numerical answers should be rounded to 2 decimal places.) 2. You are looking to buy a car. You can afford $550 in monthly payments for five years. In addition to the loan, you can make a $6,000 down payment. If interest rates are 7.25 percent APR, what price of car can you afford (loan plus down payment)? (Do not round intermediate calculations and round your final answer to 2 decimal places.)
K Internal rate of return and modified internal rate of return For the project shown in the following table,, calculate the internal rate of return (IRR) and modified internal rate of return (MIRR). If the cost of capital is 13.04%, indicate whether the project is acceptable according to IRR and MIRR. The project's IRR is %. (Round to two decimal places.) Data table (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Initial investment (CFO) Year (t) $80,000 Cash inflows (CF₂) 1 $10,000 2345 $25,000 $10,000 $15,000 $45,000 Print Done -