Question: please provide ans with detail excel calculation Bacall Electronics Inc. manufactures and supplies microchips used in the automotive industry. With demand at an all time

please provide ans with detail excel calculation  please provide ans with detail excel calculation Bacall Electronics Inc. manufactures
and supplies microchips used in the automotive industry. With demand at an

Bacall Electronics Inc. manufactures and supplies microchips used in the automotive industry. With demand at an all time high, they are looking to expand their capacity. They are considering the purchase of a new machine for $325,000. The investment is expected to generate a positive; after-tax cash flow of $68,000 per year for 7 years. The new machine will replace an existing machine that has a current market value of $18,000 and a current book value of $62,000. In addition to the investment of $325,000, the company will need to invest in spare parts inventory of $14,000 when they purchase the machine. At the end of 7 years the company believes it can sell the machine for $40,000. Bacall Electronics Inc. has a 12 percent cost of capital and a 40 percent tax rate. The new machine will be subject to a CCA rate of 25 percent. (Ignore any gain/loss on any sale of capital assets.) Complete the following table by entering the present value, after-tax, of of the following cash flows. Enter all cash flows net of tax, where applicable. Round all cash flow numbers to zero decimal places. Enter cash outflows as negative numbers

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!