Scribd
Upload
8 views7 pages

Monthly Cash Flow and Lending Summary

The document shows cash flow statements for a business from July to March. It tracks opening and closing balances each month, as well as money in (owner's capital, income), and money out (expenses like loan repayments, equipment, wages, stationery). The business received an initial owner's capital of PHP 200,000 in July. While expenses were high in the first few months as the business got started, by March the closing balance was PHP 16,800. A second table provides details on loans to various individuals, including amounts loaned and interest rates. The business earned a total of PHP 262,953.67 from lending and fees over the period shown.

Uploaded by

IanIan
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
8 views7 pages

Monthly Cash Flow and Lending Summary

The document shows cash flow statements for a business from July to March. It tracks opening and closing balances each month, as well as money in (owner's capital, income), and money out (expenses like loan repayments, equipment, wages, stationery). The business received an initial owner's capital of PHP 200,000 in July. While expenses were high in the first few months as the business got started, by March the closing balance was PHP 16,800. A second table provides details on loans to various individuals, including amounts loaned and interest rates. The business earned a total of PHP 262,953.67 from lending and fees over the period shown.

Uploaded by

IanIan
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

July August September October

Opening Balance Php - Php 32,000.00 Php 32,000.00 Php 37,000.00

Money In
Owner's Capital Php 200,000.00
Income Php - Php 8,000.00 Php 8,000.00 Php 8,000.00

Other Php - Php - Php - Php -


Total Money In Php 200,000.00 Php 8,000.00 Php 8,000.00 Php 8,000.00

Money Out

Loan Repayment

Money spent Php 15,000.00 Php 5,000.00 Php 5,000.00


Equipments Php 150,000.00
Space Rental Php - Php - Php - Php -
WAGES Php - Php - Php - Php -

Stationery Php 3,000.00 Php 3,000.00 Php 3,000.00 Php 3,000.00

Total Money Out Php 168,000.00 Php 8,000.00 Php 3,000.00 Php 8,000.00

Closing Balance Php 32,000.00 Php 32,000.00 Php 37,000.00 Php 37,000.00
CASH FLOW
PRACTICE FLOW
November December January February March
Php 37,000.00 Php 42,000.00 Php 47,000.00 Php - Php -

Php 8,000.00 Php 8,000.00 Php - Php - Php -

Php - Php - Php - Php - Php -


Php 8,000.00 Php 8,000.00 Php - Php - Php -

Php 5,000.00 Php 5,000.00

Php - Php - Php - Php - Php -


Php - Php - Php - Php - Php -

Php 3,000.00 Php 3,000.00 Php 3,000.00 Php 3,000.00 Php 3,000.00

Php 3,000.00 Php 3,000.00 Php 8,000.00 Php 3,000.00 Php 8,000.00

Php 42,000.00 Php 47,000.00 Php 39,000.00 Php (3,000.00) Php (8,000.00)
April May June
Php - Php - Php -

Php - Php - Php -

Php - Php - Php -


Php - Php - Php -

Php 5,000.00

Php - Php - Php -


Php - Php - Php -

Php 3,000.00 Php 3,000.00 Php 3,000.00

Php 3,000.00 Php 3,000.00 Php 8,000.00

Php (3,000.00) Php (3,000.00) Php (8,000.00)


12 Amount LOANED Interest DEDUCTIBLE
Rate
Php 0.24

Mr. A Php 500.00 Php 120.00


Mr. B Php 1,000.00 Php 240.00
Mr. C Php 800.00 Php 192.00
Mr. D Php 600.00 Php 144.00
Mr. E Php 200.00 Php 48.00
Mr. F Php 199,000.00 Php 47,760.00
Mr. G Php 300.00 Php 72.00
Mr. H Php 400.00 Php 96.00
Mr. I Php 500.00 Php 120.00
Mr. J Php 200.00 Php 48.00
Mr. K Php 300.00 Php 72.00
Total Amount OUT Php 203,800.00 Php 48,912.00

ACTUAL OUT
Total Lending Amount Php 154,888.00

ACTUAL IN
Total Interest Received Php 48,912.00
Total Fees Received Php 11,500.00
Total Monthly Receivables Php 202,541.67
Total Php 262,953.67
FEES 14-Apr 14-May 14-Jun 14-Jul

Php 380.00 Php 150.00 Php 41.67 Php 41.67 Php - Php -
Php 760.00 Php 150.00 Php 83.33 Php 83.33 Php 83.33 Php 83.33
Php 608.00 Php 150.00 Php 66.67 Php 66.67 Php 66.67 Php 66.67
Php 456.00 Php 150.00 Php 50.00 Php 50.00 Php 50.00 Php 50.00
Php 152.00 Php 150.00 Php 16.67 Php 16.67 Php 16.67 Php -
Php 151,240.00 Php 10,000.00 Php 16,583.33 Php 16,583.33 Php 16,583.33 Php 16,583.33
Php 228.00 Php 150.00 Php 25.00 Php 25.00 Php 25.00 Php 25.00
Php 304.00 Php 150.00 Php 33.33 Php 33.33 Php 33.33 Php 33.33
Php 380.00 Php 150.00 Php 41.67 Php 41.67 Php 41.67 Php 41.67
Php 152.00 Php 150.00 Php 16.67 Php 16.67 Php 16.67 Php 16.67
Php 228.00 Php 150.00 Php 25.00 Php 25.00 Php 25.00 Php 25.00
Php 154,888.00 Php 11,500.00 Php 16,983.33 Php 16,983.33 Php 16,941.67 Php 16,925.00
14-Aug 14-Sep 14-Oct 14-Nov 14-Dec 14-Jan

Php - Php - Php - Php - Php - Php -


Php 83.33 Php 83.33 Php 83.33 Php 83.33 Php 83.33 Php 83.33
Php 66.67 Php 66.67 Php 66.67 Php - Php - Php -
Php 50.00 Php 50.00 Php 50.00 Php 50.00 Php 50.00 Php 50.00
Php - Php - Php - Php - Php - Php -
Php 16,583.33 Php 16,583.33 Php 16,583.33 Php 16,583.33 Php 16,583.33 Php 16,583.33
Php 25.00 Php 25.00 Php 25.00 Php 25.00 Php 25.00 Php 25.00
Php 33.33 Php - Php - Php - Php - Php -
Php 41.67 Php 41.67 Php 41.67 Php 41.67 Php 41.67 Php 41.67
Php 16.67 Php 16.67 Php 16.67 Php 16.67 Php 16.67 Php 16.67
Php 25.00 Php 25.00 Php 25.00 Php - Php - Php -
Php 16,925.00 Php 16,891.67 Php 16,891.67 Php 16,800.00 Php 16,800.00 Php 16,800.00
14-Feb 15-Mar

Php - Php -
Php 83.33 Php 83.33
Php - Php -
Php 50.00 Php 50.00
Php - Php -
Php 16,583.33 Php 16,583.33
Php 25.00 Php 25.00
Php - Php -
Php 41.67 Php 41.67
Php 16.67 Php 16.67
Php - Php -
Php 16,800.00 Php 16,800.00

You might also like