Debt Financing Excel Calculator.xls - PV of Bond Face Value Annual Coupon Rate Market Rate of Interest Years to Maturity Payment Frequency\/Compounding

Debt Financing Excel Calculator.xls - PV of Bond Face Value...

This preview shows page 1 - 7 out of 35 pages.

PV of Bond Face Value $ 200,000 Annual Coupon Rate 10.00% Market Rate of Interest 12.00% Years to Maturity 10 Payment Frequency/Compounding 2 Value of Bond $177,060.16
Image of page 1
PMT on Loan Loan Amount $ 270,000 Annual Interest Rate 7.50% Duration of the Loan in Years 30 Frequency of Payments Monthly Payment Amount $1,887.88
Image of page 2
Image of page 3
Cost of Line of Credit Line of Credit Available $ 1,000,000 Commitment Rate 0.01% Line of Credit Used $ 100,000 Date Borrowed 1-Feb Interest Rate 8.00% Total Cost of Line of Credit $5,433.33
Image of page 4
Image of page 5
Simple Interest Loan Calculator Loan Information [42] Summary Loan Amount $ 90,000.00 Daily Interest Rate Annual Interest Rate 12.00% Number of Payments Term of Loan in Years 7 Total Payments First Day Interest Accrues 1/1/2017 Total Interest First Payment Date 2/1/2017 Balloon Payment Payment Frequency Monthly Days in Year 360 Balloon Payment # $ - Rounding On 1 Monthly Payment $1,588.75 Amortization Schedule Date Payment 12/31/16 $ 90,000 1 2/1/17 1,588.75 960.00 0.00 89,371.25 2 3/1/17 1,588.75 834.13 0.00 88,616.64 3 4/1/17 1,588.75 915.71 0.00 87,943.60 4 5/1/17 1,588.75 879.44 0.00 87,234.30 5 6/1/17 1,588.75 901.42 0.00 86,546.97 6 7/1/17 1,588.75 865.47 0.00 85,823.69 7 8/1/17 1,588.75 886.84 0.00 85,121.79 8 9/1/17 1,588.75 879.59 0.00 84,412.63 9 10/1/17 1,588.75 844.13 0.00 83,668.02 10 11/1/17 1,588.75 864.57 0.00 82,943.84 11 12/1/17 1,588.75 829.44 0.00 82,184.53 12
Image of page 6
Image of page 7

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture