Question

In: Accounting

Create a 5-year capital budget for the project below assuming the following. 1.$500,000 initial outlay for...

Create a 5-year capital budget for the project below assuming the following.

1.$500,000 initial outlay for purchase of new machine for a 5-year contract the company was awarded from a customer.

2.The company will have to rent new space for $50,000/year to put machine in.

3.A one-time, year 1 cost to set up the machine and get it running will be $200,000.

4.The machine is expected to generate revenue beginning in year 2.

The machine will generate around $150,000 in year 2...that number will increase by about 10% per year thereafter.

5.Machine is depreciated using S/L depreciation.

6.The company hasa flat tax rate of 25%.

7.The discount rate is 9%.

Build a 5-year capital budget that includes all of the above items and shows EBITDA, EBT, Taxes Paid, Net Income, and cash flow per year.

Then calculate NPV and IRR. Should the company undertake the project? Why or why not?

Solutions

Expert Solution


Related Solutions

An investor is considering investing in a capital project. The project requires an outlay of £500,000...
An investor is considering investing in a capital project. The project requires an outlay of £500,000 at outset and further payments at the end of each of the first 5 years, the first payment being £100,000 and each successive payment increasing by £10,000.The project is expected to provide a continuous income at a rate of £80,000 in the first year, £83,200 in the second year, and so on, with income increasing each year by 4% per annum compound. The income...
1) A company invests in a new project that requires an initial capital outlay of $852790....
1) A company invests in a new project that requires an initial capital outlay of $852790. The project will generate annual net cash flows of $145612 over a period of 8 years. The after-tax cost of capital is 9%. In addition, a working capital outlay of $94620 will be required. This working capital outlay will be recovered at the end of the project’s life. What is the net present value of the project? Select one: a. $-141474 b. $-93987 c....
                PROJECT A           PROJECT B Initial Outlay      -50000   -70000 Inflow year 1
                PROJECT A           PROJECT B Initial Outlay      -50000   -70000 Inflow year 1      12000    13000 Inflow year 2      12000    13000 Inflow year 3      12000    13000 Inflow year 4      12000    13000 Inflow year 5      12000    13000 Inflow year 6      12000    13000 ​​(​NPV, ​PI, and IRR calculations​) You are considering two independent​ projects, project A and project B. The initial cash outlay associated with project A is ​$50000​, and the initial cash outlay associated with project B is ​$70000. The required rate of...
An initial cash outlay of $1.4 million is made for a project. In Year 1, the...
An initial cash outlay of $1.4 million is made for a project. In Year 1, the expected annual cash flow is $900,000. In Years 2–5 the expected annual cash flow is $1,000,000, and in Year 6, the expected annual cash flow is $1.3 million. A cost of capital of 15% is used. The IRR (internal rate of return) is ??? Please show work/calculation using Texas Calculator. No excel.
The company above is considering a 5 year project which would require an initial outlay of...
The company above is considering a 5 year project which would require an initial outlay of $800,000 for the manufacturing equipment (depreciated straight line to zero over 8 years). Salvage value in year 5 will be $200,000. In addition, the company will need $200,000 initial investment in working capital. Tax rate is 34%. The project will produce OCF of $350,000 for 5 years. NPV IRR PI Payback and Discounted Payback
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 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...
A company is considering a 6-year project that requires an initial outlay of $23,000. The project...
A company is considering a 6-year project that requires an initial outlay of $23,000. The project engineer has estimated that the operating cash flows will be $4,000 in year 1, $6,000 in year 2, $7,000 in year 3, $7,000 in year 4, $7,000 in year 5, and $8,000 in year 6. At the end of the project, the equipment will be fully depreciated, classified as 5-year property under MACRS. The project engineer believes the equipment can be sold for $5,000...
A company is considering a 6-year project that requires an initial outlay of $30,000. The project...
A company is considering a 6-year project that requires an initial outlay of $30,000. The project engineer has estimated that the operating cash flows will be $3,000 in year 1, $6,000 in year 2, $7,000 in year 3, $7,000 in year 4, $7,000 in year 5, and $8,000 in year 6. At the end of the project, the equipment will be fully depreciated, classified as 5-year property under MACRS. The project engineer believes the equipment can be sold for $6,000...
PADICO is considering an investment project. The project requires an initial $5 million outlay for equipment...
PADICO is considering an investment project. The project requires an initial $5 million outlay for equipment and machinery. Sales are projected to be $2.5 million per year for the next four years. The equipment will be fully depreciated straight-line by the end of year 4. The cost of goods sold and operating expenses (not including depreciation) are predicted to be 30% of sales. The equipment can be sold for $500,000 at the end of year 4.Padico also needs to add...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT