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

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
Get step-by-step solutions from verified subject matter experts
