Discounted Cash Flow Model

Closed - This job posting has been filled and work has been completed.
Accounting & Consulting Other - Accounting & Consulting Posted 2 years ago

Fixed Price

Delivery by August 31, 2013

$50.00

Budget

Details

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:
Interest Rate:
Term:

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.


About the Client

(4.99) 15 reviews

United States
San Diego 09:18 PM

22 Jobs Posted
82% Hire Rate, 1 Open Job

$6,578 Total Spent
21 Hires, 0 Active

$8.85/hr Avg Hourly Rate Paid
722 Hours

Member Since Aug 12, 2012