Ask a new question

Amortization Schedule in Excel with 12 month payment deferment

I need to build an amortization schedule for a 30-year loan.  It's based on 12 payments and the loan documents have the payment amount.  But I can't figure out how to show a 12-month deferment.  The loan was made in June 2020 and the first payment is due in June 2021.  Interest has accrued for the past 12 months but there have been no payments made.

Can someone point me in the right direction?  Or does someone know of a template that has this already built-in?

Thanks

EJ

Hi EJ,

 

Thank you for posting in this community.

 

Sorry that I am not familiar with the Amortization Schedule.

However, according to your description, I found the following information may help you.

Create a loan amortization schedule in Excel (with extra payments if needed) (ablebits.com)

How to Prepare Amortization Schedule in Excel (with Pictures) (wikihow.com)

 

Disclaimer: Microsoft provides no assurances and/or warranties, implied or otherwise, and is not responsible for the information you receive from the third-party linked sites or any support related to technology.​

 

If the above suggestions don’t work, feel free to contact me. And we will further assist you.

 

Best Regards,

May

 

-----------------------
* Beware of scammers posting fake support numbers here.
* Once complete conversation about this topic, kindly Mark and Vote any replies to benefit others reading this thread.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Hi EJ7875,

 

May I know if there any update?

If you need further help, welcome to contact me. And we will further assist you.

 

Best Regards,

May

-----------------------
* Beware of scammers posting fake support numbers here.
* Once complete conversation about this topic, kindly Mark and Vote any replies to benefit others reading this thread.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Thanks for following up.  I have not had any replies to my request, other than yours.  Still trying to work out the details.

Thanks

EJ

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

Please see the replies to this question for suggestions.

Be sure to include the version number and OS version when asking your question.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info

Last updated May 31, 2024 Views 573 Applies to: