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.
I need you to create a formula (you may need to create a table 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 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 B187 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.
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.
8 pekerja bebas membida secara purata $37 untuk pekerjaan ini
Understanding of Microsoft excel and how to use it effectively with use of formulae Also have good knowledge on MS Word, Power Point, Internet browsing & E-mailing.
Hi dear We have a team of Designer, Marketeer and Accountants This task is done by the CA finalist who work in Finance and deal google sheets on daily basis You can Inbox me so we discuss further Thanks