Question

In: Finance

Nippon Steel’s expenses for heating and cooling a large manufacturing facility are expected to increase according...

Nippon Steel’s expenses for heating and cooling a large manufacturing facility are expected to increase according to an arithmetic gradient beginning in year 2. If the cost is $550,000 this year (year 0) and will be $550,000 again in year 1, but then it is estimated to increase by $41,000 each year through year 12, what is the equivalent annual worth in years 1 to 12 of these energy costs at an interest rate of 11% per year? The equivalent annual worth is determined to be?

help with excel formulas to answer this question would be great, thanks.

Solutions

Expert Solution


Related Solutions

Nippon Steel’s expenses for heating and cooling a large manufacturing facility are expected to increase according...
Nippon Steel’s expenses for heating and cooling a large manufacturing facility are expected to increase according to an arithmetic gradient beginning in year 2. If the cost is $550,000 this year (year 0) and will be $550,000 again in year 1, but then it is estimated to increase by $59,000 each year through year 12, what is the equivalent annual worth in years 1 to 12 of these energy costs at an interest rate of 13% per year?
Nippon Steel’s expenses for heating and cooling a large manufacturing facility are expected to increase according...
Nippon Steel’s expenses for heating and cooling a large manufacturing facility are expected to increase according to an arithmetic gradient beginning in year 2. If the cost is $550,000 this year (year 0) and will be $550,000 again in year 1, but then it is estimated to increase by $52,000 each year through year 12, what is the equivalent annual worth in years 1 to 12 of these energy costs at an interest rate of 13% per year? The equivalent...
A facility that manufactures fireworks has a large increase in production every June, such that their...
A facility that manufactures fireworks has a large increase in production every June, such that their peak electrical demand is 101, while in every other month of the year their peak electrical demand of 50. The local utility informs the client that they will be changing the rate structure. The demand charges will decrease from $7.54/kW to $5.37/kW. But the utility will start imposing a ratchet clause at 80% of peak demand. What will be the expected change in annual...
Acme Manufacturing makes a variety of household appliances at a single manufacturing facility. The expected demand...
Acme Manufacturing makes a variety of household appliances at a single manufacturing facility. The expected demand for one of these appliances during the next 4 months is shown in the following table along with the expected production costs and the expected capacity for producing these items. Month 1 2 3 4 Demand 420 580 310 540 Production Cost $49.00 $45.00 $46.00 $47.00 Production Capacity 500 520 450 550 Acme estimates it costs $1.50 per month for each unit of this...
Your company is planning on expanding their current facility to increase the manufacturing of their products....
Your company is planning on expanding their current facility to increase the manufacturing of their products. The total cost is expected to be $100,000, and the company has decided to finance the project with short-term debt for the company an interest -bearing note or a zero-interest -bearing note. What are the key characteristics and differences between the two? Which one should the company decide to take on and why ? What effect will each bearing note have on the financial...
Manufacturing is able to produce large quantities of sulfur dioxide, SO2, by heating zinc sulfide in...
Manufacturing is able to produce large quantities of sulfur dioxide, SO2, by heating zinc sulfide in the presence of oxygen yielding zinc oxide and sulfure dioxide. 1. Write a chemical equation. 2. If 1.72 mol of ZnS is heated in the presence of 45.6 g of O2, which is the limiting reactant? 3. How many grams of excess reactant remain? 4. If the typical yield of sulfur dioxide is 86.78%, what would be the actual yield if 4897 g ZnS...
A project involves renovating a manufacturing facility to improve profits for a company. The expected cash...
A project involves renovating a manufacturing facility to improve profits for a company. The expected cash flow amounts over the 15-year useful life of the project are shown below. The company has established a MARR of 18%. Determine whether the company should proceed with the upgrades using the following methods: a. Internal rate of return method (IRR) b. External rate of return method (ERR), with external reinvestment rate ε = 12% Initial capital investment: $95,000 Annual expenses: $14,500 Annual revenues:...
Carlton Goods Co. makes household appliances at a single manufacturing facility. The expected demand for one...
Carlton Goods Co. makes household appliances at a single manufacturing facility. The expected demand for one of these appliances during the next four months is shown in the table below along with the expected production costs and the expected capacity for producing these items. Month 1 2                            3 4 Demand Production Cost Production Capacity 420 $49 500 580                   310 $46                   $45 520                   480 540 $47 550                                 Carlton estimates that it costs $2.50 per month for each unit of this appliance carried in inventory,...
Financial modeling question. One of the clients is a large manufacturing firm. The firm is expected...
Financial modeling question. One of the clients is a large manufacturing firm. The firm is expected a strong level of sales growth which will lead to a higher net profit margin and will require an increase in new warehouses and new distribution centers. The firm's average collection period (ACP) will not be affected. The manufacturing firm's CEO comments. "Due to higher expected profitability, our shareholders will likely expect a larger dividend. Therefore, we should increase our payout ratio." Would this...
Financial modeling question. One of the clients is a large manufacturing firm. The firm is expected...
Financial modeling question. One of the clients is a large manufacturing firm. The firm is expected a strong level of sales growth which will lead to a higher net profit margin and will require an increase in new warehouses and new distribution centers. The firm's average collection period (ACP) will not be affected. The manufacturing firm's CEO comments. "Due to higher expected profitability, our shareholders will likely expect a larger dividend. Therefore, we should increase our payout ratio." Would this...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT