Note: IF YOU HAVE NOT DONE A DISCOUNTED CASH FLOW MODEL FOR A PERFORMING NOTE, YOU WILL NOT BE ABLE TO DO THIS PROJECT.
I am seeking a Microsoft Excel Expert who can quickly put together a discounted cash flow model. The cash flow model will be used to obtain the discount required for buyer of a performing note a specific yield based upon current cash flow and future payoff.
The inputs required will include:
Current Unpaid Principal:
Investor Purchase Price:
Investor Yield: (figure to obtain)
The idea is to input the figures in the first 3 inputs and the needed investor yield which would result in the purchase price.
The investor purchase price must not only include the income over the term of the note, but also a yield resulting from the payoff at the actual note balance.
The model should include 2 tabs. The first tab will include the inputs and the results. The second tab will be a month to month cash flow showing distributions.
I will pay upon receipt and verification that the model works.