3. Using cell references, create a PMT formula in cell D8 to calculate the monthly loan payment for a proposed loan from NewVentures Capital Inc. Note: The PMT function USES The same arguments as The PPMT function with The exception, that there is no Per criterion. Remember to divide The rate by 12 and multiply The nper by 12 to use monthly units. Ex: I want to know the specific Calculation process, and it would be best if you could show it in the PMT function of Excel.

4. Using cell references, create PPMT formulas to find the principal portion of the loan payment for the first loan payment in cell D10 and the last loan payment in cell D11. (I want to know the specific calculation process, and it would be best if you could show it in the PPMT function of Excel.)

Function Financial - Date & TimeMere Functions - Manager to create from Selection Defined Names 5 Remove Arrows - Evaluate Formula Formula Auditing Watch Windos Function Library D11 =PPMT(D4/12,1,D5*12,-16,0) B D E F H 1 2 3 Precision Design and Packaging Proposed New Warehouse Construction Financing through NewVentures Capital Inc. Quoted interest rate per annum 7.75% Amortization period in years 18 Principal amount to be borrowed $ 1,750,000 4 5 6 7. Monthly loan payment $15,048.32 8 9 10 11 12. Principal portion of first loan payment Principal portion of last loan payment 3,746.23 3,746.24 13 Total cost of loan 14 Loan + Ready me what you want to do wa e Trace Precedents 5 Show Formulas Trace Dependents Vs Error Checking- 5 Remove Arrows Evaluate Formula GIO Watch Window Selection Calculation Options Function Arguments ? PPMT Rate D4/12 1 0.006458333 Per 1 1 = 1 Nper D5*12 1 216 Pv -D6 til -1750000 FV 0 0 3746.236479 Returns the payment on the principal for a given investment based on periodic, constant payments and a constant interest rate. Rate is the interest rate per period. For example, use 6%/4 for quarterly payments at 6% Formula result = 3,746.24 Help on this function OK