FIN302 Investment Analysis

Please show the solution in excel format :) thank you

Q12-6

Entrepreneurship

Maram and Company should proceed with the project. True False

Joe is a new investor and has been closely watching a company by the name of USA Ltd., a pharmaceutical company aiming to develop a coronavirus vaccine. Joe believes the following returns are possible in 2022 and has attached a probability to each potential outcome:     Probability Possible Return .20 185.00% .30 83.50% .30 -5.00% .20 -100.00%   a) Calculate the Expected Return for USA Ltd. in 2022.      Show formula, calculation and a concluding statement in your response.

ANSWER ALL QUESTIONS A M&M Micro Processors Ltd is in process of purchasing high-tech Equipment for its production of microchips for the electronic industry. In its search, it has gathered the following information about two possible Equipment A and B. Both Equipment will be able to provide benefits over a ten-year period, and each required an investment of $10 000. Management has constructed the following table of estimates of rate of return and probabilities for Pessimistic, most likely and optimistic results. Equipment A Equipment B Rate of Return Rate of Return 11% 9% 18% 18% 22% 25% State of nature Recession Normal Boom I. II. Probability IV. 0.30 0.45 0.25 Table 1. Probability Required: Compute the expected rate of return for each Equipment Compute the variance and standard deviation of the rate of return for each Equipment Coefficient of variation for each Equipment Recommend which Equipment the firm should purchase 0.30 0.45 0.25

I need this question completed in 10 minutes

You are an angel investor, and 4 entrepreneurs have approached you to build some innovative folding tables, and the proposals are as follows. Project A, an investment of 566967 and annual cash flows respectively of 415527, 209635, 199906 and 298311. Project B, an investment of 439043 and annual cash flows respectively of 417004, 150449, 117975 and 384645. Project C, an investment of 628001 and annual cash flows respectively of 140108, 507720, 225467 and 147962. Project D, an investment of 450834 and annual cash flows respectively of 102735, 111878, 508753 and 154070. If the rate expected by you is 21.33% per year of compound interest. Which project is more profitable according to the NPV (Net Present Value)?Question 1 options: d c a b

A startup company has developed a new mobile app that has the potential to disrupt the market. The company is seeking funding to launch and market the app. The company is considering two financing options: equity financing with a venture capital firm that offers a valuation of $10 million and debt financing with a bank at an interest rate of 10% over a five-year term. What is the percentage of ownership the venture capital firm will have if it invests $5 million at a valuation of $10 million?

What is the net present value of this investment

G Google WebAssign- How To Factory Res. D Honey P MyLab IT | Pearson M Inbox (10,367) - rde. T35 Blackboard Learn N. CPU. Greg Noronha has been told the expected return on Merchants Bank is 8.80%, He knows the risk-free rate is 1.07%, the market risk premium is 6.75%, and Merchants' beta is 1.15. Based on the Capital Asset Pricing Model, Merchants Bank is: O A. fairly valued. O B. overvalued. C. undervalued. O Type here to search

I need the answer as soon as possible

quiz 8-1

klp.1

Please help with this question

Ee 421.

Profitaility Index Please solve for the profitiability index and explain. The information is attached.   ** The previous person answered it incorrectly*** The only answer that was correct was Project B 1.5 PLEASE ENURE ACCURACY

Finance John and John Plc. is a midsized electronics manufacturing company in the West of Scotland. You have recently joined as a finance manager at John and John. Last week, the marketing manager brought a new project to your attention. This project is about manufacturing robot vacuum cleaners ETX600 with an expected product life cycle of 4 years. In 2019, John and John Plc plans to launch these new vacuum cleaners if the project is financially feasible. Research and development costs incurred in the past three years amount to £150,000. Advertising is expected to cost £25,000 in year 1. Advertising costs will reduce by 10% every year thereafter. The company expects that sales in the first year will be £800,000, second and third year sales will be £650,000 and sales in the fourth year will be £600,000. Variable costs will be 50% of sales each year and the fixed production cost is expected to be £100,000 per year. The company estimates that if these new robot vacuum cleaners are…

5

Assume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022              50002023              60002024              70002025              80002026              90002027             100002028 11000 Determine the following:a. NPV for the period 2022 through 2028;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.

Assume your organization wishes to make a Php 200,000 investment with a private equity firm in 2021. Taking into account all of the risks, the current discount rate is 12%, and the revenue stream/dividends are as follows: 2022              50002023              60002024              70002025              80002026              90002027             100002028 11000 Determine the following: DO IT IN EXCELa. NPV for the period 2022 through 2028;b. Total NPV using manual computation;c. Total NPV using the Excel function; andd. IRR rate.

1. Is Shaylee able to invest in all of these projects simultaneously? 2-A. Calculate the profitability index for each project. 2-B. What is Shaylee’s order of preference based on the profitability index?

Calculate the NPV of the proposed investment, using the inputs suggested in this case. How sensitive is this NPV to future sales volume? *The answer is 15.7 million; please show me the work.

Flexcell Bhd is considering investing in the production of a new technology, a handheld communication device, the target market is young undergraduates. The estimated investment cost for this project is RM100 million with 3 year project life. Demand for the product, and therefore the project risk, is a function of the demand for Internet connections. The CFO working with marketing, currently estimates a 25% chance that such demand will be high, a 50% probability that demand will be medium, and a 25% probability that demand will be low. Associated after tax cash flows under each of these three market scenarios are estimated as follows: RM70 million, RMS0 million, and RM5 million. For projects of this nature, a 15% discount rate (equal to the firm's weighted average cost of capital) is assumed. Because starting the project immediately on day 1 results in negative NPV of RM0.109 million, management of the company has decided to avoid risk by delaying the implementation of the project for…

1. Enter your answers into the box below. Make sure you label your answers using 1, 2,..., etc.    XYZ Co has two  investments X and Y. Investment X has an initial capital outlay of $500 million, and the investment is expected to generate $1200 million in nine years. Investment Y has an initial capital outlay of $200 million, and the investment is expected to generate $450 million in nine years.  Assume XYZ has a cost of capital of 10%. 1.  Determine the internal rate of return of Investment X and  Investment Y. Should X and Y be taken? 2.  Determine the net present value of Investment X and Investment Y.  Should X and Y be taken?     2. Enter your answers into the box below. Make sure you label your answers using 1, 2,..., etc.   XYZ Co is considering to purchase equipment that has 12 years of life and requires an initial capital outlay of $240 million.  The equipment will be depreciated using straight line method to zero book value in 12 years.  The salvage value  of the equipment is…

F1

Imagineering, Inc., is considering an investment in CAD-CAM compatible design software with the cash flow profile shown in the table below. Imagineering’s MARR is 18%/year. Solve, a. What is the future worth of this investment? b. What is the decision rule for judging the attractiveness of investments based on future worth? c. Should Imagineering invest?