Phoenix Associates Land Syndicate (fka PBLSQ)

[Just_Play_It_58]

Any advice

on mapping the 2005 Statement of Operations onto my spreadsheet? The statement simply lists:

Revenue..................................165,971,862
Costs and Expenses
Operation Costs.....................156,771,118
General and Administrative.......2,735,642
Total Costs and Expenses......159,506,760

EBITDA......................................6,465,102

I think the EBITDA figure of $6,465,102 should go where I put it, but any suggestions are welcome. I’ve used the Operating Profit or (Loss) and Revenues to create an Operating Margin figure which shows a nice steady increase. I know the 2005 and 2006 figures are for an entire year, but if I divided the numerator and denominator, used to create the Operating Margin figure, both by 4; I’d end up with the same ratio and Operating Margin figure for each of four quarters in both years. Probably not completely accurate, but it’s a valid estimation.



The bottom third of the spreadsheet shows a percentage change of each parameter from Q1 to Q2 of 2007. Please note:

Revenues went up...................14.95%, while
Cost of goods went up only...12.69%, causing
Gross Profit to go up..............29.70%.

Phoenix is producing more at a lower cost. I expect margins will continue to increase.