If Statement - Calculating quarterly payments %

Quarterly Cost Payments % - Take2

Hi Guys/Girls
I Have made my questions and xls. document attached more concise:

Question:
I am trying to assign %'s for a Property Holding Cost. I cannot formulate the correct IF statements to correctly calculate the below-mentioned equation.

1 2 3 4 5 6 7 8 9 10 Time Period (Months)
10% 20% 30% 40% 50% 60% 70% 80% 90% 100% Cumulative Cost % assignment
10% 10% 10% 10% 10% 10% 10% 10% 10% 10% Spread Cost % assignment

The cost needs to be paid quarterly, i.e. month cost % 1,2&3 are totaled in Month 3. When the property is sold, the remaining 10th month holding cost %(ie.) 1 Month (10%) is totaled to finalize the Sale.

Example: Holding Cost is $12,000, paid quarterly, the Property is sold at the end of the 10th Month.

i.e. Time Period 1-0%($0), 2-0%($0), 3-30%($3,600), 4-0%($0), 5-0%($0), 6-30%($3,600), 7-0%($0), 8-0%($0), 9-30%($3,600), 10 -Property is sold Remaining 10%($1,200).

See attached Excel: Row 17 is highlighted in yellow, the correct equation must be able to be filled across.

Thanks to anyone that can help me here

Kind Regards,

Mitchell

I am really stuck here, is there anyone that can help? I would greatly appreciate it

Warm Regards,
Mitchell