Technology Plus, LLC is evaluating three new product offerings. Resources are available to do any or all of these. The forecasted Cash Flows for each alternative are shown below. Which one(s) should be approved if Internal Rate of Return is the sole criteria and a MARR of 20% is used?
|
Marr=20%
|
|
CASH FLOW
|
|
|
|
|
|
|
Project
|
Year
|
0
|
1
|
2
|
3
|
4
|
5
|
|
|
Model 4000
|
($75,000)
|
$20,000
|
$20,000
|
$20,000
|
$20,000
|
$20,000
|
|
|
Model 5000
|
($250,000)
|
$70,000
|
$80,000
|
$85,000
|
$85,000
|
$80,000
|
|
|
Model 6000
|
($5000,000)
|
$60,000
|
$100,000
|
$200,000
|
$2000,000
|
$2000,000
|
Please provide separate excel spreadsheets for each (5) question. ..Please. I should have 5 excel spreadsheets.