Net Present Value of project for Golden Gelt Giftware.

Project evaluation: The following table presents sales forecasts for Golden Gelt Giftware. The unit price is $40.00. The unit cost of the giftware is $25.00.

Year Unit Sales
1 $22,000.00
2 $30,000.00
3 $14,000.00
4 $5,000.00
thereafter 0

It is expected that net working capital will amount to 20% of sales in the following year. For example, the store will need an initial (Year 0) investment in working capital of .20 x 22,000 x $40= $176,000.00. Plant and equipment necessary to establish the Giftware business will require an additional investment of $200,000.00. This investment will be depreciated using MARCS and a 3 year life. After 4 years, the equipment will have an economic and book value of 0. The firm's tax rate is 35%.

What is the net present value of the project? The discount rate is 20%.

Please show all work.

Solution Preview

See attached file.

NPV is $212,021.48. I have made an Excel spreadsheet available for you that shows the calculations.

I need help on two basic/intermediate finance questions. For computation, please use Excel or Word. I'm not very good with math, so if you use Word, please show step by step on how you obtained the answers. Thanks.
1. Project Evaluation. The following table presents sales forecasts forGoldenGeltGiftware. The unit price is

A project will produce cash inflows of $1,750 a year for four years. The project initially costs $10,600 to get started. In year five, the project will be closed and as a result should produce a cash inflow of $8,500. What is the netpresentvalue of this project if the required rate of return is 13.75 percent?

Project A: presentvalue (PV) of cash inflows is $55,000 and the PV of the cash outflows is $50,000. Project B: PV of cash inflows is $24,000 and the PV outflows is $20,000. All of the following are true except ______.
the netpresentvalue of Project A is $5,000, the netpresentvalue of Project B is $4,000, the profita

What is the netpresentvalue of a project that requires a net investment of $76,000 and produces net cash flows of $22,000 per year for 7 years? Assuming the cost of capital is 15 percent. (Presentvalue (PV) of inflows less Net Investment (NINV)
The four answers to choose from are the following:
a. $91,520
b. $15,520
c.

What is the netpresentvalue of a project that has an initial cash outflow of $12,670 and the following cash inflows? The required return is 11.5%.
Year Cash Inflows
1 $4,375
2 $0
3 $8,750
4 $4,100
a) $218.68
b) $370.16
c) $768.20
d) $1,249.65
e) $1,371.02

I am deciding among two mutually exclusive projects. The two projects have the following cash flows:
Project X
Year 0 -50,000
Year 1 10,000
Year 2 15,000
Year 3 40,000
Year 4 20,000
Project Y
Year 0 -30,000
Year 1 6,000
Year 2 12,000
Year 3 18,000
Year 4 12,000
The company's cost of capital is 10% (WACC = 10%

A project will produce operating cash flows of $45,000 a year for four years. During the life of the project, inventory will be lowered by $30,000 and accounts receivable will increase by $15,000. Accounts payable will decrease by $10,000. The project requires the purchase of equipment at an initial cost of $120,000. The equipme

What is the NetPresentValue (NPV) of an investment project with an initial cost of $6 million and positive cash flows of $1.6 million at the end of the year 1, $2.4 million at the end of year 2, and $2.8 million at the end of year 3. Use 10% as the discount rate.

A company is considering two mutually exclusive projects (project A and B). The following shows the expected cash flows:
Year Project A Project B
0 -30,000 -60,000
1 10,000 20,000
2 10,000 20,000
3 10,000 20,000
4 10,000 20,000
5 10,000 20,000
Cost of capital=14%
Using one of the capital budgeting technique