Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Is it possible to do this question in excel? if so could somebody show me the necessary steps, please? A company owns a machine that

Is it possible to do this question in excel? if so could somebody show me the necessary steps, please?

A company owns a machine that is currently lying unused in the factory. The machine was bought five years ago at a cost of 60 000 and has now been depreciated down to a book value of 10 000. It could be sold now for 3 000. Alternatively, it could be rented out for one year at 2 500. The companys chief engineer believes the machine will be totally obsolete in 12 months time and would then have a scrap value of 800. The company is considering using the machine to undertake a 1-year project. If it did, the machines scrap value at the end of the year, net of dismantling costs, would be zero. Ignoring the time value of money, what is the cost of using the machine on the 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

Stocks Bonds And The Investment Horizon

Authors: Haim Levy

1st Edition

9811250146, 978-9811250149

More Books

Students also viewed these Finance questions