Home

Loan Amortization Template

%3CLINGO-SUB%20id%3D%22lingo-sub-359589%22%20slang%3D%22en-US%22%3ELoan%20Amortization%20Template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359589%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20trouble%20with%20the%20amount%20of%20payments%20per%20year%20cell.%20If%20I%20wish%20to%20pay%2012%20payments%20a%20year%20(monthly)%20the%20calculations%20are%20reasonably%20accurate%2C%20however%20if%20I%20wish%20to%20pay%20fortnightly%20or%20weekly%2C%20it%20still%20works%20out%20on%2012%20monthly%20payments%2C%20but%20dates%20of%20payments%20are%20spread%20over%20the%2026%20(fortnight)%20or%2052%20(weekly)payments.%20Even%20by%20doing%20calculations%20of%20monthly%20payments%20and%20then%20adding%20extra%20payments%20it%20still%20extrapolates%20it%20out%20further%20than%2012%20monthly%20payment%20(in%20time).%20Can%20anyone%20help%20how%20to%20fix%20the%20problem.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-359589%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ENumber%20of%20payments%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-861449%22%20slang%3D%22en-US%22%3ERe%3A%20Loan%20Amortization%20Template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-861449%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20same%20problem%2C%20the%20template%20seems%20to%20default%20the%20date%20to%20every%20month%2C%20even%20if%20I%20am%20making%20payments%20every%20two%20weeks.%26nbsp%3B%20I%20would%20like%20to%20change%20the%20date%20formula%20but%20cannot%20figure%20out%20how%20it%20should%20be%20coded%20to%20factor%20in%20and%20show%20the%20date%20of%20the%20payment%20on%20an%20every%20other%20week%20schedule%20versus%20monthly.%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F294462%22%20target%3D%22_blank%22%3E%40longtan2%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
longtan2
Occasional Visitor

I am having trouble with the amount of payments per year cell. If I wish to pay 12 payments a year (monthly) the calculations are reasonably accurate, however if I wish to pay fortnightly or weekly, it still works out on 12 monthly payments, but dates of payments are spread over the 26 (fortnight) or 52 (weekly)payments. Even by doing calculations of monthly payments and then adding extra payments it still extrapolates it out further than 12 monthly payment (in time). Can anyone help how to fix the problem.

1 Reply

I am having the same problem, the template seems to default the date to every month, even if I am making payments every two weeks.  I would like to change the date formula but cannot figure out how it should be coded to factor in and show the date of the payment on an every other week schedule versus monthly.@longtan2 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies