HOFSTRA UNIVERSITY
FINANCE 220
FALL 2019
COMPUTER PROJECT
EQUITY PARTICIPATION MORTGAGE SIMULATION
FINANCE代写 Lender likes the growth potential for the property,put together an offer to Owner using a mortgage that includes Equity Participation cash flows.
THE SITUATION:
Your client, Lender, is developing a proposal to provide financing to Owner for the purchase of a commercial property. Owner requires an $900,000 loan to make the deal work. Market 1st mortgage rates for similar projects are 5.40%. A standard CPFAM at this rate results in a Debt Service amount producing a Debt Coverage Ratio (DCR) very close to 1.0, which is unacceptably low for both Lender and Owner. At the same time, Lender likes the growth potential for the property, and therefore wants to put together an offer to Owner using a mortgage that includes Equity Participation cash flows. FINANCE代写 The fundamentals of the deal at the current time, using a standard CPFAM are as follows:
Purchase Price $1,200,000
Mortgage Amount $900,000
Nominal Annual Mort. Rate 5.4%
Loan Term 20 yrs.
Year One NOI $74,000
NOI Annual Increase $3,000
NOI Caprate .0617
Investment Horizon 5 yrs.
The loan will be prepaid at the end of Year 5. The going-out caprate is expected to be the same as the going-in caprate of .0617.FINANCE代写
THE PROBLEM:
The problem with the standard CPFAM is that the Debt Coverage Ratio (DCR) is too low. Lender wants to correct that problem by structuring a proposal for an equity participation mortgage (epm) using a Base Mortgage at a below market rate, thus increasing the DCR. Your job is to structure a proposal that will be acceptable to Lender, and also to Owner.FINANCE代写
LENDER’S GUIDELINES:
1) Lender is looking for a DCR in the 1.1-1.3 range, but she will consider accepting a DCR slightly below 1.1 in Year One if it is helpful.
2) Lender realizes that she will be switching future cash flows from the base mortgage debt service, to some claim on cash flows that are less predictable. As a result, she is looking for an Internal Rate of Return (IRR) greater than 5.4%. She feels that a figure in the 7.0% range would be appropriate.FINANCE代写
3) Lender wants to have a Priority claim on current cash flows subordinate only to required Debt Service (DS), such that, if the priority is collected, she will have a total annual Cash Flow from DS and the Priority equal to or greater than DS would have been under the standard CPFAM.
4) Lender wants the Base Mortgage to be a 20 year CPFAM.
OWNER’S OBJECTIVES:
1) Owner’s Equity investors are anxious to receive some current return on equity (CROE) as soon as possible. They are expecting to see a CROE in the 3.0% range, but are willing to settle for less in the early years, provided that this return is greater than zero in all years.FINANCE代写
2) Owner must have a $900,000 loan; he has only $300,000 of Equity available.
YOUR OBJECTIVE:
It’s your job to put together a proposal that will be favorable for Lender, but will contain features that will make it acceptable to Owner. Remember, it’s easy to put together a sweetheart deal for Lender, but it will be meaningless unless the deal is acceptable to Owner.FINANCE代写
YOUR GUIDELINES:
You may propose any structure for the distribution of cash flows that you want, subject to the following limitations:
1) The Base Mortgage must be a 20 year CPFAM for $900,000.
2) The Purchase Price is $1,200,000.
3) The Year One NOI and the annual NOI increase cannot change.
4) The investment is a five year investment; the Mortgage will be prepaid at the end of Year 5. At that time, the building will be sold, or, if the capital gain is included in the Cash Flow distribution structure and the building is not sold, the capital gain will be computed.FINANCE代写
5) The going-in caprate and the going-out caprate at the end of Year 5 are assumed to be the same.
Remember that Owner is a valuable client. No matter how sweet the deal may be for Lender, it means nothing unless Owner also finds it to be appealing. Do not be insensitive to the needs of Owner.
ASSIGNMENTS:
1）SPREADSHEET ONE: Use an Excel spreadsheet to present a Statement of Cash Flows for each year in this investment under the Standard 5.4% CPFAM, including the expected IRR. This spreadsheet must be structured in simulation mode, so that all cash flows and the IRR will change automatically when any of the Assumptions are changed. To help you, I will post a pdf version of this spreadsheet that will contain the correct Cash Flows and the IRR of 5.32%. You may use my format in preparing Spreadsheet One, or another format that makes the Cash Flows equally clear.FINANCE代写
2）SPREADSHEET TWO: Now modify Spreadsheet One to express your proposal for the epm. I have suggested some categories for Cash Flow distribution that you may choose to use, but you need not use all of them, and you may want to develop other categories for distribution and add them in to Spreadsheet Two.
3）Present a narrative in Word format specifying the changes you are proposing in the mortgage proposal. Also present a brief but clear explanation of why it is that you believe your proposal is the best approach. Your recommendation will be evaluated on its clarity, its appropriateness, its responsiveness to the assignment, and the degree to which it reflects a sensitivity to the marketability of the proposal to Owner. There is no “right” answer.FINANCE代写
GUIDELINES:
1）The Cash Flow Statements must be in simulation mode, so that the consequences of changes in fundamental assumptions can be easily tested.
2）The assignment must be submitted in two forms. First, the complete report must be submitted to my digital drop box in Blackboard. Second, you must submit a printed version, which will be the version I use to grade the project. Of course, I may check the drop box to confirm that your spreadsheet is structured correctly.FINANCE代写
3）Neatness counts! Make your report clear, brief, responsive to the assignment, well-formatted and easy to understand. Make sure each of your spreadsheets is labeled clearly and formatted beautifully. This is a 1.2 million dollar investment; I don’t want to see pennies on the spreadsheet!
4）Everything appearing on the hard copy submission must be digitally generated. This means that the hard copy will be exactly the same as the digital version in the drop box. Nothing written by hand can appear on the hard copy submission.FINANCE代写
5）You are permitted to complete this assignment yourself, or in groups of up to three students. The assignment will be graded the same way no matter how many authors it has. You may discuss this assignment with other students not in your group. However, your group is required to create the spreadsheets independently. Electronic duplications of work between groups are not acceptable and are subject to severe punishment. You MAY discuss this assignment with your instructor, but not with any other member of Hofstra’s faculty.FINANCE代写
更多其他：Report代写 prensentation代写 Case study代写 Academic代写 Review代写 Resume代写 Proposal代写
您必须登录才能发表评论。