Please solve by hand A company is investing in a new expansion project which will cost...

Please solve by hand

A company is investing in a new expansion project which will cost $180,000 paid over 3 equal payments of $60,000. one payment is due now, one at the end of the first year and one at the end of the 2nd year. The project will start generating revenues of $44,000 per year at the end of the third year and up to and including the 10th year. Minimum Acceptable Rate of Return (MARR) = 8%. Please note that because this project is an investment, MARR provides the mathematical interest rate used for calculations (i).

a) Draw the cash flow diagram (CFD) for this investment showing cost and revenue components of the CFD.

b) If all the initial costs needed for this investment are to be financed from a line of credit. What is remarkable about a line of credit, as opposed to a loan, is that you can borrow the money whenever you want. Interest will only accrue after you borrow. The credit limit will always be available, even if you choose not to use it. That is, money can be borrowed whenever needed from an account up to $500,000.

Find the maximum interest rate for this line of credit so that the project is feasible. The company decided to pay back this money to the line of credit as a lump sum (one payment) at the end of the project (whenever the last revenue is received.

Solutions

Expert Solution

Answer provided in excel sheet

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

please solve by hand

A company is considering investing in a new project that will cost $6,589,490 and increase net...

A company is considering investing in a new project that will cost $6,589,490 and increase net income by 8.18%. This project will be completely funded by issuing new equity shares. Currently, the firm has 2,196,490 common shares outstanding with a market price of $32.91 per share. The current earnings per share are $1.79. What will be the earnings per share if the project is implemented? $1.73 $1.77 $1.82 $1.86 $1.91

A company is considering investing in a project with an initial cost of $250,000. The cost...

A company is considering investing in a project with an initial cost of $250,000. The cost of capital is 15%. The project will generate $100,000 every year for four years. Calculate the NPV & IRR & determine if they should invest in this project.

The Gamma Company is planning on investing in a new project. This project requires an initial...

The Gamma Company is planning on investing in a new project. This project requires an initial investment into a new machinery of $420,000. The Gamma Company expects cash inflows from this project to be as follows: $200,000 in year 1, $225,000 in year 2, $275,000 in year 3, and $200,000 in year 4 of the project. If the appropriate discount rate for this project is 16% then the NPV of the project is closest to _____________________. Group of answer choices...

The Gamma Company is planning on investing in a new project. This project requires an initial...

The Gamma Company is planning on investing in a new project. This project requires an initial investment into a new machinery of $420,000. The Gamma Company expects cash inflows from this project to be as follows: $200,000 in year 1, $225,000 in year 2, $275,000 in year 3, and $200,000 in year 4 of the project. The appropriate discount rate for this project is estimated at 16%. What is the IRR of this project? Group of answer choices 31.2% 26.7%...

Please solve handwritten, no Excel. A company purchased new casting equipment at a cost of $250,000....

Please solve handwritten, no Excel. A company purchased new casting equipment at a cost of $250,000. The company also paid an extra $70,000 in necessary costs to have the equipment delivered and installed. The casting machine has an estimated service life of 10 years, and it will be depreciated at a CCA rate = 25%. a] What is the Cost Basis of the casting equipment? b] What will be the CCA amount each year for the service life of the...

A company is considering investing in project X. The company has a cost of capital of...

A company is considering investing in project X. The company has a cost of capital of 10% p.a. Project X is a 9-year project with an initial cost of 400,000. The project will generate the following cash flows at the end of the years: Years Cash flows 1 90,000 2 80,000 3 50,000 4 50,000 5 50,000 6 50,000 7 50,000 8 50,000 9 15,000 a) Calculate the payback period (in years) for project X. Round your answer to 2 decimal...

Tangshan Mining Company is considering investing in a new mining project.

Tangshan Mining Company is considering investing in a new mining project. The firm’s cost of capital is 12 percent and the project is expected to have an initial after tax cost of $5,000,000. Furthermore, the project is expected to provide after-tax operating cash flows of ($1,800,000) in year 1, $2,900,000 in year 2, $2,700,000 in year 3 and $2,300,000 in year 4?Maximum acceptable payback period of this project is 3 years. Calculate the payback period for this project.Calculate the...

The Sisyphean Company is planning on investing in a new project. This will involve the purchase...

The Sisyphean Company is planning on investing in a new project. This will involve the purchase of some new machinery costing $450,000. The Sisyphean Company expects cash inflows from this project as detailed below: Year One Year Two Year Three Year Four $200,000 $225,000 $275,000 $200,000 The appropriate discount rate for this project is 16%. The NPV for this project is closest to:

The Sisyphean Company is planning on investing in a new project. This will involve the purchase...

The Sisyphean Company is planning on investing in a new project. This will involve the purchase of some new machinery costing $ 350 comma 000. The Sisyphean Company expects cash inflows from this project as detailed below: Year 1 Year 2 Year 3 Year 4 $ 150 comma 850 $ 150 comma 850 $ 150 comma 850 $ 150 comma 850 The appropriate discount rate for this project is 15%. The internal rate of return (IRR) for this project is...

Subjects