Question
A company is considering whether to buy a regular or color photocopier for the office. The cost of the regular machine is $10,000, its life
A company is considering whether to buy a regular or color photocopier for the office. The cost of the regular machine is $10,000, its life span is 5 years, and the company has to pay another $1,500 annually in maintenance costs. The color photocopiers price is $30,000, its life span is also 5 years, and the annual maintenance costs are $4,500. The color photocopier is expected to increase the revenue of the office by $8,500 annually. Assume that the company is profitable and pays 40% corporate tax; the relevant interest rate is 11%. Which photocopy machine should the firm buy? (Hint: you might want to compare the differential cash flows between these two machines.)
The answer is (-1890.10)
I need to know how to find that answer in Excel, please show all the components to the formula needed to calculate the answer.
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