Need help with an excel spreadsheet - Due TODAY

Activity #3:

Using the property you selected in Weeks 1 and 2 determine the following:

What are the financing requirements for the purchase of the property?   I began by utilizing the website for the lender that holds the current mortgage. According to Greenwich capital there are numerous documents that are needed as well as the following information just to get started:

http://greenwich.brixtec.com/ContactInfo.php

The required down payment according to the commercial listing agent website is showing 43% at $8,530,929

Conduct a search for a commercial lender that services your property class and determine the following items:

http://www.commercialbanc.com/calculator-payment.html

· What is the amount of the down payment? (Equity) $8,530,929

· What is the interest rate on a new loan? 7.5%

· What is the amortization period? 30 years

· Calculate the debt service (amount of monthly payments to pay off the debt) $80,682 per month

(Provide a link to your lender's information) http://www.commercialbanc.com/calculator-payment.html

Assume that the sales price (and BTER) are 25% greater than the purchase price.

Assume the sales price is 25% greater than actual purchase price : $15,043,678.50

I then input the 5 years of cashflow calculated in week 2 into the NPV calculator with a discount rate of 7.5% , it gave me an NPV of $3,921,331.60

Using the Week 2 spreadsheet calculate the NPV of the investment (using the 5-year projection).

Calculate the IRR for this investment. IRR for this investment is 18.03%

http://tools.financial-projections.com/IRRInternalRateOfReturn.html

http://www.financeformulas.net/Net_Present_Value.html