Finance help

profileyugigogo09
IssyCakeTemplate.xlsx

Sheet1

Issy Cake
0 Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12 Year 1 Year 2
Income Statement
Revenues:
Sales by Piece
Sales
COGS
Gross Margins
Expenses:
Rent
Wages
Operating Exp
Advertising
Startup Expenses
Total Expenses
Operating Profit
Depreciation
Interest Expense
Net Income before Taxes
Taxes
Net Income
Balance Sheet:
Assets:
Current
Cash
AR
Inventory
Prepaid Expense
Total Current
Long Term
PPE
Less Depreciation
Total Long Term
Total Assets
Liabilities and Owners Equity:
Liabilities:
AP
Loan/Note
Amortization - Princ
Net Loan
Total Liabilities
Owners Equity:
PIC
Retained Earnings
Capital Stock
Total Owners Equity
Total Liabilities and Owners Equity
Cash Flow
Beginning Cash
Net Income(Retained Earnings)
Change in Assets
AR
Inventory
Pre Paid Exp
PPE
Change in Liabilities
AP
Loan/Note
Cash from Financing Equity
Cash from Financing Debt
Ending Cash

Sheet2

Sheet3