Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

My Cash in bank b/f is R 100 000 , how do I calculate from March going forward to February the next year CASH FLOW

My Cash in bank b/f is R 100 000 , how do I calculate from March going forward to February the next year

image text in transcribed

CASH FLOW STATEMENT FOR THE FINANCIAL YEAR \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline & Mar-23 & Apr-23 & May-23 & Jun-23 & Jui-23 & Aug-23 & Sep-23 & Oct-23 & Now-23 & Dec-23 & San24 & Feb-24 \\ \hline \multicolumn{13}{|l|}{ income } \\ \hline Room Revenue & R 50000,00 & R 50000,00 & R 68000,00 & R 40000,00 & R 40000,00 & \begin{tabular}{|l|} R. 44000,00 \\ \end{tabular} & R. 60000,00 & R. 68000,00 & R. 90000,00 & R 150000,00 & \begin{tabular}{|l|} R 90000,00 \\ \end{tabular} & R. 50000,00 \\ \hline Breakfast flevenue & A 11000,00 & \begin{tabular}{|l|} . 12000,00 \\ \end{tabular} & R 14000,00 & R 8000,00 & R 7000,00 & R 9500,00 & R 13000,00 & R 14000,00 & \begin{tabular}{|lll|} R & 16 & 000,00 \\ \end{tabular} & \begin{tabular}{|l|l|} R & 17500,00 \\ \end{tabular} & \begin{tabular}{|ll|} A & 16,000,00 \\ \end{tabular} & R. 12,000,00 \\ \hline Laundry fees & R 3500,00 & \begin{tabular}{ll} R 3000,00 \\ \end{tabular} & R 4000,00 & \begin{tabular}{|ll|} R & 2500,00 \\ \end{tabular} & R. 1500,00 & R. 2000,00 & \begin{tabular}{ll} R & 4,000,00 \\ \end{tabular} & R. 5500,00 & \begin{tabular}{|ll|} R & 6500,00 \\ \end{tabular} & R. 8500,00 & \begin{tabular}{ll|} R & 7000,00 \\ \end{tabular} & \begin{tabular}{ll} R 2000,00 \\ \end{tabular} \\ \hline Total income & R. 64,500,00 & \begin{tabular}{|l|} R. 65,000,00 \\ \end{tabular} & R. 86000,00 & R 50,500,00 & R. 48500,00 & R 55500,00 & 77000,00 & A 87500,00 & R.112500,90 & A 1760000,00 & Af 113000,00 & R. 64000,00 \\ \hline \multicolumn{13}{|l|}{ Expenditure } \\ \hline Cost of Goods & R 35000,00 & 20000,00 & A 30000,00 & R. 15000,00 & R. 2.5000,00 & 8 25,000,00 & R 30000,00 & A. 25,000,00 & R 20000,00 & A. 25000,00 & A 25000,00 & 8.25,000,00 \\ \hline Advetising & R 12500,00 & H & A & \begin{tabular}{|c|} R 12500,00 \\ \end{tabular} & R & R & R 12500,00 & R & R & \begin{tabular}{lll} R & 12500,00 \\ \end{tabular} & R & R \\ \hline insurance & R 3000,00 & R 3000,00 & A 3,000,00 & \begin{tabular}{|ll|} R & 3000,00 \\ \end{tabular} & R. 3000,00 & A. 3000,00 & R 3000,00 & A. 3000,00 & 3000,00 & A. 3000,00 & 3000,00 & \begin{tabular}{ll} R 3000,00 \\ \end{tabular} \\ \hline Bent & R 8000,00 & \begin{tabular}{|l|l|} A & 8000,00 \\ \end{tabular} & A 8000,00 . & R 8000,00 & R. 8.000,00 & A 8000,00 & is 8000,00 & A. 8000,00 & 8000,00 & A. 8000,00 & 8000,00 & R 8000,00 \\ \hline Electricity & \begin{tabular}{|l|l|} R & 3000,00 \\ \end{tabular} & \begin{tabular}{ll} R & 3000,00 \\ \end{tabular} & R 3000,00 & \begin{tabular}{|cc|} R & 3000,00 \\ \end{tabular} & R 3000,00 & A 3000,00 & R 3000,00 & R 3000,00 & R. 3,000,00 & R 3000,00 . & \begin{tabular}{|ll|} R & 3000,00 \\ \end{tabular} & \begin{tabular}{|l|l|} R 3000,00 \\ \end{tabular} \\ \hline Salarles and wages & R 20000,00 & . 20000,00 & R. 20000,00 & \begin{tabular}{|c|} R 20000,00 \\ \end{tabular} & R. 20.000,00 & A. 20000,00 & R 20000,00 & Af 20000,00 & \begin{tabular}{|ll|} R & 20000,00 \\ \end{tabular} & A. 20000,00 & \begin{tabular}{|l|l|} in 20000,00 \\ \end{tabular} & A 20000,00 \\ \hline Telephone and internet & R 5000,00 & A 5000,00 & R 5000,00 & R. 5000,00 & R. 5000,00 & R. 5000,00 & R 5000,00 & R. 5.000,00 & \begin{tabular}{|lr|} R & S000,00 \\ \end{tabular} & R. 5000,00 & \begin{tabular}{|ll|} R & 5,000,00 \\ \end{tabular} & R 5000,00 \\ \hline Fotal Expenses & R86500,00 & 9.59000,00 & A 69000,00 & R. 66500,00 & A 64000,00 & R 64000,00 & R. 81500,00 & R. 64000,00 & R: 59000,00 & B 26.500,00 & A 64000,00 & R 64000,00 \\ \hline \multicolumn{13}{|l|}{ Cash in bank b/f } \\ \hline Is Total income & R. 64500,00 & . 65000,00 & R. 86000,00 & \begin{tabular}{|l|} R. 50,500,00 \\ \end{tabular} & R. 48500,00 & R. 55.500,00 & R77000,00 & A. 87.500,00 & R. 112500,00 & R. 176,000,00 & R 113,000,00 & \begin{tabular}{l} R. 64.000,00 \\ \end{tabular} \\ \hline Total Expenditure & \begin{tabular}{|l|} R 86500,00 \\ \end{tabular} & R. 59.000,00 & Af 69000,00 & R 66500,00 & R 64000,00 & R. 64000,00 & R.81500,00 & R 64000,00 & & \begin{tabular}{|ll|} R & 76500,00 \\ \end{tabular} & \begin{tabular}{|l|} R. 64000,00 \\ \end{tabular} & \begin{tabular}{|l|} R 64000,00 \\ \end{tabular} \\ \hline ain bank c/f & & & & & & & & & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Future Of Audit Keeping Capital Markets Efficient

Authors: Keith Houghton, Christine Jubb, Michael Kend, Juliana Ng

1st Edition

1921666501, 978-1921666506

More Books

Students also viewed these Accounting questions

Question

Choose an appropriate organizational pattern for your speech

Answered: 1 week ago

Question

Writing a Strong Conclusion

Answered: 1 week ago