last excel

Details WACC 0 SGWN-O 1 2 3 4 5 6 7.80% Project A Project B -1225 395 402 423 432 489 512 -2146 592.5 603 634.5 648 733.5 768 1. Construct NPV profile table by using cashflows from Project A and B above. 2. Draw NPV profile 3. Compute crossover rate To receive EC your work has to be done in Excel.

1

I need do fast typing clear urjent no chatgpt used i will give 5 upvotes pls full explain plsss

v Question Completion Status: A Click Submit to complete this assessment. Question 20 An analyst estimates that project C's expected rate of return is 10%, your required rate of return of the project C is 7%, what should you do? O None of the listed choices is correct O There is no difference between reject or accept project C O Reject project c O Accept project C O All of the listed choices are correct A Click Submit to complete this assessment. MacBook Air 20 F3 O00 E4 F1 F2 F5 F6 F7 F8 # $ * 2 5 7 8. Q W R T Y F C V * 00 B

4Homework: Project Analysis As X 9 Question 2 - Homework: Projec X %3D heducation.com/ext/map/index.html?_con=con&external_browser=0&launchUrl=https%253A%252F%252Flms.mheducation.com%252F... O * O Project Analysis Assignment i 1 Saved Help Save & Exit Submit Check my work A project currently generates sales of $18 million, variable costs equal 60% of sales, and fixed costs are $3.6 million. The firm's tax rate is 35%. Assume all sales and expenses are cash items. a. What are the effects on cash flow, if sales increase from $18 million to $19.8 million? (Input the amount as positive value. Enter your answer in dollars not in millions.) Cash flow increases by $ 47,000 b. What are the effects on cash flow, if variable costs increase to 70% of sales? (Input the amount as positive value. Enter your answer in dollars not in millions.) decreases | by s 2$ 117,000 Cash flow

You wish to create a Data Table that calculates the NPV with various initial outlays in D1:E6. Which cell should be entered into the Data Table dialog box, and in which edit box?

Activity Frame B r = 11% 0 1 2 3 4 40% Prob Good 20.000 26.000 26.000 26.000 26.000 20,000 (r = 8%) Bad 60% Prob. 20.000 7.000 7.000 0 0

Plz do fast asap

Risk and probability Micro-Pub, Inc., is considering the purchase of one of two microfilm cameras, R and S. Both should provide benefits over a 10-year period, and each requires an initial investment of $5,000. Management has constructed the following table of estimates of rates of return and probabilities for pessimistic, most likely, and optimistic results: a. Determine the range for the rate of return for each of the two cameras. b. Determine the value of the expected return for each camera. c. Which camera purchase is riskier? Why? a. The range for the rate of return for camera R is %. (Round to the nearest whole number.)

Mc Graw Hill Risk and Capital Budgeting AA Fill in the blank: Scenario analysis is made up of several Correct Michael Scenarios Michael We have created various scenarios each with a forecast for our expected sales volume, revenues, expenses, risks, etc. At a high level, here are how each of the scenarios looks like. Calculate NPV for Scenario A. Use the information provided on the right. Round to the nearest whole number. Submit Enter a response then click Submit below $0 Scenarios Area 1.1 Scenario Comparison ($) Scenario A Scenario B Scenario C Initial Investment 2,000,000 2,000,000 2,000,000 Expected interest rate: 12% Forecasting period: 5 years PV annuity factor: 3.6048 Annual Net Income 545, 100 426,995 1,644,385 Annual Cash Flow 656,890 -493, 005 2,564,385 NPV -3,777, 184 7,244,095 Return to Activity Score Materials

Use attachment to answer question    q3- This question relates to the diagram, which shows the NPV profile for Projects X and Y. What is the Internal Rate of Return of Project X? Select one: a. 13% b. 9% c. 4% d. 10%

I need the Excel formula to input.

Question A    .Full explain this question and text typing work only     We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line

Spreadsheet Link What is the IRR of the following project? Cash Flow Year 0 32.000 9,000 2 10,000 15,200 3. 4. 7,800 1) 10.8% 2) 11.2% • 3) 11.7% 4) 12.0% 5) 12.3%

2. Dropdown menu 1 options are larger or smaller. Dropdown menu 2 options are earlier, more evenly or later. Dropdown menu 3 options are tracking technology or warehouse.

Version Ai Saved Help Save & Exit Submit Suppose the returns on a particular asset are normally distributed. The asset had an average return of 10.9 percent and a standard deviation of 22.6 percent. Use the NORMDIST function in Excel® to determine the probability that in any given year you will lose money by investing in this asset. Note: Do not round intermediate calculations and enter your answer as a percent rounded to 2 decimal places, e.g., 32.16. Probability %