Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please Show work and formulas in Excel A company is considering the purchase of a new machine that will enable it to increase its expected

Please Show work and formulas in Excel

image text in transcribed

A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000. In addition, the machine must be installed and tested. The costs of installation and testing will amount to $10,000. The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it) The equipment will be operated for 5 years. The sales in the first year of operation are expected to be $260,000. Then, sales will grow by 3% a year. The annual operating costs (before depreciation) will consist of fixed operating costs of $25,000 plus variable operating costs equal to 70% of sales. To support the increased level of production, the inventory of raw materials will have to be increased from $30,000 to $50,000 when the machine is purchased. The additional inventory will be carried until the machine is scrapped following the 5 years of operation. At the end of the 5-year operating life of the project, it is assumed that the equipment will be sold for $40,000. The tax rate is 40% and the company's weighted average cost of capital is 9%. Build a capital budgeting model to answer the following questions: 1) What is the operating cash flow in year 1-5? & The initial outlay in year 0? 2) What is the after tax salvage at the terminal year? 3) Calculate NPV and PI for the project. Check points: NI in year 2 = $3,834 IRR = 26.73% 4) Bonus: Using data table show the effect of changes in CGS on NPV for the project Start with CGS of 30% stepping by 5% and stopping at 70%

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

Elements Of Structured Finance

Authors: Ann Rutledge, Sylvain Raynes

1st Edition

0195179986, 978-0195179989

More Books

Students also viewed these Finance questions

Question

Q.1. Taxonomic classification of peafowl, Tiger and cow ?

Answered: 1 week ago

Question

Q .1. Different ways of testing the present adulterants ?

Answered: 1 week ago

Question

Q.1. Health issues caused by adulteration data ?

Answered: 1 week ago

Question

1. Traditional and modern methods of preserving food Articles ?

Answered: 1 week ago