File Home Insert Draw Page Layout Formulas Data Review View Developer Help Power Pivot fx [A Define Name v By Trace Precedents Use in Formula Insert Function AutoSum Recently Financial Logical Text v Used Date & Time Lookup & Math & Reference Trig More Functions Name Trace DependentsError Checking Function Library Manager Create from Selection Defined Names Show Formulas Calculate Now Watch Calculation Calculate Sheet Remove Arrows Evaluate Formula Window Options Formula Auditing Calculation 16 fx =@SUMM(B16:K16) A W&K Loan Conditions Loan amount (pv) Annual interest rate Monthly interest rate (rate) Loan period in years Loan period in months (nper) Monthly payment Start date of loan 13 C D E F H I J K L Expansion Loan Amounts Depreciation Conditions $800,000 Long term assers (cost) $800,000 4.45% Salvage value (salvage) $128,000 0.37% 10 Life of asset (life) 10 120 ($8,272) 1/6/2022 Annual Principal and Cumulative Interest Payments Years 1 2 3 4 5 6 7 9 10 1 13 25 37 49 61 73 85 97 109 Months 12 24 36 48 60 72 84 96 108 120 Toral Interest #NAME? Principal $0