The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 402 Weeks Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
I am having the worst time: I need to build a four year projected balance sheet. I've already done my four year profit projection and was wondering if someone could help me with the balance sheet. I did year one, can't go any further: Below is the four year profit projection: Four Year Profit Projection 2010 % 2011 % 2012 % 2013 % Sales $240,000 100.00% $417,000 100.00% $480,000 100.00% $604,000 100.00% Cost/ Goods Sold (COGS) 46,000 19.17% 52,000 12.47% 75,000 15.63% 116,000 19.21% Gross Profit $194,000 80.83% $365,000 87.53% $405,000 84.38% $488,000 80.79% Operating Expenses Salary (Office & Overhead) $50,000 20.83% $52,000 12.47% $55,000 11.46% $60,000 9.93% Payroll (taxes etc.) 13,000 5.42% 15,600 3.74% 15,600 3.25% 16,000 2.65% Outside Services - 0.00% - 0.00% - 0.00% - 0.00% Supplies (off and operation) 22,800 9.50% 26,000 6.24% 32,000 6.67% 38,000 6.29% Repairs/ Maintenance - 0.00% - 0.00% - 0.00% - 0.00% Advertising 1,500 0.63% 1,500 0.36% 1,200 0.25% 1,000 0.17% Car, Delivery and Travel - 0.00% - 0.00% - 0.00% - 0.00% Accounting and Legal 3,500 1.46% 3,000 0.72% 2,500 0.52% 2,000 0.33% Rent 60,000 25.00% 60,000 14.39% 60,000 12.50% 60,000 9.93% Telephone 300 0.13% 300 0.07% 300 0.06% 300 0.05% Utilities 10,000 4.17% 14,000 3.36% 17,000 3.54% 20,000 3.31% Insurance 12,000 5.00% 12,000 2.88% 12,000 2.50% 12,000 1.99% Taxes (real estate etc.) 7,500 3.13% 7,500 1.80% 7,500 1.56% 7,500 1.24% Interest 2,500 1.04% 2,500 0.60% 2,500 0.52% 2,500 0.41% Depreciation - 0.00% - 0.00% - 0.00% - 0.00% Supplemental Equipment 2,500 1.04% 5,000 1.20% 3,000 0.63% 5,000 0.83% Other expense (specify) - 0.00% - 0.00% - 0.00% - 0.00% Total Expenses $185,600 77.33% $199,400 47.82% $208,600 43.46% $224,300 37.14% Net Profit Before Tax 8,400 165,600 196,400 263,700 Income Taxes 2,097 33,120 38,800 52,740 Net Profit After Tax 6,303 132,480 157,600 210,960 Owner Draw/ Dividends - - - - Adj. to Retained Earnings $4,206 $132,480 $157,600 $210,960
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll