Tom wants to start a new project. A project requires a start up cost of $11000...

Tom wants to start a new project. A project requires a start up cost of $11000 today and 20 annual cost of $4500 starting in one year. Starting at the end of the 21th year, the project returns 10 annual payments of $Y. Find Y so that the project yields an annual effective rate of 5% over the 30 years.

PLZ by hand and not excel

Solutions

Expert Solution

-4500 -4500 +Y +Y

_________________________________________________________________________

0 1 2 3 20 21 22 30

-11000 -4500 -4500 +Y

The above is the representation of how the cashflows will be present. At year 0, today, we have cash outflow of 11000, from year 1 to year 20 we have annual cash out flow of 4500. From 21st year till 30th year we get cash inflow of Y. The annual effective rate of 5% is the IRR. The equation we need to solve is NPV=0 as that rate gives us IRR.

The equation to find Y is as under

-11000 - [4500/1.05 + 4500/1.05^2 + ..... 4500/1.05^20] + [ Y/1.05^21 + Y/1.05^22 + ..... Y/1.05^30] =0 --------(1)

The values under bracket are in Geometric Progression.

The sum of GP formula is a*(1-r^n)/(1-r)

(4500/1.05) * (1-(1/1.05)^20) / (1-(1/1.05)) = 56079.95

(Y/1.05^21) * (1-(1/1.05)^10) / (1-(1/1.05)) = 2.91Y

From (1), -11000-56079.95 + 2.91Y = 0

2.91Y = 67079.95

Y = $ 23051.53

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Two new software projects are proposed to a young, start-up company. The Alpha project will cost...

Two new software projects are proposed to a young, start-up company. The Alpha project will cost $150,000 to develop and is expected to have annual net cash flow of $40,000. The Beta project will cost $200,000 to develop and is expected to have annual net cash flow of $50,000. The company is very concerned about their cash flow. a.) Using the payback period, which project is better from a cash flow standpoint? Why? b.) If the project will take 10...

Project Z has a cost of $1.5 million to start up (i.e., at time t=0), and...

Project Z has a cost of $1.5 million to start up (i.e., at time t=0), and is expected to produce a uniform cash flow stream for 8 years (i.e., the cash flows are expected to be the same in years t=1 through t=8). Project Z’s IRR is 13.5%, while it’s cost of capital is 11.25%. Find project Z’s NPV and its MIRR. please give a step in detail. do not use excel

Project Z has a cost of $1.5 million to start up (i.e., at time t=0), and...

You have a new start-up firm. You think that the value of your start-up is around...

You have a new start-up firm. You think that the value of your start-up is around $60 million, but you will need to do a serious NPV analysis before you know the precise value. You are planning to have a 50% debt-to-value ratio, and that you will continuously rebalance to maintain this leverage. You have information on two other companies. The names of these companies are “Comp A” and “Comp B”. Comp A has the same business risk as your...

Elemental is considering another project which requires new equipment at a cost of $70,000. The equipment...

Elemental is considering another project which requires new equipment at a cost of $70,000. The equipment has a 3 year tax life and will be fully depreciated by the straight-line method over 3 years. When the project closes down at the end of the third year, it is expected to sell for $5000 before taxes. The project will require new working capital of $10000, and is expected to be fully recovered at the end of the project's life. Project revenues...

Pak Foods Ltd. is considering a project of new product line that requires the initial cost...

Pak Foods Ltd. is considering a project of new product line that requires the initial cost of Rs. 15 million. The company is considering to raise the capital from debt and equity financing (no preferred stock). The target capital structure is 60% equity and 40% debt. The interest rate on new debt is 8.00%, and the cost of equity is 15.00%, and the tax rate is 40%. The project has an economic life of 7 years and has the following...

Project EvaluationDog Up! Franks is looking at a new sausage system with an installed cost of...

Project EvaluationDog Up! Franks is looking at a new sausage system with an installed cost of $375,000. This cost will be depreciated straight-line to zero over the project’s 5-year life, at the end of which the sausage system can be scrapped for $25,000. The sausage system will save the firm $95,000 per year in pretax operating costs, and the system requires an initial investment in net working capital of $15,000. If the tax rate is 24 percent and the discount...

A proposed cost-saving project requires a device with an installed cost of $540,000. The project will...

A proposed cost-saving project requires a device with an installed cost of $540,000. The project will last for five years. The device has a CCA rate of 20%. The required initial net working capital investment is $20,000, the marginal tax rate is 37%, and the required return on the project is 11%. The device has an estimated salvage value of $95,000 at the end of Year 5, and the net working capital investment will also be recovered at the end...

ATT is considering a project. The project requires to purchase an equipment with a cost of...

ATT is considering a project. The project requires to purchase an equipment with a cost of $1.55 million. The equipment will be depreciated straight-line to a zero book value over the 9-year life of the project. At the end of the project it will be sold for a market value of $240,000. The project will not change sales but will reduce operating costs by $399,000 per year. The project also requires an initial investment of $52,000 in net working capital,...

1. A proposed cost-saving project requires a device with an installed cost of $540,000. The project...

1. A proposed cost-saving project requires a device with an installed cost of $540,000. The project will last for five years. The device has a CCA rate of 20%. The required initial net working capital investment is $20,000, the marginal tax rate is 37%, and the required return on the project is 11%. The device has an estimated salvage value of $95,000 at the end of Year 5, and the net working capital investment will also be recovered at the...

Subjects