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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started