Please show the formula and how you did the work for the following questions: 4. You...

Please show the formula and how you did the work for the following questions:

4. You have a fourth project that will cost 1700 to invest in one year from now, will generate a cash inflow of 150 starting in year three and continuing forever. If the discount rate is 8%, what is the NPV and should you accept the project based on the NPV?

5. Finally, you have a fifth project that will cost 1500 to invest in today, will generate a cash inflow of 165 in year one, which will grow at a constant rate of 2% for 29 additional years (for a total of 30 cash inflows), and will have a shutdown cost of 1000 at the end of year 30. If the project’s discount rate is 10%, what is the NPV and should you accept the project based on the NPV?

Expert Solution

jeff jeffy answered 1 year ago

This is a multipart question, can you please show the work on how you did the...

This is a multipart question, can you please show the work on how you did the problems. 1.Cost of Debt: 30 year Bonds Current Price 101.5% of par value 7.6 % Coupon Rate Semi Annual Bond 5 years to maturity Tax Rate: 40% What is the Cost of Debt? After Tax? 2.Preferred Stock: Dividend $7.50 Current Price $60.00 What is the Cost of Preferred? 3.Equity: Risk Free Rate 6.50% Market Risk Premium 6.25% Stock Beta 0.7 What is the Cost...

There are 3 questions. You must show your work and how you got the answer. PLEASE...

There are 3 questions. You must show your work and how you got the answer. PLEASE DO NOT ANSWER IF YOU ARE NOT SURE You have been asked to look at production options for the Android01, since production methods and allocation of costs have implications for cost per unit. Two alternative methods of production are being considered. Begin by gathering data (using financial information in decision making), then determine the suitability of the project. The production of Android01 will share...

Please answer the following questions regarding hydroxyapatite. Please show all work. a.) How many atoms are...

Please answer the following questions regarding hydroxyapatite. Please show all work. a.) How many atoms are in the unit cell for Hap? b.) What are the unit cell parameters? Please use the attached diagram to determine. c.) Calculate the unit cell volume for HAp. d.) Calculate the density for HAp. e.) Calculate the packing factor for HAp. f.) Derive an equation for calculating the specific surface area for hydroxyapatite particles consisting of unit cell dimension particles. Calculate the value for...

PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on...

PLEASE SHOW WORK IN EXCEL WITH FORMULA You are constructing a two stock portfolio based on the information provided below. What dollar amount will you invest in each stock to achieve the desired return goal? Stock X Stock Y Expected Return 14.0% 9.0% Goal Return of Portfolio: 10.00% Dollar Amount to Invest: $20,000

If Z is Standard Normal Variable, answer the following questions. Please show you complete work for...

If Z is Standard Normal Variable, answer the following questions. Please show you complete work for each question. a. What is the Z value if the area under the curve and to the right of Z is 0.95 b. What is the probability of Z is within the interval of -1.75 and 2.61? c. What are the middle Z values (-Z and + Z) such that the area under the probability curve from -Z to +Z is 0.97?

Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with...

Please show your work and formula on excel sheet. Thank you. Assume you borrow $8,000,000 with a coupon rate of 8% from a bank as a mortgage against your newly renovated plant. The loan is paid off in 7 years. You will pay an equal amount every year until the loan is fully paid off. What are the interest and principal payments for each year of the loan.

please show your work and formula on excel You are now 25 years old. You would...

please show your work and formula on excel You are now 25 years old. You would like to retire when you are 65 years old. You want to receive starting at 65 an annual income of $150,000 per year until you are 95. How much money must you have in your retirement account when you are 65? Assume you can earn 4% per annum.

For the following question, please show your work. Every number you get, show how you got...

For the following question, please show your work. Every number you get, show how you got it. And please make everything as clear as possible. Thanks in advance. 2. What is the outstanding balance on the following loan after the borrower has made 12.5 years of payments? (For full credit, calculate manually and show all of your work.) (20 pts) Loan amount: $300,000 Term: 25 years Discount Points: 5 Payments: Monthly Interest Rate: 4.5% (annual)

Use Excel to show your work and include the formula in the cell to show how...

Use Excel to show your work and include the formula in the cell to show how you arrived at your figures. Round percentages (example if 49.2, round to 49). Background: ABC, Inc., produces widgets. The company manufactures three levels of widgets-Economy, Better and Best. Selected information on the widgets is given below. Economy Better Best Selling price per widget $40.00 $60.00 $90.00 Variable expense per widget production $22.00 $27.00 $31.50 Selling (5% of selling price) $2.00 $3.00 $4.50 All sales...

Please show all work and formula: Please use the information on the table below to answer...

Please show all work and formula: Please use the information on the table below to answer this question. Security Actual Return Beta A 12% 1.2 B 10% 1.0 C 14% 1.4 Assume the risk-free interest rate is 1% and the market risk premium is 5.5%. An investor would like to invest $40,000 in Security A, $25,000 in security B and $50,000 in Security C. Find the portfolio’s expected return. Find the portfolio’s actual return. Based on your answers to a...

Question