Whoops - pesky misplaced colon in Excel. Typically, I've been on the other end of a microphone, not the business end. Fixed it tho. Thanks for the catch.
Total cost to buy Annual Cost @ 20 yrs Monthly Note to Bank
$14,000,000.00 $700,000.00 $58,333.33
Monthly Expenses
Monthly Loan Payment ($58,333.33)
Rent @ $5.00/sf ($25,000.00)
Office Utilities ($1,000.00)
Office Supplies ($500.00)
Music Licensing ($2,000.00)
Tower Lease ($5,000.00)
Contract Engineer ($1,000.00)
Total Monthly Expenses ($92,833.33)
Salaries Monthly
General Manager Salary ($50k annual) ($4,166.67)
Morning Drive Host ($40k annual) ($3,333.33)
FT Air Personality ($30k annual) ($2,500.00)
FT Air Personality ($30k annual) ($2,500.00)
FT Air Personality ($30k annual) ($2,500.00)
PT Air Personality ($20k annual) ($1,666.67)
PT Air Personality ($20k annual) ($1,666.67)
Total Salaries/Monthly ($18,333.33)
Benefits ($4,583.33)
Total Monthly Payroll ($22,916.67)
Total Overall Monthly Expenses (115,750.00)
Total Annual Expenses (1,389,000.00)
Total Revenue 863,700.00
Annual Total Revenue Generated (525,300.00)
Total cost to buy Annual Cost @ 20 yrs Monthly Note to Bank
$14,000,000.00 $700,000.00 $58,333.33
Monthly Expenses
Monthly Loan Payment ($58,333.33)
Rent @ $5.00/sf ($25,000.00)
Office Utilities ($1,000.00)
Office Supplies ($500.00)
Music Licensing ($2,000.00)
Tower Lease ($5,000.00)
Contract Engineer ($1,000.00)
Total Monthly Expenses ($92,833.33)
Salaries Monthly
General Manager Salary ($50k annual) ($4,166.67)
Morning Drive Host ($40k annual) ($3,333.33)
FT Air Personality ($30k annual) ($2,500.00)
FT Air Personality ($30k annual) ($2,500.00)
FT Air Personality ($30k annual) ($2,500.00)
PT Air Personality ($20k annual) ($1,666.67)
PT Air Personality ($20k annual) ($1,666.67)
Total Salaries/Monthly ($18,333.33)
Benefits ($4,583.33)
Total Monthly Payroll ($22,916.67)
Total Overall Monthly Expenses (115,750.00)
Total Annual Expenses (1,389,000.00)
Total Revenue 863,700.00
Annual Total Revenue Generated (525,300.00)
TRF said:Except that your math is wrong, as $92,833.33 + $22,916.67 != $226,916.67, unless there's some magic number missing.haverhill01835 said:Yea, the numbers are low. If I did a little more leg work and dug numbers for salaries, rent/lease etc., it would be far worse (and further make my point).
No argument there.It just doesn't make sense, especially on a Boston-based stick.