Question

Cody Jackson plans importing olives to sell to restaurants and specialty stores. This venture will require an initial outlay of $295,000 to buy a refrigerated storage unit, which can be depreciated (straight-line) to a salvage value of $110,000 in 15 years. In addition, she will need $60,000 in working capital during the 15 years of the project. Annual sales are estimated to be $202,000 and annual expenses $135,000. She also estimates that the marginal tax rate and RRR will be 25% and 8%, respectively, during the lifetime of project. Using the given information, answer the following questions

a. What is the depreciation amount each year?
b. What is the net cash flow associated with the venture at year 1?
c. What is the amount of tax payment at year 8?
d. What is the net present value (NPV) of the proposed project?
e. What is the IRR of the project?
f. Should the company accept the project? Justify your answer by using the IRR of the project.
g. Calculate the net present values of the project (NPV) at the different RRR. The RRR starts from 0% and increases by 2% until 20%. Paste to the “answer” sheet only the NPV at 10%.
h. Using the answers in the question g, draw a chart that shows the NPV of the project at different levels of cost of capital. Don’t forget to give appropriate title and labels of X and Y on the chart.

Initial cost				a
Salvage				b
Life				c
Dep.				d. NPV
Working Capital (WC)				e. IRR
Revenues				f.
Expences				g
Tax rate
RRR
Year	1-time CF	Rev	Cost	Dep	Taxes	After tax CF
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
g	RRR	NPV
	0%
	2%
	4%
	6%
	8%
	10%
	12%
	14%
	16%
	18%
	20%
h

Answer 1

Answer:

The filled in excel format is as below:

Answer a:

Depreciation amount each year = (Initial cost - Salvage value) /Useful life = ($295,000 -$110,000)/ 15

= $12,333.33

Answer b:

As calculated in above table, net cash flow associated with the venture at year 1 = $53,333.33

Answer C:

As calculated in above table, amount of tax payment in year 8 = $13,666.67

Answer d:

NPV at 8% RRR = $143,607.98

NPV at 10% RRR = $183,049.29

Answer e:

Yes, the project should be accepted. Project's IRR = 13.82%

Answer f:

NPVs are calculated as required and provided in table above.

Answer g:

The chart on NPV profile is as follows:

The excel with 'Show formula'