Net Present Value Analysis of a Lease or Buy Decision Faster Fashion Stores, Inc., owns a nationwide chain of supermarkets. The company is going to open another store soon, and a suitable building site has been located in an attractive and rapidly growing area. In discussing how the company can acquire the desired building and other facilities needed to open the new store, The Dude Watkins, the company's vice president in charge of sales, stated, "I know most of our competitors are starting to lease facilities rather than buy, but I just can't see the economics of it. Our development people tell me that we can buy the building site, put a building on it, and get all the store fixtures we need for just $850,000. They also say that property taxes, insurance, and repairs would run $20,000 a year. When you figure that we plan to keep a site for 18 years, that's a total cost of $1,210,000. But then when you realize that the property will be worth at least a half million in 18 years, that's a net cost to us of only $710,000. What would it cost to lease the property?" "I understand that Grate Insurance Company is willing to purchase the building site, construct a building and install fixtures to our specifications, and then lease the facility to us for 18 years at an annual lease payment of $120,000," replied Wage Garnisher Coleman, the company's executive vice president. "That's just my point," said The Dude. "At $120,000 a year, it would cost us a cool $2, 160,000 over the 18 years. That's three times what it would cost to buy, and what would we have left at the end? Nothing! The building would belong to the insurance company!" "You're overlooking a few things," replied Wage Garnisher. "For one thing, the treasurer's office says that we could only afford to put $350,000 down if we buy the property, and then we would have to pay the other $500,000 off over four years at $175,000 a year. So there would be some interest involved on the purchase side that you haven't figured in." "But that little bit of interest is nothing compared to over 2 million bucks for leasing," said The Dude. "Also, if we lease I understand we would have to put up an $8,000 security deposit that we wouldn't get back until the end. And besides that, we would still have to pay all the yearly repairs and maintenance costs just like we owned the property. No wonder those insurance companies are so rich if they can swing deals like this.""Well, I'll admit that I don't have all the figures sorted out yet," replied Wage Garnisher. "But I do have the operating cost breakdown for the building, which includes $7,500 annually for property taxes, $8,000 for insurance, and $4,500 for repairs and maintenance. If we lease, Grate will handle its own insurance costs and of course the owner will have to pay the property taxes. I'll put all this together and see if leasing makes any sense with our required rate of return of 16%. The president wants a presentation and recommendation in the executive committee meeting tomorrow. Let's see, development said the first lease payment would be due now and the remaining ones due in years 1-17. Development also said that this store should generate a net cash inflow that's well above the average for our stores." Required: (Ignore income taxes.) Using the net present value approach, determine whether Faster Fashion Stores, Inc., should lease or buy the new facility. Assume that you will be making your presentation before the company's 1 executive committee. How will you reply in the meeting if The Dude Watkins brings up the issue of the building's future 2 sales value?w .n. m m 10 11 12 13 14 15 16 Cash Flow Description Store Site Cost Annual Property Taxes Annual Insurance Cost Annual Repairs Annual Property Taxes, Insurance, and Repairs Site Salvage Value Annual Lease Payments Loan Downpayment Annual Loan Payments Life of the Loan {Years} Life of the Store (Years) Lease Security Deposit Required Rate of Return Cash Flows Amounts to choose from 850,000.00 7,500 00 8,000.00 4,500.00 20,000.00 500,000.00 120,000.00 350,000.00 175,000 00 4.00 18.00 8,000.00 15.00% Periods in Choose from 1 1 ihrnugh 18 1 through 4 18 2 3 4 1 through 1? 0 1? I NOTE: The periods and cash flows aren't necessarily matched. Pick and match as you interpret the ploblem 17 To Buy Cash Flow Present 18 Cash Flow Value Using Excel Period Cash Flow Description Amount Formula 19 0 Store Site Cost (850,000.00) (850,000.00) 20 1 through 18 Site Salvage Value 500,000.00 34,572.13 21 22 23 24 25 26 27 28 29 30 31 32 Net Present ValueCash Flow Present 35 Cash Flow Value Using Excel Period Cash Flow Description Amount Formula 36 37 38 39 40 41 42 43 44 45 46 47 Net Present ValueAnother note on Comprehensive Problem 3 Posted on: Friday, May 6, 2022 11:08:22 AM CDT The site value cost on the Cost to Buy option should be broken up by the loan payments You can erase the lump amount I had in the template shared with ya'll Replace the lump-sum 850,000 with the loan payment cash flow amounts and calculate present value accordingly Comprehensive Problem 3 check Figures Posted on: Friday, May 6, 2022 11:05:24 AM CDT Cost to Buy: net (outflowlcostl o1(921,456.44) Cost to Lease: net (outowlcust) of (843'4F1.65) Just do your best I know there's a lotto take care at during this last week