View the step-by-step solution to:

Question

# Can You help me solve this in excel I keep Using the =NPV function But I dont know if I am using rthe right data I

am trying to solve question 1.

Siesta Restaurant
VALUE OF MONEY APPLICATIONS 283
Operating Results
(000)
2002
Revenue
2003
Food
\$900
2004
2005
Beverage
350
\$925
2006
Total
1,250
360
\$950
365
\$975
\$1,000
Operating expenses
1,285
1,315
370
1,345
375
Food cost
240
1,375
Beverage cost
50
255
Labor cost
550
53
270
285
585
54
Travel
57
300
615
60
Marketing
120
120
650
685
60
50
120
120
Utilities
60
40
120
65
20
70
10
Rent
160
162
75
80
Total
1,240
163
1,290
165
150
1,332
1,372
1,405
Operating Profit (Loss)
\$10
\$ (5)
\$(17)
\$(27)
\$(30)
Based on Paris's market analysis, tour of the competition, inspection of the subject property,
and interviews with the prior owner, she concludes a Star Restaurant would work in the subject
space, but it would require approximately \$200,000 of renovation and conversion cost in addition
to the land purchase price of \$2,000,000. By Year 5, the restaurant could generate \$2.5 million
in annual food revenue and \$1.5 million in annual beverage revenue. Ms. Brown estimates the
following cash flows for the first five years of operations, with cash flows leveling off in Year 5.
Year
Cash Flow
1
\$695,000
W N
876,250
1,057,500
1,238,750
1,420,000
Calculate the IRR and NPV of this project utilizing a 12% discount rate and a 15% cap rate. Ms. Brown
1.
was able to secure a loan for \$1,540,000, and an equity investor agreed to invest the remaining
\$660,000 in exchange for 20% ownership in the project.

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents