Please view the following video before answering this question. Excel Video Lesson: NORM.S.DIST FunctionA proposed project has the following cash flow estimates:End of Year Mean Net Cash Flow Standard Deviation of Cash Flow012345-$32,000$4,000$8,000$12,000$12,000$12,000$1,000$2.000$3,000$5,000$6,000$7,000Assuming independent cash flows, a normally distributed net present value, and a minimum attractive rate of return of 18%,determine an analytical solution for the following:Click here to access the TVM Factor Table Calculator Part dUsing a Monte Carlo simulation with 10.000 iterations, estimate the probability that the present worth is positive and estimatethe probability that the present worth is greater than $5.000.Probability:%Carry all interim calculations to 5 decimal places and then round your final answer to 1 decimal place. The tolerance is 10.2.

Normal Distribution:A normal distribution is a type of continuous probability distribution in which…

Answered: End of Year Mean Net Cash Flow Standard…

A First Course in Probability (10th Edition)

10th Edition

ISBN:9780134753119

Author:Sheldon Ross

Publisher:Sheldon Ross

Chapter1: Combinatorial Analysis

Section: Chapter Questions

Problem 1.1P: a. How many different 7-place license plates are possible if the first 2 places are for letters and...

See similar textbooks

Similar questions

Observe the mean, the standard deviation, and the CV of the annual rate of return of the portfolio. Apple Historical Annual Stock Price Data Year Average Stock Price Year Open Year High Year Low Year Close Annual % Change 2021 135.6974 129.4100 156.6900 116.3600 148.7600 12.11% 2020 95.3468 75.0875 136.6900 56.0925 132.6900 80.75% 2019 52.0640 39.4800 73.4125 35.5475 73.4125 86.16% 2018 47.2634 43.0650 58.0175 36.7075 39.4350 -6.79% 2017 37.6378 29.0375 44.1050 29.0050 42.3075 46.11% 2016 26.1510 26.3375 29.5625 22.5850 28.9550 10.03% 2015 30.0096 27.3325 33.2500 25.7800 26.3150 -4.64% 2014 23.0661 19.7546 29.7500 17.8494 27.5950 37.72% 2013 16.8798 19.6082 20.3604 13.9475 20.0364 5.42% 2012 20.5732 14.6868 25.0750 14.6868 19.0062 31.40% 2011 13.0002 11.7704 15.0800 11.2614…
Editor of Astrology Magazine wants to obtain sales forecast value for 2021. Use the given data below and help the editor. Year Quarter Sales 2019 1. 53 2. 51 3. 48 4. 55 2020 1. 53 2. 51 3. 54 4. 52 Use time series regression model and determine sales forecast value for the second quarter of 2021
A statistical program is recommended. A company that sells musical instruments has been in business for five years. During that time, sales of pianos increased from 13 units in the first year to 77 units in the most recent year. The firm's owner wants to develop a forecast of piano sales for the coming year. The quarterly sales data follow. Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total YearlySales 1 5 2 1 5 13 2 7 4 4 14 29 3 11 3 5 16 35 4 12 9 7 22 50 5 19 10 13 35 77 (a) Deseasonalize the data. (Round your answers to four decimal places.) Year Quarter Sales Adjusted Deseasonalized Seasonal Sales Index 1 1 5 1.3407 1 2 2 0.5998 1 3 1 0.4842 1 4 5 1.5753 2 1 7 1.3407 2 2 4 0.5998 2 3 4 0.4842 2 4 14 1.5753 3 1 11 1.3407 3 2 3 0.5998 3 3 5 0.4842 3 4 16 1.5753 4 1 12 1.3407 4 2 9 0.5998 4 3 7 0.4842 4 4 22 1.5753 5 1 19 1.3407 5 2 10 0.5998 5 3…
A statistical program is recommended. A company that sells musical instruments has been in business for five years. During that time, sales of pianos increased from 13 units in the first year to 77 units in the most recent year. The firm's owner wants to develop a forecast of piano sales for the coming year. The quarterly sales data follow. Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total YearlySales 1 5 2 1 5 13 2 6 4 4 14 28 3 11 3 5 16 35 4 12 9 7 22 50 5 19 10 13 35 77 (a) Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: x1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; and x3 = 1 if quarter 3, 0 otherwise. (Let t = 1 denote the time series value in quarter 1 of year 1; t = 2 denote the time series value in quarter 2 of year 1; and t = 20 denote the time series value in quarter 4 of year 5. Round your numerical values to two decimal places.) t =…
Q3. Consider the following data. Period Rate of Return (%) 1 -6.0 2 -8.0 3 -4.0 4 2.0 5 5.4 What is the mean growth rate over these five periods?
China GDP Year ($ trillions) 2005 2.3 2008 4.6 2011 7.5 2014 10.5 2017 12.0 2020 14.5 2023 17.5 (Source Bloomberg.com U.S. GDP ($ trillions) 13.1 + 14.7 15.5 2032 2035 17.4 19.4 20.6 21.8 China GDP U.S. GDP ($ trillions) 23.2 24.6 26.1 27.7 29.4 30.6 Year ($ trillions) 2026 21.2 2029 25.6 30.9 37.3 2038 45.1 2040 51.1 2. China's GDP vs. United States' GDP I. It is widely predicted that China's economy, mea- sured by Gross Domestic Product (GDP), will even- tually overtake that of the United States. Table 3.17 shows the GDPs for China and the United States from 2005 and projected to 2040 under the assump- tion that China's GDP will grow at an average annual rate of 6.5% and that the United States' GDP will grow at an average annual rate of 2%. Investigate when China's GDP will reach that of the United States under these assumptions about the countries" growth rates by using the following steps. 1. a. Create a scatter plot for the data, with x equal to the number of years after 2000 and…
What is the standard deviation of the following investment: Actual Return Probability 5% 40% 45% 10% -12% -5% 15% 20% ○ 4.6% 12.8% 11.0% 9.2%
Month Actual demand Forecasted Demand 1 950 1000 2 1070 1000 3 1100 1000 4 960 1000 5 1090 1000 6 1050 1000 For the dataset above, compute the overall MAPE.
Use the data from the following four stocks to answer the questions below: Yields Year TLS DI PFE WMT 20x5 12.00% 4.50% 5.80% 11.30% 20x6 13.30% 5.30% 5.70% 9.00% 20x7 10.20% 3.10% 5.90% 13.90% 20x8 9.30% 2.70% 4.50% 14.80% 20x9 8.60% 1.90% 6.30% 15.00% a. Classify the correlations between each pair of stocks as positive correlation (PC), perfectly positive correlation (PPC), negative correlation (NC), perfectly negative correlation (PNC), and no correlation (NC): TLS – DI ___________ DI – PFE __________ TLS – PFE __________ DI – WMT _________ TLS – WMT _________ PFE – WMT _________
A statistical program is recommended. A company that sells musical instruments has been in business for five years. During that time, sales of pianos increased from 12 units in the first year to 76 units in the most recent year. The firm's owner wants to develop a forecast of piano sales for the coming year. The quarterly sales data follow. Year Quarter 1 Quarter 2 Quarter 3 Quarter 4 1 2 3 4 5 4 7 11 12 18 2 4 forecast for quarter 2 forecast for quarter 3 forecast for quarter 4 3 9 10 1 4 5 7 13 5 14 16 22 35 Total Yearly Sales 12 29 35 50 76 (a) Use the following dummy variables to develop an estimated regression equation to account for any seasonal and linear trend effects in the data: x₁ = 1 if quarter 1, 0 otherwise; x₂ = 1 if quarter 2, 0 otherwise; and x3 = 1 if quarter 3, 0 otherwise. (Let t = 1 denote the time series value in quarter 1 of year 1; t = 2 denote the time series value in quarter 2 of year 1; ... and t = 20 denote the time series value in quarter 4 of year 5. Round…

Recommended textbooks for you

A First Course in Probability (10th Edition)

Probability

ISBN:

9780134753119

Author:

Sheldon Ross

Publisher:

PEARSON

A First Course in Probability

Probability

ISBN:

9780321794772

Author:

Sheldon Ross

Publisher:

PEARSON

A First Course in Probability (10th Edition)

Probability

ISBN:

9780134753119

Author:

Sheldon Ross

Publisher:

PEARSON

A First Course in Probability

Probability

ISBN:

9780321794772

Author:

Sheldon Ross

Publisher:

PEARSON

SEE MORE TEXTBOOKS