Glacier of Armenia is the largest independent ice maker facility in Armenia. Glacier provides ice to bars, restaurants, supermarkets, and food storage facilities, controlling 70% of the market for ice in Armenia. In 2013, Chairman and CEO of Glacier was considering options for acquiring 12 new commercial freezers needed for the commercial storage facilities. Since the corporate tax in Armenia was relatively low, Glacier could not fully take advantage of the equipment's depreciation tax shield. Hence Glacier was considering a fifteen-year lease of the freezers. The investment arm of Farmers Insurance Group (FIG) had offered to structure a capital lease for Glacier in which FIG were to purchase the freezers from Polar King, a leading manufacturer, at $18 million and immediately lease them to Glacier. FIG's required rate of return was 13.8%, effective tax rate was 27%, and US tax laws permitted FIG to depreciate the leased freezers under the MACRS 15-year class of leased assets. Exhibit 1 at the end of this document reports the MACRS-15 annual depreciation rates. The Armenian tax laws, however, only permitted Glacier, if bought the freezers, to depreciate the freezers under a 15-year straight-line plan to a book salvage value of zero. The freezers needed to be insured with an annual insurance premium of $36,500 and required annual scheduled maintenance of $280,000. If Glacier leased the freezers, FIG would be responsible to cover insurance and maintenance costs as the owner of the freezers. If glacier bought the freezers directly from Polar King, Glacier would be responsible for both insurance and maintenance costs. Moreover, both FIG and Glacier estimated that the freezers could be sold at $1.2 million at the end of the lease period (the residual value after 15 years). Glaciers effective tax rate was 17% in Armenia, pre-tax cost of debt (for borrowing the required funds to directly purchase the freezers from Polar King) was 18.7%, and the WACC was 26.7%. In this project, you are to determine the before-tax annual lease payment that FIG should charge Glacier as well as whether Glacier should accept FIGs lease offer.

Please use and show the excel files

STEP 1: FIGs Before-Tax Annual Lease Payment Develop an Excel spreadsheet model and determine FIGs amount to be amortized, before-tax, and aftertax annual lease payment. Label this tab FIG. Then, answer the following question in your report.

a) What is FIGs Lease contract offered to Glacier? (How much should Glacier pay every year?)

STEP 2: Glaciers Buy/Lease Decision Develop an Excel spreadsheet model and determine Glaciers NAL. Title this tab Glacier. Then, answer the following questions in your report.

a) What is the NAL? Do you think Glacier should lease the freezers?

b) Suppose that Glacier could take advantage of the US tax laws and depreciated the freezers under MACRS-15. Create a new spreadsheet labeled Glacier 2 and determine what the NAL would be for Glacier? Does this change your recommendation in part (a) regarding Glaciers lease/buy decision?