Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help me with the excel portion of this please Use the following information to answer questions 1-6 in an Excel spreadsheet and submit the spreadsheet.

image text in transcribed

help me with the excel portion of this please

Use the following information to answer questions 1-6 in an Excel spreadsheet and submit the spreadsheet. Be sure to show your work as partial credit will be given if I can figure out where you started to go wrong. Turkey Company is considering a project which will require the purchase of $1.6 million in new equipment. The equipment will be depreciated straight-line to a zero book value over the 5-year life of the project. Turkey Company expects the sell the equipment at the end of the project for $180,000. Annual sales from this project are estimated at $1.3 million, and you will incur $100,000 in fixed costs and variable costs equal to 10% of sales. Net working capital equal to 30 percent of sales will be required to support the project and built up in the beginning. All the net working capital will be sold at the end of the project. The firm has a weighted average cost of capital (WACC) of 12 percent. The tax rate is 30 percent. 1. What is the annual depreciation amount? 2. What is the amount of the net (after-tax) salvage value of the equipment? 3. What is the recovery amount attributable to net working capital at the end of the project? 4. What is the operating cash flow each year? 5. What is the IRR of this project? 6. What is the NPV of this project

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Credit Derivatives Handbook Global Perspectives Innovations And Market Drivers

Authors: Greg Gregoriou, Paul Ali

1st Edition

0071549528, 978-0071549523

More Books

Students also viewed these Finance questions