A music company is considering creating the world's largest piano. Cost and cash flow details are listed below. The company requires a 12% return on its capital. a) What is the present value of the yearly cash flows? (round to nearest dollar) b) What is the net present value of the project? (round to nearest dollar) c) What is the internal rate of return of the project? (round to two decimal places)
Cost of Project ($2,500,000)
Yr 1 cash flow (300,000)
Yr 2 cash flow (150,000)
Yr 3 cash flow 50,000
Yr 4 cash flow 250,000
Yr 5 cash flow 800,000
Yr 6 cash flow 1,200,000
Yr 7 cash flow 3,500,000
Can you please show me how to do this in Excel!
I am so thankful for all that you guys do for me.
Please see the attachment for the PV, NPV, and IRR calculations.
Present value is the sum of the present value of each of the cash flows from year 1 to 7. PV = $2,452,153
Net present value = PV of cash flows - initial investment = $2,452,153 - 2,500,000 = -$47,847
The internal rate of return is found using the excel function IRR. IRR = 11.69%
Screenshot with formulas
Can you please upvote? Thank You :-)
A music company is considering creating the world's largest piano. Cost and cash flow details are...
Management of a firm with a cost of capital of 10 percent is considering a $126,000 investment with annual cash flow of $52,460 for three years. Use Appendix A and Appendix D to answer the questions. What are the investment’s net present value and internal rate of return? Use a minus sign to enter a negative value, if any. Round your answers for the net present value to the nearest dollar and for the internal rate of return to the...
The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $1,200,000, and it would cost another $21,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $578,000. The machine would require an increase in net working capital (inventory) of $12,500. The sprayer would not change revenues, but it is...
A company is considering a 3-year project that requires an initial installed equipment cost of $11,000. The project engineer has estimated that the operating cash flows will be $5,000 in year 1, $6,000 in year 2, and $8,000 in year 3. The new machine will also require a parts inventory of $2,000 at the beginning of the project (assume this inventory can be sold for cost at the end of the project). It is also estimated that the equipment can...
A company is considering a 3-year project that requires an initial installed equipment cost of $10,000. The project engineer has estimated that the operating cash flows will be $4,000 in year 1, $6,000 in year 2, and $8,000 in year 3. The new machine will also require a parts inventory of $3,000 at the beginning of the project (assume this inventory can be sold for cost at the end of the project). It is also estimated that the equipment can...
3. Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds (1957 replicas). The necessary foundry equipment will cost a total of $4,000,000 and will be depreciated using a five-year MACRS life, The sales manager has an estimate for the sale of the classic Thunderbirds. The annual sales volume will be as follows: Year one: 240 Year two: 290 Year three: 330 Year four: 350 Year five: 300 If the sales price is $26,000...
same question, three pictures so they are not blurry. thank you Project cash flow and NPV. The managers of Classic Autos Incorporated plan to manufacture classic Thunderbirds (1957 replicas). The necessary foundry equipment will cost a total of $4,000,000 and will be depreciated using a five-year MACRS life, The sales manager has an estimate for the sale of the classic Thunderbirds. The annual sales volume will be as follows: Year one: 250 Year two: 280 Year three: 360 Year four:...
Sandrine Machinery is a Swiss multinational manufacturing company. Currently, Sandrine's financial planners are considering undertaking a 1-year project in the United States. The project's expected dollar-denominated cash flows consist of an initial investment of $2000 and a cash inflow the following year of $2400. Sandrine estimates that its risk-adjusted cost of capital is 13%. Currently, 1 U.S. dollar will buy 0.83 Swiss franc. In addition, 1-year risk-free securities in the United States are yielding 6%, while similar securities in Switzerland...
Sandrine Machinery is a Swiss multinational manufacturing company. Currently, Sandrine's financial planners are considering undertaking a 1-year project in the United States. The project's expected dollar-denominated cash flows consist of an initial investment of $2000 and a cash inflow the following year of $2400. Sandrine estimates that its risk-adjusted cost of capital is 13%. Currently, 1 U.S. dollar will buy 0.71 Swiss franc. In addition, 1-year risk-free securities in the United States are yielding 7.75%, while similar securities in Switzerland...
Consider the previous question with the following details: A company is considering a project that will last for 4 years with no residual value. The project has the following cash flows and details: Period 0: Cash flow-$165,000 (Cost of project) Period 1: Cash flow $85,000, Net Income $47,500 Period 2: Cash flow $66,000, Net Income $28,500 Period 3: Cash flow $50,000, Net Income $12,500 Period 4: Cash flow $50,000, Net Income $12,500 Average Book Value $75,000 The required annual return...
(Calculating free cash flows) You are considering new elliptical trainers and you feel you can sell 3,000 of these per year for 5 years (after which time this project is expected to shut down when it is leamed that being fit is unhealthy). The elliptical trainers would sell for $1,000 each and have a vanable cost of $500 each. The annual fixed costs associated with production would be $1,300,000. In addition, there would be a $7,000,000 initial expenditure associated with...