Question

Sugar Land Company is considering adding a new line to its product mix, and the capital...

Sugar Land Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by a MBA student. The production line would be set up in unused space (Market Value Zero) in Sugar Land’ main plant. Total cost of the machine is $330,000. The machinery has an economic life of 4 years and will be depreciated using MACRS for 3-year property class. The machine will have a salvage value of $35,000 after 4 years. The new line will generate Sales of 2,000 units per year for 4 years and the variable cost per unit is $114 in the first year. Each unit can be sold for $220 in the first year. The sales price and variable cost are expected to increase by 3% per year due to inflation. Further, to handle the new line, the firm’s net working capital would have to increase by $30,000 at time zero (No change in NWC in years 1 through 3 and the NWC will be recouped in year 4). The firm’s tax rate is 40% and its weighted average cost of capital is 11%. The text below can be copy/pasted into the submission box below. Please save your work often as you type your answers. a. What are the annual depreciation expenses for years 1 through 4? (10 points) Year 1 Year 2 Year 3 Year 4 Depreciation b. Calculate the annual sales revenues and variable costs (other than depreciation), for years 1 through 4. (15 points) Year 1 Year 2 Year 3 Year 4 $ Total Sales $ Total Variable costs c. Estimate annual (Year 1 through 4) operating cash flows (25 points) Year 1 Year 2 Year 3 Year 4 Sales OCF d. Estimate the after-tax salvage cash flow (5 points) e. Estimate the net cash flow of this project (25 points) Year zero Year 1 Year 2 Year 3 Year 4 Net CF of the project f. Estimate the NPV, IRR, MIRR, and profitability Index of the project. (20 points) NPV = IRR = MIRR = PI

Homework Answers

Answer #1

A. Year Depreciation

1 . $110000

2. $146667

3. $48889

4. $24444

Dep convention= half yearly

A= 200%

B. Year. Sales . Variable cost

1. 440000 228000

2. 453200 234840

3. 466796 241885

4. 480800 249142

C. Year Operating Cash flows

1. $212000

2. $218360

3. $224911

4. $231658

D. Year Cash flows after tax

1. (212000-110000)(1-0.40)+110000= $171200

2. (218360-146667)(1-0.40)+146667=$189683

3. (224911-48889)(1-0.40)+48889=$ 154502

4. (231658-24444)(1-0.40)+24444= $148772

=( Cash flows- Dep)(1-tax rate)+ Dep

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
Company is considering adding a new line to its product mix, and the capital budgeting analysis...
Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by a MBA student. The production line would be set up in unused space (Market Value Zero) in Sugar Land’ main plant. Total cost of the machine is $350,000. The machinery has an economic life of 4 years and will be depreciated using MACRS for 3-year property class. The machine will have a salvage value of $35,000 after 4 years. The...
CASE-PART A Shrieves Casting Company is considering adding a new product line to its product mix,...
CASE-PART A Shrieves Casting Company is considering adding a new product line to its product mix, and the capital budgeting analysis is being conducted by Sidney Johnson, a recent business school graduate. The production line would be set up in unused space in Shrieves’s main plant. The machinery’s invoice price would be approximately $200,000, another $10,000 in shipping charges would be required to acquire the machinery from the supplier, and it would cost an additional $30,000 to install the equipment....
1. A company is considering a 5-year project to open a new product line. A new...
1. A company is considering a 5-year project to open a new product line. A new machine with an installed cost of $120,000 would be required to manufacture their new product, which is estimated to produce sales of $40,000 in new revenues each year. The cost of goods sold to produce these sales (not including depreciation) is estimated at 49% of sales, and the tax rate at this firm is 27%. If straight-line depreciation is used to calculate annual depreciation,...
Company A is considering launching a new clothing line. The project would require a $25,000,000 capital...
Company A is considering launching a new clothing line. The project would require a $25,000,000 capital investment and will be depreciated (straight-line to zero) over its 4-year life. The company discovers at the end of the project that it will be able to sell the equipment for $5,300,000 (salvage value). Incremental sales are expected to be $14,500,000 annually for the 4-year period with costs (excluding depreciation) of 55% of sales. The project would also require the company to increase inventory...
4. Epiphany Industries is considering a new capital budgeting project that will last for two years....
4. Epiphany Industries is considering a new capital budgeting project that will last for two years. The revenue for the first year is 200,000 and revenues grow at an annual rate of 10%. The cost of goods sold is 50% of the revenue. The capital expenditure is 120,000. The tax rate is 35%. Epiphany plans on using a cost of capital of 12% to evaluate this project. The depreciation is straight-line depreciation. Please fill in the following blanks: 15 points...
Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding a new bronze...
Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding a new bronze casting line to its production facility. Over the past several years the artistic community in Park City and along the Wasatch front has significantly increased and the company has received an increasing number of requests to do bronze castings. The casting line would be set up in unused space in Gilroy’s main plant. The equipment would cost approximately $200,000, plus another $10,000 for shipping...
Revenues generated by New Link product are forecast as follows: year 1: $40,000, year 2: $30,000,...
Revenues generated by New Link product are forecast as follows: year 1: $40,000, year 2: $30,000, year 3: $20,000, year 4: $10,000. Expenses are expected to be 40% of revenues and working capital required in each year is expected to be 20% of revenues for the following year. The product requires an immediate investment of $45,000 in plant and equipment a. What is the initial investment in the product? Remember working capital b. If the plant and equipment are depreciated...
Capital Budgeting             Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding...
Capital Budgeting             Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding a new bronze casting line to its production facility. Over the past several years the artistic community in Park City and along the Wasatch front has significantly increased and the company has received an increasing number of requests to do bronze castings. The casting line would be set up in unused space in Gilroy’s main plant. The equipment would cost approximately $200,000, plus another...
Capital Budgeting             Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding...
Capital Budgeting             Gilroy’s Casting Company, which has historically specialized in aluminum casting is considering adding a new bronze casting line to its production facility. Over the past several years the artistic community in Park City and along the Wasatch front has significantly increased and the company has received an increasing number of requests to do bronze castings. The casting line would be set up in unused space in Gilroy’s main plant. The equipment would cost approximately $200,000, plus another...
New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line....
New-Project Analysis The Campbell Company is considering adding a robotic paint sprayer to its production line. The sprayer's base price is $870,000, and it would cost another $24,000 to install it. The machine falls into the MACRS 3-year class (the applicable MACRS depreciation rates are 33.33%, 44.45%, 14.81%, and 7.41%), and it would be sold after 3 years for $644,000. The machine would require an increase in net working capital (inventory) of $16,500. The sprayer would not change revenues, but...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT