Doug is the owner of Campo’s Lemon Ice and sells lemon icies out of a bright yel
ID: 2572532 • Letter: D
Question
Doug is the owner of Campo’s Lemon Ice and sells lemon icies out of a bright yellow and green truck. His old truck is small, constantly requires fixing, and doesn’t have features he wants like an ice maker. A new truck is rather expensive. Doug estimates a new truck with all the extras would cost $134,000 today. But it would save $4,430 a year in maintenance. He also thinks having a bigger truck and an ice maker means he can drive around more without stopping for supplies and ice. This extra selling time would increase sales by $29,600 a year, though that would come with some higher costs of $10,000 (gas, CoGS, etc.). Depreciating the new truck would use 7 year MACRS (use the table from the slides or the book). The fact the new truck holds more ice and lemons has further implications, though. He thinks he will increase inventory by $4000 after buying the truck, partially funded by an increase in accounts payable of $1500. The old truck is fully depreciated, but Doug thinks he can sell the truck for $62,500. Finally, Doug thinks he will get out of the lemon icies business in 6 years. If he keeps his old truck, it would salvage for $30,000 in 6 years. If he buys a new truck, it would probably salvage for $50,000 in 6 years. He thinks his marginal tax rate will be 32% and he has a required return of 13%. Questions: For each year, how will revenue change? Expenses? Depreciation? Given that, what would the OCF be for each of the 6 years? What changes for Current Assets? Current Liabilities? What are the changes in Net Working Capital and when will they occur? Is there any salvaging here? When does salvage occur and what is the effect on cash flow? Given that, what Net Capital Spending occurs for this project and in what years? Given the OCF, Change in NWC, and NCS, what is the CFFA on this project?
Explanation / Answer
ANALYSIS TABLE
initial investment
134000
Years
1
2
3
4
5
6
savings from maintenance cost
A
4430
4430
4430
4430
4430
4430
revenue from additional sales
B
29600
29600
29600
29600
29600
29600
less additional cost incurred
C
-10000
-10000
-10000
-10000
-10000
-10000
net benefit
D
24030
24030
24030
24030
24030
24030
E
depreciation %
F
14.29
24.49
17.49
12.49
8.93
8.92
depreciation
G
19149
32817
23436
16736
11966
11953
tax shield on depreciation
H
0.32
0.32
0.32
0.32
0.32
0.32
I
6127.68
10501.44
7499.52
5355.52
3829.12
3824.96
TOTAL BENEFIT D+I
J
30157.68
34531.44
31529.52
29385.52
27859.12
27854.96
present value 13%
K
0.884956
0.783147
0.69305
0.613319
0.54276
0.480319
operating cash inflow
L
26688.21
27043.18
21851.54
18022.69
15120.81
13379.25
new asset salvageable after tax
M
19088.7
26688
27043
21851
18023
15120
32468
Work note 1 :-
salvage value
50000
asset balance 6th year
17943
Gain
32057
tax on gain
10258.24
net inflow 6th year
39741.76
present value factor
0.480319
present value of return
19088.7
if old asset ontinue it will give salvage value at the end of 6th year 30000
present value after tax is
30000-(30000*.32)=20400
20400*.480319=9799
working cfapital additional required
inventory increse (4000)
payables increase 1500
maintance cost reduced 4430
sales revenue increased 29600
additional cost (10000)
working capital increased to 29530
initial investment
134000
Years
1
2
3
4
5
6
savings from maintenance cost
A
4430
4430
4430
4430
4430
4430
revenue from additional sales
B
29600
29600
29600
29600
29600
29600
less additional cost incurred
C
-10000
-10000
-10000
-10000
-10000
-10000
net benefit
D
24030
24030
24030
24030
24030
24030
E
depreciation %
F
14.29
24.49
17.49
12.49
8.93
8.92
depreciation
G
19149
32817
23436
16736
11966
11953
tax shield on depreciation
H
0.32
0.32
0.32
0.32
0.32
0.32
I
6127.68
10501.44
7499.52
5355.52
3829.12
3824.96
TOTAL BENEFIT D+I
J
30157.68
34531.44
31529.52
29385.52
27859.12
27854.96
present value 13%
K
0.884956
0.783147
0.69305
0.613319
0.54276
0.480319
operating cash inflow
L
26688.21
27043.18
21851.54
18022.69
15120.81
13379.25
new asset salvageable after tax
M
19088.7
26688
27043
21851
18023
15120
32468
Work note 1 :-
salvage value
50000
asset balance 6th year
17943
Gain
32057
tax on gain
10258.24
net inflow 6th year
39741.76
present value factor
0.480319
present value of return
19088.7
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.