Question: PLEASE CREATE A REPLICATED EXCEL FORMAT AS SHOWN IN THE ATTACHED IMAGE AND FILL OUT you have been asked to evaluate the proposed acquisition of

PLEASE CREATE A REPLICATED EXCEL FORMAT AS SHOWN IN THE ATTACHED IMAGE AND FILL OUT

you have been asked to evaluate the proposed acquisition of a new Machine for your company. The machines basic price is $100,000.

Assume that the machine can be depreciated using straight line over three years.

The Machine would require an increase in net working capital (spare parts inventory) of $4,000 at the start of the project. This working capital will be recovered at Year 3.

The machine would have no effect on revenues, but it is expected to save the firm $40,000 per year in before tax operating costs. This machine will help the firm reduce its labor costs.

Assume that the firms marginal tax rate is 35%.

a) If the cost of capital (WACC) is 10% , should the machine be purchased? Show all your work in the attached excel file.

b) What is the minimum cost savings required to justify the purchase of this machine?

PLEASE CREATE A REPLICATED EXCEL FORMAT AS SHOWN IN THE ATTACHED IMAGE

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 Accounting Questions!

Journal of Business Ventures- Please create a summary (5oo words or less) of the attached journal article. The summary should discuss the main finding(s), the methods used, the implications of the...

*please provide answer in excel format You are asked to evaluate the proposed acquisition of a new machine to reduce labor costs for Victoria Company (VC). The machine's basic price is $70,000, and...

I have the calculations done on an excel sheet but I need it to be written out as asked below. Specifically focus on the bold item, creating an appendix or exhibit that provides a walk-through...

Please read the posted articles on the TOWS Matrix and Executive Summary, and the Southwest Airlines TOWS Exercise. The Southwest Air exercise is an actual TOWS Matrix, EFE and IFE that was handed in...

Student Name Enrolled ID. No MS 7004 Independent Study MS 7002 Thesis 1. Title: 2. Type of Research: 3. Background of the Research: 4. Research Objectives: 5. Research Questions: 6. Variables:...

Can someone help me with the Accounting Course Project. Instructions are there in the Course Project Instruction and the 10k for Nike and UNder Armour attached. I have also attached the Teamplate....

Hi need to get done only one article from the given ones but please choose any one except article no 2 as i have already done that one. please choose right theory and apply it on the article and...

1. In 2013, several data server companies took a dramatic decision to begin using energy surcharges to recapture rising energy costs. However, customers are critical of how the energy surcharges are...

PLEASE COMPLETE NO LATER THAN 11/04 @8am Each question(1,2,& 3) must be a minimum of 200 words. Please EXPLAIN answers in FULL detail and make answers knowledgeable based off the attached reading,...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

The Fifth Quarter Bar buys Old World draft beer by the barrel from a local distributor. The bar has an annual demand of 900 barrels, which it purchases at a price of $205 per barrel. The annual...

Suppose that the S&P 500 (price) index is currently 2700. Further suppose that the price of a one-year S&P500 futures contract is 2781 and the price of a two-year S&P500 futures contract is 2920....

Which of the following is true regarding commission sharing by insurance agents? A . An agent can share commissions with any person who helped solicit the insurance contract. B . Commissions can only...

illian Fok is president of Lakefront Manufacturing, a producer of bicycle tires. Fok makes 1,000 tires per day with the following resources: a) Labor productivity per labor hour for these tires =...