Suppose you are considering a project has an initial cost of $600 that has an ongoing benefit of $ 250. Further, there is an ongoing cost that is equal to $90, which increases by 10% each year ( compounding). Assume the project lasts 6 years. If the appropriate discount rate is 6%. Calculate: a) the Net Present Value = $ Blank 1 b) the Benefit Cost Ratio Blank 2 c) should the project be accepted or rejected? Explain your answer using the information from part a) and b). Answer = Blank 3 (accept/reject) provide your answers to two decimal places. Do not include any commas (,) "$" or "%" in your answers. Ensure you show all your working in your spreadsheet. (best show with excel)

Suppose you are considering a project has an initial cost of $600 that has an ongoing benefit of $ 250. Further, there is an ongoing cost that is equal to $90, which increases by 10% each year ( compounding). Assume the project lasts 6 years. If the appropriate discount rate is 6%. Calculate: a) the Net Present Value = $ Blank 1 b) the Benefit Cost Ratio Blank 2 c) should the project be accepted or rejected? Explain your answer using the information from part a) and b). Answer = Blank 3 (accept/reject) provide your answers to two decimal places. Do not include any commas (,) "$" or "%" in your answers. Ensure you show all your working in your spreadsheet. (best show with excel)

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter12: Capital Budgeting: Decision Criteria

Section: Chapter Questions

Problem 11MC: In an unrelated analysis, you have the opportunity to choose between the following two mutually...

See similar textbooks

Similar questions

Suppose you are considering a project has an initial cost of $500 that has an ongoing benefit of $250. Further, there is an ongoing cost that is equal to $90, which increases by 10% each year (compounding). Assume the project lasts 6 years. If the appropriate discount rate is 6%. Calculate: a) the Net Present Value = $Blank 1 b) the Benefit Cost Ratio = Blank 2 c) should the project be accepted or rejected? Explain your answer using the information from part a) and b). Answer =Blank 3 (accept/reject) Provide your answers to two decimal places. Do not include any commas (,) "$" or "%" in your answers. Ensure you show all your working in your spreadsheet.
Suppose a project with a 6% discount rate yields R5000 for the next three years. Annual operating costs amount to R1000 for each year, and the one time initial investment cost is R8000. a. Calculate the Net Present Value (NPV) of this project.b. Calculate the cost-benefit ratio for the project. c. Is the project acceptable? Motivate your answer.
Given the following data, use present worth analysis to find the better alternative, A or B. Use an analysis period of 12 years and 12% annual interest rate. A B Initial cost 9,010 14,542 Annual benefit 5,627 9,399 Salvage value 1,247 -2,430 6 years 4 years Useful life What is the difference between the present worth of alternative B and A, specifically what is PWB-PWA? State your answer with 2 decimal places
Assume that it costs $1,000 to start a project. If the project will give $400 profit in the first year, $500 in the second year and $300 in the third year. find the payback period. Now assume that the interest rate is 10%, find the net present value (NPV) and the profitability index (PI) for this project
Assume that it costs $1000 to start a project. If the project will give $400 profit in the first year, $500 in the second year and $300 in the third year. Find the pay back period. Now assume that the interest rate is 10%, find the net present value (NPV) and the profitability index (PI) for this project
1. Assuming monetary benefits of a construction project at $50,000 per year during year 1, 2, 3 and 5 (not year 4), one-time costs (initial investment) of $15,000, recurring costs of $35,000 per year (every year), a discount rate of 10 per cent, and a 5-year time horizon, calculate the net present value (NPV) of an information system's costs and benefits. Calculate the overall return on investment (ROI) of the project. During which year does break-even occur?. Use the NPV template provided (modify to suit your answer) and clearly display the NPV, ROI, and year in which payback occurs. Write a paragraph explaining whether you would recommend investing in this project based on your ﬁnancial analysis. Explain your answer referring to the NPV, ROI and payback for this project. Discount Rate (10%) Year 0 - 1.0000 Year 1 - .9091 Year 2 - .8264 Year 3 - .7513 Year 4 - .6830 Year 5 - .6209
Please see attached:
Perform a financial analysis for a project using the format below. Assume the projected costs and benefits for this project are spread over four years as follows: estimated costs are $100,00 in year 1 and $25,000 each year 2, 4, and 4. (hint: just change the years in the template file from 0,1,2,3, and 4. This discount factors will automatically be recalculated). Estimated benefits are $0 in Year 1 and $80,000 each years 2,3, and 4. Use an 8% discount rate. Use the business case financials template provided on the companion web site to calculate and clearly display the NPV, ROI, and year in which payback occurs. In addition, explain whether you would recommend investing in this project based on your financial analysis.
Which of the following describes the NPV decision rule? Accept if the cost of the project is recouped within 3 years. Accept if the PV of the cash inflows of the project divided by the absolute value of the cost of the project is greater than one. Accept if the PV of the cash inflows from the project minus the cost of the project is greater than zero Accept if the average net income from the project divided by the average book value is greater than the target required Accept if the rate of return earned on the project is greater than the required return for the project.
2) First, calculate the payback period and NPV for all projects below. For all the projects, the relevant discount rate is 10%. Then, comment on why the payback period provides misleading information about the following: a. Project A b. Project B versus Project C c. Project D versus Project E d. Project D versus Project F Year A B C D E F 0 -1.000 -1.000 -1.000 -1.000 -1.000 -1.000 1 1,000 100 400 500 400 500 2 200 300 500 400 500 3 300 200 500 400 10.000 4 400 100 400 5 500 500 400
Explain how the internal rate of return and net present value are related. If a project has an NPV of $50,000 using a 10 percent discount factor, what does this imply about that project's IRR?
Given the financial data in the table below for two mutually exclusive alternatives, determine the value "X" for the two alternatives to be equally attractive. Use an interest rate of 10% per year. Initial cost $2,500 $4,000 Annual benefit 500 600 Life You do not need to interpolate, just answer the closest n that surrounds your number. For example between year so and so.