Need an EXPERT at Google Sheets Formulas -- 2

$30-250 USD

In Progress

Posted

about 3 years ago

$30-250 USD

Paid on delivery

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.

Project ID: 28960806

About the project

12 proposals

Remote project

Active 3 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@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 on this excel project. Assign the task to me for optimum and satisfactory delivery. Thank you.

$120 USD in 1 day

4.3

(2 reviews)

1.8

12 freelancers are bidding on average $171 USD for this job

@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 project Google Sheets to create a formula to make it automated. However, there are few questions that concern me regarding your job details, such as : - How long is the estimated time duration to complete the project ? - Do you have sample I probably could refer in order to meet your requirements ? Thank you for reviewing my proposal and looking forward to your positive feedback. Regards, Mohd Redzuan Data Analyst

$200 USD in 5 days

5.0

(5 reviews)

2.8

@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 your earnings. Also I'll create a graph for you to get you earnings value on the graph with the time period. I can create this table easily. I am looking forward to have a discussion on it with you. Regards Parveen Kumar

$30 USD in 1 day

5.0

(2 reviews)

1.3

@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 in 2 days

4.2

(1 review)

0.9

@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 in 1 day

5.0

(2 reviews)

0.8

@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 this site I am eager to do a great job for you to start building my reputation. Feel free to chat if you have any questions Cheers Derek

$100 USD in 1 day

5.0

(1 review)

0.6

@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 in 7 days

0.0

(0 reviews)

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 consider my experts very much capable of doing it. I have been a virtual assistant for over 4 years, working on a vast variety of challenging projects. And I have provided a great service to every client with splendid work and 100% satisfaction. I do not lie sluggishly to make a false assumption of work rather I would never accept a job proposal until I'm confident of making it successful with perfection and satisfaction. If you choose me you are getting top-notch expertise and someone who will complete your job accurately the first time. Let's jump on an initial 10-minute chat or call so we can discuss your project in more detail and ensure my skill set is a great fit. Just let me know what time works best. Regards, Muhammad Ramzan K

$230 USD in 1 day

0.0

(0 reviews)

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), so you don't need to worry. feel free to contact me....

$278 USD in 3 days

0.0

(0 reviews)

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 am searching my first award in freelancing site so there is no chance to make any kind of mistake in this project. I will give you better than best. After finished this project please rate me good for my future job let me know when we can start Thank you and looking positive responses from you.

$40 USD in 1 day

0.0

(0 reviews)

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 in 3 days