Discussion

profiledwilliams1911
m6_Income_Statement_Bal_Sht_3_Year2.xlsx
Home>Business & Finance homework help>Accounting homework help>Discussion

Income Statement

Company Name: Income Statement Income Statement Instructions: Enter estimates into the "Green Cells Only". Make sure that you have thoroughly researched your potential market to ensure that your revenue and expense estimates can be explained thoroughly to an investor or banker. Hence, you must calculate your revenues on specific variables such as the percentage of your company's market penetration and the number of customers your company will attract during the period. The estimated number of customers per period is multiplied by the selling price of your products or services to attain your estimated revenue for the period. Hence, you must validate your revenue estimates and your expense estimates. You should have quotes for any expense items your company will incur such as rent, electric, water, sewer, and especially inventory you plan to purchase. In conclusion, your estimates are only as accurate as the time and effort you put into gathering the real-world data!
Revenue Year 1 Year 2 Year 3
Gross Sales
Less: Sales Returns and Allowances
Net Sales 0 0 0
Cost of Goods Sold
Beginning Inventory
Add: Purchases
Inventory Available 0 0 0
Less: Ending Inventory
Cost of Goods Sold 0 0 0
Gross Profit (Loss) 0 0 0
Expenses
Advertising
Amortization
Bad Debts
Bank Charges
Charitable Contributions
Commissions
Contract Labor
Depreciation
Dues and Subscriptions
Employee Benefit Programs
Insurance
Interest
Legal and Professional Fees
Licenses and Fees
Miscellaneous
Office Expense
Payroll Taxes
Postage
Rent
Repairs and Maintenance
Supplies
Telephone
Travel
Utilities
Vehicle Expenses
Wages
Total Expenses 0 0 0
Net Operating Income 0 0 0
Other Income
Gain (Loss) on Sale of Assets
Interest Income
Total Other Income 0 0 0
Net Income (Loss) 0 0 0

Balance Sheet

Company Name: Balance Sheet Balance Sheet Instructions: Enter data into the "Green Cells Only". A Balance Sheet is a snapshot of your company at one time in history. Thus, it's important that you determine and then input the value of your company's assets and liabilities at the beginning and end of each accounting period. Hence, a Balance Sheet must be created at the beginning of the company's accounting period and at the end of the company's accounting period. The beginning and ending Balance Sheets illustrate the asset and liability changes that have occurred during the accounting period. Essentially, the basic formula for Owner's Equity is the formula Assets - Liabilities = Owner's Equity. Hence, make sure to thoroughly analyze and input all Current and Long-term Assets in addition to all Current and Long-term Liabilities. Lastly, remember to depreciate all long-term assets during each accounting period. Remember that depreciation goes on the Income Statement and Balance Sheet but not on the Cash Flow Statement.
***Input Green Cells Only***
Assets Year 1 Year 2 Year 3
Current Assets:
Cash 0 0 0
Investments 0 0 0
Inventories 0 0 0
Accounts receivable 0 0 0
Pre-paid expenses 0 0 0
Other 0 0 0
Total Current Assets 0 0 0
Fixed Assets: Year 1 Year 2 Year 3
Property and equipment 0 0 0
Leasehold improvements 0 0 0
Equity and other investments 0 0 0
Less accumulated depreciation 0 0 0
Total Fixed Assets 0 0 0
Other Assets: Year 1 Year 2 Year 3
Goodwill 0 0 0
Total Other Assets 0 0 0
Total Assets 0 0 0
Liabilities and Owner's Equity
Current liabilities: Year 1 Year 2 Year 3
Accounts payable 0 0 0
Accrued wages 0 0 0
Accrued compensation 0 0 0
Income taxes payable 0 0 0
Unearned revenue 0 0 0
Other 0 0 0
Total Current Liabilities 0 0 0
Long-term Liabilities: Year 1 Year 2 Year 3
Mortgage payable 0 0 0
Total Long-term Liabilities 0 0 0
Owner's Equity: Year 1 Year 2 Year 3
Investment capital 0 0 0
Accumulated retained earnings 0 0 0
Total Owner's Equity 0 0 0
Total Liabilities and Owner's Equity 0 0 0

Sources and Uses

Company Name: Sources and Uses of Funds at Start-up Start-up Cash Requirements Sources and uses Instructions: Enter data into the "Green Cells Only". The Sources and Uses of Funds represents the total of all cash required to start your company in addition to where and how these funds will be attained. You may change the row names to better match your company's needs. Make sure that the Total Uses of Funds is equil to the Total Sources of Funds. A key consideration in the Sourses and Uses of Funds is the calculation of Working Capital. Working Capital represents the "Actual Cash" you will need to sustain your company until there are enouge revenues to cover all costs. Hence, it's critical to have a realistic estimate of Working Capital to ensure that your Cash Flow Statement remaines positive.
Uses of Funds:
Land
Building
Equipment
Inventory
Improvements
Deposits
Working Capital
Additional Expansion Growth
Total Uses of Funds 0
Sources of Funds
Owner’s Equity
Personal Loan
Business Loan
Other Sources
Total Sources of Funds 0
Working Capital is your operating Expenses for 12 months (Rent, electric, water, internet, loan pmt., ect…). Also, note that the Total Uses of Funds must equal the Total Sources of Funds.

Cash Flow Statement

Twelve-month Cash Flow Statement Enter Company Name Here Fiscal Year Begins: Jan-12 Notes on Cash Flow Statement Preparation Note: You may want to print this information to use as reference later. Refer back to your Income Statement Projections. Line-by-line ask yourself when you should expect the cash to come and go into your company's bank account. You have already done a sales projection, now you must predict when you will actually collect from customers. On the expense side, you have previously projected expenses; now predict when you will actually have to write the check to pay those bills. Most items will be the same as on the Profit & Loss Projection. Rent and utility bills, for instance, are usually paid in the month they are incurred. Other items will differ from the Income Statement view. Insurance and some types of taxes, for example, may actually be payable quarterly or semiannually, even though you recognize them as monthly expenses. Make every effort to make the Cash Flow as realistic as you can line by line. The payoff for you will be an ability to manage and forecast working capital needs. Change the category labels in the left column as needed to fit your accounting system. Note that lines for 'Loan principal payment' through 'Owners' Withdrawal' are for items that always are different on the Cash Flow than on the Income Statement. An Income Statement, also known as a Profit & Loss Stetement, demonstrates how much money your company makes for Income Tax Purposes. The Income Ststement does not show you actual cash flow. Hence, Loan Principal Payments, Capital Purchases, and Owner's Draw simply do not, by the rules of accounting, show up on the Income Statement. They do, however, definitely take cash out of the business, and so need to be included in your Cash plan. On the other hand, you will not find Depreciation on the Cash Flow because you never write a check for Depreciation. Cash from Loans Received and Owners' Injections go in the "Loan: Other cash injections" row. The "Pre-Startup" column is for cash outlays prior to the time covered by the Cash Flow. It is intended primarily for new business startups or major expansion projects where a great deal of cash must go out before operations commence. Begin with the amount of Cash on Hand you expect to have. Project all the Receipts and Paid Outs for the year. If CASH POSITION gets dangerously low or negative, you will need to pump in more cash to keep the operation afloat. Many profitable businesses have gone under because they could not pay the bills while waiting for money to flow in. Your creditors do not care about profit; they want to be paid with cash. Cash is the financial lifeblood of your business.
Pre-Startup EST Jan-12 Feb-12 Mar-12 Apr-12 May-12 Jun-12 Jul-12 Aug-12 Sep-12 Oct-12 Nov-12 Dec-12 Row Totals
Beginning Cash on Hand 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CASH RECEIPTS
Cash Sales 0 0 0 0 0 0 0 0 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 CASH RECEIPTS 0
: Totals are calculated automatically.		 0 0 0 0 0 0 0 0 0 0 0 0 0
Total Cash Available 0 0 0 0 0 0 0 0 0 0 0 0 0 0
CASH PAID OUT
Purchases (merchandise) 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
Purchases (specify) 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Gross wages (Withdrawals) 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Payroll expenses (taxes, etc.) 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0
Repairs & maintenance 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Advertising 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Car, delivery & travel 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Accounting & legal 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Rent 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Telephone 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Utilities 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Insurance 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Taxes (real estate, etc.) 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Interest 0 0 0 0 0 0 0 0 0 0 0 0 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 0 0 0 0 0 0 0 0 0 0 0 0 0
SUBTOTAL 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Loan principal payment 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Capital purchase (specify) 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Other startup costs 0 0 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 0
Owners' Withdrawal 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

Variables

_Example FALSE
_Shading FALSE
_Series OfficeReady 3.0
_Look 1