Big Sky Mining Company must install $1.5 million of new machinery in its Nevada mine. It can obtain a bank loan for 100% of the purchase price, or it can lease the machinery. Assume that the following facts apply.

- The machinery falls into the NIACRS 3-ycar class.

- Under either the lease or the purchase, Big Sky must pay for insurance, property taxes, and maintenance.

- The firm's tax rate is 25%.

- The loan would have an interest rate of 15%. It would be non-amortizing, with only interest paid at the end of each year for four years and the principal repaid at Year 4.

- The lease tern1s call for $400,000 payments at the end of each of the next 4 years.

- Big Sky Mining has no use for the n1achine beyond the expiration of the lease, and the machine has an estimated residual value of $250,000 al the end of the 4th year.

1. what is the cost of owning?

2. What is the cost of leasing?

3. What is the NAL of the lease?

PLEASE Show how to do this in Excel with formulas so I can do a new problem on my own.