Question

Acompany is evaluating the addition of equipment to its presentoperations. They need to purchase equipment for...

Acompany is evaluating the addition of equipment to its presentoperations. They need to

purchase equipment for $160,000. The five year MACRS GDS Recovery Method is

appropriate forthe investment and the total tax rate (federal plus state) is 40%. Gross revenue

is expected to be $30,000/year while maintenance costs are expected to be $5,000/year. It is

expected that the operation will be shut down at the end of the fourth year with a salvage value

of $20,000.
1-Prepare a table showing your development of the ATCF's.

Homework Answers

Answer #1
Depreciation Schedule
Year Opening Balance Depreciation Base Depreciation % Depreciation Closing Balance
A B C D E = C*D F = B-E
1 160000 160000 20.00% 32000 128000
2 128000 160000 32.00% 51200 76800
3 76800 160000 19.20% 30720 46080
4 46080 160000 11.52% 18432 27648
Calculation of ATCF
Particulars 0 1 2 3 4
Initial Investment
Equipment Price (A) -160000
Operating Cash Flows
Gross Revenue (B) 30000 30000 30000 30000
Maintenance Costs (C ) 5000 5000 5000 5000
Depreciation (D) 32000 51200 30720 18432
Profit Before Tax (E = B-C-D) -7000 -26200 -5720 6568
Tax @40% (F = E*40%) -2800 -10480 -2288 2627.2
Profit After Tax (G = E-F) -4200 -15720 -3432 3940.8
Add back Depreciation (H = D) 32000 51200 30720 18432
Net Operating Cash Flows (I = G+H) 27800 35480 27288 22372.8
Terminal Value
Salvage Value (J) 20000
Book Value (K) 27648
Profit on sale (L = J-K) -7648
Tax @40% (M = L*40%) -3059.2
Profit After tax on sale (N = L-M) -4588.8
Add back Book Value (O = K) 27648
Net Terminal Value (P = N+O) 23059.2
Total After Tax Cash Flows (Q = A+I+P) -160000 27800 35480 27288 45432
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
41. Evaluating Alternative Investments. Washington Brewery has two independent investment opportunities to purchase brewing equipment so...
41. Evaluating Alternative Investments. Washington Brewery has two independent investment opportunities to purchase brewing equipment so the company can meet growing customer demand. The first option (equipment A) requires an initial investment of $230,000 for equipment with an expected life of 5 years and a salvage value of $20,000. The second option (equipment B) requires an initial investment of $120,000 for equipment with an expected life of 4 years and a salvage value of $15,000. The company’s required rate of...
Pear Orchards is evaluating a new project that will require equipment of $227,000. The equipment will...
Pear Orchards is evaluating a new project that will require equipment of $227,000. The equipment will be depreciated on a 5-year MACRS schedule. The annual depreciation percentages are 20.00 percent, 32.00 percent, 19.20 percent, 11.52 percent, and 11.52 percent, respectively. The company plans to shut down the project after 4 years. At that time, the equipment could be sold for $52,800. However, the company plans to keep the equipment for a different project in another state. The tax rate is...
36. You are evaluating a potential investment in equipment. The equipment's basic price is $133,000, and...
36. You are evaluating a potential investment in equipment. The equipment's basic price is $133,000, and shipping costs will be $4,000. It will cost another $20,000 to modify it for special use by your firm, and an additional $8,000 to install it. The equipment falls in the MACRS 3-year class that allows depreciation of 33% the first year, 45% the second year, 15% the third year, and 7% the fourth year. You expect to sell the equipment for 24,800 at...
37. You are evaluating a potential purchase of several light-duty trucks. The initial cost of the...
37. You are evaluating a potential purchase of several light-duty trucks. The initial cost of the trucks will be $143,000. The trucks fall in the MACRS 5-year class that allows depreciation of 20% the first year, 32% the second year, 19% the third year, 12% the fourth year, 11% the fifth year, and 6% the sixth year. You expect to sell the trucks for 20,000 at the end of five years. The expected revenue associated with the trucks is $105,000...
You are evaluating a potential purchase of several light-duty trucks. The initial cost of the trucks...
You are evaluating a potential purchase of several light-duty trucks. The initial cost of the trucks will be $196,000. The trucks fall in the MACRS 5-year class that allows depreciation of 20% the first year, 32% the second year, 19% the third year, 12% the fourth year, 11% the fifth year, and 6% the sixth year. You expect to sell the trucks for 29,400 at the end of five years. The expected revenue associated with the trucks is $148,000 per...
You are evaluating a potential purchase of several light-duty trucks. The initial cost of the trucks...
You are evaluating a potential purchase of several light-duty trucks. The initial cost of the trucks will be $145,000. The trucks fall in the MACRS 5-year class that allows depreciation of 20% the first year, 32% the second year, 19% the third year, 12% the fourth year, 11% the fifth year, and 6% the sixth year. You expect to sell the trucks for 14,500 at the end of five years. The expected revenue associated with the trucks is $111,000 per...
Fairfax Pizza is evaluating a project that would require an initial investment in equipment of 300,000...
Fairfax Pizza is evaluating a project that would require an initial investment in equipment of 300,000 dollars and that is expected to last for 8 years. MACRS depreciation would be used where the depreciation rates in years 1, 2, 3, and 4 are 39 percent, 31 percent, 20 percent, and 10 percent, respectively. For each year of the project, Fairfax Pizza expects relevant, incremental annual revenue associated with the project to be 345,000 dollars and relevant, incremental annual costs associated...
Fairfax Pizza is evaluating a project that would require an initial investment in equipment of 400,000...
Fairfax Pizza is evaluating a project that would require an initial investment in equipment of 400,000 dollars and that is expected to last for 7 years. MACRS depreciation would be used where the depreciation rates in years 1, 2, 3, and 4 are 45 percent, 33 percent, 16 percent, and 6 percent, respectively. For each year of the project, Fairfax Pizza expects relevant, incremental annual revenue associated with the project to be 628,000 dollars and relevant, incremental annual costs associated...
Fairfax Pizza is evaluating a project that would require an initial investment in equipment of 500,000...
Fairfax Pizza is evaluating a project that would require an initial investment in equipment of 500,000 dollars and that is expected to last for 8 years. MACRS depreciation would be used where the depreciation rates in years 1, 2, 3, and 4 are 40 percent, 30 percent, 20 percent, and 10 percent, respectively. For each year of the project, Fairfax Pizza expects relevant, incremental annual revenue associated with the project to be 870,000 dollars and relevant, incremental annual costs associated...
Fairfax Pizza is evaluating a project that would require an initial investment in equipment of 600,000...
Fairfax Pizza is evaluating a project that would require an initial investment in equipment of 600,000 dollars and that is expected to last for 7 years. MACRS depreciation would be used where the depreciation rates in years 1, 2, 3, and 4 are 39 percent, 32 percent, 20 percent, and 9 percent, respectively. For each year of the project, Fairfax Pizza expects relevant, incremental annual revenue associated with the project to be 1,020,000 dollars and relevant, incremental annual costs associated...