[go: up one dir, main page]

0% found this document useful (0 votes)
95 views13 pages

Abraar Dairy and Farming Financial Template-1

The document contains historical and projected financial statements for Abraar Dairy Farming from 2019 to 2020, including an income statement showing increased revenue and profits from 2019 to projected 2020 figures, and a balance sheet displaying increased assets and owner's equity from 2019 to projected end of year 2020 figures. The document also includes a projected cash flow statement outlining expected monthly cash positions from January to April 2020.

Uploaded by

Ganacsi Kaab
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
95 views13 pages

Abraar Dairy and Farming Financial Template-1

The document contains historical and projected financial statements for Abraar Dairy Farming from 2019 to 2020, including an income statement showing increased revenue and profits from 2019 to projected 2020 figures, and a balance sheet displaying increased assets and owner's equity from 2019 to projected end of year 2020 figures. The document also includes a projected cash flow statement outlining expected monthly cash positions from January to April 2020.

Uploaded by

Ganacsi Kaab
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 13

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

You might also like