The UFRO Company is considering the replacement of an existing spectrometer with a new spectrometer; faster and with expanded capacity. If the new spectrometer is purchased, the existing (old) computer will be sold for $80,000 immediately. The existing spectrometer was purchased three (3) years ago for $500,000.

It is being depreciated under the 3-year MACRS schedule. The salvage value at the end of its six-year life will be $50,000.

The new spectrometer will be purchased for $800,000.

If the new spectrometer is purchased, accounts receivable increase immediately by $25,000; accruals will increase immediately by $40,000; and accounts payable will increase immediately by $30,000. The UFRO Company has a 30% corporate tax rate.

Shipping and installation will cost UFRO $80,000; and the modifications to the building will be $100,000.

If the new spectrometer is purchased, sales in year 1 will be $700,000, sales in year 2 will be $900,000, and sales in year 3 will be $950,000. Without the new spectrometer, sales will be $400,000 in year 1; $400,000 in year 2 and $400,000 in year 3. Operating expenses with the new spectrometer will be 40% of sales; with the old spectrometer those costs are 45% of sales.

The new computer will be depreciated using the 3-year MACRS schedule [yr.1: 33%; yr. 2: 45%; yr. 3: 15%; and yr. 4: 7%].

It is expected that the new spectrometer will be sold after three (3) years for $180,000. The UFRO Company has a cost of capital of 12%. Calculate the NPV, IRR, PAYBACK and MIRR.

Questions

New PC Where does the Year2 800,000, and Year 3 100,000, derived from?

NOI is derived how for Year1, Year 2, Year 3?

PVIF? Explain the calculation and how its derived for Year 1, year 2, year 3?

IRR= Where does the 4% derived from? How is it calculated in the Year 1? Year 2, Year 3?

I am a bit confused please further clarify.

Thank you