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: | 283 Weeks Ago, 4 Days Ago |
| Questions Answered: | 27237 |
| Tutorials Posted: | 27372 |
MCS,MBA(IT), Pursuing PHD
Devry University
Sep-2004 - Aug-2010
Assistant Financial Analyst
NatSteel Holdings Pte Ltd
Aug-2007 - Jul-2017
Hi i need this work done in Microsoft Excel spreadsheet by no later than 5 hour
Also you can answer the questions in writing in Excel as well thanks
Â
Below is the work I need to do in an Excel Spreadsheet.
Â
1.(75%) A five-year software development project is forecast to have net cash inflows of $15,000, $20, 000, $25,000, $30,000, and $50,000 over the next five years. It will cost $80,000 to implement the project, payable at the beginning of the project. Once implemented, there will be an annual cost of $5,000, payable at the end of each year. There is an assumed inflation rate of .02 each of the five years for this project. If the required rate of return is .05, construct a discounted cash flow model to determine the Net Present Value (NPV). Use the concepts found in Mantel, Chapter 1, Section 1.5 and Excel to create the formulas needed to calculate the NPV. Assume the inflows all occur at the end of the year.
Â
Â
2.(25%) Assuming your initial outflow is based on a fixed price vendor bid, your inflows based on a marketing study and your annual outflows based on your IT department’s estimate, which of these (initial outflow, annual outflow, and annual inflows) would you expect to be most accurate? Which least accurate? Why?
Â
Also this problem can be done in a regular format, not in excel thanks
Â
3. Given the scenario that this class is comprised of ten male students and eleven female students and you are part of a five member team, how would you respond to the following?
What is the probability that (if you are male) your team is composed of all males or (if you are a female) your team is composed of all females?
----------- Â ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------usi-----------ng -----------our----------- we-----------bsi-----------te -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------ns.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age-----------