Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please give cell formula, thank you The Shome Compration is conswering a sew project that involves the introduction of a new product. The firm in

please give cell formula, thank you
image text in transcribed
image text in transcribed
The Shome Compration is conswering a sew project that involves the introduction of a new product. The firm in in the 34 percent marginal tax bracket and has a 15 percent required rate of teturn or discount rase for new investments. This preject is expected to last five years, and then, because this is somewhat of a fad project, it will be terminated. Givea the following informasoo, determine the net canh flows associated with the project and the projects NPV, profitability index, and internal rafe of retum. Apply the acpropriate decisian criteris. Cost of new plaat and equipment: $6,900,000 Shipping and invallation cots: $100,000 Sales price per usit: \$250lusit in Years 14,$200 hesit in Yeat 5 Variable cost per anit: 5130 unit Astwal fived coste 3300,000 Working cspial requirements: There will be an initial workiag capital reguitement of $100,000 just to get production started. For each year, the total investment in net wotking capital wil be ceas so 10 petcent of the dollar valoc of sales for that ycar. Thus, the investment in working capitat will increase during Years 1 throogh 3 , then dectease in Year 4 . Finally, all working capial is liquidated at the termination of the project at the ead of Year 5. The depreciation method: Use the vimplified straitht-line methed over five years. It is assumed that the plast and equigment will have no salvage value after five years. Cemplete the steps below ving efll references to ghen data or previous calculations. In wome cases, a simple cell reference is all you need. To copyipaste a formula acrow a row or dewn a colamn, an absolute cell referente or a mised cell reference may be preferred. If a metific Excel function is to be used, the directions wint specify the une of that functisn. Do not type in numerical dats inte a cell or functien. Iastead, make a reference to the cell in which the data is found. Make your enmpotations anly in the green cells blg titehted below. In all cases, wnless atbernise directed, we the earliest appearasce of the data in your formulas, usuatly the Given Data seetion. Addational net working copital Capital expenditure Free cath flow NFV Profutability Index IRR

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

Global Finance And Development

Authors: David Hudson

1st Edition

0415436354, 978-0415436359

More Books

Students also viewed these Finance questions