Given the following information provide an analysis that answers the questions at the end of the assignment.

Purchase Price: $4,250,000

Rents:

Tenant	Unit 1	Unit 2	Unit 3	Unit 4	Unit 5	Unit 6	Unit 7	Unit 8
Monthly Rent	$5,400	$5,400	$6,200	$3,500	$3,600	$3,300	$3,700	$3,100

Year 1 NOI: $248,678

NOI Growth Rate: 2.6%

Loan:

LTV: 75%

Amortization Period: 25 years, Term: 10 years

Interest Rate: 3.35%

Lender Points: 2%

Selling Costs: 3%

Going Out Cap Rate: 5.5%

Discount Rate: 10%

Questions:

So far I have going-in cap rate = 5.85%

PGI= 410,400

1. What is the DSCR?
2. What is the sale price after the five-year hold?
3. What is the loan balance at sale?

Can you teach me how to do this on excel?