Interactive Income Statement and Balance Sheet

Document Sample
Interactive Income Statement and Balance Sheet Powered By Docstoc
					Interactive Income Statement and Balance Sheet
Contents 1.1 Assumptions Goto A10 2.1 Income Statement Goto A33 2.2 Balance Sheet Goto A81 3.1 Instructions Goto A131 Assumptions (continued at A22) Sheet 1.1 ---------- ---------- ---------- ------ ---------- ---------- ---------- ---------- ---------Interest (income) Rate: Earned on Cash Balance over: Interest (expense) Rate: Cost of Goods Sold: Payroll Taxes: Income Tax Rate: 0.18 $5,000 18% of Long Term Debt 75% of Sales 10% of Salaries and Wages 25%

Assumptions (continued) Sheet 1.2 --------------- --------------- --------------- ---------- --------------- --------------- --------------- --------------- --------------Depreciable Life of Assets: Beginning Accumulated Depreciation: Days Sales in Receivables: Days Cost of Goods Sold in Inventory: Days Cost of Goods Sold in Payables: Beginning Retained Earnings: 60 $5,000 45 30 45 $4,200 Months Days Days Days

Income Statement (continues to row 76) Sheet 2.1 --------------- --------------- --------------- ---------- --------------- --------------- --------------- --------------- --------------Qtr 1 Qtr 2 Qtr 3 Qtr 4 Total ------------------------------Gross Income Product Sales 50,000 55,000 60,000 70,000 235,000 Income from Service 25,000 32,000 35,000 40,000 132,000 Other Sales 1,500 1,500 1,500 1,500 6,000 Other (Interest Income) 0 0 0 0 0 ------------------------------Total Gross Income 76,500 88,500 96,500 111,500 373,000 Cost of Goods Sold Gross Margin Operating Expenses Salaries and Wages Benefits Health Insurance Payroll Taxes Office Rent Supplies Postage Telephone Insurance Dues and Subscriptions 37,500 ------39,000 41,250 ------47,250 45,000 ------51,500 52,500 ------59,000 176,250 ----
				
DOCUMENT INFO
Description: Interactive Income Statement and Balance Sheet is a Microsoft Excel model that can be downloaded immediately and used by putting your numbers in the appropriate cells. Calculations are automatic. Can be customized to fit your needs.|n||n|Cl
BUY THIS DOCUMENT NOW PRICE: $24.95 100% MONEY BACK GUARANTEED
PARTNER SmallBusinessForum
With access to close to 10,000 small business owners we are able to draw upon their collective wisdom and insights to develop new products to solve their most pressing needs. We also have a Consultant Advisory Board which consists of some of the leading consultants in the industry. We use this group as a sounding board to discuss current issues, challenges and product development ideas.