Select Statements To DisplayIncome Statement «»
Cash Flow Statement «»
Balance Sheet «»
Breakeven Analysis «»
3-Year Income Statement
Breakeven Analysis » FW Inc.
Income Statement » FW Inc.
Period Ending Dec 2021 | Currency (AED)
Revenue
Sales
1,800,000.00
Less COGS
1,080,000.00
Gross Profit
720,000.00
Expenses
Salaries
360,000.00
Rent
120,000.00
Utilities
24,000.00
Legal
0.00
Advertising
36,000.00
Supplies
12,000.00
Interest
18,000.00
Depreciation
30,500.00
Total Expenses
600,500.00
Net Income
119,500.00
3-Year Income Statement » FW Inc.
Period Ending Dec 2021 | Currency (AED)
Revenue
Year 1
Year 2
Change
Year 3
Change
Sales
1,800,000.00
2,268,000.00
26.00%
3,118,500.00
37.50%
Less COGS
1,080,000.00
1,386,720.00
28.40%
1,872,072.00
35.00%
Gross Profit
720,000.00
881,280.00
22.40%
1,246,428.00
41.43%
Expenses
Salaries
360,000.00
388,800.00
8.00%
435,456.00
12.00%
Rent
120,000.00
129,600.00
8.00%
145,152.00
12.00%
Utilities
24,000.00
25,920.00
8.00%
29,030.40
12.00%
Legal
0.00
0.00
0%
0.00
0%
Advertising
36,000.00
38,880.00
8.00%
43,545.60
12.00%
Supplies
12,000.00
12,960.00
8.00%
14,515.20
12.00%
Interest
18,000.00
19,440.00
8.00%
21,772.80
12.00%
Depreciation
30,500.00
32,940.00
8.00%
36,892.80
12.00%
Total Expenses
600,500.00
648,540.00
8.00%
726,364.80
12.00%
Net Income
119,500.00
232,740.00
94.76%
520,063.20
123.45%
Cash Flow Projection » FW Inc.
Period Ending Dec 2021 | Currency (AED)
Beginning
Jan-21
Feb-21
Mar-21
Apr-21
May-21
Jun-21
Jul-21
Aug-21
Sep-21
Oct-21
Nov-21
Dec-21
Cash on Hand (BOM)
---
125,000
142,900
159,840
171,680
133,120
109,260
80,300
55,300
39,360
28,520
68,080
92,940
---
Cash In (Receipts)
Capital In
50,000
---
---
---
---
---
---
---
---
---
---
---
---
50,000
Borrowed Funds
180,000
---
---
---
---
---
---
---
---
---
---
---
---
180,000
Revenues
Current Month (70%)
---
157,500
147,000
136,500
73,500
63,000
52,500
52,500
63,000
73,500
136,500
147,000
157,500
1,260,000
Previous Month (30%)
---
0
63,000
58,500
31,500
27,000
22,500
22,500
27,000
31,500
58,500
63,000
67,500
472,500
Total Cash In
230,000
157,500
210,000
195,000
90,000
75,000
75,000
90,000
105,000
195,000
210,000
225,000
1,962,500
Cash Out (Disbursments)
Salaries
---
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
30,000
360,000
Rent
---
10,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
10,000
120,000
Utilities
---
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
2,000
24,000
Legal
---
0
0
0
0
0
0
0
0
0
0
0
0
0
Advertising
---
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
36,000
Supplies
---
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
1,000
12,000
Interest
---
1,500
1,500
1,500
1,500
1,500
1,500
1,500
1,500
1,500
1,500
1,500
1,500
18,000
Loan Payback
---
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
3,000
36,000
Product Purchases
Current Month (60%)
---
89,100
83,160
77,220
41,580
35,640
29,700
29,700
35,640
41,580
77,220
83,160
89,100
712,800
Previous Month (40%)
---
0
59,400
55,440
51,480
27,720
23,760
19,800
19,800
23,760
27,720
51,480
55,440
415,800
Capital Purchases
Computers
5,000
---
---
---
---
---
---
---
---
---
---
---
---
5,000
Furniture
40,000
---
---
---
---
---
---
---
---
---
---
---
---
40,000
Equipment
60,000
---
---
---
---
---
---
---
---
---
---
---
---
60,000
Total Cash Out
105,000
139,600
193,060
183,160
143,560
113,860
103,960
100,000
105,940
115,840
155,440
185,140
195,040
1,839,600
Cash on Hand (EOM)
125,000
142,900
159,840
171,680
133,120
109,260
80,300
55,300
39,360
28,520
68,080
92,940
122,900
---
Balance Sheet » FW Inc.
As on Dec 2021 | Currency (AED)
Assets
Cash on Hand
122,900
Accounts Receivables
67,500
Inventories
108,000
Computers
5,000
Less: Accumulated Depreciation
2,500
2,500
Furniture
40,000
Less: Accumulated Depreciation
8,000
32,000
Equipment
60,000
Less: Accumulated Depreciation
20,000
40,000
Total Assets
372,900
Liabilities
Loans
144,000
Accounts Payable
35,640
Owner's Equity
50,000
Accumulated Earnings
---
Add: Current Period Earnings
119,500
119,500
Total Liabilities & Equity
372,900