Question

Looking for the PV of net cash flow

Pharoah 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 Pharoah Inc. is 10%. Purchase: The company can purchase the site, construct the building, and purchase all store fixtures. The cost would be $1,830,000. An immediate down payment of $365,000 is required, and the remaining $1,465,000 would be paid off over five years with payments of $353,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 $57,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 Pharoah Inc. if Pharoah will lease the completed facility for 12 years. The annual payments would be $282,000. Pharoah would have no responsibility related to the facility over the 12 years. The terms of the lease are that Pharoah 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 $125,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. Your answer is incorrect. Using factor tables, calculate the present value of the net cash flows required of Pharoah Inc. for: (Round present value factor calculations to 5 decimal places, e.g. 1.25124 and the final answers to 0 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. Present Value 1. The purchase alternative $ 2. The lease alternative $

Answer 1

1. The purchase alternative, present value = $ 226409

	Cash flow	Present value
Immediate down payment	$365000	$365000
Annual payment for 5 years	353000 per year	$ 1338223 ( 353000 * 3.791)
Salvage value at end of 12 years	$ 580000	$ 184806 (580000*.3186)
Occupancy expense for 12 years	$ 57000	$ 388380 ( 57000*6.814)
Total present value of cash flows		$ 2276409

cost of funds is 10% . Present value of annuity @ 10% for 5 years =3.791

Present value of $ 1 at the end of 12th year @ 10% =.3186

Present value of annuity @ 10% for 12 years = 6.814

2.The lease alternative  

Present value =$ 2198779

	Cash flow	Present value
Deposit at the beginning	($ 125000)	($ 125000)
First payment of installment	($ 282000)	($ 282000)
Remaining 11 installments	($ 282000 each year)	( $ 1831607)   ( 282000*6.4951)
Returning of deposit at the end of 12th year	$ 12500	$ 39828 ( 12500*.3186)
Total present value of cash flows		$ 2198779

Present value of annuity for 11 years 2 10% = 6.4951