Sheridan 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 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 Sheridan Inc. is 12%. Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $1,860,000. An immediate down payment of $410,000 is required, and the remaining $1,450,000 would be paid off over five years with payments of $350,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 $580,000. As the owner of the property, the company will pay $52,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 Sheridan Inc. if Sheridan will lease the completed facility for 12 years. The annual payments would be $269,000. Sheridan would have no responsibility related to the facility over the 12 years. The terms of the lease are that Sheridan 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. Lease:

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

Please solve the present value of the lease alternative

Current Attempt in Progress
Sheridan 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 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 Sheridan Inc. is 12%.
Purchase:
The company can purchase the site, construct the building, and purchase all store fixtures. The cost would
$1,860,000. An immediate down payment of $410,000 is required, and the remaining $1,450,000 would be paid off
over five years with payments of $350,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 $580,000. As the owner of the
property, the company will pay $52,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
Sheridan Inc. if Sheridan will lease the completed facility for 12 years. The annual payments would be $269,000.
Sheridan would have no responsibility related to the facility over the 12 years. The terms of the lease are that
Sheridan 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
Lease:
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.
Transcribed Image Text:Current Attempt in Progress Sheridan 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 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 Sheridan Inc. is 12%. Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would $1,860,000. An immediate down payment of $410,000 is required, and the remaining $1,450,000 would be paid off over five years with payments of $350,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 $580,000. As the owner of the property, the company will pay $52,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 Sheridan Inc. if Sheridan will lease the completed facility for 12 years. The annual payments would be $269,000. Sheridan would have no responsibility related to the facility over the 12 years. The terms of the lease are that Sheridan 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 Lease: 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.
X Your answer is incorrect.
Using factor tables, calculate the present value of the net cash flows required of Sheridan Inc. for: (Round present value factor
calculations to 5 decimal places, e.g. 1.25124 and the final answers to O decimal places, e.g. 5,275.)
Click here to view the factor table PRESENT VALUE OF 1.
Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1.
Click here to view the factor table PRESENT VALUE OF AN ANNUITY DUE.
Present Value
1. The purchase alternative
1944290
2. The lease alternative
2$
1866241
%24
Transcribed Image Text:X Your answer is incorrect. Using factor tables, calculate the present value of the net cash flows required of Sheridan Inc. for: (Round present value factor calculations to 5 decimal places, e.g. 1.25124 and the final answers to O decimal places, e.g. 5,275.) Click here to view the factor table PRESENT VALUE OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITY OF 1. Click here to view the factor table PRESENT VALUE OF AN ANNUITY DUE. Present Value 1. The purchase alternative 1944290 2. The lease alternative 2$ 1866241 %24
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education