Cullumber Inc. owns and operates a number of hardware stores in the Atlantic region. Recently, the company decided to open anothe 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 Cullumber is 10%. Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $1,840,000. An immediate down payment of $405,000 is required, and the remaining $1,435,000 would be paid off over five years with payments of $347,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 $590,000. As the owner of the property, the company will pay $51,000 in occupancy expenses at the end of each year. Lease: First National Bank has agreed to purchase the site, construct the building, and install the appropriate fixtures for Cullumber if Cullumber will lease the completed facility for 12 years. The annual payments would be $310,000. Cullumber would have no responsibility related to the facility over the 12 years. The terms of the lease are that Cullumber 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 $100,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 10% discount rate.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
icon
Concept explainers
Topic Video
Question
Cullumber 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 Cullumber is 10%.
Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be
$1,840,000. An immediate down payment of $405,000 is required, and the remaining $1,435,000 would be paid off
over five years with payments of $347,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 $590,000. As the owner of the
property, the company will pay $51,000 in occupancy expenses at the end of each year.
Lease:
First National Bank has agreed to purchase the site, construct the building, and install the appropriate fixtures for
Cullumber if Cullumber will lease the completed facility for 12 years. The annual payments would be $310,000.
Cullumber would have no responsibility related to the facility over the 12 years. The terms of the lease are that
Cullumber 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 $100,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 10% discount rate.
Transcribed Image Text:Cullumber 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 Cullumber is 10%. Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $1,840,000. An immediate down payment of $405,000 is required, and the remaining $1,435,000 would be paid off over five years with payments of $347,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 $590,000. As the owner of the property, the company will pay $51,000 in occupancy expenses at the end of each year. Lease: First National Bank has agreed to purchase the site, construct the building, and install the appropriate fixtures for Cullumber if Cullumber will lease the completed facility for 12 years. The annual payments would be $310,000. Cullumber would have no responsibility related to the facility over the 12 years. The terms of the lease are that Cullumber 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 $100,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 10% discount rate.
Using Excel functions, calculate the present value of the net cash flows required of Cullumber 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.)
LA
$
LA
Present Value
Transcribed Image Text:Using Excel functions, calculate the present value of the net cash flows required of Cullumber 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.) LA $ LA Present Value
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education