6 month repayment holiday at start of Loan Amortization

Question

I am building a loan repayment schedule using the Microsoft template "Loan Amortization Schedule" and all ok as my loan is standard features, except I have 6 months payment holiday at the start of the 2 year loan. I need to adjust the formulas to account for this 6 month holiday

bhushan_z · Answer

David250&nbsp;refer attached file.&nbsp;Notes:1) Added new sheet - "Modified" (kept original sheet)2) Added new parameter, 'Payment holidays (months)' at row #83) I have assumed that, u will have to pay interest amount even during holiday period

bhushan_z · Answer

can u pls share the file?u may remove ur confidential data, like loan amount, interest %, etc.

david250 · Answer

bhushan_z&nbsp;

dhan3105 · Answer

Hello @bhusan_Z .I have similar requirment. But I want add the parament of Date for those month For Example :Loan amount $50,000.00Annual interest rate 3.59%Loan period in years 1Number of payments per year 12Start date of loan 01/01/2020Payment Holiday Date start from: 01/05/2020Payment holiday (months) 3Example : https://www.bankofscotland.co.uk/mortgages/existing-customers/halifax-payment-holiday-calculator.htmlMany ThanksDan

dhan3105 · Answer

Hi expert can someone&nbsp; assit me on this I want to incorporate&nbsp;Payment Holiday Date start from: 01/05/2020 and end 30/7/2020Payment holiday (months) 3. I have also attached as an example&nbsp;Many ThanksDhan

Forum Discussion

6 month repayment holiday at start of Loan Amortization

7 Replies

Resources