Discussion

dwilliams1911

Copyof_SourcesandUsesofFundsStatement11-2.xlsx

Home >Business & Finance homework help >Discussion

Income Statement

Dave and Jacky Delicious: 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	1332500	1386200	1442064
Less: Sales Returns and Allowances	66625	69310	72103
Net Sales	1265875	1316890	1369961
Cost of Goods Sold
Beginning Inventory	0	0	0
Add: Purchases	0	0	0
Inventory Available	0	0	0
Less: Ending Inventory	0
Cost of Goods Sold	562500	582271.88	602738.73
Gross Profit (Loss)	703375	734618.1	767222.07
Expenses
Advertising	5200	5200	5200
Amortization	0	0	0
Bad Debts	33313	34655	36052
Bank Charges	0	0	0
Charitable Contributions	126588	131689	136996
Commissions	0	0	0
Contract Labor	0	0	0
Depreciation	0	0	0
Dues and Subscriptions	0	0	0
Employee Benefit Programs	0	0	0
Insurance	2000	2000	2000
Interest	586	586	586
Legal and Professional Fees	19500	19500	19500
Licenses and Fees	1000	1000	1000
Miscellaneous	36000	36000	36000
Office Expense	31500	31500	31500
Payroll Taxes	36000	36000	36000
Postage	0	0	0
Rent	60000	60000	60000
Repairs and Maintenance	62000	60000	60000
Supplies	0	0	0
Telephone	11000	12000	12000
Travel	11000	12000	12000
Utilities	60000	60000	60000
Vehicle Expenses	10000	12000	12000
Wages	120000	120000	120000
Total Expenses	625686	634130	640834
Net Operating Income	77689	100488	126388
Other Income
Gain (Loss) on Sale of Assets	0	0	0
Interest Income	0	0	0
Total Other Income	0	0	0
Net Income (Loss)	77689	100488	126388

Balance Sheet

Company Name: Dave and Jacky Delicious				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
Bank Loan	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

Dave and Jacky Delicious: 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	5,000
Equipment + packaging + supplies + long term assets	72,500
Inventory	22,000
Improvements	2,000
Deposits	15,000
Working Capital	18,500
Additional Expansion Growth	0
Total Uses of Funds	135,000
Sources of Funds
Owner’s Equity	80,000
Personal Loan
Business Loan	35,000
Other Sources	20,000
Total Sources of Funds	135,000
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						Dave and Jacky Delicious							Fiscal Year Begins:	Sep-20	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	Sep-20	Oct-20	Nov-20	Dec-20	Jan-21	Feb-21	Mar-21	Apr-21	May-21	Jun-21	Jul-21	Aug-21	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
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 (packaging)	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Purchases (equipment+other equipment)	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 (Business sign)	0	0	0	0	0	0	0	0	0	0	0	0	0	0
Other (permits)	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

Break even and Ratios

Break Even Analysis
Monthly break even units	0
Monthly revenue break even	0
Assumptions
Average per unit revenue	$ - 0
Average per unit variable cost	$ - 0
Estimated monthly fixed cost	$ - 0
Ratio Analysis	Year 1	Year 2	Year 3
Profitability Ratios:
Net Income	0.00%	0.00%	0.00%
Return on Assets	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Liquidity Ratio:
Current ratio	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Working capital	0	0	0
Quick ratio	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Solvency Ratio:
Debt to Asset Ratio	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Debt to Equity Ratio	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Efficiency Ratios:
Accounts receivable turnover	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Inventory turnover	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Number of days inventory in stock	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Fixed asset turnover	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!
Total asset turnover	ERROR:#DIV/0!	ERROR:#DIV/0!	ERROR:#DIV/0!

Compatibility Report

	Compatibility Report for m6_Income_Statement_Bal_Sht_3_Year2.xls
	Run on 6/5/2020 13:29
	The following features in this workbook are not supported by earlier versions of Excel. These features may be lost or degraded when you save this workbook in an earlier file format.
	Minor loss of fidelity			# of occurrences
	Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available.			50