Atlas Transportation is considering installing temperature logger in all its refrigerated

$144191.05

Explanation:

Solution

Recall that:

The insurance claim reduction is =$40,000

The time = 5 years

The interest rate = 5%

Now,

We find how much the company be willing to spend if it uses an interest rate of 12% compounded quarterly.

The present value is computed as follows:

The Present Value of the saving (PV) = 40000/(1+12%) + 40000/(1+12%)2 +40000/(1+12%)3 +40000/(1+12%)4 +40000/(1+12%)5

= $144191.05

Hence, the maximum amount the company should be freely spend is

= $144191.05

Explanation:

Ventajas de las tablas dinámicas de Excel:

Hacen que los informes sean flexibles y se adaptan a tus necesidades. Son una forma interactiva de resumir rápidamente grandes volúmenes de datos, haciendo mucho más fácil el proceso de análisis y permitiendo encontrar patrones o tendencias.