cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ramole
Super User
Super User

Loan Amortization Schedule

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.loan.png 

 

Thanks 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.
2 ACCEPTED SOLUTIONS

Accepted Solutions
eka24
Super User
Super User

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.

View solution in original post

LeeSJMarshall
Microsoft
Microsoft

Inspired by @eka24 I also had a go at this.  I took a similar approach but wanted to see if I could do everything in the collections.  No right or wrong, not sure if there's a better way of doing this but here's what I came up with:

https://youtu.be/DND--Peugec

LeeSJMarshall_0-1658561523658.png

 

View solution in original post

16 REPLIES 16
WarrenBelz
Super User
Super User

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
Super User
Super User

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

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 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

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

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 

 

columns.png

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.
eka24
Super User
Super User

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.

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

 

 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.
eka24
Super User
Super User

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.

@eka24 

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

 

 

 

 

Thank you
If this post helps, then Click on the Thumbs Up below. and Accept it as the solution . to help others find helpful.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,769)