cancel
Showing results for
Did you mean:

Building an interest payment projection forcast

Hi all,

I was wondering if someone might know how to build out a interest projection piece for an app?

For example if I had a loan which had a life of 3 years with 4 payments a year with a 6% interest rate. How would I go about projecting this out so that as the days draw closer and each interest period passes the current date the projections update dynamically to show the next 4 periods.

Below is roughly what I am trying to build towards

Many thanks,

Conor

1 ACCEPTED SOLUTION

Accepted Solutions
Super User

hi there @cnr

Please find the following, the scenario is a loan amount, interest based on the term and the total repayment is divided by the term. This is them shown to the user base on date in reference to the payment term.

If this is not your exact requirement you can take some bits from it.

Result

Steps

``````ClearCollect(
colPayments,
ForAll(
Sequence(12), //3 years with 4 payments
{
payment: yourPaymentValue,
yourStartDatePicker.SelectedDate,
Value * 4, //you wish to have 4 payments per month
Months
)
}
)
)``````
• Add a horizontal gallery and set its Item = colPayments
• Add two labels with Text values
• lblDate = ThisItem.month
• lblPayment = ThisItem.payment

The above will give you all the value in your collection.

To make it time relevant filter the collection

• Filter(colPayments, month >= Today())

The above will onlydisplaythe dates which newer than the current date.

Hope this helps

R

hey there if you liked the post give it a thumbs up, and if it solved your question please accept it as a solution.
Super User

hi there @cnr

Please find the following, the scenario is a loan amount, interest based on the term and the total repayment is divided by the term. This is them shown to the user base on date in reference to the payment term.

If this is not your exact requirement you can take some bits from it.

Result

Steps

``````ClearCollect(
colPayments,
ForAll(
Sequence(12), //3 years with 4 payments
{
payment: yourPaymentValue,
yourStartDatePicker.SelectedDate,
Value * 4, //you wish to have 4 payments per month
Months
)
}
)
)``````
• Add a horizontal gallery and set its Item = colPayments
• Add two labels with Text values
• lblDate = ThisItem.month
• lblPayment = ThisItem.payment

The above will give you all the value in your collection.

To make it time relevant filter the collection

• Filter(colPayments, month >= Today())

The above will onlydisplaythe dates which newer than the current date.

Hope this helps

R

hey there if you liked the post give it a thumbs up, and if it solved your question please accept it as a solution.

Announcements

Power Apps News & Announcements

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

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,966)