Historical and Projected Financial Statements
Name of your Business ABRAAR DAIRY FARMING
Your Name MOHAMUD OSMAN ABDULLAHI
Your Email Address mohamud.qalas@gmail.com
Current Month January
Current Year 2020
ANNUAL INCOME STATEMENT
2019-2020
Revenue: 2019 2020
Sales Revenue (milk sales revenue) $20,000.00 $32,400.00
Other Revenue $0.00 $0.00
Total Revenue: $20,000.00 $32,400.00
Expenses:
Water for the camel $3,500.00 $2,250.00
Salaries & Wages $2,400.00 $2,400.00
Food/Caysh expenses for the camel $3,000.00 $2,250.00
Maintenance & Repairs for the car/vehicle $1,200.00 $800.00
Marketing/Advertising $0.00 $0.00
Medical expenses for the camel $800.00 $500.00
Fuel expenses $1,200.00 $824.00
Utilities $0.00 $0.00
Insurance $0.00 $0.00
License & Fees $0.00 $0.00
Legal $0.00 $0.00
Tax $0.00 $0.00
Other $0.00 $0.00
Other $0.00 $0.00
Other $0.00 $0.00
Total Expense: $12,100.00 $9,024.00
Net Income: $7,900.00 $23,376.00
BALANCE SHEET
2019 2020
Assets: 2019 31/12/2020
Current Assets:
Cash $20,000.00 $32,400.00
Account Receivable $0.00 $0.00
Property-Toyota 4 wheel drive $0.00 $0.00
Total Current Assets $20,000.00 $32,400.00
Fixed Assets:
Property-camel $18,200.00 $25,200.00
Property-probox car $3,500.00 $2,890.00
Total Fixed Assets $21,700.00 $28,090.00
Total Assets: $41,700.00 $60,490.00
Liabilities:
Current Liabilities:
Accounts Payable $2,500.00 $3,000.00
Other $1,500.00 $2,500.00
Total Current Liabilities $4,000.00 $5,500.00
Long-Term Liabilities:
Bank Notes $0.00 $0.00
Other $0.00 $0.00
Total Long-Term Liabilities $0.00 $0.00
Total Liabilities: $4,000.00 $5,500.00
Total Owner's Equity: $37,700.00 $54,990.00
Total Liabilities and Owner's Equity: $41,700.00 $60,490.00
Balance Sheet Check: Verified
Instructions: PROJECTED
Enter the amount of cash your business had at the end of the previous Previous month end cash $5,000.00
month in C3. The amount will be verified with bank statements. Januar
Year 2020
January February March April
1. CASH ON HAND
(a) Beginning of Month $2,000.00 $2,500.00 $2,000.00 $2,700.00
Enter any cash you will add to the business not already included in C3 (b) Owner's Contribution $500.00
2. CASH RECEIPTS
Enter cash sales for each month (a) Cash Sales $2,700.00 $2,700.00 $2,700.00 $2,700.00
Enter any investments or loans that will add cash to your business (including (b) Investment or Loans
current and proposed)
(c) other
Add other cash inflows and describe in B13 and B14
(d) Sales of Young male camels $1,400.00
3. TOTAL CASH RECEIPTS
(Add line 2a through 2d) $4,100.00 $2,700.00 $2,700.00 $2,700.00
4. TOTAL CASH AVAILABLE
(Before Cash Out) (1+3) $6,600.00 $5,200.00 $4,700.00 $5,400.00
5. CASH PAID OUT
(a) Wages $200.00 $200.00 $200.00 $200.00
(b) Food/Caysh expenses for the camel $250.00 $250.00 $250.00 $250.00
(c) Maint & Repairs for the car/vehicle $100.00 $100.00 $100.00 $100.00
(d) Marketing/Advertising $0.00 $0.00 $0.00 $0.00
(e) Medical expenses for the camel $66.67 $66.67 $66.67 $66.67
(f) Fuel expenses-car/vehicle/caterpilar $100.00 $100.00 $100.00 $100.00
(g) Utilities for milk shops $0.00 $0.00 $0.00 $0.00
(h)
Add cash expenses as you project they will occur. Make sure to show
seasonal and monthly variation. Input the names of your expenses in (i)
column B to reflect your business expenses (fuel cost, salary, maintenance, (j)
rent, taxes, etc.).
(k)
(l)
(m)
(n)
(o)
(p)
(q)
(r)
(s)
Add any additional expenses here and add description
(t)
6. TOTAL CASH PAID OUT
(total 5a through 5t) $716.67 $716.67 $716.67 $716.67
7. CASH POSITION (end of month)
(line 4 minus line 6) $5,883.33 $4,483.33 $3,983.33 $4,683.33
Include any fixed assets the company will purchase including with the
proceeds of a loan or investment. 8. Capital Purchases
9. Owner's Draw
Include any loan payments from current loans 10. Existing Loan Payments
Include loan payemnts for any loans you have or are applying for 11. Applied for Loan Payments $0.00 $0.00 $0.00 $0.00
12. ENDING CASH
(line 7 minus lines 8 to 11) $5,883.33 $4,483.33 $3,983.33 $4,683.33
ECTED CASH FLOW STATEMENT
January 2020 to December 2020
May June July August September October November December Year Total
$3,500.00 $2,890.00 $2,890.00 $2,890.00 $2,890.00 $2,890.00 $2,890.00 $18.00 $5,000.00
$500.00
$2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $32,400.00
$0.00
$0.00
$1,400.00
$2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $33,800.00
$6,200.00 $5,590.00 $5,590.00 $5,590.00 $5,590.00 $5,590.00 $5,590.00 $2,718.00 $39,300.00
$200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $200.00 $2,400.00
$250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $250.00 $3,000.00
$100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $1,200.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$66.67 $66.67 $66.67 $66.67 $66.67 $66.67 $66.67 $66.67 $800.00
$100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $1,200.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$716.67 $716.67 $716.67 $716.67 $716.67 $716.67 $716.67 $716.67 $8,600.00
$5,483.33 $4,873.33 $4,873.33 $4,873.33 $4,873.33 $4,873.33 $4,873.33 $2,001.33 $30,700.00
$0.00
$0.00
$0.00
$0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
$5,483.33 $4,873.33 $4,873.33 $4,873.33 $4,873.33 $4,873.33 $4,873.33 $2,001.33 $30,700.00
PROJECTED CASH FLOW STATEMENT
January 2021 to June 2020
January February March April May June July August
1. CASH ON HAND
(a) Beginning of Month $2,700.00 $3,700.00 $4,700.00 $5,700.00 $5,700.00 $5,700.00
(b) Owner's Contribution $0.00
2. CASH RECEIPTS
(a) Cash sales $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,850.00
(b) Investment or Loans
(c) other $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
(d) Sales of Young male camels
3. TOTAL CASH RECEIPTS
(Add line 2a through 2d) $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,700.00 $2,850.00
4. TOTAL CASH AVAILABLE
(Before Cash Out) (1+3) $5,400.00 $6,400.00 $7,400.00 $8,400.00 $8,400.00 $8,550.00
5. CASH PAID OUT
(a) Wages $400.00 $400.00 $400.00 $400.00 $400.00 $400.00
(b) Food/Caysh expenses for the camel $375.00 $375.00 $375.00 $375.00 $375.00 $375.00
(c) Maint & Repairs for the car/vehicle $133.33 $133.33 $133.33 $133.33 $133.33 $133.33
(d) Marketing/Advertising $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
(e) Medical expenses for the camel $83.33 $83.33 $83.33 $83.33 $83.33 $83.34
(f) Fuel expenses-car/vehicle/caterpilar $137.33 $137.33 $137.33 $137.33 $137.33 $137.33
(g) Utilities for milk shops
(h)
(i)
(j)
(k)
(l)
(m)
(n)
(o)
(p)
(q)
(r)
(s)
(t)
6. TOTAL CASH PAID OUT
(total 5a through 5t) $1,128.99 $1,128.99 $1,128.99 $1,128.99 $1,128.99 $1,129.00 $0.00 $0.00
7. CASH POSITION (end of month)
(line 4 minus line 6) $4,271.01 $5,271.01 $6,271.01 $7,271.01 $7,271.01 $7,421.00 $0.00 $0.00
8. Capital Purchases
9. Owner's Draw
10. Existing Loan Payments
11. Applied for Loan Payments $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
12. ENDING CASH
(line 7 minus lines 8 to 11) $4,271.01 $5,271.01 $6,271.01 $7,271.01 $7,271.01 $7,421.00 $0.00 $0.00
September October November December Year Total
$2,700.00
$0.00
$16,350.00
$0.00
$0.00
$0.00
$16,350.00
$19,050.00
$2,400.00
$2,250.00
$799.98
$0.00
$499.99
$823.98
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00 $0.00 $0.00 $0.00 $6,773.95
$0.00 $0.00 $0.00 $0.00 $12,276.05
$0.00
$0.00
$0.00
$0.00 $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00 $12,276.05