A Company project of 10 years, Paying 2,000,000 a year with a 4% growth each year, at the end of project it will make a 10,000,000 lump sum payment, the rate is 14%. How do you find the PV on Excel? I know the answer just need help translating it to excel using the PV excel formula?

A Company project of 10 years, Paying 2,000,000 a year with a 4% growth each year, at the end of project it will make a 10,000,000 lump sum payment, the rate is 14%. How do you find the PV on Excel? I know the answer just need help translating it to excel using the PV excel formula?

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 6TP: Dinaro Inc. is looking at an investment project that has an NPV of ($5,000). The hurdle rate is 8%.

See similar textbooks

Related questions

Q: A company is considering an investment project that would cost $10 million today and yield a payoff…

A: A company undertakes an investment with the expectation of earning profits.Also, the company expects…

Q: he Ham Company is analyzing new capital investments. Projects X Y and Z. Each project has a cost of…

A: For determining a project’s financial feasibility, we often use capital budgeting tools. The…

Q: As the project manager at Jelz, Inc., you are considering a project that will cost $4,276 and…

A: The IRR is the investment discount rate that corresponds to the difference between the original…

Q: Assume that you are 20 years old now and have $1000 in hand to invest in one business project, and…

A: Future value of money refers to the expected value of a sum of money at a future date, considering…

Q: Question: A project pays $2000 today, costs $5000 a year from now, and pays $12, 500 in two years.…

A: Here, Cash inflow in year 0 is $2,000 Cash Outflow in Year 1 is $5,000 Cash Inflow in Year 2 is…

Q: Consider a project with a 15 year time horizon (T=14). Suppose that in the first two years, the…

A: Time Period is 15 years(T=14) Project cost at t=0 is $175 and t=1 is $150 Net benefits at t=2 is $40…

Q: You have an income of $4,000 in Period 0 and $0 in Period 1. Four different investment opportunities…

A: Given Information: Market interest 11% Income is $4000

Q: Hello, can you please answer this problem with excel and formulas, thank you! Kaleb Konstruction,…

A: a) The payback period alludes to what extent it takes for a speculator to hit breakeven to recoup…

Q: Consider a project in which you have to invest $15,000 today and you will receive $24847 in one…

A: Future Value = $24,847Present Value = $15,000Number of years (n) = 1We need to calculate the…

Q: The internal rate of return (IRR) is the discount rate that results in a net present value (NPV) of…

A: According to rule, because you have posted multiple questions, we will answer the First question…

Q: Consider a project with an initial investment (today, t = 0) of $225,000. This project will generate…

A: Profitability index is an important capital budgeting tool. This tool is often used to rank…

Q: A project whose machinery and installation cost $15,000, promises a net stream of savings of…

A: Given that;The cash flows are:Year 0: -$15,000Year 1: $3,000Year 2: $3,000Year 3: $3,000Year 4:…

Q: Below are four cases that you will have to solve using Excel spreadsheets. 2nd case The COMPETIDORA…

A: Capital budgeting refers to a concept used for estimating the viability of the project using various…

Q: Compute the IRR, NPV, Pi, and payback period for the following two projects. Assume the required…

A: Internal rate of return – It is the discount rate that equates the present value of the estimated…

Q: use excel 9. A firm faces three investment opportunities A, B and C: A. NPV = $3m, investment =…

A: NPV computes the existing value of future benefits by discounting future worth with a stated…

Q: Find the NPV of a project that costs $694,000 today and generates expected cash flows in each of the…

A: NPV is also known as Net Present Value. It is a capital budgeting techniques which help in decision…

Q: Use the format in the figure below to perform a financial analysis. Create a spreadsheet to perform…

A: ROI refers to the return on investment.. ROI can be determined by dividing benefits or revenue…

Q: Consider the following Table: 1. Draw the chash flow diagrams for (A, B and C) alternatives

A: Following formula is used for calculating present worth (PW) of a project. PW=Intial Cost+Annual…

Q: Do the following problems. You must show your work.c) Find the IRR and MIRR of the following project…

A: Excel Spreadsheet:

Q: Find internal rate of return of a project with an initial cost of $43,000, expected net cash inflows…

A: Capital budgeting approaches are the techniques that the management of the company adopts to…

Q: A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 7 years,…

A: Solution:- We know, Net Present value (NPV) means the net present value of cash inflows after…

Q: You have an opportunity to invest $104,000 now in return for $79,800 in one year and $29,600 in two…

A: A discounted method called net present value (NPV) is used to assess the effectiveness of long-term…

Q: NPV Calculate the net present value (NPV) for a 10-year project with an initial investment of…

A: NPV is the sum of present value of future cashflows less initial investment

Q: Coore Manufacturing has the following two possible projects. The required return is 10 percent.…

A: Capital budgeting refers to the concept used to estimate the viability of the project by calculating…

Q: You must find the payback for a project, and you have misplaced some of the information that you…

A: Cash Flow $ 60,000.00 NPV $ 75,000.00 Time Period 5 WACC 10%

Q: Emily Company has a minimum required rate of return of 9%. It is considering investing in a project…

A: The profitability index is a kind of capital budgeting technique that evaluates various proposed…

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

A Company project of 10 years, Paying 2,000,000 a year with a 4% growth each year, at the end of project it will make a 10,000,000 lump sum payment, the rate is 14%.

How do you find the PV on Excel?

I know the answer just need help translating it to excel using the PV excel formula?

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

Please complete the following in Excel and show work/formulas used (if used)
A company is considering an investment project that would cost $10 million today and yield a payoff of $15 million in 4 years. Complete the following table by indicating whether the firm should undertake the project for each of the interest rates listed. Interest Rate Undertake Project? Yes No 11% 10% 9% 8% Which of the following formulas would help you figure out the exact cutoff for the interest rate between profitability and nonprofitability? 10=15(1+x)410=151+x4 10=15x410=15x4 10=15×(1+x)410=15×1+x4 15=10(1+x)4
Please draw the graph and solve neatly. I will rate once given me the right answer. Question: A project pays $2000 today, costs $5000 a year from now, and pays $12, 500 in two years. What is the rate of return? Assume that the MARR is 25%
I need this question completed in 10 minutes
You have an income of $4,000 in Period 0 and $0 in Period 1. Four different investment opportunities have been given to you, which is summarized in the table below: Project Cost Worth in Period 1 $1,620 $2,400 $1,040 $1,500 $2,000 $1,000 D $700 $910 If the market interest rate is 11%, what is the optimal investment you can make? What would your consumption be in Period 0 and Period 1 if you take on the optimal set of investments?
Please answer this and kindly show the solution/computation and final answers using microsoft excel. I'll give you a like. Thank you!
Consider a project with a 15 year time horizon (T=14). Suppose that in the first two years, the project has a cost of $175 and $150 respectively and no benefits. From the third year on, the project yields benefits. Starting with a benefit of $40 in t=2, the benefits continuously decline a 1% every year for the remainder of the horizon. Calculate the present value of this project. Use an Excel spreadsheet and print out your work. Consider two different interest rates (i) 3% per year and (ii) 5% per year. In each case, assume that time is (a) discrete and (b) continuous. Create a chart plotting the present value of net benefits for the project horizon under each scenario. (You should have 4 lines on the chart.) Print out your chart as well.
Below are four cases that you will have to solve using Excel spreadsheets. 2nd case The COMPETIDORA SA company has the possibility of investing in three different projects . The projections show us the following information on which a decision must be made: PROJECT X Y Initial Z$310,000 It is requested: investment $180,000 $250,000 Year 1 cash flows $50,000 $80,000 $150,000 1. Determine the internal rate of return. 2. Determine the present value. Year 2 cash flows 3. Determine the recovery period. 4. Define which is the most viable project. $70,000 $80,000 $120,000 The discount rate for the project will be 9% and the investors propose a MARR of 22%. Year 3 cash flows $80,000 $80,000 $100,000 Year 4 cash flows $100,000 $80,000
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.)
The internal rate of return (IRR) is the discount rate that results in a net present value (NPV) of zero. True False
Compute the IRR, NPV, Pi, and payback period for the following two projects. Assume the required return is 10%. Year Project A Project B 0 $-200 $-150 1 $200 $50 2 $800 $100 3 $-800 $150 Please show inputs from the BAII Plus Financial calculator of how to get these answers
I need this question completed in 10 minutes