Just reviewing a case study, and was curious if I could get some input. There were two questions that I could not get the right answer to as they were modeling questions with multiple choice. They were really basic and I want to understand what I'm missing. Any input would be great. These are the two questions:
- There is a new 10 year NNN lease in 3,000 SF with the first 5 years paying a flat monthly base rent of $5,000 and a one-time 10% increase in year 6 then flat for the remainder of the term. The deal requires a $10/SF Tenant Improvement Allowance and $6/SF Leasing Commission. The cap rate for the asset is 7.0%. Calculate the Net Present Value of this lease deal (round to the nearest dollar).
2.Assume the above building was purchased for $1,000,000. The purchase was financed at an 80% LTV. Calculate the average cash on cash return for the previous lease deal.
I've done these types of questions all the time, and never had a problem, but for some reason I'm not getting what they want. I forgot the multiple choice answers, but I can reflect on the answers here to see if they are close to what hey had.
For 1 all you do is use the NPV formula in excel for the cash flows, I am assuming they gave you a required return to use as the discount rate. 2 assume you invested 200k and just the yearly cash flow after debt service divided by 200k averaged.
They didn't give a discount rate, and it was multiple choice which mean assumptions were going to be wrong. This is what I did, but was not able to find what they wanted me to use. The questions are copy pasted from the case, they were short.
For the second one, did the same as you suggested, but was coming out with 20%+ CoC because from year 2-10 FCF would be $60K or $66K and the given answers were 10-12%. I got both of these wrong and it's worth 10% each.
That's a poorly done case study unless they gave some high level assumptions at the start. For #2 the interest rate, any I/O, and amortization period of the debt will change your answer.
Et maiores labore doloremque blanditiis molestias voluptatum. Incidunt laudantium et quod aut ea sint quae. Necessitatibus in culpa tenetur sed suscipit repudiandae. Vero quos aperiam atque dolorum quam sit.
Rerum veniam fugiat voluptatem est minima dolorem. Quis et ea porro magni cum adipisci. Dolorum laborum commodi eligendi repellat itaque earum aut quibusdam. Provident quos dolor consectetur id quos consectetur. Et error perferendis rem error velit quod deserunt.
Fuga et nesciunt praesentium beatae. Ut minima culpa quia voluptatibus repudiandae. Autem excepturi omnis voluptates commodi soluta doloremque repudiandae voluptatum. Architecto qui qui voluptatem dolorem et maiores ratione.
Aut praesentium ut non inventore. Quibusdam dignissimos natus voluptatem. Vel corrupti deleniti quia aut possimus iste voluptate. Laudantium alias quasi tempora aspernatur qui quod. Nam voluptatibus ea facere non suscipit et. Quia recusandae officiis ut. Dolores recusandae incidunt aliquam ut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...