acct questions

profilehugh123
ForecastingModel.xlsx

Rent + 15% Growth

SDG Formula Driven
Bubble and Bee Organic - Pro Forma Modeling Template Input Required
Balance Sheet Income Statement
2013 2014 2015 2016 2017 2014 2015 2016 2017
Assets Revenues 1,776,168 - - -
Current Assets Cost of Goods Sold 357,597 - 0 - 0 - 0
Cash 25,567 43,008 169,184 169,184 169,184 Gross Margin 1,418,571 - - -
Receivables 32,375 35,525 - 0 - 0 - 0 Expenses
Inventories 131,250 143,937 - 0 - 0 - 0 Selling 439,512 - 0 - 0 - 0
Total Current Assets 189,192 222,470 169,184 169,184 169,184 General & Administrative Variable 82,514 - 0 - 0 - 0
Fixed Assets General & Administrative Fixed 572,776 - - -
PP&E 395,785 470,185 470,185 470,185 470,185 Depreciation 87,221 - - -
Less Depreciation 120,221 207,442 207,442 207,442 207,442 Total Expenses 1,182,023 - - -
Total Fixed Assets 275,564 262,743 262,743 262,743 262,743 EBIT 236,548 - - -
Net Interest Expense 7,535 - 0 - 0 - 0
Total Assets 464,756 485,213 431,927 431,927 431,927 Taxable Income 229,013 - - -
Taxes - - - -
Liabilities & Shareholder's Equity Net Income 229,013 - - -
Current Liabilities Cash Flow Statement
Accounts Payable 44,625 53,286 - 0 - 0 - 0
Accrued Liabilities - - - - - Cash Provided (used) by Operations
Bank Loan 201,796 159,579 159,579 159,579 159,579 Net Income 229,013 - - -
Total Current Liabilities 246,421 212,865 159,579 159,579 159,579 Plus Depreciation 87,221 - - -
Long Term Liabilities - - - - - Change in Working Capital
Total Liabilities 246,421 212,865 159,579 159,579 159,579 Decrease (increase) in Receivables (3,150) 35,525 - -
Decrease (increase) in Inventory (12,687) 143,937 - -
Shareholder's Equity Increase (decrease) in Accts. Payable 8,661 (53,286) - -
Member's Equity 150,000 150,000 150,000 150,000 150,000 Increase (decrease) in Accrued Liabilities - - - -
Retained Earnings 68,335 122,348 122,348 122,348 122,348 Cash Provided (used) by Operations 309,058