Excel issue

Hussein_Elsayed1605 

You have not provided sufficient details for an intelligent solution.

Re: ``after deduct the down payment Ex) Total amount 1,000,000 [....] i have to put amount on jan``

Is 1,000,000 the amount before or after the down payment?

Is the "amount on jan" the down payment?

Usually, the down payment is irrelevant.

Re:  ``skip feb and march and put the second amount in april Etc``

Without limits, one solution is to "put" $1 in April, $1 in July, $1 in Oct etc for nearly 1 million quarters.

Ridiculous, I know.  The point is:  without some constrains or additional information, there are infinite solutions.

What do the amount 1,000,000 and "down payment" represent?  Why are you making payments every quarter?  For example, is this a loan?  Is it an asset value that you are depreciating?  Over what period of time do you want to decrease the amount?  Is there "interest" involved?  Etc, etc, etc.

If this is a loan, please specify:  the amount of the loan (1,000,000?), the rate of interest (preferrably quarterly; otherwise annually); the number of quarters over which to amortize the loan (i.e. pay interest and decrease the principal).  And how should we determine the amount paid in Jan?  Is that even relevant, if the loan amount is $1,000,000?