HTT 230 WEEK 8 CHECKPOINT 352396
in Other (Other) by vomms
Favorite
Add it to your favorites and revisit later
Instant Download
Previewing 1 of 3 total pages.
Regular Price: $6.43
Your Price: $4.50 (30% discount)
You Save: $1.93
Your Price: $4.50 (30% discount)
You Save: $1.93
Description
WEEK 8 CHECKPOINT
- Determine the IRR and also NPV of the project by using a 12% discount rate along with a 15% cap rate. Ms. Brown surely could get a loan for 1,540,000, as well as an equity trader decided to invest the residual 660,000 in return for 20% ownership within the project. Year Cash Flow 1 695,000 2 876,250 3 1,057,500 4 1,238,750 5 1,420,000
IRR % (2200000) 695000 876250 1057500 1238750 1420000 IRR(A1:F1,0.1)
NPV
(2200000) 695000 876250 1057500 1238750 1420000 1,464,
A1NPV(,B1:F1)
- What is the loan-to-value ratio for this project? 1,540,000 2,200,000 70%
- What would the investors ROI be for this 5-year project if the restaurant achieved its budgeted operating results for the year?
660,000 1,420,000...
Comments (0)
You must sign in to make a comment.
Rating:
Published On:
12/21/2019
Last Updated:
12/21/2019
Print Length:
3 page(s)
Word Count:
112
File Name:
htt-230-week-8-checkpoint-352396-5.doc
File Size:
27.65 KB (0.03 MB)
Sold By:
vomms
Purchased:
0 times
Best Seller Ranking:
#