6 month repayment holiday at start of Loan Amortization

%3CLINGO-SUB%20id%3D%22lingo-sub-1382268%22%20slang%3D%22en-US%22%3E6%20month%20repayment%20holiday%20at%20start%20of%20Loan%20Amortization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382268%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20building%20a%20loan%20repayment%20schedule%20using%20the%20Microsoft%20template%20%22Loan%20Amortization%20Schedule%22%20and%20all%20ok%20as%20my%20loan%20is%20standard%20features%2C%20except%20I%20have%206%20months%20payment%20holiday%20at%20the%20start%20of%20the%202%20year%20loan.%20I%20need%20to%20adjust%20the%20formulas%20to%20account%20for%20this%206%20month%20holiday%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1382268%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1382319%22%20slang%3D%22en-US%22%3ERe%3A%206%20month%20repayment%20holiday%20at%20start%20of%20Loan%20Amortization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1382319%22%20slang%3D%22en-US%22%3Ecan%20u%20pls%20share%20the%20file%3F%3CBR%20%2F%3Eu%20may%20remove%20ur%20confidential%20data%2C%20like%20loan%20amount%2C%20interest%20%25%2C%20etc.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1392399%22%20slang%3D%22en-US%22%3ERe%3A%206%20month%20repayment%20holiday%20at%20start%20of%20Loan%20Amortization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392399%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662966%22%20target%3D%22_blank%22%3E%40bhushan_z%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1392856%22%20slang%3D%22en-US%22%3ERe%3A%206%20month%20repayment%20holiday%20at%20start%20of%20Loan%20Amortization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1392856%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F664497%22%20target%3D%22_blank%22%3E%40David250%3C%2FA%3E%26nbsp%3Brefer%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENotes%3A%3C%2FP%3E%3CP%3E1)%20Added%20new%20sheet%20-%20%22Modified%22%20(kept%20original%20sheet)%3C%2FP%3E%3CP%3E2)%20Added%20new%20parameter%2C%20'Payment%20holidays%20(months)'%20at%20row%20%238%3C%2FP%3E%3CP%3E3)%20I%20have%20assumed%20that%2C%20u%20will%20have%20to%20pay%20interest%20amount%20even%20during%20holiday%20period%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433859%22%20slang%3D%22en-US%22%3ERe%3A%206%20month%20repayment%20holiday%20at%20start%20of%20Loan%20Amortization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433859%22%20slang%3D%22en-US%22%3EHello%20%40bhusan_Z%20.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20similar%20requirment.%20But%20I%20want%20add%20the%20parament%20of%20Date%20for%20those%20month%20For%20Example%20%3A%3CBR%20%2F%3ELoan%20amount%20%2450%2C000.00%3CBR%20%2F%3EAnnual%20interest%20rate%203.59%25%3CBR%20%2F%3ELoan%20period%20in%20years%201%3CBR%20%2F%3ENumber%20of%20payments%20per%20year%2012%3CBR%20%2F%3EStart%20date%20of%20loan%2001%2F01%2F2020%3CBR%20%2F%3EPayment%20Holiday%20Date%20start%20from%3A%2001%2F05%2F2020%3CBR%20%2F%3EPayment%20holiday%20(months)%203%3CBR%20%2F%3EExample%20%3A%20%3CA%20href%3D%22https%3A%2F%2Fwww.bankofscotland.co.uk%2Fmortgages%2Fexisting-customers%2Fhalifax-payment-holiday-calculator.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.bankofscotland.co.uk%2Fmortgages%2Fexisting-customers%2Fhalifax-payment-holiday-calculator.html%3C%2FA%3E%3CBR%20%2F%3EMany%20Thanks%3CBR%20%2F%3EDan%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1433897%22%20slang%3D%22en-US%22%3ERe%3A%206%20month%20repayment%20holiday%20at%20start%20of%20Loan%20Amortization%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1433897%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20expert%20can%20someone%26nbsp%3B%20assit%20me%20on%20this%20I%20want%20to%20incorporate%26nbsp%3B%3CSPAN%3EPayment%20Holiday%20Date%20start%20from%3A%2001%2F05%2F2020%20and%20end%2030%2F7%2F2020%3CBR%20%2F%3EPayment%20holiday%20(months)%203.%20I%20have%20also%20attached%20as%20an%20example%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EMany%20Thanks%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EDhan%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

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

@David250 refer attached file.

 

Notes:

1) Added new sheet - "Modified" (kept original sheet)

2) Added new parameter, 'Payment holidays (months)' at row #8

3) I have assumed that, u will have to pay interest amount even during holiday period

Highlighted
Hello @bhusan_Z .

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

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

 

Many Thanks

Dhan