The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 408 Weeks Ago, 1 Day Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Using a spreadsheet for Problem 23, determine how Nina"s ability to negotiate a lower rent at location 3, thereby raising its ranking to "good," will affect the overall rankings of the four locations.
Information about the cash flows for a four-year financial project are listed in the following table. The cash flows are assumed to follow a triangular distribution. The cost of implementing the project is expected to be between $60,000 and $70,000, with all values in this range being equally likely. Analysis of changes in the Consumer Price Index suggests that the annual rate of inflation can be approximated with a normal distribution with a mean of 4 percent and standard deviation of 1.5 percent. The organization"r required rate of return is 20 percent. Develop a model in CB to analyze this situation and answer the following questions.
|
Year |
Minimum Inflow |
Most Likely Inflow |
Maximum Inflow |
|
1 |
$15,000 |
$20,000 |
$30,000 |
|
2 |
$20,000 |
$25,000 |
$35,000 |
|
3 |
$20,000 |
$30,000 |
$35,000 |
|
4 |
$40,000 |
$50,000 |
$60,000 |
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- -----------Â ----------- Â ----------- T-----------han-----------k Y-----------ou -----------for----------- us-----------ing----------- ou-----------r w-----------ebs-----------ite----------- an-----------d a-----------cqu-----------isi-----------tio-----------n o-----------f m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------