Question

A firm is considering a project that costs $165,000 to start and generates $28,000/year in after-tax...

A firm is considering a project that costs $165,000 to start and generates $28,000/year in after-tax cash for the next 8 years. After 8 years there are no additional cash flows or salvage value. The firm uses a 15% cost of capital.

Build a spreadsheet model to estimate the net present value of the project.

Homework Answers

Answer #1

The Net Present Value of the project is calculated in the spreadsheet by discounting each cash flow by the cost of capital and summing them. See the second screenshot, which shows formulas to know how to build a model.

Can you please upvote? Thank You :-)

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
A firm is considering a replacement project which requires the initial outlay of $300,000 which includes...
A firm is considering a replacement project which requires the initial outlay of $300,000 which includes both an after-tax salvage from the old asset of $12,000 and an additional working capital investment of $8,000. The 12-year project is expected to generate annual incremental cash flows of $54,000 and have an expected terminal value at the end of the project of $20,000. The cost of capital is 15 percent, and its marginal tax rate is 40 percent. Calculate the net present...
16 A firm is considering a replacement project which requires the initial outlay of $300,000 w-hich...
16 A firm is considering a replacement project which requires the initial outlay of $300,000 w-hich includes both an after-tax salvage from the old asset of $12,000 and an additional working capital investment of $8,000. The 12-year project is expected to generate annual incremental cash flows of $54,000 and have an expected terminal value at the end of the project of $20,000. The cost of capital is 15 percent, and its marginal tax rate is 40 percent. Calculate the net...
Hewlett Packard is considering an investment project to make a portable printer. Suppose the project requires...
Hewlett Packard is considering an investment project to make a portable printer. Suppose the project requires initial investment of $100,000. The company uses 14% after tax required rate of return. Fixed cash outlays are $30,000 a year. The company expects the printer will sell for $80 per unit and the variable cost to build a printer will be 25 percent of sales. The company does its analysis based on a 10-year project life. The salvage value of the project is...
A firm is considering a new four year project. To start the project, the firm must...
A firm is considering a new four year project. To start the project, the firm must purchase new equipment today for $300,000. This equipment will be depreciated using a 7-year MACRS schedule. The project will generate annual sales of $260,000. Annual expenses for the project will be 40% of sales (excluding depreciation). The project will require an initial investment in Net Working Capital of $12,000 immediately (year 0). Going forward, the balance sheet level of NWC will be 10% of...
You are evaluating a capital budgeting replacement project with a net investment of $85,000, which includes...
You are evaluating a capital budgeting replacement project with a net investment of $85,000, which includes both an after-tax salvage from the old asset of $5,000 and an additional working capital investment of $10,000. The expected annual incremental cash flows after-tax is $14,000. The project has a life of 9 years with an expected terminal value at the end of the project of $13,000. The cost of capital of the firm is 10 percent and the firm’s marginal tax rate...
An investment project generates after-tax cash flows of $5,000 per year for the next 10 years....
An investment project generates after-tax cash flows of $5,000 per year for the next 10 years. Suppose the payback period for the project is 5 years and the appropriate discount rate is 15 percent. What is the initial cost of the project? a. $25,000 b. $32,167 c. $30,000 d. $16,761 Please provide the formula you used and numbers you plugged in to get the answer.
Question. Marie's Fashions is considering a project that will require $28,000 in net working capital and...
Question. Marie's Fashions is considering a project that will require $28,000 in net working capital and initial investment of$87,000 in fixed assets. The ~project is expected to produce annual sales of $75,000 with associated costs of $57,000. The project has a 5-year life. The company uses straight-line depreciation to a zero book value over the life of the project. The tax rate is 30 percent. The required rate of return for the project is 12%. What is the operating cash...
A firm is considering a four year capital project which is expected to have net cash...
A firm is considering a four year capital project which is expected to have net cash inflows of $20,000, $15,000, $13,000 and $10,000 respectively in the four years following the start of the project. The cost of the project is $35,000 while the firm's weighted average cost of capital is 20%. What is the net present value of the project? a $15,500 b -$5,300 c $4,417 d $23,000 B. If the firm is considers a five year capital project which...
A firm with a 9.5 percent cost of capital is considering a project for this year’s...
A firm with a 9.5 percent cost of capital is considering a project for this year’s capital budget. The project’s expected after-tax cash flows are as follows: Year: 0 1 2 3 4 Cash flow: -$7,000 $3,200 $2,700 $2,900 $3,400 Calculate the project’s net present value (NPV). a. $2,509.55 b. $2,747.95 c. $5,200.00 d. $1,486.01 e. $4,141.55
Johnson B (Pty) Limited is considering a project that would require an initial investment of R924,...
Johnson B (Pty) Limited is considering a project that would require an initial investment of R924, 000 and would have a useful life of eight (8) years. The annual cash receipts would be R600,000 and the annual cash expenses would be R240,000. The salvage value of the assets used in the project would be R138,000. The company uses a discount rate of 15%. Additional Working Capital of R400,000 will be required for the project. 2.1 Compute the net present value...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT