MAVERICK LODGE
CASH FLOW 2002
INPUT SECTION
Loan amount from SBA $100,000
Interest rate for SBA 6.50% annual
Payback period for SBA 10 years
Loan amount from bank $200,000
Interest rate for bank loan 7.25% annual
Payback period for bank loan 15 years
Daily room rate $45.00 per day
No. of rooms 17
Maintenance exp. $1,000 if expected occupancy under 45%
Maintenance exp. $2,000 otherwise
House cleaning $3 each time the room is cleaned
Fixed Telephone exp. $75
Variable Telephone exp. 1% of revenue
Property tax rate 4% of property value paid half in June and half in December
Property value $275,000
Fixed water + sewage exp. $50
Var. water + sewage exp. 1.50% of revenue
Insurance $300 per month
Mkting exp. $400 if expected occupancy under 40%
Mkting exp. $700 otherwise
Owner's salary $3,000 per month
Beginning cash on-hand $2,500
The electricity data given to you goes here.
You decide what labels to use. Delete these
sentences and type your data.
JAN FEB MAR APR MAY JUNE JUL
Occupancy rate 0.75 0.45 0.75 0.35 0.35 0.4 0.65
No. of days in the month 31 28 31 30 31 30 31
CALCULATION SECTION
Electricity usage
YEAR 2002 CASH FLOW PROJECTIONS FOR MAVERICK LODGE
JAN FEB MAR APR MAY JUNE JUL
Revenue
Payments
Maintenance
House cleaning
Telephone
Marketing
Electricity
Water + sewage
Insurance
Mortgage
Property tax
Owner's salary
Total payments
Beginning cash
Revenue-Payments
Ending cash
AUG SEP OCT NOV DEC
0.65 type the data for the remaining months from the assignment sheet.
31
AUG SEP OCT NOV DEC