Prepare a mortgage amortization schedule based on the following terms.

Amount: $640,000

Rate: 10 Year Treasury plus 275 basis points

Term: 10 Years

Amortization: 30 Years

Payment: Annually

2.1 What is the annual payment?

2.2 What is the payment constant?

2.3 What is the mortgage balance at the end of year 10?

2.3 For the first payment, how much is Interest?

Question 2: Prepare a 5-year DCF based upon the following assumptions:

NCF: Year 1 $677,000

Growth Rate: 2.7%

Cap Rate: 6.0%

Residual Rate: 9.5%

WACC: 6.5%

3.1 What is the Purchase Price?

3.2 What is the IRR?

3.3 What is the NPV?

Question 3: Calculate the price of a stock based upon the following terms:

4.1 Dividend: $19

Discount Rate: 11%

Dividend Growth Rate: 0%

What is the price of the stock at the end of year 3?

4.2 Dividend $21

Discount Rate: 10%

Dividend Growth Rate: 2%

What is the price of the stock at the end of year 4?

Question 4: You are the CEO of a company that is having difficulties this year because of COVID. You have 18 partners. Your CFO informed you this morning that a Capital Call is required and that the amount will be $16,000 per partner totaling $288,000. Please answer the following:

5.1 What is the effect of the Capital Call on the Income Statement?

5.2 What is the effect of the Capital Call on the Balance Sheet?

5.3 What is the effect of the Capital Call on the NCF?

5.4 What is the effect of the Capital Call on the IRR?

5.5 What is the effect of the Capital Call on the NPV?

5.6 What is the effect of the Capital Call on the company's taxable income?