Question: 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
Get step-by-step solutions from verified subject matter experts
