M
mitchellqwerty
Hi Guys/Girl
I am trying to assign %'s for a Property Holding Cost. I canno
formulate the correct IF statements to correctly calculate th
below-mentioned equation (See attached document)
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 % assignmen
10% 10% 10% 10% 10% 10% 10% 10% 10% 10% Spread Cost % assignmen
The cost needs to be paid quarterly, i.e. month cost % 1,2&3 are totale
in Month 3(i.e. 30%). When the property is sold, the remaining 10t
month holding cost is totaled to finalize the Sale (i.e. 10%)
Example: Holding Cost is $12,000, paid quarterly, the Property is sol
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 sol
Remaining 10%($1,200)
See attached Excel: Row 17 is highlighted in yellow, the correc
equation must be able to be filled across
I seem to be able to get it, then I change the month and it exposes th
formula. If you could change the holding Month Period to make sure i
works, I would be most appreciative.
Thanks to anyone that can help me her
Kind Regards
Mitchel
+-------------------------------------------------------------------
|Filename: Quarterly Payments-Excel Forum.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=697
+-------------------------------------------------------------------
I am trying to assign %'s for a Property Holding Cost. I canno
formulate the correct IF statements to correctly calculate th
below-mentioned equation (See attached document)
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 % assignmen
10% 10% 10% 10% 10% 10% 10% 10% 10% 10% Spread Cost % assignmen
The cost needs to be paid quarterly, i.e. month cost % 1,2&3 are totale
in Month 3(i.e. 30%). When the property is sold, the remaining 10t
month holding cost is totaled to finalize the Sale (i.e. 10%)
Example: Holding Cost is $12,000, paid quarterly, the Property is sol
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 sol
Remaining 10%($1,200)
See attached Excel: Row 17 is highlighted in yellow, the correc
equation must be able to be filled across
I seem to be able to get it, then I change the month and it exposes th
formula. If you could change the holding Month Period to make sure i
works, I would be most appreciative.
Thanks to anyone that can help me her
Kind Regards
Mitchel
+-------------------------------------------------------------------
|Filename: Quarterly Payments-Excel Forum.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=697
+-------------------------------------------------------------------