Calculate net present value

Assignment Help Basic Statistics
Reference no: EM132027243

What is time value of money Excel spreadsheet for the following two investments:

A. Initial investment ($100,000); Forecasts: Year 1 payback ($25,000); Year 2 payback ($25,000); Year 3 payback ($25,000)

B. Initial investment ($100,000); Forecasts: Year 1 payback ($20,000); Year 2 payback ($25,000); Year 3 payback ($40,000)

Use a re-investment rate of 10%. Calculate Net Present Value (=NPV) for each investment and specify which investment is the most profitable. ( not required to use the Excel (=NPV) formula but you will find it to be the easiest and most accurate means of calculating Net Present Value.)

Reference no: EM132027243

Questions Cloud

What yield to maturity is the bond offering : What yield to maturity is the bond offering? (Assume interest payments are semiannual.)
Structure of risk-free rates holds : If the liquidity premium theory of the term structure of risk-free rates holds, what is the liquidity premium for year 2, L2?
Find annual growth rate of regular payments expected to be : Oxygen Optimization just bought a new filtration system for 203, 900 dollars. To pay for the filtration system, the company took out a loan that requires.
What is the market-to-book ratio : Given common stock of $35 for year-end, total assets of $50m, debt ratio of 65%, no preferred stock, and 3 million shares of common stock outstanding
Calculate net present value : Use a re-investment rate of 10%. Calculate Net Present Value (=NPV) for each investment and specify which investment is the most profitable.
What are the assumptions underlying sales mix : The overall concept of a contribution margin is pretty straightforward- it is how much each unit contributes to covering fixed costs and eventually, profit.
Write a paper about the counseling profession : DISCUSS how this information helps to define dynamics as it relates to the counseling profession
What is the operating cash flow at given units : At an output level of 74,000 units, you calculate that the degree of operating leverage is 1.70. Suppose fixed costs are $150,000.
How many new shares will be distributed : How many new shares will be distributed? (Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.)

Reviews

Write a Review

Basic Statistics Questions & Answers

  Probability sample mean is within two of population mean

A population has a standard deviation of 16. If a sample of size 64 is selected from this population, what is the probability that the sample mean will be within 2 of the population mean?

  Discuss two-tailed test of difference between means

According to the historical data, the life expectancy in Argentina is equal to the life expectancy in Bolivia. A new study has been made to see whether this has changed.

  What is the probability that chosen manager will be women

A manager must be chosen at random to serve on a companywide committee that deals with personnel problems. What is the probability that the chosen manager.

  Develop separate schedules by using the fcfs andedd rules

Develop separate schedules by using the FCFS andEDD rules. Compare the schedules on the basis ofaverage flow time and average days past due.

  What is the variance of the distribution of means

Your sample of 12 people is being compared to a known population with a mean of 200 and a variance of 36. What is the variance of the distribution of means?

  The moisture x of the wet mix of a product is considered to

the moisture x of the wet mix of a product is considered to have an effect on the density y of the finished product.

  What are genome projects and dna fingerprinting

What are genome projects and DNA fingerprintingWhat are genome projects and DNA fingerprinting? What are some pros and cons of each issue?

  What checks might be employed to detect

What checks might be employed to detect (a) bad values, (b) an inadequate model, and (c) the failure of assumptions?

  Proportion of auto accidents that involve teenage drivers

A researcher claims the proportion of auto accidents that involve teenage drivers is less than20%. ABC Insurance Company checks police records on 200 randomly selected autoaccidents and notes that teenagers were at the wheel in 32 of them.Assume t..

  Compute the expected value of the total waiting time

Compute the expected value of the total waiting time of all passengers who have come to the station in order to catch a train that leaves at time t.

  The power of this test against the alternative hypothesis

an experimenter suspects that a certain die is loaded that is the chances that the die lands on different faces are not

  If the annual precipitation amount has a normal

question 1 a long-term record for weather in a certain province shows that the annual precipitation has a mean of 39.67

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd