Looking for someone to create an excel template for me

%3CLINGO-SUB%20id%3D%22lingo-sub-1455250%22%20slang%3D%22en-US%22%3ELooking%20for%20someone%20to%20create%20an%20excel%20template%20for%20me%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455250%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20extremely%20new%20to%20excel%20and%20hopeful%20to%20find%20someone%20to%20create%20me%20an%20excel%20document.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20found%20the%20excel%20template%20'Loan%20Amortization%20schedule'%2C%20which%20is%20the%20closest%20thing%20to%20what%20I%20am%20looking%20for.%20However%2C%20it%20appears%20that%20it%20can't%20be%20changed%20from%20Monthly%20payment%20to%20Weekly%20payments%20(even%20when%20typing%20in%2052%20payments%20a%20year).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20situation%20is%2C%20I%20will%20be%20making%20weekly%20payments%20(amounts%20will%20differ)%2C%20and%20they%20may%20also%20be%20a%20monthly%20payment%20I%20get%2C%20which%20I%20would%20also%20like%20to%20put%20on%20the%20loan.%20Along%20with%20an%20offset%20account%20(which%20will%20also%20offset%20the%20interest).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20assistance%20would%20be%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1455250%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455305%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20someone%20to%20create%20an%20excel%20template%20for%20me%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455305%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20posted%20a%20YouTube%20video%20on%20loan%20amortization%20schedule%20which%2C%20I%20believe%20answers%20your%20question%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20watch%20in%20the%20link%20below%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fyoutube.com%2Fwatch%3Fv%3Dp7Y6KPEQNCI%26amp%3Bt%3D240s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fyoutube.com%2Fwatch%3Fv%3Dp7Y6KPEQNCI%26amp%3Bt%3D240s%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EDo%20let%20me%20hear%20from%20you%20%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455798%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20someone%20to%20create%20an%20excel%20template%20for%20me%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455798%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F695849%22%20target%3D%22_blank%22%3E%40TripsterYH%3C%2FA%3E%26nbsp%3BAs%20with%20most%20templates%20found%20on-line%2C%20they%20are%20not%20very%20useful%20if%20your%20own%20needs%20do%20not%20%3CFONT%20color%3D%22%23FF0000%22%3Eexactly%3C%2FFONT%3E%20meet%20those%20of%20the%20creator.%20They%20are%20often%20full%20with%20tricks%2C%20named%20ranges%20and%20named%20formulae%20and%20hidden%20%22treasures%22.%20This%20particular%20one%20is%20indeed%20quite%20silly%20as%20it%20allows%20you%20to%20enter%2052%20payments%20per%20year%2C%20but%20it%20calculates%20payment%20dates%20on%20a%20monthly%20basis.%20I%20changed%20the%20formula%20in%20C%20to%20add%207%20days%20to%20each%20previous%20payment%20date.%20Also%20added%20360%20rows%20to%20the%20table%20allowing%20for%2015%20years%20with%2052%20payments%20each.%20Now%2C%20i%20didn't%20touch%20any%20of%20the%20other%20formulae%20and%20it%20seems%20to%20work%20just%20fine.%3C%2FP%3E%3CP%3ESee%20if%20the%20attached%20file%20works%20for%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1455863%22%20slang%3D%22en-US%22%3ERe%3A%20Looking%20for%20someone%20to%20create%20an%20excel%20template%20for%20me%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1455863%22%20slang%3D%22en-US%22%3E%3CP%3E%3CU%3EPlease%20send%20me%20the%20details%3B%20I%20can%20prepare%20a%20template%20for%20you%3C%2FU%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3ESanjeev%20Soni%3C%2FU%3E%3C%2FP%3E%3CP%3E%3CU%3E%3CFONT%3Esanjeev.soni%40lolintegrationsolutions.com%3CBR%20%2F%3E%3C%2FFONT%3E%3C%2FU%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hello, 

 

I am extremely new to excel and hopeful to find someone to create me an excel document.

 

I found the excel template 'Loan Amortization schedule', which is the closest thing to what I am looking for. However, it appears that it can't be changed from Monthly payment to Weekly payments (even when typing in 52 payments a year).

 

The situation is, I will be making weekly payments (amounts will differ), and they may also be a monthly payment I get, which I would also like to put on the loan. Along with an offset account (which will also offset the interest).

 

Any assistance would be appreciated.

 

3 Replies
Highlighted
Hello,

I posted a YouTube video on loan amortization schedule which, I believe answers your question

You can watch in the link below
https://youtube.com/watch?v=p7Y6KPEQNCI&t=240s

Do let me hear from you

Cheers
Highlighted

@TripsterYH As with most templates found on-line, they are not very useful if your own needs do not exactly meet those of the creator. They are often full with tricks, named ranges and named formulae and hidden "treasures". This particular one is indeed quite silly as it allows you to enter 52 payments per year, but it calculates payment dates on a monthly basis. I changed the formula in C to add 7 days to each previous payment date. Also added 360 rows to the table allowing for 15 years with 52 payments each. Now, i didn't touch any of the other formulae and it seems to work just fine.

See if the attached file works for you.

Highlighted

Please send me the details; I can prepare a template for you

 

Sanjeev Soni

sanjeev.soni@lolintegrationsolutions.com