Sandhill Inc. owns and operates a number of hardware stores in the Atlantic region. Recently, the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Sandhill Inc. owns and operates a number of hardware stores in the Atlantic region. Recently, the company decided to open another store in a rapidly growing area of Nova Scotia. The company is trying to decide whether to purchase or lease the building and related facilities. Currently, the cost of funds for Sandhill is 12%. Purchase: Lease: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $2,000,000. An immediate down payment of $360,000 is required, and the remaining $1,640,000 would be paid off over five years with payments of $388,000 per year (including interest payments made at the end of the year). The property is expected to have a useful life of 12 years, and then it will be sold for $500,000. As the owner of the property, the company will pay $54,000 in occupancy expenses at the end of each year. First National Bank has agreed to purchase the site, construct the building, and install the appropriate fixtures for Sandhill if Sandhill will lease the completed facility for 12 years. The annual payments would be $328,000. Sandhill would have no responsibility related to the facility over the 12 years. The terms of the lease are that Sandhill would be required to make 12 annual payments. (The first payment is to be made at the time the store opens and then one each following year.) In addition, a deposit of $105,000 is required when the store is opened. This deposit will be returned at the end of the twelfth year, assuming there is no unusual damage to the building structure or fixtures. Assume a 12% discount rate. (a) Using Excel functions, calculate the present value of the net cash flows required of Sandhill for: (Round answers to 2 decimal places, e.g. 5,275.25.) 1. The purchase alternative 2. The lease alternative (Hint: For the annuity due for the lease payments, use type 1.) eTextbook and Media LA 6A Present Value Sandhill Inc. owns and operates a number of hardware stores in the Atlantic region. Recently, the company decided to open another store in a rapidly growing area of Nova Scotia. The company is trying to decide whether to purchase or lease the building and related facilities. Currently, the cost of funds for Sandhill is 12%. Purchase: Lease: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $2,000,000. An immediate down payment of $360,000 is required, and the remaining $1,640,000 would be paid off over five years with payments of $388,000 per year (including interest payments made at the end of the year). The property is expected to have a useful life of 12 years, and then it will be sold for $500,000. As the owner of the property, the company will pay $54,000 in occupancy expenses at the end of each year. First National Bank has agreed to purchase the site, construct the building, and install the appropriate fixtures for Sandhill if Sandhill will lease the completed facility for 12 years. The annual payments would be $328,000. Sandhill would have no responsibility related to the facility over the 12 years. The terms of the lease are that Sandhill would be required to make 12 annual payments. (The first payment is to be made at the time the store opens and then one each following year.) In addition, a deposit of $105,000 is required when the store is opened. This deposit will be returned at the end of the twelfth year, assuming there is no unusual damage to the building structure or fixtures. Assume a 12% discount rate. (a) Using Excel functions, calculate the present value of the net cash flows required of Sandhill for: (Round answers to 2 decimal places, e.g. 5,275.25.) 1. The purchase alternative 2. The lease alternative (Hint: For the annuity due for the lease payments, use type 1.) eTextbook and Media LA 6A Present Value
Expert Answer:
Related Book For
Intermediate Accounting Volume 1
ISBN: 978-1119496496
12th Canadian edition
Authors: Donald E. Kieso, Jerry J. Weygandt, Terry D. Warfield, Irene M. Wiecek, Bruce J. McConomy
Posted Date:
Students also viewed these accounting questions
-
Use the information in P3.7. Data from P3.7 Dunn Inc. owns and operates a number of hardware stores in the Atlantic region. Recently, the company has decided to open another store in a rapidly...
-
Use the information in P3.7. Data from P3.7 Dunn Inc. owns and operates a number of hardware stores in the Atlantic region. Recently, the company has decided to open another store in a rapidly...
-
A paper recycling company converts newspaper, mixed paper, white office paper, and cardboard into pulp for newsprint, packaging paper, and print stock quality paper. The following table summarizes...
-
Why would a business like Marriott first pursue offensive market strategies to increase market share or grow revenue per customer, rather than adopting other offensive market strategies?
-
Alaskan Fisheries, Incorporated, processes salmon for various distributors and it uses the weighted-average method in its process costing system. The company has two processing departments-Cleaning...
-
What is the function of air chambers in a reciprocating pump?
-
(Qualitative Characteristics) SFAC No. 2 identifies the qualitative characteristics that make accounting information useful. Presented below are a number of questions related to these qualitative...
-
This is an appeal from a judgment at trial awarding general and exemplary damages to the plaintiff for trespass [1987 CanLII 2455 (BC SC), 18 B.C.L.R. (2d) 328, 45 C.C.L.T. 137, 45 D.L.R. (4th) 559]....
-
On January 1, 2022, when Chuck was 90 years old, he purchased an annuity contract for $45,000. The contract was to pay $10,000 per year over his remaining life. The life expectancy for someone who is...
-
For an investigation program or for investigators, identify where incident investigation communications are critical for any organization. What are some possible solutions, suggestions, actions or...
-
What are the main cultural similarities and differences between Australia and Colombia. Explain
-
What are the important characteristics of cache memory design?
-
1. What are some of the things IKEA is doing right to reach consumers in different markets? What else could it be doing? 2. IKEA has essentially changed the way people shop for furniture. Discuss the...
-
Describe/narrate a situation where you have experienced benefits of listening.
-
Statistics for three stocks, A, B and C, are shown in the following tables: Only on the basis of the information provided in the tables, and given a choice between a portfolio made up of equal...
-
In a large midwestern university, 30% of the students live in apartments. If 200 students are randomly selected, find the probability that the number of them living in apartments will be between 55...
-
A container of an organic liquid a $25^{\circ} \mathrm{C}$ has a mass of $1100 \mathrm{~kg}$ and a volume of $0.94 \mathrm{~m}^{3}$. Find the liquid's weight, its density, and its specific gravity.
-
What is the pressure one mile $(1.6 \mathrm{~km})$ beneath the ocean's surface?
-
At what pressure will water boil at $65^{\circ} \mathrm{C}$ ? The vapor pressure of water can be determined from the Antoine equation: \[\frac{P(P a)}{1 \times...
Study smarter with the SolutionInn App