Illustrate graphically interest versus present worth each

Reference no: EM13451583

Listed below are three projects with their revenues listed per year. For each project, create a MS Excel spreadsheet to determine its Net Present Value and find all Internal Rate of Return (IRR) values. Show graphically Interest versus Present Worth.Each project scenario should be on a separate worksheet within the one MS Excel file.

Year	Case 1 (Cash Flow $)	Case 2 (Cash Flow $)	Case 3 (cash Flow $)
0	-1000	-6000	-1500
1	1000	-3000	6500
2	750	15000	-8200
3	500	2000	3300
4	250	5000	-1000
5	2000	12000	-500

Your MARR is 10%. Compare your spreadsheet results with hand calculations (show hand calculations on green engineering paper). Indicate whether each project met your MARR.

Reference no: EM13451583

Questions Cloud

Swap 1 is a 10ndashyear fixed-for-floating swap for : swap spreads assume the following term structure of risky and riskless interest rates.year riskless risky 1 6.91 7.33

Describe the scope of strategic marketing planning and the : nbspwrite a four to five 4-5 page paper in which youdifferentiate between marketing in a business industry of your

Find the impact of free trade on domestic job creation : what is the impact of free trade on domestic job creation policy? elaborate with examples. what the impacts of

You have 10000 to invest for 6 years you can invest this at : you have 10000 to invest for 6 years. you can invest this at a rate of 7.67 compounded annually at a rate of 7.52

Illustrate graphically interest versus present worth each : listed below are three projects with their revenues listed per year. for each project create a ms excel spreadsheet to

Discuss the benefits of market research include a swot : this is a two part written project that will focus on the marketing aspects of your start up business. please submit as

Compute a market capitalization-weighted stock price index : compute a market capitalization-weighted stock price index using the 5 given securities. set the base of the index to

Trigen corp management will invest cash flows of 905963 : trigen corp. management will invest cash flows of 905963 529350 1038985 818400 1239644 and 1617848 in research and

What primary message would you highlight for your specific : a variety of communication channels also exist to promote the marketing campaign wheather using traditional or new

User Account

All Pages