Käynnissä

Need an EXPERT at Google Sheets Formulas -- 2

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.

Taidot: Kirjanpito, Excel, Tilastotiede, Matematiikka

Näytä lisää: need expert english, need programmer for google sheets, NEED EXPERT WRITERS -- 2, google sheets formulas sum, google sheets formulas if, where's google sheets, hire google sheets expert, google sheets today's date shortcut, google sheets formulas, google sheets formulas subtraction, google sheets formulas multiply, how to use google sheets formulas, google sheets formulas tutorial, zapier google sheets formulas, google sheets formulas percentage, google sheets formulas cheat sheet, google sheets formulas not working, google sheets formulas pdf, google sheets formulas average, useful google sheets formulas

Tietoa työnantajasta:
( 10 arvostelua ) Grandville, United States

Projektin tunnus: #28960806

Myönnetty käyttäjälle:

ajmalcomsian123

Hi, I am a professional Finance and accounts manager, having 13 year experience in bookkeeping, accounting and financial analysis, financial reports, results, P&L, balance sheet, cash flow, valuations. I can help you o Lisää

$120 USD 1 päivässä
(1 arvostelu)
0.0

13 freelanceria on tarjonnut keskimäärin $165 tähän työhön

(181 arvostelua)
6.6
AdelAbuHashim

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!

$100 USD 1 päivässä
(2 arvostelua)
0.8
MuhdNasuha

Hi my name is Muhd Nasuha from Malaysia. I am a dedicated employee in performing my duties. With my experience I am confident I can perform the task.

$250 USD 7 päivässä
(0 arvostelua)
0.0
jpot309

Hi, Your job post grabbed my attention instantly. I can provide you with Formula within the next 12 hours. I have a team of experts who can smartly and nicely do this. Kindly, message me to discuss further details. I Lisää

$230 USD 1 päivässä
(0 arvostelua)
0.0
LiAnOr

Hi - I am very much interested in the job. Please forward the sample file so I can check. Thank you very much.

$200 USD 2 päivässä
(0 arvostelua)
0.0
golu2280610

Hii, I am Shivam. I am interested in your workI have got my team to complete your job. My team can do this work with utmost accuracy. My team have good knowledge of ms word, excel and PowerPoint, and accounting (tally) Lisää

$278 USD 3 päivässä
(0 arvostelua)
0.0
pmnakrani

Hello Sir/Madam I am Nakrani Prakash. I am working as accountant assistance since last 8 years. I had read your project briefly. I realized that I can completed because I have good knowledge in excel and MS office. I a Lisää

$40 USD 1 päivässä
(0 arvostelua)
0.0
jeewanusjp

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.

$100 USD 1 päivässä
(0 arvostelua)
0.0
Redhuan

Hi, Greetings. I am the right person for your Project. Experience in Data Management for more than 5 years and have broad knowledge on handing a large datasets. As I concern that you need someone to help on your proj Lisää

$200 USD 5 päivässä
(0 arvostelua)
0.0
Athed03

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

$250 USD 3 päivässä
(0 arvostelua)
0.0
derekmckinnon

I have over twenty years experience in Excel and have built interest calculations before. As a native English speaker (Australian), communication will not be a problem. As I am looking for my first completed job on t Lisää

$100 USD 1 päivässä
(0 arvostelua)
0.0
erparveenkumar

Hi I am expert in using advance formula in Excel/Google sheet. I read your requirement and have understood that you want to manage all the payment details related to the lending money and also want to keep an eye on Lisää

$30 USD 1 päivässä
(0 arvostelua)
0.0