Question: Help with excel on financial management please show an excel spreadsheet with all the information that should be listed in the document FINA 2201 Capital

Help with excel on financial management

please show an excel spreadsheet with all the information that should be listed in the document

Help with excel on financial management please show an excel spreadsheet with

FINA 2201 Capital Budgeting Problem DUE: November 17, IN CLASS Goldsmith labs recover gold from printed circuit boards. It considers expanding its' operations and it has developed new equipment for that purpose. Consider the following data: Equipment costs S250,000 right now. You expect to sell it for $50,000 in year five. It has an economic life of five years and is depreciated using straight-line method from years one to five to a value of $100,000 in year five. Operating costs are $100,000 per year. You will recover 1,000 ounces of gold per year over the next five years. The current price of gold is $300 per ounce. There will be an initial working capital requirement of S50,000 (today, vear 0) to get production started. All working capital is liquidated at termination of the project 5 years from now (year 5) The tax rate is 30%; the cost of capital is 8%. Required Using Excel prepare an analysis to be presented to the Chief Executive Officer of Goldsmith Labs evaluating the proposed expansion project. In particular your report should include the following: 1. Proiect cash flows. 2. Project's NPV, IRR and Payback Period

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!