Modeling an Amortization Curve (Back End)

[angelalvarado]

Assume you are in charge of developing an Amortization Curve for a 10 years loan. It's mandatory that the curve is back end in order to satissfy the neccesities, how can you assign the specific weights to each period in excel?