Assume that $1,285,673 is to be invested in a project whose annual projected cash flows are as follows: Year 1 = $235,678, Year 2 = $267,854, Year 3 = $298,054, Year 4 = $314,567, and Year 5 = $325,678. Assume that the required rate of return is 5.25%. Compute the NPV by using Microsoft Excel's NPV function. Be sure to show your work. Should the project be pursued? Why or why not?

Assume that $1,285,673 is to be invested in a project whose annual projected cash flows are as follows: Year 1 = $235,678, Year 2 = $267,854, Year 3 = $298,054, Year 4 = $314,567, and Year 5 = $325,678. Assume that the required rate of return is 5.25%. Compute the NPV by using Microsoft Excel's NPV function. Be sure to show your work. Should the project be pursued? Why or why not?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 35P

See similar textbooks

Similar questions

It costs a pharmaceutical company 75,000 to produce a 1000-pound batch of a drug. The average yield from a batch is unknown but the best case is 90% yield (that is, 900 pounds of good drug will be produced), the most likely case is 85% yield, and the worst case is 70% yield. The annual demand for the drug is unknown, with the best case being 20,000 pounds, the most likely case 17,500 pounds, and the worst case 10,000 pounds. The drug sells for 125 per pound and leftover amounts of the drug can be sold for 30 per pound. To maximize annual expected profit, how many batches of the drug should the company produce? You can assume that it will produce the batches only once, before demand for the drug is known.
What is the future worth (in Year 10) of $23,000 deposited at the end of Year 3 plus $28,000 deposited at the end of Year 5, and $20,000 deposited at the end of Year 8 at an interest rate of 5% per year?
du/courses/423127/quizzes/3325 take/questions/60963079 Table on the right shows the net cashflow (NCF) and cumulative cashflow for two projects X and Y. Answer the following questions. 1- Based on Descarte's rule of signs, what is the max. number of real ROR (i*) for project X? (put numerical number) 2- Looking at cumulative CF of project X, can we tell that it has only one positive i* value? (put "yes" Project X Project Y Year NCF Cumulative CE NCF Cumulative CF or "no") 180 -100 20,000 20,000 1 50 -130 16,000 36,000 3- Based on Descarte's rule of signs, what is the 36,000 2 50 80 50 30 25,000 25,000 max. number of real ROR (i*) for project Y? (put 4 50 20 30,000 5,000 numerical number) 4- Looking at cumulative CF of project Y, can we tell that it has only one positive i* value? (put "yes" or "no")
Mary is a sales person for Challenge Furniture. She receives an incremental commission based on the table below. If she sells $26,000 and has already received a draw of $766.15, how much commission is still owed to Mary? level 1 1-11,700 3.7% sales volume 2 11,701-21,200 4.3% commission rate 3 over 21,200 4.7%
Conoly Co. has identified an investment projectwith the following cash flows. If the discount rate is 10 percent, what is the present valueof these cash flows? What is the present value at 18 percent? At 24 percent?Year Cash Flow1 $ 9602 8403 9354 1,350
Dr. David Paul is a medical doctor at a small private hospital in XYZ city. He sits on the Board of Directors of the Hospital. He is also head of the Neurology Department.The hospital is undercapitalized, and they are having a board meeting to approve the budget. He requires a new MRI machine. However, the cost of the machine will impact the budget and ultimate profit of the hospital. Explain in no more than 250 words, the potential conflict of interest at the board meeting.
Company X is planning to run a project that requires an initial investment of RM 80,000.Operation cost is estimated at RM 20,000 per year starting one year from the start of theproject until its project life. Starting second year onwards, the operation cost is expectedto increase by RM 5,000 from previous year. The project will start to generate its annualincome of RM 70,000 on the second year until fifth year. The salvage value of the projectis RM 50,000 and its project life is five years. a) Construct the cash flow diagram to summarize the above transactions. b) Determine the expected project value at the end of five years. Assume the growth rateis 12%.
A new electric power generation plant is expected to cost $42,000,000 to complete. The revenues generated by the new plant are expected to be $3,875,000 per year, while operational expenses are estimated to be $2,000,000 per year. The plant will last 40 years, and the electric authority uses a 3% interest rate. Determine if the plant will be able to recover its investment using the following methods: a. IRR (show your solution for interpolation; use 5 decimal places for the interpolation procedure) b. Payback period
A building has an NOI of $130,000 and is being valued with a cap rate of 4%. Using the income approach, what is the value of the building? $4,130,000 $1,300,000 $3,250,000 $2,450,000
A project has the following cash flows : Year Cash Flows 0 −$ 12,200 1 5,410 2 7,810 3 5,200 4 −1,540 Assuming the appropriate interest rate is 8 percent, what is the MIRR for this project using the discounting? approach
Assuming your company is producing Apple and Samsung phone cases. It is required to process in the assembly and paint shops to make either phone case. It takes 1/60 of a day and 1/40 of a day to paint an Apple case and a Samsung case in the paint shop, respectively. It takes 1/50 of a day to assemble either type of case in the assembly shop. An Apple phone case and a Samsung phone case yield profits of $300 and $220, respectively, per case sold. What is a maximum-profit daily production plan for your company?
An electronics firm is currently manufacturing an item that has a variable cost of $0.50 per unit and a selling price of $1.10 per unit. Fixed costs are $15,000. Current volume is 30,000 units. The firm can substantially improve the product quality by adding a new piece of equipment at an additional fixed cost of $5,600. Variable cost would increase to $0.65 and the selling price would be revised to $1.30 with the expectation that the volume would be 50,000 units as a result of a higher-quality product. If the firm does not add new equipment, its profit will be =_____ dollars (round your response to the nearest whole number and include a minus sign if the profit is negative).