The operation cost of a company is $500,000 this year (year 0). The company expects an...

The operation cost of a company is $500,000 this year (year 0). The company expects an annual cost of $100,000 from year 1 to year 5, and the cost decreases by 4% each year from year 6 to year 12. What's the equivalent annual worth if all the expenses occur within years 1-12 ( I=10%)

Expert Solution

operation cost in yr 0 is 500000

annual cost of 100000 from year 1 to year 5, and the cost decreases by 4% each year from year 6 to year 12.

i = 10%

t = 12yrs

We need to find the present cost and then using the annuity factor of (A/P,10%,12) convert that present value into annual series

using excel

Year	Maintenance Cost	PV Factor	Present value
0	5,00,000.00	1	5,00,000.00
1	1,00,000.00	0.909090909	90,909.09
2	1,00,000.00	0.826446281	82,644.63
3	1,00,000.00	0.751314801	75,131.48
4	1,00,000.00	0.683013455	68,301.35
5	1,00,000.00	0.620921323	62,092.13
6	96,000.00	0.56447393	54,189.50
7	92,160.00	0.513158118	47,292.65
8	88,473.60	0.46650738	41,273.59
9	84,934.66	0.424097618	36,020.59
10	81,537.27	0.385543289	31,436.15
11	78,275.78	0.350493899	27,435.18
12	75,144.75	0.318630818	23,943.43
	Total present value		11,40,669.76

Equivalent annual cost = present value * (A/P,10%,12)

= 11,40,669.76 * (A/P,10%,12)

= 11,40,669.76 * 0.146763315

= 167408.47

Showing formula in excel

Year	Maintenance Cost	PV Factor	Present value
0	500000	=1/(1+0.1)^W3	=X3*Y3
1	100000	=1/(1+0.1)^W4	=X4*Y4
2	100000	=1/(1+0.1)^W5	=X5*Y5
3	100000	=1/(1+0.1)^W6	=X6*Y6
4	100000	=1/(1+0.1)^W7	=X7*Y7
5	100000	=1/(1+0.1)^W8	=X8*Y8
6	=X8*(1-0.04)	=1/(1+0.1)^W9	=X9*Y9
7	=X9*(1-0.04)	=1/(1+0.1)^W10	=X10*Y10
8	=X10*(1-0.04)	=1/(1+0.1)^W11	=X11*Y11
9	=X11*(1-0.04)	=1/(1+0.1)^W12	=X12*Y12
10	=X12*(1-0.04)	=1/(1+0.1)^W13	=X13*Y13
11	=X13*(1-0.04)	=1/(1+0.1)^W14	=X14*Y14
12	=X14*(1-0.04)	=1/(1+0.1)^W15	=X15*Y15
	Total present value		=SUM(Z3:Z15)

Rahul Sunny answered 3 years ago

Assume that Carbondale Company expects to receive S$500,000 in one year. The existing spot rate of...

Assume that Carbondale Company expects to receive S$500,000 in one year. The existing spot rate of the Singapore dollar is US$0.70. The one-year forward rate of the Singapore dollar is US$0.72. Carbondale created a probability distribution for the future spot rate in one year as follows: Future Spot Rate Probability US$0.68 20% 0.73 50% 0.77 30% Assume that i) one-year put options on Singapore dollars are available, with an exercise price of US$0.73 and a premium of US$0.04 per unit...

Fixed costs are assumed to be $500,000 per year. The company estimates the variable cost per...

Fixed costs are assumed to be $500,000 per year. The company estimates the variable cost per unit (v) to be $75 and expects to sell each unit for $425. There are no taxes and the required rate of return is 22% per year. Suppose that sales are currently estimated to be 5000 units per month. What is the degree of operating leverage? (Round to 1 decimal place, ie 2.3) Using your answer from above, estimate what the new monthly operating...

Rock company (a US firm) exports to Switzerland and expects to receive 500,000 Swiss francs in...

Rock company (a US firm) exports to Switzerland and expects to receive 500,000 Swiss francs in one year. The one-year U.S. interest rate is 5% when investing funds and 7% when borrowing funds. The one-year Swiss interest rate is 9% when investing funds, and 11% when borrowing funds. The spot rate of the Swiss franc is $.80. The firm expects that the spot rate of the Swiss franc will be $.75 in one year. There is a put option available...

Galt Motors currently produces 500,000 electric motors a year and expects output levels to remain steady in the future.

A question from Corporate Finance, by Berk&DemarzoGalt Motors currently produces 500,000 electric motors a year and expects output levels to remain steady in the future. It buys a part from an outside supplier at a price of $2.50 each. The plant manager believes that it would be cheaper to make the part rather than buy it. Direct in-house production costs are estimated to be only $1.80 per the part. The necessary machinery would cost $700,000 today (year 0) and can...

A Company is considering investing in a new dock that will cost $350,000. The company expects...

A Company is considering investing in a new dock that will cost $350,000. The company expects to use the dock for 5 years, after which it will be sold for $90,000. LakeFront anticipates annual net cash inflows of $85,000 resulting from the new dock. Instructions Calculate the net present value of the dock assuming the company's cost of capital is 10%. Calculate the net present value of the dock assuming the company's cost of capital is 15%.

o The initial capital cost will be $500,000 paid at the beginning of year 1 (i.e.,...

o The initial capital cost will be $500,000 paid at the beginning of year 1 (i.e., immediately). The impact on cottage owners will involve a loss of $50,000 at the end of each year for the first four years (because of the construction activities affecting property values) but cottage owners will benefit by $55,000 per year in perpetuity from the end of year 5 onwards. The benefits from recreational fishing will not start until the end of year 5 and...

The Construction cost of the bypass is 20 million and 500,000 would be required each year...

The Construction cost of the bypass is 20 million and 500,000 would be required each year for annual maintenance. The annual benefits to the public have been estimated to be 2 million. If the study period is 50 years and the government interest rates is 8% per year, a.) Should the bypass be constructed? B.)What impact does a social interest rate of 4% per year have on the B-C ratio of the project

The initial capital cost will be $500,000 paid at the beginning of year 1 (i.e., immediately)....

The initial capital cost will be $500,000 paid at the beginning of year 1 (i.e., immediately). The impact on cottage owners will involve a loss of $50,000 at the end of each year for the first four years (because of the construction activities affecting property values) but cottage owners will benefit by $55,000 per year in perpetuity from the end of year 5 onwards. The benefits from recreational fishing will not start until the end of year 5 and will...

At the beginning of the year, the company issued $500,000 10-year bonds at par. The holder...

At the beginning of the year, the company issued $500,000 10-year bonds at par. The holder of the bonds can convert $10,000 in bonds into cash based on the performance of the company. Specifically, each $10,000 bond can be converted into cash at the rate of 10% of net income. Draft financial statements reveal net income of $250,000. prepare a report to the board of directors that discusses the recognition, measurement, and presentation of the financial instruments issued.

A company has the option to purchase a building for $500,000 at the begining of year...

A company has the option to purchase a building for $500,000 at the begining of year one. This building is larger than needed; however, the excess space can be sublet for 12 years at a net annual rental of $8,000. Rental payments will be received at the end of each year and the risk associated with this investment is 10%. Calculate the present value of the investment in the building.

Question