Calculate NPV for non regular date & amount

JoeUser2004 

First of all i would like to thank you for your quick reply, and let me to reply to the below points.

1. Do you want to use a monthly cash flow model, as you do in your example Excel file?

yes i need to use the monthly senario as there are irrigular dates in my attachment

Or do you want to use the more consise cash flow model that you presented in your original posting?

i just sent it to clarify the idea but the second attachement is what we are working with in my work and i think it has alot of mistakes that i dont understand it so i ask for the right way to calculate what the client can get when he pay a lage amount at the begining in accurat way

2. How did you determine the annual interest rate (B5)?

the annual rate are given as per the policy of my company

It is different from the NPV discount rate (8%) in your original posting?

yes

3. For the original payment schedule (C8:C115), how did you determine the last payment in C105 (200,438), which differs from the other equal payments (200,411) starting in C15?

calculated, to be equal with the total amount in C2

4. How did you determine the value in C2 (6,903,074)?  And what purpose does it serve, if any?

According to the pricing list of units that we have in our company

It is close to, but not equal to the sum of the cash flows (C116) for the first option.