Year 1 Year 2 Year 3 Less

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

CaShake

Income Statement
For the Year Ended December 31, 2018-2020

Year 1 Year 2 Year 3


Sales 1,050,000.00 1,155,000.00 1,270,500.00
Less
Beginning Inventory 14,700 30,870.00 48,657.00
Purchases 161,700.00 177,870.00 195,657.00
Goods Available for Sale 161,700.00 176,400.00 208,740.00
Cost of Goods Sold (14%) 147,000.00 161,700.00 177,870.00
Gross Profit 903,000.00 993,300.00 1,092,630.00

Operating Expense
Salaries 296,400.00 296,400.00 296,400.00
Utilities 12,000.00 12,000.00 12,000.00
Supplies 14,400.00 14,400.00 14,400.00
Promotion and Advertising 12,000.00 12,000.00 12,000.00
Legal Expense 6,500.00 6,500.00 6,500.00
Rent Expense 132,000.00 132,000.00 132,000.00
Depreciation 8,240.00 8,240.00 8,240.00
Total Operating Expense 481,540.00 481,540.00 481,540.00

Net Income 421,460.00 511,760.00 611,090.00


Income Tax (10%) 42,146.00 51,176.00 61,109.00
Net Income after Tax 379,314.00 460,584.00 549,981.00
Start up

Expenses

Salaries 24,700.00
Utilities 1,000.00

Supplies 1,200.00
Promotion and Advertising 1,000.00
Legal Expense 541.67
Rent Expense 11,000.00
Total start up expenses 39,441.67

Start up Asset

Machinery and Equipment 6,720.00


Fixture 18,000.00
Total start up Asset 24,720.00

Total Funding Required 64,161.67


CaShake
Cash Flow
For the Year Ended December 31,2018-2020
Year 1 Year 2 Year 3
Cash Flow from Operating Activities
Cash Sales 1,050,000.00 1,155,000.00 1,270,500.00
Purchases - 161,700.00 - 177,870.00 - 195,657.00
Salaries - 296,400.00 - 296,400.00 - 296,400.00
Utilities - 12,000.00 - 12,000.00 - 12,000.00
Rent Expense - 132,000.00 - 132,000.00 - 132,000.00
Supplies - 14,400.00 - 14,400.00 - 14,400.00
Promotion and Advertising - 12,000.00 - 12,000.00 - 12,000.00
Legal Expense - 6,500.00 - 6,500.00 - 6,500.00

Tax Expense - 42,146.00 - 51,176.00 - 61,109.00


Net Cash from Operating Activities 372,854.00 452,654.00 540,434.00

Cash Flow from Investing Activities


Machinery and Equipment - 6,720.00
Fixture - 18,000.00
Net Cash from Investing Activities - 24,720.00

Cash Flow from Financing Activities

Net Cash Flow 348,134.00 452,654.00 540,434.00


Beginning Cash Balance 64,161.67 412,295.67 864,949.67
Ending Cash Balance 412,295.67 864,949.67 1,405,383.67
CaShake
Balance Sheet
As of December 31, 2018-2020

Year 1 Year 2 Year 3


ASSET
Current Asset
Cash 412,295.67 864,949.67 1,405,383.67
Inventory 14,700.00 30,870.00 48,657.00
Total Current Asset 426,995.67 895,819.67 1,454,040.67

Non-Current Asset
Machinery and Equipment 6,720.00 6,720.00 6,720.00
Less: Depreciation - 2,240.00 - 4,480.00 - 6,720.00
Fixture 18,000.00 18,000.00 18,000.00
Less: Depreciation - 6,000.00 - 12,000.00 - 18,000.00
Total Non-Current Asset 16,480.00 8,240.00 -
Total Asset 443,475.67 904,059.67 1,454,040.67

CAPITAL 443,475.67 904,059.67 1,454,040.67


Fry away sweetie churros
Changes in owner's equity
Year 1 Year 2 Year 3
Beginning Capital 64,161.67 443,475.67 904,059.67
Add: Net Income 379,314.00 460,584.00 549,981.00
Total 443,475.67 904,059.67 1,454,040.67
Ending Capital 443,475.67
Total Fixed Cost 481,540.00
SP 105.00
Variable cost/unit 14.70

Total fixed cost 481,540.00


Selling price 35.00
Variable cost/unit 4.90

You might also like