Budget and Profit and Loss Statement

profilejaysus21
BudgetFormat.xlsx
Home>Business & Finance homework help>Operations Management homework help>Budget and Profit and Loss Statement

Sheet1

Fees Revenue Profit Assets
Category Volume Saturday Volume Sunday Week end total Monthly Total Yearly total Upfront Costs Monthly est cost Yearly cost Land (acres) 346 $ 2,700.00
Gray, Dusty: Gray, Dusty: average price per acre when checking land prices on 8 different tracts of land in copiajh county with over 100 acres each. 		$ 934,200.00
Atv / day $ 20.00 Business $ 1,000,000.00 $ (10,606.55)
Gray, Dusty: Gray, Dusty: used 10 year term @ 5%		 $ (127,278.60) House 2600 $ 50.00 $ 130,000.00
Passenger / day $ 10.00 Payroll $ (2,400.00)
Gray, Dusty: Gray, Dusty: used 2 people x 10 hrs for 2 days @ $15.00 hr x 4 weekends 		$ (15,600.00) Bull dozer
Camper with hookups / night (2 adults) $ 25.00 General store $ (300.00)
Gray, Dusty: Gray, Dusty: $300.00 in supplies per weekend x %100 percent markup		 $ (7,800.00) Track hoe
Camper no hook ups / night $ 10.00 T-shirts $ (100.00) $ (600.00) Back Hoe
tent camping / night $ 10.00 Utilities $ (500.00) $ (6,000.00) Dump truck
additional person / night $ 10.00 Legal fees (est) $ 10,000.00 Water truck
Cabin (estimated cost) $ 100.00 Fuel for equip $ (400.00) $ (3,200.00) Timber (Acres) 200 $ 1,200.00 $ 240,000.00
Tshirt $ 15.00 supplies
Gray, Dusty: Gray, Dusty: wristbands waiver forms pens etc...		 $ (400.00) $ (3,600.00) Mineral rights
Septic
Trash disposal total $ 1,304,200.00
# of camp sites (25 avail) 25
Gray, Dusty: Gray, Dusty: Friday night 		$ 625.00 25
Gray, Dusty: Gray, Dusty: Saturday night
Gray, Dusty: Gray, Dusty: used 10 year term @ 5%
Gray, Dusty: Gray, Dusty: used 2 people x 10 hrs for 2 days @ $15.00 hr x 4 weekends
Gray, Dusty: Gray, Dusty: $300.00 in supplies per weekend x %100 percent markup
Gray, Dusty: Gray, Dusty: wristbands waiver forms pens etc...
Gray, Dusty: Gray, Dusty: average price per acre when checking land prices on 8 different tracts of land in copiajh county with over 100 acres each.
Gray, Dusty: Gray, Dusty: Friday night 		$ 625.00 $ 1,250.00 $ 5,000.00 $ 32,500.00
Cabin 1 $ 100.00 1 $ 100.00 $ 200.00 $ 800.00 $ 5,200.00
ATV's / day 500 $ 10,000.00 100 $ 2,000.00 $ 12,000.00 $ 48,000.00 $ 312,000.00 1950000 -20682.77
Weeks operating / year 26 $ - 0 1000000 -10606.55
Passengers/ day 500 $ 5,000.00 50 $ 500.00 $ 5,500.00 $ 22,000.00 $ 143,000.00
T shirt sales (1 per 20 people) $ 750.00 $ 112.50 $ 862.50 $ 3,450.00 $ 22,425.00
General store $ 300.00 $ 300.00 $ 600.00 $ 2,400.00 $ 15,600.00
Total $ 16,775.00 $ 3,637.50 $ 20,412.50 $ 81,650.00 $ 530,725.00 $ (14,706.55) $ (154,078.60) $ 376,646.40
$ 51,031.24 $ 331,703.06
$ 177,624.46 projections based on 100-75-50-25%

Balance Sheet

Balance Sheet
2/28/17
Current Assets
Cash $ 4,200.00
Investments $ - 0 $ - 0
Inventories $ 400.00
Accounts receivable $ - 0 $ - 0
Pre-paid expenses $ - 0 $ - 0
Other $ - 0 $ - 0
Total $ 4,600.00 $ - 0
Fixed Assets
Property and equipment $ 1,115,000.00
Equity and other investments $ - 0 $ - 0
Less accumulated depreciation (Negative Value) $ - 0 $ - 0
Total $ 1,115,000.00 $ - 0
Other Assets
Charity $ - 0
Total $ - 0 $ - 0
Total Assets $ 1,119,600.00 $ - 0
Current Liabilities
Accounts payable $ 5,400.00
Accrued wages $ - 0 $ - 0
Accrued compensation $ - 0 $ - 0
Income taxes payable $ - 0 $ - 0
Unearned revenue $ - 0 $ - 0
Other $ - 0 $ - 0
Total $ 5,400.00
Long-term Liabilities
Mortgage payable $ 1,100,000.00
Total $ 1,100,000.00 $ - 0
Owner Equity
Investment capital $ - 0 $ - 0
Accumulated retained earnings $ 14,200.00
Total $ 14,200.00 $ - 0
Total Liabilities & Stockholder Equity $ 1,119,600.00 $ - 0

Cash Flow Forecast

Cash Flow Statement
Fiscal year begins: (Pre) Startup JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Total
1/5/17 EST 1/5/17 2/5/17 3/5/17 4/5/17 5/5/17 6/5/17 7/5/17 8/5/17 9/5/17 10/5/17 11/5/17 12/5/17 Item EST
Cash on Hand (beginning of month) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
$ - 0
Cash Receipts
Cash Sales $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Collections fm CR accounts $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Loan/ other cash inj. $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Cash Available (before cash out) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cash Paid Out
Purchases (merchandise) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Purchases (specify) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Purchases (specify) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Gross wages (exact withdrawal) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Payroll expenses (taxes, etc.) $ - 0 $ - 0 $ - 0
dusty:
dusty: 		$ - 0 $ - 0 $ - 0
Outside services $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Supplies (office & oper.) $ - 0 $ - 0 $ - 0
dusty: dusty: Waivers and armbands		 $ - 0 $ - 0 $ - 0
Repairs & maintenance $ - 0 $ - 0
Advertising $ - 0 $ - 0
Car, delivery & travel $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Accounting & legal $ - 0 $ - 0
Rent $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Telephone $ - 0 $ - 0
Utilities $ - 0 $ - 0
Insurance $ - 0 $ - 0
Taxes (real estate, etc.) $ - 0 $ - 0
Interest $ - 0 $ - 0
Other expenses (specify) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other (specify) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other (specify) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Miscellaneous $ - 0
Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cash Paid Out (Non P&L)
Loan principal payment $ - 0
Capital purchase (specify)
dusty: 		$ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Other startup costs
dusty:
dusty: dusty: Used trac hoe		 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Reserve and/or escrow $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Owners' withdrawal $ - 0
Total $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Total Cash Paid Out $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Cash Position (end of month) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Income statement

Income Statement
Financial Statements in U.S. Dollars
Revenue
Gross Sales
Less: Sales Returns and Allowances $ - 0
Net Sales $ - 0
Cost of Goods Sold
Beginning Inventory (merchandise)
Inventory Available $ - 0
Less: Ending Inventory $ - 0
Cost of Goods Sold $ - 0
Gross Profit (Loss) $ - 0
Expenses
Gross wages (exact withdrawal)
Payroll expenses (taxes, etc.)

dusty: 		Supplies (office & oper.)

dusty: Description or Assumptions		 Repairs & maintenance
Advertising
Accounting & legal
Telephone
Utilities
Insurance
Taxes (real estate, etc.)
Interest
Other expenses (Misc.)
Loan principal payment
Capital purchase (specify) $ - 0
Other startup costs $ - 0
Owners' withdrawal
Total Expenses $ - 0
Net Operating Income $ - 0
Other Income
Gain (Loss) on Sale of Assets $ - 0
Interest Income $ - 0
Total Other Income $ - 0
Net Income (Loss) $ - 0

Ratios

Profit Margin = Net Income / Net Sales
Profit Margin =
ROE = Net Income / Total Shareholders Equity
ROE =