As the newly hired analyst for the corporate offices of Illuminated Electronics Corporation (IEC), you must prepare an analysis of a capital budgeting proposal.

Proposal 1 - PPD

IEC has just developed a new electronic device (called the PPD) and it believes it will have broad market appeal. The company has performed marketing and cost studies that revealed the following information:

A) New equipment would have to be acquired to produce the device. The equipment would cost $315,000 and have a six-year useful life. After six years, it would have a salvage value of about $15,000.

B) Sales in units over the next six years are projected to be as follows:

Year	Sales in Units
1	9,000
2	15,000
3	18,000
4-6	22,000

C) Production and sales of the device would require working capital of $60,000 to finance accounts receivable, inventories, and day-to-day cash needs. This working capital would be released at the end of the project's life.

D) The devices would sell for $35 each; variable costs for production, administration, and sales would be $15 per unit.

E) Fixed costs for salaries, maintenance, property taxes, insurance, and straight-line depreciation on the equipment would total $135,000 per year. (Depreciation is based on cost less salvage value).

F) To gain rapid entry into the market, the company would have to advertise heavily. The advertising costs would be:

Year	Amount of Yearly Advertising
1-2	$180,000
3	$150,000
4-6	$120,000

G) The company's required rate of return in 14%.

Proposal 2 - NED

One of your colleagues has provided an analysis of a competing proposal and concluded the following:

NPV = $120,000; IRR = 15.5%; Payback Period = 3.5 years, Profitability Index = 1.25

Required:

1) Compute the net cash inflow (incremental contribution margin minus incremental fixed expenses) anticipated from the sale of the PPDs for each year over the next six years.

2) Using the data computed (1) and other data provided in the problem, determine the net present value, internal rate of return, payback period, and profitability index of the proposed investment.

3) Using the analysis performed in (2), prepare "best" and "worst" case scenarios using the following assumptions:

a) Best Case - Projected sales expectations increase by 10%, required rate of return falls to 7%.

b) Worst Case - Projected sales decrease by 10%, required rate of return increases to 15%.

______________________________________________________________________________________

Here is my solution for question 1 and part of question 2. I am stuck with IRR, Payback Period and Profitability index. Could someone check my work to see what I am missing?

Question 1

Year	0	1	2	3	4	5	6
Sales in Units		9000	15000	18000	22000	22000	22000
Sales Revenue		$315,000	$525,000	$630,000	$770,000	$770,000	$770,000
Variable Expense		$135,000	$225,000	$270,000	$330,000	$330,000	$330,000
Contribution Margin		$180,000	$300,000	$360,000	$440,000	$440,000	$440,000
Fixed Exp including depreciation		$ 85,000	$ 85,000	$ 85,000	$ 85,000	$ 85,000	$ 85,000
Advertising		$ 180,000	$ 180,000	$ 150,000	$ 120,000	$ 120,000	$ 120,000
Total Fixed Expenses		$ 265,000	$ 265,000	$ 235,000	$ 205,000	$ 205,000	$ 205,000
Annual revenue (Net Cash Flow)		($85,000)	$35,000	$125,000	$235,000	$235,000	$235,000	$780,000

Question 2 NPV, IRR, Payback andProfitability

Year	0	1	2	3	4	5	6
Cost of equipment	$ (315,000)
Working capital	$ (60,000)
Annual revenues		$ (85,000)	$ 35,000	$ 125,000	$ 235,000	$ 235,000	$ 235,000
Releasing working capital							$ 60,000
Salvage value equipment							$ 15,000
Total cash flows	$ (375,000)	($85,000)	$ 35,000	$ 125,000	$ 235,000	$ 235,000	$ 310,000
Discount factor (14%)	1	0.877	0.769	0.675	0.592	0.519	0.456
Present value of cash flows	$ (375,000)	($74,545)	$ 26,915	$84,375	$ 139,120	$121,965	$ 141,360
Net present value	$ 64,190
Internal Rate of Return	12%
Payback Period	5.0
Profitability Index	0.20