ACC
Debt Financing Excel Calculator.xls

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

Info icon This preview shows pages 1–7. Sign up to view the full content.

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

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

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

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

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

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

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
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern