Question: please show in excel A factory is considering purchasing a new machine. It has two alternatives. Machine A costs $15,000 to purchase and 6,000 maintenance

please show in excel

A factory is considering purchasing a new machine. It has two alternatives. Machine A costs $15,000 to purchase and 6,000 maintenance cost every year. Machines B costs $30,000 to purchase and its annual maintenance cost is $1,000. Machine A can last 3 years while Machine B has a life of 5 years. If the company chooses one machine, it will have to continue to choose the same machine forever. Which machine should the company choose if the discount rate is 8% ? Please show all your work

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

Problem Four (20 marks) please show excel formulas! ABC Inc. is considering purchasing a new machine. The machine will cost $15,500,000. The machine will be used for a project that lasts 4 years. The...

Problem Three (20 marks) Please solve using Excel 123 Inc. is considering purchasing a new machine. The machine will cost $3,500,000. The machine will be used for a project that lasts 5 years. The...

please show the calculation and formula is considering purchasing a new system to improve one of its current production lines. Two types of system are available on the market and the company plan...

Bauer Industries is considering purchasing a new machine, the XD-750, which would allow it to expand its production capacity. The cost of the XD-750 is $2.75 million. Unfortunately, installing this...

Problem Six (15 marks) Use excel 123 Inc. is considering purchasing a new machine. The machine will cost $2,500,000. The machine will be used for a project that lasts 4 years. The expected salvage of...

Complete tabs 10.4, 10.6, 10.11, 10.12, 10.19, and 10.22 in the attached Chapter 10 Excel spreadsheet. An EXAMPLE tab is provided in the spreadsheet for your guidance. You must use formulas in the...

i need this case study and each part of it clearly should clearly answer .. thanks Koka Koka Tea House is a beverage producer in town. Koka Koka currently rents a bottling machine for $50,000 per...

The cash flows used in capital budgeting calculations are based on historical revenue. forecasts of future cash revenues, cash expenses, and cash investment outlays. forecasts of net income....

The company Polaris AB has the following composition of its revenues and expenses in 2019: Revenue / piece SEK 125 Variable costs / pieces SEK 55 Fixed costs SEK 4,200,000 Polaris AB is considering...

If L2 is measured in a hydrogen atom whose state function is that in Prob. 7.32, give the possible outcomes and their probabilities. Then calculate L2 for this state.

Any register name starts with # sign Select one: True False

The goal of financial management in a for - profit business is to make decisions that increase the value of the stock

SIMAD UNIVERSITY Class: BACC25 Subject: Islamic Accounting Instructions: a) Follow The Instructions. Midterm Exam Instructor: All Ibrahim Date: 6-4-2022 b) You Have 1.5 Hrs. To Complete This Test. c)...

personal motives: a positive reason for wanting to take on foreign assignments;

language aptitude: the ability to learn a language quickly is a useful attribute;

Expatriate policy should be in line with the strategic intent of the organization.