Loan Amortization Schedule

[Ramole]

Hello every body,

I would like your expert help urgently please i would like to make Loan Amortization Schedule and i dont know where to start please help , here screenshot. 

Thanks 

[WarrenBelz]

Hi @Ramole ,

This is a fairly large and complex exercise.

The only reference I could find is this post related to PowerBI. The formulas however would be useful to you.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[eka24]

I agree with @WarrenBelz that powerbi would better handle this complex issue.
A smaller version with doesn't really meet the amortization standard is WITH FUNCTIONS for sample
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-with


If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

[Ramole]

Hi,

I have just made it calculations app and its calculating fine via Payment frequency dropdown  and loan due date, but the only thing i need help is example if select Payment frequency dropdown Monthly it should populate the due date of 4 times things like please 

Thanks 

[eka24]

What is the tablename and it columns for the dropdown. When you select the dropdown what should be populated.

If you like this post, give a thumbs up. Where it solved your issue, Mark as a solution

[Ramole]

Hi @eka24 

Table Name : Loan Management

Columns dropdown: Weekly  Bi-weekly Monthly   Daily   Bi-monthly  Quarterly   Annual

if clicked Monthly it should populate 4x due date with correct data like 3/20/2020  04/20/2020 5/20/2020 06/20/2020  from  LoanRequestedDate columns 

Thanks 

[eka24 · Accepted solution]

I have a tutorial on this:

https://youtu.be/hGV-qsH6Gpg

Hope it helps

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Ramole]

Hi @eka24 

Wow - can please show me how I can I assign / attach to the record to a person once generated and send it to data source like SharePoint in another words, to save back end so i can keep history and run reports 

Thank you so much

[eka24]

If you want to save to your Datasources, use Patch function. Watch this tutorial:

https://youtu.be/gKWf_XQyIH0

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Ramole]

@eka24 

Are you planning to upload the sample app in the community ?