Advanced Excel Formula for Decay

$10-30 CAD

Completed

Posted

almost 8 years ago

$10-30 CAD

Paid on delivery

I am looking for someone to write an excel formula for a 12 month projection of loans. Rules: 1) Every month 30 new loans 2) Loan Terminates after 3 months. 3) Half of new loans from previous month will return and take a secondary loan. Month 1 30A 30 Month 2 30A 15A 30B 75 Month 3 30A 15A 30B 15B 30C 120 Month 4 30A 15A 30B 15B 30C 15C 30D 135 Month 5 30A 15A 30B 15B 30C 15C 30D 15D 30E 135 Month 6 30A 15A 30B 15B 30C 15C 30D 15D 30E 15E 30F 135 Month 7 30A 15A 30B 15B 30C 15C 30D 15D 30E 15E 30F 15F 30G 135 Month 8 ... Month 9 ... Month 10 ... Month 11 ... Month 12 ... Need a formula so we can change the numbers easily in excel.

Excel

Mathematics

Project ID: 10889163

About the project

7 proposals

Remote project

Active 8 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:

@sangwanpankajs

hello sir i can do this task i am very good in excel and maths i have done this type of projects in past with good reviews i will do it in few hours from now so please msg me to discuss thank you hope to hear from you

$29 CAD in 0 day

4.9

(62 reviews)

5.0

7 freelancers are bidding on average $26 CAD for this job

@surekash7096

I have the expertise in Excel and can create this formula in Excel, quickly for you. Ready to start work immediately.

$25 CAD in 1 day

4.5

(64 reviews)

5.2

@globalsollx

We have read your project Requirements and are keen on working on your Project We can send you samples of similar work done in past for your evaluation of our skills. We have in depth knowledge of working in MS OFFICE ( WORD EXCEL POWER POINT) VISIO, Adobe Photoshop Adobe Acrobat Professional , Adobe Flash, Adobe Illustrator , Indesign and Corel Draw We assure you that we will execute the work as per your specifications We will be grateful to you if you could give us the opportunity to work with you on this project Regards, Sudha

$15 CAD in 1 day

3.2

(1 review)

0.6

@MohammadSukkar

dear client I have read and understood your job description. I have high skills in using excel and creating formulas. I am waiting your response to begin work. thank you

$30 CAD in 1 day

0.0

(0 reviews)

0.0

@SanjayGohil007

Hello, I have a Advance Knowledge Of Microsoft Excel. i am work on excel at essar steal and perform excel Related various task. Thank you

$30 CAD in 2 days

0.0

(0 reviews)

0.0

@Sumanta61

I will upload the formula in excel as soon as you give me the job. It will be in an excel workbook employing one sheet. Sumanta

$35 CAD in 1 day

0.0

(0 reviews)

0.0

@arjunmondo

Hi, I am new to freelance but I have three years experience as an analyst. I will not be having any reviews and ratings as I have not received any projects till now. Kindly ping me so that I can send over the excel file where I have worked on the problem you mentioned. PS: You do not need to pay me for this. I just need my first project and a good review. Kindly check. Thank you. Regards, Arjun

$15 CAD in 1 day