I need an EXPERT at this. Please don't apply if you are anything short of an expert. If you accept the job and then can't complete it, I will issue negative feedback. PLEASE only apply if you can complete this project in the next 12 hours. NO exceptions.
I need you to create a formula (you may need to create tables to do this) that will calculate the following scenario:
I'm getting a no interest loan from someone with a principal balance of Cell B22 and a balloon payment in B17 years. I want to calculate how much interest (Cell I6) I will earn on their money over the number of years listed in Cell B17 compounded monthly. Here's the thing though... there may or may not be a monthly payment made on the loan. If there is a monthly payment, the monthly payment will be listed in B20 and will 100% go towards principal. If there is a monthly payment made, it will obviously decrease the amount of money I can earn interest on every month so this is what makes the formula complex. Someone else working on this before but didn't do it right. You may need to create an amortization table for each column but that should be done in another sheet in the spreadsheet.
This formula should be calculated in Cell B29 and then also work in Cells C29, D29, E29, F29, G29, H29, & I29 for the data is those rows.
You must speak fluent english as well.
13 freelanceria on tarjonnut keskimäärin $165 tähän työhön
Dear, I'm Adel, Data Scientist. I can deal with Google sheets as I've graduated from Brtlesmann scholarship in audacity in which I learnt Google spreadsheet. You can ask me for a small task before awarding me!
Sir I am expert in developing new formulas. I worked on this and find one solution. if you are interested I can share with you. Just inbox request , I will share with you. If it is ok with you you can accept sir.
I'm verry familiar with G-Sheetand its formulasi. I usually us it to manage my work and analyze data for machine learning. so I sure can help and solve the task