This is my financial statement from my business plan (class assignment). I struggle with accounting, do my charts flow and make sense numerical wise? I have a hard time making sense of the different statements. Please help me change my numbers around so my charts make sense individually and together.
F15 Pro Forma Balance Sheet Year 1 Year 2 Year 3 3 Assets 4 Cash 5 Inventory 80,000 80,000 80,000 20,000 30,000 40,000 6 Other Current Assets 1000 1000 1000! 101,000 111,000 121000 8 Total Current Asset 9 10 Short term assets 11 Building and Equipment 12 building 13 depreciation 14 equipment 15 total 16 Total assets 17 18 Current Liabilities 19 Accounts Payabie 20 salaries payble 21 9,368 93689368 70,000 70,000 70,000 30,000 30,000 30,000 2,000 2,000 2,000 42,000 42,000 42,000 143,000 153,000 163,000 10,056 9,738 11090 22 Total Liabilities 23 24 Owners Equity 25 35,000 40,000 50000 45,056 49,738 61,090 97,944 103,262 101,910 SheetlSheetsSheet2 Type here to search B18 1 Sources/Uses of Funds Statement Year 1Year 2 Year 3 3 Sources 4 Cash 5 Venture Capita 6 Total 80,000 80,000 80,000 20,000 30,000 30,000 100,000 110,000 110,000 8 Uses 9 Salaries 10 Rent 11 Advertisting 12 Supplies 13 insurance 14 Ultilities 30000 35000 10,000 40000 0 30004000 5000 600 6000 2500 2500 2500 500 6000 700 6000 19 1Sheet3 Format Painter BIU.AE Clipboard UPDATES AVAILABLE Font Updates for Office are ready to be installed, but first we D5 BC 1 Pro Forma Income Statement Year 1 Year 2 Year 3 100,000 120,000 150,000 40,000 40,000 50,000 3 Revenue 4 Cost of Goods Sold 6 Gross Margin 60,000 80,000 100,000 8 Other Expenses 9 Lawyer expense 10 Supplies expenses 11 Utilities expenses 12 insuarnce expenses 13 Total Expemses 800080008000 700 200020002000 6500 65006500 9,000 9,1009,200 500 600 15 Net Income 51,000 70,900 90,800 Sheet 1 Sheet2 F15 Pro Forma Balance Sheet Year 1 Year 2 Year 3 3 Assets 4 Cash 5 Inventory 80,000 80,000 80,000 20,000 30,000 40,000 6 Other Current Assets 1000 1000 1000! 101,000 111,000 121000 8 Total Current Asset 9 10 Short term assets 11 Building and Equipment 12 building 13 depreciation 14 equipment 15 total 16 Total assets 17 18 Current Liabilities 19 Accounts Payabie 20 salaries payble 21 9,368 93689368 70,000 70,000 70,000 30,000 30,000 30,000 2,000 2,000 2,000 42,000 42,000 42,000 143,000 153,000 163,000 10,056 9,738 11090 22 Total Liabilities 23 24 Owners Equity 25 35,000 40,000 50000 45,056 49,738 61,090 97,944 103,262 101,910 SheetlSheetsSheet2 Type here to search B18 1 Sources/Uses of Funds Statement Year 1Year 2 Year 3 3 Sources 4 Cash 5 Venture Capita 6 Total 80,000 80,000 80,000 20,000 30,000 30,000 100,000 110,000 110,000 8 Uses 9 Salaries 10 Rent 11 Advertisting 12 Supplies 13 insurance 14 Ultilities 30000 35000 10,000 40000 0 30004000 5000 600 6000 2500 2500 2500 500 6000 700 6000 19 1Sheet3 Format Painter BIU.AE Clipboard UPDATES AVAILABLE Font Updates for Office are ready to be installed, but first we D5 BC 1 Pro Forma Income Statement Year 1 Year 2 Year 3 100,000 120,000 150,000 40,000 40,000 50,000 3 Revenue 4 Cost of Goods Sold 6 Gross Margin 60,000 80,000 100,000 8 Other Expenses 9 Lawyer expense 10 Supplies expenses 11 Utilities expenses 12 insuarnce expenses 13 Total Expemses 800080008000 700 200020002000 6500 65006500 9,000 9,1009,200 500 600 15 Net Income 51,000 70,900 90,800 Sheet 1 Sheet2